Schedule of Values Template (Free, With a Filled-In Example)
Here is a free schedule of values template for small crews and remodelers. You need one when a client, a lender or a general contractor asks you to bill by progress instead of by a flat deposit. The Excel file has two tabs: a blank schedule with 15 lines, and the filled-in example from this post. The PDF is a one-page print copy to fill in by hand. This template is not an AIA G703 form and does not replace one. If your contract names a form, use that form.
Want the cost side of each line without typing receipts into a sheet? With Job Cost Pro you scan each receipt, confirm the job, and see each job's recorded costs against its budget. The free plan covers 3 active jobs at a time and 50 receipts a month, no credit card.
What a schedule of values is
A schedule of values (people say SOV) is a list. Each line is one part of the job: general conditions, demo, framing, electrical, plumbing and so on. Each line gets a dollar value, called the scheduled value. The scheduled values add up to the contract price, to the cent.
You agree on the list with the client before the first bill. After that, each bill (often called a pay application) uses the same lines. On each line you write how much work is done, in dollars. The sheet then shows the percent complete, what is left to finish, the retainage held back, and what the client owes you now. Because the client sees the job line by line, a bill is easy to check, and easy to pay.
Schedule of values vs draw schedule
A construction draw schedule splits the price by milestones: when the framing is done, you bill the next draw. A schedule of values splits the price by line items and bills each line by its percent complete. A draw schedule is simpler for a small remodel. A schedule of values gives the client, the lender or the GC more detail, so bigger jobs and jobs with a lender often ask for one. Some jobs use both: the draws set when you bill, and the schedule of values shows what each bill is for.
The columns in the free template
| Column | What goes in it |
|---|---|
| Line | The line number. |
| Description of work | One part of the job, by trade or by phase. |
| Scheduled value | The dollar value of that line. All lines add up to the contract price. |
| Work completed, previous bills | Dollars of this line you billed on earlier bills. |
| Work completed, this period | Dollars of this line done since the last bill. |
| Total completed to date | Previous + this period. The sheet adds it. |
| % complete | Total completed to date / scheduled value. The sheet divides it. |
| Balance to finish | Scheduled value - total completed to date. |
| Retainage held | Total completed to date x the retainage rate from your contract. |
Under the lines, the template adds the totals and works down to one number: the amount due on this bill. You type only the white cells. Every formula in the Excel file is plain arithmetic, so you can check it by hand.
A filled-in example: a $50,000 basement finish
This is a made-up job with made-up numbers. It is pay application #2. On bill #1 the contractor billed $6,750 of work (all of the demo, 30% of the general conditions and 40% of the framing). The contract holds back 10% retainage, as an example only.
| Line | Scheduled value | Previous bills | This period | Total to date | % complete | Balance to finish |
|---|---|---|---|---|---|---|
| General conditions and permits | $2,500 | $750 | $750 | $1,500 | 60% | $1,000 |
| Demo and prep | $3,000 | $3,000 | $0 | $3,000 | 100% | $0 |
| Framing | $7,500 | $3,000 | $4,500 | $7,500 | 100% | $0 |
| Electrical | $6,000 | $0 | $3,000 | $3,000 | 50% | $3,000 |
| Plumbing | $5,500 | $0 | $2,750 | $2,750 | 50% | $2,750 |
| HVAC | $4,000 | $0 | $1,600 | $1,600 | 40% | $2,400 |
| Insulation and drywall | $8,000 | $0 | $2,000 | $2,000 | 25% | $6,000 |
| Flooring | $5,000 | $0 | $0 | $0 | 0% | $5,000 |
| Paint and trim | $4,500 | $0 | $0 | $0 | 0% | $4,500 |
| Fixtures and finish | $4,000 | $0 | $0 | $0 | 0% | $4,000 |
| Totals | $50,000 | $6,750 | $14,600 | $21,350 | 42.7% | $28,650 |
Now the bottom of the sheet, line by line:
- Total completed to date: $21,350.
- Less retainage held (10% of $21,350): $2,135.
- Earned less retainage: $19,215.
- Less previous bills (bill #1 was $6,750 less $675 retainage): $6,075.
- Amount due on this bill: $13,140. That is the same as $14,600 of work this period, less 10%.
- Left to bill: $30,785 (balance to finish $28,650 + retainage $2,135).
The Example tab of the Excel file holds these same numbers, so you can change one cell and watch the totals move.
How to build your own schedule of values in 5 steps
- Split the job into lines
Use trades or phases the client can see on site. Ten to twenty lines is enough for most small jobs.
- Make the lines add up to the contract, to the cent
Put your bid numbers on each line. If the total is off by $1, fix it now, not on bill #3.
- Do not front-load
Putting extra value on the early lines gets you paid sooner on paper. A client, lender or GC who checks the site will push back, and it can cost you trust.
- Give each change order its own line
Add a new line with its own scheduled value. Do not hide it inside an old line. The contract sum goes up by the same amount.
- Agree on the list before the first bill
Send the blank schedule with the contract. Once the client says yes, use the same lines on every bill.
How to update the schedule on each bill
Each new bill starts from the last one. Copy the file, then work line by line. Move the old "this period" amount into "previous bills", so the previous column always holds everything you billed before. Then walk the site, or look at your photos, and write the dollars of work done on each line since the last bill.
- Bill only for work the client can see is done. A half-framed wall is not 100% framing.
- Never let a line go past 100%. If a line costs more than its scheduled value, that is a change order or a loss, not a bigger percent.
- Check that the scheduled values still add up to the contract sum after every change order.
- Keep a copy of every bill you send. When the client asks about a line, you can show the history.
A clean schedule of values gets paid faster, because the person who approves it can check each line in a minute. A messy one gets sent back, and the money waits.
Retainage on a schedule of values
Retainage is money the client holds back from each bill until the job is done. Your contract sets the rate; the example in this post uses 10%. The template takes one rate, in one cell, and applies it to the total completed to date on every line. When the job is done and the punch list is closed, you bill the retainage on its own.
Where the app fits (honest limits)
A schedule of values shows what you billed. It does not show what the job cost you. I built Job Cost Pro for the cost side. You photograph receipts and the AI reads the line items (when the receipt names the job or you scan at the jobsite, it suggests that job for one tap to confirm), and your crew clocks in on the job, so their hours are recorded for it. Before you send a bill, the cost to date is already there, from costs recorded so far. It does not build a schedule of values for you; you keep the lines in this template.
It's free for 3 active jobs at a time and 50 receipts a month, no credit card.
Whatever you use, keep the total billed to date ahead of the cost to date at every bill. If cost runs ahead of billing, you are paying for the client's job out of your own pocket.
Track your next job with Job Cost Pro
Scan receipts, confirm the suggested job, and see your recorded costs against your budget. Start with the free plan in your browser or get the iPhone app.
Google Play: US only.
Free plan available. Some features require a paid plan.
FAQ
What is a schedule of values in construction?
It is the contract price split into line items, each with its own dollar value. The lines add up to the contract price. On each bill you show how much of each line is done, so the client can check the bill line by line.
Who needs a schedule of values?
Anyone whose client, lender or general contractor asks to be billed by progress. Commercial jobs and jobs with a construction lender often ask for one. A small remodel paid by deposit and milestones may only need a draw schedule.
What is the difference between a schedule of values and a draw schedule?
A draw schedule splits the price by milestones and bills each milestone when it is done. A schedule of values splits the price by line items and bills each line by its percent complete. Some jobs use both.
Can I front-load a schedule of values?
You can put more value on early lines, but a client, lender or GC who checks the site will often push back. Keep each line close to its real cost plus your markup, so each bill matches the work they can see.
Is this the same as an AIA G703?
No. This free template uses the same kind of columns, but it is not an AIA form and does not replace one. If your contract names the G702 and G703 forms, use those forms.
How do change orders go on a schedule of values?
Give each change order its own new line with its own scheduled value, and add the same amount to the contract sum. Do not fold it into an old line, or the percent complete on that line stops making sense.