Cost Value Reconciliation (CVR) Template
A professional, formula driven Cost Value Reconciliation template built for commercial teams from a main contractor or subcontractor.The CVR sits at the core of commercial management on a construction project. This template gives you a structured, repeatable format for tracking value, cost and margin every period, with the reconciliation section calculated automatically from the figures you enter.What is included:CVR Summary tab The main reporting sheet, structured in six sections:Value - Original Contract Sum, Approved Variations and Anticipated Final Contract Sum; value certified to date, previous period and period movement; pending variations for commercial intelligence; Forecast Final Value.Cost - Budget and cumulative cost to date across five cost categories: Subcontractors, Labour (Direct), Plant and Equipment, Materials, and Preliminaries; period movement and cost to complete; Total Cost row.Reconciliation - Gross Margin to Date in pounds and percentage; Forecast Final Margin in pounds and percentage; all calculated from the value and cost sections automatically.Movement This Period - records the Forecast Final Margin from the last period and this period, with movement calculated in pounds and percentage.Explanation of Movement - free text narrative field for documenting the reasons behind any margin movement.Risk and Opportunity - log individual risks and opportunities with description, category, potential impact and probability weighting.Package Breakdown tabDetailed subcontractor cost tracker. Log each package with a description, subcontractor name, package budget and subcontract sum. Track cumulative cost to date, previous period and period movement per package. The total row feeds directly into the Subcontractors line on the CVR Summary.Project Information tabEnter your project details once: Project Name, Project Number, Client, Contract Type, Contract Start and Completion Dates, Report Number, Reporting Period, Date of Report, Prepared By and Checked By. All fields pull through automatically to the CVR Summary header.Revision RegisterLog every reissue with date, version, prepared by, checked by and a brief description of changes. Provides a clear audit trail for internal review and QA sign-off.User Guide tab Step-by-step instructions covering the layout of every tab, which cells to populate, how the formulas work, and how to use the template across multiple reporting periods.Key features:- Tracks both value and cost in a single view, so the reconciliation is always visible alongside the underlying data- Period movement columns calculate automatically from cumulative and previous period figures; no manual calculation required- Forecast Final Value and Forecast Final Cost are clearly separated: value is driven by contractual position (Anticipated Final Contract Sum plus pending variations); cost is driven by budget plus cost-to-complete judgement- Gross Margin and Forecast Final Margin both calculate automatically from the figures above- Subcontractor cost on the CVR Summary is driven by the Package Breakdown tab, so the detail and the headline figure always agree- Risk and Opportunity register uses probability weighting so you can quantify the net risk or opportunity position for each period- Colour-coded throughout: yellow cells with blue text for inputs, black text for calculated values, green text for cross-sheet links- Sheet protection prevents accidental formula overwrites; no password is required to adjust column widths or make project-specific changes- Suitable for main contractor and subcontractor commercial teams on any project typeWhat you get:One Microsoft Excel file (.xlsx) compatible with Excel 2016 and later. No macros. No add-ins. No subscription.Built by a Senior QS with 20 years of live project experience.
Get it → qstoolkit.gumroad.com