Home › BAS Tracker Spreadsheet (Australia)
BAS Tracker Spreadsheet (Australia)
Track GST on sales and purchases each quarter so your BAS is quick to complete.
Totals by quarter, GST collected and GST credits side by side, with due dates. See our BAS guide.
Quarterly BAS due dates (most quarterly lodgers)
| Quarter | Period | Usual due date |
|---|---|---|
| Q1 | July–September | 28 October |
| Q2 | October–December | 28 February |
| Q3 | January–March | 28 April |
| Q4 | April–June | 28 July |
Agents and online lodgers may have extra time. Check your ATO account.
Example: GST worksheet for a quarter
| Item | Example amount |
|---|---|
| Total sales incl. GST (G1) | A$13,200 |
| GST on sales (1A) = 1/11 | A$1,200 |
| GST on purchases (1B) | A$350 |
| Net GST payable | A$850 |
Example only, assuming all sales and purchases include GST. Your BAS may differ.
For GST-inclusive amounts, GST is 1/11 of the price. Full guide: BAS due 28 October.
General information only, not financial or tax advice.
How do I work out GST from a GST-inclusive price?
Divide by 11. For example, A$110 includes A$10 GST.
When is the Q1 BAS due?
Generally 28 October for quarterly lodgers, with possible extra time for agents or online lodgers.
What if I can't pay?
Lodge on time anyway and contact the ATO about a payment plan.
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.