Schedule of values for subcontractors: how to build one that bills clean

The schedule of values is the only document on a job that decides whether billing takes twenty minutes or a Sunday night. Most subs build it in a hurry, in the same workbook as the estimate, in the week the contract comes back signed — and then spend the next fourteen months paying for those twenty minutes. If you have ever argued with a GC’s PM about whether a line is 60% or 75% complete, with no way to prove either number, you have met a badly built SOV.

Here is how to build one that bills clean.

What a schedule of values actually is, from your side of the contract

Your contract value is one number. The schedule of values breaks that number into billable lines, each carrying its own scheduled value, so progress can be verified line by line instead of argued as a single percentage. That is the version everyone writes about, and it is written from the GC’s side: the SOV is how they check your billing.

The part nobody writes about is that the SOV is also your reporting structure. Every month until closeout, you will report progress against these lines — not against your estimate, not against your budget, against these lines. If they do not match how your crews actually work, you will be translating between two systems every single draw.

Build it like a document you have to live in, because you do.

Build the SOV from the way you bill, not from your estimate

Why estimate line items are the wrong granularity

Your estimate is organized for pricing. It is built to get a number right, so it splits work the way your costs split: material here, labor there, a line for every assembly you priced separately.

Your SOV is organized for progress reporting. It has to answer one question, once a month: how much of this line is done?

Those are different jobs, and copying one into the other is the most common mistake in sub-side billing. Too few lines and you cannot show progress — a single $900,000 line sits at “about halfway” for five months and your draw gets cut every time. Too many lines and you are estimating percent complete on forty rows a month, which nobody does accurately by the third month.

Somewhere between eight and twenty-five lines is where most commercial subcontracts land. If you are below eight, you probably cannot defend a draw. Above twenty-five, you are generating work for yourself.

Breaking out by phase or by area

Two structures work. Pick deliberately.

By phase follows your scope sequence — the order your crews actually do the work. It wins when your work is sequential across the whole building and your progress is genuinely phase-driven.

By area follows the building — by floor, by wing, by zone, by building number. It wins when the GC releases the job in pieces, which on most commercial work they do. If you are going to be 90% complete in the north tower and 20% complete in the south at the same time, an area breakout lets you bill that honestly. A phase breakout forces you to average it, and averages lose money.

The practical answer on a big job is both: area at the top level, phase inside each area. That is also the structure that lines up with how the GC’s superintendent walks the job, which matters more than it sounds like it should.

The lines to carve out on purpose

Three lines that are worth fighting for when you build the SOV, and nearly impossible to add later:

• Mobilization and general conditions, if the contract allows them. Your first month on a job has real cost and almost no installed work. A mobilization line is how that month gets billed.
• Stored materials, as their own line. On a material-heavy trade, there will be a month where the truck arrived and the crew has not started. Without a stored-materials line, that month is unbillable.
• Closeout and punch, held as their own line. If punch work is buried inside your production lines, the last few percent of every line gets stranded, and you will be chasing a small balance across fifteen rows for six months.

Where retainage sits, and why it bites at closeout

Retainage is withheld as you bill — per line, every draw — not deducted once at the end. That is obvious until you try to find it.

Here is the number that goes missing: retainage held across jobs that are otherwise finished. The work is done, the final draw was certified, the job is off your whiteboard, and some percentage of the contract value is still sitting with a GC waiting on a closeout package. Subs lose track of this routinely, because the job is mentally closed and the tracking lived in that job’s workbook.

Your SOV structure decides whether you can even reconcile it. If your lines do not match the lines the GC certifies against, your retainage-held figure and theirs will not agree, and the conversation about a $40,000 gap starts from two different spreadsheets. Agree the line structure before the first draw, not at closeout.

How change orders enter the SOV without breaking it

Approved change orders either become new SOV lines or adjust existing ones. That choice matters more than it looks.

Append them as new lines. It keeps the original contract legible — you can always see what the base scope was and what was added — and it leaves an audit trail that survives the person who built the workbook leaving. Folding a CO into an existing line buries it, and a year later nobody can explain why line 7’s scheduled value is $212,480 instead of the $198,000 in the contract.

The failure case is familiar: a change order approved in month six that never makes it onto the SOV. Bills quietly stop matching the contract value. Nobody notices until closeout, when the total billed does not reconcile and you are digging through email to find out which CO was never added. Every approved CO goes onto the SOV in the same week it is approved, or it eventually goes onto nothing.

The percent-complete conversation, and how to not lose it

There is the progress you claim and the progress the GC’s PM will certify, and the gap between them is where draws get cut.

The fix is not negotiating harder. It is documenting the basis before the walk, not during it: units installed, square footage complete, crew days expended, whatever your trade measures in. Show up with the number and what it rests on, and the conversation is a verification. Show up with a percentage and no basis, and it is a negotiation you will lose, because the person across the table is the one holding your money.

This is where daily logs do real work. The log is not paperwork for its own sake — it is the evidence behind the percentage. If you logged crew counts and completed areas every day for a month, the 68% you are claiming has a paper trail. If you did not, 68% is an opinion.

What breaks when the SOV lives in a spreadsheet

Three failures, all of them ordinary:

1. The SOV, the billed-to-date column and the job cost file are three separate files, and only one of them is current. You find out which one at the worst moment.
2. Retainage held is a formula nobody re-checked after the first change order. It was right in month one. It has been quietly wrong since month three.
3. The person who built the workbook is the only person who can bill from it. When they are out, billing waits.

None of that is a spreadsheet’s fault. A spreadsheet is a good tool for building an SOV once. It is a bad tool for operating one across a dozen jobs and four GCs for a year.

Your GC uses Procore. You use a spreadsheet. There’s a better way. Procore is the GC’s system of record — it is where you submit, and it is excellent at being that. It is not your billing system, it holds nothing about your costs, and it will never tell you which of your jobs is bleeding margin.

How SubMark handles it

SubMark is built for the sub’s side of this:

• Build the SOV once, and it locks when you submit the first draw. One structure, agreed up front, that every draw bills against.
• Approved change orders flow into the SOV and into every subsequent draw, so the contract value and the billed total stay reconciled by construction instead of by vigilance.
• Billed to date, retainage held and percent complete tracked per line on every draw — including retainage on jobs that are otherwise closed.
• Every GC’s draw deadline in one calendar, with reminders, no matter whose portal the pay app goes through.
• Certified draws push to QuickBooks Online instead of being re-keyed.
• Job costing reads the same data, so budget versus actual sits next to what you have billed — which is the only place margin erosion is visible while you can still act on it.
• Lien waiver tracking against each draw, from sent to signed to received, with the signed copy on file.

Each half of that has its own page: schedule of values for the structure and what every line carries, draw tracking for the deadlines and the billed-certified-received chain, retainage tracking for the money being held back, and lien waiver tracking for the paperwork that gates the release.

If half your contract value is product you bought months before you installed it, the stored-material lines are not a detail, they are the argument — see doors, frames and hardware.

Field users and the subs you invite are free and unlimited, which is the whole point — see how pricing works.

A build order you can use this week

1. Pull the contract value and the contract’s own billing terms. Everything else is downstream of what you actually agreed to.
2. Choose phase or area — or area-then-phase on a big job. Decide, do not default.
3. Carve out the deliberate lines: mobilization, stored materials, closeout and punch.
4. Set the retainage basis per line, and write down the percentage and when it releases.
5. Agree the progress basis with the GC’s PM before the first draw. Units, areas, or crew days. Get it in an email.
6. Decide where change orders will land — new lines, appended — and tell whoever bills that this is the rule.

Twenty minutes of structure in week one, or a Sunday night every month for a year. It is the same decision either way; you just make it earlier.