A WIP (work-in-process) schedule is a one-page report that reconciles three numbers for every open job — contract or estimate value, earned revenue based on percent complete, and billed-to-date — exposing over-billings and under-billings. Buyers, bankers, and bonding companies ask for it first because it proves revenue is real and correctly timed. A clean, monthly, balance-sheet-reconciled WIP schedule can defend 0.5 to 1.5x of your EBITDA multiple at sale — roughly 1.5 million dollars on a 3 million dollar EBITDA company.
What Is a WIP Schedule and Why Does Every Buyer Ask for One?
If you have ever shown your books to a banker, a bonding agent, or an acquirer, the first document they reach for is not your P&L. It is your WIP schedule. And if you do not have one, the conversation gets quiet.
The boomer-owner retirement wave is real, and the private-equity roll-up landscape is active — Servpro (backed by Blackstone), BluSky (Partners Group and Kohlberg), ATI Restoration, and BELFOR Holdings are all acquiring established mid-market restoration companies. If you are a 2 to 10 million dollar restoration company owner who has fielded an unsolicited offer, or expects to, the WIP schedule is the report that separates a defensible valuation from a discounted one.
This post is a plain-English explainer of what a WIP (work-in-process) schedule is, the three numbers it reconciles, why every serious buyer demands it, how to build one for a restoration company, and how it ties to revenue recognition and your balance sheet. According to Peak Business Valuation, 2024, record and reporting quality alone can move a small-business valuation by 0.5 to 1.5x of EBITDA — and the WIP schedule is one of the documents that judgment hangs on.
The good news: a WIP schedule is not complicated. It is arithmetic. The hard part is having clean job costing underneath it, which is exactly why buyers treat it as a proxy for whether the rest of your books can be trusted.
A WIP schedule reconciles three numbers
At its core, a WIP schedule answers one question for each open job: how much revenue have you actually earned, and how does that compare to what you have billed? It does that by reconciling three numbers.
- Contract or estimate value. What the job is worth — the approved estimate, including any approved supplements. This is the ceiling on revenue for the job.
- Earned revenue. The revenue you have legitimately earned based on how much of the work is done. This is calculated with the cost-to-cost percent-complete method: costs incurred to date divided by total estimated costs, multiplied by the contract value.
- Billed-to-date. What you have actually invoiced the customer or carrier so far, regardless of how much work is done.
The gap between earned revenue and billed-to-date is the whole point. When you have billed more than you have earned, the job is over-billed (billings in excess of costs and earnings). When you have earned more than you have billed, the job is under-billed (costs and earnings in excess of billings).
Small amounts of each are normal. The pattern is what matters. Persistent over-billing means you are pulling tomorrow's cash forward and will face a profit reversal later. Chronic under-billing usually means supplements are not being filed or invoices are lagging behind the work.
Why bankers, buyers, and bonding companies all ask for it
The WIP schedule proves two things a P&L cannot: that your revenue is real (tied to work actually performed, not just invoices sent) and that it is timed to the right period. It also quantifies over- and under-billing and the backlog a buyer is acquiring.
A standard P&L books revenue when you invoice. That lets profit move between periods depending on when you happened to bill — which means a P&L alone can make a so-so quarter look great or bury a great quarter. A buyer cannot underwrite a price on numbers that can shift with billing timing.
The WIP schedule fixes that. By tying revenue to percent complete, it shows what was genuinely earned in the period. It exposes over-billing that will reverse after close (and therefore is not sustainable profit). And it quantifies backlog — the unearned, contracted work the buyer is paying for on day one.
Bonding companies want it for the same reason: it tells them whether you have the working capital and discipline to finish committed work. Bankers want it to size a line of credit against real assets. Buyers want it because it is the fastest read on whether your revenue is honest. When a quality-of-earnings team finds a WIP schedule that does not tie to the balance sheet, that single discrepancy can discount the deal by 0.5 to 2.0x of EBITDA.
| Job | Contract / Estimate | Cost to Date | % Complete | Earned Revenue | Billed to Date | Over / (Under) Billing | |---|---|---|---|---|---|---| | Maple St. water mit. | 48,000 | 38,000 | 95% | 45,600 | 48,000 | 2,400 | | Oakwood fire rebuild | 320,000 | 96,000 | 40% | 128,000 | 90,000 | (38,000) | | Riverside contents | 62,000 | 31,000 | 50% | 31,000 | 35,000 | 4,000 | | Cedar Ct. mold remed. | 90,000 | 72,000 | 80% | 72,000 | 60,000 | (12,000) | | Totals | 520,000 | 237,000 | — | 276,600 | 233,000 | (43,600) |
Read the totals row the way a buyer does. Net under-billing of 43,600 dollars means this company has earned more than it has billed — there is real, performed work sitting uninvoiced. The Oakwood rebuild is the big under-billed job (likely a pending supplement); Maple St. and Riverside are modestly over-billed because deposits ran ahead of work. The net figure must tie to the balance sheet.
How to build one for a restoration company
You build a WIP schedule from five inputs, and four of them come straight out of clean job costing.
- List every open job at the close date — anything signed and started but not fully billed and closed.
- Pull costs incurred to date per job. This is where job costing has to be right: every labor hour, material purchase, subcontractor invoice, and equipment charge coded to the correct job.
- Estimate total cost at completion per job. Use the budget from the estimate, adjusted for known changes.
- Calculate percent complete (cost to date divided by total estimated cost) and multiply by contract value to get earned revenue.
- Pull billed-to-date per job and subtract earned revenue to get the over- or (under-) billing.
A note on the cap: earned revenue should never exceed contract value. If a job's costs blow past the estimate, that is a fade you flag — not a reason to recognize more than the contract is worth.
Backlog falls out of the same data. For each job, backlog equals contract value minus earned revenue; sum it for total backlog. That is the contracted-but-unearned work a buyer is acquiring, and it is one of the first numbers they will ask you to defend.
If your job costs are messy, no template fixes this — the inputs have to be right first. That is why a WIP schedule is such a strong proxy for overall books quality.
Get the WIP Schedule Template
The exact spreadsheet format buyers, bankers, and bonding companies expect — with the percent-complete and over/under-billing formulas built in. Plug in your open jobs and it reconciles for you.
How it ties to revenue recognition and the balance sheet
The WIP schedule is how you operationalize percent-complete revenue recognition each month. Revenue recognition is the policy — recognize revenue as work is performed; the WIP schedule is the worksheet that calculates the earned figure and the adjustments that flow onto the balance sheet.
Those adjustments land in two accounts:
- Under-billings become a current asset, usually labeled costs and estimated earnings in excess of billings. In the sample above, that is the Oakwood and Cedar Court jobs.
- Over-billings become a current liability, usually labeled billings in excess of costs and estimated earnings. That is the Maple St. and Riverside jobs.
The totals row of the WIP schedule must tie to those balance-sheet accounts every period. When it does, your monthly profit is accurate and a buyer can trust it. When it does not, you have an unexplained gap — and an unexplained gap on the WIP schedule is one of the most expensive findings in due diligence.
Mitigation jobs that open and close inside 30 days can often be handled more simply. But if you carry meaningful reconstruction work spanning 60, 90, or 180 days at month-end, percent-complete and a monthly WIP schedule are the only way to report honest profit.
A WIP schedule is arithmetic, but it is the highest-signal document in restoration due diligence. Run it monthly, tie it to the balance sheet, and you defend the top of your multiple range. Reverse-engineer it the week a buyer asks, and you invite a discount of 0.5 to 2.0x of EBITDA. On a 3 million dollar EBITDA business, that swing is worth 1.5 to 6 million dollars.
Free Exit Readiness Assessment
We'll show you what your books would look like to a buyer today — and the specific gaps costing you multiple. 30 minutes, no obligation.
Common mistakes that cost owners multiple
- Producing a WIP schedule only when a buyer asks. A schedule with no monthly history reads as reverse-engineered. Buyers want years of consistent, maintained reports.
- A WIP schedule that does not tie to the balance sheet. This is the single most common and most damaging finding. The totals must reconcile to under- and over-billing accounts.
- Recognizing revenue above contract value. When a job's costs exceed the estimate, that is a fade to disclose — not license to book more than the contract is worth.
- Ignoring pending supplements. Leaving approved supplement work out of contract value understates earned revenue and backlog, and it usually shows up as chronic under-billing.
- Dirty job costing underneath the schedule. If costs are coded to the wrong jobs, percent complete is wrong, and the entire schedule is fiction. Fix job costing first.
- Front-loading deposits and calling the cash profit. Heavy over-billing is borrowed cash, not earned profit, and it reverses after close.
- Treating mitigation and reconstruction the same. Long reconstruction jobs need percent complete; lumping them with same-week mitigation distorts monthly profit.
Frequently Asked Questions
What is a WIP schedule in simple terms?
A WIP (work-in-process) schedule is a one-page table that lists every open job and reconciles three numbers: the contract or estimate value, the revenue you have actually earned based on percent complete, and the amount you have billed to date. The gap between earned and billed reveals whether each job is over-billed or under-billed. It is the first report bankers, buyers, and bonding companies ask for.
Why does every buyer ask for a WIP schedule?
Because it proves your revenue is real and timed correctly. A buyer cannot trust a P&L that books revenue when invoices go out, because that can hide profit in one period and pull it from another. The WIP schedule ties revenue to actual work performed, exposes over-billing that will reverse after close, and quantifies the backlog the buyer is paying for. Without it, a buyer assumes the worst and discounts the price.
How do you calculate percent complete on a restoration job?
The standard method is cost-to-cost: divide costs incurred to date by total estimated costs for the job. If a fire job has total estimated costs of 100,000 dollars and you have incurred 60,000 dollars, the job is 60 percent complete. You then multiply percent complete by the contract value to get earned revenue. This is what every CPA, banker, and buyer expects, and it works for both mitigation and reconstruction.
What is the difference between over-billing and under-billing?
Over-billing (billings in excess of costs and earnings) means you have invoiced more than you have earned — common when you front-load a deposit or progress-bill ahead of the work. Under-billing (costs and earnings in excess of billings) means you have done work you have not yet invoiced, often because a supplement is still pending. Over-billing is a liability on the balance sheet; under-billing is an asset. Both are normal in small amounts, but a buyer studies the pattern.
Is a WIP schedule the same as revenue recognition?
They are tightly linked but not identical. Revenue recognition is the accounting policy that determines when revenue hits your income statement; the percent-complete method recognizes revenue as work is performed. The WIP schedule is the supporting worksheet that calculates earned revenue and the over- and under-billing adjustments that flow onto the balance sheet. In practice, the WIP schedule is how you operationalize percent-complete revenue recognition each month.
Do restoration companies actually need percent-complete accounting?
Mitigation jobs that open and close inside 30 days can often be handled on a completed-job or simplified basis. But reconstruction jobs spanning 60, 90, or 180 days distort financials badly under cash or invoice-based accounting. If you carry meaningful open reconstruction work at month-end, a percent-complete WIP schedule is the only way to report accurate monthly profit — and the only way to survive buyer due diligence.
How does the WIP schedule connect to my balance sheet?
The totals row must reconcile to two balance-sheet accounts: under-billings appear as a current asset (often labeled costs in excess of billings), and over-billings appear as a current liability (billings in excess of costs). If your WIP totals do not tie to the balance sheet, a buyer's quality-of-earnings team will flag it immediately, and that single discrepancy can cost you 0.5 to 1.0x of multiple.
What is backlog and why do buyers care about it?
Backlog is the unearned portion of your signed work — contract value minus earned revenue, summed across open jobs. It represents revenue and profit the buyer is acquiring on day one. A strong, documented backlog supports a higher multiple because it de-risks the first year post-close. The WIP schedule is where backlog is quantified job by job, which is why buyers read it before your sales pipeline.
How often should I produce a WIP schedule?
Monthly, as part of your close, reconciled to the same period's balance sheet. Producing one only when a buyer asks is a red flag — it signals the report was reverse-engineered. Owners who run a monthly WIP schedule for years going into a sale present clean, consistent history, which is exactly what supports the top of the multiple range.
Can a WIP schedule reveal problems before a buyer finds them?
Yes, and that is its quiet value. Persistent over-billing can mean you are borrowing tomorrow's cash today and will face a margin reversal. Chronic under-billing can mean supplements are not being filed or AR is being neglected. A negative or shrinking gross profit on a nearly complete job signals a fade. Running the schedule monthly lets you fix these issues on your timeline rather than across a negotiating table.
Will my QuickBooks produce a WIP schedule automatically?
Not by default. QuickBooks Online captures the cost and billing data, but you typically build the WIP schedule in a structured worksheet driven by accurate job costing and class tracking. If your job costs are clean and every cost is coded to the right job, the schedule assembles in minutes. If your job costing is messy, no template will save you — the inputs have to be right first.
What does a clean WIP schedule do for my valuation?
Record and reporting quality moves a restoration valuation by roughly 0.5 to 1.5x of EBITDA, and the WIP schedule is one of the highest-signal documents in that judgment. On a 3 million dollar EBITDA company, half a turn of multiple is 1.5 million dollars. A clean, monthly, balance-sheet-reconciled WIP schedule tells a buyer your revenue is real and your books are trustworthy — and that confidence is worth real money at close.
Key Takeaways
- A WIP schedule reconciles three numbers per open job: contract value, earned revenue (cost-to-cost percent complete), and billed-to-date.
- The gap between earned and billed produces over-billings (a liability) and under-billings (an asset); the pattern, not the snapshot, is what buyers study.
- Bankers, buyers, and bonding companies all ask for it because it proves revenue is real, correctly timed, and quantifies backlog.
- The totals row must tie to the balance sheet every month; an unexplained gap can discount a deal by 0.5 to 2.0x of EBITDA.
- Clean job costing is the prerequisite — no template fixes bad inputs.
- Run it monthly for years before a sale; reporting quality is worth 0.5 to 1.5x of multiple, or roughly 1.5 million dollars on a 3 million dollar EBITDA company.
Sources Cited
- Peak Business Valuation, 2024 — multiples for owner-operated and lower-mid-market businesses; the 0.5 to 1.5x impact of record and reporting quality on valuation.
- RIA Cost of Doing Business Report, 2024 — restoration industry margin and operating benchmarks that frame backlog and profit quality.
Related reading: The Complete Guide to Insurance Billing and Accounting for Restoration · How to Read a Job-Level P&L · Restoration Company Valuation Multiples · Getting Your Books Ready to Sell a Restoration Company · What a PE Buyer Looks for in Restoration Due Diligence