Free Excel template

Free payment schedule template for assessing progress claims

For head contractors, principals and superintendents answering a payment claim: assess each line, give a reason wherever you schedule less, and see the statutory deadline for your state before it passes.

Sheets Schedule · Holidays · How to use

Get the payment schedule 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.

  • Schedule

    Schedule details, the statutory deadline, the summary from scheduled value to the amount you'll pay, the endorsement and a 100-line assessment.

  • Holidays

    Public holidays and other non-business days, so business-day deadlines are counted correctly.

  • How to use

    Instructions, and what makes a reason for withholding hold up.

  • Assess each line by % to date; the sheet works out what was claimed and scheduled this period and the difference.
  • Every line scheduled below the claim is flagged until it has a reason, and the summary counts the missing ones.
  • The statutory deadline is counted from the date the claim was received, in business days where the Act counts them.
  • Retention and GST follow the same cumulative method as the claim, so both sides' numbers reconcile.
  • The payment schedule endorsement for your state, and a statement that reasons are given where you pay less.
  • A schedule dated after the deadline is flagged as late.

02How to use it

From blank to done in four steps.

  1. 1

    Log the claim

    Enter the claim number, the amount claimed, the date you received it and the state. The deadline appears straight away.

  2. 2

    Assess each line

    Enter the claimed and previously certified values from the claim, then your assessed % to date.

  3. 3

    Give your reasons

    Write a specific reason against every line you schedule differently. The Check column clears as you go.

  4. 4

    Issue on time

    Check the scheduled amount and issue the schedule before the deadline, keeping proof of when and how it was served.

03Questions

Good to know.

When the spreadsheet stops scaling.

In Palydin the assessor works directly on the submitted claim, every cut keeps its reason, and the SOPA clock is counted for the contract's state.