Constructelligence
Guide · billing

The schedule of values: how to build one, bill against it and avoid front-loading

The schedule of values (SOV) splits the contract sum into lines of work, each with a dollar value. Every progress payment after that is billed against it: each month the contractor claims a percentage of each line, and the architect or owner checks those percentages against the work in place. The SOV is set once, at the start of the job, and every pay application for the rest of the job depends on it. This guide builds one for a $3.86M job and follows it through to the sixth pay application.

Updated · 9 minute read

Key takeaways
  • The SOV splits the contract sum into lines; every pay application bills a percentage of each line.
  • It is a price, not a cost — but each line should map to known cost codes.
  • Front-loading shows up line by line: billed % running ahead of cost %.
  • Change orders get their own lines; unapproved changes stay off.

What a schedule of values is, and who approves it

A schedule of values is a list of the parts of the work with the share of the contract sum allocated to each. On an AIA contract it is the contractor's job: the A201 general conditions require the contractor to submit a schedule of values to the architect before the first application for payment, and once accepted it becomes the basis for every application after it. Its lines are the rows of the G703 continuation sheet.

Choosing the lines

Too few lines and every pay application turns into an argument about what "40% of the building" means. Too many and the monthly billing takes days. What works for most jobs:

A worked example

Riverside Apartments, job J-1104: original contract sum $3,862,000, ten SOV lines, and two approved change orders added as their own lines. This is the SOV as it stands at pay application No. 6:

ItemDescription of workScheduled valueCompleted & stored to date%Balance to finish
1General conditions$386,000$115,00029.8%$271,000
2Sitework$210,000$210,000100.0%$0
3Concrete$540,000$432,00080.0%$108,000
4Framing & rough carpentry$610,000$164,40027.0%$445,600
5Roofing$180,000$00.0%$180,000
6Doors, windows & glazing$290,000$40,000 *13.8%$250,000
7Drywall & finishes$520,000$00.0%$520,000
8Plumbing$360,000$54,00015.0%$306,000
9HVAC$410,000$41,00010.0%$369,000
10Electrical$356,000$35,60010.0%$320,400
CO-01Added storm drainage$58,000$58,000100.0%$0
CO-02Upgraded unit kitchens$80,000$00.0%$80,000
Contract sum to date$4,000,000$1,150,00028.75%$2,850,000

* Doors, windows & glazing: $40,000 is material presently stored on site, not installed work — billable under the contract with delivery tickets and insurance, and shown in its own column on the G703.

The totals are exactly what the G702 for application No. 6 carries: contract sum to date $4,000,000, total completed and stored $1,150,000, retainage at 10% $115,000. With $862,500 certified on earlier applications, the payment due this month is $172,500:

$1,150,000 − $115,000 retainage − $862,500 previous = $172,500 due
CalculatorIs this line over-billed?
General conditions$386K · 30%Sitework$210K · 100%Concrete$540K · 80%Framing$610K · 27%Roofing$180K · 0%Doors, windows$290K · 14%Drywall & finishes$520K · 0%Plumbing$360K · 15%HVAC$410K · 10%Electrical$356K · 10%CO-01 Storm drainage$58K · 100%CO-02 Kitchens$80K · 0%Filled = completed & stored to date · outline = scheduled value
Riverside Apartments at pay application No. 6 — each SOV line’s scheduled value, filled to what has been completed and stored. Change orders ride as their own lines.

Front-loading, and how to catch it

Front-loading is putting more of the contract sum on the lines that finish early — sitework, concrete, mobilization — and less on the finishes at the end. Billing then runs ahead of the work, the contractor holds the owner's cash early, and the job shows over-billed on the WIP. Some of it is deliberate; much of it is accidental, when a markup is loaded unevenly or the SOV is copied from a bid form.

It costs the contractor more than it looks like it does:

The check is the same arithmetic as the WIP, run on a single line: what the line has earned is its scheduled value times the share of that line's cost spent so far. Riverside's concrete line is billed at 80%, but $310,000 of an estimated $420,000 of concrete cost is spent — 73.8% — so the line has earned $398,571 and is over-billed by $33,429. On one line that is timing; on every early line at once it is a front-loaded SOV.

earned on a line = scheduled value × cost to date ÷ estimated total cost for the line  ·  over / (under) = billed − earned

Change orders, stored material and retainage

The monthly pencil draft

Most owners expect a pencil draft — the proposed percentages line by line — a week before the formal application. It goes faster when each line's percentage is backed by something the architect can check:

  1. Installed quantities from the field (square feet of board hung, cubic yards placed) for lines that are measured.
  2. Subcontractor pay applications for subcontracted lines — the sub's percentage and yours should agree.
  3. The schedule's percent complete for general conditions and lines billed over time.
  4. The line's cost percentage from the job cost ledger, as the sanity check on all of the above.

When the four disagree on a line, the line is either mis-billed or its cost is miscoded — both worth knowing before the owner asks.

Checklist
Schedule of values template in Excel, filled in with example rows — columns: Item, Description of work, Cost codes, Scheduled value, Previous applications, This period, Materials stored, Completed & stored to date…
The schedule of values template as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Schedule of values template (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

Each schedule of values line with its cost codes, scheduled value, previous applications, this period and stored materials, with completed to date, percent, balance to finish and retainage calculated.

11 columns: 7 you fill in and 4 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 4 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
ItemTextLine number, so the row can be referred to.
Description of workTextFree text.
Cost codesTextFree text.
Scheduled valueAmount ($)Enter the amount in dollars.
Previous applicationsAmount ($)Enter the amount in dollars.
This periodAmount ($)Enter the amount in dollars.
Materials storedAmount ($)Enter the amount in dollars.
Completed & stored to dateCalculatedCalculated: [Previous applications] + [This period] + [Materials stored]
%CalculatedCalculated: [Completed & stored to date] ÷ [Scheduled value]
Balance to finishCalculatedCalculated: [Scheduled value] − [Completed & stored to date]
RetainageCalculatedCalculated: [Completed & stored to date] × 0.10

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

What is a schedule of values in construction?

A list of the parts of the work with a share of the contract sum allocated to each. Once the owner or architect accepts it, every progress payment is billed as a percentage of each line, and the lines become the rows of the AIA G703 continuation sheet.

Who prepares the schedule of values?

The contractor. Under AIA A201 the contractor submits it to the architect before the first application for payment; the architect can ask for supporting data and require changes before accepting it.

What is front-loading a schedule of values?

Allocating more of the contract sum to work that finishes early, so billing runs ahead of the work in place. It shows as over-billing on the WIP and leaves the final lines underfunded.

Should the schedule of values match the estimate?

It should map to it — each line should roll up known cost codes — but it is a price, not a cost. Markup and overhead are spread across the lines so that they add up to the contract sum.

How are change orders added to a schedule of values?

As new lines with the approved change order value, billed like any other line. Existing lines are not changed, and unapproved changes are not added.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.

More in Billing & cash

Free tools for this topic: Over/under billing calculator (WIP) · Pay application and retainage calculator · G703 continuation sheet PDF to Excel

All billing & cash resources →