Free download, pay applications

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?

SheetWhat it is for
InstructionsThe steps on this page and what each column means
Schedule of valuesThe 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.

ColumnWhat to enterWhy it matters
Item no., Description, CSI divisionOne line per billable part of the work, often by CSI MasterFormat divisionLines that match how the work is built make percent complete easy to verify on site.
Scheduled valueThe value of each line; lines add up to the contract sumApproved change orders get their own lines so the total always equals the contract sum to date.
Completed, previous and this periodWork in place before this period, and work in place this periodBilling only work in place keeps the pay application from being rejected.
Materials presently storedMaterial on site or approved off-site storage, not yet installedOwners usually require proof of storage, insurance and title before paying for it.
Total completed and stored, % complete, Balance to finishCalculated per lineThe total is what feeds the pay application summary.
Retainage rate, RetainageThe withheld percentage per line, from the contractMany 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.

ItemScheduled valueCompleted and stored% completeBalanceRetainage
1 General conditions (01)$90,000$36,00040%$54,000$3,600
2 Concrete (03)$150,000$150,000100%$0$15,000
3 Structural steel (05)$180,000$108,00060%$72,000$10,800
4 Finishes (09)$220,000$12,0005%$208,000$1,200
5 Plumbing (22)$120,000$42,00035%$78,000$4,200
6 HVAC (23)$140,000$58,00041%$82,000$5,800
7 Electrical (26)$100,000$14,00014%$86,000$1,400
8 CO-001 Added storm line (33)$50,000$00%$50,000$0
Total$1,050,000$420,00040%$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?

  1. 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.
  2. 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.
  3. Fill this period. Each period, enter work completed this period and materials stored, line by line.
  4. Check the totals. Total completed and stored, retainage and earned less retainage calculate at the bottom; carry them to the pay application summary.
  5. Add approved changes as lines. Each approved change order gets its own line with its own scheduled value.
  6. 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.