Simple CRM for a Small Business: Spreadsheet, Ready-Made Tool or Custom Build?

Most small businesses start tracking leads in the same place: the WhatsApp chat list, a few name cards in a drawer and whatever the owner remembers. It works until a lead goes quiet because nobody wrote down who was meant to call whom, or until you cannot tell which enquiries turned into jobs. At that point the question becomes practical: do you need a CRM at all, and if so, which kind?

A CRM (customer relationship management) tool is, in the plainest sense, a place that remembers every lead for you: who they are, where they came from, what they want, what happens next and when. This guide is about one decision for a small business: tracking leads in a spreadsheet, in a ready-made CRM tool, or in a custom-built system. It does not repeat the general test for whether your business has outgrown spreadsheets everywhere, or the broader buy-or-build question. It stays on leads, from first enquiry to won or lost.

What a simple CRM does, and what to track

Strip away the marketing and a simple lead-tracking CRM does five jobs. Whether it is a spreadsheet or software, if it does these five, it is working.

• Capture. Every enquiry ends up in one list, however it arrived: a WhatsApp message, a phone call, a web form, a referral or an event. Which channel to offer customers is a separate question, covered in enquiry forms vs WhatsApp.
• Stage. Each lead has a clear stage, such as new, contacted, quoted, won or lost, so you can see where it stands.
• Next step. Each open lead has a next action and a date. This single field prevents most lost leads.
• History. A short note of what was said, so anyone on the team can pick up the conversation.
• A simple count. How many leads came in, how many were quoted, how many were won, and from which source.

Before choosing any tool, decide the handful of fields you will keep. More fields are not better: every extra field is one more thing someone must fill in, and the ones nobody fills in make the data untrustworthy.

Eight or nine columns is plenty to start with. You can always add one later; removing a field that people have learned to ignore is much harder.

Option one: a spreadsheet, set up properly

A shared spreadsheet is the right first CRM for many small businesses, and there is nothing embarrassing about it. It costs little or nothing, everyone already knows how to use it, and you can change it in a minute. The difference between a spreadsheet that works and one that quietly loses leads is set-up.

• One row per lead, one column per field. No merged cells, and no colours as the only record of status.
• Dropdown lists for stage and source. Otherwise you end up with "Quoted", "quoted" and "sent quote" all meaning the same thing, and counts stop adding up.
• A next-follow-up date column. Sort or filter the sheet so that today's and overdue follow-ups sit at the top whenever you open it.
• One shared online file, not copies. If more than one person edits it, keep a single shared sheet rather than versions emailed around.
• A short weekly review. Ten minutes going through anything overdue is the manual version of a reminder system.

Where it strains: a spreadsheet does not remind you of anything by itself. It cannot easily stop two people overwriting the same row, it keeps no tidy history of who changed what, and it makes it awkward to give someone access to only their own leads. If you do not open the file, nothing happens. Those limits are exactly what the signs later in this guide are about.

Option two: a ready-made CRM tool

A ready-made CRM is a subscription product built for the common lead-tracking job. Typically it gives you a pipeline view of leads by stage, reminders for follow-ups, several logins with different access, a phone app, and a way to import a spreadsheet file. Many offer a limited free tier and charge per user per month beyond it, but plans and limits change, so check the current terms yourself rather than relying on a review written last year.

It tends to fit when:

• More than one person works the leads and you need to see who is doing what.
• You regularly forget or miss follow-ups and want automatic reminders.
• Your sales process is fairly ordinary: enquiry, follow-up, quote, win or lose.
• You want to be up and running in days rather than commissioning a build.

Things to weigh before you commit:

• Fit versus clutter. Ready-made tools are built for many industries, so you will see fields, screens and sales jargon you do not need. A tool that is too big for you gets abandoned just as surely as a spreadsheet that is too small.
• Per-user cost that grows with the team. Multiply the monthly fee by the number of people who need a login, over a full year, not just the first month.
• Where your data lives and how you get it out. Before you enter a single lead, check that you can export everything in a standard file. A tool you cannot leave is a risk of its own.
• Lead details are personal data. Names and phone numbers are personal data under Malaysia's Personal Data Protection Act 2010. Ask a qualified adviser how it applies to what you store, and give logins only to the people who need them.
• Whether the team will really use it. A tool nobody updates is worse than a spreadsheet people actually open. Pick one person to own it and make it the only place leads are recorded.

Option three: a custom-built lead system

A custom build is a small web app made around exactly how your business sells. It is the least common answer for lead tracking, and it should be: most small businesses are well served by the first two options. It earns its cost only in narrower situations.

A custom build can be justified when:

• Your process has steps a ready-made tool keeps forcing you to work around. For example site visits, multi-stage approvals, or quotes that depend on your own pricing rules.
• Staff must see only their own leads, or only their own branch's. And the role rules are specific to how you work.
• The lead record has to sit inside a bigger system. Such as jobs, scheduling or invoicing, rather than living as a separate island next to them.
• You have already used a ready-made tool and can name what it could not do. This is the strongest signal of all. "It feels too basic" is not a reason; "it cannot record the approval step we need" is.

Gotka's App & System Development service lists an indicative starting price of RM8,000 for web apps and dashboards, the category a lead tracker usually falls under, and RM12,000 for business systems and integrations if the lead record has to be part of a wider system. Both are indicative and confirmed only by a written quote once your workflow is scoped. Compare that against what a subscription would cost your headcount over several years, and against the cost of the problem it fixes, rather than against one month's fee. For how long a build takes, see how long a custom business system takes.

The three options side by side

No column wins everywhere. The cheapest option that stops leads being lost is usually the right one, and it is fine for that answer to be the spreadsheet you already have.

Signs you have outgrown your current option

Outgrowing the spreadsheet:

• You missed or double-handled a follow-up in the last month because nobody was sure whose it was.
• Two people edited the file at once and one lost changes, or you keep copies called "final_v3".
• You cannot say within a minute which leads are overdue today.
• You are building formulas, colour codes and macros just to get reminders.
• You want a salesperson to see their own leads without exposing everyone else's.

Published advice on this, mostly from CRM vendors, suggests reconsidering once you have a few dozen active leads or a second person editing the file. Treat those numbers as rough prompts rather than rules, because follow-up discipline matters more than the count.

Outgrowing the ready-made tool:

• You keep a side spreadsheet for things the tool cannot record.
• Staff skip the tool because it asks for fields that make no sense for how you sell.
• You pay for features you never use while the one thing you need is missing.
• Every new request becomes a workaround that only one person understands.
• The subscription total across your team over a few years is approaching what a build around your own process would cost.

None of these on its own is a reason to switch. Two or three together usually are. For the same kind of test across your whole business rather than just leads, see signs your business has outgrown spreadsheets.

A simple test before you decide

Rather than debating it, test your current setup against your last twenty leads. Take twenty real enquiries from the past two or three months and answer these honestly:

1. For how many can you say, in under a minute each, what stage they are at?
2. For how many open leads is there a written next action and date?
3. How many went quiet without anyone deciding they were lost?
4. Can you tell which source (website, WhatsApp, referral) the won ones came from?
5. If the person who handled most of them were away tomorrow, could someone else carry on each conversation from the notes alone?

If you can answer most of these with confidence, your current setup is fine, and changing tools would add effort without adding results. If you stumble on two or three, fix the process first by adding the next-action date and the dropdown lists, then see whether that is enough. If you still stumble on most of them, the setup is genuinely failing and it is time to move up one option.

Then run a trial rather than a debate. Put the same twenty leads into the candidate tool (many ready-made tools can import a spreadsheet file) and use it for a month alongside the old sheet. If the team actually uses it and misses fewer follow-ups, keep it. If not, you have lost a month, not a year of fees.

Moving from one option to the next without losing leads

Whichever direction you move, the leads are the asset, so protect them. The same steps apply from spreadsheet to tool, or from tool to custom build. For a bigger system, moving data into a new business system goes into more depth.

1. Clean before you move. Merge duplicates, fix phone number and date formats, and agree one set of stage names. Moving a mess just gives you the same mess in a new place.
2. Decide what comes across. Open leads and recent history, yes. Old leads with no activity for years can stay in an archive file.
3. Map the columns. Write down which old column becomes which new field before you import anything.
4. Import a small batch first. Ten leads is enough to see whether names, dates and stages landed in the right place.
5. Run old and new side by side briefly. Then pick a date when the old file becomes read-only. Two live lists is how leads get lost.
6. Keep an export. Save a copy of the old file and, from the new tool, an export you can open without it.

Because lead details are personal data, archive or delete old copies deliberately, and do not leave exports sitting in shared chats or personal inboxes.

A worked example: three hypothetical businesses

These are illustrations, not real clients, to show how the same question leads to different answers.

• A freelance photographer with about fifteen live enquiries, mostly from WhatsApp. One person, simple stages, small numbers. A spreadsheet with a stage dropdown, a next-follow-up date and a weekly review is enough. A CRM tool would add more screens than the work needs.
• An air-conditioning servicing company with four office staff. Enquiries arrive from a website form and WhatsApp, several people reply, and follow-ups keep slipping because nobody is sure whose they are. A ready-made tool fits: import the spreadsheet, run it for a month alongside the old sheet, and keep it if misses drop.
• A renovation contractor whose leads need a site visit, a measured quotation and owner approval, with each salesperson seeing only their own. After trying a ready-made tool, the team still keeps a side sheet for site visits and approvals. Now there is something specific to point at, and a custom build is worth scoping, alongside a written quote from a developer.

Common mistakes

• Buying software before deciding the fields and stages. A tool cannot fix a process you have not defined.
• Tracking too many fields. The ones nobody fills in make every report unreliable.
• Having no next-action date. It is the single field that most reduces lost leads.
• Expecting a CRM to do the follow-up for you. A tool records and reminds; someone still has to make the call.
• Skipping the export check. Confirm you can get your data out before you put any in.
• Letting leads also live in private phones and personal chats. If it is not in the system, it does not exist for the team.
• Jumping to a custom build before testing a ready-made tool with real leads. The trial is cheap and tells you exactly what is missing.
• Keeping two live lists after the move. Set a date, make the old one read-only, and stick to it.

Where Gotka Technologies fits

If a spreadsheet or a ready-made tool covers your leads, that is a good outcome and you do not need a custom build. If your process is specific enough that you can name what a ready-made tool cannot do, Gotka's App & System Development service builds web apps and business systems, from an indicative RM8,000 for web apps and dashboards and RM12,000 for business systems and integrations, confirmed by written quote once your workflow is scoped. Before that conversation, what to prepare before your first talk with a developer helps you bring real examples, and once quotes arrive, how to compare two custom software quotes helps you line them up. If your leads start on your website, Gotka's Web Design service covers the site itself.

Key terms used in this guide

• CRM (customer relationship management): a tool or system that records your leads and customers, what has been said and what happens next.
• Lead: a person or company that has shown interest but has not yet bought.
• Pipeline: the sequence of stages a lead moves through, from new enquiry to won or lost.
• Stage: a named step in the pipeline, such as contacted or quoted.
• Next action: the specific thing that will happen next with a lead, with a date attached.
• Source: where a lead came from, such as a website form, WhatsApp or a referral.
• Import and export: moving records into a tool from a file, or out of it into a file, usually a CSV.
• Per-user pricing: a subscription charged for each person who has a login.