How to Track Your Clients' Session Packs Without a Spreadsheet

“How many sessions do I have left?” It always comes at the end of the hour, with your client’s bag already on their shoulder. You say you’ll check tonight. Tonight, you open a spreadsheet you haven’t touched since Tuesday.

Tracking packs isn’t hard. What makes it painful is logging everything after the fact and never having set the rules. Here’s how to fix both, whatever tool you end up using.

Three answers you should have in ten seconds

For every client, you should be able to say without opening a laptop:

• How many sessions do they have left?
• When do those sessions run out?
• Are they paid up?

If any of those means recounting, your system is already costing you: evenings at the computer, awkward moments when a client disagrees, and now and then a session that never got counted.

Why the spreadsheet always gives out

A spreadsheet is fine with three clients. After that, it starts failing for simple reasons:

• It lives far from the session. You’re on the gym floor, it’s on your computer, so everything gets logged from memory later.
• It doesn’t know about your sessions. You enter each one twice: once in your training log, once in the file.
• It’s bad at exceptions. A couple sharing a pack, a free session, a break for an injury: each one becomes a note in a cell.
• It never warns you. You find out a pack ran out when your client is already two sessions past it.

Set your rules before you sell the next pack

Most friction around packs comes from a rule nobody ever stated. Answer these once, then put them in the message every new client gets.

Situation	The call you need to make
Late cancellation	How much notice do you need? Any exception for illness?
No-show	Is the session always counted, or case by case?
Expiry	Does the pack expire? What happens to sessions left after that?
Breaks	Do you extend for injuries or vacations? By how much, at most?
Partners	Shared pack, or one each?
Sessions past the balance	Paid one at a time, or taken from the next pack?

Which rule you pick matters less than your client knowing it before it applies. A counted cancellation is a much shorter conversation when it was on the table from day one.

Session pack or monthly subscription?

Both work, but you track them differently.

	Session pack	Monthly subscription
The client buys	A number of sessions	A session quota each month
You track	The remaining balance	The month’s quota and the month’s payment
Sessions not used	Stay on the balance	Your call, carry over or not, and say so up front
When to follow up	As the balance runs down	Less about balance, more about attendance
Works well for	Clients with a variable schedule	Steady clients, for the long haul

You can offer both. If you do, be clear about which one each client is on: a fuzzy mix is the surest way to lose track of sessions.

What to record, and nothing more

Whatever your tool, these fields are enough:

1. The pack’s name and number of sessions, or the monthly quota.
2. The client or clients it covers.
3. The purchase date and the expiry date, if there is one.
4. Sessions already done, if you’re picking up a pack in progress.
5. The price and what’s been paid, with the date and how they paid.
6. Every counted session, with cancellations and no-shows listed separately so you can point to them.

That last one saves you the day a client questions their balance. A dated list beats any debate.

Count during the session, not at night

The simplest rule pays off the most: the balance changes the moment the session is logged, standing next to your client. No catching up at night, nothing forgotten, and you can answer the question on the spot.

Get in the habit of mentioning the balance before you’re asked, too: “You’ve got three left, let’s talk about what’s next next week.” No bad surprises for them, and no last-minute conversation for you.

Bring up renewal before the last session

Waiting for the final session to discuss what comes next puts you both in an awkward spot. Pick a threshold, say two sessions left, and have the conversation then:

You have two sessions left on your pack. Want to map out what’s next together next time?

That gives your client time, and it keeps the conversation on their goals rather than on a payment due today. For clients who are drifting away, see our article on following up with a client who’s dropping off.

When a payment is late

A short, factual reminder with no apology handles almost every case:

Hi, a quick reminder: the rest of your pack is still to be paid. Thank you!

Send it in writing rather than bringing it up at the end of a session in front of other people. And record each payment the day you get it: a reminder sent by mistake hurts more than a few days’ delay.

Key takeaways

• Balance, expiry, payment: three answers you should have in ten seconds.
• Write down your rules (cancellations, no-shows, breaks, partners) and share them before session one.
• Count when the session is logged, not at night.
• Keep a dated list of counted sessions: it settles disputes.
• Bring up what’s next at two sessions left, not at the last one.