SOVIQ AI › Guides › Schedule of values template

Schedule of values template, and how to build one that gets you paid on time

The schedule of values is the document every pay application on the job is built from. Spend an hour getting it right and you will save a fight every month for the life of the project.

By Vagish Kapila, founder of Varshyl Inc. and a licensed California general contractor · Updated 2026-11-16

Download the template

Download the free schedule of values template (Excel). It has the nine continuation-sheet columns, formulas for total-to-date, percent complete, balance to finish and retainage, a summary block that matches the G702 cover page, and sample lines you replace with your own.

What a schedule of values is

A schedule of values (SOV) breaks the contract sum into line items with a dollar value each, typically by trade or CSI division: mobilization, demolition, concrete, framing, roofing, plumbing, electrical, finishes, closeout. The values must add up to the contract sum. Once the owner approves it, every pay application reports progress against those lines; it is the one document that both sides agree defines what a dollar of work looks like.

How to break down the contract

  1. Start from your estimate. Your bid already has the costs by trade; the SOV is those costs with overhead and profit spread across them.
  2. Separate labor-heavy and material-heavy lines where the owner will ask (for example "Lumber, material" and "Rough carpentry, labor"). It makes stored-material billing clean.
  3. Give mobilization and general conditions their own lines so early-month costs can be billed early.
  4. Keep closeout as a line (as-builts, O&M manuals, punch list); it lets the owner hold something at the end without holding everything.
  5. Twenty to sixty lines is normal for a small or mid-size commercial job. Fewer and the owner can't verify progress; more and you are doing paperwork for its own sake.
  6. Match the owner's cost codes if they give you any; it saves a round of questions.
  7. Add approved change orders as new lines, numbered after the original items, so the original scope stays auditable.

Front-loading, and why it gets applications rejected

Contractors sometimes weight early lines heavier than their real cost to improve cash flow. Owners and lenders know this, and a schedule where mobilization is 8% of a $2M job will be sent back. A defensible SOV tracks real cost plus a consistent markup. Legitimate cash-flow help comes from billing mobilization and stored materials promptly and from negotiating retainage, not from the numbers.

The columns your template needs

ColumnFormula
Scheduled valueEntered once
From previous applicationLast month's total to date
This periodEntered monthly
Materials presently storedEntered monthly
Total completed and stored to dateprevious + this period + stored
% completetotal to date ÷ scheduled value
Balance to finishscheduled value − total to date
Retainagetotal to date × retainage rate

The template's summary block sums these and computes total earned less retainage, less previous certificates, and current payment due, the same arithmetic as a G702 cover page.

When the template stops being enough

A spreadsheet is fine for one job. By the third concurrent project you are copying sheets, pasting last month's total into this month's previous column, and hoping nobody inserted a row. That is where errors come from, and every error is a month of cash. SOVIQ reads the schedule of values (or the bid) once, keeps it as the source of truth for every application on the job, carries previous billing forward automatically and reconciles change orders.

Frequently asked

What is the difference between a schedule of values and a bid?

The bid is your price to the owner, usually a lump sum with some breakdown. The schedule of values is that sum broken into line items the owner approves for billing purposes. The SOV must equal the contract sum.

Who approves the schedule of values?

The owner, usually through the architect or construction manager, before the first pay application. Changes after that come only through change orders.

Should overhead and profit be a separate line?

Usually no. Most owners expect overhead and profit spread across the lines. A separate "fee" line is common on cost-plus or GMP contracts.

Is the template free?

Yes, no email required. Download it above.

Skip the template: let SOVIQ build the schedule from your bid

Upload your bid, proposal or an old SOV as PDF, Excel or Word. SOVIQ reads it, structures the line items, checks the totals and turns it into monthly pay applications. $150 a month, AI included.

Start billing with SOVIQ →   See pricing