Small Business Income and Expense Tracker: Excel Spreadsheet Template (Example and Blank Files)

General information and planning tool only. Not financial advice, tax advice or accounting advice: it does not consider your situation. Check with the ATO or another official source, or a registered tax agent or licensed adviser, before you act.

Log sales and costs, split out GST or VAT automatically, and see monthly profit and tax totals.

What You Get

• Income and expense logs with automatic tax split
• Monthly summary of income, expenses, profit and net tax
• Expenses by category
• Example file and blank file (Excel)
• Formulas work in Microsoft Excel. You can also upload the file to Google Sheets (File > Import); please test it with your own data first

How It Works

Open the Start Here sheet, fill the yellow cells and read the summary. The example file shows how it looks with sample figures.

Please Note

Created by LifePlanLabs with AI assistance, then checked: calculations and answer keys are generated and verified by code, and every page was reviewed before sale. A parent, teacher or adviser should still read through it. Digital download only, no physical item. For personal or own-classroom/own-business use; please do not resell or share the file. Australian English.