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
Start with the contract sum
Enter the project, contract reference and original contract sum.
- 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
Track the decision
Record the claimed value when submitted, then the approved value and decision date.
- 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.
More free templates
- Progress claim templateA month-end progress claim: schedule of values, cumulative % complete, variations, retention, GST and the total payable, with the Security of Payment endorsement for your state.Get the template
- Payment schedule templateThe assessor's reply to a payment claim: claimed against scheduled amount line by line, a reason wherever they differ, retention, GST and the scheduled amount.Get the template
- Risk register templateA 5×5 risk and opportunity register: likelihood and consequence scoring, bands, expected value, owners, treatments and a live heat map.Get the template
- EOT and delay notice registerDelay notices and extension of time claims per separable portion: notice dates, days claimed, days granted and each portion's adjusted completion date.Get the template
- Retention tracker templateRetention held claim by claim against the cap, releases at practical completion and the end of the defects liability period, and the balance still held.Get the template
- Cost report templateMonthly cost control by cost code: budget, approved changes, committed and actual cost, forecast to complete, forecast final cost and variance.Get the template