Key takeaways
- Prepaid lessons are tracked as a liability per student.
- Cancellations consume, earn or defer by a fixed rule.
- Teacher pay derives from the pay type.
- Every teacher reads Healthy, Thin or Loss.
Blue Note Music Studio sells lessons four at a time. By the second week of August the account looks healthy, but most of that money belongs to lessons not yet taught, three students are holding make-up credits nobody has written down, and the voice teacher's split was renegotiated last year to a number the owner has to look up. LessonDesk US records the package, the lesson and the pay rule once, so the studio always knows what it owes.
Prepaid lessons are a liability
Every package records the lessons included and the price paid, so the per-lesson value, the lessons used and the lessons remaining all derive from the lessons actually logged against that package.
Remaining lessons times the per-lesson value is what the studio still owes in teaching, and the dashboard totals it across every student so the cash in the account is read honestly.
Cancellations follow a rule
A lesson is logged as attended, late cancelled or early cancelled. Attended and late-cancelled lessons consume a package lesson and earn its value; an early cancellation consumes the lesson but earns nothing yet.
The early cancellation earns a make-up credit with an expiry date, and the credit reads Open, Used or Expired, so the studio knows exactly how many lessons it still owes without being paid again.
Teacher pay from the pay type
Each teacher carries a pay type: a flat amount per lesson, or a percentage of the lesson's value. The pay for every attended or late-cancelled lesson derives from that rule, and an early cancellation pays nothing.
A make-up lesson earns the value the early cancellation deferred and pays the teacher on the same rule, so an open credit is a lesson the studio still owes, not money it has already made.
What each teacher returns
The teacher summary totals lessons taught, minutes, revenue, pay owed and the room cost of the time used, then labels each teacher Healthy, Thin or Loss by margin percent for the month.
A senior teacher on a generous split and an hourly tutoring slot paid at a flat rate can both read Loss against the same package price, and the fix is different in each case.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
LessonDesk US Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No online lesson scheduling or booking calendar, no teacher payroll or contractor tax filing, no card processing or automatic tuition billing, no student progress or grading records, and no attendance reminders by text or email.

