Home › GST Tracker Spreadsheet (Australia)
GST Tracker Spreadsheet (Australia)
Record GST collected and GST paid on every transaction, then total it for your BAS.
Keep tax invoices for anything you claim GST credits on, and only claim the business portion of mixed-use purchases.
GST in one minute
- GST is 10% added to most goods and services.
- In a GST-inclusive price, GST is 1/11.
- You must register once turnover reaches the GST threshold; below it, registration is optional.
- Some items are GST-free (for example most basic food) or input-taxed.
Example calculations
| Price | Type | GST |
|---|---|---|
| A$110 | GST-inclusive | A$110 ÷ 11 = A$10 |
| A$100 | GST-exclusive | A$100 × 10% = A$10, total A$110 |
| A$55 | GST-inclusive | A$5 |
Worked examples of the standard 10% rate.
Columns your tracker should have
| Column | Example |
|---|---|
| Date | 5 Oct |
| Supplier / customer | Officeworks |
| Total incl. GST | A$66 |
| GST | A$6 |
| Tax invoice held? | Yes |
| Business % | 100% |
Only claim credits with a valid tax invoice and only for the business portion.
General information only, not financial or tax advice.
How do I calculate GST from a total?
For GST-inclusive totals, divide by 11.
Do I have to register for GST?
You must register once your turnover reaches the GST threshold. Check ato.gov.au for the current threshold.
Can I claim GST on everything?
Only on business purchases that include GST, with a valid tax invoice, and only the business portion.
Related
Australian Tax Time Bundle · Sole Trader Income & Expense Spreadsheet · Sole Trader Tax & BAS Dashboard
Try it in an app
Side Hustle Income & Tax Tracker (AU) (A$29, one-off): Track side-hustle income and expenses by Australian financial year, set money aside for tax, and watch the GST turnover threshold.