Nobody decides to run a business on spreadsheets. It just happens, one sheet at a time, and each one made sense on the day it was made.
A spreadsheet is a brilliant place to think. It is a poor place to operate. The difference shows up slowly, so most owners feel the cost long before they can name it.
Here is how to name it. Seven signs. If three or more are true, the sheet has stopped helping.
01
Two people have two different versions of the same sheet
Someone downloaded it to work offline. Someone else kept editing the original. Both are now right, and both are now wrong. The moment a file gets copied, the copy starts drifting, and nobody sends round a note to say which one won.
02
The same fact is typed in more than one place
A phone number lives in the lead sheet, the calling sheet and the invoice sheet. Change it in one, and the other two are quietly out of date. You do not notice until someone calls a dead number and swears it was right yesterday.
03
Somebody spends their Friday building a report
Copy, paste, tidy, format, send. If a person is doing that every week, you are paying wages to move numbers from one box to another. That is the clearest sign the sheet has stopped being a tool and started being a job.
04
You cannot tell who changed something, or when
A number is different from last week. Nobody knows who edited it or why. With no record of changes, every disagreement becomes a memory contest, and the loudest memory wins.
05
The sheet has rules only one person understands
Hidden columns. A formula that must not be touched. A tab everyone is told to leave alone. When one person is the only one who can safely open a file, that file is now a risk, not an asset.
06
You are filtering to find work instead of being told about it
If finding today's tasks means sorting, filtering and scrolling, the sheet is not telling you what to do. It is storing things and leaving the thinking to you. Work you have to go looking for is work that gets missed.
07
Nobody trusts the total
The clearest signal of all. Someone reads a number out loud and a second person says they will double-check it. At that point the sheet has stopped being the record and become one opinion among several.
What this actually costs
The cost is not the hours. It is the decisions made on numbers nobody checked.
On one job we read 19,133 call records one at a time and compared each one to what actually happened on the call. On another, we looked at 10,850 calls and found 1,032 where the note said one thing and the result said another. Nobody had spotted it, because nothing in the sheet made anyone check.
That is the real problem with a spreadsheet. It will hold a wrong number as happily as a right one, for years, without complaining once.
Do not buy a tool yet
The instinct is to go shopping. New software, fresh start, problem solved.
It rarely works, because a new tool inherits the same muddle. If two people disagree about what a stage means, the software will not settle it. It will just record the disagreement faster.
Do these three things first, in this order.
One. Pick the handful of facts that must only ever exist in one place. Usually the customer, the deal and the money. Everything else can be copied; those three cannot.
Two. Write down who owns each one. Not a team. A person. Ownership that belongs to everybody belongs to nobody.
Three. Find the report somebody builds by hand every week and work out where each number on it comes from. That trail tells you what the system actually has to do. Most people discover half the numbers cannot be traced anywhere.
Do that, and the tool decision becomes obvious and small. Skip it, and you will be having this same conversation in eighteen months about a more expensive system.