Free tool

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 contractDraw amountCumulative billedRetainage heldNet due
Total

Download the spreadsheet (CSV with formulas)

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

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.