What a CRM gives a small business: the next step after Excel and a notebook

Excel is a great program. Really. Lots of businesses start with Excel or a plain notebook, and that’s perfectly normal. The problem isn’t Excel. The problem is using it for a job it wasn’t made for.

How to tell Excel is no longer enough

• Three people open the same file, and someone wipes out someone else’s changes without knowing it.
• Nobody can say for sure “Who was talking to this customer?”
• A customer you promised to call back slips your mind. A week later they’ve already bought somewhere else.
• At the end of the month you ask “how many leads came in this month, and how many turned into sales?”, and someone spends half a day counting.
• When a salesperson quits, the customer list leaves with them — on their phone.

If two of these sound familiar, you’ve outgrown Excel. That’s a good sign — the business is growing.

What a CRM actually is

The name is a bit intimidating, but the idea is simple. Every customer has a card: who they are, where they came from, what they asked for, who talked to them, what the next step is and when. On top of that, reminders: “call at 10 tomorrow”. And a funnel: lead → contacted → price sent → payment.

That’s it. Everything else is convenience built on top of that foundation.

Off-the-shelf CRM or your own

I’ll be honest: there are ready-made CRMs, and in many cases they’re enough. If your process is standard — lead, call, sale — take a ready-made one, pay the monthly fee and get on with it. You don’t have to build everything from scratch.

When do you need your own? When your process is unusual: for example, an order goes first to production, then to the warehouse, then to the courier. Or when the CRM has to connect to your Telegram bot, 1C or a payment system. The money and nerves it takes to bend a ready-made system to fit you can sometimes add up to more than building from scratch.

Before you choose software

• Write down every place your leads come from.
• Which stages a sale goes through. 4–6 stages are enough; more just confuse things.
• Who’s responsible at each stage.
• Which numbers you want to see at the end of the month.

A CRM doesn’t create order. It helps you not forget the order you’ve agreed on.

So sketch the process on paper first, then pick the software. Do it the other way around, and the software will bend you to fit its process.