From notebooks and Excel to a simple CRM your small sales team will actually use

When sales live in notebooks

"Each of my salespeople keeps their own notebook or Excel file, and many of the conversations are on their personal WhatsApp. When someone leaves, their customers go with them." Many small sales teams in Bangladesh work this way. It works until it doesn't: follow-ups are missed, the owner can't see what's in the pipeline without calling everyone, and nobody knows why deals were lost.

A CRM (customer relationship management system) fixes this, but only if people use it. Many businesses buy one, fill it in for a month, and drift back to notebooks. The goal here is a CRM simple enough to survive.

What a small team actually needs

Leave the long feature lists for later. A small team needs five things:

1. Contacts and companies in one shared place, owned by the business, not by individuals.
2. Deals in stages, so you can see what is where.
3. A next action with a date on every open deal.
4. A short history: calls, quotations, notes.
5. A simple weekly view for the owner or sales lead.

If a tool does these well and is easy to use on a phone, it's enough to start.

Decide the process before the tool

First write your sales stages in plain words, for example: new enquiry, first contact made, need understood, quotation sent, negotiating, won, lost. Then decide the minimum fields: name, company, phone, source, stage, value or quantity, owner, next step with date, and a reason when a deal is lost.

The tool can be a well-structured Google Sheet, an off-the-shelf CRM, or a small custom system if your process is unusual. A sheet is a fine start for two or three people. Once you need reminders, mobile access and a history for each customer, a proper CRM becomes worth it. Whatever you choose, try it with your own real data before committing.

A team with someone comfortable with spreadsheets can set up a sheet-based CRM itself. Outside help is useful when choosing between tools, migrating messy data, connecting forms and messaging channels, and setting up reminders and reports.

Setting it up, step by step

1. Collect everything: every notebook page, Excel file and contact list. Merge it into one list and remove duplicates.
2. Import only what's useful: active customers and open deals first; old history can wait.
3. Set one rule: no open deal without a next step and a date.
4. Connect the main sources of enquiries, such as your website form, so less is typed twice. The approach in a simple lead system covers this side.
5. Train in one short session, using the team's own deals, not a demo.
6. Run the weekly sales meeting from the CRM screen. More than anything else, this keeps it alive.

Why teams stop using a CRM

• Too many required fields, so updating takes longer than the call.
• The owner keeps asking for updates on WhatsApp instead of looking at the CRM.
• Double entry: the same information in the CRM and in a separate report.
• No easy mobile access for people who are always out in the field.
• The team sees it as a way to watch them rather than a tool that helps them sell. Explain honestly that customer data belongs to the business, and the CRM is there so nobody's work gets lost.

A first step for this week

Write your sales stages on one page and agree on them with the team. Then put only your open deals, each with a next step and a date, into one shared sheet. See lead generation and B2B outreach, or contact me for help.