WIP Reporting: Construction Work in Progress Guide

Work in Progress (WIP) reporting is essential for contractors because traditional financial statements don't show the true picture of incomplete projects. Understanding WIP is critical for managing your business.

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.

A WIP schedule is a detailed report showing the financial position of each project in progress. Here's what it should include:

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.

WIP reporting should drive management action. Monthly preparation and regular reviews are essential—problems need to be identified earlier rather than at project closeout when it's too late. This proactive approach is part of effective cash flow management .. Monthly preparation and regular reviews are essential—problems need to be identified earlier rather than at project closeout when it's too late.. Here's how to use it effectively:

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.

WIP is only as good as your estimates to complete. Garbage in, garbage out.

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. Overly optimistic estimates to complete can mask serious cash flow problems that only emerge when it's too late.. 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 1-2: Design WIP Report. Design WIP schedule format, define metrics, and configure reporting. This foundational setup is part of proper job costing implementation—and proper job costing is essential for understanding true profitability ., define metrics, configure reporting.

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.