Operations

The memory problem: how to tell your business has outgrown spreadsheets

Spreadsheets are not the problem. A business that only runs because one person remembers how the spreadsheet fits together is the problem. Here is how to tell which one you have.

It is not the spreadsheet's fault

Every operation we have looked at in Tanzania and East Africa runs on spreadsheets somewhere, and that is fine. A spreadsheet is a good tool for a person to think with. The trouble starts when a spreadsheet stops being a tool and becomes the operation's memory: the only place that holds what was ordered, what was paid, what was promised, and how those three things connect.

A tool does not care who uses it. A memory only works if the person who built it is in the room. That is the actual line between a business that has good spreadsheets and a business with a memory problem, and it has nothing to do with how neat the columns are.

Five signs you have crossed it

  1. Two files, two truths. The finance sheet says one stock number, the store sheet says another, and reconciling them means someone walking to the store to count by hand. Nobody trusts either number on sight anymore.

  2. One person is the API. A formula, a macro, or a filing habit only one employee understands sits between a question and its answer. When they are on leave, the question waits for them, not the other way around.

  3. Payroll takes a day. Hours, advances, and deductions get copied by hand from three places into one, once a month, by someone who dreads the date on the calendar.

  4. You cannot answer "how much do we actually have" without a phone call. Cash, stock, and receivables live in different files kept by different people, so a same-day answer means interrupting someone else's day.

  5. You are afraid to let someone go on leave. Not because they are irreplaceable as a person, but because the operation would not survive two weeks without their particular spreadsheet habits. That fear is the clearest symptom there is.

Why it gets worse with growth, not better

A founder-run operation can carry a memory problem for a surprisingly long time at a small size, because the founder or one trusted employee simply holds more of the picture in their head. Growth removes that cushion. More transactions mean more chances for the two files to disagree. More staff mean more people who need an answer the spreadsheet cannot give without a translator. More funders, banks, or partners mean more people asking for numbers that have to be defensible, not just plausible.

So the memory problem does not announce itself early. It sits quietly under a small operation and then breaks loudly under a growing one, usually at the exact moment growth was supposed to be the reward for years of hard work. That is the pattern we see most often: the operation that finally lands the bigger contract or the expansion funding, and immediately finds out its own books cannot keep up with the opportunity it just won.

What to fix first

You do not fix a memory problem by buying software. You fix it by finding out exactly where the memory currently lives, one process at a time, before you touch a single tool. That is the order that actually works: steady the foundations that are actively breaking, build the systems that replace the fragile handoffs, then let the operation run without you re-checking it every week.

If you want a starting point today, our free operations check walks through the twelve questions we ask on every audit; most people who answer them honestly already know which of the five signs above is theirs. From there, an operations audit gives you a concrete, prioritized map of what to fix, and for most growing organizations that map leads to one connected system for finance, stock, and operations rather than three spreadsheets and a prayer.

Questions

Frequently asked.

How do I know if my business needs a system or just better spreadsheets?
If one person leaving for two weeks would put real numbers at risk, no amount of spreadsheet tidying fixes that. Better spreadsheets help when the problem is disorganization. A system is what fixes a problem that depends on a specific person being present.
What is the "memory problem" in a small business?
It is when the facts of how the business runs, what was ordered, paid, promised, and how those connect, exist only in one person's head or one person's file, instead of in a system anyone on the team can read and trust.
How long can a business run on spreadsheets before it becomes risky?
There is no fixed date. It becomes risky the moment growth (more transactions, more staff, more outside scrutiny from funders or banks) starts outpacing what one person can hold in their head, which is usually well before anyone notices.
What's the first step if we think we've outgrown our current systems?
Map where the memory actually lives before buying anything. Our free operations check is a fast way to do that yourself; an operations audit does it properly and hands you a prioritized plan.

Start here

Not sure where you stand?

Run the free 12-question operations check yourself, or tell us what you want to get running and we'll set up a short, no-pressure call.

Phone / WhatsApp
+255 788 266 166
Office
NIC Building, Boma Road, Arusha