Does QuickBooks Online do certified payroll?

On its upper tiers it downloads a certified payroll report as a spreadsheet. Intuit's help article (updated August 2026) says Premium and Elite; Intuit's Firm of the Future article (June 2026) says Workforce Elite only, after the May 2026 rename to Workforce Payroll, Premium and Elite. Confirm it on your plan. The report needs time entered on the QuickBooks weekly timesheet with a project on each line, and it leaves the header, entry numbers, apprentice status, cash in lieu of fringe and the signature to you.

Why does the QuickBooks report leave the wage determination number blank?

QuickBooks does not hold the determination. It reports what you paid; checking it against the determination and writing the number in the header is a separate step, which is what this app does when the report is imported.

The 2025 form changed. Is the QuickBooks report current?

Check that yours downloads in the January 2025 layout (separate name columns, basic rate alone in 6A, fringe split into plan and cash, the J or RA column). The CertifiedHours import reads either layout.

Your payroll system

Certified payroll in QuickBooks Online Payroll: the certified payroll report, and what it leaves blank

QuickBooks Online Payroll (renamed QuickBooks Workforce in May 2026) downloads a certified payroll report as a spreadsheet on its upper tiers, built from weekly timesheets by project. What the report fills, what it leaves for you, and how to finish it.

Checked against the sources below October 16, 2026. Menus move; if a step is off, tell us from the Help menu and it is fixed the same week.

The short answer

QuickBooks Online Payroll includes a certified payroll report on its upper tiers (Reports, then Standard reports, search for certified payroll, pick the pay period and project, Download spreadsheet). It fills hours, rates, classifications and deductions from your timesheets and payroll items; it leaves the project ID, wage determination number, payroll number, worker entry numbers, apprentice status, any cash paid in lieu of fringe (Intuit's article says to add it to 6B and adjust 7B and 9 by hand) and the signed statement to you. Intuit renamed the tiers Workforce Payroll, Premium and Elite in May 2026 (new pricing from July 1, 2026), and its pages differ on whether Premium has the report, so confirm it on your plan.

What QuickBooks Online Payroll gives you

On the upper tiers: a spreadsheet in the WH-347's layout for a pay period and a project, with standard and overtime hours by day, rates, classifications and deductions, when time was entered on the QuickBooks weekly timesheet with the project name.
Projects and job costing, so hours are tracked to the federal job separately from your other work.
Payroll items per classification, which is what the report reads.

What the WH-347 still needs

The header: project ID, wage determination number, certified payroll number.
Column 1A entry numbers, column 2 journeyworker or apprentice, and page 2 box 4 for apprentices.
Cash paid in lieu of fringe. Intuit's article lists it as a manual entry: add it to 6B and adjust 7B and 9 to match.
The Statement of Compliance signature, and any check that a rate meets the determination.
On the lowest tier (Workforce Payroll, formerly Core): the report itself. It exports payroll details without daily hours or classifications.

The export: Certified payroll report (upper tiers) or Payroll details (Workforce Payroll)

On a tier with the report: Reports, then Standard reports. Search for certified payroll report. Choose the pay period and the project. Download spreadsheet.
Save the spreadsheet as CSV (File, Save as, CSV) so the day columns come through as columns.
On Workforce Payroll (formerly Core): Reports, then Payroll details, for the pay period; export to Excel and save as CSV.

How each column lands on the form

The import matches columns by meaning, so the exact header can vary. It asks about anything it is unsure of before it fills the grid.

In QuickBooks Online Payroll	On the certified payroll
Name	Matched to the crew by name.
Work classification	Matched to the job's trades on the determination.
Hours by day	Straight time and overtime by day when the day columns are named (Sun, Mon, Tue…). Single-letter day headers are not recognised on their own; point them at the days in the mapping step.
Rate of pay	Column 6A.
Gross	Compared with rate × hours: equal sets the cash fringe to 0; a plausible excess becomes the cash fringe per hour; a gross far past that is kept as 7B. The import has no fringe column of its own.
Federal tax, Social Security, Medicare	Column 8, withheld and FICA.

Rates and classifications

Name the payroll items as the determination names the classifications, and enter time on the QuickBooks weekly timesheet, not the Time app workflow, with the project on every line. The report and the import both read those names.

Fringe

Cash in lieu of fringe does not reach the QuickBooks report on its own; Intuit's article has you add it to 6B by hand and adjust 7B and 9. If you pay it per hour through a payroll item, the gross on the report rises above rate × hours and the import sets the difference per hour as the cash fringe. Contributions you make to plans are not on the report; record the plan once and the hourly credit per line.

Every week

Enter time on the weekly timesheet by project and classification; run payroll weekly.
Download the certified payroll report spreadsheet for the week and project, save as CSV.
Import into the week in CertifiedHours; it reads the day columns, classifications and rates and adds the entry numbers, payroll number and determination.
Read the checks: each rate against the determination, fringe on every hour, 7B not under 7A, apprentices registered.
File and send. The signed statement prints on page 2 with the phone and email a reviewer wants.

Questions people ask

Does QuickBooks Online do certified payroll?: On its upper tiers it downloads a certified payroll report as a spreadsheet. Intuit's help article (updated August 2026) says Premium and Elite; Intuit's Firm of the Future article (June 2026) says Workforce Elite only, after the May 2026 rename to Workforce Payroll, Premium and Elite. Confirm it on your plan. The report needs time entered on the QuickBooks weekly timesheet with a project on each line, and it leaves the header, entry numbers, apprentice status, cash in lieu of fringe and the signature to you.
Why does the QuickBooks report leave the wage determination number blank?: QuickBooks does not hold the determination. It reports what you paid; checking it against the determination and writing the number in the header is a separate step, which is what this app does when the report is imported.
The 2025 form changed. Is the QuickBooks report current?: Check that yours downloads in the January 2025 layout (separate name columns, basic rate alone in 6A, fringe split into plan and cash, the J or RA column). The CertifiedHours import reads either layout.

Sources

Keep QuickBooks Online Payroll. Add the form.

Export the week, import it, read the checks, file. The WH-347 and the signed statement print; the prime gets the PDF. Free for one payroll a month, $19 for unlimited.

Start free

Other systems