CRM for small businesses: when the spreadsheet stops working

A spreadsheet is a perfectly good CRM. Plenty of small businesses run on one for years, and moving to software too early just swaps one place nobody updates for another.

The trouble starts quietly. An enquiry arrives on a busy afternoon, nobody adds it, and nobody chases it. So the real question is not which CRM to buy. It is what has to happen to every enquiry between the moment it arrives and the moment it becomes paid work, and whether your current set-up makes that happen without anyone having to remember.

What a CRM actually does

CRM stands for customer relationship management. Strip away the features and a CRM does four jobs:

• One record for each customer. Name, contact details, what they asked for and where they found you.
• The history. Every call, email, quote and booking in one place, so anyone can pick up where the last person left off.
• The next step. What needs doing, by whom and by when.
• The view across all of it. How many enquiries came in, where they came from, and how many became paying work.

The last job is the one spreadsheets do worst, and the one that tells you where your next customer is most likely to come from.

When a spreadsheet is still enough

Stay with the spreadsheet if all of these are true:

• One or two people handle every enquiry.
• Enquiries arrive in one or two places, such as email and the phone.
• You can see every open enquiry on one screen.
• You cannot remember the last time a follow-up was forgotten.

If that is your business, keep the spreadsheet, add a status column and a next-action date, and look at it every morning. That is a CRM, and it works.

Signs the spreadsheet has stopped working

• Follow-ups depend on memory. Quotes go out and nobody chases them until the customer has gone elsewhere.
• The same details are typed twice. A website form arrives by email, then somebody copies it into the spreadsheet, then into the diary, then into the invoice.
• There are two versions of the truth. One person's copy says the job is booked; another's says it is still a quote.
• Nobody can answer the simple questions. How many enquiries came in last month? Where from? How many became work?
• When someone is off, the history goes with them. The detail lives in one person's inbox or head.
• Enquiries arrive in too many places. Website, email, phone, WhatsApp and social messages, with no single list of what is waiting.

One of these is a nuisance. Several together usually mean enquiries are being lost, and you will not see them, because a lost enquiry leaves no trace.

What to check before you choose a CRM

There are a great many CRMs, from well-known names such as HubSpot, Zoho, Pipedrive and Capsule to tools built for a single trade. We have not tested them all, and a ranking would be out of date within months, so here are the checks that work for any of them.

1. How do enquiries get in? If your website forms, inbox and booking system cannot feed it automatically, somebody has to retype everything, and that is the first job to stop getting done.
2. Does it match how you win work? Some CRMs are built around a pipeline of quotes and deals. A business that lives on repeat bookings or appointments needs customer history and reminders more than a pipeline.
3. What does it cost for your whole team? Most charge per user per month. Price it for everyone who will use it, on the plan that includes what you need, not the cheapest plan on the page.
4. Can you get everything out? Before you put anything in, check you can export your customers and their history in a format another system can read.
5. Where is the data held, and who can see it? Customer records are personal data, so where they are stored and who has access is a data protection question as well as a software one. The Information Commissioner's Office publishes advice for small organisations, and that is the place to start rather than a supplier's sales page.
6. Will your team still use it in month three? Try the free plan or trial on a real week of enquiries, with the people who will use it every day. If it feels like extra work in the first week, it will be quietly dropped long before it pays for itself.

The part most CRMs leave to you

A CRM is only as good as what goes into it. The software is the easy part to buy. Getting every enquiry into it without anyone retyping is the part that decides whether it works.

That means connecting the places enquiries actually arrive: the forms on your website, your booking system and your inbox. When an enquiry from your website creates the customer record, sets the next step and tells the right person, nothing depends on someone remembering to copy it across on a busy day.

This is the work our Connected build does: a website connected to the tools your business already uses, such as booking, reviews, customer records and email. It starts from £3,000 plus VAT, or £2,400 plus VAT with a Grow or Accelerate plan. The full list is on our pricing page.

When off-the-shelf stops fitting

Most small businesses should start with an off-the-shelf CRM and connect it properly. A bespoke system earns its place when the way you work is part of what sets you apart, and every tool you try makes you bend that work to fit its screens. Typical signs are jobs that move through stages a standard pipeline does not have, quotes built from your own prices and options, or customers who need to see and manage their own bookings.

That is when a bespoke application built around your work can be the better answer. Bespoke builds start from £6,000 plus VAT, and we compare that option honestly with using or connecting the software you already have before recommending it.

What follow-up did for our own business

At The Anchor, our own venue, plenty of people wanted to come. The gap was between wanting to and actually having a table. We built a booking route that turned that interest into a confirmed booking, then added confirmations and reminders. Table bookings grew by 403%, and no-shows fell by 89%.

The Anchor is a pub, but the problems it had are the ones every small business has: being found, turning interest into a firm booking or sale, and keeping more of what you sell. Every business has its own version of the held table: the quote, the appointment, the site visit. The full case study explains the changes together.

If your business is in Staines or Spelthorne

Orange Jelly is based in Stanwell Moor, Staines, so Staines and Spelthorne is where we look for clients first. If that is where your business is, here is how we work with local businesses.

The short version

• A spreadsheet is a fine CRM while one or two people handle every enquiry and nothing gets forgotten.
• Move when follow-ups depend on memory, details are typed twice, or nobody can say how many enquiries became work.
• Choose the CRM your team will keep up to date, priced for everyone who will use it, and one you can get your data out of.
• Getting enquiries into it automatically matters more than which one you pick.
• Go bespoke only when your way of working is part of what sets you apart and off-the-shelf tools keep fighting it.