Table of Contents
- What Is a Construction Work-in-Progress Report and Why It Matters
- Key Components You Must Include in Your WIP Report
- Step-by-Step: How to Prepare Your WIP Report Each Period
- Work in Progress Report Example: A Real Project Walkthrough
- Percentage of Completion Construction Accounting Methods
- Construction WIP Schedule Template and Monthly Close Checklist
- Construction WIP Reporting Best Practices and Common Pitfalls
- Handling Change Orders, Retainage, and Disputed Costs
- Frequently Asked Questions
Last Updated: October 8, 2026
What Is a Construction Work-in-Progress Report and Why It Matters
For contractors, WIP reporting isn’t optional. Margins are thin, and a project profitable in month three can turn into a loss by month six.
Projects span months or years, so you can’t wait until closeout to understand profitability.
Those with tight cash flow aren’t making mistakes on individual jobs, they lack a WIP reporting process. Profitable firms run a structured monthly close with WIP reconciliation.
Key Components You Must Include in Your WIP Report
Your WIP report needs five core pieces of information. Miss any and it’s unreliable.
Contract Value and Original Estimated Costs
Document the original contract amount and initial cost estimate, your benchmark.
Costs Incurred to Date
Direct labor, materials, subcontractor costs, and allocated overhead.
Revised Estimated Costs and Cost to Complete
Update your original estimate monthly for unforeseen conditions, price changes, or scope creep.
Percentage of Completion
This drives revenue recognition.
Earned Revenue and Billings to Date
Earned revenue is what you’ve made on work completed; billings to date is what you’ve invoiced.
Step-by-Step: How to Prepare Your WIP Report Each Period
With a system in place, most firms complete monthly WIP in two to three hours.
Accurate cost reporting relies heavily on the underlying construction project schedule to ensure that progress billing remains aligned with the actual timeline of work performed.
Step 1: Gather and Verify Job Costs
Pull your job-cost ledger for the period: direct labor, materials, subcontractor invoices, and equipment/overhead allocations. Reconcile job costs to the GL first, a missing subcontractor invoice can throw off your entire WIP calculation.
Step 2: Calculate Percentage of Completion
Choose your method and stick with it. Cost-to-cost is most common.
Cost-to-Cost Formula:
Percentage of Completion = Actual Costs to Date ÷ Total Estimated Costs
Example: If you’ve spent $150,000 and your revised estimate is $400,000, you’re 37.5% complete.
Document your revised estimate and why it changed, material escalation, scope change, unforeseen conditions. This creates an audit trail.
Step 3: Determine Earned Revenue and Billings
Multiply percentage of completion by contract value for earned revenue to date.
Earned Revenue Formula:
Earned Revenue = Contract Value × Percentage of Completion
If your contract is $500,000 and you’re 37.5% complete, you’ve earned $187,500 so far.
Now check your billings. If you’ve billed $200,000, you’re overbilled by $12,500; if $175,000, you’re underbilled by $12,500.
Step 4: Reconcile Costs and Identify Overbilling or Underbilling
Reconcile: Earned Revenue $187,500 − Costs $150,000 = Gross Profit $37,500; less Billings $200,000 = $12,500 overbilled. Overbilling means cash collected ahead of work, good for cash flow but a balance-sheet liability. Underbilling is the opposite. Reconcile both monthly.
Work in Progress Report Example: A Real Project Walkthrough
Here’s a real scenario to make the math concrete.
The Project: A $600,000 commercial renovation. You estimated $450,000 in costs.
Month 3 Status:
- Costs Incurred: $135,000 (direct labor $75,000, materials $45,000, subs $15,000)
- Revised Estimate: Still $450,000 (no surprises yet)
- Billings to Date: $180,000
Calculations:
Percentage of Completion = $135,000 ÷ $450,000 = 30%
Earned Revenue = $600,000 × 30% = $180,000
Gross Profit = $180,000 − $135,000 = $45,000
Billing Position = $180,000 (earned) − $180,000 (billed) = $0
You’re perfectly matched, no overbilling or underbilling.
Month 6 Status:
- Costs Incurred: $290,000
- Revised Estimate: $480,000 (discovered hidden structural issues, +$30,000)
- Billings to Date: $360,000
Calculations:
Percentage of Completion = $290,000 ÷ $480,000 = 60.4%
Earned Revenue = $600,000 × 60.4% = $362,400
Gross Profit = $362,400 − $290,000 = $72,400
Billing Position = $362,400 (earned) − $360,000 (billed) = $2,400 underbilled
You’re slightly underbilled, send a progress invoice for the $2,400 gap. More importantly, margin compressed from $150,000 estimated to $120,000, a $30,000 hit. That’s the value of monthly WIP: you caught the overrun in month 6, not at closeout.
Percentage of Completion Construction Accounting Methods
Two methods dominate construction accounting.
Cost-to-Cost Method
The most common method: revenue recognized by proportion of costs incurred to total estimated costs. Strength: simple to calculate and audit. Weakness: assumes costs are evenly distributed, so front-loaded labor or back-loaded materials can distort early profitability.
Units of Delivery Method
Revenue recognized by units delivered or milestones reached, common where deliverables are clear (square footage, units, phases). Strength: matches revenue to delivery. Weakness: requires clear unit definitions; ambiguity creates disputes. Most firms use cost-to-cost.
Construction WIP Schedule Template and Monthly Close Checklist
A WIP report is only as good as the close process behind it. The most common failure isn’t bad math, it’s a missing input, stale estimate, or unflagged change order. A repeatable close calendar with named owners and review gates prevents that.
Who Owns Each Input
Assign one owner per input. When two people assume the other is handling it, costs go missing.
| Input | Owner | Due | Review Gate |
|---|---|---|---|
| Job-cost ledger pulled and reconciled to GL | Staff accountant | Business day 3 | Controller sign-off |
| Open subcontractor and material invoices accrued | AP clerk | Business day 3 | Controller sign-off |
| Payroll and labor distribution coded to jobs | Payroll administrator | Business day 2 | Controller sign-off |
| Revised cost-to-complete per project | Project manager | Business day 4 | Operations manager approval |
| Approved change orders logged and priced | Project manager | Business day 4 | Contract administrator verification |
| Billings and retainage schedule updated | Billing specialist | Business day 4 | Controller sign-off |
| WIP schedule calculated and reviewed | Controller | Business day 5 | CFO or owner approval |
| Overbilling/underbilling and margin variance reviewed | CFO or owner | Business day 6 | Management meeting |
Two gates matter most: the operations manager approves the project manager’s revised estimate (reducing the temptation to understate cost-to-complete), and the CFO or owner approves the controller’s final report (keeping estimate bias out of the financial statements).
Separate the person who estimates from the person who approves. When the same project manager both sets the cost-to-complete and signs off on the resulting margin, estimate bias has no check.
Monthly Close Calendar
A workable sequence for a calendar-month close:
- Days 1-2: Payroll closes; labor distributed to jobs; timesheet corrections made before the ledger locks.
- Day 3: Job-cost ledger pulled and reconciled to the GL; open AP accrued.
- Day 4: Project managers submit revised cost-to-complete and change order status; contract administrator verifies each change order is signed.
Data Validation and Reconciliation Checks
Before approval, run these checks, each catches a specific error class.
- Job cost to GL: Total job costs across all projects must tie to the job-cost control account in the general ledger. A variance means a cost was coded to the wrong project or not entered.
- Payroll to job cost: Total labor distributed to jobs must equal gross payroll for the period. Unallocated labor is a common gap.
- Subcontractor commitments: Compare subcontractor costs incurred to the commitment log. A sub who has performed work but not yet invoiced will understate cost-to-date.
If job costs don’t tie to the general ledger, stop. Do not calculate percentage of completion on an unreconciled ledger. Every downstream number, earned revenue, gross profit, overbilling, inherits the error.
WIP Schedule Template Structure
Build the schedule as one row per active project so the portfolio fits on one page.
| Project | Contract Value | Revised Estimate | Costs to Date | % Complete | Earned Revenue | Billings | Over/(Under) Billing | Gross Profit |
|---|---|---|---|---|---|---|---|---|
| Project A | $500,000 | $450,000 | $180,000 | 40.0% | $200,000 | $210,000 | $10,000 | $70,000 |
| Project B | $300,000 | $280,000 | $150,000 | 53.6% | $160,800 | $150,000 | ($10,800) | $10,800 |
Add a totals row and a margin percentage column. The margin percentage column is what management watches month over month, a sliding margin is the early warning, not the dollar profit.
A close calendar with named owners, due dates, and two approval gates turns WIP reporting from a monthly scramble into a repeatable process. The reconciliation checks are what keep the numbers defensible.
Construction WIP Reporting Best Practices and Common Pitfalls
Three mistakes show up repeatedly in construction WIP reports.
Pitfall 1: Stale Cost Estimates
You update costs monthly but never revisit the revised estimate. By month six it’s three months old and worthless.
Pitfall 2: Misaligned Cost Categories
Fix: Create a clear chart of accounts per project, train your team on coding rules, and spot-check invoices before entry.
Pitfall 3: Ignoring Billing Timing
You calculate earned revenue correctly but forget billings lag. Underbilled by $50,000, you don’t follow up, and cash flow suffers.
Fix: Review overbilling and underbilling weekly, not monthly. Underbilled? Send an invoice. Overbilled? Monitor the liability. Don’t let positions drift.
Handling Change Orders, Retainage, and Disputed Costs
Change orders, retainage, and disputed costs all affect contract value or total estimated cost, both inputs to percentage of completion. Get them wrong and every downstream number is wrong.
Change Orders: Approved vs. Unapproved
A change order changes contract value, estimated cost, or both. Treatment depends on whether the client has signed.
Approved change orders are added to contract value and revised cost estimate. A signed $20,000 change order adding $15,000 of cost moves contract value from $600,000 to $620,000 and the estimate from $450,000 to $465,000.
Unapproved change orders are harder: work may be performed and cost incurred, but contract value isn’t legally increased. Two approaches:
- Conservative: Include the cost in costs incurred but not in contract value until signed. This depresses reported margin until approval.
- Probability-weighted: If approval is highly probable and reasonably estimable, include a portion in contract value. Requires judgment and documentation.
Apply your approach consistently and disclose it. Switching mid-project to smooth a margin draws scrutiny.
Do not recognize revenue on an unapproved change order just because the work is done. Cost incurred without a signed change order creates a margin problem on the WIP, and that problem is real, it’s the signal that you’re funding the client’s indecision.
Retainage: Why It Creates a Permanent Underbilling
Retainage is the percentage a client withholds until substantial completion or final closeout, commonly 5% to 10% of each progress billing.
Earned revenue includes the full amount earned, retainage and all. Billings to date reflect only what’s been invoiced, and retainage is withheld from that invoice.
Example: A $600,000 contract at 60% complete with 10% retainage.
- Earned revenue: $600,000 × 60% = $360,000
- Billings before retainage: $360,000
- Retainage withheld: $36,000
That $36,000 isn’t a billing error, it’s a receivable the client owes but is holding.
Disputed Costs and Claims
A dispute is a cost or revenue item whose realizability is uncertain, an unsigned change order, a contested back-charge, or a delay-damages claim.
Treat disputed items conservatively:
- Disputed cost: If incurred, it belongs in costs to date. Excluding a real cost to protect margin is inaccurate, not conservative.
- Disputed revenue: Exclude from contract value until resolved or highly probable. If included, document the basis and consider a separate line so management sees the exposure.
- Disputed subcontractor cost: Accrue your best estimate of what you’ll ultimately pay, not the invoiced amount, not zero.
Keep a disputed items log alongside the WIP schedule. List each dispute, the amount, the expected resolution, and the treatment applied. When the dispute resolves, the log tells you exactly what to adjust and why.
How These Flow Through the WIP
Put it together, a project with an approved change order, retainage, and one disputed change order:
- Original contract: $600,000
- Approved change order: +$20,000 → contract value $620,000
- Disputed change order: $15,000, excluded until resolved
The disputed change order’s cost sits in the denominator, lowering percentage of completion and earned revenue until resolution, the conservative, correct outcome. When the client signs, contract value increases, the percentage recalculates, and margin recovers.
Change orders, retainage, and disputes all hit the same two inputs: contract value and total estimated cost. Decide your treatment policy once, apply it consistently, and document every judgment call so the WIP report is defensible to your CPA, your lender, and your bonding company.
Frequently Asked Questions
How often should contractors prepare construction WIP reports?
Most contractors prepare WIP reports monthly at period close, aligning with financial statement preparation and tax compliance requirements. Some larger firms or those with significant billings prepare them more frequently, bi-weekly or on project milestone dates. Monthly reporting is the standard because it matches your general ledger close cycle, ensures timely revenue recognition, and provides monthly snapshots of cash flow and project profitability for management decisions.
What is the difference between a construction progress report and a WIP report?
A progress report tracks construction schedule, milestones, and physical completion status for project management and client communication. A WIP report is a financial accounting document that tracks costs incurred to date, earned revenue, billings, and projected profit or loss. WIP reports are required for accurate financial reporting and revenue recognition under accounting standards; progress reports are operational tools. Both are important, but WIP reports are what your accountant and lenders need to assess financial health.
How do you calculate overbilling and underbilling on a WIP report?
Overbilling occurs when cumulative billings to the customer exceed cumulative earned revenue; underbilling is the opposite. Calculate it as: Billings to Date minus Earned Revenue to Date. A positive number means you’ve overbilled (you owe the customer a credit or will earn it on future work); a negative number means you’ve underbilled (the customer owes you). This calculation is critical for accurate balance sheet reporting and cash flow forecasting, especially on long-term contracts.
What are common construction WIP reporting mistakes?
Common mistakes include miscalculating percentage of completion, failing to record change orders promptly, not reconciling job costs to the general ledger, overlooking retainage and holdbacks, and mishandling revenue recognition on disputed or delayed billings. Many contractors also forget to include allocated overhead in job costs, which inflates profit margins. Regular reconciliation between your job-cost ledger and general ledger catches most of these errors before financial statements are issued.
Leave a Reply