Does a small business really need a CRM, or is Excel enough?

Excel is enough while one person handles every lead and opens the file every day. You need a CRM when more than one person touches a lead, when follow-ups are being missed, or when you cannot say which source produced last quarter's orders. Those are the real triggers. The number of rows matters far less than the number of hands on them.

Why the lead count is the wrong test

Owners often ask "how many leads before I need a CRM?" and expect a number. A sheet with 300 rows run by one careful person works fine. A sheet with 60 rows shared between the owner, a salesperson and an accounts clerk can already be losing orders.

What breaks is not the storage. It is the memory around each row. Who called last? Was the quote sent on WhatsApp or by email? Did the customer say "call after Diwali" or "call after the board meeting"? A spreadsheet holds the answer only if someone typed it, the same day, in the same column.

A scorecard you can fill in ten minutes

Score each line honestly for the last two months. One point for every "yes".

The scorecard has limits. A solo owner can score three simply by being untidy, which a better sheet cures, and a shared sheet can score one while a salesperson is quietly sitting on a hot lead. Treat the total as a prompt to look at real rows, not a verdict.

Zero or one point: stay on the sheet and tidy it. Two or three: fix the sheet first, using the layout further down. Four or more: a CRM is likely to be worth the effort, and the real task is choosing and setting one up so your people use it.

What a spreadsheet cannot do, however well you build it

A sheet cannot nudge anyone. A CRM can show each salesperson, first thing in the morning, the list of calls due today. A sheet shows every row equally, so the overdue ones hide among the rest.

It also cannot keep a trail. If a salesperson overwrites a price, the old price is gone. And it cannot join an enquiry to its quote, its invoice and its repeat order without someone doing that by hand every time.

Those are the three gaps a CRM closes. If none of them has cost you an order, you may not need one yet.

For example: a tile dealer in Morbi

Take an invented tile dealer in Morbi selling to builders and contractors across Gujarat and Rajasthan. The owner keeps leads in a sheet. Two salespeople, a counter clerk and the owner all type into it, and builders also message on WhatsApp.

A contractor asked for a quote on 40 boxes, was quoted by phone, and went quiet. The owner thought the salesperson had followed up. The salesperson thought the clerk had. The sheet showed "quote given" and nothing else. Three weeks later the contractor bought from a competitor, and nobody could say whether the quote had been too high or simply forgotten.

The dealer did not buy software straight away. The owner added three columns: owner of the lead, next call date, and what was promised. The owner fixed one rule, that a row without a next call date is not a lead. Every morning the clerk sorted by date and read out the day's calls. That held for a few months, though the clerk grumbled about the daily reading and two salespeople still kept their own notebooks. When the team grew to five and builders began comparing two quotes at a time, the dealer had a clear picture of what a CRM must do, and could judge vendors against it instead of against their demo.

Fix the sheet first: a layout that works

Before any software, make your sheet behave like a small CRM:

• One row per enquiry, never one row per customer with many dates crammed into a cell.
• Columns: date received, source, name, phone, what they asked for, owner of the lead, next action, next action date, status, quote value, reason if lost.
• A fixed list of statuses (new, contacted, quoted, negotiating, won, lost) chosen from a dropdown, not typed.
• One person responsible for the file, and one rule on when it is updated.

If your team cannot keep a sheet like this tidy for six weeks, a CRM will not fix that. People who skip the sheet will skip the software. Find out why they do not update it first; why employees do not use the CRM covers the usual reasons.

When to stay on Excel on purpose

Do not buy a CRM if you have a handful of repeat customers and almost no new enquiries, if the lead owner is always you, or if your real problem is that nobody calls people back. Software does not make anyone call.

Also hold off if you are in the middle of changing what you sell or whom you sell to. A CRM set up around today's stages will need rebuilding.

Moving across without making a mess

When you do move, bring only clean rows: remove duplicates, delete leads dead for years, and settle your status names before the import. Choose the tool after you have written down the five things your sheet could not do.

Count your missed follow-ups tonight

Open the sheet and sort by last contact date. Write down every lead untouched for more than a week and what it was worth. That list, and its rupee total, is your case for or against software. CRM consulting and selection is the service that follows from it, and the FAQ has other questions owners ask us before they commit. Bring the list when you tell us what you need.