The spreadsheet that runs your business is a liability

There's a file. Everybody knows which one. It's got eleven tabs, three colors of highlighting nobody remembers the meaning of, and a name like Jobs_Master_final_v4. Your whole operation runs through it. Schedule, pricing, who owes what, which crew is where. And one person really understands how it works. A business running on spreadsheets feels organized, and that feeling is exactly the problem.

The spreadsheet was a smart move

Give the file its credit, because it earned it. When you started, you didn't have the money for software or the patience to set any up. So you opened a blank sheet and built exactly what you needed, no more. It fit your business like a glove because you made the glove.

And it worked. It tracked the jobs, it did the math, it kept the chaos in rows. Somebody on your team got good at it, maybe you, and the business grew on top of it. That's not a mistake. That's resourcefulness.

But the business you built it for is gone. It's two or three times bigger now, with more people touching the file and more money riding on every cell. You kept growing. The file kept getting longer. Nobody ever stopped and asked whether the thing holding up the house was built for a house this size.

It wasn't. It was built for a shed.

It doesn't break the way you think

Software that breaks usually tells you. It crashes, it throws an error, it goes down and somebody calls. A spreadsheet doesn't do any of that. It breaks silently. A formula drags one row too short. Somebody pastes over a cell that held a calculation. A cost column stops getting updated in March and nobody notices until October. The file opens fine. The numbers look fine. They're just wrong.

This isn't a small-business problem. When JPMorgan's own task force went through the London Whale trading loss, it found a risk model run through Excel by copying and pasting data between sheets by hand, and a formula that divided by a sum instead of an average. One of the biggest banks on earth, a loss in the billions, and part of the story was a spreadsheet nobody had checked. If their file could lie to them, yours can lie to you.

Any mechanic will tell you a gauge you've never checked against anything isn't a gauge. It's a decoration that happens to point at numbers. Your spreadsheet is a dashboard full of gauges that have never been tested, and you make real decisions off them every day.

It never crashes. It just quietly lies.

What a business running on spreadsheets actually costs

The cost hides in two places, and neither shows up on a bill.

The first is time. Say your office manager spends six hours a week moving numbers between three sheets, fixing what didn't match and chasing down who changed what. At a loaded cost of $35 an hour, that's $210 a week, or $10,920 a year, spent keeping the file alive. That's an example, and it's conservative, because it doesn't count your hours spent double-checking her work before you trust it.

The second is the bad number you didn't know was bad. Say, as a second example, your material costs went up 8% and the cost column in your quoting tab never caught it. If you quote $400,000 of work off that tab over a year, you just gave away $32,000 of margin, one quote at a time, and every one of those jobs looked profitable on the sheet. Nobody stole it. The cell just stopped telling the truth.

Then there's the person. The file has an author, and the author is the system. When she's out sick, the schedule doesn't get built. When she quits, she takes the meaning of every color and every hidden column with her. You didn't build a tool. You built a hostage situation with gridlines.

Why adding more to the sheet makes it worse

When the file starts struggling, the instinct is to fix it with more file. Another tab for the new service line. A second copy so two people can work at once. A column that checks the other column. Each one is a sensible patch.

But every patch adds a new place for the truth to split. Now there are two copies and they don't agree. Now the check column has its own broken formula. Now there's a version on someone's laptop that's three days newer than the shared one. You've got the same problem with more surface area.

Remembering isn't a system, and neither is a file that only works because somebody remembers how it works. A spreadsheet is a calculator with a long memory. It doesn't know who's allowed to change what. It doesn't know when a number is stale. It doesn't stop anybody from doing anything. It holds whatever you type, right or wrong, with the same straight face.

Every patch makes the file heavier. Not one of them makes it honest.

Nobody but the author can explain it

Pick the one spreadsheet your business would stop without. Then ask three questions, honestly.

Could anyone other than its author open it and explain every tab without making a phone call? If nobody could, the file isn't a system. It's a person, wearing a file.

Which number in it would you bet payroll on? Not the one you think is right. The one you know is right, because you know where it came from and when it was last checked. If you can't name one, you're steering by numbers you already don't trust.

And if someone changed a cell in it today, by accident, what would catch it? If the answer is nothing, or the answer is you, eventually, you've found where your business is bleeding without a sound.

The fix is boring, and it holds

A better spreadsheet won't do it, and neither will buying the shiniest software on the market and dumping your mess into it. Plenty of founders do that and end up with the same chaos in a more expensive container.

The fix is structural. The information your business runs on lives in one place, goes in once, has an owner, and breaks loudly when something's wrong instead of quietly drifting. Nobody has to remember what the yellow highlighting means, because nothing depends on anyone remembering.

When that's in, the change is mostly quiet. Your office manager gets six hours of her week back. Quotes come off costs that are current. The person who built the file can go on vacation, and the schedule still gets built. You stop double-checking, because there's nothing left to double-check.

Let the file retire

The hardest part isn't the switch. It's admitting the thing that saved you is now the thing holding you back. That file was proof you could figure it out with nothing. You're attached to it for good reason.

But a business you're building to last can't run on something only one person can explain. The spreadsheet got you from zero to here. It can't get you from here to the next size up, and it was never supposed to.

Thank it. Then stop letting it run the place.