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 it 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 the three 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 line between a business with 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.

  2. One person is the API. A formula 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.

  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.

  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.

  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

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

So the problem does not announce itself early. It sits quietly under a small operation and breaks loudly under a growing one, usually the same month you landed the bigger contract that was supposed to be the reward.

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 tool. 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.

Our free operations check runs the twelve questions we ask on every audit. Most people who answer them honestly already know which of the five signs is theirs. From there, an operations audit gives you a prioritized map of what to fix.

Field notes by email

Get the next one.

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