Used Car Dealer Accounting Spreadsheets


Simplify your dealership bookkeeping, margin scheme VAT return and  year end accounts preparation. For dealers with additional sales income streams. Easy Dealer accounting software for less than the price of a tank of fuel!
Maintain your accounting records digitally, as required by HMRC’s new MTD rules for VAT-registered businesses.
Versions available for the UK and Republic of Ireland

** New version available for Australian GST**

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

Easy-to-use bookkeeping & VAT spreadsheet for used car dealers. This dealer accounts template will simplify your dealership bookkeeping, VAT return and year end accounts preparation. ** New version available for Australian GST**

  • Easy-to-use bookkeeping & accounts spreadsheet includes clear step-by-step instructions
  • Choose your financial year end date (financial year end date can be changed to any date in the chosen spreadsheet)
  • Designed for used car dealers using the VAT margin scheme
  • For car dealers with other sources of income – vehicle repairs, vehicle hire etc
  • Includes a sales & purchase invoice generator
  • Includes a stock book page as required by HMR&C (UK Version)
  • Can be easily adjusted for any future changes in VAT rates!
  • No bookkeeping experience required
  • Calculates the VAT due for each car sale, either for vehicles eligible for the margin scheme, or those where VAT must be accounted for using the normal VAT rules
  • VAT page will automatically calculate the VAT due for each quarter (month & bi-monthly for Republic Of Ireland version)
  • 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
  • Provides you with a guide to your trading profit
  • Two spreadsheets included in the UK & Australia versions to cater for additional revenue streams if needed.


VAT data can be submitted to HMRC under the new MTD system using bridging software, such as the system available from

Pages include :

  • Stock book & margin calculator
  • Sales & purchase invoice generators
  • Quarterly sales list (Monthly for the ROI Version)
  • Bank & cash receipts
  • Payments & expenses
  • Profit & Loss account
  • VAT return summary

** New version available for Australian GST**