Salon bookkeeping spreadsheet: what records to keep

The ATO says you are legally required to keep records of all transactions relating to your tax, super and registration affairs. Each record should show at least the date, the amount and a description such as a sale, purchase, wages or rent, plus the GST information. Keep most records for 5 years, and be able to show them if the ATO asks. A simple spreadsheet with one tab for sales, one for expenses, one for wages and one for stock can hold all of that, as long as you also keep the receipts and bank records behind it.

Facts checked . Prices change; the sources are listed at the end.

Preen is booking, client and payment software for hair, beauty and wellness businesses in Australia. What Preen does.

What must each business record show?

The ATO says a record explains the tax and super-related transactions of the business, with enough information to understand what happened and why. At a minimum a record generally shows:

  • the date, the amount and a description, such as sale, purchase, wages or rental, plus the relevant GST information,
  • the purpose of the transaction, and
  • the relationship between the parties, if relevant.

The ATO’s five record-keeping rules are: keep all the records for starting, running, changing, selling or closing your business that are relevant to your tax and super; where an expense is part business and part personal, keep clear documents showing the business share; don’t change the information in a record and store it so it is protected; be able to reconstruct your original data if your system changes; and keep most records for 5 years. Records must be in English or easy to convert to English.

What does a simple spreadsheet layout look like?

This layout is ours. Each column traces back to the minimum details above. Anything in brackets is for you to fill in or delete.

A simple bookkeeping spreadsheet layout for a hair, beauty or wellness business
TabColumnsWhy
SalesDate, client or invoice number [if you use one], service or product, amount, GST [if you are registered for GST], how it was paid, date it reached your bank.The ATO's examples of income records include tax invoices, receipts, EFTPOS and online payment records, bank statements and cash sales records.
ExpensesDate, paid to, what it was for, amount, GST [if you are registered for GST], business share % [if part private], receipt saved (yes or no), how it was paid.The ATO says deductions need records, and records must show how you worked out the business portion of mixed-use expenses.
Bank checkMonth, balance on your bank statement, balance on your sheet, difference and why.The ATO says to reconcile your banking records regularly and bank cash sales income regularly.
Wages and super [if you employ people]Pay date, employee, gross pay, tax withheld, super paid and date, tips paid out and tips kept by the business.The ATO lists wages, allowances, super contributions, tax file number declarations and Single Touch Payroll reports as employee records, and asks that tips be recorded as above.
Stock [if you sell products]Stocktake date, who did it, each product on hand and its value, and how you valued it.The ATO says a stocktake record needs a list of each article on hand and its value, who did it, how and when, and who valued it and on what basis.
AssetsDate bought, description, cost, business share %.The ATO says to keep records of buying, maintaining, repairing and selling business assets.

Keep the documents behind each line: tax invoices, receipts, bank and card statements, and merchant facility statements. If you take cash, the ATO says cash register tapes can be thrown out after one month only if you keep Z-totals that you have reconciled with actual sales and the amount banked; otherwise keep the full rolls for five years.

Which other guides cover the records this feeds?

If you are registered for GST, your sales and expenses tabs feed your activity statement; see our BAS guide for sole traders and the guide to tax invoices for clients. For products you sell, see GST and stock on retail products. For equipment you buy, see the instant asset write-off. For what employees must get with each pay, see the payslip requirements guide.

Where does Preen fit?

Checkout and receipts are included from the Solo plan, and so are waitlist and reports. Your tax records are still yours to keep in the form the ATO describes. Your accountant or the ATO can tell you what you need for your own business.

Questions people ask

What records does a salon or studio have to keep?

The ATO says records of all transactions relating to your tax, super and registration affairs, including documents about your business's income and expenses, and about any election, choice, estimate or calculation you make for your tax and super.

How long do I keep business records?

The ATO says most records for 5 years, generally starting from when you prepared or obtained the record or completed the transaction, whichever is later. Some records must be kept longer, for example to cover the period of review for an assessment that uses information from the record. The ATO also notes that ASIC requires companies to keep records for 7 years.

Can I keep my records in a spreadsheet?

The ATO does not say a spreadsheet is required or ruled out. It says records can be paper or electronic, must not be changed, must be stored so they are protected from being changed or damaged, and that you must be able to reconstruct the original data if your system changes and extract it in a standard format such as Excel or CSV if asked.

How do I record tips?

The ATO says that for employees' tips and gratuities you need to show what amounts have been paid to your employees and what you retain, and recommends a written policy covering how you collect and record tips, how and how often you distribute them, and how you resolve disputes.

Do I need a separate business bank account?

The ATO says a partnership, company or trust must have one. A sole trader doesn't have to, but the ATO says it is better, so you can separate business transactions from personal ones.

Sources

General information, not tax, legal or financial advice. The spreadsheet layout is our own suggestion, built on the minimum record details the ATO describes; it is not an ATO form. Several of the ATO pages cited are dated 2019 to 2022, so check the ATO for anything that has changed, and ask your registered tax or BAS agent about your own records. Checked 28 October 2026.

No booking commission, one price per location.

Preen is booking, client and payment software for hair, beauty and wellness businesses in Australia. Clients book online, and you keep your calendar and client list in one place.

From Solo, card payments go through your own Stripe account. Stripe's fees apply. See stripe.com/au/pricing.