Retail Shop Accounting Spreadsheets

£14.99

Easy-to-use bookkeeping spreadsheets for retail shops. This set of accounting templates including flat rate VATcash accounting VAT & non-VAT versions will simplify your bookkeeping, VAT return and year end accounts preparation.

All spreadsheets are designed using Microsoft Excel 2003, and will run on all later versions of Excel.
If you do not have Microsoft Excel, then the spreadsheets are compatible with the FREE OpenOffice software, available from www.openoffice.org

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