We love spreadsheets. They're the most successful business software ever made, and for a young company they're exactly right. But every growing business crosses an invisible line where the spreadsheet stops being a tool and becomes a risk. Here's how to know you've crossed it.
1. There's a file called FINAL_v7
Version chaos means multiple people need to write to the same data at the same time — which is the precise problem databases were invented to solve. If merging versions is someone's job, you've crossed the line.
2. One person is the system
When only Sunita knows how the pricing sheet works, your business continuity plan is Sunita never falling ill. Software encodes the rules; spreadsheets encode them in someone's head.
3. Month-end means reconciling numbers
If sales, stores and accounts each keep their own sheet and month-end is the ritual of making them agree, you're paying days every month for the absence of a single source of truth.
4. Copy-paste is a daily verb
Data moving between sheets — or between a sheet and other software — by human hands is both your biggest time sink and your biggest error source. Integration is what systems are for.
5. You can't answer 'who changed this?'
Spreadsheets have no real audit trail. The first time a number changes and nobody knows when or why, you've learned the lesson auditors charge much more to teach.
6. Access is all-or-nothing
The sheet with salaries, margins and customer data is either shared with too many people or locked away from those who need part of it. Role-based access isn't a luxury; it's how growing teams work.
7. The sheet decides what you can't do
The clearest sign: ideas get rejected because 'the sheet can't handle it'. When your tooling starts vetoing your operations, the tool and the business have swapped places.
Three or more of these and the question isn't whether to move — it's what to move first. The answer is usually the sheet that the most people touch the most often. That's where a system pays for itself fastest.