A spreadsheet is a sensible way to start running a business. It is quick, flexible and familiar. The question is not whether spreadsheets are bad. It is whether yours is still doing the job, or whether the business is now working around it.
Spreadsheets are not the enemy
A well-kept spreadsheet with one owner, one location and a clear purpose can run a small operation for a long time. Replacing it too early means paying for something you do not yet need.
The trouble starts when a spreadsheet quietly becomes the only record of who is doing what, for which customer, at what cost, and more people depend on it than the person who built it. At that point it is a system of record, but it has none of the protections a system of record would have.
A good spreadsheet has a few things in common. It has one owner, it lives in one place, it is backed up, and a short note explains what each tab is for and who changes it. If yours has all four, it may last longer than you expect.
Eight signs it is time to look again
None of these is a reason to panic on its own. Three or more together is worth taking seriously.
- More than one version of the truth. Two people hold two copies, and when they disagree nobody knows which is right.
- One person understands the file. If they are away, or leave, the business cannot work out what the formulas do.
- The same information is typed twice. Job details go into the spreadsheet, then into the accounts, then into a report.
- Status needs a phone call. To find out where a job is, someone has to ask the person doing it.
- Month-end surprises. You find out a job lost money, or was never invoiced, when it is too late to act.
- Evidence cannot be found. A photo, certificate or sign-off exists somewhere, but nobody can say where.
- Errors turn up after the invoice. A wrong figure or missing item is discovered by the customer rather than by you.
- Growth is limited by admin. Taking on more work means taking on more people to keep the paperwork moving.
If you are unsure, ask the people who use the spreadsheet every day to say which of these they recognise. Count how many sound like your business. If it is three or more, the spreadsheet may now be costing you more time than it saves.
You can test most of these in a week without changing anything. The table suggests one quick check for each.
| Sign | How to check it this week |
|---|---|
| More than one version of the truth | Ask two people for the latest figure on the same job and compare their answers. |
| One person understands the file | Ask someone else to explain how one key tab works. |
| The same information typed twice | Follow one job's details and count how many times they are entered. |
| Status needs a phone call | List the last five questions about job status and who answered each. |
| Month-end surprises | Take last month's closed jobs and note any whose figures changed after the month ended. |
| Evidence cannot be found | Choose one completed job and time how long it takes to find its evidence. |
| Errors after the invoice | Look at recent corrections to invoices and note what caused each one. |
| Growth limited by admin | Ask what the next hire would spend their time on, and how much of it exists because of the file. |
What to do first
Do not start by shopping for software, and do not try to replace everything at once. Start with a single process, followed end to end.
- Pick the process that causes the most pain. One candidate is the route from a completed job to an invoice.
- Write down every step, who does it, and where the information lives at each point.
- Mark every place where information is typed again, waits for someone, or cannot be found.
- Ask the people doing the work what slows them down. They usually know.
This takes a few hours and costs nothing. It often shows that part of the problem is the process, not the tool.
One more test is worth running. Ask what would happen if the main spreadsheet vanished tomorrow. How long would it take to rebuild, and from what? If the honest answer is "we are not sure we could", you have found how much the business depends on it.
Deciding what comes next
Once the process is mapped, fix what is cheap to fix first: a clearer way of working, one owner and a tidier file. Whether you then need a packaged tool or something built around how you work is a separate decision. Our guide to choosing between bespoke and off-the-shelf software sets out how to make it, including when we would tell you not to build.
What a system can and cannot do
A system can give you one record of each job, one live status, and a place for evidence and approvals. Our job management software is a configurable foundation for that; anything more specific, such as variations tracking or site forms, is built to your requirements.
It will not fix a process nobody understands, and it will not remove the need for people to enter information accurately. Moving a messy process into software gives you a faster mess.
Whatever you decide, write down how the work flows today before you change it. That record is useful whether you tidy the spreadsheet, adopt a packaged tool or commission something built for you, and it makes any conversation with a supplier much shorter.
If you would like to see what manual work is costing you before deciding anything, the business-case calculator lets you use your own figures. You can also read how late invoicing builds up in our article on the time between job completion and invoicing.