Used Car Dealer Accounting Spreadsheets

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

     *** 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

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

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 :

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