Australian Sole Trader Income, Expense & GST Tracker (Excel)

Track your income and expenses, see your profit every month, and add up your figures for a simple quarterly BAS. Designed for Australian sole traders who want clear records without accounting software.

What's inside:

• Settings: business name, ABN, financial year, GST on or off, set-aside %

• Income: every payment received, with GST worked out

• Expenses: categories, business-use %, GST credits and tax invoice checks

• Monthly Summary: income, expenses, profit and GST for each month

• Simple BAS worksheet: G1, 1A, 1B and net GST for each quarter (Simpler BAS)

• Tax Set-Aside: a monthly savings guide so tax time isn't a shock

Key features:

• Flags purchases over $82.50 that need a tax invoice to claim GST

• Business-use % for mixed personal and business expenses

• GST switch: works whether or not you're registered for GST

• Formula cells locked so they can't be typed over by accident

• Blank copy for your records, plus an example copy filled in so you can see how it works

Is it right for you? It's built for cash-basis record keeping, quarterly GST reporting using Simpler BAS, and businesses with no employees. It doesn't cover accruals accounting, PAYG withholding or payroll, fuel tax credits, GST adjustments or depreciation.

Format: ZIP with 2 Microsoft Excel files (blank + example). Built for Excel 2016 or later, including Microsoft 365.

This is a record-keeping tool, not tax or accounting advice. TechNexum is not a registered tax or BAS agent. Check your figures before lodging and talk to a registered tax or BAS agent about your situation.

Questions: technexum@melbournetechhelp.com.au