Free Excel template

Free retention tracker template for construction contracts

See how much retention is held on a contract, when the cap is reached, and when each release falls due, from practical completion to the end of the defects liability period.

Sheets Retention · Releases · How to use

Get the retention tracker 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.

  • 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. 1

    Enter the contract terms

    Contract sum, retention rate and cap, the form of security and the share released at practical completion.

  2. 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. 3

    Set the milestones

    Enter the date of practical completion and the defects liability period in months.

  4. 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.