How to track prepaid lesson packages
A package count is trustworthy only when a coach can explain every change. This method keeps sessions, attendance outcomes, payments, and renewals clear without turning the spreadsheet into a second job.
10-minute setup · Worked example · Free Excel template
Free lesson-package tracker
Includes formulas for remaining lessons, credit, outstanding amount, and renewal status. Two sample rows show how it works. No email address required.
Step 1
Define what uses a lesson before you count anything.
Choose a consistent outcome for attended lessons, no-shows, excused absences, and cancellations. Your policy belongs to your business; the important part is that the recorded outcome determines the count. A scheduled lesson alone should not silently consume a session because the schedule can change.
| Outcome | Typical package treatment | What to record |
|---|---|---|
| Attended | Uses one session | Date and lesson reference |
| No-show | Uses one only if your policy charges it | Status and policy decision |
| Excused | Usually does not use a session | Status and short reason |
| Canceled | Does not use a session | Who canceled and when, if useful |
Step 2
Keep sessions and money in separate columns.
A student can have three lessons remaining and still owe money. Another student can have no lessons remaining and hold a payment credit. Treating money as “lesson credit” hides both situations.
Step 3
Use a worked example you can reconcile by hand.
Avery bought a 10-lesson package for $450. Six attended lessons and one chargeable no-show used seven sessions. A weather cancellation did not use one. Avery has three sessions remaining and owes nothing.
- Package size
- The number of sessions purchased
- 10
- Lessons used
- Completed sessions that count against the package
- 6
- Charged no-shows
- Missed sessions your written policy counts
- 1
- Lessons remaining
- Package size minus used lessons and charged no-shows
- 3
- Amount charged
- The package price placed on the account
- $450
- Amount paid
- Money actually received
- $450
- Credit
- Payment above the current charge
- $0
- Outstanding amount
- Charge not yet covered by payment or credit
- $0
Step 4
Review exceptions, not every cell.
Update attendance after each lesson, then use a short weekly review to find the records that need action.
- Packages with zero, one, or two lessons remaining
- A negative count, which signals a missed renewal or an incorrect outcome
- Money outstanding even though the package has already started
- A credit that should be applied, retained, or refunded according to your policy
- An expiration date approaching while sessions remain
When the spreadsheet stops being enough
A spreadsheet works well when one person updates a small roster consistently. It becomes fragile when attendance lives in a calendar, payments live somewhere else, and students ask for a count that no one can reproduce quickly.
LessonSync uses the same basic model, but attendance keeps package history current and invited families can verify their own records. Keep the spreadsheet for as long as it works. Move when maintaining it becomes the work.
Explore Lesson Packages →