Guide

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.

ColumnHouse AHouse BHouse 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 margin20.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

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

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.