Schedule of Values

Schedule of Values

Schedule of Values

Put together your monthly pay application in one workbook. List the contract once on the Schedule of Values, then each month pick the next application and type the work done that period. Everything billed before carries forward by itself, so the previous billing, retainage and current payment due work themselves out. The Application tab prints the cover page, with the schedule of values behind it.

Excel 2010 or newer

Microsoft 365

Excel Table · grows as you add lines

No macros

Nothing locked

Who it's for

Who it's for

Built for general contractors and subs who bill monthly against a schedule of values, with retainage held back. The pages are laid out like the AIA G702 and G703. They aren't the official AIA forms, so if your contract requires those, copy the numbers across.

Office tenant fit-out · App 02

The bid's lines become the schedule of values. Carpet tile is stored on site, and an approved change order bills like any line.

Payment due
$65,409
General contractor sample: Office tenant fit-out · App 02

Sample jobs for illustration. Numbers vary by market.

Key features

Key features

01

Bill a month in minutes

Bill a month in minutes

Pick the application number and type this period's work in its column. From previous application, total completed, balance to finish and retainage all fill in by themselves.

02

Every application, exactly as sent

Every application, exactly as sent

Each line keeps its own billing history for 24 applications. Pick an earlier one and both pages reprint it the way it went out, so last month's pay app is never lost.

03

Stored materials and change orders

Stored materials and change orders

Stored materials carry forward as a balance until they're installed. A change order stays gray and uncounted until you pick the application it was approved in.

04

Retainage your way

Retainage your way

Set retainage on work and on stored materials. Lower it partway through the job and the earlier applications keep their old rate.

Guide

Why I built a schedule of values spreadsheet

A lot of our bigger projects require progress billing. Instead of one invoice at the end, you bill every month for the work done that month, line by line, against a schedule of values. On a job that runs a year, that's a dozen pay applications, and every one of them depends on the ones before it.

So I wanted one spreadsheet that could keep track of all of our billing for the life of a project. It had to be easy to use, easy enough for my 65-year-old dad. But it had to be smart, too.

Before this, every pay application was a small research project. We had to calculate every line item by hand, dig up all of our previous billing certificates, and make sure the total on the previous certificates line was right. Get one number wrong and the whole application is off. An application that doesn't add up doesn't get paid on time.

Now everything is logged in one spreadsheet. When we add a new billing, the spreadsheet does the math and the pay application is ready to go.

What is a schedule of values?

A schedule of values is a list of every part of the contract with the dollar amount assigned to it. Site work, concrete, steel and roofing each get their own line and their own scheduled value. Add up the lines and you get the contract sum.

It's the backbone of progress billing. Each month, you bill a share of each line based on how much of that work is done. The owner, the architect or the lender checks your numbers against the same schedule, line by line, so everyone measures progress the same way.

Most schedules of values start from the bid. The sections and lines you priced become the lines you bill. Change orders get added as their own lines once they're approved.

How progress billing works

Progress billing means getting paid as the job moves, instead of all at the end. Each billing period, usually a month, you send a pay application that shows:

  • This period's work on each line, in dollars.

  • What you billed before, carried forward from every earlier application.

  • Materials stored on site or off site that aren't installed yet.

  • Retainage held back.

  • The payment due for this period.

The math itself isn't hard. Keeping it straight for 12 or 18 months is. Every application builds on the last one, so one wrong number carries into every application after it.

You'll also hear the word draw, especially on residential and bank-financed jobs. A draw schedule usually ties payments to milestones, like foundation, framing or dry-in, instead of line-by-line progress. It's the same idea in bigger steps. On a schedule of values, a milestone is just a line you bill at 100% once it's done.

How retainage works

Retainage is the part of each payment the owner holds back until the job is finished, as security that the work gets completed and corrected. It's usually a percentage of what you bill, often 5% or 10%.

On 10% retainage, every $100,000 of work you bill pays $90,000 now. The other $10,000 builds up over the job and comes due at the end, usually after substantial completion and the punch list.

A few things make retainage easy to get wrong:

  • It applies to stored materials too, sometimes at a different rate than completed work.

  • It can change partway through. Some contracts cut it in half once the job is 50% complete.

  • It adds up. On the sample job, $110,011 is being held after four applications.

The template keeps one rate for work and one for stored materials, and each application can have its own. Lower the rate on App 07 and Apps 01 through 06 keep the rate they were billed at.

Some states and contracts require retainage to be held in a separate account. That's set by your contract and your state's law, not by the spreadsheet.

A progress billing example with real numbers

Here's Application 04 from the sample file: Northline Construction billing a $1.8 million shell and site package called Harbor Plaza, for the period ending February 28.

On the schedule of values, a few lines tell the story:

  • Storm drainage ($153,360) was 90% billed before this period. This period finishes it at 100%.

  • Asphalt paving ($172,368) starts this period at 25%, or $43,092.

  • The HVAC rooftop units are on site but not set yet. They bill as $60,000 of stored materials.

On the application for payment, every line rolls up into nine numbers:

  1. Original contract sum: $1,810,586

  2. Net change by change orders: $20,300

  3. Contract sum to date: $1,830,886

  4. Total completed and stored to date: $1,100,111

  5. Retainage: $110,011 (10% of $1,029,111 in completed work, plus 10% of $71,000 stored)

  6. Total earned less retainage: $990,100

  7. Less previous certificates for payment: $633,564

  8. Current payment due: $356,536

  9. Balance to finish, including retainage: $840,786

Line 7 is the one that used to take the digging. Here it's worked out from Applications 01 through 03, which are still in the file. Pick App 02 and both pages reprint exactly the way it went out in December.

Stored materials and change orders

These are the two places pay applications usually go wrong.

Stored materials are things you've bought and had delivered but haven't installed. Most contracts let you bill for them. The catch is the next month: once they're installed, they move from stored to work completed, and they can't be billed twice. In the template, each line keeps a stored balance for every application. It carries forward on its own until you set it to zero, and the install bills as work in that month's column.

Change orders get their own lines at the bottom of the schedule. A change order counts from the application it was approved in. Until then, it stays gray and adds nothing. In the sample, four change orders are approved, including a $6,500 credit, for a net change of $20,300. A fifth, $10,000 for extra grading, is still pending and isn't in any total.

Schedule of values template for Excel: what's in the file

The schedule of values template has three tabs.

  • Setup. Your company, the owner, the project, the architect, the contract date and the retainage rates. Also the application schedule: 24 applications, each with its period end date and the dates you applied and got paid.

  • Schedule of Values. Every line with its scheduled value, laid out like the AIA G703. Pick the application number at the top and type this period's work in its column. From previous application, stored materials, total completed, %, balance to finish and retainage all fill in.

  • Application. The cover page, laid out like the AIA G702, with your logo, the change order summary, lines 1 through 9, your certification, the architect's certificate and a notary block. There's nothing to type on this page.

Use one file per project. Each file holds 24 applications, enough for a two-year job, and about 480 lines. Type in the blue cells only, and there are no macros. A line billed past 100% turns red, and so does a percentage typed where dollars belong.

The download comes with a blank file and the Harbor Plaza sample, plus a PDF guide, in two editions: one for Excel 2021 and newer, and one for Excel 2010 and newer.

AIA G702 and G703: what's the same and what isn't

The AIA G702 (the application and certificate for payment) and G703 (the continuation sheet) are the standard pay application forms in commercial construction. This template is laid out the same way, with the same columns and the same nine lines, so anyone used to reading an AIA pay app can read this one.

It isn't the official AIA document, though. AIA forms are licensed. If your contract requires the official G702 and G703, use this file to do the math and copy the numbers across. If your contract asks for a pay application with a schedule of values, this format covers it.

From bid to schedule of values

If you priced the job in the Bid template, you don't have to type the schedule of values. The Bid's Export tab lays out every included line at its price, ready to paste. The sections and lines come over in order, and the schedule adds up to the bid price: $1,810,586 on the sample.

The Job Costing Tracker takes the same lines at cost, as the budget. The numbers you bid are the numbers you bill and the numbers you track.

Schedule of values template FAQ

Is there a free version?

No. It's an Excel file, not software, so there's no way to give you a limited version. Cutting rows, formulas or tabs would just hand you a spreadsheet that doesn't work. You get the whole file as part of the template library: $97, one time, for every template.

Does it work in Google Sheets?

No. It's built for Excel only.

Which versions of Excel?

The download has two editions: one for Excel 2021 and newer, and one for Excel 2010 and newer.

Does it work on a Mac?

Yes, in Excel for Mac.

Is this the official AIA G702 and G703?

No. It's laid out the same way, but it isn't the licensed AIA form. If your contract requires the official form, copy the numbers across.

How many pay applications fit in one file?

24, enough for a two-year job billed monthly.

Can I change retainage partway through the job?

Yes. Type the new rate on that application's row on Setup. Earlier applications keep the rate they were billed at.

Does it handle lien waivers?

No. Lien waivers are separate documents, usually on a form your state or the owner sets. Keep them alongside each application.

Can I use it as a construction invoice?

On a progress-billed job, the application for payment is your invoice. For a one-time invoice on a small job, it's more than you need.

Get the file.

Get the file.

Unlock the library and get this ready-to-use template, with all tabs, formulas, and workflows already connected, plus every other template in the collection.

No subscription. No locked formulas.

No subscription. No locked formulas.

See what’s in the library

The Mighty Template library

The Mighty Template library

$97

$97

once

This template plus the other three, built and tested.

  • Construction Bid Template
  • Job Costing Tracker
  • Construction Project Tracker
  • Schedule of Values

No subscription. No locked formulas.

No subscription. No locked formulas.