Free schedule of values template (Excel)
This free schedule of values template is an Excel workbook that breaks the contract sum into billable lines and tracks each line every pay period: work completed before and this period, materials stored, total to date, percent complete, balance to finish and retainage. The totals feed the summary page of a pay application. No email, no macros.
Download the template
No sign-up, no email. 3 sheets, no macros, 13 KB. Opens in Excel or Google Sheets. The example sheet uses illustrative Texas project data; the blank sheet is ready to use.
What is in the workbook?
| Sheet | What it is for |
|---|---|
| Instructions | The steps on this page and what each column means |
| Schedule of values | The blank working sheet: formulas for total completed and stored, percent complete, balance to finish and retainage per line, with totals |
| Example (Texas) | An illustrative $1,050,000 Austin, TX building contract, mid-job |
What do the columns mean?
The columns carry the same information as the continuation sheet of a standard pay application, so the totals drop straight into its summary page. Use the form your contract requires; this sheet is our own layout, not a reproduction of any published form.
| Column | What to enter | Why it matters |
|---|---|---|
| Item no., Description, CSI division | One line per billable part of the work, often by CSI MasterFormat division | Lines that match how the work is built make percent complete easy to verify on site. |
| Scheduled value | The value of each line; lines add up to the contract sum | Approved change orders get their own lines so the total always equals the contract sum to date. |
| Completed, previous and this period | Work in place before this period, and work in place this period | Billing only work in place keeps the pay application from being rejected. |
| Materials presently stored | Material on site or approved off-site storage, not yet installed | Owners usually require proof of storage, insurance and title before paying for it. |
| Total completed and stored, % complete, Balance to finish | Calculated per line | The total is what feeds the pay application summary. |
| Retainage rate, Retainage | The withheld percentage per line, from the contract | Many states cap retainage on public work; your contract sets the rate. |
What does the example look like?
The Example sheet, as its formulas compute it. Illustrative data, not a real project.
| Item | Scheduled value | Completed and stored | % complete | Balance | Retainage |
|---|---|---|---|---|---|
| 1 General conditions (01) | $90,000 | $36,000 | 40% | $54,000 | $3,600 |
| 2 Concrete (03) | $150,000 | $150,000 | 100% | $0 | $15,000 |
| 3 Structural steel (05) | $180,000 | $108,000 | 60% | $72,000 | $10,800 |
| 4 Finishes (09) | $220,000 | $12,000 | 5% | $208,000 | $1,200 |
| 5 Plumbing (22) | $120,000 | $42,000 | 35% | $78,000 | $4,200 |
| 6 HVAC (23) | $140,000 | $58,000 | 41% | $82,000 | $5,800 |
| 7 Electrical (26) | $100,000 | $14,000 | 14% | $86,000 | $1,400 |
| 8 CO-001 Added storm line (33) | $50,000 | $0 | 0% | $50,000 | $0 |
| Total | $1,050,000 | $420,000 | 40% | $630,000 | $42,000 |
IllustrativeThe contract sum to date is $1,050,000, with $420,000 completed and stored, $42,000 retained at 10% and $378,000 earned less retainage: the same numbers as the worked example in our G702 and G703 guide.
How do you use the template?
- Build the lines from your estimate. One line per billable part of the work, grouped the way it will be built; the lines must add up to the contract sum.
- Get it approved before the first bill. Send the schedule of values to the architect or owner for approval; front-loaded lines are a common reason for rejection.
- Fill this period. Each period, enter work completed this period and materials stored, line by line.
- Check the totals. Total completed and stored, retainage and earned less retainage calculate at the bottom; carry them to the pay application summary.
- Add approved changes as lines. Each approved change order gets its own line with its own scheduled value.
- Roll forward. After the pay application is certified, add this period to Previous and clear This period and Stored for the next one.
For how these totals become the summary page, line by line, read how to fill out a G702 and G703 pay application.
When does a spreadsheet stop being enough?
The arithmetic is easy; the backup is not. Each period, someone has to tie percent complete to what is in place, check stored materials against delivery tickets and add the right change orders. Fina, BAU AI's finance and budget agent, drafts the pay application from the schedule of values, the approved change orders and the field progress, checks the arithmetic and flags anything that does not tie out, each figure linked to its source; your project manager reviews and submits. Fina is offered to the founding cohort and is not part of the published plans.
Frequently asked questions
Is the schedule of values template free?
Yes. Download it without an email address and adapt it for your own projects. A credit line to BAU AI sits at the bottom of each sheet.
Is this the AIA G703?
No. It is our own spreadsheet that tracks the same information, so the totals carry over to whatever form your contract requires. Use the official form where the contract calls for it.
How do I handle variable retainage?
Set the retainage rate per line, for example a lower rate on general conditions or 0% on stored materials, if your contract allows it.
Does it work in Google Sheets?
Yes. The formulas are plain arithmetic and SUM. There are no macros.
See Fina draft a pay application from your schedule of values
Bring last month's pay app. In 15 minutes Fina rebuilds it with you and shows what does not tie out.