Pubs, Clubs And Bars Accounting Spreadsheets (Australia)


Easy-to-use bookkeeping spreadsheets for pubs, clubs & bars in Australia.

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

  • Simple pub accounting spreadsheets include instructions
  • Choose your financial year end date (financial year end date can be changed to any date in the chosen spreadsheet)
  • NO bookkeeping experience required, simply record till sales, bankings & payments/expenses
  • VAT or GST page will automatically calculate the GST due
  • The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on your pub, club & bar bookkeeping
  • Pub expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
  • Provides you with a detailed pub trading profit & loss account

Pages include :

  • Daily pub takings
  • Bank & cash receipts
  • Pub expenses sheet
  • Profit & Loss account (automatically generated)
  • GST return summary (automatically calculated)