Certified payroll from QuickBooks
QuickBooks can produce a federal WH-347 spreadsheet. It does not know your state portal or your general contractor's tracker. We turn QuickBooks payroll into each job's file, check it, and a person signs.
| Worker | Hrs | Check |
|---|---|---|
| ID 0000 | 40 | OK |
| ID 0001 | 38 | Under entered rate |
| ID 0002 | 40 | Deductions off |
Statement of Compliance: not signed. Last four digits of ID only, never a full SSN.
How it runs.
Every covered week, on every job, often in a different format. The office re-keys the same hours, and a mistake on a signed statement is serious.
QuickBooks week
Hours by project and classification, pay, deductions, fringes.
Your dataBuild and check
WH-347, DIR eCPR XML, or tracker import. Math and rates checked.
AutomatedA person signs
Fix flags, sign the Statement of Compliance, upload each file.
A personFiled copy kept
A dated copy of what was built for each week.
Automated
QuickBooks Online Payroll / QuickBooks Desktop Payroll / WH-347 / California DIR eCPR / LCPtracker
The rules and limits.
- Federal form
- 29 CFR 5.5(a)(3): weekly, on Optional Form WH-347 or any format, with a signed Statement of Compliance.
- What stays off
- Full SSNs, home addresses, phones, and emails on weekly transmittals.
- Signature
- DOL accepts an original or legally valid electronic signature. Scans and photocopies do not count.
- California eCPR
- DIR takes V1 XML until January 13, 2027. V2 requires contractorPWCR and fringePaid. Schema validation checks structure, not accuracy.
- QuickBooks today
- Intuit describes a WH-347 spreadsheet from QuickBooks Online Payroll. Project ID, wage determination, and fringe in lieu are added by hand.
What a person does.
- Someone who knows the job confirms classifications and hours.
- Wage rates, fringes, and apprentice ratios come from your determinations and advisers.
- The contractor or its agent signs the Statement of Compliance. We do not.
- A person uploads each file and reviews portal errors.
Where we stand: we have not shipped this. We would set it up against your own QuickBooks reports first.
Common questions.
QuickBooks already does a WH-347. Why would we need this?+
If a federal WH-347 on a few jobs works for you, you may not. It helps when jobs need state files or a tracker, or someone keeps re-keying the same payroll.
Can it submit to DIR or a tracker for us?+
We plan on a person uploading. The DIR documents we read describe portal upload and mention no API.
Will this keep us compliant?+
No software can promise that. The contractor signs and remains responsible. Falsifying the certification can lead to civil or criminal prosecution.
Sources
- DOL: Instructions for Form WH-347
- 29 CFR 5.5 (Cornell LII)
- California DIR: eCPR XML Submission FAQ
- Intuit: Create and review your certified payroll report
- Intuit: Set up certified payroll reports
- Intuit: Prevailing wages and certified payroll in QuickBooks Desktop Payroll
- LCPtracker Professional
General information, not legal, tax, or compliance advice. Rules change; confirm against the current source and your own advisers.
Bring us your version of this.
Intro calls are 30 minutes, free, and useful even if we never work together. We'll be honest about whether this is the right fit for your construction team.