How to read a construction WIP report
Read a WIP report by checking three things on every job: whether the estimated total cost is believable, whether the job is over or under billed, and whether the projected gross profit is holding or fading from last month.
A construction WIP report shows, for every open job, what the contract is worth, what it is expected to cost, how much of it is done, how much revenue has been earned, and how that compares with what has been billed. To read one, start at the right-hand columns. Look for jobs where gross profit dropped since last month, jobs that are heavily under billed, and jobs that are over billed by more than the cash in the bank can cover. Then trace each red flag back to the estimated total cost, because that one forecast drives every other number on the line.
Bankers and surety underwriters read WIP reports this way. Owners who learn to do the same catch losing jobs months earlier.
What each column on a WIP report means
Layouts vary, but most WIP schedules built on the cost-to-cost percentage of completion method carry these columns.
| Column | What it is | How it is calculated |
|---|---|---|
| Contract value | Original contract plus approved changes | From the contract and the change order log |
| Estimated total cost | Current forecast of what the job will cost | Cost to date plus cost to complete |
| Estimated gross profit | What the job should make | Contract value minus estimated total cost |
| Cost to date | Actual job costs posted | From the job cost ledger |
| Percent complete | How far along, by cost | Cost to date divided by estimated total cost |
| Earned revenue | Revenue you have earned so far | Contract value times percent complete |
| Billed to date | Everything invoiced, including retainage | From billing records |
| Over or under billing | Billing ahead of or behind the work | Billed to date minus earned revenue |
| Cost to complete | Cost still to be spent | Estimated total cost minus cost to date |
How to read a WIP report in six steps
- Check the date and the cutoff. Confirm the report uses costs posted through month end and billings through the same date. A mismatch distorts every job.
- Compare estimated gross profit with last month. Put the two reports side by side. A drop is called fade. Two months of fade in a row on the same job means the forecast is chasing reality.
- Test the estimated total cost. Ask the PM how cost to complete was built. A number that equals the original budget minus cost to date is not a forecast; it is a hope.
- Scan the over and under billing column. Large underbilling often means unbilled work, unapproved change orders, or a cost overrun the estimate has not caught. Large overbilling means you are holding the customer's cash for work not yet done.
- Look at percent complete versus the schedule. A job at 85 percent complete by cost that the superintendent calls 60 percent done is spending faster than it is building.
- Total the report. Net over billing across all jobs compared with the cash in the bank tells you whether you are funding today's work with tomorrow's money.
Worked example: reading a three-job WIP
Here is a simplified month-end WIP for a contractor with three open jobs. The numbers are illustrative.
| Job | Contract | Est. total cost | Cost to date | % complete | Earned revenue | Billed to date | Over (under) |
|---|---|---|---|---|---|---|---|
| Clinic remodel | $620,000 | $540,000 | $405,000 | 75% | $465,000 | $520,000 | $55,000 |
| Warehouse addition | $1,150,000 | $1,060,000 | $318,000 | 30% | $345,000 | $290,000 | ($55,000) |
| Retail fit-out | $280,000 | $236,000 | $212,400 | 90% | $252,000 | $252,000 | $0 |
Clinic remodel. Over billed by $55,000. Is that fine? It depends. If the schedule of values was front-loaded, the company has collected cash for work it still owes, and the last 25 percent of the job will need cash with little billing left to fund it. Check that the $135,000 cost to complete is real before celebrating.
Warehouse addition. Under billed by $55,000. Three questions: Did the PM miss billing for stored materials or completed work? Is there signed change work that has not been invoiced? Or did costs run ahead because something went wrong? If last month's estimated total cost was $1,020,000 and it is now $1,060,000, the third answer is likely, and the job's profit just fell from $130,000 to $90,000.
Retail fit-out. Billing matches earned revenue at 90 percent complete, with $23,600 left to spend and $44,000 of profit projected. This is the boring job, and boring is good. The only check is whether closeout and punch costs are in the forecast.
Across the company, over and under billing nets to zero. That looks balanced. But the clinic's overbilling is cash already spent, while the warehouse's underbilling is cash not yet collected. The owner should not read the net figure as safety.
Red flags to act on
- Estimated gross profit dropping month after month on the same job.
- Cost to complete unchanged for several months while cost to date climbs.
- Under billing that grows each month with no change order or billing explanation.
- Total over billing higher than cash on hand plus receivables due in 30 days.
- Jobs disappearing from the report at substantial completion while retainage and warranty costs are still open.
- A job whose estimated total cost exactly equals its original budget at 70 percent complete.
How banks and sureties read your WIP
Outside readers look for consistency more than any single number. They compare this quarter's WIP with the last one and with the closed-job schedule, asking whether jobs finish at the margin they showed midway through. A contractor whose jobs gain margin at the end is usually forecasting conservatively. One whose jobs lose margin at the end is forecasting optimistically, and the underwriter will discount every open job on the current report to match. They also compare total underbilling with working capital, since underbillings are an asset that may never turn into cash. Clean, consistent WIP reports are one of the simplest ways to support a larger bonding line.
Mistakes people make reading WIP reports
- Reading overbilling as profit. It is a liability: you owe the work.
- Reading underbilling as a sign the PM is being conservative. More often, something is unbilled or over budget.
- Looking only at this month. WIP is a trend tool, so keep at least three months side by side.
- Including unapproved change orders in contract value but not the matching costs, or the other way around.
- Letting the bookkeeper fill in cost to complete. The PM knows the job; the PM should sign the forecast.
Templates and related guides
Build your own schedule with the WIP report template, and feed it from the job cost report template. For the math behind the forecast column, see how to calculate cost to complete on a construction job, and for the billing column, overbilling and underbilling explained with examples. Sureties also lean on WIP when setting bond capacity.
Smart Business Automator builds the WIP view from live job costs, commitments, and billings, and keeps prior months alongside so fade stands out. Learn more about job costing and WIP automation.
Frequently asked questions
How often should a contractor run a WIP report?
Monthly is the norm, after job costs are posted and pay apps are out. Many contractors also review the underlying cost to complete weekly so the monthly WIP holds no surprises.
Is overbilling good or bad on a WIP report?
Neither by itself. Modest overbilling on a well-run job helps cash flow. Large overbilling, or overbilling the company has already spent, means the end of the job will need cash with little billing left to cover it.
Why do sureties care so much about the WIP report?
It shows whether jobs are making the profit that was bid, whether forecasts move over time, and whether the company is funding work with customer cash. Those trends say more about risk than a year-end income statement.
What is margin fade on a WIP report?
Fade is a drop in a job's projected gross profit from one report to the next. Steady fade usually means the cost to complete was understated earlier. See how to find margin fade on construction projects.
Who prepares the WIP report?
The bookkeeper or controller usually assembles it, but project managers supply the estimated cost to complete for each job, and the owner reviews it before it goes to the bank or surety.
