Beautician and Beauty Salon Accounting Spreadsheets


Easy-to-use bookkeeping spreadsheets for beautician and beauty salons. Versions available for UK & Australia businesses registered for VAT or GST as well as non-registered traders

All spreadsheets are designed using Microsoft Excel 2003, and will run on all later versions of Excel.
If you do not have Microsoft Excel, then the spreadsheets are compatible with the FREE OpenOffice software, available from

Easy-to-use bookkeeping spreadsheets for beautician or beauty salons. There are versions for non-VAT registered businesses as well as sets of VAT accounting templates including flat rate VAT & cash accounting VAT scheme, which will simplify your salon bookkeeping, VAT return and year end accounts preparation. Versions also available for Australia GST

  • Simple beautician or beauty salon accounting spreadsheets
  • Full instructions included
  • The spreadsheets are set up to record one accounting year
  • Choose the version for financial year end you need to record, for example – the 2023 version is for any financial year ending in 2023
  • No bookkeeping experience required, simply record salon sales, bankings & payments/expenses
  • If registered, the VAT/GST page will automatically calculate the salon VAT or GST due for each quarter
  • The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on your salon bookkeeping
  • Salon expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
  • Provides you with a detailed salon trading profit & loss account
  • If UK VAT registered 2 spreadsheets are included: one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme
  • ** Now available for Australia GST**


VAT data can be submitted to HMRC under the new MTD system using bridging software, such as the system available from

Pages include :

  • Salon daily takings
  • Bank & cash receipts
  • Salon expenses sheet
  • Profit & Loss account (automatically generated)
  • Quarterly VAT or GST return summary (automatically calculated)