Seven Signs Your Business Has Outgrown Spreadsheets

Nobody starts out needing software

Every spreadsheet that has become a problem started as a good decision. Someone needed to track twelve orders and a sheet did it in ten minutes. The trouble is that a spreadsheet degrades gracefully — it never fails outright, it just gets slower, more fragile and more dependent on the one person who understands it. There is no moment where it stops working, which is exactly why businesses stay on one about two years longer than they should.

So instead of asking “is our spreadsheet broken?”, ask a more useful question: what is it costing to keep it? The signs below are the ones we see most often in the first discovery call, and each has a number attached to it.

1. One person is the system

There is a file only Sarah touches. She built it, she knows which columns are formulas and which are pasted values, and when she is on holiday the reporting stops. That is not a spreadsheet — that is an undocumented application with a single point of failure who also has to do their actual job.

The cost is invisible until she leaves. We have picked up several projects that began the week after a “Sarah” resigned, and the first four weeks were archaeology: working out what the sheet did before anything could replace it. Rebuilding under time pressure always costs more than rebuilding on a normal schedule.

2. Somebody re-types data that already exists

If a number is typed into one system and then typed again into another, you are paying a person to be an API. This is the single most common automation we are asked for, and it is usually the cheapest one to fix.

It is worth timing honestly. Two people spending 90 minutes a day re-keying orders is roughly 780 hours a year. At a fully-loaded £22 an hour that is a shade over £17,000 — every year, forever, for work that produces nothing a customer would pay for.

• Orders arriving by email and typed into the order system
• Invoices typed into both the accounting package and a tracking sheet
• Delivery details copied into a courier portal one at a time
• Enquiries retyped from the website inbox into a CRM

3. Two people can be right and still disagree

The classic symptom: sales quotes a stock figure, the warehouse quotes a different one, and both are reading a real number from a real file. Spreadsheets have no single source of truth once more than one copy exists, and copies always exist.

The business cost is not the argument — it is the double-selling, the apology emails and the credit notes. One wholesale client we worked with was writing off £2,000 to £3,000 a week in returns and credits traceable to stock and order errors. That is the sort of figure that pays for an automation project in a quarter.

4. You cannot answer a simple question without a morning of work

“How much did we sell of product X to customers in the north last quarter, and what did it cost to deliver?” If that takes someone half a day of VLOOKUPs, the data is technically present but practically unavailable. Decisions get made on instinct instead, because the cost of checking is too high.

This is the sign business owners feel most and articulate least. It shows up as a vague sense that you are flying blind in a business that is, on paper, well documented.

5. The file has broken at least once and nobody knows why

A formula that silently stopped copying down. A sort applied to one column but not the rest. Someone pasting over a formula with a value. Spreadsheets fail quietly and the failure is discovered weeks later, usually by a customer.

The tell is a person who says “I always check it manually anyway, just in case.” That sentence means the automation you already built is not trusted, and the manual work never actually went away.

6. Growth makes things worse rather than better

In a healthy operation, doubling the order count roughly doubles revenue and adds a little admin. On a spreadsheet, doubling the order count doubles the admin exactly, because every order is a hand-typed row. Growth stops feeling like success and starts feeling like drowning.

This is the point where most businesses hire another admin. It is worth pricing the alternative before you do: a first automation phase typically lands between £5,000 and £15,000 and does not need a desk, a laptop or a salary review.

7. The workaround has its own workaround

There is a macro that fixes a problem, and a checklist that catches the cases the macro misses, and a WhatsApp group where people flag the ones the checklist misses. Each layer was rational on the day it was added. Together they are a system nobody designed and nobody can safely change.

When you reach this point, replacing the sheet is not a technology decision any more, it is a risk decision.

What to do about it, in order

You do not need to replace everything, and you should not try to. The projects that work start narrow and prove themselves.

1. Time one task honestly for a week. Not an estimate — an actual tally. The number is almost always higher than the guess.
2. Pick the task with the most repetition and the least judgement. Re-keying beats decision-making as a first target every time.
3. Automate that one path end to end, including the error cases. A half-automated process that still needs checking has saved nobody anything.
4. Measure the same task again after four weeks, then decide whether phase two is worth it on evidence rather than enthusiasm.

That sequence is deliberately unglamorous. It is also why the first phase usually pays for itself before the second one starts.

Frequently asked questions