Spreadsheets are excellent until they are dangerous. The tipping point is recognisable, and it usually arrives about a year before anyone acts on it.
Key Takeaways
- Spreadsheets are excellent until they are dangerous.
- The tipping point is recognisable, and it usually arrives about a year before anyone acts on it.
A spreadsheet is the right tool for longer than most software vendors admit. It is free, everyone knows it, and it bends to whatever you need this week. Plenty of businesses in Nepal run well on one for years.
Then it stops being an asset. Here is how you know.
1. Someone has to be careful
There is a file only one person is allowed to touch, because they know which cells contain formulas and which look like numbers but are text. When they take leave, work waits.
That is not a spreadsheet any more. That is a system with a single point of failure who also has a day job.
2. You have several versions of the truth
Final. Final_v2. Final_updated_Shrawan. The version on the accountant's laptop that has three rows the shared one does not.
Once reconciling copies is a regular task, the spreadsheet has stopped saving time. The cost is not the reconciliation. It is the decision someone makes from the wrong copy.
3. The report takes a day
Month end means someone exporting, pasting, filtering and cross-checking for hours before anyone can see how the business did.
Two costs here, and the second is larger. The obvious one is the day. The hidden one is that nobody asks a question they would like answered, because asking means someone spends another day. Businesses run on the reports that are cheap to produce.
4. Mistakes are getting expensive
A wrong price sent to a customer. A stock figure that was two weeks old. A payment marked received that was not.
Spreadsheets do not enforce rules. They will let anyone type anything anywhere, and they will not tell you. When the cost of a single mistake starts to approach the cost of software, the arithmetic has changed.
5. Two people cannot work at once
Shared cloud sheets help, until the file grows large enough to be slow, or two people edit the same row, or someone sorts a column and breaks the alignment for everyone.
If your team coordinates over who has the file open, you are paying a coordination cost every day.
What to do about it
The instinct is to replace everything. Resist it. Whole-system replacements are where budgets go, because you are rebuilding years of accumulated logic that nobody has written down.
Pick the single process causing the most pain and replace only that. Keep the spreadsheet for the rest. Live with the split for a few months, learn what you actually need, then extend.
Before you talk to anyone about building it, do one thing: export a copy of the spreadsheet and write down, in plain sentences, what each column means and what rules people follow that are not written anywhere. That document is worth more to a scoping conversation than any feature list, and it is the part only you can produce.
What it costs
A focused internal tool covering one process starts from NPR 80,000 with us. The number moves with how many people use it, how many rules it enforces, and whether it has to talk to something you already run.
The question to test it against is not whether the software is cheap. It is whether the day per month, the reconciliation, and the occasional expensive mistake cost more over two years. Usually they do, and usually nobody has added them up.
Enjoyed this article? Share it with others!
Written by
AntByte Labs
Engineering · AntByte Labs
AntByte Labs is a Engineering at AntByte Labs, sharing expert insights on technology, software development, and digital innovation to help businesses grow.