Almost every small business runs on spreadsheets at some point. They're flexible, cheap and everyone already knows how to use them. For a long time, that's exactly the right tool.
The trouble starts quietly. A file gets copied, a formula breaks, an order gets typed in twice. Nobody decides to outgrow spreadsheets — it just happens as the business grows. Here are the five signs we see most often when small businesses come to us.
01Two people, two versions of the truth
“Stock_final_v3.xlsx” lives in someone's email, and a slightly different copy lives in the shared drive. When two people give different answers to “how many do we have left?”, the spreadsheet has stopped being a system and become a guess.
02Someone re-types the same data every day
Orders come in through a website, a delivery app or a phone call, and someone copies them into the sheet by hand. Every re-typed line is time spent and a chance for a mistake. Double entry is the clearest sign that two systems should be talking to each other.
03Only one person really understands it
There's a tab nobody touches and a formula only one colleague can fix. When that person is on holiday, the business slows down. Knowledge that lives in one head — or one cell — is a risk, not a process.
The goal isn't to get rid of spreadsheets. It's to stop running the business on them.
04Customers find the mistakes before you do
A room gets booked twice. An item sells after it ran out. A delivery goes to an old address. When errors reach customers first, the cost isn't just the fix — it's trust.
05Reports take a day, so nobody reads them
If pulling last month's numbers means an afternoon of copying and checking, the numbers arrive too late to act on. Good software turns “let me put that together” into a page you open on your phone.
What to replace first
You don't need a big project. The businesses that move smoothly do it in small steps:
- Start with the process that hurts most. Usually orders, bookings or stock — not the whole business at once.
- Look for an existing tool before building one. A good POS or booking system may already fit. Build custom only where your process is genuinely different.
- Keep the spreadsheet as a report, not the source. Export to it for analysis; stop typing into it as the system of record.
- Move one team at a time. Run old and new side by side for a short period, then switch.
- Spreadsheets are a fine start, a risky system of record.
- Double entry and “one person who knows” are the loudest warnings.
- Replace the most painful process first, one team at a time.
- Operations
- Spreadsheets
- Small business
