How to Keep Track of Customer Enquiries Without an Expensive CRM

When you run a small business, customer enquiries can quickly become difficult to manage.

One person emails you. Another sends a message through your website. Someone else contacts you through Facebook, Instagram or WhatsApp.

At first, it can feel manageable.

Then you realise you cannot remember who you replied to, who asked for a quote, who said they would come back next month, or which enquiries simply disappeared.

The usual advice is to buy a customer relationship management system — a CRM.

But for many solo businesses and small service businesses, that can be more technology than you actually need.

You can create a simple enquiry system without paying for expensive software or building a complicated setup.

The real problem is not the number of enquiries

Most small businesses do not struggle because they have thousands of enquiries.

They struggle because enquiries are spread across different places.

You might have:

• emails in your inbox
• messages from your website
• social media enquiries
• notes written on paper
• names saved in your phone
• quotes waiting to be followed up
• potential customers you meant to contact again

The problem is not necessarily volume.

It is that there is no single place showing you what needs attention.

Start with one enquiry tracker

The simplest solution is to create one central list for every genuine business enquiry.

A spreadsheet works perfectly well for many small businesses.

You could include columns such as:

Date received — when the enquiry first arrived.

Name — the potential customer's name.

Contact details — their email address or telephone number.

What they need — a short description of the enquiry.

Where they found you — Google, Facebook, referral, your website or another source.

Status — for example: New enquiry, Replied, Quote sent, Follow-up needed, Booked, or Not proceeding.

Next action — one of the most important columns. Instead of simply recording what happened, record what you need to do next.

For example: Follow up Friday. Send quote. Customer asked me to contact them again in November.

Notes — keep this brief. You do not need to copy entire email conversations into your tracker.

The purpose is simply to make it easy to understand what is happening.

Every enquiry should have a status

This small change makes a surprisingly big difference.

Without a status, an enquiry is simply a name on a list.

With a status, you immediately know what stage it has reached.

For example:

Now you can open your tracker and see what needs attention without searching through your inbox.

Create a simple follow-up routine

A good enquiry system only works if you actually look at it.

You do not need to check it constantly.

For many small businesses, a simple routine is enough.

For example:

Morning: Check for new enquiries.

End of day: Update anything you replied to.

Twice a week: Review enquiries marked “Follow-up needed”.

That can take only a few minutes.

The important thing is that you stop relying on memory.

Do not leave follow-ups inside your inbox

Email is useful for communication.

It is not always good for managing a sales process.

Once you reply to an enquiry, the message may disappear down your inbox.

A week later, you may not remember that you intended to follow up.

Instead, record the follow-up in your enquiry tracker as soon as you send your reply.

For example: Quote sent 14 October. Follow up 18 October.

That tiny habit can prevent promising enquiries from being forgotten.

Keep the system as simple as possible

It is very easy to overbuild a business system.

You start with a spreadsheet.

Then you add automations.

Then forms.

Then dashboards.

Then notifications.

Before long, managing the system becomes another job.

A small business enquiry system only needs to answer four questions:

Who contacted me?

What do they want?

What stage are they at?

What do I need to do next?

If your system answers those four questions, it is doing its job.

When should you use a CRM instead?

There may come a point when a spreadsheet is no longer enough.

A CRM may make sense if:

• several people manage enquiries
• you receive a large number of leads
• you need automated email sequences
• you have a longer sales process
• you need detailed reporting
• customer information needs to connect with other business systems

But you do not need to start there.

For many solo businesses, consultants, freelancers and small service businesses, a clear enquiry tracker is more useful than a complicated CRM that nobody enjoys using.

A simple system is better than a sophisticated system you avoid

The best business technology is not necessarily the most advanced.

It is the technology you will actually use.

If customer enquiries are currently scattered across emails, messages and notes, start by creating one central place for them.

Then give every enquiry a status and a next action.

That alone can make your business feel much more organised.

Want the system already built for you?

The Enquiries & Clients Kit gives you a practical, ready-to-use system for keeping track of enquiries, follow-ups and client information without building an expensive or complicated CRM setup.

Enquiries & Clients — £29

View the Enquiries & Clients Kit →