When a spreadsheet stops being enough

Most businesses start on a spreadsheet, and that is a sensible place to start. It costs nothing, everyone knows how to use one, and you can change it the moment your business changes.

The trouble comes later, and it comes quietly. Nobody decides that the spreadsheet has failed. The work around it simply gets heavier, until a large part of the week goes into keeping the sheet correct instead of running the business.

Signs you have outgrown it

More than one version exists. Someone saved a copy to work on, and now there is "Stock FINAL", "Stock FINAL 2" and the one on the owner's phone. Nobody is sure which is right.

The same thing is typed more than once. A sale goes into the sales sheet, then the stock sheet, then an invoice, then a message to the customer. Every extra copy is a chance for a mistake.

Only one person understands it. The sheet works because one person knows which cells not to touch. When they are away, things stop.

You cannot answer simple questions quickly. What sold best last month? Who still owes us money? If the answer takes an afternoon of filtering and adding up, the data is there but it is not working for you.

Mistakes reach customers. A wrong price on a quote, an item promised that was already sold, a payment recorded against the wrong name.

It does not connect to anything. Payments arrive on M-Pesa, orders arrive on WhatsApp, and somebody has to copy each one across by hand.

One of these on its own is normal. Three or four together usually mean the spreadsheet is now costing more than it saves.

What comes after a spreadsheet

The answer is not always custom software. There are three steps, and the right one depends on how unusual your way of working is.

1. Tidy the spreadsheet. One shared file, clear rules about who edits what, and a few locked cells. If the business is small and stable, this may be all you need.

2. Use a ready-made tool. Accounting, point of sale and booking are common needs with good existing products. If your process is close to how most businesses work, start here.

3. Build something that fits. When your process is specific to you, or the pieces need to talk to each other, a small system built around how you already work pays for itself. Typically that means one place to record a sale, with stock, invoices and customer messages updating on their own.

Start with one problem

The businesses that do this well rarely replace everything at once. They pick the task that wastes the most time or causes the most mistakes, fix that, and move to the next one.

A useful exercise: for one week, write down every time someone copies information from one place to another. The longest line on that list is where to begin.

If you would like a second opinion on where your own spreadsheet is holding you back, tell us about it. We are happy to say when a simpler fix will do.