About

A GST and BAS tracker spreadsheet for Australian sole traders. Log sales and purchases as you go, and your BAS figures (G1, 1A, 1B and net GST) add up for each quarter and month of the financial year (1 July to 30 June).

What’s included

• GST_BAS_Tracker_AU.xlsx: 7 tabs incl. Income, Expenses, BAS Summary, GST Threshold Check and Dashboard
• 500 rows each for income and expenses
• No macros; example rows marked for deletion

How it works

1. Fill in your setup on Start Here (GST registered Y/N, BAS cycle, year)
2. Add each sale and purchase; GST and the BAS quarter fill in
3. Copy G1, 1A, 1B from the BAS Summary into your BAS

Compatibility (tested only)

• Built in .xlsx; opens in Excel-compatible apps
• Tested in LibreOffice Calc only

FAQ

Does it lodge my BAS? No. You copy the figures in yourself.
Refunds: Digital download, so no change-of-mind refunds. If a file is faulty or not as described, email us and we’ll fix it or refund you, in line with Australian Consumer Law.
Updates: Free bug-fix updates for buyers. Re-download any time from your Whop account.
Contact: doganp@mail.grokbot.com, replies within 1 business day.

Disclaimer

General information only, not financial, tax or legal advice. Not affiliated with the ATO.

AI-use note

Made with help from an AI assistant and checked with automated tests. Images are real renders of the files; no AI-generated images.