A WIP schedule example for a custom home builder, with the math shown
Three houses, every column calculated, and what each number tells you to do next. Illustrative figures, not a real client.
Short answer: A WIP schedule lists each open house with its contract, estimated total cost, cost to date, percent complete, revenue earned, amount billed and the difference. On the cost-to-cost method, percent complete is cost to date divided by estimated total cost, and revenue earned is that percentage times the contract. If you billed more than you earned, the house is overbilled. If you billed less, it is underbilled.
The example: three houses, all numbers illustrative
These houses are made up so the arithmetic is easy to follow. Nothing here is a client or an industry benchmark. The method is cost to cost, the most common one for builders: percent complete equals cost to date divided by estimated total cost at completion.
| Column | House A | House B | House C |
|---|---|---|---|
| Contract price (with approved changes) | $1,000,000 | $1,500,000 | $800,000 |
| Estimated total cost at completion | $800,000 | $1,260,000 | $640,000 |
| Estimated gross profit | $200,000 | $240,000 | $160,000 |
| Estimated gross margin | 20.0% | 16.0% | 20.0% |
| Cost to date | $480,000 | $945,000 | $128,000 |
| Percent complete (cost to date / estimated cost) | 60.0% | 75.0% | 20.0% |
| Revenue earned (percent complete x contract) | $600,000 | $1,125,000 | $160,000 |
| Billed to date | $650,000 | $1,050,000 | $200,000 |
| Over (under) billing (billed - earned) | $50,000 over | $75,000 under | $40,000 over |
| Gross profit earned to date (earned - cost) | $120,000 | $180,000 | $32,000 |
| Cost to complete (estimate - cost to date) | $320,000 | $315,000 | $512,000 |
| Revenue left to earn (contract - earned) | $400,000 | $375,000 | $640,000 |
Company totals: contracts $3,300,000, revenue earned $1,885,000, billed $1,900,000, so the company is net overbilled by $15,000. Estimated gross profit across the three houses is $600,000, or 18.2 percent. Gross profit earned to date is $332,000.
How to read each house
House A: overbilled, on plan
You have billed $50,000 more than you have earned. That is cash you hold ahead of the work, and it is a liability on the balance sheet until the work catches up. Margin is on its 20 percent plan, so the question is only whether the extra billing is funding this house or being spent on another one.
House B: underbilled, and the margin has faded
Say you priced House B at 20 percent, which would have been an estimated cost of $1,200,000. The current forecast is $1,260,000, so estimated margin is now 16 percent. That is four points of fade on a $1,500,000 house, or $60,000. You are also $75,000 underbilled, which means you have done work you have not yet billed. Two things to check this month: the next draw or invoice, and whether any of the extra $60,000 is a change you can still price.
House C: early, so the percentage is volatile
At 20 percent complete, a small change to the estimate moves revenue earned a lot. Overbilling of $40,000 is common early because of deposits and the first draw. Do not read much into early percentages. Review the estimate by cost code instead.
Want a WIP schedule built from your own houses? Request a Relationship Assessment.
The formulas, in one list
- Percent complete = cost to date / estimated total cost
- Revenue earned = percent complete x contract price
- Over or under billing = billed to date - revenue earned
- Gross profit earned = revenue earned - cost to date
- Cost to complete = estimated total cost - cost to date, ideally forecast by cost code, not budget less spent
Where WIP schedules go wrong
The estimated cost is stale. Percent complete is only as good as the estimate at completion. If you never revise it, margin looks perfect until the last invoices arrive. Unbilled or unpriced changes are left out of the contract column. Costs are coded to the wrong house, so one house shows more percent complete than it has earned and another shows less. Uninstalled materials inflate cost to date, so some builders exclude them from percent complete, as covered in our guide on uninstalled materials. And for tax, a home construction contract can use a different method than your management WIP, so ask your CPA which applies.
This is a management schedule. It does not replace the method your CPA uses for income tax, and it is not accounting or tax advice.
Build your own
You can lay this out in a spreadsheet in an afternoon. Our free WIP schedule template has the same columns with the formulas built in, and you can paste in your own houses. What takes time is keeping the cost-to-complete forecast honest every month, which is where most builders fall behind.
How we help
Our team codes every cost to the house, builds the WIP schedule from your job cost records and reviews the over and under billing with you each month. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.
Sources
- CFMA, WIP Accounting: Critical and Often Misunderstood
- CFMA, Work-in-Progress in Construction
- Legal Information Institute, 26 CFR 1.460-3, Long-term construction contracts
- FASB, ASC Topic 606, Revenue from Contracts with Customers
Common questions
What is a WIP schedule example for a home builder?
It is a table with one row per open house: contract, estimated cost, cost to date, percent complete, revenue earned, amount billed and over or under billing. This page walks through three houses with every formula shown.
How do you calculate percent complete on a WIP schedule?
On the cost-to-cost method, divide cost to date by estimated total cost at completion. Revenue earned is that percentage times the contract price.
What does overbilled mean on a WIP schedule?
You have billed more than the revenue you have earned to date. The excess is shown as a liability, sometimes called billings in excess of costs and estimated earnings.
What does underbilled mean?
You have earned more than you have billed. The difference is an asset, sometimes called costs and estimated earnings in excess of billings, and it usually means a draw or invoice is due.
How often should a builder update the WIP schedule?
Monthly, after the books are closed, with the cost-to-complete forecast refreshed by cost code.
Is a management WIP schedule the same as my tax method?
Not necessarily. Home construction contracts have their own tax rules, so confirm the method with your CPA.
Related
- How to post the WIP journal entry in QuickBooks Online
- What is a WIP schedule?
- WIP over and under billing
- Forecasting cost to complete by cost code
- Uninstalled materials and percent complete
- Monthly WIP review meeting
- Year-end close and CPA handoff checklist for home builders
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.