Check with your accountant. This template helps you organise your own figures. It is general information, not tax or accounting advice. Have your accountant or registered tax agent check your figures before you lodge or submit anything to a tax office or any other authority.
The problem. The ATO expects every business record to show a date, an amount, a description and the GST. Accounting software does that, and a great deal more than one person needs.
What this does. You keep one list of income and one list of expenses in Excel. Each line gets a GST treatment from a short dropdown. The workbook adds up G1 total sales, 1A GST on sales and 1B GST on purchases for each quarter of a July to June year, and shows your profit or loss by month.
What you can do with it
- Record each amount you receive or pay once, with its date, description and GST treatment.
- Read G1, 1A, 1B and 1A minus 1B for each quarter, with cents and in whole dollars.
- See profit or loss by month, by your own expense categories, without GST.
- See income, expenses and profit for the year so far, and the GST position for the current quarter, on one dashboard.
- Spot lines with something missing: a Check column flags a missing date, GST treatment, category or tax invoice.
- Run a ten-point checklist at the end of each quarter and print the BAS Summary for your accountant.
How it works
- Enter your business name and the year your financial year starts. Change the expense categories to suit you.
- Add a line for each amount received and each business cost paid, as they happen.
- At the end of the quarter, read the BAS Summary and have your accountant check it before you lodge.
Who it is for. Sole traders in Australia who are registered for GST, report it quarterly, and want a spreadsheet instead of accounting software.
Who it is not for. Businesses with employees or stock systems, anyone who wants bank feeds, invoicing or automatic lodgement, and anyone not registered for GST in Australia.
What it does not cover
- PAYG withholding and PAYG instalments, which appear on the same BAS form.
- Fuel tax credits, wine equalisation tax and luxury car tax.
- BAS labels other than G1, 1A and 1B (for example G2, G3, G10 and G11, which the full reporting method asks for).
- Refunds, credit notes, bad debts and other adjustments to an earlier BAS.
- Splitting a cost between business and private use. Enter only the business part.
- Choosing between the cash and non-cash basis, GST instalments, and annual GST reporting.
- Your income tax return, depreciation, wages and super.
It does not choose a GST treatment for you, and it does not lodge anything. 1A minus 1B is a working figure: your BAS may include other amounts.
What you need. Microsoft Excel 2016 or later. No macros, no add-ins, no subscription and no AI.
Good to know
- Amounts are entered as actually paid or received, including any GST. GST is worked out as one-eleventh of an amount marked GST included. Where an invoice shows a different GST amount (phone, insurance, council bills), you type it.
- You enter the date that applies to your accounting basis (cash or non-cash). Confirm your basis with your accountant.
- The expense categories are a starting list for you to edit. They are not the labels of any tax return.
- 1,000 income rows and 1,000 expense rows are ready, and you can extend either sheet by dragging the last row down.
- One workbook covers one July to June financial year. Use a fresh copy each year.
- Nothing is locked or password protected.
- GST rules are current as at 14 November 2026. The ATO pages each rule came from are listed inside the workbook and the guide.
- General information only. It is not accounting, tax, legal or financial advice.