If you run a construction business and your lender, surety, or CPA has ever asked you for a WIP schedule, you know how the conversation usually goes. You nod. Your bookkeeper sends something. Nobody's entirely sure if it's right. Life goes on.
Then, at some point, often when you're trying to expand your bonding capacity or refinance a line, someone looks closely at the WIP schedule, and things get uncomfortable.
This piece is the straight explanation I wish every contractor got before that conversation. Not the accountant version. The owner version.
What WIP reporting actually is
WIP stands for work in progress. A WIP schedule is a report, usually monthly, that tells the story of every active project: how much you've billed on it, how much you've actually earned based on the work completed, and the gap between those two numbers.
It exists because construction projects don't fit cleanly into regular accounting. If you bill a $1M project in stages, and you're halfway through the work but you've only billed 30% of the contract, normal accounting would show you as way less profitable than you actually are. Conversely, if you've billed 80% but only done 40% of the work, you look flush in ways you shouldn't.
WIP reporting fixes this. It compares:
- What you've billed so far (the money that's moved through invoices)
- What you've earned so far (the portion of the contract price that matches the work you've actually completed)
The difference between those two numbers is either over-billing (you've invoiced ahead of the work, which is a liability) or under-billing (you've done more work than you've invoiced, which is an asset). Both show up on the balance sheet.
Why your lender and bonding company demand it
Here's the part owners often miss: your lender and your bonding company are not primarily looking at your P&L. They're looking at your balance sheet. And on a construction balance sheet, the largest and most important items are usually your WIP-related balances.
If your WIP schedule shows a healthy pattern, work coming in, getting billed, completing on schedule, cash flowing through, your balance sheet looks strong. Your working capital ratio looks real. Your surety is comfortable writing bigger bonds.
If your WIP schedule is messy, wildly variable billing-to-earnings ratios, projects that have been "95% complete" for six months, jobs where the estimated final cost keeps creeping, the balance sheet loses credibility. Your bonding capacity caps out. Your lender gets nervous on the operating line.
A good WIP schedule isn't just accounting cleanup. It's the single most important financial artifact most construction businesses produce, and it's the reason bonding and lending relationships work or don't.
The key numbers on a WIP schedule
A clean WIP schedule has a row for every active project with roughly these columns:
- Contract value: the total price of the job
- Estimated total cost: what you expect the whole job to cost by completion
- Estimated gross profit: contract value minus estimated total cost
- Costs to date: what you've actually spent on the job so far
- Percent complete: costs to date divided by estimated total cost
- Earned revenue to date: percent complete times contract value
- Billed to date: what you've actually invoiced on the job
- Over-billings (billings in excess of earnings): billed more than you've earned
- Under-billings (earnings in excess of billings): earned more than you've billed
The rollup of all your over-billings and under-billings across active projects ends up on your balance sheet. Over-billings are a liability (you owe that work). Under-billings are an asset (you're owed that billing).
You don't need to memorize the mechanics. What you need to understand is that every one of those numbers rolls up into decisions your lender, surety, and leadership team are making.
Where WIP reporting goes wrong
In my experience, four things break WIP schedules more than anything else:
The estimated total cost never gets updated
This is the number one killer. A project kicks off with an estimated total cost of $800K. Three months in, the actual cost projection has drifted to $900K from change orders, material price changes, productivity issues. But the estimate on the WIP schedule still says $800K.
Result: the percent complete calculation is wrong, earned revenue is wrong, and over-billing/under-billing is wrong. When the project finishes and reality catches up, everything swings hard in one month, and profit that looked real for a quarter evaporates overnight.
Fix: Updated estimates monthly. Real projections, not wishful thinking. If the job is going to come in at $900K, put $900K on the schedule and explain the variance to the original estimate.
Change orders aren't on the schedule
Every approved change order changes the contract value. If those change orders aren't flowing onto the WIP schedule the month they're approved, your WIP is using a stale contract value and all the downstream numbers are wrong.
Fix: Change orders hit the WIP schedule the month they're approved, with contract value adjusted and estimated cost adjusted. Tight project management discipline is the only way this works at scale.
Costs aren't being recorded against the right job
Sounds basic. It isn't. The amount of money that gets miscoded to a generic "construction costs" bucket instead of a specific job would shock most contractors. When that happens, the job-level costs-to-date is wrong, which means percent complete is wrong, which means earned revenue is wrong. You get the idea.
Fix: Job coding discipline on every invoice, every time card, every material receipt. Your bookkeeper should be catching miscoded items monthly and re-assigning them. If they aren't, that's worth a conversation.
The schedule is built from estimates, not actuals
Some shops build their WIP schedule by asking the PM "how far along are you?" and using that percentage directly. It's better than nothing, but it's not what your lender or surety wants. They want cost-based percent complete, actual costs divided by updated total cost estimates, because estimates from PMs can be wishful.
Fix: Percent complete from cost-to-date divided by estimated total cost, with occasional sanity checks from the PM on physical progress. Cost-based is the accounting standard and it's what will stand up to outside scrutiny.
How accurate WIP changes your picture
When a WIP schedule is clean and updated monthly, a few things change for the business:
You see loss jobs earlier. A job that's heading to a loss shows up as a growing under-billing with deteriorating estimated gross profit. On a clean schedule, you see it months before the job wraps. You can renegotiate, de-scope, or just brace for it, but you're not surprised.
You see margin drift across the portfolio. When a handful of jobs are all slipping on estimated gross profit, it's usually a signal of a systemic issue: pricing, productivity, or estimating. A clean schedule surfaces the pattern.
Your bonding conversations get easier. A clean, consistent WIP schedule delivered monthly is something your surety will actually read. It's the single biggest thing that moves bonding capacity up, because it lets them write bonds to the real picture of your business, not a conservative guess.
Your lender sleeps at night. And so do you. A messy WIP schedule means something somewhere is wrong. A clean one means the business is running the way you think it's running.
Who should be doing WIP reporting
Your bookkeeper can produce a WIP schedule if they have the right training and the right software. Many don't. If your current bookkeeper isn't producing a monthly WIP schedule or isn't confident explaining the numbers on it, that's a signal that either their construction-industry experience is shallow, or they need support from someone whose experience is deeper.
A fractional CFO engagement in a construction business almost always includes WIP schedule review and often WIP schedule preparation. That's not because WIP is hard. It's because WIP sits at the intersection of accounting, operations, and strategy, which is exactly where a fractional CFO operates.
If your WIP is a mess
It usually takes 30-60 days to get a messy WIP schedule into good shape. The work is:
- Reconstructing accurate cost-to-date on each active project
- Building real, updated estimated total cost for every job
- Reconciling billing to the schedule
- Building the rollup to the balance sheet
- Setting up the monthly cadence so it stays clean going forward
None of that is magic. But it's specialized enough that most construction businesses can't do it internally, and it's important enough that getting it right changes how the business looks to every outside party that matters.
If any of this sounds like something you've been meaning to get to, book a free strategy call. We'll go through your current setup and tell you honestly what it would take to get your WIP reporting into shape. And if you want more on the construction finance side specifically, our construction industry page has the fuller picture.