01What's inside
Built the way the work is done.
Retention
Contract terms, the retention position (held, released, balance, releases due) and a claim-by-claim log.
Releases
Every release, with its date, type, amount and reference.
How to use
Instructions, and what to diarise so retention isn't forgotten.
- Retention worked out from each claim's certified value, capped at a % of the contract sum.
- This claim's deduction is the movement from the last, and 'Cap reached' shows when deductions stop.
- The end of the defects liability period calculated from practical completion and the DLP in months.
- Release amounts due at practical completion and at the end of the DLP.
- A next step that says what's due: the practical completion release, the final release, or nothing yet.
- Works for cash retention, bank guarantees and insurance bonds.
02How to use it
From blank to done in four steps.
- 1
Enter the contract terms
Contract sum, retention rate and cap, the form of security and the share released at practical completion.
- 2
Log each certified claim
Add the gross value certified to date each month; retention to date and this claim's deduction fill in.
- 3
Set the milestones
Enter the date of practical completion and the defects liability period in months.
- 4
Record releases
Log each release as it's paid or returned. The balance and next step update.
03Questions
Good to know.
When the spreadsheet stops scaling.
Palydin works out retention held, released and available for every contract from its claims, and flags releases as they fall due for both parties.
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
- Variation register templateEvery variation on the contract in one log: status, claimed and approved values, time impact and the adjusted contract sum.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
- 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