A customer contacts your business on WhatsApp about a bulk order. Your sales assistant sends a quotation but forgets to follow up.
A month later, the assistant leaves, taking the customer's details and conversations on their personal phone.
You've potentially lost a valuable customer.
Sound familiar?
Many Kenyan small businesses struggle to manage customer information scattered across WhatsApp, Excel spreadsheets, M-Pesa statements, and notebooks.
The good news? You don't need expensive software to stay organised.
This guide explains how to track customers, manage follow-ups, and know when it's time to consider a CRM system.
Key Takeaways: Keep track of your customers
- Keep customer information in one place. Record contact details, purchase history, communication channels, and follow-up dates.
- Start with a spreadsheet. You don't need expensive customer tracking software to get organised.
- Use business-owned communication channels. Keep customer conversations on your company's WhatsApp Business number and email.
- Review customer records weekly. Match M-Pesa payments, update purchase history, and follow up on outstanding enquiries.
- Consider a CRM system as you grow. Cloud CRMs offer convenience, while self-hosted CRMs provide greater control over your data and hosting costs.
Why Is It Hard to Keep Track of Customers?
Imagine a small electronics shop in Nairobi.
Some customers visit the shop, while others enquire through WhatsApp, phone calls, or Instagram.
One salesperson records contacts in a notebook. Another saves them on their phone, while the owner tracks payments through M-Pesa.
This works when you have a few customers. But as enquiries increase, information becomes harder to manage.
You might forget what a customer ordered or miss an important follow-up. The problem grows when several team members handle sales without sharing information.
Without a shared customer database, everyone works with different information.
The solution? Create one reliable place to record customer details, regardless of how they contact your business.
What Happens When You Lose Track of Customers?
Poor customer tracking can quietly cost your business money.
Here are some common problems:
- Lost sales opportunities: Customers request quotations but never receive follow-ups.
- Poor customer service: Returning customers must explain their needs every time they contact you.
- Missed repeat purchases: You forget to contact customers who might be ready to order again.
- Confused sales teams: Different employees contact the same customer without knowing what was discussed.
- Lost customer relationships: Staff leave with contacts and conversations stored on their personal devices.
Imagine a hardware supplier in Nairobi.
A regular customer returns, but the new salesperson doesn't recognise them because their purchase history wasn't recorded.
This can affect customer satisfaction.
Good customer tracking helps your team recognise returning customers, understand their needs, and offer better service.
How to Keep Track of Customers This Week
You don't need expensive software or major changes. Start with these seven practical steps.
Create One Customer Tracking Sheet
Use Excel or Google Sheets to create a central customer database.
Record important details whenever someone contacts your business:
- Customer name and phone number
- Source of enquiry
- Last contact dates
- Purchase history
- Next follow-up date
- Sales status
- Responsible team member
Here's a simple template you can copy.
Free Customer Tracking Template for Small Businesses
| Customer | Phone | Source | Purchases | Last contact | Follow Up | Status |
|---|---|---|---|---|---|---|
| Example Customer | 07XX XXX XXX | 2 orders, KSh 18,500 | 3 Nov | 4 Dec | Repeat | |
| Example Lead | 07XX XXX XXX | Walk-in | None | 18 Nov | 25 Nov | Quoted |
Use consistent status labels:
- New lead: Interested but hasn't purchased.
- Quoted: Received pricing but hasn't responded.
- Paid: Completed payment.
- Repeat: Purchased more than once.
- Gone quiet: Hasn't responded to follow-ups.
Update the sheet after every important interaction. Limit staff access to relevant information, and protect customer data.
Use a Business-Owned WhatsApp Number
When employees use personal WhatsApp numbers, customer conversations may disappear when they leave.
Instead, use a company-owned WhatsApp Business number.
Organise conversations with labels such as New enquiry, Quotation sent, Payment received, and Follow-up needed.
Remember to record important details in your customer tracking sheet. Your business should also control account access and staff handovers.
Keep Customer Conversations on Business Email
Use a professional business email address instead of employees' personal accounts.
For example, customers can contact hello@yourbusiness.co.ke.
HostAfrica's HMailPlus Professional Email & Workspace helps businesses organise communication through contact management, email synchronisation, and collaboration features.
Although it isn't a CRM system, it can help keep customer communication organised as your business grows.
Match M-Pesa Payments to Customer Records
Review M-Pesa payments weekly and match them to customer records.
For example, a customer buys supplies worth KSh 8,000 in January and KSh 12,000 in March.
Recording both purchases helps you identify repeat customers and understand buying patterns.
Use transaction references to match payments, and avoid storing unnecessary financial details.
Create One Sales Process for Everyone
Your team should follow the same sales process:
Enquiry→Quote→Payment→Delivery→Follow-up
When someone requests a quotation, record the enquiry and follow-up date.
Update their status after payment, and check their satisfaction after delivery.
This simple pipeline management process keeps everyone informed.
Hold a Weekly 30-Minute Customer Review
Set aside 30 minutes each week to review your customer records.
Ask three questions:
- Which customers need follow-ups?
- Which enquiries have gone quiet?
- Which previous customers might buy again?
Assign each follow-up to a team member so no opportunity is forgotten.
Make One Rule: If It Isn't Recorded, It Didn't Happen
Your tracking system only works when everyone uses it.
After each important call, WhatsApp conversation, quotation, or sale, update the customer record.
It takes an extra minute but can save hours of searching through messages later.
Spreadsheet vs CRM: When Have You Outgrown Your Tracking Sheet?
A spreadsheet is a great starting point.
However, it can become difficult to manage as your customer base and sales teams grow.
Use this checklist to assess your business.
- Several team members update the same spreadsheet, and information gets overwritten.
- Customer records contain duplicates or conflicting details.
- Follow-ups still get missed despite weekly reviews.
- You struggle to identify the right customers for marketing campaigns.
- You need to see your sales pipeline in real time.
- Field sales teams need customer information on their phones.
If you ticked three or more, it's worth exploring a CRM system.
This doesn't mean your spreadsheet has failed.
It simply means your business needs a better way to manage growing customer relationships.
A CRM can help everyone work from the same information without constantly checking different files.
What Is a CRM System, and How Does It Work?
CRM stands for Customer Relationship Management.
A CRM system is customer tracking software that stores contact details, purchase history, conversations, and sales activities in one place.
Instead of searching through WhatsApp chats and spreadsheets, your team can open a customer record and see what happened previously.
Many CRM systems also support follow-up reminders, sales pipeline management, and customer reporting.
Some include tools for marketing campaigns and basic project management. However, their main purpose is managing customer relationships, not projects.
For Kenyan businesses considering a CRM, there are two main options. You can choose between a cloud CRM and a self-hosted CRM.
See the table below:
| Feature | Organised spreadsheet | Cloud CRM | Self-hosted CRM on VPS |
|---|---|---|---|
| Setup | Quick and simple | Sign up and start | Requires technical installation |
| Cost | Usually free | Paid plans, often per user in USD | Monthly VPS fee in KSh, plus any software and IT costs |
| Customer data | In your file | Stored by the CRM provider | Hosted on your own server |
| Maintenance | Your team | CRM provider | You or your IT partner |
| Best for | Getting organised | Teams wanting quick setup | Growing teams wanting more control |
- Cloud CRM: A cloud CRM is hosted and maintained by a software provider. You simply create an account, add customers, and start using it. Zoho CRM is one example with free and paid plans. It's convenient because you don't manage the server. However, paid plans often charge per user, sometimes in US dollars. Costs can increase as your team grows.
- Self-Hosted CRM: A self-hosted CRM runs on a server your business controls. You can install open-source CRM software on a Virtual Private Server (VPS). This can help you avoid per-user subscription fees, although hosting and maintenance still cost money. You'll also need technical expertise to install, secure, update, and maintain the system.
Why Some Kenyan Businesses Choose a Self-Hosted CRM
Imagine you manage a sales team with ten employees.
With a cloud CRM that charges per user, adding more team members can increase your monthly bill.
A self-hosted CRM works differently.
Your VPS hosting fee doesn't automatically increase whenever you add another user.
However, you'll still need enough server resources to support everyone. Software licences, maintenance, and IT support may also add costs.
For businesses that want predictable hosting expenses, this can be attractive.
A HostAfrica Linux VPS provides a server hosted in Nairobi, with monthly billing in KSh and M-Pesa payment options.
Here are two general starting points:
| VPS Plan | Resources | Regular Monthly Price | Suggested Use |
|---|---|---|---|
| Linux Cloud C4 | 2 vCPUs, 4 GB RAM, 100 GB storage | KSh 3,200 | Small teams with a handful of users |
| Linux Cloud C5 | 4 vCPUs, 8 GB RAM, 200 GB storage | KSh 6,400 | Growing teams or heavier CRMs |
These are general recommendations. Always check your chosen CRM's requirements before selecting a plan.
Important: HostAfrica supports the VPS server, not the CRM software. Your business or IT partner is responsible for installing, securing, updating, and maintaining the CRM.
If you're unsure about the technical responsibilities, read our guide on Managed vs Unmanaged VPS Hosting.
You can also explore self-hosted n8n to send website enquiries automatically into a spreadsheet or CRM.
Our guide on How to Automate Business Tasks in Kenya explains other simple ways to reduce repetitive work.
Common Customer Tracking Mistakes to Avoid
Even with the right tools, a few mistakes can create problems.
- Using personal WhatsApp numbers: Keep important customer communication on business-owned accounts.
- Creating a spreadsheet and forgetting it: Update records regularly, especially after customer conversations.
- Recording contacts without purchase history: Knowing what customers bought helps your team serve them better.
- Buying a CRM before defining your sales process: Agree on how enquiries, quotations, payments, and follow-ups should work first.
- Choosing software based on price alone: Consider future team growth, user costs, security, and maintenance.
- Self-hosting without technical support: Make sure someone can maintain your CRM before moving it onto a VPS.
FAQs: Customer Tracking Software
What is the best way to keep track of customers?
Start with one shared customer tracking sheet. Record contact details, purchase history, communication dates, and the next follow-up. Make sure your team updates it regularly.
Can I keep track of customers using Excel or Google Sheets?
Yes. Both are suitable for small businesses with simple customer tracking needs. As your team grows, a CRM may become easier to manage.
When does a small business need a CRM system?
Consider a CRM when customer information becomes difficult to manage or employees start missing follow-ups. It's also useful when several team members need access to the same records.
What's the difference between a cloud CRM and a self-hosted CRM?
A cloud CRM is managed by a software provider. A self-hosted CRM runs on your own server and requires someone to install and maintain the software.
How much does a self-hosted CRM cost in Kenya?
HostAfrica's Linux Cloud C4 starts at a regular price of KSh 3,200 per month, while C5 costs KSh 6,400 per month. Additional costs may include software licences and IT maintenance.
How can I stop losing customer contacts when staff leave?
Use business-owned WhatsApp and email accounts. Keep customer records in a shared system, control access, and ensure employees update information before leaving.
Start Keeping Track of Your Customers Today
Keeping track of customers doesn't have to be complicated.
Start with one spreadsheet, a business-owned WhatsApp number, and a weekly customer review.
Make sure every customer has a record your team can access.
As your business grows, you can move to a CRM system that makes managing customer relationships easier.
If you want more control over your customer data and hosting expenses, consider running a self-hosted CRM on a VPS.
Ready to grow beyond spreadsheets?
Explore HostAfrica Linux VPS plans and find a hosting option that suits your business and CRM requirements.
