How to keep track of personal training clients without a spreadsheet

Most advice on this starts by listing everything you could record, which is how people end up with a fourteen column spreadsheet they abandon in month two. Start from the other end. These are the records that actually change what you do:

• Who the client is. Their goal, their injuries, when they started. You will forget the injury before you forget the name.
• What they did. One line per exercise is enough: sets, reps, load.
• What they have paid, and for which period. Not a running total. A period, and whether it is settled.
• When their plan ends. The single most expensive date to miss.
• When they are next in.
• How long since they last trained. Not when they last booked. When they last actually trained.

Nothing else earns its keep. Body measurements, adherence scores, readiness ratings and the rest are fine if you genuinely use them, and pure overhead if you do not. Be honest about which.

People describe this as a volume problem, as though there is a client count where you graduate to software. That is not what happens.

What changes is how many dates you are holding, and that grows faster than your client list, because every client brings a renewal, a booking pattern and a payment cycle of their own.

The specific failures, roughly in the order they arrive:

• You are on your feet. Spreadsheets are miserable on a phone, so you tell yourself you will fill it in later, and later is where records go to die.
• Your client cannot see it. The history only serves you, which wastes most of its value. The person who most needs to see that they now squat what they could not squat in February is them.
• Nothing watches the dates. A renewal is only visible if you go and look at it, and you look when you remember, which is after it lapses.
• Payment status lives in two places: the sheet, and your memory. When they disagree you tend to trust the wrong one, and you end up asking a client something you should already know.
• Absence is invisible. A spreadsheet shows you rows, not gaps. Nobody has ever opened one and had it point out that Sam has not been in for three weeks.

This is the whole trick. Any system that depends on you reconstructing four sessions from memory at nine at night will be abandoned, usually within a fortnight of you setting it up.

What to record is unglamorous: the exercise, the sets, the reps, the load. That is enough to answer the only question you ask a log mid-session, which is what they did last time. Anything longer competes with the coaching for your attention, and coaching should win.

The record has a second purpose that is easy to underrate. You remember your clients getting stronger. They do not.

Progress is obvious from the outside and almost invisible from the inside, and someone eight weeks in usually feels like nothing is happening. Showing them February next to September is the most persuasive thing you can do, and it only works if February exists somewhere they can see it.

These get conflated constantly, and it sends trainers shopping for far more software than they need. Taking payments means moving money: card processing, a provider, fees. Tracking payments means knowing who has paid for what, and when the next one is due.

Most trainers get paid by bank transfer or in cash, it works, and it costs them nothing. If that is you, be careful not to buy a payment processor to fix a bookkeeping problem. You will pay a percentage of every session for the privilege.

A payment record needs four fields and no more:

• Which plan the client is on.
• Which period it covers.
• Whether that period is settled.
• When it was paid.

One point on language, because it changes how the conversation goes. A client owes you for periods they actually trained in. A plan that has run out is expired, not overdue. Treating those as the same thing makes you sound like a collections department to someone who simply has not renewed yet.

A renewal is a date, and dates are what a busy person is worst at holding. It will not announce itself, and the client will not raise it, partly because most of them have no idea when their plan ends either.

A window beats a reminder. Seven days is enough to have the conversation in person at their next session, which is a much better place for it than over text.

A month that lapses without you noticing is not deferred revenue. It is gone. You cannot invoice someone in October for training they did not do in September.

The sequence is consistent enough to plan around: a reschedule, then a gap with a reason attached, then a longer gap with a vaguer reason, then nothing. At no point does anyone tell you they have stopped. By the time it is obvious the habit is gone, and getting it back is much harder than keeping it was.

Your calendar shows what is booked. It has no way of showing you who is not in it.

That is why this catches good trainers. You notice an empty slot in your day, which reads as a scheduling problem, rather than a missing person, which is what it is.

So make it a rule instead of a feeling. Pick a number of days and check against it every week. Two weeks works well for someone training twice a week, because it is two missed weeks rather than one bad one: long enough to be a signal, short enough to still be recoverable.

When you reach out, make it about their training rather than their attendance. Something specific from their last session lands. A message that reads as a chase does not, and it puts them in the position of having to apologise to you, which is a reliable way to get no reply at all.

Some will not come back, and that is fine. The value is finding out in week two rather than month three, while you still have time to fill the slot.

Treating them the same causes most of the trouble. Three problems show up when they share a week:

• You double book yourself.
• You cannot see who has signed up for a class without scrolling back through messages.
• Your clients do not know what is on unless you tell each of them individually.

The third quietly costs the most. A class with four empty spots is usually a class nobody knew about.

What helps is unremarkable. One calendar holding both, capacity visible on the class itself, and clients able to see what is open and put themselves in it without going through you.

If you coach six people, they are all on the same kind of plan, and they all pay at the start of the month, a notes app and a calendar will serve you well. Structure you do not need is one more thing to maintain.

When you do look, four things are worth checking:

• It works properly on a phone, because that is where you are when the information exists.
• Your clients get a view of their own, so the history earns its keep twice.
• It tracks payment status without insisting on processing the payment and taking a cut.
• It tells you something you did not already know.

Software that only stores what you type into it is a spreadsheet with rounded corners.

That is the real test. The reason to pay for something is that it watches the dates you cannot watch, and puts the right three names in front of you on a Monday.