Running a company on Excel: how many people before it breaks? 5 warning signs

With 5 people, Excel runs smoothly. At 15, someone is reconciling accounts past midnight every day. The problem isn't headcount. It's that "relying on people's memory" has hit its breaking point. Across 252+ projects, Excel always shows warning signs before it breaks. Owners just usually hold out until the last minute to notice.

Johnny Yang7 min read
Running a company on Excel: how many people before it breaks? 5 warning signs

Most owners who come to me aren't looking for "an impressive system." They come because Excel suddenly stopped cooperating.

Last month's numbers from sales don't match what accounting reconciled. The warehouse says there are 30 units in stock; a physical count finds 12. The core report one person built over five years, the one only they understand, goes dark when that person takes parental leave, and the whole department stalls.

This post isn't telling you to "switch systems right now." I'm Johnny Yang. I've been a serial founder for seven years, and my team has delivered 252+ projects across 32+ industries. Here's the conclusion up front: Excel isn't a bad tool. It just can't hold up when "scale" and "dependency" stack up at the same time. This post helps you check where your company stands: can it still hold, or is it already about to break?

The conclusion first: it's not headcount, it's "relying on memory" hitting its limit

Excel itself isn't the problem. In a company of three to five people, one spreadsheet is clear, and you can see at a glance who changed what.

The problem is that as the company grows, the data starts to "split up." Sales has a customer sheet, accounting has a reconciliation sheet, the warehouse has an inventory sheet, and none of them talk to each other. Every time they need to line up, someone has to "remember" to sync them. With more people and more departments, syncing by memory will break sooner or later.

When it breaks, no system tells you. You find out from a customer complaint, from books that won't reconcile, or from the owner digging through spreadsheets at midnight.

5 signs Excel is about to break

Sign 1: the same data has two or more "correct versions"

The customer list in sales doesn't match the one in accounting. The warehouse inventory numbers don't match purchasing's. You ask "which one is right," and the answer is always "let me double-check." That means there is no single source of truth anymore. Everyone is maintaining their own version of "the truth."

Sign 2: only one person in the company understands the core report

VLOOKUP stacked on VLOOKUP, macro stacked on macro. The spreadsheet is brilliant, but only one person can edit it. When that person takes leave or quits, the spreadsheet becomes a black box nobody dares touch. I've seen a company where the formula logic behind the core quotation sheet existed only in one senior employee's head. The day she left, the company's entire quotation process stopped for two weeks.

Sign 3: the same data gets typed in by hand two or more times

A customer places an order. Sales logs it in their sheet, accounting logs it again in the invoicing sheet, the warehouse logs it again in the shipping sheet. Typing the same data three times means that by the third time, there's already a chance it won't match the first two. And nobody will catch it unless the books don't balance at month-end. (I have a client with over 10,000 SKUs who was exactly like this: listing one product meant opening six files to cross-check, and wrong item numbers often surfaced only after a customer had ordered. The full story is in "How to integrate multi-channel inventory".)

Sign 4: the owner has become a "human VLOOKUP"

When anyone needs a number, their first reaction is "ask the boss," not "check the system." That means the company's information was never really structured. It lives in the owner's head and memory. When the owner takes a week off, the company doesn't just run a bit slower. Many decisions get stuck outright, because only the owner remembers where that number is or how that logic works.

Sign 5: you always find problems "after" they happen, never "before"

Excel won't pop up and tell you "this stock level looks wrong" or "this order is past its payment deadline." By the time you notice, it's usually because a customer called, or the books didn't balance at month-end. No early warning means the company is always "fighting fires after the fact," never "stopping them before they start."

Chart of Excel management load rising with company headcount

The red line is a company running purely on Excel. From around 15 people, time spent reconciling, searching, and firefighting climbs sharply, because the cost of syncing by memory grows non-linearly: double the people, and the relationships that need lining up don't double, they multiply several times over. The purple line is a company after its processes are digitized. The load curve is much flatter, because the data is already in sync and nobody has to reconcile it by hand.

Which stage are you in?

Company sizeHow well Excel fitsCommon symptomsRecommended action
1-5 peopleFully adequateAlmost noneNo rush. Just clean up the spreadsheet structure
6-14 peopleStarting to strainVersion conflicts, slower reconciliationMap your processes first. Find "which sheet breaks most often"
15-30 peopleClear warningHuman VLOOKUP, single point of failure (one resignation and work stops)Time to digitize core processes. No need to replace everything
30+ peopleHigh riskFirefighting after the fact, owner becomes the information bottleneckFull process review, phased implementation of systematized workflows

The real first step isn't rushing into a system

The easiest mistake an owner makes is seeing Excel's warning signs and jumping straight to buying an expensive system.

I've seen too many of these projects, and this is the pattern with the highest failure rate: the company's processes are a mess, they buy a system, and it's still a mess. Just a more expensive one that's harder to change. Before AI, the more important thing is to simplify your workflows, then digitize them. That's the first step that actually helps. Many processes grew out of "old limitations": data had to be entered twice because the old systems didn't connect, and the owner had to remember things because nobody organized them. What you should actually do is find the steps that should disappear and cut them. Once the process is straightened out, then it's time to ask whether you need a system. (I wrote about how to take that first step in "The first step in SME digital transformation". For the full picture on ERP, see "The complete SME ERP guide". If you're unsure whether inventory needs an inventory management system or an ERP, see "Inventory systems vs. ERP: what's the difference".)

We worked with a traditional manufacturer that had been in business for over 30 years. They had bought two ERP systems before, and both failed. It turned out the problem wasn't the systems. Nobody had first untangled their messy spreadsheet workflows. On the third attempt they worked with us. We spent time understanding what they actually did day to day, reshaped the processes, and only then built the system. Employee adoption went above 90%.

FAQ

Q: My company has only 8 people. Do I need to deal with this now? A: At 8 people you're usually still in the "strained but holding" stage. The most cost-effective move here isn't spending big on a system. It's taking stock: find the one spreadsheet that "only one person understands" and turn it into a process everyone can follow. Lowest cost, fastest payoff.

Q: Does Excel plus a bunch of add-on tools (Google Forms, Zapier, and so on) count as solving it? A: That postpones the problem. It doesn't solve it. A system stitched together from add-ons is often harder to maintain than a native system when staff change or processes shift, because nobody understands how all the logic is wired together.

Q: Won't switching systems make things messier, with employees unable to use it? A: That's exactly why you "simplify first, then digitize." If you force a system onto processes that haven't been straightened out, of course employees can't learn it and don't want to use it. That's the main reason traditional ERP implementations fail so often. Get the order right, and employees pick it up faster than you'd expect. (For when exactly to move from Excel to a system, I have a dedicated checklist of signs: "When to switch from Excel to ERP".)

Q: How long before I see results? A: If you only do the process review and cleanup first, you'll usually see a clear difference in 2-3 weeks (reconciliation time and duplicate data entry drop first). If you go on to systematize, it takes 6-12 weeks depending on complexity.

Next steps

Want to know exactly which stage your company is in, and which spreadsheet to tackle first? Two options:

  1. See more real cases: our library of 252+ projects. Find one in your industry and at your size.
  2. Book a free 30-minute diagnostic. Pick a convenient time slot online, and I'll help you pinpoint the part of your company that most needs digitizing first. You can also read the AI ERP page for the full approach, or the post on what's actually different between regular ERP and AI ERP.

Every Wednesday I also talk through this kind of behind-the-scenes reality on my podcast 《熊董不上班》 ("Johnny Yang Doesn't Go to the Office"). While growing a one-person company past NT$10,000,000 in revenue in ten months, I fell into the "just push through with Excel" trap myself. The full story is in there.

Found this useful? Pass it on
30 minutes · free

Bring the one thing you are stuck on — a free 30-minute diagnostic

You do not need to know what system you want. Tell Johnny Yang about the one thing that keeps blocking you, and in 30 minutes you will know whether to skip it, build it with coaching, or pay for a custom build. No pitch — if we cannot help, you will hear that straight.

Johnny Yang replies himself · limited spots each month · or just book a free 30-minute diagnostic

Johnny Yang (熊董)
Johnny Yang (熊董)
Founder, Brightstream Technology

Serial founder leading a small team that builds systems into an owner's everyday work.

As a founder
7 yrs
Projects delivered
252+
Industries served
32+
About Johnny