The Spreadsheet That Runs Your Company

Every company has one.

A spreadsheet on one person’s computer that the business genuinely depends on. It has tabs nobody else understands. It has a formula somebody wrote in 2019 that everyone is now afraid to touch. It gets emailed around with version numbers in the filename, and the real version is whichever one that person happens to be looking at right now.

Nobody planned this. It started as a shortcut, it worked, and it kept working. That is how every one of these gets built.

How to find yours

Ask your team one question: if this person were out for two weeks, what would stop?

Not slow down. Stop.

The answers are always specific, and they are almost never what the org chart would suggest. The schedule that gets rebuilt by hand every Monday morning. The pricing workbook that decides what goes on every quote. The job costing file that is the only place labor and materials meet. The commission calculation. The compliance log that gets assembled the week before the audit. The list of who has access to what, maintained in a tab called Sheet3.

If your answer takes more than a few seconds, ask the person who does the work rather than the person who manages it. They will know immediately. They have been carrying it.

Why it is a problem, in the order it will bite you

It is a single point of failure attached to a human being. Vacation is a risk. A resignation is a crisis. We have watched a company spend three weeks reverse engineering a file because the person who built it left and the formulas had no notes.

It is probably not backed up the way you think. If it lives on a desktop, or in a folder one person created, it may not be in the backup at all. Owners routinely assume coverage that was never actually configured.

It has no access control worth the name. Anyone who was ever emailed a copy still has that copy. If it holds payroll figures, client lists, or pricing, that has quietly become a data question rather than a filing question.

Nobody can tell you whether it is right. A spreadsheet edited by four people over six years contains at least one error. The only question is whether it is a rounding difference or the reason a bid came in wrong.

It is a hiring ceiling. You cannot delegate work that exists only in one person’s head and one person’s file. This is the one owners feel constantly without ever naming it.

What to do, in a sensible order

Do not start by replacing it. The instinct is to go buy software. Software projects that begin with nobody understanding the current process end badly and expensively. The spreadsheet works. Respect that it works.

Get it off the desktop today. Into shared company storage, with real backup and real permissions. That takes about ten minutes and removes the worst of the risk before you have decided anything else.

Have the owner walk you through it. Record the conversation. Where does the data come from, what happens to it, who gets the output, what do they do with it. You are not looking for formulas. You are looking for the process the formulas are a shadow of.

Write the steps down in plain language. One page. This is the actual deliverable. A process somebody else can read is a process somebody else can run.

Then decide. Sometimes the answer is that the spreadsheet is fine, and now it is documented and backed up, which is a real win. Sometimes there is a system you already own that does the job properly. Sometimes it is worth automating the two or three steps that eat the most time and leaving the rest alone.

The test worth applying

The workflows worth changing share a shape. Somebody does it at least a few times a week, it follows the same steps every time, and the steps are boring. Frequency times tedium, with a known procedure.

Work that is genuinely different every time is judgment, and judgment is what you hired the person for. Leave it alone. The goal was never to automate a person. It was to stop spending them on retyping.

Most companies have three or four of these files. Finding them is a conversation, not a project, and it is the one we would want to have first.

Every business runs on something nobody wrote down. The only real question is whether you find yours on a quiet Tuesday afternoon or during somebody’s notice period.