WIP schedule: definition and example
A plain definition for custom and spec home builders, with a worked example.
Definition: A WIP schedule, short for work in progress schedule, is a monthly report of every open house showing contract value, cost to date, estimated cost at finish, percent complete, revenue earned, amount billed and over or under billing. Lenders, sureties and CPAs ask for it to judge job profitability and cash.
Also called: work in progress schedule
How it works for a home builder
The WIP schedule rolls the job cost report up to one line per house. Each line takes the contract price and the estimated total cost, computes percent complete, and compares earned revenue to billings.
It also surfaces a risk the job cost report hides: a house can be on budget and still strain cash if it is billed far behind the work. The schedule's gross profit column shows projected profit on each house, not just on closed ones.
Example
One line of a WIP schedule, Lot 14. All numbers below are made up for illustration. They are not a real client or house.
| Item | Amount |
|---|---|
| Contract price | $540,000 |
| Estimated total cost | $450,000 |
| Cost to date | $250,000, 55.6% complete |
| Earned revenue | $300,000 |
| Billed to date | $340,000 |
| Over billed | $40,000 |
Made-up numbers. Earned revenue is 540,000 times 55.6%. Over billing is billed minus earned.
Common questions
What does WIP stand for in construction accounting?
Work in progress. A WIP schedule reports open contracts that are still being built.
Who asks for a WIP schedule?
Banks, sureties and CPAs commonly ask. Builders use it themselves to see profit and cash on open houses.
How often should a WIP schedule be prepared?
Monthly, after the close and after cost to complete has been updated by the project manager.
Sources
- CFMA, WIP accounting: critical and often misunderstood
- CFMA, Work-in-progress in construction
- Sage, What does your monthly WIP and forecasting meeting look like?
Related guides
Related terms
Want your own houses run this way? 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, pricing or request a Relationship Assessment.
By John Mos, Founder. Updated . Definitions are general information. 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.