Sole Trader Spreadsheet Australia – Income, Expense & GST Tracker
A sole trader spreadsheet for Australia that tracks income and expenses, splits out GST at 1/11 and applies business-use % for mixed costs like phone and car. Monthly profit and GST summaries follow the July–June financial year, ready to hand to your accountant or BAS agent. Works in Excel, Google Sheets and LibreOffice. A$19.
A simple Excel / Google Sheets tracker for Australian sole traders who want clean records without accounting software. Log what came in and what went out, and the workbook splits out the GST component, applies business-use percentages, and builds your monthly summary for the Australian financial year (July to June). Handy to give your accountant or BAS agent at quarter-end.
• Income and expense logs with dropdowns, pre-built to 500 rows
• GST / GST-free toggle per line (1/11 calculation; switches off if you're not GST-registered)
• Business-use % for mixed expenses (phone, car)
• FY month mapping with an editable FY start date
• Monthly summary of income, expenses, net profit, GST collected and paid, plus a chart
• Totals by editable expense category
• Instructions sheet and sample data; works in Excel, Google Sheets and LibreOffice
Not tax advice. Check figures with a registered tax/BAS agent or the ATO before lodging.
Contact: workassist.andrei@proton.me
Templates built with AI assistance and checked by hand. General record-keeping tools, not tax, financial or BAS advice.