How to Read a Construction WIP Report (A Non-Accountant's Guide)

A Work-in-Progress (WIP) report is the single most important financial document a contractor produces. It is also the one most commonly misunderstood, left to the accountant to interpret, or generated reactively when a banker asks for it. If you own or operate a construction company, knowing how to read your own WIP schedule without needing a translation gives you a genuine operational edge.

This guide explains every column in plain language, walks through a realistic example, and tells you what to look for when something appears off.

What a WIP Report Actually Is

The WIP report is a snapshot of every open job on your books. It shows how much revenue you have earned based on actual project progress versus how much you have invoiced the client. The gap between those two numbers, whether positive or negative, is one of the strongest indicators of your business's near-term financial health.

Most contractors think of WIP as an accounting document the bookkeeper generates each month so the right journal entries get posted. It is much more than that. A properly maintained WIP schedule tells you whether your jobs are running to budget, whether your cash position is about to tighten, and whether your reported profit this month reflects real economic progress or a timing artifact from aggressive billing.

Bankers, bonding agents, and potential acquirers all request WIP schedules because they tell the story that financial statements cannot. A contractor can show strong profits on a P&L and be financially stressed on a WIP. Understanding how to read that report yourself is a core competency for any contractor serious about running a profitable company.

The Seven Columns in a WIP Report

Regardless of the software generating it (QuickBooks, Sage, Procore, Viewpoint, or a spreadsheet), most WIP reports share the same core structure. Here is what each column means in plain language:

Contract Value (Revised Contract Amount). The total agreed price for the project, including all approved change orders. This is your job's top-line revenue target.

Estimated Total Cost. Your projected total cost to complete the job from start to finish, including costs already incurred and costs still ahead. This number must be updated monthly as conditions change.

Costs Incurred to Date. Total direct job costs posted through the reporting date: labor, materials, subcontractors, equipment, and any other costs coded to that job.

Percent Complete. The central calculation in WIP reporting. It equals costs incurred to date divided by estimated total cost. This single number drives every other calculated column on the report.

Earned Revenue. Contract value multiplied by percent complete. This is the revenue you have mathematically earned based on how far the job has progressed, regardless of what you have actually invoiced.

Billed to Date. The total dollar amount you have invoiced the client through the reporting date.

Over/(Under) Billed. Earned revenue minus billed to date. A positive number means you have done more work than you have collected for (underbilled). A negative number means you have collected more than you have earned (overbilled).

Sample WIP Schedule

Here is what a simplified WIP report looks like for a mid-size general contractor with four active jobs:

Reading this table at a glance: the Parking Structure job is $150,000 overbilled (the contractor has collected more than they have earned based on progress). The Retail TI is $56,250 underbilled (the work has been done but not yet invoiced). The Office Buildout is $50,000 overbilled. The Warehouse Expansion is $50,000 underbilled. Overall, this contractor is net overbilled by $93,750 across their portfolio, meaning they have collectively billed $93,750 more than they have earned.

How Percent Complete Gets Calculated

The standard approach is the cost-to-cost method:

Percent Complete = Costs Incurred to Date / Total Estimated Cost

For the Warehouse Expansion above: $720,000 / $960,000 = 75.0% complete.

This method works well when your cost estimates are accurate and current. The problem is that percent complete is only as reliable as the estimate underneath it. If you originally budgeted $960,000 for that warehouse job but unforeseen structural conditions are going to push the final cost to $1,100,000, your calculation is wrong. At $720,000 spent against a $1,100,000 revised estimate, you are actually 65.5% complete, not 75.0%. That 9.5-point difference reduces earned revenue from $900,000 to $786,000, creating a roughly $114,000 swing in the reported position for that single job.

This is why updating your cost-to-complete estimate every month matters. A WIP report built on estimates from six months ago tells you a story that no longer exists. Project managers need to provide fresh estimates of remaining costs for every active job at the time of each monthly close, not just when billing goes out.

Some contractors use physical completion percentages rather than cost-to-cost, particularly on jobs with cost profiles that do not track progress linearly. A job with heavy early material procurement and labor-intensive finish work late may show inflated early progress under cost-to-cost. Whichever method you use should reflect your billing profile and be applied consistently across all jobs.

Understanding Overbilling and Underbilling

This is the concept that most non-accountants find confusing. Here is the simplest way to think about it.

Overbilling means you have invoiced your client more than you have mathematically earned. In the Parking Structure example, the contractor has billed $1,700,000 but only earned $1,550,000 based on 50% completion. The $150,000 difference sits on the balance sheet as a liability called "billings in excess of costs" (or "contract liabilities" under ASC 606 terminology). It represents a future performance obligation: the contractor still owes the client $150,000 worth of work.

Overbilling feels good in the short term because you have cash in hand. But it carries real risk. If the job stalls, or if the client disputes completion, you may need to return or work off that cash. Consistent heavy overbilling on the same jobs month after month is a pattern worth investigating. It can indicate front-loaded billing schedules, optimistic progress estimates, or underlying job problems being papered over with cash.

Underbilling means you have done the work but have not invoiced for it yet. The $56,250 on the Retail TI sits as a current asset on the balance sheet called "costs in excess of billings" (or "contract assets"). It is real value you have created and is theoretically collectible. The risk is that you are financing your client's project with your own working capital.

Chronic underbilling is one of the most common causes of the pattern where jobs look profitable on paper but the bank account stays stubbornly thin. You have earned the revenue; you just have not collected it yet. In cash flow terms, uncollected earned revenue has the same effect as lost revenue in the near term. Our article on why your jobs look profitable but your bank account disagrees covers this dynamic in detail.

A healthy portfolio has a roughly balanced overbilling and underbilling position, with neither a large persistent overbill nor a large persistent underbill across the full job mix. Small amounts of either are normal. Large persistent imbalances are signals worth investigating.

Red Flags That Should Trigger Closer Review

Once you understand the columns, you can spot problems that a P&L will not show you for another 30 to 60 days. These patterns warrant immediate investigation:

Declining projected margins month over month. If a job was bid at 18% gross margin, showed 15% at the 30-day review, and is now at 11%, the job is fading. Catching that trend at 11% gives you a chance to act on subcontractor costs, scope creep, or crew productivity. Catching it at 3% when 90% of the work is done does not. The article on profit fade in construction covers the mechanics in detail.

Jobs with 90%+ costs spent but less than 85% earned revenue. This mismatch usually means the cost-to-complete estimate is still showing the original budget rather than a realistic revised figure. Something is being ignored in the estimate, and the true job margin is worse than reported.

Persistent overbilling on the same job for multiple consecutive months. Some front-loading is normal. But if the same job has been $400,000 overbilled for three straight months while costs keep accumulating, there is a structural issue with either billing practices or job execution.

Cost-to-complete estimates that have not changed in 60 days. Active jobs have evolving conditions. A static estimate for two months almost certainly means nobody is actually re-estimating. The WIP is being maintained as a compliance document, not a management tool.

A net overbilled portfolio position that keeps growing. If aggregate overbillings consistently exceed underbillings by a widening margin, current revenue may be propped up by prior-period billings. When those jobs complete, revenue recognition can drop sharply without a corresponding change in business activity.

How WIP Connects to Your Balance Sheet

The WIP report does not exist in isolation. It directly populates two balance sheet line items that lenders and bonding agents examine closely.

Costs in excess of billings (underbillings) appears as a current asset alongside accounts receivable. Surety underwriters typically treat this as high-quality working capital because it represents earned revenue that is collectible under existing contracts.

Billings in excess of costs (overbillings) appears as a current liability. A surety underwriting your bonding capacity will look at this number carefully. For a $5M general contractor, a bonding agent would generally want to see overbillings no greater than 10 to 15% of total open contract value, with underbillings backed by billing schedules that convert to cash within 60 to 90 days. If your balance sheet shows $2M in billings in excess of costs on $8M of open contracts, that is a conversation you need to be prepared for. Our construction bonding readiness guide covers exactly what sureties analyze when they look at a WIP schedule.

For the contractor in our sample table, the $93,750 net overbilled position is a relatively small percentage of $5.575M in total contract value (about 1.7%). That is manageable. If that number were $600,000 or $900,000 and concentrated in one or two jobs, the story would be different.

Using WIP Data for Cash Flow Forecasting

The WIP report is backward-looking by nature, but it is one of the most useful inputs for forward-looking cash planning.

For each underbilled job, your earned revenue is already sitting on the balance sheet as a current asset. Look at the billing schedule for each underbilled job and identify when the next application for payment will go out. That cash is likely collectible within 30 to 60 days and should appear as a near-term inflow in your cash projection.

For each overbilled job, examine the remaining cost-to-complete. That is future cash outflow with no offsetting new billing until the overbill is worked down. A contractor with $500,000 in aggregate overbillings and $350,000 in remaining costs to complete on those jobs needs to spend $350,000 before those jobs generate another dollar of invoice.

Netting underbillings (near-term cash in) against overbilled remaining costs (near-term cash out) across your portfolio gives you a materially more accurate picture of the next 60 days than looking at your bank balance alone. For a complete methodology on turning WIP data into a rolling cash forecast, the cash flow forecasting guide walks through exactly that process.

Common Mistakes Contractors Make with WIP

The WIP report is only as good as the inputs behind it. These are the most common places where accuracy breaks down:

Not updating cost-to-complete estimates monthly. If project managers provide revised estimates twice a year, your WIP is wrong 10 months out of 12. This is the single biggest source of unreliable reporting in construction accounting.

Using original budgets after change orders are approved. An approved change order that adds $80,000 to a job's scope needs to be reflected in both the contract value and the revised cost estimate. If only the top line is updated, percent complete is overstated and earned revenue is inflated.

Treating WIP as an accounting chore rather than a management tool. The contractors who get the most value from WIP reporting review it in a monthly meeting with their project managers, using it as a job health scorecard. Those who generate it solely because their banker requests it get no operational benefit from the process.

Leaving substantially complete jobs open. Jobs sitting at 95% or 98% completion that have not been formally closed distort your portfolio totals and make aggregate metrics harder to read. Close jobs promptly when they are substantially complete and final billing is processed.

Inconsistent overhead allocation across jobs. If overhead is applied unevenly, job margins are unreliable, and trend analysis across jobs becomes meaningless. This problem usually traces back to how the construction chart of accounts is structured and whether the allocation methodology is applied consistently.

How Often to Update WIP and Who Should Be Involved

Monthly is the minimum for any contractor above $2M in annual revenue. For companies above $10M or those with complex multi-year projects, the WIP cycle should be tied directly to the monthly billing cycle: costs closed for the period, estimates revised by project managers, report generated, reviewed before the month-end close is finalized.

The review should involve more than the bookkeeper. Project managers need to provide fresh cost-to-complete numbers. The owner or CFO should review job-level margins and flag any job where projected gross margin has moved more than 3 percentage points since the prior month. Any job meeting that threshold should be discussed before numbers are locked into the books.

For a company that has been running WIP reporting as a reactive exercise, moving to a monthly review cadence takes two or three cycles to get right. The first month surfaces the backlog of stale estimates. The second month catches the adjustments. By the third month, the report starts telling you things you did not already know.

If you are building this process from scratch or your current WIP workflow is not producing reliable data, the team at Northstar works specifically with construction companies to design reporting systems that project managers will actually maintain and that produce information owners can act on.

What to Do When the Numbers Do Not Make Sense

Sometimes you will pull a WIP report and a job will show results that feel wrong. A straightforward remodel is showing 3% gross margin when you bid it at 17%. A job looks 70% done on-site but the report says 45% complete. Here is the diagnostic sequence:

First, verify the cost-to-complete estimate. It is almost always the source of the discrepancy. Get the superintendent on the phone and build a fresh estimate-to-complete from scratch, ignoring what the system currently shows.

Second, check whether all costs have been coded to the job. Missing subcontractor invoices, materials billed to overhead instead of the job, or payroll coded to the wrong cost code will all distort the numbers without leaving an obvious trail.

Third, verify the contract value. Have all approved change orders been added to the revised contract amount? A change order that has been performed but not yet formalized will create an apparent overbilling even when the billing itself is legitimate.

Fourth, confirm the billed-to-date figure. Has the most recent application for payment been entered in the system? If the last billing was processed by accounts receivable but not yet reflected in the WIP report, the overbilling and underbilling positions will both be wrong.

Most WIP discrepancies trace back to one of these four causes. A systematic monthly review with project managers will catch them before they accumulate into larger misstatements that affect reported income and balance sheet quality.

Conclusion

Reading a WIP report confidently comes down to four things: understanding what percent complete actually measures and whether the estimate behind it is current; knowing what overbilling and underbilling mean for near-term cash; identifying any jobs showing margin deterioration that warrants intervention; and assessing whether the aggregate portfolio position is healthy relative to bonding capacity and working capital needs.

A WIP report that is updated monthly, reviewed with project managers, and connected to a rolling cash forecast is one of the most powerful tools available to a contractor. A WIP report generated reactively the night before your banker calls is just noise that consumes everyone's time.

The Northstar construction team works with contractors at every revenue level to build reporting systems that actually get used. If you want a second set of eyes on your current WIP process, reach out for a review.