Free Excel template

Free variation register template for construction contracts

Every variation on a contract in one log, from raised to decided, so the adjusted contract sum and the open exposure are always current and nothing falls between monthly claims.

Sheets Register · How to use

Get the variation register template

Enter your email and the download starts straight away.

Excel (.xlsx); also opens in Google Sheets and Numbers. We’ll email you the link, and we may get in touch about Palydin. See our privacy policy.

01What's inside

Built the way the work is done.

  • Register

    The contract position (approved variations, adjusted sum, open exposure, approval rate, days to decision) and a 200-row register.

  • How to use

    How to run the register through a variation's life, and how it feeds the progress claim.

  • Statuses from Draft through Submitted and Under assessment to Approved, Rejected or Withdrawn, each colour-coded.
  • Only approved variations change the adjusted contract sum; submitted ones show as open exposure.
  • Approved less claimed, per variation and in total, shows how far assessments move from claims.
  • Average days from submission to decision, to show how quickly variations are being dealt with.
  • Days claimed and granted per variation, with notice and instruction references.
  • An approved variation with no approved value turns red.

02How to use it

From blank to done in four steps.

  1. 1

    Start with the contract sum

    Enter the project, contract reference and original contract sum.

  2. 2

    Log variations as they arise

    Add a row the day a variation is raised, with who raised it and the instruction or notice reference.

  3. 3

    Track the decision

    Record the claimed value when submitted, then the approved value and decision date.

  4. 4

    Report and claim

    Filter by status for the monthly report, and carry approved values into the next progress claim.

03Questions

Good to know.

When the spreadsheet stops scaling.

In Palydin each variation is linked to the contract scope, its value carries into the next claim automatically, and both parties see the same register.