About the business
I run a service business with about fifteen people. Orders, customers, staff schedules and payments all lived in spreadsheets. For years, that worked. Honestly, I was proud of how little it cost.
The problem: five small things, over a few months
Nothing broke in a single day. It crept up.
1. The same data in two places. A new customer went into the order file, then again into the billing file. Sometimes the spelling didn't match, and I couldn't connect the two.
2. Too many versions of one file. We had "final", "final2" and, my favorite, "final_USE_THIS". Two people edited different copies, and one set of changes simply vanished.
3. One person who understood the file. When she went on leave, nobody dared change anything.
4. Mistakes found late. A wrong price made it onto an invoice. We found out when the customer called.
5. No quick answers. "What's due this week?" or "Who hasn't paid?" took an hour of filtering and ended in a guess.
Any one of those, I could live with. Three of them at once was a business running on luck.
What we did: move one thing first
I didn't try to change everything. We picked the one sheet that caused the most daily pain, which was the order file.
Before building anything, we mapped how an order really moves, from the first call to the final payment. We cut steps that only existed because of the spreadsheet. Then we built a simple application that keeps each order once, in one place, with a person's name against every change.
The other sheets stayed. We only moved the next one after the first was working properly. Some small sheets are still spreadsheets today, and that's fine. A spreadsheet one person keeps for themselves is often the right tool.
The result: fewer repeats, fewer surprises
An order goes in once, and everyone sees the same version. A wrong price gets caught when it's entered, not when the invoice goes out. "What's due this week?" is a screen now, not an hour. And when someone's away, the work doesn't stop with them.
If you're nodding along, the next question is where to start. Here's how to find the one workflow worth moving first, and what it looks like when several tools finally become one.
If two or three of these signs sound familiar, tell us which spreadsheet hurts most. We'll tell you honestly whether it needs software yet, or whether a cleaner spreadsheet is enough.
Free tool audit
List the tools you pay for and how work moves between them. We'll show you what overlaps, what to cut, and whether building anything is worth it.
- Free
- Reply within 24 hours
- No obligation