Nothing you type is sent anywhere. The math runs in your browser, and a draft is saved only in this browser so you can come back to it. The printout follows the WH-347 column order and carries the Statement of Compliance word for word, ready to sign. Your agency or prime may require its own system or DOL’s Form WH-347: check with them.
Page 1: payroll header
Page 1: worker rows
One worker per row, ST hours on top and OT below, as on the form. The grid scrolls sideways inside its box. Shaded cells are worked out for you. Use “+ Classification” for a worker who worked in two classifications this week.
This worksheet is built for a computer screen. On a phone it works, but the grid is wide.
| 1AEntry | 1B to 1DWorker name | 1E and 2ID no.; J or RA, level | 3Classification | 5Total hours | 6ARate paid | Fringe credit$/hr, page 2 | 6BFringe credit | Cash in lieu$/hr | 6CCash in lieu | 7AGross, this project | 7BAll work; blank = 7A | 8 Taxwithholdings | 8 FICA | 8 Othersee remarks | 8 Totaldeductions | 9Net pay | CheckWD rate + fringe | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Totals for this payroll | ||||||||||||||||||||||||||
The check column is optional: type the basic rate plus fringe from your wage determination for the worker’s classification. The tool never looks up rates. Leave 7B blank when the worker had no other work this week.
Page 2: fringe benefit plans
One line per plan (up to six, as on the form). Each plan’s hourly amount applies to every worker unless you type a different amount for a worker in the table below, for example family and single coverage. Type 0 for a worker not in the plan. A worker’s total hourly credit feeds column 6B.
| Plan name | Plan type | Plan no. | Funded or unfunded | Hourly creditper worker |
|---|
Page 2: Statement of Compliance
I paid or supervised the payment of the laborers or mechanics working on the above project during the stated time period. I certify the following:
Apprenticeship programs (box 4), up to three:
| Apprenticeship program name | Registered | Labor classification |
|---|---|---|
Print lays the payroll out as landscape pages in the WH-347 column order: page 1 (a sheet for every 8 rows) and page 2, the Statement of Compliance in DOL’s wording with your boxes marked. A long fringe table continues on another page 2 sheet; the signature block stays on the last one. In the print dialog, keep the layout landscape, the margins at Default, and headers and footers off. Then sign and date page 2. The CSV file is made in your browser.
How the tool fills each column
You type hours, rates, cash in lieu, 7B and deductions; the tool multiplies and adds as DOL’s WH-347 instructions describe, rounding each amount to the cent. Column 6A is the rate you actually paid, and DOL says “do not include cash payments in lieu of fringe benefits in this column”. The WH-347 guide covers every field.
| Column | The tool | DOL’s instructions |
|---|---|---|
| 5 | ST plus OT hours, all seven days. | “Enter the total number of the hours worked entered in column four.” |
| 6B | Hours × the worker’s hourly credit from page 2. | It “should equal the worker's total hours worked in this period multiplied by the hourly credit for fringe benefits” |
| 6C | Hours × the hourly cash in lieu. | It “should equal the worker's total hours worked in this period multiplied by the hourly rate provided to the worker as cash in lieu” |
| 7A | ST hours × ST rate, plus OT hours × OT rate, plus 6C unless you untick that option. | “gross amount earned for the workweek for hours worked on this Federal or federally assisted project” |
| 7B | What you type; blank means 7B equals 7A. | “the total gross amount earned during the week for all work performed during the week” |
| 8 | Tax plus FICA plus Other. | “include the amounts listed under the Tax Withholdings, FICA and Other columns” |
| 9 | 7B minus total deductions. | “the actual dollar amount paid to the worker for all hours worked across all projects” |
Column 7A and cash in lieu
The instructions define 7A only as the gross earned on the project. They do not say in so many words whether 6C cash in lieu belongs in it. The tool includes it by default, as the worked example in our WH-347 guide does; the 6B plan credit never goes in 7A. If your contracting agency wants it shown another way, untick the option and follow the agency.
The worked example (an electrician at $35.00 plus $15.00, 40 ST hours, 4 OT hours at $52.50, $5.00 cash in lieu, $10.00 plan credit) gives 6B $440.00, 6C $220.00, 7A $1,830.00, and $2,270.00 of wages, cash and credit together.
The overtime checks
On a contract covered by the Contract Work Hours and Safety Standards Act (CWHSSA), work over 40 hours in a workweek is allowed only if the worker “receives compensation at a rate not less than one and one-half times the basic rate of pay for all hours worked in excess of forty hours in such workweek” (29 CFR 5.5(b)(1)). DOL’s instructions say to “enter hours worked on this project in excess of 40 hours total in the week as overtime”. So the tool flags:
- OT hours when the worker’s rows total 40 or less. That can be right: other covered work counts toward the 40, and a contract or state law may pay daily overtime.
- More than 40 hours with fewer OT hours than the excess.
- An OT rate below 1.5 times the ST rate. Fringe payments, including cash in lieu, “are excluded in computing overtime obligations under CWHSSA”.
CWHSSA does not reach every job: the Resource Book applies it to FAR contracts over $150,000 and other covered contracts over $100,000 (as of November 2026), and says “CWHSSA and FLSA do not require premium pay or overtime compensation for work performed on holidays, weekends, or days of rest”. See Davis-Bacon overtime and the CWHSSA overtime calculator.
The rate and fringe check
Type the basic rate plus fringe from your wage determination. The tool adds the ST rate, hourly plan credit and hourly cash in lieu and flags a shortfall, since “monetary wages paid in excess of the basic hourly rate may be used as an offset or credit to satisfy fringe benefit obligations, and vice versa”. Most plan credits must be annualized first: use the annualization calculator and see Davis-Bacon fringe benefits.
Page 2: the six boxes and the fringe table
The six checkboxes carry DOL’s wording from page 2 of the WH-347, word for word, and the printout shows each statement with its box marked or not. “Boxes 1, 2, 3 and 6 (i.e., the first three boxes and the last box) always must be checked”; the tool reminds you of box 4 when a row shows RA and box 5 when a row has plan credit or cash in lieu. Paying the whole fringe in cash, you “check the box but do not complete the subsection”. The fringe table lists each worker once, in the order of page 1, since the list “should mirror the worker names and order found on Page 1 of the certified payroll form”; a worker with a different hourly credit in two classifications gets a line for each, and the printout says so. An unfunded plan needs DOL’s approval under 29 CFR 5.2829 CFR 5.28Code of Federal Regulations, eCFR before you take the credit. The signer then signs and dates the printout: “Legally valid electronic signatures are acceptable.” DOL adds that “Photocopies or scanned copies of signatures do not satisfy this requirement.” See the Statement of Compliance guide.
Where your entries go
Nowhere. The math runs in your browser and nothing is sent. A draft is kept in this browser on this device only; Clear all deletes it.
Can you submit the printout?
The rule says the weekly payroll “may be submitted using Optional Form WH-347 or in any other format desired”, and DOL’s instructions say each payroll needs a signed Statement of Compliance, for example “page 2 of the WH-347 or another document with identical wording”. The printout follows the WH-347 column order and carries the Statement of Compliance word for word; you sign and date it. Your agency or prime contractor may require its own system or DOL’s Form WH-347: check with them before you send it.
What the tool does not do
- Look up rates. Find your wage determination in the contract or on SAM.gov; see wage determinations.
- Work out a weighted average OT rate for a worker in two classifications, which the Resource Book allows.
- Check deductions against 29 CFR part 329 CFR part 3Code of Federal Regulations, eCFR, or work out taxes.
- Sign or submit anything for you. Your agency, prime or state may require its own form or system.
Questions filers ask
Can I submit the printout as my certified payroll?
The rule lets you submit the weekly payroll in any format with the required information, signed with a Statement of Compliance worded as on page 2 of the WH-347 (29 CFR 5.5(a)(3)(ii)(B))29 CFR 5.5Code of Federal Regulations, eCFR. The printout follows the WH-347 column order and carries that statement word for word: fill in every column, sign and date page 2. Your agency or prime may require its own system or DOL’s form, so check with them.
Where is my data stored?
Only in this browser on this device, as a draft in local storage. Nothing is sent to us or anyone else. Clear all deletes it, and a private window keeps nothing after you close it.
Why does the tool flag OT hours when the worker worked 40 hours or less?
CWHSSA overtime is for hours over 40 in the workweek. The flag is a prompt to check: OT can still be right if the worker had other covered work that week or the contract or a state law pays daily overtime.
How do I enter a worker who worked in two classifications?
Use “+ Classification” on the worker’s row. The new row keeps the same entry number, as DOL’s instructions ask, and the overtime checks add the hours of both rows.
Should 7A include the cash in lieu of fringes?
The instructions do not say. The tool includes 6C in 7A by default, matching our WH-347 guide’s example. If your agency wants it left out, untick the option.