Introduction
Searching for a construction CVR template usually means one of two things. Either you are setting up commercial reporting for the first time, or the spreadsheet you have is not giving the commercial team a trustworthy view of margin.
A CVR template is not just a formatted table. It is the structure that forces the right questions every reporting cycle: what have we earned, what have we spent, what are we committed to, what is still forecast, and what will the final margin be?
This guide sets out what a proper construction CVR template should include, the columns that actually matter, and the design mistakes that turn a template into a month-end box-ticking exercise rather than a management tool.
What a Construction CVR Template Is For
A Cost Value Reconciliation template exists to reconcile earned value against cost, then project the final commercial position. If you need the fundamentals first, start with what cost value reconciliation is and what a CVR report shows.
A good template should make three things obvious at a glance:
-
Current position: value to date versus cost to date
-
Certainty of the remaining cost: committed versus uncommitted
-
Forecast final margin: and what is putting it at risk
If your template only shows current margin and a single blended cost-to-complete figure, it is incomplete.
Core Sections Every CVR Template Needs
1. Project Header
Include project name, contract sum, reporting period, QS owner, and date of data cut-off. Without a clear cut-off date, every comparison between periods is unreliable.
2. Value Section
| Column | Purpose |
|---|---|
| Original contract sum | Baseline value |
| Agreed variations | Formally agreed changes to value |
| Submitted / pending variations | Value claimed but not yet agreed |
| Anticipated variations | Expected instructions not yet formalised |
| Applied / earned value to date | Value of work achieved to date |
| Certified value to date | Value certified by the client or CA |
| Forecast final value | Expected total value at completion |
Separating agreed, submitted, and anticipated value stops optimistic recovery assumptions from quietly inflating margin.
3. Cost Section
| Column | Purpose |
|---|---|
| Cost to date (invoiced) | Actual cost posted |
| Accruals | Incurred but not yet invoiced |
| Cost to date (including accruals) | True cost position to date |
| Committed cost | Placed orders and subcontracts not yet fully expended |
| Uncommitted / forecast remaining cost | Estimated cost still to come |
| Provisions / risk allowance | Known risks not yet crystallised |
| Forecast final cost | Expected total cost at completion |
This is where many templates fail. Blending committed and uncommitted cost into one "cost to complete" number hides the real risk. Keep them separate, as explained in committed vs uncommitted costs.
4. Margin and Movement
| Column | Purpose |
|---|---|
| Current margin (£ / %) | Value to date less cost to date |
| Forecast final margin (£ / %) | Forecast final value less forecast final cost |
| Movement since last CVR | What changed and why |
| Key risks / actions | What the commercial team must do next |
A template without movement commentary is a snapshot, not a management document. RICS guidance on cost reporting is clear that cost reports should support decision-making, not just present totals.
Recommended Package-Level Rows
Portfolio summaries are useful for directors. Day-to-day control happens at package level.
Your construction CVR template should allow rows for:
-
Preliminaries
-
Each major subcontract package
-
Direct materials / labour where relevant
-
Provisional sums
-
Contingency / risk
For each package, track order value, cost to date, committed remaining, forecast final cost, and variance to allowance. That is how you see which package is driving margin movement before the project total moves.
Common CVR Template Mistakes
One blended cost-to-complete column. Looks tidy. Hides whether the remaining cost is locked in or still estimated.
No split between certified and applied value. Certified value can lag earned value. Using only certified figures understates progress and distorts current margin.
Variations dumped into one total. Agreed, disputed, and anticipated variations do not carry the same certainty. Mixing them inflates forecast value.
No owner or action column. A CVR that identifies risk without assigning an action will be rediscussed next month with no progress.
Manual re-keying from multiple sources. The template becomes the reconciliation exercise. By the time it is finished, the data is already ageing. That is the core weakness of spreadsheet CVRs covered in CVR software vs spreadsheets.
Spreadsheet Template vs Live CVR
A spreadsheet construction CVR template is a sensible starting point for process discipline. It forces consistent columns and a shared language across projects.
It breaks down when:
-
Multiple people update different source sheets
-
Accruals and commitments are entered late or inconsistently
-
Variation registers sit outside the CVR
-
Directors need a current view mid-period, not just at month end
CVR software should still follow the same template logic. The difference is that value, cost, commitments, and variations feed the structure automatically, so the QS spends time interrogating the position rather than rebuilding the table.
A Simple Checklist Before You Sign Off a CVR
Use this against any construction CVR template, spreadsheet or system:
-
Cut-off date is stated
-
Applied value and certified value are both visible
-
Variations are split by certainty (agreed / submitted / anticipated)
-
Cost includes accruals
-
Committed and uncommitted cost are separate
-
Forecast final margin is shown, not only current margin
-
Movement since last period is explained
-
Risks have named owners and next actions
If any of those are missing, the template is not ready for a commercial review meeting.
Conclusion
A construction CVR template is only useful if it structures the commercial conversation properly. The right sections force clarity on value certainty, cost certainty, forecast margin, and action. The wrong template produces a neat percentage that nobody can trust.
Start with the sections above. Keep package-level detail. Separate what is fixed from what is forecast. Then connect the template to live project data so the CVR stays current enough to manage, not just report.
Turn Your CVR Template Into a Live Commercial View
StoneRise follows the same CVR structure commercial teams already use, fed by live valuations, costs, commitments, and variations, so the template stops being a monthly rebuild.
FAQ: Construction CVR Template
What should be in a basic construction CVR template?
Project header, value section, cost section (with accruals, committed, and uncommitted cost), forecast final margin, movement commentary, and actions.
Should a CVR template be project-level or package-level?
Both. Directors need a project summary. QSs need package-level rows to find where margin is moving.
Is there a standard industry CVR template?
Formats vary by contractor, but the underlying components are consistent: earned value, cost, commitments, forecast final position, and risk. RICS cost reporting principles are a useful reference point for structure and purpose.
Can I use the same CVR template across every project?
Yes, and you should. Consistent columns make portfolio reviews possible. Project-specific detail belongs in the package rows and commentary, not in a completely different layout each time.
Last updated: August 2026
