Free tool · no sign-up

Free Schedule of Values Template and Online Builder

Enter each line of your subcontract with its scheduled value and see the total checked against the contract sum as you type. Download it as an Excel file with formulas or as a CSV, or open it in the pay application generator to bill against it.

Prefer to start in Excel?Blank template (.xlsx)Electrical example (.xlsx)Formulas total the lines and check them against the contract sum.
ItemDescription of workScheduled value% of contractRemove
2.0%
1.2%
3.0%
7.8%
10.7%
3.8%
6.4%
2.5%
9.5%
11.9%
11.1%
8.4%
5.6%
4.5%
7.0%
2.4%
1.5%
0.7%
Total$486,000.00100.0%
Amounts in US dollars. Leave change orders off: they're billed as their own lines.

The lines add up to the contract sum.

Lakeside Medical Office Building18 lines

Original contract sum$486,000.00
Schedule of values total$486,000.00
Contract sum less total$0.00

Made in your browser; nothing is uploaded.

Next stepBill against this schedule

Open the free pay application generator with these lines, the contract sum and the names already filled in. Enter this period's percent complete and download a G702/G703-style PDF. It replaces any draft you have open in the generator.

Schedule of values example

An electrical subcontractor signs a $480,000 subcontract on a two-story medical office building. Its schedule of values has 7 lines, and the scheduled values add up exactly to the contract sum:

ItemDescriptionScheduled value% of contract
1Mobilization, bonds, insurance & submittals$14,000.002.92%
2Underground & site conduit$38,000.007.92%
3Switchgear, panelboards & transformers (material)$96,000.0020%
4Gear setting & feeders (labor)$70,000.0014.58%
5Branch rough-in, levels 1 & 2$128,000.0026.67%
6Lighting fixtures, devices & trim$114,000.0023.75%
7Testing, closeout, O&M manuals & warranty$20,000.004.17%
Original contract sum$480,000.00100%

Each month the subcontractor bills a percent complete against these lines, and the GC's project manager checks every line on a site walk before approving the pay app. Underground conduit billed at 75 percent should look three-quarters done in the trench; switchgear billed as stored material should be on site. Lines billed ahead of the work are cut back, and the approved amounts roll into the GC's own pay application to the owner.

The GC also watches what is left on each line. The balance to finish, plus the retainage held, is what it would cost the GC to finish the scope if the subcontractor left, so mobilization stays at 2.92% of the contract and closeout carries $20,000 until the as-builts and O&M manuals are delivered. Most real schedules split the work further; the schedule of values guide breaks the same contract into 17 lines and bills a first pay app against it.

What is a schedule of values?

A schedule of values (SOV) is the breakdown of your subcontract into lines of work, each with a dollar value. Together the lines add up to the original contract sum. It is usually the first document a general contractor asks for after the subcontract is signed, and it has to be approved before your first pay application.

After that, every pay application bills against it. Each month you report the percent complete on each line, and the GC, the architect and the owner's lender check that progress against what they see on site. On a G702/G703-style application the schedule of values becomes the continuation sheet, with one row per line. Approved change orders are added below the original lines; the original lines don't change.

A good schedule of values for a specialty subcontractor:

  • adds up exactly to the original contract sum, before change orders;
  • splits the work the way it will be built, by building, floor, area or phase;
  • separates material from labor on major equipment, so stored materials can be billed against the right line;
  • lists general conditions such as mobilization, submittals and closeout as their own, modest lines;
  • follows the line items or cost codes the GC gives you, when they give you a format.

How general contractors review a schedule of values

The project manager checks the schedule against the subcontract and against their own budget for your scope. On most jobs the architect or the owner's lender looks at it too, because the same lines are what they certify payment against every month. Expect them to check:

  • The total. It must equal the subcontract amount to the cent. A schedule that doesn't add up comes straight back.
  • Line detail. A line has to be small enough that its percent complete can be judged on a site walk. "Electrical: $480,000" can't be checked; rough-in by floor can.
  • Values per line. Each line is compared with what that work usually costs. Lines that look high for early work, or low for closeout, get questioned.
  • Format. Many GCs want their own line items, cost codes or spreadsheet, especially when they bill through a portal. Ask before you build it.
  • Retainage and closeout items. Some GCs want a separate line for closeout documents, O&M manuals, as-builts or warranty, so they hold real value until those are delivered.

Once it's approved, treat it as fixed. Moving value between lines later needs the GC's agreement, and new work comes in as change orders on their own lines.

Front-loading: why GCs send schedules back

Front-loading means putting more value on the work done early in the job, such as mobilization, underground, rough-in or early material, and less on the work done late, such as trim, testing and closeout. The total stays the same, but more of the contract gets billed in the first months, which helps the subcontractor's cash flow.

GCs, owners and lenders watch for it because it leaves too little value on the remaining work. If the subcontractor walks off or goes under, the money left in the contract may not pay someone else to finish, and the retainage held may not cover the gap. A front-loaded schedule is usually returned for revision, and some contracts, public ones especially, forbid it outright. It also costs trust you need when you later ask for retainage to be reduced or released.

Price each line at what that work costs plus its share of overhead and profit. Mobilization is usually a few percent of the contract, not a large share of it. If a line looks high, be ready to show how you got to it. The % of contract column in the builder and in the Excel template shows where the value sits at a glance.

Frequently asked questions

What is a schedule of values in construction?

A schedule of values breaks a construction contract into lines of work, each with a dollar value, that add up to the contract sum. The general contractor approves it before the first pay application. Every pay application after that bills a percent complete against each line, so the GC, the architect and the lender can check the billing against progress on site.

What does SOV mean in construction?

SOV stands for schedule of values. It is the line-by-line breakdown of a contract's value that every pay application bills against. On a G702/G703-style pay application, the SOV becomes the continuation sheet.

How do I make a schedule of values for a pay application?

Start from your estimate and group it into lines the GC can check on site, by building, floor, area or system, with material split from labor on major equipment. Price each line at its cost plus its share of overhead and profit, and keep mobilization and closeout as modest lines of their own. Check that the lines add up exactly to the contract sum and send the schedule to the GC for approval before your first pay application. If the GC gives you a format or cost codes, use them.

Does the schedule of values have to match the contract sum?

Yes. The scheduled values must add up exactly to the original contract sum, to the cent, or the GC will send the schedule back. Approved change orders are added later as their own lines, so the original lines stay as approved. The builder and the Excel template both check the total against the contract sum.

What is front-loading a schedule of values?

Front-loading is putting more value on the early lines, such as mobilization, rough-in or materials, than that work is worth, so more of the contract is billed early. General contractors, owners and lenders look for it and send front-loaded schedules back for revision. Price each line at what the work costs plus its share of overhead and profit.

How many lines should a schedule of values have?

Enough that the general contractor can check your percent complete each month. Split large scopes by building, floor or phase, and split material from labor on major equipment. Many subcontract schedules have 10 to 40 lines. If the GC gives you a format or cost codes, use them.

Does the Excel template work in Google Sheets?

Yes. The template uses only standard formulas (SUM, IF, INDEX, ROUND and TEXT), which work in Excel, Google Sheets and LibreOffice. The CSV has columns for item, description and scheduled value, for importing into other software.

Is my schedule sent to RetainageBack?

No. The builder makes the Excel and CSV files in your browser and keeps your draft in this browser's storage. When you open it in the pay application generator, the schedule goes in the part of the page address after the #, which your browser doesn't send to our server.

From schedule of values to getting paid

Once the schedule is approved, use it to create a pay application each month. A free RetainageBack account keeps the schedule and its change orders for every job, rolls each pay app forward, and shows the retainage each GC is still holding. Read how a schedule of values becomes the G703, with a worked example, and what retainage is and how it's calculated.