Free Excel template

Free progress claim template for end-of-month claims

A month-end progress claim in Excel, built the way Australian claims actually work: cumulative, rebuilt each month on what was certified last month, with retention, GST and the Security of Payment endorsement for your state.

Sheets Claim · Variations · How to use

Get the progress claim 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.

  • Claim

    Claim details, the claim summary from gross value to amount claimed, the SOPA endorsement and a 100-line schedule of values.

  • Variations

    Approved, pending and disputed variations, each claimed by % complete like the contract works.

  • How to use

    Step-by-step instructions and the checks to make before you serve the claim.

  • Each line claims its % complete to date, measured from last month's certified %, so a cut is never claimed twice.
  • Retention is worked out to date and capped at a % of the original contract sum, so this month's deduction is always right.
  • Approved variations adjust the contract sum; pending and disputed ones are claimed without changing it.
  • GST is added on the net amount claimed, and every amount is rounded to the cent line by line.
  • Pick NSW, VIC, QLD, WA, SA, TAS, ACT or NT to print the matching Security of Payment endorsement.
  • A line claimed below last month's certified % turns amber, so typos are caught before the claim goes out.

02How to use it

From blank to done in four steps.

  1. 1

    Set up the claim

    Enter the claimant, respondent, project, reference date and state, and check the retention rate and cap against your contract.

  2. 2

    Build the schedule of values

    One line per item with its contract value, copied from the contract's schedule of rates or trade breakdown.

  3. 3

    Claim this month's progress

    For each line, enter last month's certified % and this month's % complete to date. Add variations on their own sheet.

  4. 4

    Check and serve

    The summary works out gross value, retention, what was previously certified, GST and the amount claimed. Attach your evidence and serve the claim.

03Questions

Good to know.

When the spreadsheet stops scaling.

Palydin drafts each claim from the live contract, carries the last certified position forward, and gives the assessor the same record to work on.