✦ Sector
CVR in construction: getting cost value reconciliation out of spreadsheets
CVR in construction - cost value reconciliation - is the monthly comparison of what a job is worth against what it has cost, used to report margin honestly rather than by guesswork. Most contractors build it in Excel. Here's how it's actually assembled, and where that approach stops working.
Haystak · 11 August 2026 · Updated 11 August 2026 · 9 min read
Cost value reconciliation (CVR) in construction is the process of comparing the value a contract has earned to date against the cost incurred to earn it, on a set date each month, to arrive at a reported margin. It's the mechanism that turns site activity into a number the board and the bank can trust.
Every mid-sized contractor does it. Most do it in a spreadsheet built years ago by someone who has since left, with formulas nobody wants to touch. It works, until the business runs enough live contracts that one person can no longer hold the whole picture in their head by the reporting deadline.
What a CVR report actually contains
At its simplest, a CVR compares value against cost for a single contract at a point in time. The result - value minus cost - is the reported margin, and the change in that margin month on month is what commercial managers and finance directors actually watch.
| Component | What it represents | Where it comes from |
|---|---|---|
| Certified value | What the client's QS has agreed the work is worth so far | Valuation / interim certificate |
| Applied value | What the contractor has claimed the work is worth | Application for payment |
| Cost to date | Actual cost incurred, from the ledger | Purchase ledger, labour, plant, subcontract |
| Cost to complete | Estimated cost to finish the remaining work | QS / site manager judgement |
| Accruals | Cost incurred but not yet invoiced | Delivery notes, verbal orders, known liabilities |
| Retentions | Value withheld by the client, and by the contractor from subcontractors | Contract terms |
| Variations | Agreed or pending changes to scope and value | Instructions, compensation events |
Certified and applied value are not the same thing, and the gap between them matters. Applied value is what the contractor thinks it's owed; certified value is what the client's QS has actually agreed. A contractor reporting margin against applied value alone is reporting an aspiration, not a fact - which is a common way CVRs mislead the people relying on them.
How the monthly CVR cycle actually runs
The cycle is anchored to the valuation date on each contract, which rarely lines up neatly with the company's month end. That mismatch is one of the quiet reasons spreadsheet CVRs take so long to assemble - every contract is on its own clock.
- 01Valuation submitted and certified. The QS submits an application; the client's QS certifies a value, often lower, and often late.
- 02Cost to date pulled from the ledger. Actual invoiced cost, plus labour and plant allocated to the contract's cost codes.
- 03Accruals added. Cost that's happened but hasn't hit the ledger yet - a delivery on site, a subcontractor's verbal instruction - has to be estimated and added, or the reported cost understates reality.
- 04Cost to complete re-forecast. The QS or site manager reviews remaining scope and re-estimates what it will cost to finish, which is where most of the judgement - and most of the disagreement - sits.
- 05Retentions and variations reconciled. Retention percentages applied per contract terms; variations checked against what's actually been agreed versus what's still pending.
- 06Margin calculated and compared to last month. A sudden swing gets investigated before the report goes to the board, not after.
Where WIP fits in
Work in progress (WIP) is the accounting side of the same picture: the value of work done but not yet certified or invoiced, which has to be recognised correctly in the accounts under the relevant standard. A CVR that's wrong flows straight into a WIP figure that's wrong, which is one reason auditors ask pointed questions about how contractors build their CVRs, not just what the final number says.
Getting this right also depends on accurate underlying cost allocation - see time tracking software for construction for how labour cost actually reaches the right cost code before it ever reaches a CVR.
Why the spreadsheet version breaks at scale
A spreadsheet CVR works fine for five contracts and one QS who built it. It breaks for reasons that are entirely predictable once you've seen it happen a few times.
- No single source of truth. Cost-to-date is manually copied from the accounts system, so it's always slightly stale and occasionally wrong.
- Formulas nobody understands. The person who built the model has moved on, and everyone is now afraid to touch a cell.
- No audit trail on judgement calls. Cost-to-complete estimates change from month to month with no record of why, which makes trend analysis unreliable.
- Doesn't scale with headcount. Each new QS builds their own version, so contract reports are inconsistent across a portfolio.
- Consolidation is manual. Rolling up twenty contracts into a group position means twenty separate files and a lot of copy-pasting under deadline pressure.
None of this is a criticism of the QS building the spreadsheet - it's usually the most sensible tool available at the time. The problem is what happens as contract count and headcount grow past what one well-built spreadsheet can hold together.
What replacing the spreadsheet actually involves
The fix is rarely 'buy a CVR product'. Off-the-shelf construction ERPs include CVR modules, but many contractors find them too rigid for how their commercial team actually thinks about cost-to-complete and variations. The alternative is a bespoke reporting layer that pulls cost-to-date and applications automatically from your existing accounts and site systems, and leaves the QS's judgement calls - cost to complete, variation status - as the only manual input.
That's a smaller build than replacing the whole finance system, and it's the shape of work we typically scope under bespoke software development for construction. If your CVR is still living in one person's spreadsheet, talk to us about what a live version would need to pull in automatically.
For the accounting treatment behind WIP and contract revenue recognition, ICAEW's technical guidance is a reliable starting point when briefing a build alongside your auditors.
✦ Where this fits
More on this from us: our construction software work.