Every business we meet starts the same way: one spreadsheet that worked beautifully — until it didn't. More people joined, more tabs appeared, formulas got pasted over, and one day two "final" copies disagreed about how much money came in last month.
The moment a spreadsheet stops being a tool
Spreadsheets are brilliant for analysis and terrible as shared operational systems. The failure points are always the same:
- No access control. Everyone who can type can also delete. A salesperson can see — and edit — the salary column.
- No history. When a number changes, nobody knows who changed it, when, or what it said before.
- No validation. A date typed as text, a quantity with a comma, a customer entered three ways — every report downstream quietly rots.
- No workflow. "Pending" and "approved" live in a colour code someone invented, and the approval itself happens in a chat thread the spreadsheet never sees.
What replaces it
Not a bigger spreadsheet — a small system: a login for each person, roles that decide who sees and edits what, forms that refuse bad data, dashboards that read from one source of truth, and an activity log that remembers everything. That is the whole recipe. It can run on Google Sheets as the database with an Apps Script web app on top (zero hosting cost), or on PHP and MySQL when you want your own server — the discipline is what changes, more than the technology.
The honest test
Ask one question: if this file disappeared tonight, what would break tomorrow? If the answer is "the whole business", that file has been your ERP for years — it just never got promoted. Systems that important deserve logins, backups and an audit trail.
When you are ready to promote yours, here is exactly how the process works — and a quote costs nothing.