• These spreadsheets are to be used for your financial year ending in 2024

  • Easy-to-use bookkeeping spreadsheet includes instructions

 

  • Made specifically for newsagents or convenience stores

 

  • Shop takings page allows for National Lottery & payment agent income details to be entered 

 

  •  Can be easily adjusted for any future changes in VAT rates

 

  • No bookkeeping experience required, simply record shop takings, bankings & payments

 

  • VAT page will automatically calculate the VAT due for each quarter
  • VAT data can be submitted to HMRC under the new MTD system using bridging software, such as the Excel Add-in available from www.vitaltax.uk

 

  • The layout, formulas & also the 'predictive text' feature of Excel will help reduce the time you need to spend on record-keeping

 

  • Drop-down menus makes categorising expenses very quick & straightforward

 

  • Why spend £20 on a 'big red cash book' & then spend hours adding up all the columns (usually at least twice)

  

  • Ideal format to e-mail to your accountant - good bookkeeping should help reduce accountancy fees!!

 

  • Provides you with a cumulative detailed trading profit & loss account

 

  • Includes the following pages
                    Shop takings

Bank & cash receipts

Expenses & payments

Profit & Loss account

VAT returns

 

  • Designed using Microsoft Office Excel 2003

 

 

  • 4 versions of the bookkeeping spreadsheets are included on the disc
    1. Non-VAT registered traders
    2. Flat-rate VAT scheme 
    3. Cash, retail POS VAT scheme
    4. Cash, retail apportionment 1 method VAT scheme version

  • Please provide an email address if you would like the spreadsheets emailing