Certified payroll template
There is no official “certified payroll Excel template.” There is an official WH-347, and there is the roster you need to collect before you can fill it. This page gives you both — plus a printable worksheet for checking the math.
The short answer: use the official WH-347 for the federal form, and use a roster template to collect the data once. The free CSV below matches the tool's import columns; the printable worksheet mirrors the WH-347 so you can catch errors before you type them into the form.
Download the templates
The CSV is a data-collection aid. It is not a certified payroll and cannot be filed on its own. The worksheet is a checklist, not an official form.
Why a generic Excel template fails
- No determination fields. It has no place for the wage determination number and modification, so the reviewer cannot tie the payroll to the contract.
- One blended rate. Base rate and fringe get combined into a single hourly number, which hides whether the fringe obligation was met.
- Wrong overtime math. It multiplies the package by 1.5 instead of the basic rate, or ignores overtime entirely.
- No certification. The Statement of Compliance is missing, unsigned or undated.
- Stale form. The workbook was built on an older revision and is missing current fields.
What is in the CSV
| Column | What to enter |
|---|---|
| worker_name | Full name as it appears on payroll. |
| worker_id | Last four of the SSN or the employee ID. Do not put full SSNs in a shared sheet. |
| classification | The exact classification from the wage determination, e.g. “Laborer Group 1”. |
| county | County and state for the rate lookup. |
| base_rate / fringe_rate | The two components, separately. Do not combine them. |
| mon_hours … sun_hours | Daily hours, including overtime hours in the day they were worked. |
| ot_hours | Overtime hours for the week, for the OT column. |
| notes | Anything the reviewer should know: two classifications, a missing plan, a cash shortfall. |
How to use it in five steps
- Download the CSV and replace the two example rows with your roster.
- Enter the base rate and fringe rate separately from the contract's determination — not from last year's sheet.
- Enter daily hours; put overtime hours in the day they were worked and in the OT total.
- Print the worksheet and check that daily hours reconcile, fringe is supported, and overtime uses the base rate.
- Fill the official WH-347, sign page 2, and file through the channel the contract requires.
If you file in a state with its own form, use the form directory first. A federal WH-347 does not replace a Pennsylvania LLC-25 or an Oregon WH-38 on a state-covered job.
Questions
Is there a free certified payroll template?
Yes. The roster CSV and worksheet on this page are free. The official federal form is the DOL's WH-347, also free.
Can I file an Excel template instead of the WH-347?
You can submit payroll data in another format if it contains all required information, but most agencies expect the WH-347 or an equivalent certified payroll with a signed Statement of Compliance. An Excel workbook without the certification is not a substitute.
Why do generic templates get rejected?
They usually lack the determination number and modification, separate fringe columns, correct overtime math, and the signed certification. Many are built on an old revision of the form.
Does the CSV upload into WageDecoder?
Yes. The columns match the tool's roster import. Import, check the rates, and export the filled WH-347.
Skip the copy-paste
Import the roster CSV into WageDecoder, run the rate and fringe checks, and export the filled WH-347.
Not legal advice. The template is a data-collection aid, not an official form. Verify the form and rates against the contract and the agency's instructions. Not affiliated with the U.S. Department of Labor or any state agency.