Spreadsheets are brilliant, and anyone who tells you otherwise has never had to get a business moving on a Monday morning. They are free, they bend to whatever you need, and everyone already knows how to use one. Plenty of good operations run on them for a decade.
But there is a point where the tool that got you here quietly becomes the thing holding you back. It never announces itself. It arrives one workaround at a time. Here is how to tell you have crossed it.
1. You cannot answer a simple question without phoning someone
“Where is the 3 ton roller?” “Did we do the Meyerton service?” “How many jobs did that client have last month?”
These should take four seconds. If they take four phone calls, the information exists but it does not live anywhere you can reach. That is not a people problem. It is a missing system.
2. One person owns the file
There is a workbook that only Sarah properly understands, with formulas nobody else will touch, and everyone gets nervous when she takes leave. A spreadsheet that has become too complex and too fragile for anyone else to open is no longer a tool. It is a single point of failure with your operation sitting on top of it.
3. The same information lives in four places
There is a version in the shared drive, one on a laptop, one printed on the wall in the yard, and the real one in someone’s head. Nobody is certain which is current. Every decision you make carries a quiet risk of being made on the wrong number.
4. Paperwork comes back late, or it does not come back at all
Job cards, inspection sheets, delivery notes and condition reports get filled in on paper because paper is what a person has on a site. Then the paper lives in a bakkie for a week, gets rained on, or simply never arrives. You only find out when you go looking for it, which is always at the worst possible moment.
5. Work gets done and never invoiced
This one costs real money and it is more common than owners like to admit. A job is completed, the paperwork does not close the loop, and it never reaches the invoice run. At month end the revenue is simply lower than it should be, and nobody can point to why. When a business finally puts a system in, this is usually the leak that pays for it.
6. A query about March takes two days to answer
A client disputes something from eight months ago. In a spreadsheet operation, answering that means finding the right file, finding the right row, and then finding the paper that proves it, if it still exists. In a system, it is a search. The difference matters most in exactly the moments where you are least able to afford it: a damage claim, a compliance audit, a contract renewal.
7. You are the system
The clearest sign of all. Scheduling happens because you allocate it. Follow-ups happen because you remember them. Nothing moves when you are on holiday, and holidays stop being restful. Your business has a capacity ceiling and the ceiling is you.
What to actually do about it
The instinct is to build a better spreadsheet. That buys you six months and lands you back in the same place, because the problem was never the formulas. It was that the work has no home.
A few things worth knowing before you go looking:
Start with the record, not the report. Everyone wants the dashboard. The dashboard is the easy part and it is worthless without clean underlying records. Get every machine, vehicle or site into one place with its own history, get every job attached to one of them, and the reporting stops being a project.
The field has to be as easy as WhatsApp. If capturing a job on a phone is slower than sending a photo to a group chat, your team will send the photo to the group chat. Any system that ignores this fails in week three, no matter how good the office side looks.
Do not rip out your accounting. Pastel, Sage and Xero handle the money perfectly well. The gap in most operations is not financial, it is operational. Fill that gap and hand the numbers across cleanly.
Beware the twelve month build. Custom software written from scratch for one business is how this used to be solved, and it is why most owners never solved it. If a system already exists and can be set up around how you work, you are live in weeks and you find out early whether it fits.
None of this needs a technology department. It needs the work to finally have somewhere to live.
If several of these seven landed, that is worth thirty minutes of your time. See what the system does, or look at what it costs before you speak to anyone.