Almost every business starts on spreadsheets, and there’s nothing wrong with that. They’re flexible, everyone knows how to use them and they cost next to nothing. The trouble starts slowly. One sheet becomes five, three people start updating them, and one day you realise the business depends on a file nobody dares to touch.
Eight signs it’s time
- There’s a “final” version, and a “final v2”. Copies get emailed around and nobody is sure which one is right.
- One person understands it. When they’re on holiday, everyone else works around it.
- Things are typed into it from somewhere else. Orders from emails, hours from timesheets, totals from the accounting software.
- Nobody can tell who changed what. A number is wrong, and there’s no way to find out how it got that way.
- It’s useless on a phone. The people on site or on the road can’t use it, so they write things down and someone types them up later.
- Reminders depend on someone looking. Renewals, expiry dates and follow-ups get missed because the sheet can’t tell anyone.
- Simple questions take an evening. “Which customers are ordering less?” means exports, lookups and a late night.
- You’re nervous about it. If it went missing tomorrow, you’re not sure what you’d lose.
If three or more of these sound familiar, the spreadsheet is costing you more than it saves.
Why it happens
A spreadsheet is a blank page. That’s why it’s so useful at the start: it takes the shape of whatever you need. But a business needs more than a blank page once it grows. It needs one version of the truth, rules about who can change what, a history of what changed, and a way to nudge people when something’s due. Spreadsheets can be pushed into doing some of that, but they were never built for it.
What to do next
Don’t throw it away. That spreadsheet is the most accurate description of how your business really works, and it’s exactly what anyone building you something better should start from.
- Check for a ready-made product first. If there’s good software built for your trade and it fits how you work, use it.
- If nothing fits, build a system of record. One app holding the jobs, customers, staff and certificates in the shape your business needs, joined to your accounting software and the tools you already use.
- Keep spreadsheets for thinking. Forecasts, what-ifs and one-off analysis are what they’re best at.
The recruitment agency on our What we build page is a good example. Hours used to be chased by phone, typed into the payroll spreadsheet, then typed again into every client’s invoice. Now they’re confirmed once and feed payroll and invoices together.