GST & BAS Tracker Spreadsheet for Australian Sole Traders | Quarterly BAS Summary (Excel + Google Sheets)

Stop dreading BAS time. This simple spreadsheet works out your GST and gives you the figures to copy straight into your BAS each quarter.

What it does

- Log sales and purchases on one row each. GST is calculated automatically at 1/11th of GST-inclusive amounts (Australia's 10% rate).

- Quarterly BAS summary for G1, 1A and 1B (all Simpler BAS needs), plus G10/G11 for full reporting and net GST owing or refundable

- Mark GST-free sales, capital purchases and the business-use % of mixed purchases

- Set your financial year start once, and quarters (Jul–Sep, Oct–Dec, Jan–Mar, Apr–Jun) are assigned automatically

- Step-by-step instructions tab with plain-English ATO GST basics

You get: 1 .xlsx file that works in Microsoft Excel, Google Sheets and LibreOffice. Instant download, no subscription.

Made for: Australian sole traders and freelancers registered for GST who lodge BAS themselves or hand figures to a BAS agent.

General information only, not tax advice. Check ato.gov.au or ask a registered tax/BAS agent.

General information only, not tax advice. Doesn't cover PAYG instalments/withholding, FBT or fuel tax credits.

Tags: GST tracker, BAS spreadsheet, sole trader Australia, ATO, small business template, bookkeeping spreadsheet, Excel template, Google Sheets template, freelancer Australia, tax time