Aussie Small Business Bookkeeping Spreadsheet: GST, BAS Figures, Km Log (Excel and Google Sheets)

An Australian bookkeeping spreadsheet. Log each bit of business money in or out and the spreadsheet does the rest.

• GST worked out on every line, at one eleventh
• Simpler BAS figures (G1, 1A and 1B, cash basis) for each quarter, with the ATO due date
• Month, quarter, financial year and 5-year dashboards, with profit goals
• Car km log using the ATO cents per km method, with the 5,000 km cap
• Tax savings tracker and a $75,000 GST threshold check
• Red warnings when a date, amount or category doesn't add up

Includes: a blank file for your business, an EXAMPLE file to explore, and the 14-page Toolkit Guide (PDF), including how to stay safe with AI.

Works in: Excel 2016 or newer (Windows and Mac) and Google Sheets (free).

Please note:

• This is a record-keeping tool, not tax, legal or financial advice. Rules and rates change, so check ato.gov.au or ask your accountant or BAS agent before you lodge anything.
• The BAS figures use the cash basis and cover G1, 1A and 1B only. They don't cover wages (W1, W2), PAYG instalments or the accruals basis.
• This is a digital download. Nothing is posted.

Refunds: Because these are digital files, we don't offer refunds if you simply change your mind. This doesn't affect your rights under the Australian Consumer Law. If a file is faulty, doesn't match its description, or doesn't work as described in Excel 2016 or newer or Google Sheets, contact us through regulationcollective.com. If there's a major problem, you can choose a replacement or a refund. For a minor problem, we'll fix it quickly.