Article
Five spreadsheet mistakes quietly costing dealers thousands
The everyday spreadsheet errors that eat margin at independent dealerships — double-sold cars, missing costs, stale prices — and how a DMS closes them off automatically.
TL;DR
The five most expensive spreadsheet mistakes at independent dealerships are: double-sold vehicles, missing reconditioning costs, out-of-sync listing prices, lost enquiries, and no aged-stock alerts. Each is silent, additive, and easy to fix with a real DMS.
The five mistakes
- Double-sold cars. Two people mark the same vehicle available at once.
- Missing reconditioning costs. The £280 invoice for prep never made it into the sheet, so gross looks better than it is.
- Out-of-sync prices. AutoTrader says £8,995, Facebook says £9,295, your own site says £9,495. Buyers notice.
- Lost enquiries. A message came in on Saturday and never got a reply because it wasn't logged anywhere central.
- No aged-stock alerts. A car sits for 120 days at the wrong price and quietly turns into a loss.
Why spreadsheets can't fix them
Spreadsheets don't enforce data quality, don't sync in real time across a team, and can't push changes to marketplaces. Every one of the five mistakes above needs a live single source of truth to prevent — not another tab and another VLOOKUP.
What a DMS does instead
A DMS makes the vehicle record the source of truth. Status changes are visible to everyone instantly. Costs attach to the car. Listings across channels stay in sync because they share the same source. Enquiries land in one inbox. And aged stock flags itself before it eats margin.
Frequently asked questions
Is a spreadsheet ever enough?
For a single-person operation with under twenty cars, maybe. Once a second person edits stock or listings go to more than one channel, the copy-paste tax adds up fast.
What is the biggest single risk?
Double-sold cars. Two salespeople promising the same vehicle to different buyers damages reputation as well as margin, and a spreadsheet cannot prevent it.
How much do these mistakes cost per year?
Estimates vary, but dealers we speak to typically identify £5,000–£15,000 of avoidable losses a year once they see the data properly.
Do I lose my history if I switch?
No — sold vehicles can be imported into a DMS as historical records so reporting still covers earlier months.
Related guides
What is a Dealership Management System (DMS)?
The foundational guide to DMS software, its core modules, and why independent dealers need one.
Switching from spreadsheets to a DMS
A step-by-step migration plan for dealers moving from Excel and Google Sheets to Lotra.
Vehicle inventory management for car dealers
How modern inventory management works — from auction purchase to sold, without spreadsheets.
See it inside Lotra
Lotra is the operating system for independent dealerships. Inventory, CRM, finance, listings and AI insights in one workspace.