Pubs, Clubs And Bars Accounting Spreadsheets

*** NEW FOR 2027 ***
       Versions now available :
            Sole traders –  spreadsheets  include page to generate quarterly data for submitting to HMRC (using bridging                                                 software ie Vitaltax)

           Limited companies & partnerships – standard version

• 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
• Sole trader version automatically generates quarterly data for MTD ITSA submissions (using bridging software such as the Excel Add-in available from www.vitaltax.uk). 

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

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)