Certified payroll overtime is arithmetic anyone can do with a calculator or a spreadsheet. The problem is one non-obvious rule: cash paid directly to a worker in lieu of fringe counts toward the overtime "regular rate" and must itself carry the time-and-a-half premium, while a bona fide plan contribution never does — and a hand calculation built for ordinary hourly overtime has no reason to know the difference exists.
| Step | Common mistake by hand | What this calculator does |
|---|---|---|
| Finding the overtime rate | 1.5x the base cash rate only, the way ordinary hourly overtime works, with fringe added separately at a flat rate on every hour. | 1.5x the base cash rate plus any cash-in-lieu-of-fringe, since 29 CFR 5.32 / 778.7 puts the cash-fringe portion in the regular rate. |
| Bona fide plan contributions | Sometimes folded into the same overtime multiplier as cash pay, which overpays the plan contribution unnecessarily. | Excluded from the overtime premium entirely and paid at the same flat rate every hour, exactly as the regulation allows. |
| Checking the wage-determination minimum | Compared against base rate alone, missing that fringe counts toward the required total too. | Compares required base + fringe against actual base + bona fide fringe + cash fringe, and reports any shortfall per hour. |
| Apprentice-to-journeyman ratio | Tracked separately, if at all, and easy to miss when a crew's mix shifts mid-week. | Reports how many apprentice hours exceed the approved ratio from the counts you enter. |
| Is anything I enter uploaded anywhere? | N/A | No. The calculator runs entirely in your browser; nothing is sent to a server. |
Applying the overtime premium to the base cash rate only, and paying any fringe paid directly to the worker in cash at straight time even during overtime hours. Under 29 CFR 5.32 and 29 CFR 778.7, cash-in-lieu-of-fringe is part of the overtime "regular rate" and must itself get the time-and-a-half premium. A bona fide plan contribution is excluded and never gets the premium — the two figures are easy to swap by hand.
Most general-purpose payroll software and hand-built spreadsheets compute overtime as 1.5x the base hourly rate, because that is correct for a plain hourly job with no fringe. Certified payroll on a Davis-Bacon or prevailing-wage job adds a second required figure, the fringe rate, and the rule for which part of it counts toward the regular rate is specific to government-contract wage law — not something a general payroll setup applies unless it was built for this.
Only until the mix changes. A formula built for one classification with a fixed split between bona fide and cash-in-lieu fringe silently gives the wrong overtime rate the week a worker's cash-fringe portion changes, or the week someone copies last week's blended rate forward instead of recomputing it from this week's actual pay.
No. Whether a contract is covered, which wage determination applies, and a worker's approved apprentice rate all come from the contracting officer's wage determination and the registered apprenticeship agreement. Both a hand calculation and this calculator take those figures as inputs already looked up; neither one guesses them.
No, and neither does a spreadsheet on its own. This calculator checks the underlying arithmetic — required vs. actual compensation, the correctly computed overtime rate, and the apprentice ratio — for one classification, one week, so you can carry the right numbers into a certified payroll report. It does not know your project name, contract number, or DOL's exact form layout, and it does not submit or sign anything.