A spreadsheet is the right tool for a trade business right up until the moment it isn't. The honest trigger point isn't a headcount or a turnover figure — it's the day you lose or misprice work because the spreadsheet couldn't remind, calculate, or show you something in time.
This isn't a "spreadsheets are bad" post. Spreadsheets are free, familiar, and genuinely fine for a sole trader sending a handful of quotes a month. This is a post about the specific failure points — so you can switch when it's time, not a year after you should have.
What a Spreadsheet Does Well
Credit where it's due. For a certain stage of business, a spreadsheet is genuinely the best choice:
- Zero cost — the strongest competitor any software has
- Total flexibility — you can track anything, your way
- No learning curve — you already know Excel or Google Sheets
- No vendor lock-in — your data is your file
If you work alone, send fewer than ~10 quotes a month, and keep on top of follow-ups in your head, a spreadsheet may still be the right answer. The case for changing isn't ideological. It's arithmetic.
The Six Signs It's Time to Switch
1. Two people need the same file
The moment a second person edits the same sheet, you get conflicts: overwritten cells, "whose version is right?", and a folder called Customers_FINAL_v7_AH.xlsx. Spreadsheets weren't built for concurrent editing. A CRM gives everyone the same live record with a change history.
2. Quotes take longer than the work
If building a quote means copying last month's file, updating prices from memory, checking the VAT maths by hand, and formatting it in Word — that's 30–45 minutes per quote. At five quotes a week, that's most of a working day, every week, spent on admin a system does in minutes.
3. Follow-ups live in your memory
A quote goes out Tuesday. Did they reply? Did you chase it? A spreadsheet has a "status" column that's accurate exactly as long as someone updates it manually — which is to say, never quite. Missed follow-ups are the most expensive line item in most trade businesses: the work was already 80% won.
4. You can't answer "are we actually making money?"
This is the big one. A spreadsheet can record costs against jobs — if you built it that way and if everyone logs everything. In practice, quoted vs actual profit per job is the first thing spreadsheets stop delivering, and the reason most owners start looking. (We cover what proper job costing looks like in a separate post.)
5. The VAT maths is manual
Manual VAT calculations on quotes are how you send a quote that's quietly wrong — and either lose margin or lose trust. If your spreadsheet relies on someone multiplying by 1.2 correctly, every quote is a small gamble.
6. You're about to hire
A new team member can't run your business from a spreadsheet only you understand. The colour-coding, the tab names, the "Dave column" — that's tribal knowledge. A system with roles and a shared pipeline is how a new starter becomes useful in a week instead of a month.
Scoring yourself: two of these and it's worth a look. Three or more and the spreadsheet is already costing you more than software would.
What the Switch Actually Involves
The fear is a six-week IT project. It isn't — or it shouldn't be. A realistic switch:
| Step | Time | What you do |
|---|---|---|
| 1. Contacts | An afternoon | Export your customer list to CSV, import, dedupe |
| 2. Products/services | An hour | Prices, cost prices, VAT rates — your price list, entered once |
| 3. Pipeline | An hour | Set stages that match how you sell (most trades need 5–7) |
| 4. First quote | 15 minutes | Build one real quote end-to-end, PDF included |
| 5. Team | 30 minutes | Invite staff, set who sees what |
Total: one to two days, mostly data cleaning you'd benefit from anyway. The trap to avoid is trying to replicate every spreadsheet formula. You're not migrating a model — you're replacing manual work.
What to Look For in the Thing You Switch To
Not all CRMs fit trades and service businesses. The shortlist:
- Quotes with real VAT handling — UK rates, per-line override, professional PDF
- Job tracking after the quote — the quote shouldn't be the end of the record
- Cost logging against jobs — materials, labour, subcontractors, fuel
- Simple enough to learn in an afternoon — configurability is where implementations go to die
- Priced for your size — per-user enterprise pricing makes no sense at five staff
We built SME System around exactly this list — UK VAT and quoting first, job costing behind it, up and running in an afternoon. If you're comparing options, our guide to CRM for tradespeople covers what to look for in more detail.
The Cost of Waiting
Every month on an outgrown spreadsheet has a price: quotes sent late or wrong, follow-ups dropped, and — the quiet one — pricing decisions made blind because you can't see which jobs actually made money.
The switch costs a day or two. Waiting costs more, every month, compounding. If you recognised yourself in three or more of those six signs, this week is a good time to start a free trial and import your first contacts.