WIP Reports Your Bank Will Actually Trust
A WIP schedule nobody trusts is worse than none at all. What lenders look for, the three numbers that flag trouble early, and how to keep the report current without heroics.
Every contractor above a certain size produces a WIP schedule, because the bank and the bonding company require one. Far fewer produce a WIP schedule anyone actually trusts, including the people who built it. And a WIP nobody trusts is worse than none at all: it consumes a week of the controller's month and still gets discounted by every serious reader.
What the bank is actually reading
Lenders and sureties don't read your WIP to admire the formatting. They read it to answer three questions: are the margins you booked real, is there unbilled work piling up, and do your cost-to-complete estimates move smoothly or lurch at the end of jobs? A WIP that answers those questions consistently, quarter after quarter, is the cheapest credibility a construction company can buy. One that restates itself every quarter costs you exactly that credibility, and eventually, bonding capacity.
The three numbers that predict trouble
- Underbilling growth: a rising underbilled position is either work you haven't invoiced (a cash problem) or cost overruns you haven't recognized (a margin problem). Both deserve attention this week, not at year-end.
- Margin fade: jobs that close two points below where they ran at 50% complete. One fading job is a bad job; a pattern of fade is an estimating or change-order-capture problem.
- Stale cost-to-complete: CTC estimates that haven't moved in three months aren't stable, they're ignored. Fresh CTCs are the difference between a forecast and a formality.
WIP accuracy is a systems question first
The usual prescription for a bad WIP is discipline: make the PMs update their projections. But discipline fails when the underlying job cost data is three weeks stale, because the PM is being asked to forecast from numbers they don't believe. If costs hit the job in real time, payroll, AP, committed subcontracts, equipment, then updating a cost-to-complete is a ten-minute review. If costs arrive via month-end journal entries, the same task is an hour of reconstruction, and it simply won't happen weekly.
Building a weekly WIP habit that survives busy season
The companies that do this well keep it small: a standing thirty-minute weekly review of active jobs, looking only at the three numbers above. No formatting, no packet, no meeting-before-the-meeting. The quarterly WIP the bank sees is then just a snapshot of a process that runs continuously, which is exactly what makes it trustworthy.
How Acumatica keeps the WIP honest
In Acumatica Construction Edition, the WIP schedule is a live report over the same project data everything else uses: budgets, actuals, commitments, change orders, and billings. There's no export step and no side spreadsheet to reconcile, so the WIP your controller reviews on Tuesday is the same one that prints for the bank at quarter-end. When the underlying numbers are current and shared, trust stops being a leap of faith and becomes a property of the system.
Curious how this applies to your business?
Talk to a senior consultant. No sales pitch, just a real conversation.
Related articles
Five Field Service Metrics That Predict Profitability
Service divisions drown in activity metrics and starve for profit metrics. The five numbers that actually predict whether a service operation grows or grinds.
The Ontario Contractor's Guide to Holdback and the Construction Act
Holdback is earned money with a delay attached. A plain-English guide to Ontario's Construction Act holdback rules and the tracking that keeps releases from going missing.

Construction Cash Flow Forecasting Using ERP Data
Why ERP-driven cash flow forecasts beat spreadsheet-based ones, every time. A practical guide to 13-week rolling forecasts in Acumatica.