Used Car Dealer Advanced Accounting & VAT Spreadsheet for 2020 year ends

Used Car Dealer Advanced Accounting & VAT (margin scheme) Spreadsheet 2020

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.

• Easy-to-use bookkeeping & accounts spreadsheet includes clear step-by-step instructions
• For financial year ending in 2020
• 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
• 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
• 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

• 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
• Bank & cash receipts
• Payments & expenses
• Profit & Loss account
• VAT return summary

Watch Video Demo

Customer Reviews

"Hello Barry. My name is Chris from Conwy, N.Wales. I bought the Used Car Dealer Accounts Spreadsheet from you a few months ago. I just want you to know how fantastic & easy it is to use, even for me with limited computer skills. Also, i have just had a VAT inspection & the VAT Man thought it was brilliant & simple & was really happy with it. Consequently, i passed the inspection with flying colours! Regards, Chris"

 "Found the used car dealer spreadsheets really easy to use and the service received was excellent" Jon Langton - Langton Motor Company

"Excellent Software wish i had found it sooner. regards paul"

"FANTASTIC ITEM, BETTER THAN EXPECTED, EXACTLY WHAT I WAS LOOKING FOR, THANKS"

"Very pleased with the product, it does exactly what it says in the description"

"...the software saves hous & days!....It's enabled me to catch up on some accounts ... very quickly"

“.. i was through illness, a long way behind with my paperwork. The further i got behind..... the more depressed i became. You see i used to keep all my records up to date manually, in my own handwriting. The working out of a VAT return took hours & days, & i was months behind! However, i purchased your Accounts Spreadsheets & found were ideal for my small Business & enabled me to save on WEEKS of work in order to catch up. Im now right upto date & recently passed a VAT inspection with flying colours with no mistakes in the workings out due to the 100% accuracy of your Spreadsheets. The VAT person agreed the Spreadsheets were an excellent Accounts Package for me & he even visited your site to look at the other Spreadsheets available to other small Business. His idea was if someone was struggling with their VAT then he may recommend one of your Accounts Spreadsheets after seeing how mine worked so well & with 100% accuracy.”

Click here to see more feedback on my ebay shop

--Click here for Used Car Dealer Advanced Accounting & VAT Spreadsheet 2018 year ends

--Click here for Used Car Dealer Advanced Accounting & VAT Spreadsheet 2016 year ends

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