Why Spreadsheets Fail When You Own More Than One Car

A spreadsheet is the natural first move when you want to get organised about your vehicles. It's free, flexible and already on your computer. For one car, it works well enough. You track the MOT date, maybe the service history, perhaps what the insurance costs. Simple. Add a second car and it starts to strain. By the time you have three or four vehicles — a daily, a weekend car, a project, a family runner — the spreadsheet has either grown into something unwieldy, or quietly fallen behind reality. Usually both. Here's why, and what better looks like. ## The Structure Problem Spreadsheets are flat. They're good at rows of similar things — a list of expenses, a table of MOT dates. What they're not good at is representing connected, nested information. A vehicle record isn't flat. It has a profile (make, model, registration, purchase date, value). It has a history (services, faults, repairs). It has documents (V5C, insurance certificates, invoices). It has upcoming events (MOT renewal, tax, insurance). It has costs (fuel, servicing, tax, insurance, repairs). Each of these is its own type of information with its own structure. In a spreadsheet, you have two choices: cram everything into a wide, complex table that nobody wants to update, or split it across multiple sheets and spend time cross-referencing. Neither is pleasant. Neither is reliable over time. ## The Maintenance Problem The other issue is discipline. A good spreadsheet needs to be updated every time something changes — every service, every insurance renewal, every cost. Real life doesn't cooperate with this. You get the car serviced, you mean to update the record later, and later doesn't come. After six months, the spreadsheet is partially accurate. After a year, you're not sure which parts you can trust. You find yourself doing the actual work of looking up MOT dates and insurance renewals rather than trusting the record — which means the record has stopped being useful. This isn't a discipline failure. It's a design failure. Spreadsheets make updating feel like admin. Good purpose-built tools make it feel like completing a picture. ## The Deadline Visibility Problem This is the most consequential failure mode. Spreadsheets are bad at surfacing urgency. Imagine you have four vehicles. Each has an MOT date, a tax date and an insurance renewal date. That's twelve dates sitting somewhere in a spreadsheet. Some are two weeks away. Some are eight months away. In a spreadsheet, they all look the same — they're just cells. There's no mechanism that puts the two-week deadline in front of you without you actively looking for it. You have to open the spreadsheet, find the right sheet, scan the dates, work out which ones are imminent. Every time. If you don't do that regularly enough, you miss something. A missed MOT doesn't just mean a fine. It means your vehicle is uninsured and you cannot legally drive it until it passes. The penalty for driving an uninsured vehicle starts at £300 and can reach much higher. None of that is caused by carelessness — it's caused by a tool that doesn't surface the thing you need to know. ## The Document Problem Where do you keep your V5C logbooks? Your insurance certificates? Your service invoices? For most people, the answer is somewhere physical — a folder, a drawer, a glovebox — with perhaps some PDFs scattered across email or a downloads folder. The spreadsheet doesn't help here. It tracks that a document exists, maybe, but it doesn't hold the document. So when you need your insurance certificate for a garage, or your V5C for a sale, or an old service invoice for a warranty claim, you're searching in two places: the spreadsheet to find the reference, and whatever folder system you use to find the actual file. For one car this is manageable. For four, it's a reliable source of friction and occasional panic. ## The Sharing Problem If you share vehicles with a partner or family member — or if someone else manages some of the vehicles on your behalf — a spreadsheet is a collaboration nightmare. Emailed copies go out of sync. Shared drives create version confusion. Google Sheets works better, but still has no awareness of roles, no structured vehicle records, no deadline logic. You end up with everyone looking at the same flat document and hoping it's up to date. ## What the Alternative Looks Like The answer isn't a more complicated spreadsheet. It's a purpose-built record. Purpose-built means the data structure matches the domain. Vehicle profiles with nested history. Documents attached to the records they belong to. Costs categorised and totalled per vehicle. Dates that surface as actions when they become relevant — not when you happen to open the right file. It means a single view that tells you, for all your vehicles simultaneously, what's due in the next thirty days. Not a table you scan — a digest that surfaces what matters. It means a record you can trust, because it's designed to be maintained as you go, not in a periodic admin session that keeps getting skipped. ## The Honest Test Here's the question to ask yourself about your current vehicle records: *If you needed to sell one of your vehicles tomorrow — could you produce a complete service history, the current MOT certificate, the insurance certificate, and the V5C without more than a few minutes of searching?* For most multi-vehicle owners who rely on a spreadsheet or scattered paper records, the honest answer is no. Not quickly, and probably not completely. That's the problem worth solving. Not because it's urgent every day, but because it surfaces at exactly the wrong moments — a sale, an insurance claim, a roadside check, a garage asking for history before a job. Fleet Tracker is built for the person who has more than one car to look after and wants a record they can actually trust. If you've outgrown your spreadsheet — or you're building one that keeps feeling like more work than it's worth — it's worth taking a look.