Australian Invoice Template & Tracker - ABN GST Tax Invoice, Paid and Overdue Tracking, Excel Spreadsheet

Send professional Australian invoices from Excel, and see at a glance who has paid you, who is overdue and how much GST you charged each BAS quarter.

What it does

Printable invoice page: headed TAX INVOICE when you are registered for GST, or INVOICE when you are not. Pick the invoice number, then print or save as PDF.

Shows the details the ATO lists for a tax invoice: your business name and ABN, the date, a description with quantity and price, the GST amount and which lines are taxable. The buyer's name is always shown (add their ABN if they want it), as needed for sales of $1,000 or more.

GST on or off, and prices typed before GST or including GST. GST is rounded the ATO way (total invoice rule).

Invoice register: due dates from your payment terms, payments received, balance, status (Paid, Part paid, Overdue, Not due) and days overdue.

Dashboard: invoiced and received this financial year, owed to you now, overdue, average days to pay, plus charts by month and by age.

Reports: GST on your invoices by BAS quarter (G1 and 1A), on an accrual or cash basis.

Client list with an ABN check-digit test, 14 built-in checks, and your bank and PayID details on every invoice.

Room for 200 invoices, 400 invoice lines and 50 clients.

How it works: 1. Setup: your business details, ABN, GST registration and bank details. 2. Clients: add each customer once. 3. Invoices and Line Items: one row per invoice, then the lines you sold. 4. Invoice: pick the number and save as PDF. Record payments as they arrive and the Dashboard does the rest.

What you get: an Excel workbook with a worked example, plus a blank copy. Instant download. Excel workbook (.xlsx). Every formula tested in LibreOffice Calc. Australian dollars, dd/mm/yyyy dates.

Built and checked by a CPA. Every formula tested against a separate calculation.

30-DAY MONEY-BACK GUARANTEE: if it doesn't work for your situation, message us within 30 days. We'll fix it, or refund you in full if you'd rather. This is in addition to your rights under the Australian Consumer Law, which are not excluded.

General information only, not tax, financial or legal advice. Check your own situation with a registered tax agent. Example names, ABNs and bank details are made up (example only, not a real ABN).

Designed by Plain Numbers Co with the help of AI tools. Listing images are designed previews of the actual file.