Customer records for a hairdresser or salon: what to keep, what is allowed, and the way without Excel

Keeping customer records as a hairdresser or salon means recording four things: who the customer is, how you reach them, what you did and when. You need nothing more to see who is staying away and to bring that customer back. Below you will find which details to keep, what the GDPR allows, a free layout for Excel, and the way the list fills itself without any typing.

In short

• Four columns are enough: contact, last visit, what you did, consent for messages.
• The GDPR allows this, as long as you say what you keep and why.
• A digital loyalty card fills the list at every stamp, without Excel.

Why customer records pay off more than a full diary

Most salons know exactly who is coming in tomorrow, but not who was last in three months ago. That second number is the money. A customer who quietly stays away costs you 8 to 10 visits a year on average. At 35 euro a haircut that is 300 euro per customer per year.

Reichheld and Schefter showed in Harvard Business Review that 5 percent better customer retention raises profit by 25 to 95 percent. You do not need to be an economist to follow that: bringing a customer back costs one message, while winning a new customer costs advertising and a first appointment at a discount.

So the list is not administration. It is the list of people you should call.

Which details you keep (and which you do not)

Keep it small. Every field you do not use is a field you will not update.

| Field | Why | Required? | |---|---|---| | First and last name | To recognise the customer and address them | Yes | | Phone number or email | To remind them and bring them back | One of the two | | Date of last visit | To see who is staying away | Yes, this is the most important field | | What you did | Colour formula, treatment, product, so the next time is right | Yes for hairdressers and beauty | | Consent for messages | Whether you may send a promotion or a birthday message | Yes, record it | | Birthday | For a birthday promotion | No, only if the customer wants it | | Notes | Allergy, skin type, preferred stylist | Only if the treatment needs it |

What you do not record: address (unless you post something), year of birth, family situation, remarks about the person. Anything you would not want the customer to read does not belong in there.

What the GDPR says, in plain words

The General Data Protection Regulation sounds heavy, but for a salon it comes down to four rules.

1. Say what you keep and why. A short privacy statement on your site or at the till: "We keep your name, contact details and treatment history to help you properly and to remind you of your appointment."
2. Use details for the purpose you collected them for. Contact details for appointments may not simply be used for a newsletter. For that you ask separately, with a box that is unticked by default.
3. Do not keep it longer than you need it. Delete customers who have been away for three years. Invoices are a separate matter: their retention period follows the tax rules of your own country, and that is bookkeeping, not your customer records.
4. Secure it. An Excel file without a password on a shared laptop is not secured. Forwarding a file over WhatsApp is not either.

Customers have the right to ask what you hold about them and to have it deleted. Make sure you can do that within a month. The same regulation applies across the EU, with a supervisory authority in every country, and most of them publish free guidance for small businesses.

Customer records in Excel: the free layout

If you start on paper or in Excel, use these columns, in this order:

Name | Phone | Email | Last visit | Treatment / formula | Messages (yes/no) | Birthday | Notes

Three agreements with yourself:

• Every customer, every visit, update the date. Do it while they pay, not at the end of the day.
• Sort on "last visit" every Monday. Everyone who has been away longer than their interval, 8 weeks for a haircut and 5 weeks for nails, gets a message.
• A password on the file, and one single place. Not on three laptops, not in your email.

This works up to about 100 customers. Above that, updating becomes the bottleneck: a salon with 400 customers and 25 visits a day types 25 dates every day. Nobody keeps that up, and then the list is unreliable within two months.

The way without typing: the list fills itself

There is a way to have your customer records updated at every visit without anyone typing anything: a digital loyalty card.

Here is how it works. The customer scans a QR code at the till, fills in their first name and puts the card in Apple Wallet or Google Wallet. At every visit you give a stamp with your phone. That stamp is the visit date in your records straight away. After a few weeks you have, without Excel:

• a list of all your customers with their last visit,
• a list of everyone who has been away longer than usual,
• a button to send that group a message ("We miss you, you have 3 stamps to go"),
• and consent for messages recorded properly, because the customer added the card themselves.

The colour formula or treatment note you enter once, with the customer in the system, and it is there at the next visit. That is how the loyalty card for hairdressers works: for the customer it is a stamp card, for you it is your customer records.

For the GDPR this is tidier than Excel: the details sit in a secured place, the customer gave consent themselves, and deleting is one button.

Five things you can do with good records

1. Bring back the people who stay away. Everyone who has not been in for 10 weeks gets a message. In salons that do this, part of the group returns within two weeks, and 20 to 30 percent is normal at a hairdresser.
2. Birthdays. A message with a small gesture, such as a free wash in their birthday month. It costs almost nothing and gets remembered.
3. Fill the quiet days. A promotion only to customers who already came in three times on a Tuesday.
4. Ask for reviews at the right moment. Two days after a visit, only to customers who have been in more than five times. More about that in collecting Google reviews through your loyalty card.
5. Know what a customer is worth. Visits per year times average spend. That number decides how much you may spend to bring them back.

Frequently asked questions

Which customer details am I allowed to keep?

Everything you need to deliver your service and to reach the customer: name, phone number or email, what you did (colour formula, treatment), when, and whether the customer wants to receive messages. Sensitive details such as health or allergies you may only record if the treatment needs them and the customer knows about it.

Do I need consent to store customer details?

Not for the details you need for the appointment and the treatment, because that falls under performing the contract. For marketing messages, such as a promotion or a birthday email, you do need consent, and unsubscribing has to be as easy as signing up. Explain in a short privacy statement what you keep and why.

How long may I keep customer details?

As long as you need them for the purpose. You keep a colour formula as long as the customer keeps coming. Details of a customer who has not been in for three years you delete or anonymise. Invoices are a separate matter: their retention period follows the tax rules of your own country, and invoices are not customer profiles.

Is Excel good enough for customer records?

For a salon with fewer than 100 customers it can work, as long as you protect the file with a password and do not share it over WhatsApp or email. Above that you get stuck: no automatic visit date, no messages, no view of who is staying away. A system that fills the list at every visit is then cheaper in time.

How do I see which customers are staying away?

By recording the date at every visit and making a list of customers who have been away longer than their usual interval: 8 weeks at a hairdresser, 5 weeks at a nail salon. A digital loyalty card does that on its own and can send those customers a message.

Want to try it yourself?

Start today with the four columns, or skip Excel and let the list fill itself with a loyalty card for hairdressers. Live in five minutes, free to start, and your customers do not have to install anything. If you work in a nail salon or a beauty salon, have a look at the digital stamp card for your business.