Schedule of values G703 example, worked line by line, with a free template
A schedule of values splits the contract into line items that sum to the contract total. On a G703 every line follows three formulas: G = D + E + F, percent complete = G ÷ C, and balance to finish H = C − G. The sum of Column C must equal G702 Line 3, and the sum of Column G must equal Line 4.
Build your pay app free
Type your G703 lines, check the math, download the PDF. Next month carries over. No account.
The columns, briefly
A item number, B description, C scheduled value (this line’s share of the contract), D work completed in previous applications, E work completed this period,F materials presently stored, G total completed and stored to date (G = D + E + F), the percent complete (G ÷ C, no letter on the AIA form), H balance to finish (H = C - G), and I retainage, used only where it varies per line. That’s the whole grid. The rest is filling it in without breaking those three identities. A correct schedule of values is one you can prove ties, line by line and in total. The free G702/G703 Excel template has every column above set up as formulas.
A worked example
A $200,000 site-work contract broken into four lines, at an application where the job is partway along: $50,000 of previous work, $35,000 completed this period, and $10,000 in stored materials. Every G is D + E + F; every H is C - G; the column totals are the figures that must carry up to the G702.
| A · Description | C · Sched. | D · Prev. | E · This | F · Stored | G · To date | % | H · Balance |
|---|---|---|---|---|---|---|---|
| 1 · Mobilization | 20,000 | 20,000 | 0 | 0 | 20,000 | 100% | 0 |
| 2 · Earthwork | 80,000 | 30,000 | 20,000 | 0 | 50,000 | 62.5% | 30,000 |
| 3 · Utilities | 60,000 | 0 | 15,000 | 10,000 | 25,000 | 41.7% | 35,000 |
| 4 · Paving | 40,000 | 0 | 0 | 0 | 0 | 0% | 40,000 |
| Totals | 200,000 | 50,000 | 35,000 | 10,000 | 95,000 | 47.5% | 105,000 |
Read line 3: 0 + 15,000 + 10,000 = 25,000 (that’s G), 25,000 ÷ 60,000 = 41.7% complete, 60,000 - 25,000 = 35,000 (H). Every other row checks the same way, and the totals row is each column added down. Column C sums to the $200,000 contract; Column G sums to $95,000, which is what must appear on the G702 as total completed and stored (Line 4).
The next three sections follow this same project through the three situations that break schedules of values in practice: a change order, stored material getting installed, and a line billed past its value.
What happens when a change order arrives?
Midway through the job the owner approves a change order: relocate a storm drain, $15,000. On the schedule of values that is a new line, not an edit to an existing one: line 5, Storm drain relocation, C = 15,000, every other column zero until the work starts, H = 15,000. Column C now sums to $215,000, and the certificate has to move with it. Line 1, the original contract sum, stays at $200,000. Line 2, net change orders, becomes $15,000. Line 3 = Line 1 + Line 2 = $215,000. A change order never edits Line 1; it lands in Line 2, and after every change order the sum of Column C must still equal Line 3.
The failure mode a receiver sees: the new line appears on the G703 while Line 2 on the G702 still reads zero, so Column C sums to $215,000 against a Line 3 of $200,000 and the application cannot be certified. The reverse is worse: an existing line’s C raised with no approved change order behind it. Either way the tie between the sum of Column C and Line 3 is the check that catches it.
What happens to stored material the next period?
On line 3, Utilities, $10,000 of pipe sits in Column F: delivered to the site, billed as stored, not yet installed. Stored material is value the sub has already been paid for once. When the pipe goes in the ground the next period, the amount has to move out of F and into E. Here is the same row across two applications, assuming installing that pipe is the only utilities work next period:
| Application | D · Prev. | E · This | F · Stored | G · To date |
|---|---|---|---|---|
| This period | 0 | 15,000 | 10,000 | 25,000 |
| Next period, done right | 15,000 | 10,000 | 0 | 25,000 |
| Next period, double-counted | 15,000 | 10,000 | 10,000 | 35,000 |
Next period’s D is this period’s D + E (0 + 15,000 = 15,000). The installed pipe shows up as E = 10,000, F drops to zero, and G stays exactly $25,000, because installation converts stored value into completed value; it does not create new value. The third row is the error: E takes the $10,000 while F keeps it too, G jumps to $35,000, and the sub is paid twice for the same pipe. A line whose F never falls while its E rises is double-counting stored material, and the overstatement equals the stored amount.
What does a line billed over 100 percent mean?
Suppose Earthwork hits rock and the sub, instead of pricing the extra work, keeps billing against the line until G reaches $88,000 on a C of $80,000. Then the percent is 88,000 ÷ 80,000 = 110% and H = 80,000 - 88,000 = -8,000. A negative balance to finish is the sheet telling you the line has billed more than the contract ever allocated to it. Percent complete over 100 means billing beyond scheduled value, and the fix is a change order that raises Column C, not a bigger number in Column G.
Priced correctly, the rock work becomes a change order: Line 2 rises by the agreed amount, Line 3 moves with it, and either the Earthwork line’s C grows or a new line carries the extra scope, which brings the percent back under 100. As the receiver, do not certify a line with a negative H. Send the application back for the change order first, because certifying it means paying for scope the contract does not contain.
Where a schedule of values goes wrong
Every failure above is a broken identity: a Column C that no longer sums to Line 3, a G that stopped equaling D + E + F after a manual edit, an F that never falls while E rises, a D that does not match what last month’s application reported as D + E. That makes each one catchable rather than a matter of opinion, and it is what a reviewer’s checklist works through in order. When the sheet and the certificate disagree and you need to trace the gap to the exact cell, see what to do when the totals stop tying.
Checking a real one fast
On a four-line example you can verify the math by eye. On a real continuation sheet of 40, 80, or 150 lines across several pages, doing it by hand is where errors slip through. PayAppCheck reads the whole schedule, recomputes G, the percent and H on every line, sums each column, and confirms the totals carry up to the G702. Any cell that does not tie is flagged. If you need the numbers in a spreadsheet, see how to convert a G703 to Excel without retyping it. If you are building the schedule of values rather than checking one, start from the free AIA-style G702/G703 Excel template, where the columns above are already wired up as formulas.
Paste your SOV into the free builder
The builder now takes a schedule of values pasted from any spreadsheet and turns it into this month’s G703.
Paste your SOVDownload the free template
The G702 certificate and G703 continuation sheet in one formula-linked .xlsx. Enter your email and it downloads.
Your address is never sold or given to anyone else for their marketing. Or download the .xlsx directly.
Questions people ask
What is a schedule of values on a pay application?
It is the breakdown of the contract sum into line items, each with a scheduled dollar value, that every progress billing is measured against. On AIA G702/G703 paperwork it is the G703 continuation sheet, columns A through I. The scheduled values in Column C must sum to the contract sum to date, and each period’s billing on every line is tracked against its scheduled value.
What does a schedule of values look like on a G703?
One row per line item, with its scheduled value in Column C and its billing to date across Columns D, E and F. In the worked example on this page a $200,000 site-work contract has four lines. At this application $50,000 was billed in previous applications, $35,000 this period and $10,000 is stored, so Column G totals $95,000, the figure G702 Line 4 has to show, and Column H totals $105,000 left to finish.
Who fills out the schedule of values?
The party applying for payment prepares it: the subcontractor on a sub’s pay application, the general contractor on the application to the owner. The receiving party, GC, owner, or lender, reviews and approves it before the first application and then checks every later application against the approved version. After approval, scheduled values change only through a change order.
How detailed should the line items be?
Detailed enough that a reviewer can verify each line’s percent complete against observable work on site. Most schedules break the job down by trade or CSI division, with large trades split further by phase, area, or into labor and material. Too coarse a breakdown hides front-loading behind big round percentages; one line per bolt bloats review without adding accuracy.
What happens when Column C does not sum to the contract sum?
The application cannot be certified until it ties, because the schedule and the certificate disagree about what the contract is worth. The two common causes are a change order added to the G703 but missing from Line 2 on the G702, and a scheduled value edited after approval without a change order. Measure the gap, sum of Column C minus Line 3: when it equals one change order exactly, that is the one missing from Line 2.
Build your G702/G703 free, check the math, download the PDF.
Make a pay app