Sole Trader GST, BAS & Expense Tracker (AU)

BAS due and a shoebox of receipts? This is a simple spreadsheet for Australian sole traders and tradies. Log your income and expenses as you go, and your GST figures are ready at the end of each quarter.

Enter each payment and purchase once. Pick the GST code and business-use %, and the sheet works out the GST in your sales, your GST credits and your business costs ex-GST. The BAS Summary shows each quarter's G1 Total sales, 1A GST on sales and 1B GST on purchases, the three GST amounts you report under Simpler BAS. It also shows net GST to pay or refund, a box for your PAYG instalment, profit, and a tax set-aside using the % you choose.

It flags GST purchases over $82.50 that need a tax invoice before you can claim the credit. A 12-week Car Logbook works out your work-use % and checks the logbook period.

Works in Microsoft Excel and the free version of Google Sheets. No macros, no subscription, no bank connection. Template only, not tax advice: check current ATO rules.