Guide · Spreadsheets
Tracking repeat customers in a spreadsheet? Here’s what it can’t show you.
Plenty of great salons, barbershops, nail and lash studios, spas, groomers and detailers, and lots of other shops that run on repeat clients, keep track with a spreadsheet and a payment app. It works, until a regular quietly stops coming and nothing in the sheet says so.
The short answer
- A spreadsheet shows what happened, not who is about to stop coming.
- Every gap in the typing makes a loyal regular look like a stranger.
- Keptix reads the sheet you already have and shows which regulars are slipping, by name.
The problem nobody sees
Your best regulars almost never cancel or complain. They get busy, miss one visit, then another, and drift to whoever was convenient that week. By the time you notice their name hasn’t come up in a while, they’ve often found someone else.
Each one is worth far more than one visit. A regular who comes every few weeks can be worth hundreds or thousands of dollars a year, and winning a brand-new client to replace them costs more time and money than keeping the one you had.
Why your spreadsheet misses it
A spreadsheet only knows what someone typed in. Busy days get skipped, cash visits never make it in, and “Jess T.” and “Jessica T” become two different people. Every gap makes a regular look like they stopped coming, or hides the one who really did.
And even a perfect sheet can’t tell you when to worry. A client who comes every two weeks and one who comes every two months look exactly the same in a list of last visits. Knowing who is actually late means checking every client against their own usual rhythm, every single week. That’s the part that never gets done on a Saturday night after close.
What it looks like in your shop
Picture a maintenance regular who came in like clockwork every three weeks for a year. Their last row is nine weeks old. In the spreadsheet, it’s just another date in a long column, sitting right next to clients who are perfectly on schedule.
Nothing turns red. Nobody gets a heads-up. Three missed visits later, that regular is gone.
How Keptix solves it
Upload the spreadsheet you already keep, or connect Square or Jobber. Keptix learns each client’s own rhythm and shows you exactly which regulars are slipping, what they used to spend with you, and a friendly message to bring each one back that you can send in one tap.
No new system to learn and no more scrolling through rows. Your sheet keeps working the way it does today. Keptix just finally tells you what’s in it.
Judged by each client’s own rhythm
See who’s slipping in your spreadsheet, in about 2 minutes.
Upload it to the free Leak Check as a CSV or Excel file. You’ll see how many regulars are past their own usual visit and what they used to spend with you. No account or card needed, and your file is read once, then thrown away.
Get my free Leak Check →Common questions
Can I really just upload my spreadsheet?
Yes. Any sheet with one row per visit and at least the client’s name and the date works. Save it as a CSV or Excel file and upload it to the free Leak Check.
Do I have to stop using my spreadsheet?
No. Keep it exactly how it is. Keptix reads it and shows you who is slipping. Nothing in your sheet changes.
Why can’t I just look at who hasn’t been in for a while?
Because every client comes on a different schedule. Two months is normal for some clients and very late for others. A list of last visits can’t tell the difference, which is how regulars slip by unnoticed.
Is my client information safe?
Your file is read once to show your numbers, then thrown away. Keptix never contacts your clients unless you choose to send a message.
More guides: Clients stopped coming back? · Using Square just for payments? · All guides