WIP Reports in Construction

What Is a WIP Report in Construction?

A work in progress (WIP) report is a financial statement that compares each active construction project’s costs, billings, and earned revenue to show whether the job is on budget, properly billed, and holding its estimated margin.

Construction accounting has a timing problem that most industries never face. You spend money on a job for months (sometimes years) before the final payment arrives, and standard financial statements can’t tell you how those open jobs are performing. The WIP report solves this. It applies percentage-of-completion accounting to every active project, converting raw job cost data into a snapshot of earned revenue and projected margin.

For a CFO or controller, the WIP report answers the questions a P&L can’t:

• Which jobs are ahead or behind on margin?
• Are we billing faster or slower than we’re earning?
• What will this project do to our cash position next month?

The report also matters well beyond the finance office. Sureties review WIP schedules before setting bonding limits, and lenders request them before extending credit. Auditors rely on them to confirm that revenue recognition matches the work performed. And of course project managers use them to spot cost problems while a fix is still possible.

Disciplined WIP reporting gives leadership a live read on the financial health of the entire project portfolio and catches margin problems while there’s still time to act. Without it, margin surprises arrive at closeout when nothing can be done.

WIP Report vs. WIP Schedule: Is There a Difference?

The two terms overlap and most contractors use them interchangeably.

Strictly speaking, the WIP schedule is the document itself: a line-by-line listing of every open job with its contract value, costs, billings, percent complete, and over/underbilling position. It’s the format sureties and lenders request, usually quarterly.

The WIP report is the broader analysis built on that schedule: variance trends, margin gain and fade, and the commentary that explains what the numbers mean.

If your surety asks for a WIP schedule, they want the standardized job listing. But if your CFO asks for a WIP report, they want the story behind it.

What Information Does a WIP Report Track?

A complete WIP report tracks seven core components for every active job:

Why WIP Reports Are Non-Negotiable for Construction Contractors

The case for disciplined WIP reporting is risk, plain and simple. FMI’s 2025 Project Management Study found that only 2.5 percent of contractors report projects consistently finishing on time and on budget. That means nearly every contractor is carrying jobs right now that are drifting from their estimates, and the WIP report is the instrument that shows how far.

The stakes are asymmetrical. A construction project caps how much profit you can earn, but there’s no floor on what you can lose. In its research on why large contractors fail, FMI found that failing firms usually exhibit a combination of interacting factors rather than one fatal blow, and that the difference between a bad year and a catastrophic one can come down to one or two jobs due to inadequate capitalization.

Margins leave little cushion for that kind of surprise. Global construction profit margins averaged around 7 percent, according to the Turner & Townsend 2024 International Construction Market Survey. At 7 percent, a 2-point fade on a $10 million job erases $200,000 — the entire profit on a roughly $2.9 million project. WIP reporting exists to catch that fade before it’s too late.

Cash Flow Forecasting and Project Profitability

WIP data is the raw material for reliable cash flow forecasting because it connects billing position to actual work performed. You might find yourself in one of two situations.

Overbilling creates false profit signals. A job billed $75,000 ahead of earned revenue makes this month’s cash position look healthy, but that $75,000 belongs to future costs on that same job. If you treat it as profit and spend it, your project runs out of funding before it runs out of work.

Underbilling creates a cash drain. A job that has earned $600,000 but billed only $540,000 is financing $60,000 of the owner’s project out of your working capital, interest-free. Multiply that across 10 open jobs and the company is quietly lending its owners half a million dollars.

The drain compounds with slow collections. The construction industry runs a median of 83 days sales outstanding — the longest of any industry, according to PwC data published by Construction Financial Management Association — well above the 45 Days Sales Outstanding benchmark that’s considered healthy. When billings already lag earned revenue, a 90-day collection cycle stretches the gap between spending and receiving to the breaking point.

Bonding Capacity and Lender Confidence

The WIP schedule is the first document your surety reads. Most contractors underestimate how much weight it carries. Sureties typically require WIP schedules quarterly, and they read them the way a bank reads a credit report: for evidence of project control.

Consistent margin gain (jobs finishing at or above bid margin) tells the surety your estimating and execution are sound, which supports higher bonding limits and the capacity to pursue larger work.

Repeated fade tells the opposite story. A pattern of jobs that start at 12 percent margin and close at 7 raises red flags that can shrink your bonding program, and with it, the size of projects you’re allowed to chase. Lenders apply the same lens to credit lines: heavy underbillings relative to equity suggest the balance sheet overstates the company’s real position, and sophisticated lenders will ask why.

Revenue Recognition Compliance (ASC 606, GAAP, IFRS)

WIP reporting is how contractors comply with percentage-of-completion revenue recognition. Accounting rules (ASC 606 under U.S. GAAP, and IFRS 15 internationally) require contractors to recognize revenue gradually as work is completed, in proportion to costs incurred against the total expected cost. That’s the exact calculation a WIP report performs, which means your WIP report is your revenue recognition compliance.

The over- and underbilling figures flow directly to the balance sheet as “billings in excess of costs and estimated earnings” (a liability) and “costs and estimated earnings in excess of billings” (an asset). If the WIP report is wrong, the financial statements are wrong, and that’s a problem auditors, sureties, and lenders will all eventually find.

How to Read a WIP Report: Key Components Explained

The fastest way to learn WIP mechanics is to walk one job through the whole report. So here’s the running example this section and the next will use: a $1 million commercial tenant improvement project, tracked from contract award through its current billing cycle.

Contract Value and Estimated Costs to Complete

Our example project was awarded at $950,000. Two months in, the owner executed a $50,000 change order for added electrical scope, bringing the current contract value to $1,000,000. The estimating team projects a total estimated cost at completion (ECAC) of $850,000, which puts projected gross margin at $150,000, or 15 percent.

Two rules keep these numbers honest. First, only executed change orders belong in contract value. Verbal approvals and pending PCOs don’t belong on a financial statement. Second, ECAC has to be a living number. If steel rebids come in high or labor productivity slips, the ECAC must move with reality. An ECAC frozen at the original estimate makes every downstream metric fiction.

Change orders deserve real-time tracking for a simple reason: a change order shifts contract value, percent complete, earned revenue, and the billing position all at once. Book it 45 days late and the WIP report has been wrong for 45 days.

Costs Incurred to Date

Our project has booked $510,000 in costs to date: field labor and burden, materials, subcontractor invoices, equipment charges, and the job’s share of indirect costs.

That last category is where most WIP reports go wrong. Direct costs get captured because someone has to pay the invoice. Indirect costs (equipment ownership, small tools, insurance, project management time) get overlooked or allocated once a quarter.

If left out, you’ll have two problems: percent complete reads lower than it is, and projected margin reads higher than it will be. Both errors flatter the job right up until closeout, when the truth arrives.

Timing matters as much as completeness. A subcontractor invoice entered three weeks after the work happened means the WIP report spent three weeks understating percent complete. To act on a WIP report, you need real-time cost capture from the field, rather than month-end batch entry.

Percentage of Completion

Under the cost-to-cost method, the most common approach, percent complete equals costs incurred divided by ECAC. For our project: $510,000 ÷ $850,000 = 60 percent complete.

Two alternatives exist. Both are legitimate, but cost-to-cost dominates because the inputs already live in the accounting system. The units-of-work method measures physical output (linear feet installed, cubic yards placed) against total scope, and it fits repetitive, measurable work. The milestones method recognizes completion at defined stages.

Percent complete drives everything downstream, which is exactly why the most common WIP failure is so damaging: the project manager and the accounting team calculating it differently. The PM walks the site and calls the job 75 percent done based on physical progress. Accounting runs cost-to-cost and gets 60 percent. Both can be right in their own frame, and the 15-point gap usually means one of two things: costs are hitting the books late (accounting is behind), or the ECAC is understated and the remaining work will cost more than anyone has admitted (the PM is optimistic).

Either way, the gap itself is the finding. Companies that reconcile PM and accounting percent complete every month catch cost problems a full reporting cycle earlier than companies that don’t.

Earned Revenue vs. Billed Revenue

Earned revenue is percent complete applied to contract value. Our project: 60 percent × $1,000,000 = $600,000 earned.

Now the comparison that makes the WIP report worth building. The project has billed $675,000 to date, thanks to a front-loaded schedule of values. Billed minus earned: $675,000 − $600,000 = $75,000 overbilled. That $75,000 sits on the balance sheet as a liability (billings in excess of costs and estimated earnings), because the company has collected for work it hasn’t performed yet.

Had the numbers run the other way, say $540,000 billed against $600,000 earned, the job would be $60,000 underbilled, recorded as an asset (costs and estimated earnings in excess of billings). Modest, deliberate overbilling is standard practice and healthy for cash flow. Large or unexplained positions in either direction deserve scrutiny.

How to Calculate WIP: Step-by-Step Formula

Every input should come straight from your accounting system and executed contracts. Here’s the process, followed by the complete example for our imaginary project.

First, gather your five core inputs and make the calculations using the formulas below: original contract value, executed change orders, estimated cost at completion, costs incurred to date, and billed to date.

1. Revised (current) contract value: original contract + executed change orders.
2. Estimated total cost at completion (ECAC): costs to date + estimated cost to complete.
3. Percent complete: costs incurred to date ÷ estimated cost at completion (multiply by 100 for a percentage).
4. Earned revenue: percent complete × revised contract value.
5. Over/underbilling position: billed to date − earned revenue. A positive result is overbilled; a negative result is underbilled.
6. Estimated gross profit: revised contract value − estimated total cost.

Be sure to adjust the financial statements: post overbillings as a current liability and underbillings as a current asset, and recognize revenue at the earned amount rather than the billed amount.

WIP Calculation Example: $1 Million Commercial Project

Reading the result operationally, a positive (overbilled) position means billing is ahead of production. Cash is strong, but the finance team should hold that $75,000 against the roughly $340,000 of cost still to come rather than treating it as available profit.

A negative (underbilled) position means production is ahead of billing. The immediate move is to bill for the earned work and find out why the gap exists, because chronic underbilling usually traces back to unexecuted change orders or a billing process that can’t keep pace with the field.

Overbilling vs. Underbilling: What Each Means for Your Business

WIP Gain and Fade: What It Is and Why It Matters

WIP gain means a job’s projected margin is improving against the original estimate. WIP fade means it’s eroding. Sureties track both, job by job, across your reporting history, and the pattern matters more than any single project.

Occasional fade is normal; construction is uncertain work. What sureties and lenders penalize is systematic fade: jobs that reliably close below bid margin, which points to estimating problems, execution problems, or a WIP process that hides bad news until closeout.

Gain has its own caution flag. A contractor whose jobs consistently close far above bid margin may be sandbagging estimates, which distorts the balance sheet in the other direction.

What Causes WIP Fade?

Fade almost always traces to one of a handful of root causes:

• Uncaptured indirect costs — equipment, insurance, and supervision time that never hit the job, so ECAC was understated from the start
• Scope creep without change orders — the field performs added work on verbal direction while contract value stands still
• Late expense entry — subcontractor and material invoices booked weeks behind the work, making early percent complete look better than it was
• Optimistic percent complete estimation — ECAC held at the original estimate long after field conditions said otherwise
• Buyout losses — trade packages contracted above the estimated cost, locking in erosion before the first crew mobilizes

Detect Fade Early With Real-Time Dashboards

Every cause on that list shares a trait: it’s invisible in a monthly spreadsheet and obvious in live data. This is where business intelligence changes the WIP conversation. ContractorBI™, TopBuilder’s analytics platform built for construction finance teams, pulls job cost actuals from your ERP continuously and compares them against estimates across every open job, by project, division, estimator, or cost code.

When labor hours on a mechanical package start outrunning production, the variance surfaces on the dashboard that week, while the response options still include reassigning crews or expediting a change order. By the time the same variance reaches a month-end spreadsheet, the only option left is documenting the loss.

ContractorBI also tracks gain and fade trends across job types, so you can see whether fade concentrates in a particular division, customer, or category of work and fix the pattern instead of the symptom.

Common WIP Report Mistakes and How To Avoid Them

Most WIP failures come from process, and every one has a fix.

Mistake 1: Treating WIP as a Monthly Chore, Not a Daily Tool

The month-end WIP scramble produces a report that’s stale before leadership reads it. Costs from the last week of the month slip into the following period, so percent complete describes a job site that existed 30 days ago.

The fix: Stop saving WIP for month-end. Get field logs posting job costs daily, and have PMs review cost-to-complete once a week. When the data flows in continuously, the month-end schedule just confirms what you already knew.

Mistake 2: PM and Accounting Percent Complete Misalignment

The PM says 75 percent, but accounting says 60 percent. Both numbers walk into different meetings, and now the company is running two sets of books without meaning to. Usually the culprit is costs posting late or an ECAC no one has touched since the estimate — but until someone reconciles the two, leadership can’t trust either number, which means they can’t trust the report.

The fix is a standing monthly reconciliation against one shared dataset. PMs sit down with accounting’s actuals, explain any material gap in writing, and revise the ECAC when the explanation says the remaining work will cost more.

Mistake 3: Ignoring Change Orders Until Month-End

A change order moves contract value, and contract value moves everything: percent complete, earned revenue, the billing position. If change orders sit unlogged for three weeks, the WIP report will be wrong for three weeks. Meanwhile, the field keeps performing the added work, and that work piles up as underbilling or as scope you never get paid for.

Log change orders the day they occur and track them by status: pending, submitted, or executed. Where the contract allows it, don’t let crews start change order work until the paperwork is signed. Once it is, the new contract value belongs in the WIP report that same day.

Mistake 4: Not Linking WIP to the P&L and Balance Sheet

We’ve discussed how overbilling is a liability and underbilling is an asset. A WIP spreadsheet that never reconciles to the general ledger misstates both, and it means revenue is being recognized on what you billed rather than what you earned. Your auditor will find this. So will your lender, probably during a renewal.

The fix is boring and non-negotiable: post the over/underbilling adjustment as part of every close, and tie the WIP schedule to the balance sheet accounts before the numbers go anywhere near the bank or the surety.

Mistake 5: Relying on Excel for Multi-Project WIP

An Excel spreadsheet handles two jobs fine, but not 20. Formulas can be overwritten and no one notices. Plus, nothing feeds from the ERP, so someone re-keys costs by hand, and when a number changes there’s no record of who changed it or why. The whole report now depends on the one person who understands the spreadsheet.

The graduation point is when you’re running WIP across multiple concurrent jobs, divisions, or entities. That’s when the calculation belongs in a system that pulls job cost data from the ERP on its own. This is what ContractorBI does, assembling the WIP schedule from live actuals rather than copied cells.

How Often Should You Run WIP Reports?

Monthly is the minimum for every contractor using percentage-of-completion accounting. Weekly is the standard for active, high-risk, or high-value projects. And a fresh WIP schedule should precede every bonding renewal, lender review, and major draw request.

The right cadence follows from how fast conditions change. For example:

• A $200,000 job with a two-month duration can’t afford a monthly-only review, because the whole project happens inside two reporting cycles.
• A portfolio with heavy self-perform labor needs weekly reads on productivity-driven cost codes.
• Any job already showing fade belongs on a weekly watch list until the trend reverses.

Why Switch From Spreadsheets to Real-Time WIP?

There are many reasons why you should switch from managing WIP in Excel, but perhaps the most obvious is it just can’t handle your data load.

Construction generates enormous volumes of job cost data, and FMI estimates that 96 percent of it goes unused. On top of that, research from Autodesk and FMI attributes an estimated 14 percent of all construction rework to bad data. This includes missing, inaccurate, wrong, duplicate and poor quality data. A WIP process built on manual re-entry inherits all those defects.

Manual WIP is also a time suck and a money drain. The 2025 Intuit construction technology trends report found that 75 percent of construction decision-makers say they spend too much time managing data because of disconnected tech stacks.

And construction leaders say that consolidating to a uniform data environment would save them roughly 10.5 hours per week, according to Deloitte’s State of Digital Adoption in the Construction Industry.

What Integrated WIP Reporting Looks Like

A connected workflow replaces month-end scrambles with a pipeline that runs itself. Because ContractorBI shares data with TopBuilder CRM and bid management, the same platform can connect WIP performance to pipeline and revenue forecasting. Here’s what happens when you set it up.

Job cost data flows from the ERP automatically. ContractorBI connects directly to Sage 100 Contractor, Sage 300 CRE, Sage Intacct Construction, Viewpoint Spectrum, Acumatica, and Procore, so labor, material, subcontractor, and committed costs arrive without re-entry. TopBuilder’s Construction Data Services handles the initial unification: loading, cleaning, and reconciling records across systems.

Percent complete and earned revenue calculate automatically. The platform applies cost-to-cost math to live actuals, so the WIP schedule always reflects the most recent data.

The WIP dashboard updates in real time. Every open job’s contract value, costs, billings, percent complete, and over/underbilling position sits in one view, with drill-down by job, division, estimator, or cost code.

Finance reviews variance, then acts. Margin fade, billing gaps, and unexecuted change orders surface as exceptions. Adjustments post back through the normal close process, and bonding-ready schedules export on demand.

Features To Look for in WIP Reporting Software

Whatever platform you evaluate, the checklist below separates tools that automate WIP from tools that just display it. The contrast with generic BI tools is worth understanding before you commit: this breakdown of the hidden costs of Power BI for construction covers why blank-slate platforms struggle with construction job cost structures.

WIP Reports for Specialty Contractors

Most WIP guidance is written for general contractors, but specialty contractors (mechanical, electrical, plumbing, HVAC, roofing) carry two WIP challenges that GC-oriented advice skips.

1. Tracking Equipment Costs in WIP

For equipment-heavy trades, equipment is typically the largest cost after labor, and it’s the cost category most likely to leak out of the WIP report. Fuel, maintenance, rental fees, mobilization, and ownership costs (depreciation, insurance, storage) often sit in overhead accounts or fleet ledgers instead of hitting the job.

If equipment costs never reach costs incurred to date, the cost-to-cost calculation understates percent complete, which understates earned revenue and overstates projected margin.

What to do instead: Charge every machine hour to the job it worked on, at a rate that covers the full cost of owning and running that machine. Pull the hours from field logs or telematics as they happen. Contractors who start doing this often find their real margins run several points below what they thought.

2. Multi-Trade Jobs and Performance Obligations

ASC 606 requires revenue to be recognized per performance obligation, and for a specialty contractor running combined scopes (say, plumbing, mechanical, and electrical under one contract), that can mean separate percent complete tracking for each distinct obligation rather than one blended number for the job.

The problem is blended tracking hides the information a finance leader needs. A combined job reading 65 percent complete might be a 90 percent complete mechanical scope carrying a 40 percent complete electrical scope that’s bleeding labor.

Structuring WIP by obligation (or at minimum by trade-level cost codes that roll up cleanly) keeps revenue recognition compliant and gives PMs a margin read on each scope.