The Spreadsheet That Almost Broke a Business (And What Fixed It)

Picture this: it's a Monday morning, and your operations manager — let's call her Marta — sends you the weekly sales report. It's a spreadsheet. A big one. You scroll down. Then across. Then you notice the tab at the bottom that says "FINAL_v3_USE THIS ONE (2)."

If you've been there, you know the feeling. Part confusion, part dread, part quiet acceptance.

This is the story of how a mid-sized retail company went from that moment to having clean, live data at their fingertips — and what the road in between actually looked like.

It Started Innocently Enough

When the company launched, Excel made perfect sense. Ten products, two staff, one location. One tab for sales, one for expenses. Done.

But businesses grow. And with growth comes more data — more locations, more products, more staff adding their own tabs. Before long, the file had 47 tabs. There was a tab called "OLD - do not use," and three people were still using it.

Nobody planned for this. It just... happened. Like how a kitchen drawer starts with scissors and a takeaway menu, and five years later you can't close it.

The Formula That Broke Everything

Here's the thing about spreadsheets: they're incredibly powerful right up until they aren't.

At some point, someone — with the best intentions — built a master formula that pulled numbers from six different tabs, applied a calculation, and spat out the monthly margin figure. It worked beautifully. For about four months.

Then someone renamed a tab. One tab. And the formula, which had been referencing that tab by name, quietly started returning the wrong number. Not an error — the wrong number. It looked fine. It just wasn't.

Nobody noticed for six weeks. By then, the numbers had fed into three board reports and a supplier negotiation. The margin the business thought it had? Off by nearly 12%.

The Meeting Where Nobody Agreed

This is the part that almost every business owner I talk to recognises immediately.

The leadership team gathered to review quarterly performance. The CEO had one number for revenue. The sales manager had a different one. The finance lead had a third. All three were looking at spreadsheets. All three were confident.

The meeting lasted two hours. About forty minutes of that was actual discussion. The rest was people scrolling through tabs, saying things like "wait, are you including returns in this?" and "which version did you pull from?"

Nothing got decided. Everyone left tired. Someone sent a follow-up email that started: "Just to clarify what we agreed today…" — which is always a bad sign.

The Moment They Knew Something Had to Change

After that meeting, the operations director sat down and made a list. How many hours per week did the team spend maintaining spreadsheets? How many decisions had been delayed because the numbers weren't clear? How much trust had quietly eroded?

The answers were uncomfortable. And they pointed in one direction.

What the Solution Actually Looked Like

They didn't need something complicated. They needed something honest.

A developer (hi, that's the kind of work I do) connected their existing tools — their point-of-sale system, their accounting software, their stock management — into a single data pipeline. Think of it like plumbing: the water was already there, it just wasn't flowing to the right place.

On top of that, they got a dashboard. A clean, simple screen — accessible from any browser, phone or laptop — that showed the numbers everyone needed, updated automatically. Revenue today. Revenue this week. Margin by product. Stock levels. Staff hours.

One number. One source. Everyone looking at the same thing.

The first Monday after it went live, Marta didn't send a spreadsheet. She sent a link. The meeting that week took thirty minutes. Decisions got made.

The Honest Part

Was it more expensive than Excel? Yes — there was a build cost, and a small monthly cost to keep the data flowing. Was it worth it? Marta's team got back roughly four hours a week they'd been spending on manual updates. The leadership team stopped having the two-hour argument meeting. And the business stopped making decisions based on numbers nobody fully trusted.

For a growing business, that's not a luxury. That's just good foundations.

If your spreadsheet has more tabs than you can count, or if you've ever sat in a meeting where three people had three different answers — you're not doing it wrong. You just grew past the tool. That's actually a good problem to have.

---

If you'd like a second opinion on your project, I'm easy to reach — get in touch here.