Key Takeaway
Lesson credit management means one fixed set of numbers for a prepaid package: sessions bought, sessions used, sessions left, expiry date. Both sides open it and read the same thing.
Picking a method comes down to three things: how many packages you hold at once, how many people read the numbers, and whether the confirmation leaves a trace.
In This Article
Open the thread where you track your sessions. Is the last message still from two months ago? Every time you want the balance you scroll up, hunt for the message, and count the dates one by one. That is the problem lesson credit management solves: keeping sessions bought, sessions used, sessions left, and the expiry date in one fixed place, so anyone who needs the number opens it and sees the same thing.
What lesson credit management covers
Anything you pay for up front and use a bit at a time counts. Personal training, tutoring hours, salon packages, massage vouchers, even a prepaid coffee card. You buy a lump of something, then draw it down one at a time.
The math is easy. Buy some, deduct one, hit zero, buy again. The hard part is that the number usually lives in someone's head, so when you need it there is nowhere to look it up.
How do you count sessions accurately? Four rules people forget
Why do counts go wrong? There are more rules than you would think, and every one of them moves the final number.
-
Buy 10, get 1 free
You paid for 10 and you get to use 11. It is easy to stop counting at 10.
-
Group sign-up, separate schedules
Three people sign up together and book their own times. They share one total, so each person's usage needs its own count.
-
Cancellations and rescheduled sessions
Does that session count or not? The two sides end up one session apart, and it is always this one.
-
Different expiry dates
You hold two or three packages at once, each with its own deadline. Which one you use first decides whether any of it goes to waste.
Stack all four, add three months, and memory starts to leak. Then one of two things happens. You think you still have sessions left when you do not, or you get charged for one more than you actually used.
The fix is plain. Write the rules down in one fixed place you can open whenever you need it, so nobody has to remember anything.
Five ways to track lesson credits, compared: from chat threads to a lesson tracking app
Most people land on one of five: a chat thread, a paper notebook, Google Sheets, a Notion database, or a dedicated app. Put them on one table and the differences show up fast.
| Method | Cost | Setup | Many people | Reminders | In sync | Best for |
|---|---|---|---|---|---|---|
| Chat thread | Free | Lowest | Switch windows per person | None | You count back yourself | One-on-one, few sessions |
| Paper notebook | One notebook | Low | Flip pages to find someone | None | Only one side sees it | Writing by hand, checking in person |
| Google Sheets / Excel | Free, Excel needs a license | Medium, you write the formulas | One row per person | Set it up yourself | A shared link syncs | People happy to build a sheet |
| Notion | Free plan is enough | Medium to high | Group and filter | Date reminders work | Only if they use Notion too | People already living in Notion |
| Dedicated app | Free tier available | Low, fill in the fields | One package, one set of numbers | Built in | Both sides see the same numbers | Lots of sessions, someone to reconcile with |
Every method holds up somewhere, and most have a weak spot. A chat thread carries no expiry reminder. Paper only shows the numbers to whoever holds it. Sheets and Notion are strong on structure and clumsy on a phone. A dedicated app builds the reminders, syncing, and deductions in, so it is the least effort day to day.
This app is ours. It is called Course Kit. The screenshot below is its course detail page: remaining, used, and total sit right at the top, with unit price, expiry date, and the latest records underneath. The free version is on the App Store and Google Play, so you can try it yourself.
How to design a lesson tracking spreadsheet
Of the five, a spreadsheet is what most people reach for the first time they get serious about this. Run one package end to end and six columns are enough: person and package, total including bonus, used, remaining, expires, and last session. Remaining runs on a formula, and the expiry date turns red as it gets close.
Why each column earns its place and how to set the formulas up is a separate piece, and it comes with a template that already has them in it: How to build a lesson tracking spreadsheet: six columns and two formulas.
One limit up front. A sheet remembers numbers, not whether the two of you agreed. Who confirmed which session, and when, needs another checkbox column you tick by hand, and on a busy day it gets skipped.
How the remaining count is calculated
The formula is simple. Total including bonus minus sessions used, then adjust for the four rules above. Whether the answer holds up has little to do with the arithmetic. It depends on where the numbers live.
Should you switch tools? Three tests
Three questions settle it.
1. How many packages you hold at once. One or two with simple rules, and a chat thread, paper, or a sheet all work. Pick whichever one you already open most. Three or more, or rules like buy 10 get 1 free and group sign-ups, and automatic reminders and one-tap deductions start paying off.
2. How many people read the numbers. If it is only you, use whatever feels easiest. With a coach, a student, or a shop on the other end, put the record somewhere both sides can open, so opening it is the whole reconciliation.
3. Whether the confirmation leaves a trace. If you can look up who changed which entry and when, neither of you has to argue from memory.
Two or more hits means it is worth switching. One hit and your current method is fine, at least until the session count grows or a second person needs to check it.
A four-step routine for any package
Whatever tool you pick, the routine is the same four steps. Skip one and the numbers start drifting from there.
-
Set up the package
Log total sessions, unit price, expiry date, and bonus sessions on the day it is bought. Do not wait until the first session is over.
-
Deduct after the session
Deduct the moment a session ends. Same day is accurate. By the next day you are guessing which date it was.
-
Confirm together
Show the other side the entry you just made. This is where the two sets of numbers line up.
-
Close the month
At month end, scan what is left and which packages are close to expiring. Bring up renewals early, not after the last session.
Step three matters most to me. Through the years I took personal training, I was the one scrolling the thread and counting dates. My sister was on the other end, keeping the same records for a whole list of clients. Both sides worked too hard, only because the numbers were not in one place.
Course Kit connects the two steps people skip most. One tap deducts a session as soon as it ends, and the manager and the member open the app to the same numbers. More than 300 people use it today.
Here is a review from Google Play in January 2026:
Really convenient. I have bought a lot of course packages and I really needed an app like this to track them. One tap when I use a session records what is left, so I do not have to write long notes myself. It also reminds me to finish a package before it expires.
Google Play user, Jan 28 2026 (translated from Chinese)
FAQ
Do I need an app if I only have a few sessions?
The session count is wrong. What now?
What if the other side never confirms?
I'm switching from a chat thread or a spreadsheet. What happens to the old records?
How is lesson credit management different from budgeting?
Next time someone asks how many sessions are left, hopefully you will not have to scroll. To start by hand, how to build a lesson tracking spreadsheet comes with a template that already has the formulas set. To watch the four steps run, the free Course Kit app is on the App Store and Google Play.
