What Is WIP Reporting in Construction? The Report Every Lender Asks to See
A work-in-progress schedule — universally called a WIP — is the report that summarizes every active construction contract's financial status at a specific point in time. For each contract on the schedule, it shows the contract amount, the total estimated costs, the costs incurred to date, the earned revenue (percent complete times contract amount), the billings to date, and the resulting over-billing or under-billing position.
The WIP is to construction what the inventory report is to retail or the receivables aging is to a services business — the essential operational report that summarizes how the core of the business is doing. It is reviewed monthly by the controller and CFO, presented quarterly to lenders and sureties, and audited annually by CPAs with special scrutiny. Getting the WIP right is arguably the single most important ongoing deliverable in construction accounting.
Most WIP schedules follow the same column structure, which lets lenders and sureties review them quickly across companies. Slight variations exist but the core is consistent.
Columns on a standard construction WIP
- Contract Amount — current total contract value including approved change orders
- Estimated Total Cost — current estimate of what the project will cost to complete
- Estimated Gross Profit — contract amount minus estimated total cost
- Costs Incurred to Date — actual costs booked against the job to the reporting date
- % Complete — typically costs incurred to date divided by estimated total cost
- Earned Revenue to Date — contract amount × % complete
- Billings to Date — cumulative amount billed to the owner through pay applications
- Over-Billing / Under-Billing — billings to date minus earned revenue to date (positive = over; negative = under)
- Remaining Backlog — contract amount minus earned revenue; the revenue left to recognize
Every row on a WIP is the output of a specific set of calculations. Take a hypothetical project: $10M contract amount, $8M estimated total cost, $3.2M costs incurred to date, $4M billings to date. Percent complete = $3.2M ÷ $8M = 40%. Earned revenue = $10M × 40% = $4M. Over-billing = $4M billings − $4M earned = $0 (right on top — neither over nor under). Estimated gross profit = $10M − $8M = $2M, of which $800K (40% × $2M) has been recognized.
Now change one input: the estimated total cost revises up to $9M. Percent complete becomes 35.6% ($3.2M ÷ $9M). Earned revenue becomes $3.556M ($10M × 35.6%). Over-billing becomes $444K ($4M − $3.556M) — positive, so the project is over-billed. Estimated gross profit drops to $1M, of which $356K (35.6% × $1M) has been recognized. The financial impact of a single estimate revision is visible immediately and can meaningfully change reported earnings.
The single most-analyzed line on a WIP is the over-billing / under-billing column. It is the difference between what has been billed to the owner and what has been earned based on the percent complete. Over-billings appear on the balance sheet as 'billings in excess of costs and estimated earnings' — a liability. Under-billings appear as 'costs and estimated earnings in excess of billings' — an asset.
A small net over-billing position across the portfolio is healthy and normal — it reflects a business that is billing promptly and collecting close to the value of the work done. A large and growing over-billing position is a warning sign — the company may be aggressively billing ahead of progress, which front-loads cash but creates a deferred revenue liability that eventually has to be earned through actual work.
Sureties specifically watch for the ratio of over-billings to earned revenue across the company's portfolio. A portfolio running 15%+ over-billed in aggregate is usually a flag for closer examination — either the billings are ahead of reality, or the cost estimates are behind reality, both of which matter for bonding decisions.
Banks and sureties don't look at the WIP as a general information report — they look at it as a leading indicator of the company's health. Several specific analyses drive their decisions.
What lenders and sureties analyze on a WIP
- Concentration — what percentage of backlog is in a single project, single owner, or single geography; high concentration increases risk
- Margin trend — are gross profit percentages on active projects in line with historical averages, or are margins deteriorating?
- Estimate revisions — projects where estimates have increased meaningfully are indicators of potential loss projects
- Over-billing aggregation — is the company pulling cash forward by aggressive billing?
- Remaining backlog vs. capacity — does the company have the resources to complete the work on its books?
- Loss contracts — any project forecast to finish at a loss (currently booked or pending)
- Age of projects — projects that have been open longer than expected may have hidden problems
Get AP insights in your inbox
Get our weekly roundup of AP automation tips and industry news. No spam, ever.
No spam. Unsubscribe anytime.
External auditors (CPAs performing the annual financial statement audit) pay disproportionate attention to the WIP because the numbers on it drive revenue recognition, which drives everything. The audit procedures on WIP typically include: testing a sample of cost estimates for reasonableness; confirming contract amounts with customers; examining change order documentation; verifying billings against source documents; evaluating management's process for identifying loss contracts; and testing the cost-to-date numbers against the job cost system.
The audit findings on WIP are often about estimation rigor rather than clerical errors — can management support its cost estimates with documentation showing how they were developed? Are estimates being updated regularly as conditions change? Is the process for identifying and booking loss contracts consistent and timely?
WIP patterns that warrant investigation
- Consistently increasing estimated total cost across multiple revision cycles — the original estimate was wrong or scope has crept
- Percent complete climbing faster than physical progress — costs front-loaded or billings outpacing earning
- A single project representing >40% of backlog — concentration risk
- Margins deteriorating across the portfolio — a systemic pricing, productivity, or cost issue
- Over-billing balance growing faster than new contract signings — cash being pulled forward faster than earned
- Projects sitting at 85-95% complete for multiple periods without closing — closeout friction or hidden punch list issues
- Projects where actual costs exceed the original contract amount but the contract amount hasn't been revised for change orders — unbilled work
A healthy monthly WIP close involves a few disciplined steps: updating cost estimates for every active project based on the PM's current view; reconciling contract amounts against all approved change orders; confirming billings to date against the AR system; identifying any loss contracts and booking the full projected loss; and reviewing the portfolio-level over/under-billing trend for anomalies.
The monthly rhythm is what keeps the WIP reliable. A WIP that only gets serious attention at year-end for the audit is a WIP that will have surprises at year-end. Continuous estimation updates and monthly review catch issues when they're small rather than when they've accumulated across the portfolio.
Traditional WIP preparation pulls from the job cost system, the AR/billing system, and the PM's cost estimates — often via manual spreadsheet consolidation each month. The manual process is labor-intensive and prone to error, especially when contract change orders haven't flowed through consistently.
Integrated construction accounting platforms produce the WIP directly from the underlying job cost and AR data, with PM-maintained estimates flowing in continuously. The operational benefit is a WIP that's always current; the strategic benefit is that issues surface in real time rather than at month-end when it's often too late to do anything about them.
The WIP is the most consequential report in construction accounting. It drives revenue recognition, it's the first thing lenders and sureties ask to see, and the numbers on it are the ones auditors scrutinize. A company with accurate job costing, disciplined estimate updates, and a reliable monthly close produces a WIP that tells the real story. A company without those disciplines produces a WIP that tells stories that don't match reality — until reality catches up at closeout or at the audit.
Written by
Sarah Blake
Head of Product
Former AP Manager at a $200M construction firm, now leads product at Covinly. Writes about what AP teams actually need from automation — beyond the marketing promises.
View all posts