Tradie Subbie Register + Payments & TPAR Tracker (AU) – Excel & Google Sheets

Keep every subbie's ABN, address, insurance and licence expiry dates in one list. Log what you pay them, and get a whole-dollar TPAR summary for the financial year, ready to copy into the ATO form or hand to your BAS agent. Offline, no subscription.

If your trade business pays subcontractors, the ATO may require a Taxable payments annual report (TPAR) by 28 August each year. It needs each subbie's ABN, name, address, gross amount paid, GST and any tax withheld. This spreadsheet keeps those records as you go, so they're ready at tax time. It also warns you when a subbie's insurance or licence has expired or is about to.

What's inside

• Subbie register (200 subbies):

• ABN, GST registered, contact details, address, trade, licence number and expiry, public liability insurer and expiry, workers comp / personal accident expiry, signed subcontract on file, Active/Inactive

• ABN check that tests the 11-digit format and check digits and catches typos. It doesn't check the ABN online, so use ABN Lookup for that.

• Compliance status: OK / Expires soon / EXPIRED / MISSING INSURANCE, plus an ACTION column

• Payments log (1,000 payments):

• Date paid, invoice number, job, amount incl. GST and tax withheld (no ABN)

• GST is worked out as 1/11 if the subbie is GST registered, or you can set it per invoice

• Mark payments as not reportable, e.g. materials only

• TPAR Summary: every subbie with reportable payments in the financial year. Shows ABN, name, address, gross paid, GST and tax withheld in whole dollars (cents dropped, as the ATO asks), with totals.

• Dashboard:

• TPAR-year totals, the due date and days to go

• Reportable payments by month

• Counts of expired, missing and expiring insurance and of ABN problems

• A to-do list

• Start Here guide, plus an EXAMPLE file and a BLANK file. Change the TPAR year on Settings to see any financial year.

Works with: Microsoft Excel and Google Sheets (import). No macros, no subscription, and it works offline. Yellow cells are for typing; grey formula cells are locked, with no password.

Please note

• This is a record-keeping tool only. It is not tax, legal or insurance advice, and it does not lodge anything with the ATO.

• Whether you need to lodge a TPAR, and which payments count, depends on your business. Check ato.gov.au or ask your registered tax or BAS agent.

• Tested in LibreOffice and built only with functions that Excel and Google Sheets both support. It has not been tested in desktop Excel itself.

Licence: for use in your own business. Please don't resell or share the file.

FAQ

• Does it lodge my TPAR? No. It gives you the figures to type into the ATO's online form, or to hand to your BAS agent.

• Does it check ABNs with the ABR? No. It checks the format and check digits only. Use ABN Lookup to confirm an ABN is active.

• I'm not registered for GST. Does it still work? Yes. GST is based on whether the SUBBIE is GST registered, not you.

• Is it a subscription? No. It's a one-off purchase and an instant download.