Most trainers who run group classes sell them in class packs: 5, 10 or 20 sessions paid up front. Packs are great for cash flow and for commitment, but they create a bookkeeping job that grows with every student: how many classes does each person have left, who has paid, and who is about to run out?
Why class packs get out of hand
A pack is just a prepaid balance. The trouble is volume. With a handful of students you can keep it in your head. With thirty, fifty or a hundred, spread across several groups and time slots, you are tracking three numbers per person (classes left, payments, expiry) and updating them after every single session.
Where spreadsheets fall short
- They are not at the session. You take attendance on paper or from memory and update the sheet “later”. Later piles up.
- One wrong cell costs money. Edit the wrong row and someone trains for free, or loses classes they paid for.
- They never warn you. A sheet will not tell you that Marta has one class left and this is the moment to offer a renewal.
- Students cannot see their own balance. So they message you to ask, one by one.
What you actually need to track
- Each student’s classes remaining, updated the moment they attend.
- Payments: who paid for the current pack, and how much.
- A short history: which sessions they came to and when each class was deducted.
- A low-balance signal, so renewals happen before the pack runs out.
The simple rule: deduct when you take attendance
The fix is to record usage at the moment it happens, not afterwards. If marking someone as present also deducts a class from their pack, the balance can never drift: you do one action at the session and the bookkeeping is done. That is how Bootcamp Tracker works: you take attendance from your phone (or students check in with a QR code), and each attendee’s pack goes down by one.
Add a low-balance alert and the same data becomes a sales tool: you see who is about to run out and can offer a new pack before they drift away.
Let students see their own balance
The other half of the job is answering “how many do I have left?”. When each student can open the app and see their own balance and sessions (and nobody else’s), those messages stop.
Common mistakes to avoid
- Relying on memory. Past ten students, you will forget who paid.
- Updating “later”. Anything not recorded at the session gets lost.
- Mixing groups in one sheet. Keep each group’s roster and sessions separate so balances stay clear.
If you are moving off a spreadsheet, you do not need to retype anything: import your students from a CSV file and start deducting classes from the next session.