DocsClaimsClaim spreadsheet

Claim spreadsheet

Getting a served payment claim as an Excel spreadsheet, for head contractors who ask for claims in Excel, sending it with the claim, and sending it afterwards.

  • Reviewed 24 Sep 2026
  • 3 min read
  • Claims

Some head contractors ask for payment claims in Excel. Every claim the platform prints is also printed as a claim spreadsheet (.xlsx), at the same moment as its PDF.

What is in it

The same claim as the PDF, laid out as a table you can sort and sum:

  • A header with the claimant, the respondent, the contract, the date and the period.
  • A heading for each of your contract's item groups, in the order you set them up, so a contract set up by level (Level 1, Level 2, rough-in, fit-off) comes out by level, with each line beneath it.
  • For each line: contract value, previously claimed, this claim and claimed to date, each with its percentage beside it (% previously, % this claim, % to date), then retention and the net amount. Every line is listed, including ones this claim does not touch, as on the PDF.
  • A Qty column when any item on the claim has a quantity. It is blank on lump sums.
  • Variations, any retention release and one-off charges, then the claim total, GST and retention.

On a claim with a deduction, a Before deductions column sits left of the contract value. Under each item a deduction comes off, it shows the item's value before deductions and each deduction taken off it, and a = Value after deductions row carries the item's value and claim figures. Each deduction also has a row of its own, marked Incl. above because it is already taken off the items. Only the contract value column adds up to the total, so a sum of it never counts a deduction twice. If your contract has a discount, its Contract price rows restate a discount already inside the item values, so leave them out of a sum.

The PDF is still the payment claim. The spreadsheet sets out the same claim, and says so.

Sending it with the claim

On a contract served by email, tick Also attach an Excel spreadsheet next to Serve this claim now, on the page Review and serve opens. The spreadsheet goes in the same email, straight after the claim PDF.

If a head contractor always wants it, set Attach a spreadsheet when serving? to Yes, by default in the contract's details. The box then starts ticked on every claim on that contract, and you can still untick it on any one of them. Claims served from the month-end claim run follow the contract's setting.

Sending it afterwards

If the head contractor asks for the spreadsheet after you have served the claim, open the claim and choose Send to head contractor beside Claim spreadsheet. Before anything is sent you are shown who it goes to:

  • A claim served by email goes to the same people it was served on.
  • A claim served by post, delivery or lodgment goes to the contract's current contacts, addressed the way a claim email would be.

The email is titled Spreadsheet copy and says it is a copy of the claim you already served, not a new payment claim. Only the spreadsheet is attached. Whether it arrived is shown beside the spreadsheet on the claim. If it bounces you are not sent a delivery-failure alert, because the claim itself was delivered, so check there.

It can be sent once the claim has been served, not while it is waiting for manual service. If the claim email itself failed or bounced, re-send the claim first; the spreadsheet can be sent once the claim has gone through. A claim served before the spreadsheet existed has no stored spreadsheet, so it cannot be sent this way. Download it and send it yourself.

Downloading it

Open the claim. Under its documents, Claim spreadsheet has a download link once the claim has been submitted or prepared for manual service.

A claim served before the spreadsheet existed has one too, built when you download it from the claim's current figures. It says so at the top: if the contract has changed since the claim was served, the served PDF is the one that counts.

Was this page useful?Something wrong? Contact support