How a Single WIP Report Saved My Client $400K

By Martin · 2026-02-02

Let me tell you about a phone call I got two years ago that turned into one of the most dramatic turnarounds I've been part of.

"Martin, we haven't run a WIP report in six months. Everything feels fine, but my banker is asking for one and I have no idea what it's going to show."

The contractor—let's call him Dave—ran a $12M specialty subcontracting company. Seven active projects, good reputation, steady backlog. His PM's gave him weekly updates, his accountant sent monthly financials, and his bank balance was healthy. Why would he need to spend hours compiling a WIP report?

Turns out, there were about 400,000 reasons why.

What We Found in That First Report

It took us three days to pull together the data. We built a full WIP schedule covering all seven active projects: contract value, costs to date, estimated costs to complete, percent complete, billings to date, and projected margin at completion.

When I opened the spreadsheet to review the results, I immediately saw three problems that made my stomach drop.

Project #1 - Municipal Parking Structure: Originally bid at 18% gross margin. Five months in, costs were running 15% over estimate. The PM had been tracking it but assumed they'd "make it up" in the last phase. Projected margin at completion: -3%. They were going to lose money.

Project #2 - Hospital Renovation: Bid at 15% margin, should have been one of their best jobs. But there were $127K in unreported labor overruns (overtime that wasn't in the original estimate) and $85K in pending change orders the PM hadn't documented yet because he was "waiting for the right time to submit them." Projected margin: 4%. They'd given away 11 points of margin through poor change order management.

Project #3 - Office Complex: This one looked profitable on paper—until we realized they were $410K overbilled. They'd been billing aggressively to manage cash flow, which had worked great for six months. But now they were 87% billed and only 52% complete. The project was on schedule, but when it closed out, there would be a cash cliff. Months of work with no new billings coming in.

Dave went pale. "How did we not know this?"

The Margin Fade No One Saw Coming

The parking structure was the scariest one. Here's how it happened:

The project started great. First two months came in under budget. The PM was feeling confident. Then they hit unexpected rock during excavation—not enough to trigger a change order claim, but enough to burn through their contingency and add two weeks to the schedule.

Meanwhile, the rebar sub's price had gone up 8% since the original bid, and the PM had approved it without realizing it blew their budget. Small overruns on concrete pours. Overtime to make up the schedule. A few rental equipment additions.

None of these were catastrophic individually. But together, over five months, they'd eaten through the entire margin and then some. The PM kept thinking they'd recover it on the next phase, but the math didn't work. They were on track to finish the job, make the customer happy, and lose $75K in the process.

If we'd caught it in month two, they could have filed for the rock excavation costs, repriced the remaining scope, or at minimum stopped the bleeding early. At month five, their options were limited.

The Change Order Crisis

The hospital renovation was a different kind of problem. The PM was experienced, the job was tracking close to schedule, but they'd left $85K in documented change order work sitting in a notebook.

Why? "I didn't want to nickel-and-dime the client. I was going to bundle them all and submit at the end."

That's a $85K mistake. Here's what we found when we dug into the details:

When we finally compiled and submitted them, the owner's rep had been replaced by someone new who didn't remember the verbal approvals. We got $52K approved after two months of negotiation. The other $33K? Gone.

That single decision to wait—to be the "easy contractor" instead of the business-minded contractor—cost them 4 points of margin.

The Overbilling Time Bomb

The office complex looked like the winner in the WIP report. Healthy margin, good progress, client paying on time. Except for one line item that jumped off the page: billings at 87%, costs at 52%.

Dave's initial reaction: "That's great, right? We have their money and we're ahead of schedule."

No. That's $410K in undistributed labor and materials you still owe them. And when I looked at the billing schedule, they were running out of line items to bill. The next three months were going to be heavy construction activity with minimal billing opportunities until substantial completion.

What that meant in practice: they'd been using this project to fund cash flow for the entire company. When it caught up, they'd have 3-4 months of costs going out with no significant billings coming in. Their line of credit was already 70% drawn. Where was the cash going to come from?

The Three-Week Fix

We didn't solve everything overnight, but we moved fast.

Week 1: Stop the bleeding

Week 2: Restructure the overbilled project

Week 3: Install systems to prevent this

The Results Six Months Later

We didn't save everything, but we saved most of it.

The parking structure: we got the owner to approve a $31K deduct change order for value engineering, which let us cut costs without cutting scope. The PM tightened up labor management for the final three months. Final margin: 2%. Not great, but a $130K improvement from where we were headed.

The hospital renovation: recovered $52K of the $85K in change orders. Implemented a change order log that caught another $23K in scope changes before they were performed, getting them approved upfront. Final margin: 9%.

The office complex: closed out smoothly by spreading billings more evenly and reducing other project mobilizations to preserve cash. Final margin: 14%.

Net impact: roughly $400K in margin saved, plus another $180K in cash flow crisis avoided.

The Lesson: You Can't Manage What You Don't Measure

Dave is now religious about WIP reports. Every month, on the 5th, his team compiles updated cost-to-complete estimates, billing positions, and margin projections. Every project, every time.

It takes about four hours of PM time total. That's it. Four hours a month to know whether you're making money or losing it, whether you're overbilled or underbilled, whether you need to file change orders or tighten up cost controls.

The alternative? Six months of drifting, followed by a $400K surprise.

Here's what I learned from Dave's situation, and what I'd tell any contractor:

Margin fade is silent: It doesn't announce itself. Small overruns compound over months until the job is underwater. If you're not tracking cost-to-complete weekly, you won't catch it until it's too late.

Change orders don't age well: Submit them immediately. Waiting makes them harder to prove, harder to remember, and harder to get approved. Every week you wait is margin you'll never recover.

Overbilling is borrowing from yourself: It feels like winning when the cash comes in, but you owe that work. If you're systematically overbilled across multiple projects, you're one bad quarter away from a cash crisis.

PMs are optimists: They believe they'll make it up on the next phase. They think the overrun is temporary. They assume the client will approve the change order verbally discussed. Trust your PMs to build the job; trust your WIP report to tell you if they're making money doing it.

Dave's company is doing $16M this year, and every project is tracked in real-time. They catch problems in week two, not month six. They submit change orders same-day. They manage their overbilling positions deliberately instead of accidentally.

That phone call two years ago could have been the start of a slow decline into insolvency. Instead, it was the wake-up call that turned them into one of the best-managed contractors I work with.

All because of one WIP report. Want to understand the full WIP process? Read our Complete Guide to WIP Reporting.