Miscoded hours can ripple through certified payroll, percentage of completion, and the numbers your bank and surety rely on.
Every hour of labor on a prevailing wage job travels a long way. It starts on a timecard, moves through certified payroll and job cost, and lands on the work-in-progress (WIP) schedule your bank, surety, and CPA use to evaluate your company. If that hour hits the wrong job, cost code, or wage rate, the error will ultimately impact the company’s revenue recognition.
I recently joined Samantha Lake, chief operating officer of ProNovos, and Bernadette Negrete, director of GL engineering and programming at eBacon, for a webinar hosted by eBacon that traced one hour of labor from timecard to WIP schedule. Here’s what every contractor doing public work should know.
Why doesn’t clean certified payroll guarantee accurate job costs?
Certified payroll proves you paid workers correctly. It doesn’t prove you charged that labor to the right job. Contractors on Davis-Bacon projects must submit weekly certified payrolls to the contracting agency, which reviews them for wage compliance, not job costing. As Negrete explained, paying people correctly and costing their hours correctly are two separate tasks.
Lake pointed to a common culprit: crews that split a day between prevailing wage and private jobs, paired with a time system that defaults every hour to the morning job.
How do miscoded hours distort your WIP schedule?
Most contractors recognize revenue using the cost-to-cost percentage of completion method. Divide costs to date by total estimated costs to get percent complete, then multiply by the contract value to get earned revenue. If you’ve spent $300,000 of an estimated $1 million on a $1.5 million contract, you’re 30% complete and have earned $450,000.
Compare that to billings. Bill $500,000 and you have $50,000 in overbillings (a liability). Bill $400,000 and you have $50,000 in underbillings (an asset third parties often view as a red flag).
Because labor cost sits in the numerator, a miscoded hour inflates one job’s percent complete and understates another’s. If those jobs carry different margins, you recognize the wrong revenue. One hour won’t move your financial statements, but it often signals a bigger internal control gap.
Why does bad payroll data cause profit fade all at once?
Normally, profit fade gives you a warning: a job bid at 20% slips to 19%, then 17.5%. Lake explained that bad payroll data removes that warning. When labor lands on the wrong job, costs look on budget, so the project manager (PM) has no reason to update the estimated cost to complete. The real cost shows up at closeout, when there’s no work left to absorb it.
Wage rates carry similar risk. The most common labor issue I find in audit testing is the wrong wage rate. Negrete noted that pulling the wrong wage determination can force restitution to workers and refiled payrolls, with penalties possible if an audit finds underpayment. Ohio public improvements carry their own state prevailing wage requirements, too.
What do CPAs, sureties and banks look for first?
When I open a WIP schedule, I start by tying overbillings and underbillings to the balance sheet and current-year revenue and costs to the income statement. Then I look for outliers: large over or underbillings and margins far from the norm. Sureties and banks compare your current WIP to the last one and ask what changed. Swings happen. Having no explanation for them hurts your credibility.
Where should contractors start?
Each panelist named a different first fix:
- Negrete: Make sure whoever processes payroll knows which jobs are prevailing wage and that each job carries the correct determination for its county from day one.
- Lake: Code hours to the right job daily, and have PMs review labor hours by cost code weekly.
- My pick: Hold monthly job reviews between accounting and PMs to update estimated costs to complete.
Lake and I also stressed teaching PMs how percentage of completion works, since many assume billings drive revenue.
Talk With GBQ’s Construction Team
For the full conversation, watch the webinar replay on certified payroll and WIP schedules. If you’d like a second set of eyes on your WIP process or prevailing wage setup, contact GBQ’s construction industry professionals or explore our construction accounting services. Empowering growth is only a conversation away.
Frequently Asked Questions
What is a WIP schedule in construction?
A WIP schedule tracks each open contract’s value, estimated total cost, cost to date, and billings to date. Contractors use it to calculate percent complete, earned revenue, and over or underbillings. Banks, sureties, and CPAs rely on it to judge whether financial statements can be trusted.
What is the difference between overbillings and underbillings?
Overbillings occur when you bill more than you’ve earned under percentage of completion, creating a liability. Underbillings occur when earned revenue exceeds billings, creating an asset. Large underbillings often raise questions about billing practices or optimistic cost estimates