Draw schedule template for custom home builders
Turn a contract price and a milestone split into draw amounts, cumulative billings and retainage. Download the same layout as a spreadsheet with formulas.
Short answer: A draw schedule splits the contract price into milestone payments. Each draw equals the milestone's percent of contract times the contract price, retainage held equals the retainage percent times the draw, and net due is the draw less retainage. The percentages must total 100 percent. This template calculates it in your browser, and the CSV has the formulas for Excel or Google Sheets.
Your contract
| Milestone | % of contract | Draw amount | Cumulative billed | Retainage held | Net due |
|---|---|---|---|---|---|
| Total |
Illustrative arithmetic only. Nothing you enter leaves your browser. The example split is made up, not a recommendation. Your contract sets the milestones, and a lender's draw schedule may be different.
How the columns work
- Draw amount = milestone percent x contract price.
- Cumulative billed = running total of draws.
- Retainage held = retainage percent x draw amount, if your contract holds retainage from you.
- Net due = draw amount - retainage held.
The milestone percentages should total 100 percent of the contract price. Approved change orders change the contract price, so rerun the schedule or bill changes on their own lines. If your lender funds the loan on its own schedule, the owner's payment schedule and the lender's draw schedule are different things, covered in our guide on lender draw budget vs job budget.
Designing the split
A good split follows your costs, so you are never far ahead of or behind the work. Backloading the schedule forces you to fund the build from your own cash. Frontloading can trigger overbilling concerns with a lender or owner. See our guide on designing a milestone draw schedule and the draw package checklist.
Using the spreadsheet version
The CSV has the contract price and retainage in two cells at the top, ten milestone rows with illustrative names you can rename, a total row and a check that the percentages equal 100 percent. Enter percentages like 10%, open it in Excel or Google Sheets, and the formulas calculate there.
This is a planning aid, not legal advice. Check your contract and your state's rules on retainage and payment.
Want draws prepared from your books?
Our team prepares each draw package from your job cost records and keeps billings, retainage and WIP aligned. 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 draw schedule template for home builders?
Yes. This page has a calculator that runs in your browser and a CSV with formulas for Excel or Google Sheets.
How do you calculate a draw amount?
Multiply the milestone's percent of contract by the contract price.
How is retainage calculated on a draw?
Retainage held equals the retainage percent times the draw amount. Net due is the draw minus retainage.
Does the draw schedule have to total 100 percent?
Yes. The milestone percentages should add up to 100 percent of the contract price, adjusted when change orders change the price.
Does the template store my numbers?
No. It runs in your browser and sends nothing.
Related
- Milestone draw schedule design for fixed-price builds
- Construction draw package checklist
- Retainage and customer deposits
- Progress invoicing in QuickBooks Online
- Cost-plus vs fixed-price accounting
- Progress billing vs the lender draw
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.