Nobody sets out to run a business on spreadsheets. It happens because a spreadsheet is the fastest way to solve today's problem, and then today's problem repeats for four years. The awkward part is that a spreadsheet never announces it has stopped working. It just gets slower, more fragile, and more dependent on one person, until something falls through a crack big enough that you finally notice. Here is how to tell where you are, without waiting for that.
One: Two People Can't Use It At Once
This is the earliest sign and the easiest to dismiss. Someone has the file open, so someone else gets a read-only copy, works in it anyway, and now there are two versions. Cloud spreadsheets soften this but do not fix it — you still get the person who sorts a column while someone else is mid-edit and quietly scrambles every row.
The underlying problem is that a spreadsheet has no concept of who is allowed to change what. Every cell is equally editable by everyone. That is exactly what makes it fast to start with, and exactly what makes it unusable once more than a couple of people depend on it.
Two: The Truth Lives In More Than One Place
Ask yourself where a client's phone number actually lives. If the honest answer is "the jobs sheet, and the invoicing file, and probably a text thread", you have three versions of the truth and no way to know which is current.
This is the point where admin time starts climbing without anyone doing anything wrong. Every update becomes three updates. Every discrepancy becomes a conversation. The work is not the job — the work is keeping the copies agreeing with each other.
Three: Nothing Reminds Anybody Of Anything
A spreadsheet is a record of what happened. It has no opinion about what should happen next. It will sit there perfectly happily with a quote from six weeks ago that nobody followed up, and it will never once mention it.
That is usually the single most expensive gap, because the work is already won or nearly won. You did the site visit, you built the quote, you sent it — and then the follow-up depended on somebody remembering. Chasing is the cheapest revenue in the business and the first thing to fall off when the week gets busy.
Four: Only One Person Really Understands It
Every long-lived spreadsheet develops a caretaker. They know that column M has to stay hidden, that the totals break if you insert a row above 14, and that the pricing tab is the real one despite what the other tab says.
That person is now a dependency. Not because they want to be — usually they would love to hand it over — but because the knowledge is in their head rather than in the file. When they are away, work slows down. When they leave, it stops.
Five: You Can't Answer Simple Questions Quickly
How many jobs are sitting unquoted right now? What did we invoice last month versus the month before? Which customer owes us the most and for how long? Which crew is over-committed next week?
If answering any of those means opening several files and doing some arithmetic, the business is running blind between reporting cycles. Decisions get made on a feeling, and the feeling is usually a few weeks out of date.
Six: You've Started Avoiding It
The last sign is behavioural. People stop updating it during the day and batch it up for Friday. Then Friday gets busy and it becomes Sunday. Then it becomes approximate.
Once a system is only accurate on Sundays, it is not a system anymore, it is a report. And a report nobody trusts stops being consulted, which means the actual decisions are being made from memory.
What Actually Replaces It
The instinct is to buy an off-the-shelf tool, and for plenty of businesses that is the right answer. Where it goes wrong is when the tool assumes a workflow you do not have, so your team ends up maintaining the tool and a spreadsheet on the side. That is worse than where you started.
The test is simple. Write down the stages a job moves through in your business, in your own words. If a product handles those stages as they are, buy it. If using it means renaming your stages to match its stages, and the way you work is genuinely part of why customers choose you, that is when building around your actual process pays for itself.
- Write your stages down before you look at any software
- Count how many places one client's details currently live
- Name the person who is the caretaker, and what only they know
- Pick the one gap that costs the most — usually follow-up — and fix that first