Construction WIP Report Guide | Projul

If you have ever finished a project thinking you made money, only to find out the numbers told a different story, you are not alone. That gap between what you think is happening on your jobs and what is actually happening is exactly what a WIP report is built to close.

A Work-in-Progress report is one of the most important financial tools in construction. It gives you a clear, honest picture of where every active project stands right now, not where you hope it stands or where it stood last month. For contractors who want to stop guessing and start managing their money with real data, the WIP report is where it all starts.

This guide breaks down what a WIP report is, how to read one, how to build one, and how to actually use the information to run a tighter operation.

What Is a Construction WIP Report?

A WIP report is a financial snapshot of all your active projects at a specific point in time. It lines up three things for each job: how much work you have completed, how much you have billed, and how much you have spent.

The core idea is simple. On any given project, the amount of work you have done and the amount you have billed rarely match up perfectly. You might be 60% done with the work but only 40% billed. Or you might have billed 80% of the contract but only completed 50% of the scope. Both situations create real financial consequences, and the WIP report makes those gaps visible.

Construction is different from most industries because projects stretch over months or years. Revenue does not arrive in neat, predictable chunks. Costs pile up unevenly. Materials get front-loaded. Labor spikes during certain phases. Change orders shift the target mid-project. Without a WIP report, you are flying blind through all of it.

The report ties directly into the percentage-of-completion accounting method, which is standard for most contractors. Instead of recognizing revenue only when a project is done, you recognize it proportionally as work progresses. The WIP report is the mechanism that makes this work.

If you are still getting familiar with how construction financials differ from other businesses, our construction accounting basics guide covers the fundamentals worth knowing first.

The Key Columns: What Every WIP Report Contains

Every WIP report, whether it lives in a spreadsheet or in your accounting software, contains the same core columns. Here is what each one means and why it matters.

Contract Value (or Contract Price)

This is the total amount the client has agreed to pay for the project. It includes the original contract plus any approved change orders. If your contract started at $500,000 and you have $75,000 in approved changes, your contract value is $575,000.

Keep this number current. Unapproved change orders should not show up here. Only include amounts that are signed and agreed upon.

Estimated Total Cost

This is what you expect the project to cost when it is 100% complete. It includes labor, materials, equipment, subcontractors, and your share of overhead costs. This number should be a living estimate, not the number you put in your original bid and never touched again.

Revisiting your estimated total cost every month is critical. If material prices jumped or you needed more labor hours than planned, your estimate needs to reflect that. A stale estimate makes the entire WIP report unreliable.

Actual Costs to Date

Projul is trusted by 5,000+ contractors. See their reviews to find out why.

This is the total you have spent on the project so far. Every dollar of labor, every material invoice, every sub payment. Accurate job costing is what makes this number trustworthy. If costs are sitting in the wrong job or haven’t been posted yet, your WIP will be off.

Percent Complete

This is calculated by dividing actual costs to date by estimated total cost. If you have spent $200,000 on a job you expect to cost $400,000, you are 50% complete.

A quick note: this is cost-based percent complete, which is the most common method. Some contractors prefer to estimate percent complete based on physical progress (the superintendent’s judgment call), but cost-based is more objective and what most accountants expect.

Earned Revenue

Multiply the percent complete by the contract value. If you are 50% complete on a $575,000 contract, your earned revenue is $287,500. This is the revenue you have actually earned based on work performed, regardless of what you have billed.

Total Billings to Date

This is the total amount you have invoiced to the client so far. Not what you have collected, but what you have billed. If you are handling AIA billing or progress billing, this number comes straight from your pay applications.

Over/Under Billing

This is the punchline of the whole report. Subtract earned revenue from total billings.

• If billings are higher than earned revenue, you are overbilled. You have collected more than you have earned. That is a liability.
• If earned revenue is higher than billings, you are underbilled. You have done more work than you have been paid for. That is an asset, but it also means cash is lagging behind your effort.

How to Read a WIP Report: A Practical Example

Let’s walk through a real example. Say you have three active projects:

Project A: Smith Office Renovation

• Contract Value: $400,000
• Estimated Total Cost: $320,000
• Actual Costs to Date: $240,000
• Percent Complete: 75% ($240K / $320K)
• Earned Revenue: $300,000 (75% x $400K)
• Billings to Date: $280,000
• Over/Under: -$20,000 (Underbilled)

You have done $300,000 worth of work but only billed $280,000. The client owes you for $20,000 of completed work. You need to get that next invoice out.

Project B: Highway Retaining Wall

• Contract Value: $850,000
• Estimated Total Cost: $740,000
• Actual Costs to Date: $370,000
• Percent Complete: 50%
• Earned Revenue: $425,000
• Billings to Date: $510,000
• Over/Under: +$85,000 (Overbilled)

You have billed $85,000 more than you have earned. That money is not profit. It is future work you owe. If cash flow is tight later in the project, this overbilling will catch up to you. It is fine to be slightly overbilled at times, but $85,000 on an $850K job is a flag worth watching.

Project C: Municipal Water Treatment Building

• Contract Value: $1,200,000
• Estimated Total Cost: $1,050,000
• Actual Costs to Date: $840,000
• Percent Complete: 80%
• Earned Revenue: $960,000
• Billings to Date: $960,000
• Over/Under: $0 (Perfectly billed)

This job is right on track. Billing matches earned revenue. This is the ideal scenario, and honestly, it is rare. Enjoy it when it happens.

Looking at all three projects together, you have a net underbilling of $20,000 minus the overbilling of $85,000, giving you a net overbilling of $65,000 across your portfolio. That means, company-wide, you have collected more than you have earned. Your cash position looks better than your actual financial position.

This is exactly the kind of insight that a profit and loss statement alone cannot give you. The P&L shows revenue and expenses, but it does not show the timing mismatch between billing and work completion that the WIP report reveals.

How to Build a WIP Report

You do not need expensive software to build a WIP report. A spreadsheet works fine for smaller operations. Here is the process.

Step 1: Gather your project list. Pull every active job. If a project has any remaining work or unbilled amounts, it belongs on the WIP.

Step 2: Update contract values. Check for approved change orders on every job. Your contract value needs to reflect the current agreed scope, not the original bid.

Step 3: Revisit estimated total costs. This is the step most contractors skip, and it is the step that matters most. Sit down with your project managers or superintendents and ask: knowing what we know today, what will this project cost to finish? Then add that to your costs to date for the revised estimate. If your estimating was solid upfront, the revisions should be small. But they still need to happen.

Step 4: Pull actual costs to date. This comes from your job cost reports. Every invoice, every payroll entry, every equipment charge needs to be posted to the correct job. If your time tracking is sloppy or your subs’ invoices are sitting unposted, your costs will be understated and your WIP will look better than reality.

Step 5: Pull billings to date. Total up every invoice or pay application you have sent on each project.

Step 6: Calculate. Run the math. Percent complete, earned revenue, over/under billing. The formulas are straightforward:

• Percent Complete = Actual Costs to Date / Estimated Total Cost
• Earned Revenue = Percent Complete x Contract Value
• Over/Under Billing = Billings to Date - Earned Revenue

Step 7: Review and question. Look at the results. Does anything look off? A project showing 90% complete with only 50% of costs posted probably has missing cost data. A job showing a huge overbilling might have an outdated cost estimate. The WIP report is only as good as the data feeding it.

Common WIP Report Mistakes (and How to Avoid Them)

Even experienced contractors make WIP mistakes. Here are the ones that show up most often.

Not updating cost estimates. This is the number one problem. If your estimated total cost never changes from the original bid, your percent complete will be wrong, your earned revenue will be wrong, and your over/under billing will be meaningless. Revisit estimates monthly.

Missing or misallocated costs. A subcontractor invoice sitting on someone’s desk unposted will understate your costs and overstate your percent complete. Costs coded to the wrong job will make one project look better and another worse. Clean job costing discipline is the foundation of a reliable WIP.

Ignoring pending change orders. If you have done extra work but the change order is not approved yet, that cost is hitting your actual costs without a corresponding increase in contract value. Your margin will look like it is shrinking, and it might be. Track pending change orders separately so you can see their impact.

Running the WIP too infrequently. A WIP report that you look at once a quarter is barely useful. Monthly is the minimum. On large or fast-moving jobs, biweekly reviews keep you ahead of problems.

Treating overbilling as profit. This is the classic trap. You have billed more than you have earned, so your bank account looks healthy. But that money belongs to future work. Spend it now and you will be short later. Overbilling is a timing benefit, not income.

Not involving field leadership. Your project managers and superintendents know things the accounting system does not. They know the pour got delayed, the steel delivery is late, or the scope is growing. Their input on estimated costs to complete is essential. A WIP built purely from the office, without field input, will miss the story behind the numbers.

Putting WIP Reports to Work in Your Business

A WIP report sitting in a filing cabinet does nothing. Here is how to actually use it.

Monthly WIP review meetings. Block one hour each month to sit down with your project managers and review every active job. Go line by line. Ask why each project is over or underbilled. Ask if the estimated cost to complete is still accurate. This single meeting will catch more profit leaks than almost anything else you can do.

Cash flow planning. Your WIP report tells you where your cash is relative to your work. If you are heavily underbilled, you know you need to push invoicing harder to close the gap. If you are overbilled, you know that cash cushion is temporary and you should not count on it for new equipment purchases or other big expenses.

Bonding and banking. Surety companies and banks love WIP reports. They use them to assess your financial health and your ability to manage projects. A clean, current WIP report makes bonding conversations easier and can help you qualify for larger projects. If your WIP is a mess, expect harder questions and tighter limits.

Spotting troubled projects early. A project with margins shrinking month over month on the WIP is a project in trouble. Catch it at month three instead of month nine and you have options: renegotiate scope, push change orders, reassign crews, or at minimum stop the bleeding before it gets worse.

Year-end tax planning. Your WIP report directly affects your tax liability under percentage-of-completion accounting. Overbillings become liabilities and underbillings become assets on your balance sheet. Understanding these numbers before year-end gives you and your CPA time to plan.

Holding your team accountable. When project managers know their jobs will be reviewed on the WIP every month, they pay closer attention to costs, estimates, and billing. The WIP report creates a culture of financial awareness on the project level, which is where money is actually made or lost in construction.

The WIP report is not glamorous. It is not the kind of thing that makes it onto a conference stage or a podcast highlight reel. But it is the report that separates contractors who know where they stand from contractors who are guessing. And in construction, guessing gets expensive fast.

Curious how this looks in practice? Schedule a demo and we will show you.

Start running your WIP monthly. Update your estimates honestly. Involve your field teams. And use the numbers to make decisions, not just to fill a file folder. Your future self, and your accountant, will thank you.