How to Stop Running Your Business on Spreadsheets

Which spreadsheets run my business?

The sheets that run your business are the ones where a wrong cell costs money or a late update stalls a decision. Not every sheet counts.

Owners say it this way: “We are running a $20M business out of 40 spreadsheets and a bunch of WhatsApp chats.” The first job is to find out which of the 40 matter.

Ask each department head one question: “Which sheet would hurt most if it vanished tonight?” Write the answers on one page. Expect these:

• The pricing sheet sales uses to quote.
• The inventory count ops keeps next to the ERP.
• The AR chase list finance rebuilds each week.
• The production schedule on a shared drive.
• The owner’s Monday sheet that stitches it all together.

Yours will have more. Write them all down.

How do I map them in one afternoon?

Put every sheet in a table with six columns and fill it with the person who owns it. Do not do this alone.

Sheet name:
Owner (one name):
Who else uses it:
Where the data comes from:
How often it is updated, and by hand?:
What breaks if it is wrong:

The fifth column is the key. A sheet updated by hand every Friday is a Friday report. A sheet that pulls on its own is closer to a system.

Count the rows when you finish. That count is your first number. It tells you how much of the business sits in files instead of systems.

Which spreadsheets should I keep?

Keep a sheet when one person owns it and no one else depends on it. It holds their own thinking. A budget model, a quote calculator or a scratch analysis can all stay.

Use this test. Keep the sheet if all three answers are yes:

1. Does one person own and use it?
2. Does it read from a source and not copy from one?
3. Could the business run if it disappeared?

Good sheets are tools. Bad sheets are infrastructure. When a sheet becomes infrastructure, it needs to move.

Which spreadsheets should I retire?

Retire any sheet that copies data from another sheet or from a system. A copy ages the moment you make it.

The common ones:

• The “clean version” of an ERP export someone fixes by hand.
• The master customer list that three people keep separately.
• The weekly report built by pasting from four tabs.
• The tracker that mirrors something already in the CRM.

When you retire a sheet, name the replacement first. Point the people who used it to the new source. Then lock the old sheet to read-only for 30 days. If nobody screams, archive it.

Which spreadsheet do I move first?

Move the sheet that costs the most hours each week, then the one that feeds the most other sheets. Rank by hours first.

Score each remaining sheet on a 1 to 3 scale:

Question	1	2	3
Hours a week to maintain	Under 1	1 to 4	Over 4
People who depend on it	One	Two or three	Four or more
Decisions or payments it drives	None	Some	Many

Add the three scores. The highest total moves first. In most companies this is the owner’s Monday sheet or the AR chase list. Our guide on taking reports off your desk covers that first move.

Move one sheet at a time. Let it run beside the old one for two weeks. Compare the numbers. When they match, retire the old one.

What does it look like when it works?

An eight-figure consumer brand we worked with replaced 47 spreadsheets. Examples describe particular client projects, not a prediction of your results.

Sheets were not the goal. The goal was to stop asking “which version is right.” Each retired sheet removed one place where numbers could drift.

Before you move anything, wire the sources into one place. Sheets that read from one place stay accurate. Sheets that copy from tools drift.

If you want a team to do the mapping and the move, the Business Brain is the name for the finished version. The map in this guide is yours either way.