Convenience Store 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 convenience store 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
• Allows for National Lottery & payment agent income details to be entered
• 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 convenience store bookkeeping
• Expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
• Provides you with a detailed trading profit & loss account
• 4 spreadsheets are included : one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme, another for the retail apportionment 1 method VAT scheme and one for non-VAT registered convenience stores
• 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 convenience store takings
• Bank & cash receipts
• Convenience store expenses sheet
• Profit & Loss account (automatically generated)
• Quarterly VAT return summary (automatically calculated)