CRM for consultants: the threshold where a spreadsheet stops working

Most independent consultants don't need a CRM yet, and the ones who do can name the exact moment it changed. Here's the threshold, and what to do on either side of it.

Contents
  1. The threshold
  2. If you’re under the line
  3. If you’re over the line
  4. What to do on the first day, whatever you pick
  5. The honest summary

Search results for this will hand you a list of ten CRMs. Before that list is useful, there’s a question worth answering: are you at the point where a CRM helps, or the point where it becomes one more thing to maintain?

Plenty of independent consultants buy one too early, use it for six weeks, and go back to the spreadsheet. That’s not a discipline failure. It’s a sizing mistake.

The threshold

A CRM starts paying for itself when you can no longer hold the state of every conversation in your head, and something is falling through.

That’s it. Not deal count, not revenue. State.

Concretely, one of these is usually true when it flips:

Under that line, a spreadsheet with five columns — name, what they want, last contact, next action, date — genuinely outperforms a CRM, because it takes no maintenance and you’ll actually update it.

Over that line, the spreadsheet stops failing loudly and starts failing quietly. It still looks fine. It just isn’t true any more.

If you’re under the line

Stay there, and make the spreadsheet slightly better:

One column that matters more than the rest: next action, with a date. Not status, not stage. The literal next thing and when. Sort by that column and you have most of what a CRM would give you.

A rule for silence. Three weeks without a reply and it moves to Cold, with a recontact date. Without a rule, dead conversations sit in the list forever and the list stops being scannable.

Nothing about this is a compromise. For a one-person practice with a handful of live conversations, it’s the correct tool.

If you’re over the line

Now the tool choice matters, and the free tiers are real. Two things to check first, because they’re where people get surprised.

Tested on a live account — HubSpot

HubSpot free gives you a genuine CRM database: contacts, companies, deals, notes, tasks, up to 1,000 contacts and 2 users, permanently. For a consultant that’s a lot of headroom.

What it won’t do:

Limit What it means for you
1 deal pipeline Sales and delivery share one board
10 custom properties And the setup spends four before you start
1 automated action Follow-up sequences aren’t in the free plan
Branding On every form and email a client sees

That last one decides it for many consultants. If your client-facing forms carry someone else’s logo, this is the limit that matters regardless of the others.

Something lighter is often the better answer at this size. Tools that live inside your inbox — Streak, OnePageCRM and similar — cost less and demand far less attention, because they don’t ask you to leave the place where the conversations actually happen.

I earn nothing from either. I’m naming them because for a real slice of readers they’re the right answer, and a list that only contains the tools I’m paid for isn’t worth reading. I haven’t run them on client work — that’s from their documentation, not from use.

What to do on the first day, whatever you pick

Import the spreadsheet before anything else. Not because migration is fun, but because a CRM with no history in it gets abandoned in week two. Watch what happens to your phone numbers and date formats — that’s where import damage usually hides.

Cut the default pipeline down. Whatever you use will hand you five to seven stages. A consultant needs about four: a real conversation, a proposal out, won, lost. Every stage past that is a card nobody moves.

Record why you lost. Price, timing, scope, someone else. Four options. After twenty deals it’s the most useful thing in the system, and it costs one click.

The honest summary

Related: every hard limit on HubSpot’s free tier · why the default seven pipeline stages are wrong