Construction WIP Reporting Guide | Work in Progress Reports Explained

If you run a construction company and you are not doing WIP reporting, you are flying blind. You might think your business is profitable based on your bank account balance. But cash in the bank does not tell you the whole story. Not even close.

WIP stands for work in progress. A WIP report is the single most important financial tool for any contractor running multiple jobs. It tells you which projects are making money, which ones are losing money, and whether your billings match the work you have actually completed.

In this guide, we will break down everything you need to know about WIP reporting: what it is, how to build one, common mistakes, and why your bonding company cares so much about it.

What Is WIP Reporting?

A WIP report compares three things for every active job in your company:

1. How much work you have completed (based on costs incurred vs. estimated total costs)
2. How much revenue you have earned (based on percent complete times the contract value)
3. How much you have billed the client

The gap between earned revenue and billings tells you whether you are over-billed or under-billed on each job. Add all your jobs together, and you get the true financial position of your company.

This matters because construction accounting is different from most other businesses. You do not sell a product and collect payment the same day. Projects stretch over weeks, months, or even years. Costs hit at different times than billings. Without a WIP report, your income statement and balance sheet can be wildly misleading.

Why WIP Reporting Matters for Contractors

Here is the blunt truth: contractors go out of business all the time while showing a “profit” on paper. How? Because their financial statements did not reflect reality.

WIP reporting fixes that. Here is what it does for you:

Shows true profitability per job. Your P&L might say you made $200K last quarter. But if you are under-billed by $150K across your jobs, a big chunk of that “profit” is work you have done but have not been paid for yet. That is a cash flow problem waiting to happen.

Catches problems early. If a job’s actual costs are running ahead of your estimate, the WIP report shows it immediately. You can make adjustments before a project turns into a financial disaster.

Keeps your bonding company happy. Sureties look at WIP reports more closely than almost anything else. If you want higher bonding capacity, clean WIP reports are non-negotiable.

Supports better decision-making. Should you take on that next big project? Your WIP report tells you whether you have the financial bandwidth to handle it.

Satisfies your CPA. If your CPA prepares financial statements using the percentage-of-completion method (and they should for most contractors), they need accurate WIP data to do it right.

Over-Billing vs. Under-Billing Explained

These two concepts are the heart of WIP reporting. Let us walk through each one.

Over-Billing

Over-billing happens when you have billed the client more than the value of work you have actually completed.

Example: You have a $500,000 contract. You are 40% complete based on costs, meaning you have earned $200,000 in revenue. But you have billed the client $250,000. You are over-billed by $50,000.

That $50,000 is not profit. It is a liability. You owe the client $50,000 worth of work that you have already been paid for. On your balance sheet, over-billings show up as a current liability (often called “billings in excess of costs and estimated earnings”).

Over-billing is not necessarily bad. In fact, many successful contractors stay slightly over-billed because it means the client is funding the work rather than the contractor. The key is knowing the number and managing it.

Under-Billing

Under-billing is the opposite. You have completed more work than you have billed for.

Example: Same $500,000 contract. You are 60% complete, meaning you have earned $300,000. But you have only billed $220,000. You are under-billed by $80,000.

That $80,000 is an asset on your balance sheet (called “costs and estimated earnings in excess of billings”). But it is also a warning sign. You have spent real money on labor, materials, and subs that you have not collected for yet. You are essentially financing the project for the client.

A little under-billing here and there is normal. Large or persistent under-billing across multiple jobs is a red flag. It means your cash flow is under pressure, and if those billings do not catch up, you could be in trouble.

The WIP Schedule Format

A standard WIP schedule is a spreadsheet with one row per active job and columns that capture the key numbers. Here is what a typical WIP schedule includes:

Some contractors add columns for original contract value vs. revised contract value (to track change orders), costs to complete, and projected final margin.

The bottom of the schedule totals everything up. The net over/under billing number feeds directly into your financial statements.

How to Calculate Earned Revenue vs. Billings

The percentage-of-completion method is the standard approach for construction WIP reporting. Here is the step-by-step calculation:

Step 1: Calculate Percent Complete

Percent Complete = Costs to Date / Estimated Total Cost at Completion

Let us say you have a $1,200,000 contract. Your estimated total cost is $960,000. You have spent $480,000 so far.

Percent Complete = $480,000 / $960,000 = 50%

Step 2: Calculate Earned Revenue

Earned Revenue = Percent Complete x Contract Value

Earned Revenue = 50% x $1,200,000 = $600,000

Step 3: Compare to Billings

If you have billed $650,000, you are over-billed by $50,000. If you have billed $550,000, you are under-billed by $50,000.

Step 4: Calculate Profit Earned to Date

Estimated Gross Profit = Contract Value - Estimated Total Cost $1,200,000 - $960,000 = $240,000

Profit Earned to Date = Percent Complete x Estimated Gross Profit 50% x $240,000 = $120,000

This tells you how much of the expected profit you have “earned” based on the work completed.

A Note on Cost Estimates

The whole system depends on one critical input: your estimated cost at completion. If that number is wrong, everything else is wrong too. This is why keeping your job cost estimates updated is so important. When costs change, your WIP changes. When your WIP changes, your financial statements change.

Impact on Financial Statements

WIP adjustments directly affect your balance sheet and income statement. Here is how:

Balance Sheet

• Under-billings appear as a current asset. They represent revenue you have earned but not yet billed.
• Over-billings appear as a current liability. They represent payments you have received for work not yet performed.

Income Statement

Under the percentage-of-completion method, revenue is recognized based on percent complete, not based on when you send invoices. This means:

• Your reported revenue reflects actual production, not billing timing
• Gross profit tracks real job performance, not cash collection
• Period-to-period comparisons are more meaningful

Why This Matters

If you are using cash-basis accounting or simple accrual without WIP adjustments, your financial statements could be way off. A company that looks profitable might actually be losing money on its jobs. A company that looks tight on cash might actually have strong job margins with billings that are lagging behind.

Banks, bonding companies, and savvy business owners all know this. That is why WIP-adjusted financial statements are the gold standard in construction.

Common WIP Mistakes

After working with hundreds of contractors, here are the mistakes we see over and over again:

1. Not Updating Cost Estimates

Your original estimate is a starting point. As the job progresses, things change. Material prices go up. You hit unforeseen conditions. A sub comes in over budget. If you do not update your estimated cost at completion, your percent complete is wrong, and your entire WIP is unreliable.

Fix: Review and update cost estimates on every active job at least monthly. Compare actual costs to the budget and adjust your forecast.

2. Ignoring Pending Change Orders

You have submitted a $75,000 change order, but it has not been approved yet. Do you include it in your WIP? Many contractors do not, which understates the contract value and distorts the numbers.

Fix: Have a consistent policy for pending change orders. Many CPAs recommend including them at a reduced value (say 50-75%) if approval is likely. Just be consistent.

3. Front-Loading Costs

Some jobs have heavy upfront material purchases. If you buy $200,000 in steel that is sitting in a warehouse, your costs to date spike, but the work is not really 50% done just because you spent 50% of the budget.

Fix: Consider using stored materials as a separate line item, or adjust your percent complete calculation to reflect actual installation progress rather than just spending.

4. Not Reconciling to the General Ledger

Your WIP schedule should tie back to your accounting system. If the costs on your WIP do not match your job cost ledger, something is wrong. Maybe costs were coded to the wrong job. Maybe a bill was not entered yet.

Fix: Reconcile WIP to GL every month before finalizing the report.

5. Doing WIP Only at Year-End

Some contractors only prepare a WIP schedule once a year for their CPA. That is like checking your speedometer once per road trip. You need this information regularly to make good decisions.

Fix: Prepare WIP reports monthly. It does not have to take all day. With good job costing software and a solid process, you can knock it out in a few hours.

6. Mixing Up Contract Types

Not every job uses percentage-of-completion. Time and materials jobs, cost-plus jobs, and small short-term contracts might use different recognition methods. Applying the wrong method to a job will skew your WIP.

Fix: Work with your CPA to classify each job by contract type and apply the right revenue recognition method.

WIP Reporting for Bonding Companies

If you work with a surety, your WIP report is one of the first things they look at. Here is what bonding companies are watching for:

Consistent margins. If your estimated margins swing wildly from job to job, that raises questions about your estimating accuracy.

Fade vs. gain. “Fade” means your margins are shrinking as jobs progress (you estimated 20% but you are tracking to 12%). “Gain” means margins are improving. Consistent fade is a red flag. It usually means you are underestimating costs at bid time.

Over-billing levels. A moderate level of over-billing is normal and even expected. Excessive over-billing can signal cash flow problems (you are billing ahead to cover expenses on other jobs).

Under-billing trends. Persistent under-billing means you are not getting paid for work you have done. That puts cash flow at risk and may indicate billing process issues.

Estimated costs to complete. Sureties want to see that you have a realistic handle on what it will take to finish each job. Vague or stale estimates undermine confidence.

Backlog quality. They look at your upcoming work (backlog) alongside the WIP to gauge whether you can handle current and future obligations.

If you want to grow your bonding capacity, keeping clean, accurate WIP reports is one of the most effective things you can do. Your surety agent and your CPA should be working from the same data.

Connecting WIP to Job Costing

WIP reporting is only as good as the data feeding it. And that data comes from your job costing system.

Every dollar spent on a job needs to be tracked and coded correctly. That means:

• Labor costs tied to the right job and cost code
• Material purchases allocated to the correct project
• Subcontractor invoices recorded against the right job
• Equipment costs assigned properly
• Overhead allocation applied consistently

If your job costing is sloppy, your WIP will be sloppy. Garbage in, garbage out.

This is where your systems matter. Tracking costs on paper or in disconnected spreadsheets creates lag time and errors. By the time you compile the numbers, they are already outdated.

How Projul Helps With WIP Data

Projul’s job costing tools track labor, materials, and subcontractor costs in real time as your crews work. Every cost gets tied to a job and cost code automatically.

Because Projul integrates directly with QuickBooks, your accounting data stays in sync. You do not have to re-enter numbers or reconcile between two separate systems. When a cost hits in Projul, it flows to QuickBooks. When you need to pull WIP data, the numbers are already there and up to date.

This also connects to your estimating process. Your original budget from the estimate becomes the baseline for job costing, which feeds the WIP. It is one connected flow from bid to completion.

And when it is time to bill, Projul’s invoicing tools make it easy to track billings against each job, giving you the other half of the WIP equation.

The result? Less manual work, fewer errors, and WIP reports you can actually trust.

Building a WIP Process That Works

Here is a practical framework for getting WIP reporting right in your company:

Monthly Routine

1. Update cost estimates on every active job. Talk to your project managers. What has changed? What are the remaining costs to complete?
2. Reconcile job costs between your project management system and your accounting system. Make sure they match.
3. Review billings on each job. Are you billing promptly? Are there approved change orders that have not been billed?
4. Run the WIP schedule. Calculate percent complete, earned revenue, and over/under billings for every job.
5. Review with your team. Sit down with project managers and review the WIP. Discuss any jobs with margin fade or billing issues.
6. Share with your CPA and surety as needed (typically quarterly or annually for formal reporting).

Keys to Success

• Assign ownership. Someone in your company needs to own the WIP process. Usually it is the CFO, controller, or office manager.
• Use real data. Do not guess at costs to complete. Get input from the people running the jobs.
• Be honest. It is tempting to leave cost estimates unchanged to avoid showing margin erosion. Do not do that. Bad WIP data leads to bad decisions.
• Invest in your systems. Good construction management software pays for itself by keeping your financial data accurate and accessible. Check out Projul’s pricing to see what fits your operation.

Wrapping Up

WIP reporting is not glamorous. It is not the exciting part of running a construction company. But it is one of the most important things you can do to protect your business.

A good WIP report tells you the truth about your jobs, your cash flow, and your financial position. It helps you catch problems before they become disasters. It keeps your bonding company confident in your operation. And it gives you the data you need to make smart decisions about which jobs to take and how to run them.

Start with accurate job costing. Keep your estimates updated. Reconcile your numbers monthly. And build a process that turns raw data into clear, actionable reports.

Your future self will thank you.