Pubs, Clubs And Bars Accounting Spreadsheets

• 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 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)