Construction WIP Report: A Worked Example
Plenty of small contractors never hear the words "WIP report" until a bank or a bonding agent asks for one. Then it sounds like an accounting exam. It is not. It is one row per open job and a little arithmetic, and the number the whole row hangs on is your estimated total cost. The job cost calculator adds labor, materials, subs and other costs to get it. This post walks one job through every column, then a 3-job schedule. It is information, not accounting or tax advice: your CPA decides how your books handle it.
What a WIP report is (and who asks for it)
A WIP report, or work in progress schedule, answers one question for each open job: have you billed more or less than the work you have done is worth? Lenders and bonding agents may ask for one to see if your cash and your jobs line up. A small remodeler who keeps cash-basis books may never be asked. Even then, it is a useful check once a month, because it shows a job that is quietly eating your cash before the job ends.
The 8 columns, in plain words
| Column | What it means | Where the number comes from |
|---|---|---|
| Contract price | What the client agreed to pay, with approved changes | The contract and signed change orders |
| Estimated total cost | What you expect the whole job to cost | Your bid cost, updated when it changes |
| Cost to date | What you have spent so far | Receipts, hours and subs logged to the job |
| Percent complete | How far along the job is, by cost | Cost to date / estimated total cost |
| Earned revenue | What the finished work is worth so far | Contract x percent complete |
| Billed to date | What you have invoiced | Your invoices |
| Over (under) billed | Billed minus earned | Billed to date - earned revenue |
| Cost to complete | What is left to spend | Estimated total cost - cost to date |
The contract and the estimate change when a change order is approved. That is one more reason to track change orders in writing: a change that is not in both columns makes every number after it wrong.
One job, worked line by line
Job A uses the same sample numbers the job cost calculator starts with, so you can check them yourself: 120 labor hours at $45, $8,500 in materials, $6,000 in subs, $900 other. That is $20,800 of cost. At a 35% markup the contract is $28,080, with $7,280 of expected gross profit (25.9%). Now say the job is partway done:
| Line | Math | Amount |
|---|---|---|
| Contract price | From the calculator | $28,080 |
| Estimated total cost | From the calculator | $20,800 |
| Estimated gross profit | $28,080 - $20,800 | $7,280 |
| Cost to date | Example input | $12,480 |
| Percent complete | $12,480 / $20,800 | 60% |
| Earned revenue | $28,080 x 60% | $16,848 |
| Billed to date | Example input | $18,000 |
| Over (under) billed | $18,000 - $16,848 | $1,152 over |
| Gross profit earned so far | $16,848 - $12,480 | $4,368 |
| Cost to complete | $20,800 - $12,480 | $8,320 |
Over-billed vs under-billed: which one hurts
Over-billed means you have been paid for work you have not done yet. Job A is $1,152 over. That cash is not profit: you owe the client that much work. Spend it on something else and you will be short when the last weeks of the job come due.
Under-billed means you have done work you have not invoiced. That is a cash gap: your money is sitting in the client's house. A little of it is normal between invoices. A lot of it, month after month, means your progress billing is behind the work.
A 3-job WIP schedule
Here is a small shop with three open jobs. Job B just started and has its deposit in. Job C was priced with the overhead and profit calculator: $30,000 cost, 20% overhead, 10% profit, which comes to $41,250 ($30,000 x 1.10 / 0.80). Its WIP gross profit of $11,250 holds $8,250 of overhead and $3,000 of profit, so do not read WIP profit as money you keep.
| Job | Contract | Est. cost | Cost to date | % done | Earned | Billed | Over (under) |
|---|---|---|---|---|---|---|---|
| A | $28,080 | $20,800 | $12,480 | 60% | $16,848 | $18,000 | $1,152 |
| B | $12,000 | $9,000 | $2,250 | 25% | $3,000 | $4,500 | $1,500 |
| C | $41,250 | $30,000 | $24,000 | 80% | $33,000 | $30,000 | ($3,000) |
| Total | $81,330 | $59,800 | $38,730 | - | $52,848 | $52,500 | ($348) net under |
The shop as a whole is only $348 under-billed, which looks fine. The rows tell the real story: Jobs A and B are carrying $2,652 of cash Job C has not been billed for. That is the point of a WIP schedule. The total hides it; the rows show it.
Why the numbers lie if cost to date is wrong
Every column after cost to date depends on it. If receipts sit in the truck for a week and hours are logged on Friday, cost to date is low. Then percent complete is low, earned revenue is low, and a job can look over-billed when it is not. The reverse happens too: materials bought but not installed can make a job look further along than it is. Ask your CPA how your books treat those.
This is why a WIP report is only as good as your job costing. If you are new to it, start with what job costing is, then the habit of how to track job profitability while the job runs. Whether you keep cash or accrual books changes how your CPA uses these numbers, but not how you collect them.
- No receipt is missing from a job
- Every hour is logged to its job
- Signed change orders are in both the contract and the estimate
- The estimated total cost is current, not the original bid
Percentage of completion vs completed contract
These are two ways to count revenue on a job that runs a long time. The percentage of completion method counts revenue as the work gets done: it is the earned revenue column above, and a WIP report is built on it. The completed contract method counts the revenue and the profit only when the job is finished.
Take Job A at 60% complete. Percentage of completion says $16,848 is earned so far ($28,080 x 60%). Completed contract says $0 is earned until the job is done, then all $28,080 at once. Same job, same cash, very different numbers on paper.
Which method you may use for taxes is set by the tax rules for long-term contracts (section 460 of the tax code), and smaller contractors can qualify for exceptions. That call is your CPA's. Either way, you can still keep a WIP report for yourself and your bank, and it still needs an honest cost to date.
Where the app fits (honest limits)
The hard part of a WIP report is the cost-to-date column. That is the part I built Job Cost Pro for: it keeps cost to date on each job as receipts and hours come in, and shows margin from costs recorded so far. You photograph receipts and the AI reads the line items (when the receipt names the job or you scan at the jobsite, it suggests that job for one tap to confirm). It does not make a WIP report or work out over and under billing; you or your CPA do that from its numbers. It is not a scheduling tool. Free on the App Store: 3 jobs, 50 receipts a month, AI scanning included, no card. Get it here.
For the other reports worth reading each month, see job costing reports.
Track your next job with Job Cost Pro
Scan receipts, confirm the suggested job, and see your recorded costs against your budget. Start with the free plan in your browser or get the iPhone app.
Google Play: US only.
Free plan available. Some features require a paid plan.
FAQ
What is a WIP report in construction?
A work in progress report lists every open job with its contract price, estimated total cost, cost to date and billings to date. From those it shows percent complete, earned revenue, and whether each job is over-billed or under-billed.
How do you calculate percent complete on a WIP report?
The common way is cost to date divided by estimated total cost. In the example here, $12,480 spent on a job estimated at $20,800 is 60% complete. Ask your CPA which method your books use.
What does over-billed mean in construction?
You have billed more than the work done is worth so far. In the example, $18,000 billed against $16,848 earned is $1,152 over-billed. That cash is owed work, not profit.
Is under-billing bad?
Not by itself. A little under-billing between invoices is normal. A large or growing amount means you are doing work you have not invoiced, which is a cash gap. Send the next progress bill.
Do small contractors need a WIP report?
Not always. Lenders and bonding agents may ask for one, and a cash-basis remodeler may never be asked. It is still a useful monthly check on whether your billing keeps up with your work.