Car Dealer Accounting & MTD: Connect Your DMS to Xero, QuickBooks, Sage

Most car dealers I speak to are running two ledgers at the same time and do not even realise it.

The dealer management system knows what was sold, who paid the deposit, what is still owed, and which deals are sitting on finance. The accounting package knows what was banked. Somewhere in the middle, a person is typing the same numbers into both, hoping nothing slips through.

It works, until VAT quarter comes around. Or until Making Tax Digital deadlines start landing in your inbox. Or until your accountant asks for the figures and you spend a Saturday matching invoices to bank statements.

This post is about how to fix that. We will cover how accounting actually works for a UK car dealership, why the VAT margin scheme makes generic integrations unreliable, what Making Tax Digital means for you in practice, and how the right setup can take the whole thing off your plate.

Why car dealer accounting is harder than it looks

If you ran a coffee shop, accounting would be straightforward. You sell a coffee for £3.50, 20% VAT is included, the till connects to your accounts package, and your numbers are right.

Car dealerships are different for three reasons.

The VAT margin scheme. Most used-car sales fall under the second-hand goods margin scheme, which means you pay VAT on your profit margin, not the full sale price. Generic accounting integrations do not understand this. They will happily push a £14,000 sale into your ledger at standard rate VAT and you will not notice until the VAT return is wrong.

Bundled deals. A single invoice often contains a margin-scheme vehicle, a standard-rated warranty, a standard-rated admin fee, and maybe a finance commission. The VAT treatment on each line is different. That has to flow into your accounts correctly or your VAT return will not reconcile.

Finance payouts. When a deal goes on finance, the lender pays you days or sometimes weeks after the car leaves the forecourt. If you book the revenue when the lender confirms the payout, your accounts and your bank balance will not match. If you book it when the cash lands, your management reports lag behind reality. Most dealers end up with a mess in the middle.

Add up these three things and you get a situation where the dealer who knows cars inside out ends up doing double-entry bookkeeping in their evenings. That is the problem worth solving.

What "accounting integration" actually means

When people say their DMS has an accounting integration, they could mean one of three things.

A CSV export. You download a file from the DMS, open it in Excel, tidy it up, then import it into your accounts software. Better than nothing, but it is still manual, still error-prone, and still ages every quarter.

A one-way push. Invoices created in the DMS get sent into the accounts package automatically. This is a real improvement. You stop typing invoices twice. But payments, voids, and contact updates still drift out of sync.

A proper two-way sync. Sales invoices, payments, customer records, supplier bills, and cancellations all flow between the systems automatically. Change something in one place and the other catches up. This is what you actually want.

The third option used to be rare in the motor trade because generic plug-ins did not understand the VAT margin scheme. That has changed. At Vehiso we now have proper, motor-trade-aware accounting integrations built into the DMS for the three accounting platforms UK dealers actually use: Xero, QuickBooks Online, and Sage Business Cloud Accounting.

Making Tax Digital, in plain English

Making Tax Digital, or MTD, is HMRC's programme to move tax record-keeping out of paper ledgers and bridging spreadsheets and into proper accounting software. For VAT-registered businesses, MTD for VAT is already mandatory. MTD for Income Tax Self Assessment is rolling out next, and the deadlines will not move just because you are busy.

What MTD actually requires, in practice:

Digital records. You have to keep your business records in digital form, not in a paper invoice book.
Digital links. The data has to flow electronically between the systems involved. Typing figures from one spreadsheet into another is not a digital link. Exporting a CSV and uploading it counts, but only just.
MTD-compatible software. The final submission to HMRC has to go through software HMRC has recognised as MTD-compatible.

This is where it gets uncomfortable for a lot of dealers. If your sales records live in a DMS and your VAT return is filed from Xero, the link between the two has to be digital. If you are retyping invoice totals into your accounts package every Friday, that is not a digital link, even if both ends are software.

Xero, QuickBooks Online, and Sage Business Cloud Accounting are all on HMRC's list of MTD-compatible software. So the question is not whether your accounts package is ready. It is whether the chain from sale to submission is digital end-to-end. A proper DMS-to-accounting integration closes that gap.

What you actually want syncing

If you are setting this up, here is the short list of things that should be moving between your DMS and your accounts package without anyone typing them.

Sales invoices. Every invoice you generate against a deal should push to your accounts package the moment it is created. Vehicle, warranty, admin fee, paint protection, the lot. Each line on the right nominal, each line with the right VAT code, margin-scheme handling applied automatically where it applies.

Customer payments. Deposits, balance payments, card payments, bank transfers. If you reclassify a payment in the DMS, for example moving an amount from "deposit" to "balance," the entry in your accounts should follow.

Contacts. Customers and trade suppliers should appear as contacts in your accounts software on first use, deduplicated by email so you do not end up with three versions of John Smith.

Purchase orders and supplier bills. Auction wins, trade buys, parts orders. These should post as supplier bills in your accounts package ready to pay, with the right vendor attached.

Cancellations and voids. Cancel a deal in the DMS and the corresponding invoice should void in the accounts package automatically. Manual credit notes after the fact are a common source of mismatched figures.

Finance settlements. When a lender funds a deal, the settlement should post to a dedicated clearing account until the bank payment lands. This is the bit most dealers get wrong, and it is the reason their bank reconciliation never quite ties out.

If your integration handles all of these properly, you stop running two ledgers. There is just one set of numbers, and it is right.

The motor-trade detail nobody else gets right

Three things separate an accounting integration that is genuinely built for car dealers from a generic plug-in.

VAT margin scheme handled automatically

When you sell a margin-scheme vehicle, the invoice should post to your accounts under the margin scheme, with the VAT calculated from the profit rather than the full sale price. Standard-rated add-ons such as warranties, admin fees, and paint protection should be split out on the same invoice with 20% VAT applied correctly to those lines only.

Done properly, this means your VAT return reflects what HMRC actually expects: VAT on the margin for vehicles, VAT on the full price for ancillary products. Done badly, this is where dealers end up either overpaying VAT or facing penalties when HMRC notices the under-declaration.

If you want a refresher on how the margin scheme works in practice, the worked example in our car dealer invoicing guide covers it step by step.

Finance clearing accounts

When a finance house funds a deal, the money does not appear in your bank instantly. The right approach is to post the lender settlement to a dedicated clearing nominal when the deal completes, and only mark it cleared when the payout actually lands.

This sounds like a small thing. It is not. Without a clearing account, you either book revenue you have not received, or you delay booking revenue until the cash arrives. Either way your management accounts drift away from reality. With one, your books, your bank, and your funded-deal report all agree.

Multi-currency safety

If you operate in pounds, your accounts package needs to be set to pounds. Sounds obvious. It catches people out anyway, especially groups with overseas entities or anyone who set up a Xero organisation with the wrong base currency by accident.

A good integration checks the currency before it pushes anything, and blocks the connection if there is a mismatch. Better to get a clear error on day one than discover six months of GBP invoices sat in a EUR ledger.

What this looks like with Vehiso

A few specifics worth flagging if you are evaluating the integration in the Vehiso DMS.

Two-click connection. Pick your provider, log in to your accounts software, approve the connection, choose which organisation to sync if you have more than one. No API keys, no IT involvement, under a minute.

Mapping is in your hands. You map vehicle sales, deposits, finance settlements, workshop labour, part-exchange, and supplier payments to your specific chart of accounts. Change a mapping and future entries follow it. Your accountant can set this up with you in one call.

Idempotent and traceable. Every push is recorded in a sync log with the entity ID in the provider, the status, and any error message returned. If a sync retries, it does not duplicate. If something goes wrong, you can see what.

Included on every plan. This is not an add-on, there are no per-sync charges, and it is available during the 7-day free trial without a card.

The full feature page is at vehiso.com/features/accounting-integrations if you want the longer version.

How to get your accounting in order before the next deadline

If you are reading this and quietly hoping it is not as urgent as it sounds, here is a short checklist to work through.

Pick your accounts package. If you do not have one, talk to your accountant first. They will have a strong preference based on what their other clients use. Xero, QuickBooks Online, and Sage are all credible choices. If you are setting up from scratch, our guide on how to start a used car dealership covers MTD registration alongside the rest of the setup.
Move your records into it. If you are still on a paper invoice book or a Word template, your priority is getting current and historical records into digital form. This is the foundation MTD assumes.
Connect your DMS. Whichever accounts package you choose, set up the integration with your DMS so invoices, payments, and supplier bills flow automatically. This is the digital link MTD requires.
Sit down with your accountant. Walk through the chart of accounts and nominal mappings together. The integration only works if the mapping is right, and your accountant will know which nominals to use for vehicle sales, finance commission, workshop labour, and so on.
Reconcile your first month carefully. Watch the first VAT period closely. Check that margin-scheme sales are posting correctly, that finance settlements are landing in the clearing account, and that voids are reflected in both systems. Once you trust it, you can stop checking every entry.

It is rarely a one-afternoon job, but it is rarely more than a week of part-time work either. The payoff is permanent.

FAQ

Is my DMS MTD-compatible?

Strictly, MTD applies to the software that submits your VAT return, not the DMS. Xero, QuickBooks Online, and Sage Business Cloud Accounting are all HMRC-recognised MTD software. The question for the DMS is whether the link to your accounts package is digital, which means a proper integration rather than rekeying.

Do I have to use the margin scheme?

You can only use the margin scheme on vehicles where you were not charged VAT on the purchase, or where you did not reclaim VAT. If you bought a car from a VAT-registered seller who charged you VAT and you reclaimed it, you have to sell that car under standard VAT. The two schemes coexist in most dealerships. Your records have to show which scheme applies to which vehicle.

Can I switch accounts package later without losing data?

Yes, although it is not painless. Xero, QuickBooks, and Sage all support data export, and there are migration tools and accountants who specialise in moves between them. The bigger question is mid-year continuity for VAT and management reporting. If you can, plan a switch to coincide with the start of a new accounting year.

What about FreeAgent or other accounts packages?

The Vehiso integration currently covers Xero, QuickBooks Online, and Sage Business Cloud Accounting. These cover the vast majority of UK dealerships. If your accountant is on a different package, talk to us about it.

What happens if a sync fails?

Every push is logged. Transient failures retry automatically with exponential back-off. Persistent failures show up in the sync log with the error message from the provider, so you can see exactly what went wrong and fix it. Nothing silently disappears.

Will my accountant still have a job?

Yes, and they will be happier about it. Removing manual data entry frees your accountant to do the work you are actually paying them for: advising on tax planning, reviewing your margins, preparing year-end accounts, and spotting issues before HMRC does. Most accountants love a client whose books are clean.

Accounting and Making Tax Digital for Car Dealerships: A Practical Guide