top of page
Search

Work-in-Progress (WIP) Reporting in Construction:The Complete Guide to Profitability, Cash Flow, and Risk Control

  • luanadorfman
  • Apr 17
  • 8 min read

 

Most contractors don't lose jobs because they're bad builders. They lose margin — and sometimes the entire business — because their financial tracking didn't keep up with what was happening in the field.

WIP reporting is the connective tissue between your job site and your bank account. When it works, you always seem to know where you stand. When it breaks down, you find out the hard way: on a job you thought was profitable, right before payroll.

This guide cuts through the noise on WIP accounting — from the core mechanics to the mistakes that quietly kill margins — and shows how modern construction finance teams are replacing slow, error-prone spreadsheets with real-time visibility.

 

Why WIP Reporting Exists — And What Breaks Without It



Construction finance is fundamentally different from almost every other industry. Projects last months or years. Billing happens in draws. Costs hit unevenly. Revenue is delivered progressively, not all at once.

That creates a core accounting challenge: when do you actually recognize revenue? The answer — under both GAAP and basic business logic — is as you earn it, proportional to how much work is actually complete. That's exactly what WIP accounting does.


What goes wrong when companies skip it

•        Overbilled jobs look profitable until uncompleted work eats the margin

•        Underbilled jobs create phantom losses that hide real performance

•        Cash flow crises hit without warning because billing ran ahead of cost control

•        Year-end tax surprises emerge because income was misreported all year

•        Sureties and lenders lose confidence — and tighten credit lines

 

The hard truth

Over 60% of construction company failures involve some form of financial reporting breakdown — most often inaccurate job cost tracking or delayed recognition of project losses. WIP reporting is the most effective control against this risk.

 

 

The Core Mechanics: Completion, Overbillings, and Underbillings


Percentage of completion: how revenue is actually earned

The percentage-of-completion (POC) method is the accounting engine behind every WIP report. The principle is simple: you recognize revenue in proportion to how much of the project is finished. The most reliable way to measure that is the cost-to-cost method:

 

Percent Complete  =  Costs Incurred to Date  ÷  Total Estimated Cost

Earned Revenue    =  Percent Complete  ×  Total Contract Value

Over / Underbilling   =  Billings to Date  −  Earned Revenue

 

Overbillings: cash now, obligation later

An overbilling occurs when you've invoiced more than you've actually earned. On the surface, it looks great — cash in hand. But it represents a real liability. You've been paid for work you haven't done. If cost overruns or scope disputes emerge, that money may need to be returned or applied forward.

Sureties and experienced lenders view large, consistent overbillings with skepticism. They often signal aggressive billing, poor cost forecasting, or a business that's borrowing from future jobs to fund today's overhead.


Underbillings: earned but not collected

An underbilling means you've done the work but haven't invoiced for it yet. It shows up as an asset on your balance sheet — but it's not cash. Chronic underbillings are a red flag that often points to billing process breakdowns, unresolved contract disputes, or overly optimistic cost estimates that made the job look further along than it really is.


The number nobody talks about enough: estimated cost to complete

Your WIP is only as good as your estimated cost to complete (ETC). Every calculation flows from this projection. If it's stale or optimistic — because a subcontractor is behind, a change order is still unsigned, or weather ate two weeks of productivity — your entire WIP report is wrong.

This is why WIP can't live exclusively in the finance department. Project managers have to own their cost projections. The field and finance have to be speaking the same language, updated on the same cycle.

 

WIP and Cash Flow: The Connection Most Contractors Miss


Here's something that surprises a lot of contractors: you can have strong WIP — solid margins, accurate completion percentages — and still be cash-strapped. How?

Because profit and cash are not the same thing. WIP measures earned revenue. Cash flow depends on when you collect that revenue and when you pay your costs. A job that's 60% complete but only 40% billed has a real cash gap. You've spent the money. The invoice hasn't gone out.


The construction cash cycle is brutal

•        You pay labor and materials upfront or on 30-day terms

•        You complete work and submit a payment application

•        The owner reviews and approves — often 30 to 60 days later

•        Payment arrives, sometimes 90 to 120 days after the cost was incurred

•        And retainage — that 5 to 10% withheld from every draw — doesn't come back until the very end

 

Cash flow tip

One of the fastest ways to improve cash flow without adding revenue: accelerate your billing cycle. If your payment apps go out on the 25th but your contract allows submission on the 1st, you're leaving 3 to 4 weeks of float on the table every month. On a $10M contract, that's real money.

 

Using WIP to actually forecast cash

When your WIP data is accurate and timely, you can build a cash flow forecast that reflects your real project portfolio — not just last Tuesday's bank balance. Combine your estimated cost to complete (when will costs hit?) with your billing schedule (when do invoices go out?), apply your historical collection lag, and layer in retainage release dates for jobs nearing completion.

Companies that do this don't get surprised. They see the cash gap coming three months out — with time to draw on credit, accelerate billings, or defer discretionary spend.

 

The 5 WIP Mistakes That Quietly Kill Margins


1. Not updating cost estimates regularly

PMs who update their cost-to-complete once a quarter are giving finance stale data. By the time the real numbers surface, there's no runway to respond. Build a formal monthly review where project managers update their ETC against actual spend — and make it a cultural expectation, not an optional exercise.


2. Confusing billings with revenue

If you're recognizing revenue when you send an invoice rather than when you earn it, your income statement is wrong — sometimes dramatically. Implementing percentage-of-completion accounting feels like more work upfront. But over any significant period, it tells you the truth about your business in a way that billing-based recognition never will.


3. Including unapproved change orders

The change order is "basically approved," so you include it in contract value. If it doesn't get executed — or comes in lower — your WIP is overstated and the margins quietly disappear. Track pending change orders separately. Recognize them only when formally executed.


4. Treating WIP as a finance-only exercise

When WIP lives entirely in accounting, disconnected from project management, the numbers lose their meaning. Finance is working with data that's weeks old. PMs aren't accountable for their estimates. Nobody trusts the report. WIP has to be a cross-functional process: PMs own the cost projections, finance owns the analysis, leadership reviews and acts on it monthly.


5. Delaying loss recognition

Under GAAP, if a contract will result in a loss, you recognize the full anticipated loss immediately — not spread over the remaining project. Many contractors delay this out of optimism or to protect reported earnings. Have a clear policy: any job where revised ETC exceeds contract value triggers a formal review. If a loss is probable, record it.

 


Modernizing WIP: What Technology Actually Changes

Where spreadsheets start to break

For a small contractor with a handful of active jobs, a WIP spreadsheet can work. But as volume grows, spreadsheets fail in predictable ways: a single formula error propagates everywhere, version control becomes a nightmare, and connecting live cost data requires manual exports that are outdated before they're finished.

The typical construction company using spreadsheets spends 15 to 25 hours per month just preparing a WIP report. That's time your finance team isn't spending on analysis, forecasting, or decisions that actually move the business.


What a real WIP platform should do

•        Pull committed and incurred costs directly from your job cost system in real time

•        Automate percent-complete calculations as costs are posted — no manual formulas

•        Give project managers a simple interface to review and update their ETC directly

•        Generate audit-ready WIP schedules in hours, not days

•        Translate WIP data into rolling cash flow forecasts automatically

•        Log every change to an estimate — who changed it, when, and by how much

 

About Numerical

Numerical is a construction finance operations platform built to automate WIP reporting, job cost tracking, and cash flow forecasting — so your finance team spends less time in spreadsheets and more time making decisions that matter. We connect directly to your existing job cost system (Sage, Viewpoint, Foundation, QuickBooks, and others) and generate finished WIP reports in a fraction of the time. Visit numerical.build to schedule a demo.

 

 

Frequently Asked Questions


 What is WIP reporting in construction?

WIP (Work-in-Progress) reporting is a financial management process that tracks the current status of every active project — showing how much revenue has been earned versus billed, and whether each job is trending toward a profit or a loss. It uses the percentage-of-completion method to recognize revenue as work is performed, not when invoices are sent.


 What is the difference between an overbilling and an underbilling?

An overbilling (contract liability) occurs when billings to date exceed earned revenue — you've invoiced more than the work justifies. An underbilling (contract asset) is the opposite: earned revenue exceeds billings, meaning you've done the work but haven't invoiced for it yet. Both appear on your balance sheet and are central to understanding your true financial position.


How do you calculate percent complete on a construction project?

The most widely used and auditor-preferred method is cost-to-cost: divide total costs incurred to date by total estimated cost. If you've spent $400,000 on a project with a $1,000,000 revised estimated cost, you're 40% complete. Some contractors use labor hours or milestone-based methods, but cost-to-cost is preferred because it ties directly to financial data.


 Why do profitable construction jobs sometimes create cash flow problems?

Because profit and cash aren't the same thing. You can have strong earned revenue on a WIP report while still being cash-short if your billings are lagging behind completion, your collection cycle is long, or retainage is tied up in jobs nearing — but not yet at — substantial completion. WIP tells you what you've earned; cash flow tells you what you've collected.


 How often should a construction company prepare a WIP report?

Monthly is the standard minimum. Larger GCs and specialty contractors with high-volume, fast-moving projects often run WIP bi-weekly. The key is consistency — the same methodology, the same cutoff date, every cycle. A WIP report prepared inconsistently is worse than no report at all, because it creates false confidence in numbers that can't be compared meaningfully over time.


 How does Numerical improve WIP reporting for construction companies?

Numerical automates the data collection, calculation, and reporting layers that typically consume 15–25 hours of finance staff time each month. We connect directly to your job cost system, automate percent-complete calculations, and give project managers a simple interface to update their cost-to-complete estimates. The result is a finished, audit-ready WIP schedule in hours — plus integrated cash flow forecasting built directly on your live project data. Learn more at numerical.build.


 
 
 

Comments


bottom of page