How to Track Prepaid Lesson Credits Correctly

A guardian pays for a block of lessons, the money lands in your account, and the admin work should be finished. Yet many tutoring centres still reopen the same payment record every week to work out who has lessons remaining, whether a missed session is chargeable, and why an invoice does not match the balance. Knowing how to track prepaid lesson credits properly turns that uncertainty into a clear, repeatable process.

The goal is not simply to record that a payment was received. It is to maintain an accurate running balance for each student or family, then reduce that balance only when a lesson is delivered or a chargeable absence occurs. When attendance, billing and payments sit in separate spreadsheets, the balance is always one manual update away from being wrong.

Start with a clear credit policy

Prepaid credits work only when families and staff understand what a credit represents. In most tutoring businesses, a credit is money paid in advance that can be applied to future lessons. It is not necessarily the same as one lesson, because students may be enrolled in subjects with different rates, receive discounts, or have different lesson lengths.

Set the rules before taking payment. Confirm whether credits belong to an individual student or the whole family, whether they can be used across subjects, and whether they expire. Also define how absences affect the balance. A practical attendance policy might charge for attended and missed lessons, while a cancelled lesson creates no debit. The right policy depends on your terms and capacity, but it must be applied consistently.

Avoid using vague labels such as paid up or two lessons left. They are difficult to audit and become unreliable as soon as a student changes class, has a make-up lesson, or attends at a different rate. Track a dollar balance instead, with every addition and deduction visible.

How to track prepaid lesson credits from payment to lesson

The cleanest workflow follows the real order of events: payment first, attendance second, invoice or statement third. Each step should update the same student or family record.

When a guardian makes a payment, add it as a credit against the correct billing account. If siblings are billed together, use a consolidated family balance rather than splitting the payment across separate records without a clear reason. This gives the guardian one figure to understand and gives your office one source of truth.

Next, tutors or administrators mark attendance for each scheduled lesson. This is the trigger for the debit. An attended lesson reduces the available credit by the agreed charge. A missed lesson does the same if your policy says the place was held and is chargeable. A cancelled lesson should not reduce the balance. The difference matters: treating every absence as the same is one of the quickest ways to create disputes.

Finally, generate the billing record from those confirmed lesson outcomes. If the guardian has sufficient prepaid credit, the credit offsets the charge. If the balance is running low or becomes negative, the system identifies the amount to collect. This approach means your invoicing reflects what actually happened, rather than what was expected to happen when the timetable was created.

Keep four records aligned

A reliable prepaid model depends on four records agreeing with each other:

• the payment received from the guardian
• the current credit balance for the student or family
• the attendance status for every scheduled lesson
• the invoice history showing charges and credit offsets

If one record is updated manually and the others are not, you lose confidence in the balance. For example, a bank transfer may be visible in your bank account but not yet allocated to the family account. The family then appears overdue even though they have paid. Or a tutor may mark a lesson as cancelled after an invoice has been raised, leaving a charge that now needs correcting.

Your process should make these exceptions visible early. A weekly check of unallocated payments, unmarked attendance and negative balances catches most issues before they become awkward phone calls.

Use attendance as the billing trigger

Scheduled lessons tell you what is planned. Attendance tells you what should be charged. That distinction is central to accurate prepaid tracking.

Charging directly from the timetable can look efficient, but it creates extra work whenever lessons are cancelled, rescheduled or missed. You either need to reverse charges later or ask staff to remember separate adjustments. Over a busy term, those adjustments are where small errors become lost revenue or incorrect invoices.

Attendance-based billing is more controlled. Mark the lesson, then let the debit follow the status. A tutor does not need to calculate balances, and the office does not need to compare rolls against invoices line by line. Tutors remain responsible for accurate attendance; administrators retain oversight of billing outcomes.

There is a trade-off. This model relies on attendance being marked promptly. Set a clear deadline for tutors, especially where invoicing runs weekly or fortnightly. If attendance is late, the charge may appear in the next billing cycle instead. That is usually better than charging incorrectly, but families should know what to expect.

Make adjustments traceable, not invisible

Every tutoring centre needs the ability to correct a mistake. A student may have been marked missed when they cancelled within policy, a lesson may have been duplicated, or a goodwill credit may be approved after a service issue. The problem is not the adjustment. The problem is making it without a record.

Do not overwrite the original payment or quietly change the balance in a spreadsheet. Create a separate adjustment with a reason, date and staff member attached. This preserves the history: what was originally charged, what changed, and why.

The same principle applies to refunds. A refund is not simply a lower balance. It is money leaving the business and should be recorded separately from a future lesson credit. Keeping refunds, credit notes and payments distinct makes reconciliation cleaner and gives you a reliable audit trail when a guardian asks for an explanation months later.

Give families a balance they can understand

Prepayment should reduce payment chasing, not replace it with balance questions. Families need invoices or statements that show the opening credit, charges for the period, payments received and closing balance in plain language.

Be especially clear when a charge has been offset by existing credit. A guardian who sees an invoice total of zero may assume no lesson charge occurred. Showing both the lesson debit and the credit applied explains that their prepaid funds were used as intended.

For Australian tutoring businesses, make sure tax treatment is equally clear. Where GST applies, invoices need to present it correctly even when a guardian's credit covers the amount due. A credit balance helps cash flow, but it does not remove the need for accurate invoice records.

Set alerts before credit runs out

A balance that reaches zero without anyone noticing creates an uncomfortable choice: allow lessons to continue unpaid, stop the student unexpectedly, or chase the guardian after the fact. None is ideal.

Use a low-credit threshold based on the family's usual lesson pattern. A student attending twice a week needs more notice than one attending fortnightly. The practical aim is to contact the guardian while there is still enough credit for one or two upcoming lessons, giving them time to pay without disrupting attendance.

Also review negative balances separately. They may be normal for a short period where billing occurs after attendance, but they should not become a hidden form of ongoing credit. Assign responsibility for follow-up and decide when enrolments require payment before further sessions are confirmed.

Replace spreadsheets when the volume demands it

A spreadsheet can track a handful of students with simple arrangements. It becomes fragile once you manage sibling accounts, recurring classes, multiple tutors, variable rates, make-up sessions and frequent payment methods. The issue is not that spreadsheets are incapable. It is that the business starts relying on people to remember every connection between payment, attendance and invoice.

A tutoring-specific platform such as PhoenixLMS keeps prepaid balances, lesson attendance and recurring invoicing in the same workflow. Payments build guardian credit, confirmed attendance creates the appropriate lesson debit, and invoice balances update from that record. If an attendance status is corrected, the next billing cycle can reflect the correction rather than leaving staff to hunt for a manual fix.

The best prepaid credit process is quiet. Guardians know where their money stands, tutors only need to record what happened in class, and your office can see exceptions before they turn into a billing problem. That leaves more time for the work families actually value: consistent teaching and well-run lessons.