Tag: how to prepare construction work in progress reports

  • How to Prepare Construction WIP Reports

    How to Prepare Construction WIP Reports

    Table of Contents

    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.

    Contractor reviewing construction job cost documents and project folders at desk with laptop and calculator in modern office setting with natural lighting
    Contractor reviewing construction job cost documents and project folders at desk with laptop and calculator in modern office setting with natural lighting

    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

    Get Started Today →

    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).

    Pro Tip
    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.
    Watch Out
    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.

    Key Takeaway
    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.

    Watch Out
    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.
    Pro Tip
    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.

    Key Takeaway
    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.