How to Read a Construction WIP Report: Why a Cash-Rich Month Can Mean You Are Overbilled
On this page
- Quick Answer: How to Read a WIP Report
- The Four Numbers a WIP Schedule Runs On
- One Job, Three Months: Watching the Gap Open
- The Trap: Budget Spent Is Not Percent Complete
- Change Orders: The Quiet Distorter
- Widening the Lens: A Portfolio WIP Schedule
- The Tax Side: WIP Is Not Just a Management Report
- Why This Reaches Past Your Books: Bonding and Lending in Florida
- What Clean WIP Reporting Requires
- What the Bank Balance Will Never Tell You
How the work-in-progress schedule reveals what your bank balance hides, walked through with real numbers. Reference content for Florida trade business owners. Reviewed against ASC 606 and construction accounting sources, 2026.
It is the end of the month and the operating account looks healthy. Deposits came in, the balance is up, and the instinct is to read that as a good month. For a contractor, that instinct is dangerous. A full bank account can sit on top of a job that has already lost money, or a job where the cash belongs to work you have not performed yet. The number that tells you which one you are looking at is not your bank balance. It is your work-in-progress schedule.
The WIP report is the one document that separates how much you have billed from how much you have actually earned. On a long construction job those two numbers drift apart, sometimes by tens of thousands of dollars, and the gap is invisible in your checking account. A contractor who reads only the bank balance is flying blind on the exact metric that bonding companies, banks, and the IRS care about most.
This walkthrough takes a single job month by month, then widens to a full portfolio, and shows what the WIP schedule reveals that the bank balance cannot. The math is not complicated. Reading it correctly is what protects your cash and your bonding capacity.
Quick Answer: How to Read a WIP Report
A WIP (work-in-progress) report shows, for every active job, how much revenue you have actually earned versus how much you have billed. The gap between the two is the number that matters. If you have billed more than you have earned, you are overbilled, and that extra cash is a liability, not profit. If you have earned more than you have billed, you are underbilled, and you are owed money you have not invoiced. The three formulas that produce it:
| WIP formula | Calculation |
|---|---|
| Percent complete | Costs to Date ÷ Estimated Total Cost |
| Earned revenue | Percent Complete × Contract Value |
| Over/(under) billing | Earned Revenue − Billings to Date |
A positive over/under figure (earned exceeds billed) means underbilling, an asset: you have done work you have not invoiced yet. A negative figure (billed exceeds earned) means overbilling, a liability: you have collected cash for work you still owe. The rest of this guide walks those formulas through a real job, then a four-job portfolio, and shows why the gap is invisible in your bank account and decisive on your balance sheet.
The Four Numbers a WIP Schedule Runs On
The cheat sheet above gives you the formulas. This is where they come from, and why the inputs behind them decide whether the output is trustworthy. A WIP schedule is built from a small set of inputs and three calculations. Every credible source on percentage-of-completion accounting uses the same formulas (the method recognized under ASC 606 and the legacy percentage-of-completion guidance).
The inputs for each job:
- Contract value (current, including approved change orders)
- Estimated total cost (the full job budget, the most sensitive number on the report)
- Costs to date (every dollar posted to the job: materials, labor, equipment, subcontractors)
- Billings to date (what you have actually invoiced)
The three calculations:
- Percent complete = Costs to Date ÷ Estimated Total Cost
- Earned revenue = Percent Complete × Contract Value
- Over/under billing = Earned Revenue − Billings to Date
That last line is the whole point. A positive earned-minus-billed number means you have earned more than you billed: you are underbilled, and that gap is an asset, work you have done but not invoiced. A negative number means you billed more than you earned: you are overbilled, and that gap is a liability, cash you are holding for work you still owe (Wegner CPAs, percentage-of-completion method; ASC 606).
Hold onto that. Overbilling is a liability, not a profit. The cash is in your account, but the balance sheet says you owe the work.
One Job, Three Months: Watching the Gap Open
Take a single commercial build-out. Contract value $300,000, estimated total cost $240,000 (so the job is budgeted to make $60,000 gross profit). Front-loaded billing schedule, which is common and not wrong by itself. Here is how the WIP math reads at three points.
| Month 1 | Month 2 | Month 3 | |
|---|---|---|---|
| Contract value | $300,000 | $300,000 | $300,000 |
| Estimated total cost | $240,000 | $240,000 | $260,000 |
| Costs to date | $48,000 | $132,000 | $208,000 |
| Percent complete | 20% | 55% | 80% |
| Earned revenue | $60,000 | $165,000 | $240,000 |
| Billings to date | $90,000 | $165,000 | $230,000 |
| <strong>Over/(under) billed</strong> | <strong>$30,000 over</strong> | <strong>$0</strong> | <strong>($10,000) under</strong> |
Read across the bottom row, because that is the story the bank balance never tells.
Month 1. The contractor billed $90,000 but only earned $60,000. That is $30,000 overbilled. The checking account looks great, $90,000 came in, but $30,000 of it is a liability. It is cash collected for work not yet done. A contractor who sees the deposit and spends against it is spending the customer’s money, and will have to perform that $30,000 of work later with no new billing to cover it.
Month 2. Billings and earned revenue line up exactly. Healthy. This is what the schedule is supposed to look like mid-job.
Month 3. Two things happened. The estimate rose from $240,000 to $260,000 (cost overruns, or change-order work that was not re-estimated), and now the contractor is underbilled by $10,000. Underbilled means earned revenue is sitting uninvoiced, an asset, money the contractor has the right to bill but has not. The cash is owed to the contractor, not in the account. If billing does not catch up, the contractor finances that $10,000 out of pocket.
Notice what moved the numbers in Month 3. The estimate changed. That is the most sensitive input on the entire schedule. If the estimated total cost is wrong, percent complete is wrong, earned revenue is wrong, and the over/under position is wrong. A WIP schedule is only as honest as the cost estimate feeding it.
The Trap: Budget Spent Is Not Percent Complete
The single most common WIP error is using “how much of the budget we have spent” as a stand-in for “how much of the work is done.” They are not the same number.
A job can be 80% through its budget and only 60% complete if costs have run over. Using budget-spent as the progress measure overstates percent complete, which overstates earned revenue, which makes an overbilled job look balanced and a losing job look profitable. Percent complete must reflect costs incurred against a current, honest estimate of total cost, with approved change orders folded into both the contract value and the cost estimate. Pending change orders that the client has not signed should be tracked separately, not baked into contract value, because they inflate earned revenue on work that may never be authorized.
This is also where gross profit hides. Gross profit to date is earned revenue minus costs to date. In Month 3 above, that is $240,000 − $208,000 = $32,000 of gross profit recognized, against a job budgeted for $60,000. The margin is eroding as the estimate climbs, and the WIP schedule shows it months before the final invoice would.
Change Orders: The Quiet Distorter
Change orders deserve their own warning, because they distort a WIP schedule in two directions and both are common.
When a change order is approved, it raises the contract value and usually the estimated cost. Folding it into both keeps the schedule honest. The error is folding a change order into contract value (which raises earned revenue) without updating the estimated cost to match, which inflates margin on work you have not priced correctly. The opposite error is performing change-order work, raising your costs, but not yet updating the contract value because the paperwork is not signed. Now your costs climbed, percent complete jumped, and earned revenue is being calculated against a contract value that does not include the change. The schedule shows margin erosion that is really just unbilled scope.
The discipline: only approved change orders move contract value. Pending ones are tracked on the side. And every approved change order updates the estimate in the same motion, so percent complete stays tied to a current, honest total. Contractors who batch their change-order paperwork for month-end, or quarter-end, are guaranteeing that their WIP schedule is wrong for most of the period.
Widening the Lens: A Portfolio WIP Schedule
One job teaches the mechanics. A real contractor runs several at once, and the portfolio WIP schedule is what a bonding company and a bank actually want to see. Here is a four-job snapshot.
| Job | Contract | Est. cost | Costs to date | % complete | Earned | Billed | Over/(under) |
|---|---|---|---|---|---|---|---|
| A. Medical office | $850,000 | $680,000 | $476,000 | 70% | $595,000 | $640,000 | $45,000 over |
| B. Restaurant | $500,000 | $400,000 | $340,000 | 85% | $425,000 | $400,000 | ($25,000) under |
| C. Warehouse | $1,200,000 | $960,000 | $288,000 | 30% | $360,000 | $300,000 | ($60,000) under |
| D. School addition | $300,000 | $250,000 | $237,500 | 95% | $285,000 | $277,000 | ($8,000) under |
Each line tells a different story, and none of it is visible in a single bank balance.
Job A is overbilled by $45,000. On a healthy, mid-stage job a moderate overbilling from front-loaded billing is normal, but $45,000 is cash the contractor is holding against work still owed. Spend it as profit and the back half of the job has to be funded from somewhere.
Job B is underbilled by $25,000 at 85% complete. The contractor has performed $425,000 of work and only billed $400,000. There is $25,000 in earned revenue sitting uninvoiced. This is not a problem to monitor; it is a billing to send this week.
Job C is the red flag. Underbilled by $60,000 at only 30% complete. The job is barely started and billing is already $60,000 behind earned revenue. If that pattern holds to completion, the contractor could be financing a quarter-million dollars of this project out of working capital before catching up. The billing schedule on Job C needs to be fixed now, not at the next pay application.
Job D is nearly done and close to balanced. Boring, which is exactly what a closing job should be.
Read together, this portfolio tells one story. One job is feeding cash the business may be over-spending (A). Two jobs are quietly lending the owner’s money to the customer (B and C). And the business needs to accelerate billing before Job C strains everything. The operating account, meanwhile, might look fine all month, because Job A’s overbilling masks the underbilling everywhere else.
The Tax Side: WIP Is Not Just a Management Report
The WIP schedule is also where a contractor’s tax method lives, and that connection catches owners who treat WIP as a purely internal tool.
For long-term contracts, the tax rules generally push larger contractors toward the percentage-of-completion method for recognizing income, the same cost-to-cost logic the WIP schedule already runs on. Smaller contractors may qualify for exceptions that allow other methods. Eligibility is tied to thresholds that adjust over time, so the method you are allowed to use is not a permanent given, and should be confirmed against current IRS rules for your size of business. The practical point is the link. The same earned-revenue figure that tells you whether you are overbilled also drives how much income you recognize for tax in a given year. A WIP schedule that overstates percent complete does not just mislead management; it can overstate taxable income, or understate it, depending on the direction of the error.
This is why the estimate discipline matters beyond cash management. An estimate that is quietly wrong all year produces a WIP schedule that misstates earned revenue, which flows into the income you report. The contractor who keeps the schedule honest month to month is also keeping the tax position defensible. The one who reconstructs it at year-end is making a tax representation out of a guess. Because the method rules and thresholds shift, the specific method a given contractor should use is a question for a CPA against current-year IRS guidance, not a rule of thumb. But the underlying truth holds: clean WIP data is the foundation the tax method sits on.
Why This Reaches Past Your Books: Bonding and Lending in Florida
For a Florida contractor, the WIP schedule is not just an internal tool. It is the document a surety underwriter reads before issuing or renewing a bond, and the document a bank reads before extending a credit line.
Surety companies ask for a WIP schedule at every bond renewal, and often mid-year on larger accounts. They are evaluating financial discipline: are your estimates reliable, are you chronically overbilled (which signals you are using customer cash as working capital), is your underbilling growing. Underwriters read underbilling by stage, not just size. Underbilling early in a job, like Job C above, is usually a billing-timing problem to fix. Underbilling that shows up late in a job worries them more, because it often signals unapproved change orders or profit that is fading without being recognized yet, which means the net worth on your balance sheet may be overstated. A clean, accurate WIP schedule expands the size of project you can be bonded for. A sloppy one shrinks your bonding capacity, which in Florida’s construction market directly limits the public and commercial work you can bid.
Underwriters also look hard at consistency. A WIP schedule where percent complete was overstated because the estimate was not updated after change orders is exactly the kind of thing a surety analyst flags, because it tells them the contractor’s reported margins cannot be trusted. Banks reading WIP schedules for a line of credit ask the same questions, and a GAAP-basis WIP schedule is typically what they require to lend against work in progress. In both cases, the contractor who maintains the schedule monthly walks in with a defensible picture of every active job and borrows or bonds against it. The contractor who reconstructs it the night before the renewal walks in with numbers that fall apart under the first question.
What Clean WIP Reporting Requires
The formula takes minutes once the inputs are clean. Getting the inputs clean is the real work, and it is where most contractors lose the thread.
It requires costs coded to the right job in real time, not reconstructed at month-end. It requires the cost estimate updated whenever an approved change order or a genuine overrun changes the picture. It requires billings tracked against earned revenue, not just against the billing schedule. And it requires the discipline to read the over/under line every month and act on it: bill the underbilling before it strains cash, and treat the overbilling as the liability it is rather than spendable profit.
A contractor running this monthly always knows which jobs are funding themselves and which are quietly bleeding. That is the difference between a WIP schedule that protects the business and a bank balance that flatters it right up until the job closes at a loss.
What the Bank Balance Will Never Tell You
Your bank balance tells you how much cash moved. Your WIP schedule tells you whether that cash is yours. Overbilling looks like a good month and is actually a liability; underbilling looks like nothing and is actually money you are owed. The gap between billed and earned is invisible in the operating account and decisive on the balance sheet, and in Florida it is the number that sets your bonding capacity. Run the WIP monthly, keep the estimate honest, fold approved change orders into both contract value and cost, and read the over/under line as the truth the bank balance is hiding.
The contractors who get into trouble are rarely the ones doing bad work. They are the ones doing good work while reading the wrong number, spending an overbilled month as profit, letting an underbilled job quietly drain working capital, walking into a bond renewal with a schedule that cannot survive a follow-up question. None of those failures show up in the bank balance until it is too late to fix them cheaply. All of them show up in a WIP schedule the month they start. The bank balance tells you the money moved. Only the WIP tells you whose it was, and a schedule kept accurately every month, not reconstructed at renewal, is what turns that answer into bonding capacity instead of a surprise.
This article is general information, not legal, tax, or accounting advice. Construction tax, sales tax, payroll, and classification rules are complex, fact-specific, and change over time. Tax figures, statutory limits, and regulatory rules cited here reflect the law as understood at the time of writing and may since have changed; rates and thresholds in particular are commonly updated year to year. Nothing here creates a professional relationship or should be acted on without confirming how the current rules apply to your specific situation with a licensed CPA, tax professional, or attorney familiar with Florida construction. Where a number or rule drives a real decision, verify it against the primary source (the IRS, the Florida Department of Revenue, or the relevant Florida Statute) or with your own advisor before relying on it.