The Question I Hear Most Often
"Do we need an ERP, or do we just need to clean up our spreadsheets?"
It's a fair question, and the honest answer is: it depends, and a lot of businesses guess wrong in both directions. Some spend six figures on an ERP they didn't need yet and their people quietly go back to Excel. Others white-knuckle a tangle of spreadsheets years past the point where it's costing them real money.
Let me give you a way to tell the difference—without a sales pitch.
Spreadsheets Aren't the Enemy
First, let's clear something up. Spreadsheets are one of the most useful tools ever built. They're flexible, everyone knows them, and for a small operation they're often exactly right. I'm not here to tell you they're beneath you.
But they have a quiet failure mode, and it's worth knowing about. Decades of research by Raymond Panko at the University of Hawaii—the most-cited authority on this—found that the large majority of real-world spreadsheets audited contained errors, with studies putting the share of flawed spreadsheets at roughly 88% and higher [1]. The reason is simple and human: people entering data and formulas make small, undetected mistakes at a steady rate, and once an error is buried in a sheet, it's genuinely hard to find [1][2].
That doesn't make spreadsheets bad. It makes them fragile at scale. One person, one sheet, low stakes—fine. Five people editing shared files that feed your quotes, inventory, and invoices—that's where the quiet errors start costing real money.
What an ERP Actually Is
ERP stands for enterprise resource planning. Stripped of the jargon, it's a single connected system that manages the core moving parts of your business—things like inventory, orders, production, purchasing, and invoicing—so they share one set of data instead of living in separate files [3].
The key word is connected. In a spreadsheet world, your quote, your job, your material list, and your invoice are separate documents that someone keeps in sync by hand. In an ERP, they're the same data seen from different angles. Update once, and it's right everywhere.
That's the whole value proposition. Not "more features"—fewer disconnects.
Five Signs You've Actually Outgrown Spreadsheets
You've genuinely outgrown spreadsheets—not just disorganized ones—when you see these:
- More than one person needs the same data at the same time. The moment people are emailing "final_v3_REALfinal.xlsx" around, you're maintaining copies, not data.
- You're re-typing the same information into multiple places. A quote becomes a job becomes an order becomes an invoice, and someone keys it in four times. Every re-entry is a chance for one of those quiet errors.
- You can't answer "where does this job stand?" without asking someone. If status lives in someone's head or a sheet only they update, you don't have visibility—you have a bottleneck.
- The errors are starting to cost real money. A wrong material count, a missed line item, a stale price—when mistakes stop being annoying and start being expensive, the math changes.
- You're afraid to change the spreadsheet. When a workbook gets so tangled that nobody dares touch the formulas, it's become a liability holding your business together with tape.
If none of these ring true, you may just need better-organized spreadsheets—and that's a perfectly good, cheap answer.
The Honest Middle Ground
Here's what the ERP salespeople won't tell you: there's a lot of room between "messy spreadsheets" and "full ERP." Plenty of small manufacturers get real visibility with a few connected tools—a shared job board, barcode-based inventory counts, mobile status updates from the floor—well before they need a full platform.
The right move is usually to fix the process first, then add just enough system to keep it honest, and leave room to grow into an ERP when the signs above actually show up. Buying a big platform to fix a broken process just makes the mess run faster.
And when you do outgrow spreadsheets, the goal isn't the fanciest ERP—it's one your people will actually use. The best system in the world is worthless if your shop floor avoids it and quietly keeps its own spreadsheet on the side. (That's the whole reason we built DhyanaERP the way we did—but whether it's us or someone else matters less than getting the timing and the fit right.)
How to Decide Without Guessing
If you're on the fence, don't buy anything yet. Map how information actually moves through your business first—where it gets re-typed, where it stalls, where the expensive mistakes happen. That map tells you whether the answer is "tidy up the spreadsheets," "add a couple of connected tools," or "yes, it's ERP time."
That's exactly what our Manufacturing & Operations consulting does: we fix the process first and tell you honestly which of those three you're actually looking at—no obligation to buy software from us.
Get in touch and tell us where your spreadsheets are starting to hurt. Sometimes the right answer really is "just organize what you have"—and we'll tell you when it is.
Sources & References
[1] Panko, R. R. What We Know About Spreadsheet Errors. University of Hawaii. Long-running research finding that the large majority of audited real-world spreadsheets contain errors (studies put the figure at roughly 88% and above), driven by steady, hard-to-detect human cell and formula error rates. panko.com/ssr
[2] Tuck School of Business at Dartmouth. A Critical Review of the Literature on Spreadsheet Errors. Academic review summarizing decades of spreadsheet-error research and why errors persist undetected. Tuck spreadsheet research (PDF)
[3] Gartner. Enterprise Resource Planning (ERP) — IT Glossary. Defines ERP as software that manages and integrates core business processes on a shared data model. gartner.com/en/information-technology/glossary
Steve Dickens is the founder of DhyanaTech. He spent years in construction and manufacturing before building software—and he still believes the right answer is sometimes a better spreadsheet, not a bigger system.