DMS vs Spreadsheet: When Should a Used Car Dealer Make the Switch?

Please take a look at the case study following the progress of MWA Autos LTD; our very first partner who we took from spreadsheets to a fully functional DMS

Ask a fifteen-car independent dealer why they've never bought a DMS and the honest answer is usually some version of "it works." The stock sheet has every car on it. The WhatsApp group covers handovers between the yard and the workshop. Nobody's had a Trading Standards visit go badly. That answer is often correct, and it deserves to be taken seriously rather than dismissed as a dealer who just hasn't caught up yet, because a genuinely small operation can run perfectly well on a shared spreadsheet and a good memory for a long time.

The harder question, and the one this article is actually about, is knowing when that stops being true. Not in vague terms like "when you've outgrown it," which tells a dealer nothing they can act on, but in terms of specific things that happen in a working week that mean the spreadsheet has quietly become the risk rather than the solution.

Where a spreadsheet is genuinely the right tool

Start with the case for the spreadsheet, because most content on this subject skips straight past it to the sales pitch.

A one or two-person operation, buying and retailing somewhere under about fifteen cars at a time, where the same person appraises the stock, writes the advert, handles the enquiry and does the paperwork, has very little to gain from a DMS. There's no version-conflict problem because there's rarely more than one person in the file at once. There's no missed-follow-up problem because the person who took the enquiry is also the person who remembers it needs chasing. Compliance record-keeping is manageable because the transaction volume is low enough that a well-organised folder of finance agreements and ID copies, alongside a consistent naming convention, still holds up if anyone ever asks to see it.

In that setup, a DMS mostly adds a monthly cost and a login screen for a problem the dealer doesn't actually have yet. Spend the money on stock or marketing instead. The spreadsheet earns its keep here, and any argument for switching should start from acknowledging that rather than pretending every dealer on Excel is one bad week from catastrophe.

The signals that actually mean something has changed

What follows isn't a list of things that would be nice to have. Each one is something that, once it starts happening regularly, means the underlying system has stopped matching how the business actually runs.

Stock count crossing roughly fifteen to twenty cars, turning at a normal pace. Below that, most people can hold the whole forecourt in their head: what's in, what's prepped, what's had an offer. Above it, that mental model starts dropping detail, and the spreadsheet becomes the only place the full picture exists, which is a much bigger problem the moment a second person needs to see it too.

More than one person editing the same file. This is the trigger that does the most damage fastest, and it has nothing to do with stock count. Two people working from the same sheet, or worse, two versions of it because someone made a personal copy "just to check something," produces overwritten fields, a car marked sold that isn't, and occasionally the exact scenario every dealer dreads: two members of staff independently agreeing a deal on the same car with two different buyers because a sale confirmed by WhatsApp between the salesperson and the workshop never made it back into the sheet before someone else quoted the car as available.

Compliance record-keeping that's outgrown a folder. A used car dealer accepting a cash payment of 10,000 euros or more (or the sterling equivalent) for a single transaction has to register with HMRC as a High Value Dealer under the money laundering regulations, and needs to be able to show the paperwork behind that transaction on request, not reconstruct it from memory. The Consumer Rights Act 2015 gives buyers a 30-day short-term right to reject a faulty vehicle, which means a dealer needs to know, precisely, when that clock started on every car sold, not roughly. A spreadsheet can hold all of this information. What it can't do is enforce that it was filled in consistently, timestamp when a field was actually entered rather than backfilled later, or flag a gap before it becomes the thing an inspector or a solicitor's letter asks about.

Missed follow-ups that nobody notices are missed. A "call back" column only works if someone is actively scanning it every day, and in practice that column becomes the place enquiries go to be forgotten once the person who owns it gets busy with something more urgent, which on a working forecourt is most days. The lead isn't lost in an obvious way. It just quietly goes cold, and nobody finds out because nothing flagged that it needed chasing.

Formulas breaking silently, and the hours spent afterwards untangling them. Someone deletes a row to tidy up "old" stock and a lookup formula three tabs over starts returning the wrong figure. Someone pastes values instead of formulas and a running total stops updating. A spreadsheet doesn't tell you when it's wrong, it just quietly gives you a wrong number that looks exactly like a right one, and the cost shows up later as reconciliation time: closing out the month by cross-checking the stock sheet against a separate sales log, a folder of invoices and a WhatsApp thread to work out what actually happened. That reconciliation time is the business explaining, in hours spent rather than words, that no single version of the truth currently exists.

The real driver isn't stock count on its own

It would be tidy to say "under twenty cars, stick with a spreadsheet; over twenty, switch," but that's not quite honest, and a genuinely useful piece of advice has to be more specific than a round number. The actual driver is the combination of how many people touch the same source of truth and how much of what they're recording carries compliance weight if it's wrong.

Stock count is a proxy for that. It isn't the mechanism itself.

A twelve-car dealer with one owner-operator handling everything is lower risk than a twenty-two-car dealer with three staff independently updating the same sheet from their phones between test drives, even though the second dealer has fewer cars per person on paper. The number of hands in the file, not the number of cars on the forecourt, is what turns a spreadsheet from a lightweight tool into a liability, because every additional person editing the same document is another chance for two versions of the truth to exist at once. Stock count matters mainly because it tends to correlate with staff count. It isn't the cause on its own.

What actually changes when a dealer switches

This is where most comparison content turns into a feature list, which misses the point of why a DMS actually helps. MYDEALERSHIPVIEW wasn't built to be a better spreadsheet. It was built to change what the working day looks like once a dealer stops treating record-keeping as a separate chore bolted onto the job of selling cars.

A stock record that updates once, in one place, the moment a car's status changes removes the version-conflict problem entirely, because there's no longer a second copy for someone to edit by accident. Log a follow-up against a lead and it surfaces again automatically if nobody's actioned it, which removes the "forgotten column" problem because the system does the noticing instead of relying on someone remembering to look. Compliance records tied directly to the vehicle and the transaction, timestamped as they're created rather than reconstructed afterwards, turn "we should have that somewhere" into "here it is." None of that is a new feature bolted onto a spreadsheet's job. It's the job done differently, in a way built for more than one person to rely on at once. If you want the fuller picture of what a dealer management system actually does day to day, our explainer on what a dealer management system is covers that ground properly. The specific tools behind the points above, stock, CRM follow-up and compliance record-keeping, are laid out on our features page.

A straightforward way to check where you actually stand

Read back through the five signals above and count how many genuinely describe a normal week, not an unusual bad one. One, and the spreadsheet is probably still doing its job; keep an eye on the trend rather than acting now. Three or more out of five, and the honest advice is to stop treating the current setup as temporary. That's not a sales line dressed up as advice. A dealer who recognises three or more of those signals is already paying a cost for staying on a spreadsheet, in missed follow-ups, in reconciliation hours, in the compliance exposure of records that exist but can't be trusted at a glance. The only question left is whether that cost gets addressed now or after it causes a specific, avoidable problem.

If that's where you've landed, the next sensible step isn't picking a system on brand recognition. It's comparing what's actually on offer against what you counted above, which is exactly what our DMS comparison guide is for.

FAQs