Spreadsheets are brilliant. They’re flexible, everyone knows how to use one, and they cost next to nothing. Most businesses start out running on them, and for a while that’s exactly right.
The trouble comes later. A spreadsheet built to track a handful of jobs is now running the whole operation, and it was never designed for that. Here are five signs you’ve reached that point.
1. Nobody is sure which version is right
There’s the copy on the shared drive, the one someone emailed last week, and the one with “final” in its name that isn’t. When two people can open the same information and see different answers, decisions get made on the wrong one.
2. Only one person really understands it
Every business has one: the spreadsheet with the formulas nobody dares touch, maintained by the one person who built it. It works until they’re on holiday, off sick or moving on. A system the business depends on shouldn’t depend on one person’s memory.
3. You’re typing the same thing in twice
An enquiry arrives by email. Someone copies it into the spreadsheet. Someone else copies it into an invoice. Then it’s typed again into a message to the customer. Every copy takes time, and every copy is a chance to get something wrong.
4. Finding out where things stand means asking someone
If the only way to know whether a job is done, a quote has gone out or a customer has been called back is to ask a colleague, the information isn’t really available. It’s just stored. The larger the team, the more of the day goes on asking and answering.
5. Mistakes are starting to cost you
A row sorted without its neighbours. A formula overwritten by a number. A filter left on. Small slips in a spreadsheet are easy to make and hard to spot, and they tend to surface as a missed job or a wrong price.
What to do about it
Recognising the signs doesn’t mean you need custom software tomorrow. Work through it in order.
Look at ready-made tools first. If an existing product does what you need at a sensible price, use it. It will be quicker and cheaper than building something.
Consider bespoke when nothing fits. If you’ve tried the standard options and keep bending your process to suit them, or paying for three tools that don’t talk to each other, a system built around how you work becomes worth pricing up.
Start small. The most useful first version usually replaces the one spreadsheet that causes the most trouble. Once that’s working, add to it. You don’t have to replace everything at once.
What a replacement looks like
In practice, it’s usually a web application your team signs in to. Everyone sees the same, current information. People see what’s relevant to their role. Work moves from one stage to the next, and anyone can check where a job stands without asking.
The aim isn’t to add technology for its own sake. It’s to take away the copying, the chasing and the doubt.
If some of this sounds familiar, tell me how things work now and where the friction is. You can also read about bespoke web applications and what they can include.