Retail Shop Accounting Spreadsheets

• Simple shop 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 shop 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 shop retailers.

• 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 till takings
• Bank & cash receipts
• Payments & expenses sheet
• Profit & Loss account (automatically generated)
• Quarterly VAT return summary (automatically calculated)