Variations are easiest to recover when they are recorded while the information is fresh. The longer a change sits only in an email chain, site instruction or somebody’s notebook, the harder it becomes to price and agree later.
Start the variation log when the change is identified
Do not wait for a final quotation. Give the change a reference as soon as it is recognised and record the source of the instruction, a short description and the current status.
What should a variation tracker contain?
A useful register normally needs the variation number, date, client reference, description, estimated or actual cost, quoted sell value, margin, approval status, approval date and notes. If the change affects programme, record the expected time impact too.
Separate cost from sell value
Knowing the contractor cost is not the same as knowing the value submitted to the client. Keeping the two fields separate makes margin visible and reduces the chance of pricing only labour while forgetting materials, subcontractors, plant or supervision.
Use clear statuses
For example: Pending, Pricing, Quoted, Approved, Rejected, Invoiced and Paid. The exact wording can vary, but the objective is to see instantly where every change sits commercially.
Review the register every week
A weekly review prevents a long tail of unpriced work. Focus first on instructed work with no quotation, quotations with no response, and approved changes that have not reached the next valuation or invoice.
Keep evidence alongside the reference
The spreadsheet does not need to hold every photo and email. It should tell you where the evidence is. Use the same variation reference in the document folder, email subject or site-photo naming convention where possible.
Make the quote repeatable
A consistent quote format improves speed. Build up quantity, unit cost, markup and sell value, then record the final quoted figure back in the variation register. That creates a clean link between the working calculation and the commercial log.
The ProjectDesk Pro Contractor Quote & Variation Pack combines an editable quote builder with a variation/change-control register in Excel.
Start with the free Project Control Starter Pack
Want to try the ProjectDesk Pro approach before buying? Download the Free Project Control Starter Pack with a dashboard, action tracker, variation register and two-week lookahead in one editable Excel workbook.