Excel is not the enemy. It is the fastest modelling tool ever built, and most good systems start as a spreadsheet somebody wrote on a Sunday. The problem is not the tool, it is the moment when the tool quietly becomes the system of record without anyone deciding it.
Sign one: the same number exists in three places and they disagree
Stock in the warehouse sheet, stock in the shop, stock in the accounting export. Every month somebody reconciles them by hand and calls the result correct. The reconciliation is not the problem. The problem is that nobody can say which number was right, so decisions are made on the most optimistic one.
Sign two: a process only exists in one person's head
There is a file with a macro, and there is a colleague who knows why column M must never be sorted. When that person is on holiday, the month closes late. When that person leaves, you discover how much of your operation was undocumented. This is the risk that owners underestimate the most, because it is invisible until it is not.
Sign three: your answers arrive too late to matter
You want to know which products earned money last quarter, and the answer takes three days of assembly. By the time it arrives, the question has moved on. A system is not there to produce prettier reports. It is there so that the answer is a query rather than a project.
Sign four: growth makes things worse instead of better
A new sales channel should be good news. Instead it means another export, another import, another manual step at month end. When every increase in volume increases administrative work proportionally, you are not scaling, you are stacking. That is the point where the cost of the spreadsheet exceeds the cost of the system.
Sign five: you are afraid to check
The quiet one. You suspect the stock figure is wrong, and you do not count, because counting would prove it and then something would have to be done. Or you avoid a price change because nobody can say what the real cost of the product is. Fear of your own numbers is the clearest signal of all.
What to do about it, in order
- Write down the five processes that hurt most. Not all of them, five.
- For each one, note who does it, how long it takes and what breaks when it goes wrong.
- Find the one process where a fix would free the most time. Start there.
- Only then look at software. The tool is the last decision, not the first.
And a warning about the opposite mistake: not every spreadsheet needs to die. Planning, simulation and one off analysis are exactly what a spreadsheet is good at. What belongs in a system is the record of what actually happened: orders, stock movements, hours, invoices. Keep the model in Excel if you like it. Move the truth into the system.
If two of these five signs describe your company, you have time to do this calmly. If four do, you are already paying for the system every month, you are just paying in other people's hours.