Where Does the Company Keep Its Brain? Mapping the Informal Systems That Run Your Business
Photo: Moscow School of Management SKOLKOVO, CC BY-SA 3.0, via Wikimedia Commons
Every company of any size runs on two systems. The first is the one leadership believes in: the CRM, the ERP, the dashboards, the documented processes. The second is the one that actually works — a patchwork of personal spreadsheets, remembered formulas, and institutional knowledge held by a handful of people. The first system gets budgeted. The second gets relied upon.
The trouble with the second system is not that it exists. Informal workarounds are often a sign of intelligent, committed employees solving real problems quickly. The trouble is ownership. Ask five executives who maintains the company's true cost model, and you will likely get five different answers — or five confident nods toward a person, not a place.
The Audit Nobody Schedules
Begin with a simple, uncomfortable exercise. For each critical business function — pricing, margins, cash forecasting, customer history, vendor terms — write down where the authoritative answer lives. Not where it should live. Where it lives today.
In most small and mid-sized companies, the honest answers cluster into three categories. First, the lone spreadsheet: a file on someone's desktop, revised over years, containing logic that exists nowhere else. Second, the tribal expert: the controller who knows why the Kansas City account gets a different freight allowance, the sales lead who can recite which customers pay in sixty days. Third, the fossil: a documented process that everyone quietly abandoned because reality moved on.
The risk is not evenly distributed. A lone spreadsheet with a backup and a second person who understands it is a nuisance. The same spreadsheet in one person's head, with no backup and no successor, is a single point of failure wearing the costume of efficiency.
Stress-Test the Structure
Once mapped, apply three tests to each piece of critical knowledge.
The two-week test. If this person were unavailable for two weeks, would the function degrade, pause, or collapse? Be honest. Most owners discover that quote generation, not anything glamorous, is the true dependency.
The reconstruction test. Could a competent newcomer rebuild this logic from what is written down? If the answer requires a phone call to a former employee, you have your answer.
The acquirer test. If a buyer's due diligence team asked to see your pricing methodology and customer concentration data tomorrow, how long would it take to produce — and how confident would you be in it? Companies preparing for a sale routinely discover that their most valuable numbers were never assets at all. They were habits.
Consolidation Without Bureaucracy
The remedy is not a six-month software implementation. It is a disciplined sequence:
- Name the sources. Create a one-page inventory of critical data and its current home. Circulate it. Disagreement is the point — where executives disagree about where numbers live, you have found a governance gap.
- Document the logic, not just the outputs. The formula matters more than the figure. Why does gross margin on government work get calculated differently? Write down the reasoning, the exceptions, and the person who arbitrates disputes.
- Establish a second reader. For every critical file or process, designate one other person who reviews it quarterly. Not to do the work — to understand it. Redundancy is cheaper than rescue.
- Set a sunset for the fossils. Where documented processes and reality have diverged, decide which one wins. Half of what passes for tribal knowledge is simply the absence of a decision.
- Review annually. Add the inventory to your year-end close. Systems drift; the map needs updating.
The Deeper Point
There is a leadership dimension here that goes beyond risk management. When critical knowledge lives in one head, that person carries invisible weight — and the company carries invisible leverage. Consolidating the brain is not an accusation of hoarding; handled well, it is a gift. Employees who no longer serve as the sole custodian of a spreadsheet are freed to do the work only they can do.
The companies that survive transitions — a departure, a system failure, a sale — are rarely the ones with the best software. They are the ones that could answer, without hesitation, the question every owner should be able to answer: where does this company keep its brain?
