How to track coaching payments and lesson credits
A trustworthy balance should show what was charged, what was paid, what was returned, and why. This method keeps that money trail separate from the number of lessons a student still has available.
Clear definitions · Worked ledger · Weekly checklist
Money balance
Answers whether the account owes money, is settled, or has money available as a credit.
Lesson balance
Answers how many purchased sessions remain after attendance and any policy-based deductions.
Step 1
Give each transaction one clear meaning.
Do not use “payment,” “credit,” and “refund” interchangeably. A short set of definitions makes the balance explainable to you, the payer, and anyone else reviewing the account.
| Record | Meaning | Typical effect |
|---|---|---|
| Charge | Money the student or family owes | +$300 due |
| Payment | Money you received | −$300 due |
| Account credit | Money already received or granted that can cover a later charge | $60 available |
| Refund | Money returned to the payer | $60 returned |
Step 2
Keep an event ledger instead of overwriting a total.
A single balance cell tells you where the account stands but not how it got there. Add one row for each charge, payment, credit adjustment, or refund and preserve the date, amount, method, and a short reference.
| Date | Event | Charge | Payment | Running position |
|---|---|---|---|---|
| Oct 1 | Five-lesson package charged | $300 | — | $300 due |
| Oct 1 | Online payment received | — | $360 | $60 credit |
| Oct 22 | Additional lesson charged | $75 | — | $15 due |
| Oct 22 | Remaining payment received | — | $15 | $0 |
Step 3
Track purchased lessons in a separate ledger.
Money and sessions answer different questions. A family can be fully paid while still having two lessons left, or have no lessons left while holding a monetary credit. Record attendance against the package without changing the payment history.
Avoid the ambiguous word “credit” by itself.
Write “$60 account credit” for money and “two lessons remaining” for sessions. This prevents a financial credit from being mistaken for a free lesson—or the other way around.
Step 4
Reconcile exceptions once a week.
Compare the ledger with bank, card, or payment-processor activity. You should be able to trace each balance without rebuilding it from messages or memory.
- Match every received payment to one student account and payment method.
- Review outstanding charges that passed their expected payment date.
- Confirm why every account credit exists and whether it should be retained, applied, or refunded.
- Check that refunds appear both in your records and at the payment provider.
- Compare lesson usage with attendance outcomes, not only with scheduled events.
- Add a note for any manual adjustment so another person can reproduce the decision.
When a spreadsheet starts hiding the history
A spreadsheet can work for a small roster when one person updates it consistently. It becomes risky when charges, payments, package usage, and messages live in separate places or when several instructors can change the same account.
LessonSync keeps charges, payments, credits, package activity, and student history connected. Use the manual method for as long as it stays easy to explain; move when reconciliation becomes recurring administrative work.
This guide describes an operational recordkeeping method, not accounting, tax, or legal advice.