Set up certified payroll reports in QuickBooks Online Payroll

To generate the federal certified payroll report (WH-347) in QuickBooks Online Payroll, you’ll need to first set up your project, pay schedules, and custom pay types.  This report is required when you work on publicly funded projects to report prevailing wages paid to your employees. 

Step 1: Set up and create a project in QuickBooks

You’ll need to set up a project in QuickBooks to run the certified payroll report. When adding your employee’s time to the project, use the weekly timesheets from + Create (don’t use the Time workflow from My Apps).  

Step 2: Set up a weekly pay schedule

Add all your employees working on the project to a weekly pay schedule. 

Step 3: Set up standard time and overtime for each job classification

If your employee has multiple job types on a project, you’ll need to create 2 custom hourly pay types for each job classification: standard time and overtime.  For example: Painter ST, Painter OT.  Note: When you set up custom overtime rates, you'll need to manually enter the Qualified Overtime tracking when you run payroll.

If your employee only has one job classification on the project, you can use the default overtime pay type. 

1. Go to All apps , then Payroll, then Employees (Take me there).
2. Select Edit payroll items. 
3. Select New pay item. 
4. Select Pay type. 
5. Select Hourly. 
6. In the name field, we recommend [Wage determination number and job classification] ST or OT (example: WD #CA20000 Carpenter-Industrial ST)
7. Select Save.
8. Select Assign employee(s). 
9. Select your employee, then Next. 
10. Enter the hourly rate.
11. Select Save. 
12. Repeat steps 2–11 for overtime and for any additional job classifications. 

Step 4: Add company-paid fringe benefits (optional)

If you want your company-paid fringe benefits like 401(k), health, dental, or other insurance to show on page 2 of your certified payroll report, you’ll want to set these up in QuickBooks. 

• Set up retirement
• Set up health insurance 

Related articles

• Create and review your certified payroll report in QuickBooks Online Payroll