Every business runs on spreadsheets at some point — and honestly, spreadsheets are brilliant. They're flexible, everyone knows them, and they cost nothing. We will never tell you to replace a spreadsheet that's working.
But there's a point where the spreadsheet stops being a tool and starts being a risk. Most teams pass that point about a year before they admit it. Here are the signs we see over and over when companies come to us, and what the sensible next step actually is (spoiler: it's not always "build custom software").
The 7 signs
1. There's one person who "owns the sheet" — and everyone's scared of them going on holiday
If a single person understands how the formulas work, you don't have a system, you have a dependency with a pulse. When that person leaves, their knowledge leaves with them.
2. You have files named Final_v3_ACTUAL_final(2).xlsx
Version chaos means people are making decisions on different versions of the truth. If your team ever asks "wait, which file are we using?", data is already being lost.
3. People re-type the same information into multiple places
An order comes in by email, gets typed into a sheet, then typed into the accounting software, then typed into a delivery note. Every re-type is a chance for an error, and it means your systems disagree with each other by default. This is usually the loudest sign — and often the cheapest to fix.
4. "Can you send me the latest numbers?" takes hours, not seconds
If reporting means someone manually assembling data from five sources every Monday morning, you're paying a skilled person to be a copy-paste machine.
5. The spreadsheet has become an app — badly
Colour-coding as workflow states. Comments as audit trails. A macro someone wrote in 2019 that no one dares touch. At this point you've already built software; it's just fragile software with no backups, no access control, and no error handling.
6. Mistakes are starting to cost real money
A mistyped price honoured on a big order. An invoice that never got sent because a row was accidentally deleted. When you can name specific incidents — and put a £ figure on them — the spreadsheet is no longer free.
7. You can't safely give people access
You want a contractor to see their own jobs but not everyone's pay rates. You want a client to check their order status without ringing you. Spreadsheets are all-or-nothing; there's no "this person sees only this."
Three or more of these? Keep reading.
What to do about it (in order of cost)
The right answer is rarely "spend £40k on a custom platform." Here's the honest ladder:
Step 1: Try off-the-shelf software first
For common problems — CRM, project tracking, invoicing, inventory — good products already exist. If a £30/month tool covers 90% of what you need, take that deal. An agency that pushes custom builds before asking what you've tried isn't advising you, it's selling to you.
Step 2: Connect what you already have
Very often the problem isn't the tools, it's that they don't talk to each other. Automations and integrations — order comes in, invoice gets raised, sheet gets updated, team gets notified, no human typing — are dramatically cheaper than new systems. Projects in the low thousands, not tens of thousands, and this is where most businesses should start.
Step 3: Build custom only where your business is genuinely different
Custom software makes sense when the workflow is your competitive advantage, or when no product fits how you actually operate and forcing yourselves into one would hurt. Then a focused internal tool or web app — built around your exact process — pays for itself in saved hours and prevented mistakes. The key word is focused: the best first version replaces one painful workflow, not your whole business.
How to think about the cost
Don't ask "what does software cost?" Ask "what does the spreadsheet cost?" Count the hours spent re-typing, chasing versions, and building Monday reports. Multiply by what those people cost. Add the incidents from sign #6. That number, per year, is your budget benchmark — most businesses find the manual process costs more annually than fixing it would cost once.
If you recognise your business in this article and want a straight answer on which step of the ladder you're at, get in touch. Sometimes the answer really is "you're fine on spreadsheets for another year" — and we'll tell you that too.