Monthly project P&L tracking earned value vs cost vs forecast final margin. Generic structure for main contractors and subcontractors. 11 sheets, 317 formulas, fully populated sample project showing how a £4.5m job tracks across 12 months.
Cost Value Reconciliation is the monthly process of reconciling what a project HAS earned against what it HAS COST, and what it WILL EARN against what it WILL COST. The output is the project's actual margin position. Done well, CVR gives early warning of margin erosion, identifies under-recovered costs, flags over-claims that need unwinding, and forms the basis of the monthly board pack. Done badly, it lets margin slip month after month until the project closes out at a loss.
This toolkit gives you a working CVR structure that handles a full 12-month project cycle. Track contract sum movements (variations, dayworks, fluctuations) through to Adjusted Contract Sum. Compare applied value against certified value with delta tracking. Capture cost across ten standard categories. Forecast Final Value, Final Cost, and Final Margin with built-in risk allowances. Reconcile to a monthly margin position. The 12-Month Rolling tab shows the trend visually.
The structure works for both main contractor and subcontractor commercial roles — adjust the cost categories, sub-package list, and reporting period to match your project.
