WIP schedule template for custom home builders
Enter up to six houses and see percent complete, revenue earned, over and under billing and gross profit earned. Download the same layout as a spreadsheet with formulas.
Short answer: A WIP schedule shows, for each open house, contract price, estimated cost at completion, cost to date, percent complete, revenue earned and billings. On the cost-to-cost method, percent complete is cost to date divided by estimated cost, revenue earned is that percentage times the contract, and over or under billing is billed minus earned. This template calculates it in your browser, and the CSV opens in Excel or Google Sheets with the formulas included.
Your houses
| House | Contract price | Estimated total cost | Cost to date | Billed to date | % complete | Revenue earned | Over (under) billing | Gross profit earned | Cost to complete |
|---|---|---|---|---|---|---|---|---|---|
| Total |
Illustrative arithmetic only. Nothing you enter leaves your browser. The example numbers are made up. Over billing is billed minus earned, shown positive when you have billed ahead of the work.
How the columns work
- Percent complete = cost to date / estimated total cost at completion (cost-to-cost method).
- Revenue earned = percent complete x contract price.
- Over (under) billing = billed to date - revenue earned. Positive means overbilled.
- Gross profit earned = revenue earned - cost to date.
- Cost to complete = estimated total cost - cost to date.
The numbers are only as good as the estimated cost at completion. Refresh it every month by cost code, as described in our guide to forecasting cost to complete. For a line-by-line walkthrough with three houses, see the WIP schedule example.
Using the spreadsheet version
The CSV has the same columns, three example rows marked EXAMPLE, twelve empty rows with the formulas filled in, and a total row. Open it in Excel or Google Sheets, delete the examples and type over your own houses. The formulas calculate in the spreadsheet, not on our server.
What this does not do
This is a management view. It does not decide your tax method, treat uninstalled materials, or fix costs coded to the wrong house. Those need the books. See uninstalled materials and percent complete and percentage of completion vs completed contract. This is not tax advice.
Want it built from your books every month?
Our team builds the WIP schedule from your job cost records after each close and reviews it with you on the house-by-house review call. 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
Common questions
Is there a free WIP schedule template for home builders?
Yes. This page has a calculator that runs in your browser and a CSV you can open in Excel or Google Sheets with the formulas already in place.
What columns does a WIP schedule need?
Contract price, estimated total cost, cost to date, billed to date, percent complete, revenue earned, over or under billing, gross profit earned and cost to complete.
How do I calculate over and under billing?
Billed to date minus revenue earned. If the result is positive you are overbilled, and if negative you are underbilled.
Does the template save my numbers?
No. The calculator runs in your browser and sends nothing.
Can you prepare my WIP schedule for me?
Yes. Our team builds it from your job cost records each month.
Related
- WIP schedule example for a custom home builder
- What is a WIP schedule?
- WIP over and under billing
- Monthly WIP review meeting
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.