Guides & checklists · Guide · Part 2 of 4
Five signs the spreadsheet is now running your business
Spreadsheets are a smart place to start. These are the five warning signs that one has quietly become the backbone of the business, and what to do about each.
In brief
- The signs: no single true version, data typed twice, one person who understands it, slow answers, and access you cannot safely give.
- One or two signs: clean the sheet up. Three or more: compare a ready-made tool with a custom build.
- Whatever you choose, move the data once, carefully, and retire the old file.
Almost every small business runs on a spreadsheet at some point. A print shop tracks jobs in one, a restaurant tracks orders, a salon keeps clients and colour formulas. That is sensible: spreadsheets are cheap, flexible and everyone knows the basics.
Trouble starts when the sheet stops being a list and becomes the system everything depends on. It was never built for that job. These five signs tell you it has happened.
1. Nobody is sure which version is real
There is "Jobs.xlsx", "Jobs FINAL.xlsx" and "Jobs FINAL Maria edits.xlsx". Someone emailed a copy last week. When a customer calls about an order, two files disagree.
Move to one shared file in the cloud, archive the rest, and turn on version history so you can see who changed what. If people still keep private copies because the shared one is slow or confusing, that is your cue for a real tracker with one source of truth.
2. The same information is typed more than once
An auto shop writes the customer's name and car on a work order, types it into the sheet, then types it again into the invoice. Every retype costs time and invites a typo. Map where each piece of information starts and where it ends up, then ask whether it could be entered once. A web form, a quote page or a booking page can often feed the sheet directly.
A useful habit: every time you catch yourself copying the same data between two places, write it down. After a week, that list is your automation plan.
3. Things break when one person is out
Only one person understands the formulas. Only one person knows that column H means "paid" and yellow means "rush". When they are off sick, work stalls. Write a short guide to what each column means, replace colour codes with a Status column and a drop-down, and lock formula cells. If the sheet still needs an expert to run it, it is time for screens with rules anyone can follow.
4. Simple questions take an hour
How many jobs are late? Who has not paid? How did last month compare with the one before? If each answer takes an hour of filtering, the sheet is holding your information hostage. Pick the five questions you ask every week, make sure the data behind them is recorded the same way every time (real dates, consistent customer names, numbers without notes in them), and build a summary tab that answers them on its own.
5. People need access you cannot safely give
A customer wants the status of their order. A part-timer needs today's schedule but should not see pay rates or phone numbers. With one big file it is all or nothing. Split sensitive information into separate files with tighter sharing. If customers keep calling for updates, a status page or automatic texts will save the calls. If staff need different views of the same data, you need a tool with roles and permissions.
Exhibit 1What your score suggests
| Signs you recognise | Likely next step |
|---|---|
| One or two | Clean up the sheet with the fixes above |
| Three or more, common process | A ready-made tool for your trade, set up properly |
| Three or more, unusual process | Connect what you have, or build a tracker around how you work |
Ready-made or custom?
Outgrowing a spreadsheet does not have to mean building software. A ready-made tool is the better choice when your process looks like most businesses in your field, when you mainly need one shared list with statuses and reminders, or when you are still working out how you want to run things.
Custom work makes more sense when the way you work is what sets you apart, when you pay for several tools that do not talk and staff copy between them daily, when customers, staff and partners each need their own view, or when mistakes are expensive enough that the software should enforce the rules instead of relying on memory. There is a middle path too: keep the tools you have and connect them, so data entered once shows up everywhere it is needed.
Whichever way you go, move the data once and carefully, check it against the old sheet, and then retire the old file so nobody drifts back to it. That is the core of our spreadsheet replacement work, and often the start of an order and job tracker.
