Academy › Build › Bookings and orders
How many sessions each client has left, without guessing
By the end, you'll track every package balance on a single spreadsheet, know exactly when a session gets deducted, and tell the customer in every confirmation, so they never have to ask how many they have left.
By Yodai · Published September 6, 2026 · Updated October 12, 2026
You sold a five-session package. You charged the full amount on day one. Now your client texts you on a Tuesday afternoon: "How many do I have left?" You open the calendar, count the past appointments on your fingers, and answer "two, I think."
That "I think" is the problem. If you're wrong in her favor, she gets a session she never paid for and you never find out. If you're wrong against her, you just told her a package is used up when she still had a session coming. Both kinds of mistakes cost you money or trust. And both come from the same root cause: there's no single place where that number lives.
And the size of the mistake depends on how many packages you're tracking. With two or three clients on an active package, you notice it by the end of the month and fix it in time. With twenty, it piles up every week, and by the time you notice, you don't even know how far off your count really is.
One number, one place
A notebook, a phone note, and a spreadsheet all fail for the same reason when you use them on and off: you jot things down when you remember, and sometimes in two places at once. With three active packages, nothing goes wrong. With fifteen, it breaks down in exactly the month you're busiest, which is when you need it not to break down the most.
The alternative is one place and one moment. One place: a package tracking sheet, with one row per client (sessions bought, used, remaining, and the expiration date), and no other paper trail. One moment: you subtract the session at the same step every time, never at the end of the day or whenever you happen to remember. What's left is deciding what that step is: the exact moment a session gets used.
- The slot is locked into your calendar as soon as the appointment is booked
- You always know exactly how many future appointments are already committed against your packages
- You need a clear cancellation rule, or you end up penalizing the clients who give you advance notice
- A session is only used up when the service is actually delivered
- Works better where there's no fixed appointment, like a drop-in access space
Which one to pick: If you work with a calendar and appointments (hair salon, physical therapy, classes), subtract when the client books: the session is the slot you're holding, not just the service you provide. Subtract at check-in only if your package gives open access with no booked time, like a gym floor.
The risk of subtracting at check-in is the no-show: someone books, doesn't show up, and the slot in your calendar sits empty without costing them anything. That's why many businesses with fixed appointments find it pays off to subtract at booking: the slot is spoken for the moment you commit it, whether it's used or not.
What the client sees
The balance is useless if only you can see it. If your client has to ask you how many she has left, you've already lost: that means it isn't in front of her anywhere. The confirmation you send every time she books is the natural place to tell her, without her having to ask: when you confirm the appointment, add a line with what's left, copied straight from your tracking sheet.
That message isn't just information: it's proof you're running things right. A client who sees her exact balance every time she books never asks again, and never wonders if you're overcharging her.
What to do about cancellations
If you subtract at booking, you need to decide what happens when someone cancels. A common rule for businesses that work by appointment is the same one you'd use for any booking, for example: if they give more than twenty-four hours' notice, the session goes back into the package; if they cancel later or don't show up, it still gets deducted.
It's the same rule you already apply to single appointments, just extended to the package. Without that rule in writing, every cancellation gets negotiated case by case, and that's where "I think" creeps back in. If your clients are individual consumers, put it in writing before they pay for the package, and make sure what you deduct is in proportion to what you actually lose: consumer protection law doesn't allow disproportionate penalties.
Let's say you have an eight-session package at $20 a session. If you let a late cancellation slide every time someone asks, you can end up giving away two or three sessions a month without even noticing: $40 to $60 you'd already counted as paid, money you actually gave back in the form of a free session.
- 1The package lives on your tracking sheet
Not as a loose note: one row per client, with sessions bought, used, remaining, and the expiration date, and no other paper tracking that same number. - 2Every session in the package is subtracted when you confirm the appointment
You deduct it on the sheet right then, not at the end of the month or whenever you remember. - 3The balance goes in the confirmation
You don't need a new template: it's the same confirmation message you always send, with one extra line copied from the sheet. - 4You define the cancellation rule
How much advance notice is needed to get the session back, and what happens if there's no notice at all. - 5When it hits zero, you're the one who says so
Before confirming a package appointment, check the sheet: if there are no sessions left, you tell them when you confirm, instead of them finding out in the chair.
What you do the day that balance hits zero is the next decision: whether you renew out of habit, or take a look first at how it was used.
- Each package's balance lives in one place, your tracking sheet, not split between a notebook and your phone
- You know whether you deduct at booking or at the visit, and why it's one and not the other for your business
- The client sees how many sessions they have left without having to ask you
- You have a written rule for cancellations, the same one you already use for one-off appointments
Test yourself
Answer before opening each one. If one gives you trouble, go back to the section that explains it.
1. You have eight active packages, and one of your clients texts to ask how many sessions they have left, because even you aren't sure. What do you change first?
The place where the balance lives, not your memory. As long as the number only exists in your head or in a notebook, it'll keep happening; the balance needs to live in one place, your tracking sheet, and get subtracted at the same step where you confirm each appointment, not from whatever you remember at the end of the day.
2. You have an open-access training room, no fixed time slots, and a ten-visit package. Do you deduct a visit when it's booked or when the client shows up?
When they show up. There's no time slot to block here: the package pays for actual visits, and someone who skips a day doesn't cost you an empty slot or penalize them either.
3. A client cancels their package session two hours before the appointment, without any advance notice, and asks you not to deduct it because "nothing really happened, right?" What do you do?
You deduct it, because your cancellation policy is already written down, and it's the same one you use for single appointments: less than 24 hours' notice, and it still gets deducted. Make an exception today, and that's the one they'll bring up tomorrow, and you're right back to the case-by-case mess you wanted to avoid.
With the balance kept properly on your sheet, you can see when it's getting close to zero, and that's exactly the moment that decides whether the client renews or walks away.
NextWhen a package runs out, don't renew on autopilot: check how they used it