Introduction
Every QS I know builds their CVR the same way.
Open a spreadsheet. Start pulling figures from the subcontract register. Cross-reference the payment application folder. Check what variations have been approved. Add the procurement commitments. Work out what's been certified upstream.
It takes two or three days. Sometimes longer if a project manager hasn't kept their records straight. By the time the figures go in front of the commercial director, they're already two weeks old.
The director asks a question about a specific package. Nobody in the room can answer it without going back to the spreadsheet and the project files it's linked to. The conversation stalls. Decisions get deferred.
This is how most commercial teams in UK construction manage their CVR process. And it works, up to a point. The question is where that point is, and whether you've already passed it.
This article compares running cost value reconciliation in spreadsheets against using dedicated construction CVR software, so you can make an informed decision about which approach is right for your business. If you need a primer on what CVR actually involves first, read our guide on what is cost value reconciliation in construction.
What CVR Actually Requires
Before comparing tools, it's worth being clear about what a proper CVR needs to capture.
At its core, a cost value reconciliation compares what a project has cost against what it has earned. That sounds simple. In practice, it means pulling together:
- Committed costs: Subcontract orders, materials procurement, plant hire, direct labour
- Incurred costs: What's actually been paid or certified at any given point
- Certified value: What the client has certified upstream
- Variations: Approved, submitted and unapproved, both upstream and downstream
- Forecasts: Projected final cost and final value, and the margin between them
- Risk items: Uncommitted costs, unrecovered variations, disputed amounts
A CVR that misses any of these is incomplete. And an incomplete CVR produces decisions based on partial information.
The challenge isn't knowing what to include. Every experienced QS knows what a CVR should contain. The challenge is getting all of that data, reconciled and accurate, quickly enough to be useful.
The Problem with Spreadsheets for CVR
Spreadsheets are not inherently bad tools. They are flexible, familiar, and free. For a single project, with one QS and a straightforward contract, they can work perfectly well.
But most commercial teams are not running a single project with a straightforward contract.
Data Is Always Scattered
A CVR built in a spreadsheet requires the QS to manually gather information from multiple sources. The subcontract register might live in a shared drive. Payment applications come in by email. Procurement data sits in a separate system or another spreadsheet. Variation logs are maintained by individual project teams and formatted differently on every job.
Every time you run a CVR, you are reassembling this picture from scratch.
It Takes Days to Produce, Not Hours
According to RICS guidance on commercial management, timely cost reporting is a fundamental discipline in managing project risk. But timely and manual are difficult to combine.
When the CVR takes two or three days to build, it can only realistically happen once a month. That means the commercial picture is 30 days old between reviews. Margin erosion happening in week two of the month goes undetected until week one of the following month.
Format Inconsistency Across Projects
Ask three QSs to build a CVR and you will get three different formats.
Different column headings. Different ways of handling variations. Different approaches to forecasting. When a commercial director has to review CVRs from five projects, they spend the first 20 minutes of each review understanding how the spreadsheet is structured rather than interrogating the numbers.
It becomes impossible to compare project performance at a portfolio level. You cannot quickly see which projects are trending over budget, which margins are at risk, or where the business needs to focus attention.
Version Control Is a Constant Problem
Spreadsheets get emailed. They get saved locally. Someone updates a figure in the version on their desktop but not the shared drive. By the time figures are presented in the monthly commercial meeting, nobody is certain they are looking at the latest version.
This is not a criticism of the people involved. It is a structural weakness of spreadsheets as a collaboration tool. When multiple people need to contribute to the same document, version control becomes a problem that people management cannot fix.
Errors Compound Over Time
Manual data entry introduces errors. Formula errors compound them. A broken link to another worksheet means a whole section calculates incorrectly and nobody notices until the final account.
The Construction Leadership Council's productivity report has consistently highlighted data quality as a major constraint on commercial performance across the UK industry. Spreadsheet-based processes are a significant contributor.
What CVR Software Does Differently
Dedicated CVR software does not just digitise the spreadsheet. It changes the underlying process.
Live Data Rather Than Monthly Snapshots
When subcontract orders, payment applications, variations and certified values all feed into the same system, the CVR can be generated at any point. Not just at month end. Any time, in real time, reflecting the current position of the project.
A QS can pull a CVR on a Tuesday afternoon before a client meeting. A commercial director can check the portfolio position before a board meeting without waiting for someone to compile a report.
Consistent Format Across Every Project
Because the data structure is standardised within the software, every CVR looks the same. Same format. Same definitions. Same approach to variations and forecasting.
Commercial directors can compare project performance directly. Portfolio reporting becomes genuinely useful because the underlying data is comparable. When something looks wrong on one project, it is immediately apparent against the wider picture.
Margin and Risk Visibility Built In
Good CVR software does not just show you the current position. It shows you where the project is heading.
Forecast final margin. Uncommitted costs. Unrecovered variations. Early warnings on packages that are trending over their subcontract value. These risk items are calculated automatically from the live data, not worked out manually by a QS who has to remember to check.
This is the difference between knowing your current margin and understanding your projected final margin. The second figure is the one that matters for decision-making.
Version Control Eliminated
Because there is one version of the data in the system, version control ceases to be a problem. Everyone looking at the CVR is looking at the same figures. There is no question of which spreadsheet is the latest one.
When Spreadsheets Still Make Sense
It would be dishonest to say spreadsheets are always the wrong answer.
If you are a small business running one or two projects at a time, with a single QS managing the commercial process end to end, a well-structured spreadsheet can be perfectly adequate. The overhead of implementing software is not always justified.
If your projects are genuinely simple, with straightforward subcontract structures, minimal variations and short programmes, the complexity of a CVR is limited and the manual process remains manageable.
The honest question is not whether spreadsheets can work. It is whether they are limiting what your commercial team can actually achieve.
Signs You Have Outgrown Spreadsheets
Here are the signals that indicate the manual process is costing you more than you realise.
- CVRs consistently arrive in meetings already two or more weeks out of date
- Commercial directors cannot compare project margins without asking QSs to explain their spreadsheet structure
- The monthly CVR build takes more than a day of QS time per project
- Variation tracking is inconsistent across projects and packages
- Margin erosion on a project has only become visible at the final account stage
- Different QSs are producing CVRs in different formats and there is no standardised template
- You cannot produce an accurate portfolio-level commercial summary without spending days compiling individual project reports
If three or more of these apply, the spreadsheet is not a neutral tool. It is actively limiting your commercial control. Our commercial control scorecard can help you assess where the specific gaps are in your current process.
What to Look for in CVR Software
If you are evaluating options, these are the capabilities that matter. For a broader framework on evaluating construction management software, our software adoption guide covers what to look for across the procurement and commercial stack.
Live data integration: The CVR should draw from live subcontract orders, payment applications and variation records. If you are still manually importing data, you have not solved the core problem.
Consistent output format: Every project should produce a CVR in the same structure. Portfolio comparison only works if the underlying data is standardised.
Forecast final account: The software should calculate projected final cost and value, not just the current position. Risk items should be identified automatically from the live data.
Audit trail: Commercial disputes happen. You need to be able to show the historic position at any point in time, with a clear record of what was included and when.
Built for construction: Generic financial software adapted for construction requires significant customisation and produces compromises. Construction-specific software understands JCT and NEC contracts, subcontract structures, and how payment applications and variations interact with the CVR.
StoneRise's commercial management software is built by qualified quantity surveyors who ran construction businesses for a decade before writing a line of code. The CVR functionality reflects how the process actually works on a main contractor programme, not how it looks in a generic financial model.
Conclusion
Spreadsheets built UK construction's commercial management processes. For decades they were the best available option and a lot of experienced QSs still use them effectively.
But the limitations are structural. They cannot provide live visibility. They cannot standardise reporting across a portfolio. They require significant manual effort every month to produce a snapshot that is already becoming outdated.
CVR software does not replace the judgement of a good QS. It gives them current, accurate data to apply that judgement to. Less time building the picture. More time interrogating it and making decisions.
The question is not whether you can manage CVR in spreadsheets. Most commercial teams can. The question is what it is costing you in time, accuracy, and commercial control to keep doing so.
See CVR Software in Action
StoneRise produces cost value reconciliations from live project data, automatically, for qualifying main contractors. No spreadsheet builds. No month-end scrambles. A current picture of every project, any time you need it.
FAQ: CVR Software vs Spreadsheets in Construction
Can you run CVR effectively in Excel?
Yes, particularly for smaller businesses with one or two projects and a single QS managing the process. Excel is flexible and most commercial teams are already proficient. The limitations become significant as project volume increases, where format inconsistency, manual data gathering, and version control create real problems.
What is the main advantage of CVR software over spreadsheets?
Live data. A spreadsheet-based CVR is a snapshot built manually from multiple sources. CVR software pulls from live project data, meaning the cost value reconciliation can be produced at any point rather than only at month end. For commercial directors managing multiple projects, this difference in timeliness fundamentally changes what decisions can be made and when.
How long does it take to produce a CVR in software compared to a spreadsheet?
A spreadsheet CVR typically takes one to three days of QS time per project, depending on contract complexity and how well the underlying records are maintained. With CVR software drawing from live data, producing the report takes minutes rather than days. The time saving comes from eliminating the manual data gathering stage.
Does CVR software replace the need for a QS?
No. CVR software automates the data gathering and calculation element of the process. The judgement involved in interpreting the numbers, managing risk items, and forecasting the final account still requires an experienced QS. The software gives QSs better information to work with, not a replacement for their expertise.
What size of contractor benefits most from CVR software?
Main contractors running multiple concurrent projects are where the return on investment becomes most clear. The benefits of standardised format, portfolio visibility and live data compound when you are managing five or more projects simultaneously. Smaller businesses running one or two projects may find the overhead of implementation is not justified against the manual process they already have.
Last updated: June 2026
