Will QuickBooks Do Certified Payroll? What It Can and Can't Do

Partly. QuickBooks Desktop with a payroll subscription can print a WH-347-style certified payroll report. QuickBooks Online cannot produce the federal form directly — you add a third-party app or export to Excel and finish by hand. And neither version does the two parts that actually get shops fined: matching each worker to the right Davis-Bacon work classification, and paying fringe per hour worked. QuickBooks reports what you already told it. It does not do the compliance judgment. For tools built for the job, compare dedicated Davis-Bacon compliance software.

That gap is why a QuickBooks salesperson says "yes, with the right plan" and a contractor three years into QuickBooks Online says the opposite. One plumbing-shop owner, pushed toward four different subscription tiers to get the job done, put it plainly: the salesman "doesn't understand what he's selling." This page sorts out what QuickBooks genuinely does, the three places it breaks, the manual workaround shops actually use, and the point where it stops being worth it.

Will QuickBooks do certified payroll?

The honest split is version by version. QuickBooks Desktop — Pro, Premier, or Enterprise with a payroll subscription — has a built-in Certified Payroll Report that outputs a WH-347-formatted spreadsheet. QuickBooks Online has no such report. That matters more every year: Intuit stopped selling new Desktop Pro and Premier subscriptions to most new US customers in 2024 and keeps pushing shops to Online, the one version that can't do this. So a bookkeeper leaving a parent company's payroll, or a long-time Desktop user forced to upgrade, lands on the weaker tool exactly when a federal job needs the stronger one.

What QuickBooks can do for certified payroll

QuickBooks does the arithmetic and the record-keeping well. On a covered federal job — any construction contract over $2,000 under the Davis-Bacon Act — it tracks hours by employee, applies a pay rate, calculates gross wages, withholds taxes and deductions, and lands on net wages paid. Run your weekly payroll there and those columns come out right on every WH-347 line.

Desktop goes one step further. Reports, then Employees and Payroll, then More Payroll Reports in Excel, then Certified Payroll Report opens a wizard that asks for the project name and project/contract number and exports a spreadsheet already shaped like the WH-347. For a single prevailing-wage job with one classification, that export gets you most of the way to a filed form.

What QuickBooks will not do is decide whether the numbers are right for Davis-Bacon. It has no wage determination inside it. It does not know a laborer got paid an electrician's rate for four hours. It treats fringe as a flat benefit. Those three judgments are the job — and they are where it breaks.

Where QuickBooks falls short

Three breakpoints separate a QuickBooks payroll report from a compliant certified payroll. Each one is a place the WH-347 demands something QuickBooks does not track on its own.

QuickBooks runs the payroll math, then breaks on three compliance judgments, so most shops finish the WH-347 by hand

It does not match Davis-Bacon classifications

QuickBooks stores a pay rate per employee or per item. It does not hold the wage determination's classification list, and it will not tell you which classification a worker belongs in. You pick that yourself. A contractor who priced out ADP's higher tiers ran into the same gap: the software "doesn't do the classification matching — you still have to manually pick the right Davis-Bacon classification for each worker and hope you got it right." QuickBooks is no exception.

The fix is upstream, not in the software. You already chose each classification when you bid the work; the certified payroll must use those same lines. QuickBooks just needs you to enter what you already know. But it offers no guardrail if you enter the wrong one. A wrong work classification is one of the most common triggers for a rejected report and a back-wage finding.

Fringe per hour breaks in a flat-benefit setup

QuickBooks Payroll is built to apply benefits as a flat weekly or per-pay amount. Davis-Bacon requires the opposite: fringe paid on every hour actually worked (29 CFR 5.5). Set a flat fringe and the math silently drifts.

Take a determination with an $18.75/hr fringe rate. A clerk sets QuickBooks to pay $750 a week, assuming 40 hours. The worker logs 46. The fringe benefits column now shows an effective $16.30/hr — a $2.45/hr shortfall the report doesn't flag. This is the flat-weekly fringe trap that quietly underpays.

Multiply that gap across a crew and twelve weeks and it becomes real money — one shop paid $13,508 on a single fringe violation. This is why practitioners say they run fringe "in Excel outside of payroll and reconcile." Our fringe-per-hour guide shows the full calculation.

Online does not produce a compliant WH-347

The federal form needs the Statement of Compliance — the sworn certification on the back page — plus the specific fringe column layout. QuickBooks Online prints neither. It has no certified payroll report at all. A painting contractor running QuickBooks Online for three years said it flatly: "all certified payroll has to be re-created and sent to each general contractor... It cannot be done inside of QuickBooks."

Desktop's export gets closer but still hands you a spreadsheet, not a signed, filed form. Some shops keep an older Desktop version alive just for a third-party certified-payroll add-on such as Sunburst. That works, but it is a bolt-on, not a native feature — and it ends when the Desktop version does.

The manual QuickBooks workaround

Most small shops bridge the gap the same way: run payroll in QuickBooks, then finish the certified payroll by hand. Here is the workflow, step by step.

The load-bearing steps are 4 and 5. QuickBooks handles steps 2 and 3; the compliance work (fringe reconciliation and the classification lines) is manual either way. Budget two to three hours a week per job once you are running more than one. A certified payroll calculator can shorten step 4.

QuickBooks Online vs Desktop vs a dedicated tool

Scored against the three breakpoints, here is where each option actually lands.

QuickBooks wins on cost when you have it already. Dedicated software wins on the two manual columns and on prime contractor/subcontractor portal submission. The right answer depends on volume.

When QuickBooks stops being enough

The switch point is not a feeling. It is a job count. Contractors who work this daily put it at three to four prevailing-wage jobs running at the same time. Below that, the manual workaround is cheaper than software. Past it, the re-keying and the rejected-report rework cost more than a subscription.

Two other triggers force the question earlier. First, a prime contractor that mandates a portal like LCPtracker: you do not choose the platform, and QuickBooks output rarely uploads clean. One contractor described "multiple tries and corrections on both ends" before a QuickBooks export was accepted, and warned to "check your payroll subscription and see if your provider can actually export LCPtracker-compatible CPRs." Second, apprentice ratio tracking across several jobs, which QuickBooks does not monitor at all.

If you have hit that point, comparing dedicated options is the next step — see our guide to certified payroll software. If you are still on one or two jobs, the manual workaround above is the honest, cheaper answer, and the certified payroll pillar walks the full weekly workflow.

FAQ

Is QuickBooks certified payroll accurate?

The payroll math is accurate; the compliance is only as accurate as your inputs. QuickBooks correctly calculates gross, taxes, deductions, and net. It does not verify your Davis-Bacon classification or check that fringe was paid per hour worked, so a flat-fringe setup or a wrong classification produces a clean-looking report that still fails an audit.

Does QuickBooks Desktop do Davis-Bacon certified payroll?

Yes, with limits. Desktop's built-in Certified Payroll Report exports a WH-347-formatted spreadsheet once you enter the project number and classifications. It still treats fringe as a flat benefit, so you confirm fringe per hour and sign the Statement of Compliance yourself. It is a strong starting point for one or two jobs, not a full compliance system.

What is the cheapest way to do certified payroll with QuickBooks?

Run payroll in the QuickBooks plan you already have, export the detail to Excel, fix fringe to a per-hour figure, and hand-fill a free fillable WH-347. That costs only your time — roughly two to three hours a week per job. It stays the cheapest option until you pass three to four simultaneous prevailing-wage jobs.

Frequently asked questions