Pubs, Clubs And Bars Accounting Spreadsheets


Easy-to-use bookkeeping spreadsheets for pubs, clubs & bars. This set of pub accounting templates including flat rate VAT & cash accounting VAT will simplify your pub bookkeeping, VAT return and year end pub accounts preparation. Versions available for Republic of Ireland and 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 (Versions available for the UK, Republic of Ireland and Australia)
  • 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 VAT  or 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
  • 2 spreadsheets are included (UK Version): one designed for the special flat-rate retail VAT scheme and one for the standard retail cash VAT scheme

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

Updated to record temporary hospitality reduced VAT rated income

Pages include :

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