On most construction jobs you don’t get paid in one lump sum at the end. You get paid in draws: a payment when the foundation is in, another when the frame is up, and so on until the punch list is done. The draw schedule decides how much cash you have at each stage, so it’s worth setting up properly. Bill a draw late or wrong and you end up paying your subs and suppliers out of your own pocket while you wait.
This page gives you a free construction draw schedule template for small contractors: plan the draws, bill each one from a schedule of values, track retainage, and see what the owner or lender still owes you. There’s also an online version you can fill in right here. Below it we walk through a four-draw example and explain every formula.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Up to 30 schedule of values lines and 12 draws per project, with a printable pay application in the familiar G702/G703 layout.
Free online construction draw calculator
Enter the retainage %, then one row per line of your schedule of values: the scheduled value, the % complete at the last draw, the % complete now and any materials stored on site. Add your planned milestones if you have them, or click Load example. The report works out the current payment due, retainage held, balance to finish and whether you’re ahead of or behind the planned draw schedule. You can print it, save it as a PDF, download it as Excel, Word or CSV, or send a link to the owner, the lender or your bookkeeper.
4. Draw request
Application for payment (summary)
Continuation sheet: schedule of values
Progress by line
Planned draw schedule
Retainage = completed work × retainage % + stored materials × stored-materials retainage %. Current payment due = (total completed & stored − retainage) − the same figure on the previous draw. Contractor: ______________ Approved by owner / lender: ______________
Made with the free construction draw schedule tool at bookkeepingsheets.com
What is a construction draw schedule?
A construction draw schedule is the agreed plan for how a contract price gets paid out over the life of a job. Each draw is one payment request. For a homeowner paying from savings, the draw schedule is usually a list of milestones in the contract. For a construction loan, the lender holds the money and releases each draw after an inspector confirms the work is in place. On commercial jobs, the contractor usually submits a monthly pay application based on the percentage of each line that’s complete.
There are two common ways to set the amount of each draw:
- Milestone draws. A fixed % of the contract when a stage is finished: for example 12% at mobilization, 18% when the foundation is complete, 20% when the house is dried-in. Simple for the owner, but if a milestone slips by two weeks, so does your cash.
- Percentage-of-completion draws (schedule of values). The contract is split into lines (site work, framing, plumbing and so on), each with a scheduled value. Every draw bills the % complete of each line, minus what was billed before. This is what AIA G702/G703-style pay applications use, and lenders like it because each dollar ties to work in place.
The template does both. You plan the milestones on the Draw Plan sheet, then bill each draw from the schedule of values. The Draw History sheet shows whether the work billed is ahead of or behind the plan.
What’s inside the template
- Project Setup: project, owner, contractor, retainage % on completed work and on stored materials, the draw you’re preparing, and the draw at which retainage is released.
- Schedule of Values: up to 30 lines with a scheduled value and a type (Original or Change order). It totals the original contract sum, change orders and contract sum to date.
- Draw Plan: up to 12 milestones with a planned date and % of the contract, turned into planned amounts and a planned cumulative total. A check warns you if the plan doesn’t add up to 100%.
- Progress: the cumulative % complete of every line at every draw. Leave a cell blank and the last % carries forward, so you only update what changed. A check flags any line whose % went down.
- Stored Materials: materials delivered but not installed yet, by line and draw.
- Pay Application: the draw request for the draw number on Project Setup: the nine-line summary (original contract, change orders, completed and stored, retainage, previous payments, current payment due, balance to finish) and the continuation sheet with columns A to I. It’s set up to print on one landscape page width.
- Draw History: every draw so far vs. the plan, retainage held, payment due, amount received and anything still owed.
How to use it
- Build the schedule of values from your estimate. Use the same lines you bid with, and keep them small enough to measure. “Framing” works; “Structure” is too vague to agree on a %. Don’t load all the profit into the early lines (front-loading). Most lenders and owners check for it.
- Enter the draw plan from the contract or the lender’s draw schedule: milestone, planned date and % of the contract.
- At each draw, update % complete. Walk the job with your foreman and enter the total % done on each line to date. On a loan, expect the lender’s inspector to check these.
- Add stored materials. Cabinets in the garage, windows on a pallet: list the invoiced value on the line they belong to. Next draw, once they’re installed, move them into % complete and clear the stored amount.
- Set the draw number on Project Setup and print the Pay Application. Attach the lien waivers and invoices your owner or lender asks for.
- Record what you were paid on Draw History. The Still owed column shows any short payment right away.
Worked example: Cedar Lane garage + ADU
A small builder signed a $172,000 contract for a detached garage with an accessory dwelling unit above it. Retainage is 10% on both work and stored materials. In September the owners approved change order CO-1, a ducted mini-split upgrade, for $3,800, so the contract sum to date is $175,800. The draw plan has seven milestones, from 12% at mobilization to 8% at final completion. This is the same data the Load example button and the template use.
Four draws in, the Draw History sheet looks like this:
| Draw | Milestone | Planned cumulative | Completed & stored | vs. plan | Retainage held | Payment due |
|---|---|---|---|---|---|---|
| 1 (Jul 15) | Mobilization; foundation underway | $21,096 | $20,400 | −$696 | $2,040.00 | $18,360.00 |
| 2 (Aug 14) | Foundation complete; framing underway | $52,740 | $50,825 | −$1,915 | $5,082.50 | $27,382.50 |
| 3 (Sep 15) | Framed and dried-in | $87,900 | $93,025 | +$5,125 | $9,302.50 | $37,980.00 |
| 4 (Oct 15) | Rough-ins complete | $123,060 | $117,275 | −$5,785 | $11,727.50 | $21,825.00 |
Draw 3 ran ahead of plan. The frame and roof went up fast, and $5,700 of windows was delivered and billed as stored material before installation. Draw 4 is behind: the plan assumed the rough-ins would be finished by October 15, but plumbing is at 60%, electrical at 55% and HVAC at 50%. So instead of the 20% milestone payment ($35,160), the builder can bill $21,825. That $13,000 gap is worth knowing about before payroll, not after.
Here’s how draw 4’s payment due is built, line by line in the Pay Application summary:
| Line | Amount |
|---|---|
| 1. Original contract sum | $172,000.00 |
| 2. Net change by change orders | $3,800.00 |
| 3. Contract sum to date | $175,800.00 |
| 4. Total completed & stored to date ($108,775 work + $8,500 cabinets on site) | $117,275.00 |
| 5. Retainage (10%) | $11,727.50 |
| 6. Total earned less retainage | $105,547.50 |
| 7. Less previous payment applications (draws 1–3) | $83,722.50 |
| 8. Current payment due | $21,825.00 |
| 9. Balance to finish, including retainage | $70,252.50 |
The job is 66.7% complete (completed and stored ÷ contract sum to date), and the owners are holding $11,727.50 of retainage they’ll release at final completion.
The formulas, explained
| Column / figure | Formula | Example (draw 4) |
|---|---|---|
| D. From previous draw | Scheduled value × % complete at the last draw | Roofing: $12,000 × 80% = $9,600 |
| E. This period | Scheduled value × % complete now − D | $12,000 × 100% − $9,600 = $2,400 |
| F. Materials presently stored | Invoiced value on site, not installed | Cabinets: $8,500 |
| G. Total completed & stored | D + E + F | Cabinets line: $0 + $0 + $8,500 = $8,500 |
| H. Balance to finish | Scheduled value − G | $22,000 − $8,500 = $13,500 |
| I. Retainage | (D + E) × work retainage % + F × stored retainage % | $108,775 × 10% + $8,500 × 10% = $11,727.50 |
| Current payment due | (G − I) now − (G − I) at the last draw | $105,547.50 − $83,722.50 = $21,825.00 |
| vs. plan | Total completed & stored − planned cumulative | $117,275 − $123,060 = −$5,785 |
In the spreadsheet, work completed to date for a whole draw is one SUMPRODUCT: =SUMPRODUCT(SVal,INDEX(Eff,0,4)), the scheduled values times the fourth column of the carried-forward % grid. The Pay Application picks the draw with INDEX(Eff,line,DrawNo), so changing one cell on Project Setup reprints any past draw. Original contract and change orders are SUMIFS on the line type.
How retainage works
Retainage (also called retention) is the part of each payment the owner or lender holds back until the job is finished. It protects them if the work isn’t completed or defects show up. On a 10% retainage job, a $100,000 contract leaves $10,000 sitting with the owner until final completion. For a small contractor that’s often most of the profit.
Retainage limits depend on the state and on whether the job is public or private, and many contracts lower retainage once the job is half done. California is a recent example: for most private projects under contracts entered into on or after January 1, 2026, retention is capped at 5% of each payment and of the contract price. Purely residential projects of four stories or less are exempt. Check your own state’s rules and your contract before you settle on a rate. When retainage is released, enter that draw number on Project Setup. From that draw on, the template holds no retainage, and the payment due includes everything held so far.
What owners and lenders usually ask for with a draw
- The pay application (summary + continuation sheet), signed.
- Lien waivers. Usually a conditional waiver from you for this draw, and unconditional waivers from subs and suppliers for the previous one. Forms are set by statute in many states, so use your state’s form.
- Invoices for stored materials, and sometimes photos or proof of insurance for materials stored off site.
- An inspection. On a construction loan, the lender’s inspector checks % complete before releasing funds. Agree the schedule of values with the lender up front so you’re measuring the same lines.
Common draw schedule mistakes
- Front-loading the schedule of values. Putting extra value into early lines brings cash in sooner, but inspectors spot it, and it leaves you short at the end when the punch list still has to be paid for.
- Entering this month’s % instead of the cumulative %. If plumbing was 40% done last draw and is 60% now, enter 60%, not 20%. The template flags any line that goes down.
- Billing change orders before they’re signed. Add a change order line only once it’s approved. Our job cost tracking spreadsheet keeps pending change orders separate from your budget.
- Forgetting retainage in your cash plan. Payment due is after retainage. If your margin is 15% and retainage is 10%, most of your profit arrives with the final payment. Plan for it in a 13-week cash flow forecast.
- Not chasing short payments. Record what was actually paid on every draw. A $500 deduction “for now” is easy to forget by the final draw.
- Letting the milestone plan drift. If the schedule slips, talk to the owner or lender early and update the plan rather than billing work that isn’t in place.
FAQ
What’s a typical construction draw schedule for a house?
There’s no standard, but many residential schedules use five to seven draws: a deposit or mobilization draw (often 5–15%), then foundation, framing and dry-in, rough-ins (plumbing, electrical, HVAC), insulation and drywall, finishes, and a final draw at completion that includes the retainage. Some states limit how big a deposit a home improvement contractor can take, so check before you set the first draw.
What’s the difference between a draw schedule and a schedule of values?
The draw schedule is when you get paid (the milestones and dates). The schedule of values is what the contract is made of (each line and its dollar value). On a percentage-of-completion job, each draw request bills the schedule of values, and the draw schedule is a forecast of when those bills will go out.
Is this the same as an AIA G702/G703 form?
The Pay Application sheet follows the same layout and column logic (A to I) that most contractors know from AIA G702/G703, which makes it easy for owners and lenders to read. It isn’t the official AIA document. If your contract requires the AIA forms, use them for the submission and use this template for planning and tracking.
How do I bill retainage at the end of the job?
When the job reaches final completion (or the point your contract allows), enter that draw number in “Release retainage at draw #”. That draw’s payment due then includes all the retainage held so far, along with any remaining work.
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, dropdowns and checks carry over.
Related calculators and templates
- Construction Job Cost Tracking Spreadsheet (Budget vs. Actual)
- 13-Week Cash Flow Forecast Template
- Accounts Receivable Aging Report Template
- Accounts Payable Tracker Template
- Invoice Late Fee & Interest Calculator
This guide and template are for general record-keeping and information. They aren’t legal, tax or accounting advice. Retainage limits, lien waiver requirements, deposit limits and prompt-payment rules vary by state and by contract. For questions about your own situation, talk to a qualified attorney, accountant or your lender.