Projects that are publicly funded typically require the contractor to pay a
prevailing wage rate for workers on the job. Then, for each payroll period, the
contractor must create a certified payroll report that shows the wages paid to
Following are the steps for creating a type of certified payroll report.
Because QuickBooks is not specifically set up to handle this type of report,
there are two drawbacks:
The report shows amounts paid to each employee; it does not show hours. If you absolutely require this information, you can create a time report that shows hours worked by an individual on a certain service item in a given time period.
The report represents all crafts. It is not possible to filter the report to represent a single craft.
Follow these steps for each worker.
Set up an Hourly Wage payroll item for prevailing wage jobs, called "Prevailing Wage Rate."
Go to the Employees menu and click Payroll Item List.
Click Payroll Item at the bottom of the list and click New.
In the Add new payroll item window, select Wage and click Next.
Follow the rest of the prompts and click Finish.
When you do payroll for an employee who is working on a prevailing wage job, enter the hours worked under "Prevailing Wage Rate," rather than under "Hourly Wage."
Go to the Reports menu, choose Employees & Payroll, and then click Payroll Summary to create a Payroll Summary report (one of the Payroll reports).
Modify the Payroll Summary report:
Click Customize Report at the top of the report.
Click the Display Columns by drop-down list and choose Day.
Click the Filters tab.
In the Filter scroll box, select Name. Click the Name drop-down list and choose the employee for which you're creating the report.
In the Filter scroll box, select Payroll Item. Click the Payroll Item drop-down list and choose Prevailing Wage Rate.
Select the Header/Footer tab. Change the Report Title to Certified Payroll Report.
Click Memorize to memorize the report for future use.
You can also create a QuickBooks report that provides all the information you need to fill in Box 1 (employee information) of your certified payroll reports.