Certified payroll from Excel that checks itself before you sign it

EG Certified Payroll fills the federal WH-347 form, both pages of the January 2025 revision, from the hours and rates you enter each week. It works out the prevailing wage side for you: classification rates, overtime, fringe, gross per project, net. And it will not approve a payroll that breaks a rule.

Pay once, use it forever. No subscriptions, no renewals. The trial has no limits. Every printed page says TRIAL COPY until you activate.

Built by an Excel developer, not a template site.

Hundreds of custom Excel projects · 5.0★ client rating across 230+ reviews · Building Excel tools since 2010

Read the reviews →

The Weekly entry page after Check: Marisol Vega's rate paid is highlighted, a red line reads Rate paid plus fringe must reach 30.60, now 29.60, short 1.00, and a callout headed Paid below the prevailing wage explains the rule with an Apply fix button

DOL’s own web form prints whatever you type. This one derives every figure from the wage determination, tells you which cell is wrong and by how much, and offers the fix.

The Weekly entry page of EG Certified Payroll: a sample payroll for the week of August 30 to September 5, 2026, with Riley Torres's line showing the Laborer classification, rate paid, the required basic plus fringe, hours by day, deductions and week totals
Weekly entry after Check payroll: the tally reads 2 blocking, 4 of 6 workers clear, and Marisol Vega's rate paid is boxed in red with the line Rate paid plus fringe must reach 30.60, now 29.60, short 1.00
Weekly entry after the fixes: the band reads No issues found, this payroll is ready to approve, Approve is highlighted in the header row, and all six workers show No issues found
The rendered Form WH-347, page 1, January 2025 revision: project and contractor details, then six workers with identifying number, classification, hours by day, total hours, rate paid, gross, deductions and net pay, with no trial mark
The rendered Form WH-347, page 2: the Statement of Compliance with its numbered paragraphs and checkboxes, the fringe benefit table with a row per worker, the exceptions area, and the signature, date and title lines
The Projects page with the sample project's card: name, contract number, location, wage determination number, contract value, and two classification blocks, Laborer and Carpenter, each with basic hourly rate, fringe rate, an in-effect-from date and a Rate changed button
The Employees page: a searchable list of eight workers with last name, first name, identifying number, status and active flag, and Dan Whitfield's card open below with last name, first name, middle initial, identifying number and worker status
The Home page of EG Certified Payroll with the sample loaded: Overview tiles for 8 active employees, 1 active project and 1 payroll, New payroll and Open payroll buttons, and Clear sample data

What EG Certified Payroll does

A reporting layer over the payroll you already run. You enter hours and rates; it produces the certified payroll and refuses the ones that would not pass.

Weekly entry hours by day, one line per classification ▼
One page per payroll week. Each worker has a line per classification with straight time and overtime by day, the rate paid, the cash paid in lieu of fringe, deductions, and the week’s totals.
  • The required rate is shown beside what you pay: basic plus fringe from the wage determination, so a short rate is visible before Check runs.
  • Overtime is derived, not typed. The overtime rate follows the basic rate; the week’s gross, deductions and net follow the hours.
  • New payroll rolls last week forward: the same workers and classifications, with hours only if you ask for them.
  • Add a worker or remove one on the page; the sample project ships with two spare workers to try it on.
Check, Fix, Approve the part DOL’s form does not do ▼
Check reads the whole payroll against the rules and lists every finding with the worker, the cell and the amount. Blocking findings stop approval until they are fixed.
  • Paid below the prevailing wage: rate paid plus fringe short of the classification’s obligation, with the restitution owed.
  • Missing identifying number, a worker with no hours in the week, and the other rules a reviewer would catch.
  • Fix takes you to the cell, and Apply fix corrects a rate to meet the obligation in one click.
  • Approve freezes the figures. An approved payroll cannot be edited by accident; Reopen it to change anything, and the form reprints from the approved figures exactly as they were.
The printed form WH-347, January 2025 revision, both pages ▼
Preview form renders the federal form from the approved figures: page 1 with the workers, hours, rates, gross, deductions and net, and page 2 with the Statement of Compliance.
  • Every page of a long payroll carries its own Statement of Compliance, as the form requires.
  • Save PDF writes the pages to a Certified payrolls folder beside the workbook, ready to submit.
  • Approved payrolls are archived as snapshots, so a payroll certified in March reprints in September exactly as it was, even after a rate or a classification changed.
Projects, classifications and rates the wage determination, once per project ▼
Each project holds its contract number, location, wage determination number and the classifications from that determination.
  • Basic rate and fringe per classification, with a dated history: change a rate from a given date and earlier weeks keep the rate they were paid under.
  • Apprenticeship programs with their levels, and fringe plans paid to a fund rather than in cash, so what prints matches what was paid.
  • Deactivate and restore a finished project instead of deleting it; its payrolls stay reprintable.
Employees name, identifying number, status ▼
A searchable list; click a name to open the card. Each employee carries a last name, first name, middle initial, the last four digits of the identifying number the form asks for, and a worker status of journeyworker, registered apprentice or trainee.
  • No Social Security numbers and no contact details are held anywhere in the workbook. The form wants four digits, so that is what is stored.
  • Assign an employee to a project’s classifications once, and the weekly page knows the rate that applies.
A sample project to try it on one click from Home ▼
Load sample project builds one project with six workers and one week of hours, with two mistakes in it for Check to find: a rate a dollar under the prevailing wage and a worker with no identifying number. Fix them, approve, preview the form, and clear the sample when you are ready for your own data. Nothing you typed yourself is touched.

What it deliberately does not do. It never computes tax withholding; the deductions you enter are the deductions that print. It holds no Social Security numbers and no contact details. And it certifies nothing: approving a payroll freezes its figures, and the contractor signs the Statement of Compliance and files it. The software prepares the form; the responsibility for what is on it stays where the law puts it.

Who built this workbook

EG Certified Payroll comes from the same developer behind hundreds of custom Excel projects. These are reviews of that work.

★★★★★

“Most likely one of the best freelancers I’ve had the opportunity of working with. I would highly recommend David for any complex VBA coding. We’ll be working with him again in the future.”

VBA Development Client · via Upwork, 2020

★★★★★

“David does phenomenal work. We brought him in during the middle of a project and he was able to pick up a significant workload very quickly. His communication and ability to hit deadlines early was great. He was a true pleasure to work with and his work was outstanding.”

Report Creation Client · via Upwork, 2022

Trial
The full workbook, every feature, no time limit and no limit on payrolls.
$0
no card required

Includes

  • ✓ Weekly entry with derived overtime, gross and net
  • ✓ Check, Fix and Approve
  • ✓ Projects, classifications and dated rates
  • ✓ The rendered WH-347, both pages, to PDF
  • ✓ Approved payrolls archived as snapshots

Every printed page is marked TRIAL COPY / NOT FOR SUBMISSION.

Download the trial

Windows PC required: why it does not run on Mac.

Removes the mark
License
The same workbook with the mark gone from every page, so the form can be filed.
$199
pay once · 2 computers

Adds

  • ✓Clean formsNo TRIAL COPY mark on any page, for every payroll, past and future.
  • ✓Unlocks in placeClick Activate on any page and enter your key. Your projects, employees and payrolls stay exactly where they are.
  • ✓Move it when you need toDeactivate this machine from the About page and activate on the next one.

The key arrives by email the moment the purchase completes.

Buy $199

Already using the trial? Keep your file. Buying a license unlocks it in place, nothing to move or re-enter.

Questions before you start? Read the setup guide, the certified payroll guides, or contact support.

Common questions

Does it file or certify the payroll for me?

No. It prepares Form WH-347 from your figures and checks them against the wage determination you entered. Approving a payroll in the workbook freezes those figures so the form reprints the same way later; it is not a certification. You sign the Statement of Compliance and submit it the way your contracting agency asks.

What happens when DOL revises the form?

The January 2025 revision is what ships today, and this download keeps serving it for as long as a past payroll might need reprinting. When DOL issues the next revision it becomes its own edition of the product, and the terms for existing license holders will be published with it.

Will it run on my Mac?

No. Activation and the file dialogs use Windows components the macOS sandbox does not provide, so the workbook is Windows-only for now. More on Excel VBA and the Mac.

Scroll to Top