Signs your company has outgrown Excel

Excel isn’t the problem. For calculations, analysis and quick checks, it’s hard to beat. The trouble starts when a spreadsheet that began as a helper becomes the company’s main system: orders, stock, quotes and deadlines all live in it, and a dozen people depend on it to do their jobs.

This doesn’t happen overnight. The company grows, the sheet gets new columns, new tabs and new copies, and at some point it starts slowing work down instead of helping. Here is how to recognise that point.

There are several versions of the truth

“Stock_FINAL.xlsx”, “Stock_FINAL_2.xlsx”, “Stock - Mark.xlsx”. When a meeting turns into a debate about whose spreadsheet is right rather than about the work itself, the spreadsheet has stopped doing its job.

The same goes for sales and the warehouse having different numbers for the same product, or management getting one report from finance and a different one from sales.

The same data gets typed in more than once

An order arrives by e-mail. The sales rep enters it into the orders sheet. The warehouse copies it onto their own list. Someone types it a third time into the invoicing software.

Every retyping costs someone’s time and is another chance to get the quantity, price or delivery address wrong. If people spend a large part of their day moving data from one place to another, that is work that adds nothing to the business.

Everything depends on one person

Almost every company that runs on Excel has someone who knows how the spreadsheet works. They know which formulas must not be touched, which tab gets updated on Fridays and why column H says what it says.

When that person is on holiday, work slows down. When they leave the company, part of the know-how leaves with them. This isn’t about trusting people. It’s that the process isn’t written down anywhere except in one person’s head and a file only they understand.

Month-end brings surprises

Management sees the real picture only after the month closes, and it isn’t always the picture they expected. The margin on a project is lower than everyone thought. More material was used than planned. A customer hasn’t paid two invoices and nobody noticed in time.

When numbers are pulled together by hand from several spreadsheets, they arrive late. When they arrive late, decisions get made on gut feeling.

Stock on the shelf doesn’t match the sheet

A sales rep promises delivery because the sheet says the goods are in stock. The warehouse goes to the shelf and finds nothing. Or the reverse: the goods are sitting in the warehouse, and purchasing orders them again because the goods receipt was never recorded.

If every stocktake turns up new differences that nobody can explain, your records aren’t following the real movement of goods. People then start working around them: sales phones the warehouse before every promise, and the warehouse keeps its own notebook because nobody trusts the sheet any more.

Quotes get lost

Quotes are written in Word or Excel and sent by e-mail. Nobody knows exactly how many are open, which ones are waiting for an answer or who needs a follow-up call. When a sales rep leaves, their quotes stay in their inbox.

A customer calls back a month later asking about a quote, and the search begins for which version was sent and at what price.

On top of that, nobody can say how many quotes turn into orders or why the rest don’t. The information exists, it’s just scattered across inboxes and folders on different computers.

The spreadsheets get slow and fragile

The file takes ages to open. Two people can’t work in it at the same time. Someone accidentally overwrites a formula with a value, and nobody notices until the numbers stop making sense. A macro written by a former colleague breaks after an update and nobody knows how to fix it.

These are technical symptoms, but they point to the same thing as everything above: the tool has outgrown its purpose.

What to do first

If several of these sound familiar, the first step isn’t buying software. It’s understanding exactly where the problem comes from.

Map the path of one order

From the first contact with the customer to the paid invoice, write down every step, who does it and in which tool. That list alone usually shows where data gets retyped and where it gets lost.

Write down how the process really runs, not how it’s supposed to. Phone calls, messages on someone’s mobile and notes stuck to a desk are part of the process too.

List the spreadsheets the business depends on

For each one, note who maintains it, who reads it, how often it’s updated, and what would happen if it disappeared tomorrow. Some will turn out not to matter. Others will turn out to be holding up the whole operation.

Decide what hurts most

It might be the warehouse, quotes, project tracking or work orders. That’s where to start. A system that handles one part of the business well is worth more than one that covers everything and that nobody uses.

Don’t try to fix everything at once

Roll out a solution for the first area, let people work in it, and only then move on. That way mistakes show up early, while they’re still easy to correct.

You don’t have to get rid of Excel along the way. It will stay useful for analysis and calculations. The goal is for your business data to live in one place, with Excel doing what it was made for.

Want a second opinion

Send us a description of how you handle orders, stock or quotes today and which spreadsheets you use for it. We’ll review it and suggest where it would make sense to start.