Free Ways to Keep a Customer List Without a CRM

The five fields that make a record useful

Name and how to reach them. One contact route you have actually tested, not three you have not. If the whole relationship lives in a messaging app thread, write down the phone number or handle separately, because an account can be lost and a thread can be deleted.

What you did for them, in your words. Not a category — the specifics. Deep clean, two-bedroom flat, dog in the house. Fitted a shelf, they supplied the brackets. The detail is what makes the follow-up message sound like a person who remembers them rather than a broadcast.

What they paid and how they paid it. The figure matters less than the pattern of who pays without chasing and who does not.

The date you last spoke to them. And one line of anything you noticed: they mentioned moving in the spring, they run a shop on the same street, they wanted the other room done later. That last line is where repeat work comes from.

Five columns. Nothing else earns its space at this size, and every extra field is one more thing you will stop filling in by the third week.

Why the last-contact date does the work

Sort the list by that column and it tells you who to speak to today. Without it you have a pile of names and no way to decide, so you contact nobody, which is what happens to almost every list ever written.

It also stops the two failure modes at either end. You do not message the same person twice in a week because you forgot, and you do not let someone who was happy with your work drift for months until they have found somebody else.

Update it every time, including when they do not reply. A message sent is contact. Written down, it is the difference between following up and pestering. What to actually say when someone has gone quiet is a separate craft, and how to follow up with a customer who went quiet handles the wording.

Capturing the detail in the moment

The record has to be created while you are still there, or within a minute of leaving. Standing on the sidewalk outside the house, in the van, on the bus. Not tonight, because tonight you will be tired and the name will be gone.

The fastest capture on a phone is a voice note to yourself: name, address, what you did, what they paid, what they mentioned. Twenty seconds. Then transcribe the voice notes into the list in one sitting, once a day or once a week.

If typing is easier, keep a single note pinned to the top of your notes app and add a line to the bottom of it every time. One place, always the same place. A detail written in three different apps is a detail you will never find again.

Ask for the contact route at the end of the job, not the start. Someone who is pleased with what you just did gives you a number without thinking about it, and that is also the moment to mention you do other work, which is where turning a first customer into a second one begins.

Keeping it somewhere a lost phone cannot take

A note on one phone is not a list. It is a list that ends the day the phone is stolen, drowned, or upgraded badly.

The simplest fix that costs nothing: keep the file in a free account that syncs, so the same document opens on any device you can log into. A spreadsheet or document in a web account beats a local note for exactly one reason — the phone is no longer the only copy. Those accounts have their own ceilings, and what happens when a free cloud storage account runs out of room is worth knowing before it stops syncing quietly in the background.

Then take a copy that does not depend on any account at all. Export the sheet, email it to yourself, or write the names and numbers in a paper notebook you keep at home. Do it on a fixed day so it actually happens. An account can be locked, a password can be lost, and a phone number change can cut you out of your own login.

Check that you can get back in from a device that is not your phone. Not theoretically — actually log in from a library computer or a friend's browser once. Finding out your login only works on the phone you no longer have is a bad afternoon.

Many people end up keeping the customer list as one tab in the same file as everything else, which is a reasonable place for it: running a hustle on one free spreadsheet sets out how that file gets organized.

When a real tool starts paying for itself

Watch for specific symptoms rather than a number of names. You are scrolling to find someone. You have contacted the same person twice by accident. You cannot remember which of three people asked about the same job. You are forgetting to follow up on quotes you have already written.

The other trigger is when more than one person touches the list — a partner, a helper, someone answering messages for you. A shared list needs to show who spoke to whom, and a note app stops coping at that point.

Until then, a tool with contact stages, pipelines and automated sequences will slow you down. It asks for setup time you do not have and structure your business does not yet have shape for. Adding software to a list of nine people is a way of feeling organized without being organized.

Records that only matter if somebody reads them

The list does nothing on its own. Its only value is that it makes a decision easier on a slow week, and that only happens if you open it on the slow week.

So attach it to a fixed moment. Sunday evening, or the first coffee on a Monday, or whatever hour is reliably yours. Open the list, sort by last contact, pick a small number of people at the bottom, and message them. Then update the dates. The whole thing should take less time than the queue in a shop.

If you have gone a month without opening it, the honest response is to make it smaller rather than to promise yourself you will do better. Cut it to the people who paid and the people who nearly did. A short list you use beats a complete one you avoid.