Simple CRM Setup: A Complete Guide for Small Business

Most small businesses do not have a customer problem. They have a memory problem. A lead emailed in March, a buyer asked a question on the phone, someone filled in a form last week, and none of it sits in the same place. So people slip away, and nobody notices until it is too late to fix. This guide covers simple CRM setup from an empty page to a daily habit.

A CRM is just the answer to that. It is one list that holds every lead and buyer, plus what happens next with each of them. You do not need a big system to start. You need one list you will actually open every day.

A simple CRM is one list, one row per person, with a next step and a date on every row. If you open it daily and clear what is due, nobody slips away.

Step 1: Decide what counts as a person on the list

Start by deciding who goes in. The rule is easy: anyone who has shown interest or paid you. That includes people who asked for a quote, replied to an email, booked a call, filled in a form, or bought something. Suppliers, friends and newsletters you read do not belong here.

Keeping the rule narrow matters. A list that holds everyone you have ever met turns into noise, and you stop opening it.

Step 2: Pick the place the list lives

Choose one home for the list. A spreadsheet is a perfectly good first CRM. A dedicated CRM tool works too. The tool matters far less than the habit. If you already live in a spreadsheet, stay there. If you want more structure, our guide to choosing a tool covers what to look for.

Whatever you pick, there must be exactly one list. Two lists is the same as no list.

Step 3: Set up only the columns you need

Resist the urge to track twenty fields. Start with these:

1. NameThe person, and the company if there is one.
2. How to reach themEmail and phone number.
3. Where they came fromInbox, form, referral, event, or ad. This tells you later what is worth repeating.
4. StageNew, talking, quote sent, bought, or not now.
5. Next stepOne sentence on the next thing that will happen.
6. Next step dateThe day it will happen. This is the column that does the work.
7. NotesAnything you want to remember about them.

The last three fields are what separate a CRM from a contact list. A contact list tells you who someone is. A CRM tells you what you owe them and when.

Step 4: Pull in the people you already have

Now fill the list. Go through the places where people already show up: your inbox, your contact form, your invoices, and your phone. Add each person once. Do not try to be perfect. Aim for a list that is roughly right today, then fix gaps as they appear.

AI can speed up this step a lot. You can paste in a batch of emails or form entries and ask it to pull out names, contact details and what each person wanted, then drop the result into your list. Always read the output before you trust it, because a wrong email address is worse than a blank one. Lesson 5.1 shows how to set this up so people from your inbox and forms land in the list without retyping.

Step 5: Give every person a next step and a date

Go down the list and fill in the last two columns for each person. Ask one question per row: what happens next, and when?

If the answer is "nothing," pick a stage that says so, such as "not now," and set a date to check again in a month or two. No row should be left without a date. A row with no date is where people go to be forgotten.

Step 6: Ask the list who to contact today

Every morning, sort the list by next step date and look at what is due today or earlier. That is your follow up list. Do those things, then update each row with the new next step and a new date.

This takes a few minutes once the list is in good shape. It is also where AI helps again: you can paste the list and ask "who should I follow up with today, and what should I say?" and get a ready to edit start for each message.

Step 7: Keep it clean

Spend five minutes at the end of each week tidying. Merge anyone who is there twice. Mark deals that are won or lost. Move cold people to "not now" with a date to revisit. A small weekly clean keeps the list honest, and an honest list is one you keep using.

What to do after the basics work

Once you have used the list for a few weeks, you can add small things: a column for deal value, a tag for customer type, or an automatic reminder. Add one thing at a time and only when you feel the lack of it. For ideas on routines, see the repeatable framework, and for what to watch, the metrics that matter.

When you are ready to connect the list to your emails, the welcome email lesson is the natural next step, followed by an email journey and replying to new leads quickly.

Simple CRM setup: a worked example from start to finish

Say you run a small photography business. Today, enquiries arrive by email, through a contact form and by Instagram message. Some people have booked, some asked for prices, and a few said "maybe next spring". Nothing is written down in one place.

You create a spreadsheet and add the seven columns. You scroll your inbox and add every person who asked about a shoot in the last few months. You open the form entries and add anyone not already there. For Instagram you add the people you remember talking to. That takes an evening, and the list is roughly right.

Now you go row by row. Someone asked for prices and never heard back: next step "send price list", date today. Someone booked for June: next step "send questionnaire", date six weeks before the shoot. The "maybe next spring" people become "not now" with a date in February. By the end of the evening, every row has a next step and a date.

The next morning you sort by date. Three things are due. You do them, update the rows, and you are done in a few minutes. That is the whole system working. It is plain, and it is enough.

What to do when the list feels like too much work

Nearly everyone hits a wall in the second or third week. The list is out of date, a few rows are old, and opening it feels like facing a pile of laundry. Do not start again. Instead, do a short rescue.

1. Sort by datePut the oldest next step dates at the top.
2. Decide fastFor each overdue row, either do the step now, set a new honest date, or move the person to "not now".
3. Stop at tenIf the pile is large, handle ten rows a day until it is clear.
4. Restart the habitOpen the list at the same time tomorrow, even if it is only for a minute.

A list that is slightly behind but opened daily recovers quickly. A list left alone for a month does not.

Privacy and care with other people's details

A customer list holds personal details, so treat it with care. Keep it in a place only you and trusted people can open. Only store what you need to do the job. The UK data protection regulator's guide for small businesses makes the same points: collect only what you actually need, do not keep information "just in case", keep it secure, and tell people why you need it. Rules differ by country, so check the regulator where you operate. If you paste messages into an AI tool to pull out names and requests, check the tool's settings and your local rules on personal data first, and remove anything you do not need to share. This is not legal advice, so if you hold sensitive data, ask someone qualified about what applies to you.

How the lesson fits in

This guide gives you the shape of the list. Lesson 5.1, Every customer in one place, shows the practical side: keeping every lead and buyer in one simple list, pulling in people from your inbox and your forms, adding a next step and a date to each, and asking who you should follow up with today and getting the list back. If the reading made sense, the lesson is the quickest way to do it with your own data. You can also compare it with the manual way to judge whether it suits you.

Questions people ask

Do I need paid CRM software to start?

No. A spreadsheet with the columns above is enough to start. Move to a tool later if you outgrow it.

How many people should be on the list at the start?

Everyone who has shown interest or bought from you in the last year is a fair first pass. Add the older ones later if you have time.

How often should I open the list?

Daily, for a few minutes. The habit matters more than the tool.

What if I forget to update it?

Make updating the list the last step of every call or reply. If it is not recorded, it did not happen.