WIP Reports in Construction: Job Profitability

You can have every crew booked solid and still lose money. It happens all the time in construction. A company stays busy, invoices go out, cash comes in, and then tax season hits. That is when the owner finds out three jobs lost money and one of them lost a lot.

A WIP report stops that from happening. It is the single best tool a contractor has for knowing the real financial health of every active job. If you are not running one, you are guessing. And guessing in construction is expensive.

This guide breaks down everything you need to know about construction WIP reporting: what it is, how to build one, how to read one, and how to use it to protect your business.

What Is a WIP Report?

WIP stands for Work in Progress. A WIP report is a financial snapshot of every active job your company is working on right now.

For each project, it shows:

• Contract value (what the client agreed to pay)
• Estimated total cost (what you expect the job to cost)
• Costs to date (what you have spent so far)
• Percent complete (how far along the job is)
• Earned revenue (the revenue you have actually earned based on work done)
• Billings to date (how much you have invoiced)
• Over-billing or under-billing (the gap between what you billed and what you earned)

Think of it as a report card for every job. It tells you which projects are on track, which ones are bleeding money, and which ones have billing problems that need attention right now.

The WIP report is not just an internal tool. Banks, bonding companies, and CPAs all use it to judge your company’s financial health. If you want a bond or a line of credit, you will need a clean WIP report.

Why WIP Reports Matter for Contractors

Most contractors track revenue. They know how much they billed last month. But billing is not the same as earning. You can bill $500,000 in a month and still lose money if your costs are out of control.

Here is why construction WIP reporting matters:

Banks Require Them

If you apply for a line of credit or a construction loan, the bank wants to see your WIP report. They want to know that your jobs are profitable and that your cash position is real, not inflated by over-billing.

Bonding Companies Require Them

Before a surety issues a performance bond or payment bond, they review your WIP. A messy WIP report with lots of over-billing or fade (shrinking margins) is a red flag. It can cost you the bond, which means you lose the job.

They Reveal Hidden Problems

A job can look fine on the surface. The crew is working, invoices are going out, and the client is paying. But underneath, the costs might be running 20% over budget. Without a WIP report, you will not know until it is too late.

WIP reports catch these problems early. They show you when a job’s profit margin is shrinking so you can take action before the damage is done.

They Show Your True Financial Position

Your bank account balance does not tell the whole story. If you are over-billed on several jobs, that cash in your account is not really yours. It belongs to future work you have not done yet. A WIP report makes this crystal clear.

Key Components of a WIP Report

A standard construction WIP report has seven columns. Here is what each one means:

1. Contract Value

This is the total amount the client agreed to pay for the project. It includes the original contract plus any approved change orders. If you signed a $500,000 contract and later added a $30,000 change order, your contract value is $530,000.

2. Estimated Total Cost

This is what you expect the job to cost when it is finished. It includes labor, materials, equipment, subcontractors, and your share of overhead. This number should be updated every time something changes on the job.

3. Costs to Date

This is what you have actually spent on the job so far. It includes every dollar that has gone out the door: payroll, material purchases, sub invoices, equipment rentals, and any other direct costs.

4. Percent Complete

This tells you how far along the job is. There are two ways to calculate it (more on that below). The most common method in construction is the cost-to-cost method, which divides costs to date by estimated total cost.

5. Earned Revenue

This is the revenue you have actually earned based on the work completed. You calculate it by multiplying the contract value by the percent complete.

Example: If the contract value is $500,000 and you are 40% complete, your earned revenue is $200,000.

6. Billings to Date

This is the total amount you have invoiced the client so far. It may or may not match your earned revenue. The gap between the two is where over-billing and under-billing show up.

7. Over-Billing or Under-Billing

This is the difference between your billings to date and your earned revenue.

• Billings > Earned Revenue = Over-billed
• Billings < Earned Revenue = Under-billed

Both situations create problems, and we will dig into that below.

How to Calculate Percent Complete

There are two main methods contractors use to figure out how far along a job is. The method you pick affects every other number on your WIP report, so it matters.

Cost-to-Cost Method

This is the most common approach in construction WIP reporting. It uses a simple formula:

Percent Complete = Costs to Date / Estimated Total Cost

Example: You estimated a job would cost $200,000. You have spent $120,000 so far.

$120,000 / $200,000 = 60% complete

The cost-to-cost method is popular because it is based on hard numbers. You can pull the data straight from your job costing system without making judgment calls.

The downside? It assumes costs happen at a steady rate throughout the project. If you front-load material purchases, the formula might say you are 70% complete when the job is really only 50% done physically.

Physical Observation Method

This method uses a field estimate. A project manager or superintendent walks the job and estimates how far along the work is based on what they see.

It can be more accurate for certain types of work, but it is subjective. Two people might look at the same job and come up with different numbers. It is also harder to defend to a bank or bonding company because there is no formula behind it.

Which Method Should You Use?

Most CPAs and bonding companies prefer the cost-to-cost method because it is objective and consistent. If you use physical observation, document your reasoning and keep records. Many contractors use cost-to-cost as the primary method and physical observation as a sanity check.

Over-Billing vs. Under-Billing

This is the part of the WIP report that catches most contractors off guard. Both over-billing and under-billing are problems, just in different ways.

What Is Over-Billing?

Over-billing means you have invoiced the client for more than the work you have completed. Your billings to date are higher than your earned revenue.

Example: You are 30% complete on a $1,000,000 job. Your earned revenue is $300,000. But you have billed the client $400,000. You are over-billed by $100,000.

That $100,000 is not profit. It is money you have collected for work you have not done yet. If costs run over budget, that cash disappears fast.

Why it is a problem:

• It inflates your cash position. You think you have more money than you do.
• It hides job losses. A job can look profitable while it is actually losing money.
• Banks and bonding companies see heavy over-billing as a warning sign.
• If a client disputes work or the project gets delayed, you may owe money back.

What Is Under-Billing?

Under-billing means you have done more work than you have billed for. Your earned revenue is higher than your billings to date.

Example: You are 60% complete on a $500,000 job. Your earned revenue is $300,000. But you have only billed $220,000. You are under-billed by $80,000.

That means you have $80,000 worth of completed work sitting on the table that you have not collected for yet.

Why it is a problem:

• You are financing the project out of your own pocket.
• It creates cash flow problems, especially across multiple jobs.
• It means your billing process is behind, which often signals bigger issues with progress billing.

The Ideal State

You want billings to be close to earned revenue on every job. Small gaps are normal. Large gaps on either side are red flags that need attention right away.

How Often Should You Run WIP Reports?

The short answer: at least once a month. The better answer: as often as your data allows.

Monthly (Minimum)

Every contractor should run a WIP report at the end of each month. This gives you a regular check on job health and catches problems before they snowball. Your CPA will also need monthly WIP data for financial statements.

Weekly (For Large Projects)

If you are running jobs over $500,000 or managing multiple projects at once, weekly WIP reviews make a big difference. A lot can change in a month. Material prices spike. A sub sends an unexpected invoice. A change order gets approved but nobody updates the budget.

Weekly reviews catch these issues while they are still small.

Real-Time (The Goal)

The best contractors do not wait for a report. They track live construction costs in their project management software and review job health throughout the week. When your data is always current, your WIP report is just a summary of what you already know.

Common WIP Reporting Mistakes

A WIP report is only as good as the data behind it. Here are the mistakes that make WIP reports unreliable:

1. Ignoring Change Orders

When a change order gets approved, two things need to happen on the WIP: the contract value goes up, and the estimated cost goes up. If you add the revenue but forget to add the cost (or the other way around), your percent complete and margin calculations will be wrong.

2. Not Updating Estimated Costs

Your original estimate is a starting point, not a fixed number. As the job progresses, you learn things. Material costs change. Scope shifts. Subs come in higher or lower than expected. If you do not update your estimated total cost, your percent complete will be off, and your WIP report will lie to you.

3. Using Old Cost Data

If your WIP report runs on last week’s numbers, it is already outdated. This is a big problem with spreadsheet-based WIP reports. By the time you gather the data, enter it, and run the formulas, the numbers are stale.

4. Lumping Overhead Into Jobs Inconsistently

Some contractors throw all overhead costs into their biggest jobs. Others spread them evenly. Others ignore them entirely. However you handle overhead, be consistent. Changing your method mid-year makes it impossible to compare jobs accurately.

5. Only Running WIP Reports at Year End

If you only look at your WIP report once a year for your CPA, you are using it as a historical document instead of a management tool. By the time you see a problem, it is 12 months old. Monthly reviews are the minimum.

6. Not Reconciling With Your Accounting System

Your WIP report and your accounting records should match. If they do not, one of them is wrong. Reconcile every month to make sure your costs to date, billings, and revenue numbers are accurate.

Using Software to Automate WIP Reporting

Building a WIP report by hand in a spreadsheet takes hours. You have to pull cost data from one system, billing data from another, and contract values from a third. Then you enter it all into a template, double-check the formulas, and hope nothing got copied wrong.

Construction management software like Projul eliminates most of that work. Here is how:

Real-Time Cost Tracking

When your team logs costs in the field, those numbers feed directly into your job cost reports. No manual entry. No waiting for the bookkeeper to catch up. Your costs to date are always current.

Automatic Percent Complete Calculations

With accurate cost data flowing in, the software calculates percent complete using the cost-to-cost method automatically. You do not have to do the math or worry about formula errors.

Built-In Reporting

Projul’s reporting features let you pull a WIP report with a few clicks. Every active job, all in one place, with current numbers. You can run it monthly, weekly, or any time you want to check on job health.

Progress Billing Integration

When your billing is connected to your job progress, you can see over-billing and under-billing in real time. Projul’s progress billing tools keep your invoicing aligned with the actual work completed.

No More Spreadsheet Errors

Spreadsheets break. Formulas get deleted. Someone copies last month’s template and forgets to update a cell. Software removes those risks. The data is entered once, stored in one place, and calculated the same way every time.

How to Use a WIP Report to Make Better Decisions

Running the report is only half the job. You also need to act on what it tells you. Here is what to look for:

Fading Margins

If a job’s projected margin is shrinking month over month, something is wrong. Dig into the costs. Find out what changed. Maybe a sub came in over budget, or material waste is higher than expected. Catch it early and you can still fix it.

Large Over-Billing Balances

If you are over-billed by a large amount on several jobs, be careful. That cash is not yours yet. Do not spend it on new equipment or use it to cover losses on other jobs. Set it aside for the work still ahead.

Consistent Under-Billing

If you are under-billed across multiple projects, your billing process needs work. You are doing the work but not collecting for it. Review your billing schedule and make sure invoices go out on time.

Jobs With No Recent Cost Activity

If a job shows on your WIP but has not had any cost activity in weeks, something is off. Either the job is stalled, or costs are not being recorded. Both need your attention.

WIP Reporting and Your CPA

Your CPA uses your WIP report to prepare financial statements using the percentage of completion method. This is the standard accounting method for construction companies that work on long-term contracts.

Under this method, revenue is recognized based on the percent complete, not based on when you send invoices. That means your WIP report directly affects your income statement and balance sheet.

Give your CPA clean, accurate WIP data every month. It makes their job easier, keeps your financial statements accurate, and helps you avoid surprises at tax time.

If your WIP data is messy, your CPA has to make assumptions. Those assumptions might not match reality, and that can lead to tax problems down the road.

Getting Started With Construction WIP Reporting

If you are not running WIP reports today, start simple:

1. List every active job with its contract value and estimated total cost.
2. Gather your costs to date for each job from your accounting system.
3. Calculate percent complete using the cost-to-cost method.
4. Calculate earned revenue (contract value times percent complete).
5. Compare billings to earned revenue to find over-billing and under-billing.
6. Review the results and look for red flags.

Once you have the process down, move to a monthly schedule. And when you are ready to stop doing it by hand, look into software that handles it for you.

Projul gives contractors real-time job costing, progress billing, and reporting in one platform. You can see exactly where every job stands without building a single spreadsheet.

Check out Projul’s pricing to see which plan fits your company, or book a free demo to see it in action.