CVR
The monthly answer to whether the job is making what you think it is making.
One sheet a month that puts the value of the work done next to the cost of getting there, and explains every movement in the margin. Value comes from the account's real position rather than what is certified, cost from the ledger plus the accruals it has not seen yet, and every movement gets its reason in one line.
What you get
How it works
Value from the account, not the certificate
The value side builds from the contract sum, variations split by status, the remeasure adjustment and loss and expense: what the work done is actually worth. Certified value is the other side's opinion of that number, and reading value from certificates is how agreed variations and supportable claims go missing.
Cost the ledger has not seen yet
The cost side covers labour, plant, materials, subcontractors and preliminaries, then the two lines that keep a CVR honest: accruals for goods and work received but not invoiced, and provisions for known risks. Without them the job looks profitable right up to the month the invoices land.
The movement, explained
Margin, margin percentage and the movement on last period calculate themselves, with the cash position alongside, and the sheet holds one line for the main reason the margin moved. A CVR that cannot explain its movement is a spreadsheet, not a reconciliation.
An Excel template with no macros. Only the yellow cells can be edited, the Guide tab explains every step, and it prints on A4. Your contract's terms come first.
Related paid help
For the CVR produced and kept honest month after month, see the CVR Production & Maintenance service.