Why You Need a Schedule of Values Template
The Schedule of Values (SOV) is the financial backbone of your construction contract. It breaks the total contract price into line items that map to the work being performed — and it's what your monthly pay applications are built on.
Getting the SOV right at the start of the project saves you from billing headaches, cash flow gaps, and disputes with owners or GCs later. A poorly structured SOV leads to front-loading accusations, retainage arguments, and pay apps that don't reflect the actual work completed.
What's Inside the Template
The spreadsheet includes a complete SOV framework for C&I solar projects:
- Line items by phase — Engineering, Procurement, Construction, Commissioning, and Closeout, broken into billable work categories
- Contract value columns — Original contract amount, approved change orders, and revised contract total for each line item
- Billing columns — Previous billings, current period work completed, materials stored, total completed and stored, retainage, and net amount due
- Percentage complete — Automatic calculation of percent complete for each line item and the overall project
- Retainage tracking — Standard retainage calculation with columns for held and released amounts
How to Use It
- Download the template and open it in Excel or Google Sheets
- Break your contract into line items — each line item should represent a meaningful portion of the work that can be measured and billed
- Assign values to each line item — the total of all line items must equal the contract price
- Submit for approval — most owners or GCs will review and approve the SOV before you submit your first pay application
- Update monthly — each billing cycle, fill in the percent complete or dollar amount completed for each line item
- Track change orders — when approved changes come in, add them as new line items or adjust existing ones
Customization Tips
Don't front-load. It's tempting to assign heavy values to early phases (engineering, procurement) to improve early cash flow. Owners and GCs know this trick. Keep values proportional to the actual cost of work to maintain credibility and avoid disputes.
Match your WBS. Your SOV line items should align with your WBS phases and cost codes. When the same structure drives your budget, schedule, and billing, everything reconciles cleanly.
Right-size your line items. Too few line items (5–6) and you can't show granular progress. Too many (50+) and monthly billing becomes a burden. For most C&I solar projects, 15–25 line items is the sweet spot.
Separate materials from installation. For procurement-heavy items like modules and inverters, consider splitting into "materials delivered" and "materials installed." This lets you bill for stored materials before they're installed — important for cash flow on projects with long installation timelines.
Understand retainage. Standard retainage is 5–10% held from each pay app until substantial completion. Know your contract terms and make sure the template reflects the correct retainage rate.
How the SOV Connects to Your Project Systems
The SOV ties directly into your financial workflow:
- Pay Applications — Every monthly pay app is built from the SOV. Percent complete on each line item drives the billing amount
- Budget — SOV line items should map to budget categories so you can compare what you're billing vs. what you're spending
- WIP Reports — The SOV provides the "billings" side of your WIP calculation (earned revenue vs. actual billings)
- Change Orders — Approved change orders modify the SOV with new or adjusted line items and revised contract totals
- Cash Flow — Your billing schedule, driven by the SOV, determines when cash comes in. Structure it to match your cost outflows