An Excel version of the federal certified payroll report: the WH-347 column layout with the daily-hours grid, gross and net wage formulas, and the statement of compliance, ready to fill out each payroll week.
Download the free template (.xlsx)
Free download. No signup, no email required.
The WH-347 structure in a spreadsheet that does the arithmetic for you.
Worker, withholding-status code, work classification, straight/overtime hour rows across the seven-day grid, total hours, rate of pay with fringe, gross earned, the deduction columns, and net wages paid.
Total hours sum from the daily grid; gross amount earned and net wages paid compute from hours, rates, and deductions, so the cross-footing a DOL reviewer checks is done by formula.
Contractor or subcontractor, project and location, project or contract number, payroll number, and week-ending date — the fields agencies match against the contract.
A second sheet with the statement-of-compliance language and the fringe-benefits checkboxes (paid to plans, or paid in cash), completing what page two of the form requires.
Separate straight-time and overtime rows per worker with their own rates, matching how the form expects hours over 40 to be reported and paid at time and a half.
Duplicate the sheet for each weekly submission and keep the numbered sequence (Payroll No. 1, 2, 3...) that certified payroll requires for every week on the project.
Certified payroll is weekly — the template makes the week mechanical.
Your firm, the project and its number, and whether you are the contractor or a subcontractor. Each week changes only the payroll number and week-ending date.
One row per worker who performed covered work that week, with the work classification exactly as it appears on the wage determination — classification mismatches are the most common compliance finding.
The seven-day grid takes hours per day per worker; hours past 40 go on the overtime row at time and a half. Totals compute.
The rate-of-pay cell reflects the wage determination’s base rate plus fringe, whether fringe is paid into bona fide plans or in cash. Gross earned and net wages compute from there.
Check the fringe method, sign, and submit with the payroll sheet — weekly, for every week from first covered work to last. Our WH-347 guide walks through each column in detail.
About the official form: WH-347 is a U.S. Department of Labor form and the DOL publishes it as a fillable PDF; use of the WH-347 layout itself is optional, but the data it collects is required weekly on Davis-Bacon covered work. This template reproduces that layout in Excel so the math is done for you. It is a working tool, not legal advice — the wage determination and your contract govern.
One project, one crew, the template is fine. The failure mode is re-keying: the same hours your foreman already turned in get typed again into the payroll sheet, classifications drift from the wage determination, and every transcription is a chance for the certified payroll to disagree with the time records an auditor can subpoena.
SitewideOps generates WH-347 reports from the same field time that hits job cost: crews clock time once, prevailing-wage rate groups carry the determination rates, the per-job certified-payroll flag marks covered work, and the weekly report falls out with nothing re-keyed. The numbers on the form and the numbers in job costing are the same numbers, which is exactly what you want when someone checks.
SitewideOps builds WH-347 reports from the same field time that hits job cost — prevailing-wage rate groups, per-job flags, and nothing re-keyed.
Anyone interested gets a free 21-day demo account: the full product, every feature, no credit card.