WIP Reporting: Construction Work in Progress Guide

The Problem: At any given time, you likely have millions of dollars in projects that are partially complete. Your balance sheet shows these as assets (costs in progress), but without WIP reporting, you don't know:

How much revenue you should recognize on incomplete projects

What your profit position is on each project

Whether you're overbilled or underbilled

If projects are trending toward profit or loss

Example Without WIP: You have five projects in progress, each $500,000 contract. You've billed $1.5 million total. Without WIP, your P&L shows nothing about these projects—you're essentially flying blind.

Example With WIP: Same five projects. WIP reveals: Project A is 60% complete with expected profit of $75,000. Project B is 40% complete but already showing $30,000 in losses. Project C is 80% complete with expected loss of $50,000. Now you know where to focus attention.

Contract Amount: Original contract plus approved change orders. This is total potential revenue.

Estimated Total Cost: Your best estimate of total cost to complete. This is critical—and must be kept current.

Costs to Date: Actual costs incurred on the project to date.

Percent Complete: How far along the project is (costs to date / estimated total cost) or another recognized measure.

Revenue Recognized: Contract amount times percent complete. This is revenue that should be recognized to date.

Amount Billed: Total amount billed to customer to date.

Over/Under Billed: Revenue recognized minus amount billed. Positive = overbilled; negative = underbilled.

Estimated Profit/Loss: Revenue recognized minus costs to date. This is profit (or loss) recognized to date.

Expected Gross Margin: The anticipated profit at completion based on current estimates.

The Key Insight: Compare estimated gross margin to expected gross margin. If expected is significantly lower, the project is trending toward problems.

Monthly Preparation: Prepare WIP monthly at minimum. Quarterly is insufficient—problems need to be identified earlier.

Project Manager Review: Have project managers review and validate their project's WIP data. They know the field reality.

Identify Warning Signs: Look for:

Projects with estimated loss (expected margin < 0)

Projects where expected margin is declining (current estimate worse than original)

Large underbilling (working capital impact)

Projects with significant pending change orders

Discuss at Meetings: Make WIP a standing agenda item in management meetings. Review projects needing attention.

Trend Analysis: Track WIP metrics over time. Is average project margin improving or declining? Why?

Escalation Rules: Define thresholds for escalation—when does a project need executive attention? A 10% unfavorable margin variance? 20%?

Update Estimates: WIP requires current estimates to complete. Update estimates as conditions change—not just at project closeout.

Estimates to Complete: Your estimate of remaining cost is the most important—and most often wrong—number in WIP. Be realistic. Don't optimistic estimate just to make numbers look good.

When to Update: Update estimates when:

Scope changes significantly

Productivity is clearly different than expected

Major problems or changes occur

At regular intervals (monthly or bi-weekly)

Documentation: Document the basis for your estimates. What assumptions are you making? What's driving remaining costs?

Consequences: If estimates are wrong, WIP is misleading. Underestimating costs to complete overstates profit. This is one of the most common causes of contractor financial distress.

Week 3-4: Gather Data. Pull contract amounts, costs to date, current estimates for all projects.

Month 2: Prepare First WIP. Prepare first WIP report, validate data, train project managers.

Month 3: Review and Refine. Review WIP in management meeting, refine estimates, establish escalation rules.

Ongoing: Maintain Monthly. Prepare monthly, track trends, use for management decisions.