Cafe VAT Accounting Spreadsheets – sole traders (MTD for ITSA)

       *** 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 cafe accounting spreadsheets include instructions
• 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 till sales, bankings & payments/expenses
• VAT page will automatically calculate the VAT 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 cafe bookkeeping
• Expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
• Provides you with a detailed trading profit & loss account
• 3 spreadsheets are included (UK only) : one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme and one for non-VAT registered cafe
• 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). 
• 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

Pages include :

• Daily cafe takings
• Bank & cash receipts
• Cafe expenses sheet
• Profit & Loss account (automatically generated)
• MTD for Income Tax data sheet (automatically calculated)
• Quarterly VAT return summary (automatically calculated)