For independent tutors & piano studios

A lesson balance
you can explain.

“You have five lessons left” is more useful when you can show how you got there. Keep what happened, what was charged, and what was paid as separate facts.

By Yurii Koshkin, app developer · Published 8 October 2026 · Fictional example, no customer data

Four facts, not one checkbox

Money received: amount, currency, date and payment reference. A payment is not proof that a lesson happened.
Credit added: the package or entitlement that payment buys. Write its unit explicitly: one standard lesson, 30 minutes, or another agreed unit.
Attendance outcome: attended, cancelled, rescheduled or no-show. Record the actual event before interpreting its financial effect.
Credit charged: the change under the policy agreed with that client. A cancellation does not always mean a charge; attendance and charge are not interchangeable.

Choose one unit for a ledger. If you teach mixed lesson lengths, document how those lengths use credits rather than silently treating every appointment as equal. A credit balance is not a tax invoice, a bank reconciliation or cash revenue.

Follow an eight-lesson package

Suppose a fictional student, Alex, has an eight-lesson package. For this example only, an attended lesson uses one credit; an agreed timely cancellation uses none; a chargeable no-show uses one. These are illustrative rules, not a recommended or legally universal cancellation policy.

Illustrative package ledger · standard-lesson credits
Date	Event / outcome	Change	Balance	Reason / reference
1 Oct	Package added	+8	8	Receipt R-01; eight lessons
3 Oct	Attended	−1	7	Lesson L-01
5 Oct	Timely cancellation	0	7	Agreed no-charge policy
7 Oct	No-show recorded	−1	6	Lesson L-03; chargeable under example policy
8 Oct	Correction to L-03	+1	7	Cancellation message had arrived in time; reverse prior charge

On a narrow screen, scroll the table sideways. You can also print this page using your browser.

Closing balance = opening balance + credits added − credits charged + signed adjustments
Here: 0 + 8 − 2 + 1 = 7 credits remaining

The correction is linked to the original event. Keeping a reason preserves the explanation; silently changing a total from six to seven does not. Do not add an unrelated “extra credit” that makes the balance look right but hides the original mistake.

Do not charge the same lesson twice

A reschedule can mean moving an uncharged appointment, or granting a makeup for an appointment already charged. Those are different cases. Write down which applies.

Uncharged original: moving the date does not itself use a credit. Charge once when the replacement lesson is delivered, if that is the agreed policy.
Charged original with a makeup entitlement: track the replacement against the original charge. Do not deduct a second package credit merely because another appointment exists.
Reversed original charge: restore the credit with a linked correction, then handle the later lesson normally. Do not both restore a credit and grant a separately uncharged makeup by accident.

The exact policy is yours to agree with the client. This worksheet does not decide contractual rights, refunds or whether a specific missed lesson should be charged.

Reconcile before sending a statement

Check the opening balance against the last statement.
Match new package credits to the correct receipt and client. Do not guess from an unlabelled payment.
Review cancellations and makeups against the agreed policy, including any pending dispute.
Link corrections to their original entry and record a reason.
Recalculate the closing balance and share the dates, outcomes and credit movements that explain it.

If a payment is not identified yet, mark it unresolved in your payment records. Avoid treating an unexplained transfer as either a confirmed package or proof that the client still owes you.

Copy a starting template

Use this in your own document or spreadsheet. Keep any real client information private, and share only that client’s statement.

Client reference:
Credit unit / lesson duration:
Agreed cancellation & makeup policy version:
Statement period:
Opening credit balance:

Date | Event reference | Outcome | Credit change | Balance | Reason

Package / receipt reference:
Unresolved payment or attendance questions:
Closing credit balance:

For a piano studio, “one 30-minute lesson credit” is clearer than an unexplained “1”. If a longer lesson uses two credits, agree and record that basis before applying it.