Paul Rammeloo, homeBook a call

CRM for small business: what it needs to do, and how to set one up

A CRM for small business is one place for every lead and customer. What it must do, when a spreadsheet is enough, and a simple setup a small team will use.

On this page (9 sections)
  1. What a CRM must do for a small team
  2. Why it matters: leads go cold quietly
  3. Spreadsheet or CRM?
  4. How to set one up in an afternoon
  5. How to choose the tool
  6. An example, so you can picture it
  7. Common mistakes
  8. Where this fits
  9. Sources

A CRM for small business is one place that holds every lead and customer: who they are, where they came from, what they asked, and what happens next. The software matters less than the habit. A small team needs a list nobody can miss, a next step on every line, and a quick way to see who is waiting.

A lot of small businesses don’t really have a CRM problem. They have a “leads are in five places” problem. The fix is the same either way.

Key takeaways

  • A CRM has one job for a small team: no lead gets lost, and every lead has a next step with a date.
  • A shared spreadsheet is a fine start. Move to a CRM when leads arrive from several channels or more than one person follows up.
  • Set it up around your stages and fields first, then pick the tool. Review it weekly or it decays.

What a CRM must do for a small team

Ignore the feature lists for a minute. For a business with one to ten people, a CRM has to do five things well:

Job What it looks like in practice
Capture every lead Website forms, lead ads, email and messages land in it without copy and paste
Show the next step Every open lead has an action and a date, so nothing sits silent
Remind the owner A nudge when a lead is waiting or a follow-up is due
Show the pipeline You can see at a glance how many leads are at each stage
Record the outcome Won or lost, and why, so you learn which channels and offers work

If a tool does those five, it’s enough. If it doesn’t do the first one, nothing else matters, because the leads that never make it in are the ones you lose.

Why it matters: leads go cold quietly

The cost of a messy lead list doesn’t show up as an error. It shows up as enquiries that simply never turn into conversations. In a 2011 Harvard Business Review audit of 2,241 US companies, 23% never replied to a web enquiry at all, and only 37% replied within an hour (Harvard Business Review, 2011).

In many cases the lead probably landed somewhere nobody was watching. A CRM is a low-cost way to make a waiting lead visible. I go deeper on reply time in speed to lead.

Spreadsheet or CRM?

Start with what you’ll actually keep up to date.

Your situation Use
Under about 10 enquiries a week, one person replies, one or two channels A shared spreadsheet with the fields below
Leads from several channels, or two or more people follow up A simple CRM with form and email connections
You want automatic follow-up, reminders and reporting by source A CRM, connected to your forms, ads and email

A spreadsheet fails in predictable ways: someone forgets to add the Instagram enquiry, two people reply to the same lead, or the “next step” column goes stale. When you notice any of those, it’s time to move.

How to set one up in an afternoon

  1. Map your channelsEvery place a lead can arrive
  2. Define your stagesFour to six, in your words
  3. Pick your fieldsOnly what you'll use
  4. Connect captureForms and ads feed it directly
  5. Weekly reviewFifteen minutes, same day
Set the process first. The tool just holds it.

1. Map every channel

Write down every place an enquiry can arrive: website form, phone, email, Facebook and Instagram messages, lead ads, referrals, walk-ins. Each one needs a route into the list. The channels nobody routes are where leads die, which is the leak I describe in why good leads go cold.

2. Define your pipeline stages

Keep it to four to six stages that match how you actually sell. For a service business, something like:

Stage Means
New Arrived, no reply yet
Contacted First real reply sent
Talking A real conversation has happened
Quoted or booked A price or appointment is on the table
Won Paid or confirmed
Lost With a reason: price, timing, went elsewhere, no reply

If you can’t explain a stage in one line, merge it with another.

3. Pick the fields

Only add a field if someone will fill it in and someone will use it. A good minimum:

  • Name and contact details
  • Source (which channel or ad)
  • Date and time it arrived
  • What they asked for
  • Stage
  • Next step and its date
  • Owner
  • Outcome and lost reason
  • Consent: how and when you got it, if you’ll email them commercially

That last one matters in Canada. If you send commercial emails, you need to know which consent you’re relying on. The CASL checklist explains implied consent and express consent.

4. Connect capture

Forms, lead ads and your enquiry inbox should create a record automatically. Copying by hand works for a week, then it doesn’t. This is also where automation earns its keep: a new lead can trigger an instant holding reply and a reminder to the owner.

5. Review it weekly

Fifteen minutes, same day each week. Check three things: leads with no reply, leads with an overdue next step, and lost reasons. That one meeting is what keeps a CRM from becoming another place leads go to die.

How to choose the tool

I’m not going to rank brands here. Plans and prices change too often, and the right pick depends on your channels. Judge any option against these criteria:

Criterion Question to ask
Capture Can my forms, lead ads and inbox create leads automatically?
Simplicity Will my least technical person use it on a phone?
Pipeline Can I set my own stages and see them at a glance?
Reminders Does it nudge the owner when a lead waits?
Email Does it connect to the inbox we already use?
Follow-up Can it send a short nurture sequence with an unsubscribe?
Data Can I export everything if I leave?
Cost What does it cost at the number of users I’ll have next year?

Run a two-week trial with real leads. The one your team actually opens every day wins.

An example, so you can picture it

This is an illustration, not a client story.

A three-person cleaning company gets enquiries from its website, Google, Facebook messages and phone. Leads live in two inboxes and one partner’s phone. They move to a simple CRM: the form and Facebook lead ads create records, phone enquiries are added on the spot, and each lead has a stage and a next step. A reminder fires when a new lead waits more than an hour. At the Friday review they see that most lost leads say “timing”, so they add a follow-up two weeks later. Nothing about their marketing changed. They just stopped losing track.

Common mistakes

  • Buying features instead of a habit. A powerful CRM that nobody updates is worse than a spreadsheet everyone uses.
  • Too many stages and fields. Every extra field is a reason to skip updating it.
  • No owner. If everyone can follow up, nobody does.
  • No lost reasons. Without them you can’t tell if the problem is price, timing or your reply speed.
  • Automating messages without consent. Follow-up emails are still commercial messages. Check consent before you switch on a sequence.

Where this fits

A CRM is the backbone of follow-up, and follow-up is one of the three places I check first in a Growth Diagnostic. Once leads are in one place, the next wins are faster replies, better follow-up emails and, if you want it, AI lead follow-up with a person still in charge. If leads come in but don’t turn into customers, book a call.

Sources

  • Oldroyd, J. B., McElheran, K. and Elkington, D. “The Short Life of Online Sales Leads.” Harvard Business Review, March 2011. hbr.org

Questions people ask

Do I need a CRM for a small business?

You need what a CRM does: one place for every lead, a clear next step for each one, and a way to see who is waiting. For a handful of enquiries a week, a shared spreadsheet can do that. Once leads come from several channels or more than one person replies, a proper CRM usually pays for itself in leads you stop losing.

Is a spreadsheet good enough as a CRM?

It can be, if every lead goes into it, someone updates it the same day, and you review it weekly. Spreadsheets break down when leads arrive from many channels, when several people work them, or when you want reminders and automatic follow-up.

What should a small business CRM track?

At minimum: name, contact details, where the lead came from, the date it arrived, what they asked for, the stage, the next step with a date, the owner, and the outcome with a reason if lost. Add consent details if you send commercial emails in Canada.

How do I choose a CRM?

Pick the simplest one that captures leads from all your channels automatically, shows a pipeline your team understands, sends reminders, and connects to your email. Try it with real leads for two weeks before you commit. The one your team actually uses beats the one with the most features.

Tell me where it's stuck.