Lesson packages: the countdown that keeps a studio solvent
A teaching studio runs on families and goodwill, which is exactly why its books drift: nobody wants to interrupt a good lesson streak with an invoice conversation. But packages create a hard number — lessons purchased minus lessons taught — and when it quietly goes negative, the studio is teaching free while the awkwardness compounds. The countdown isn't unfriendly; it's what keeps the relationship clean.
One log line per lesson; the roster fills itself
Date, student, instrument — ten seconds after the lesson ends. Counted against each student's package, LESSONS LEFT stays live: amber at your warn level ("renew soon," raised while the family is mid-streak and happy), red past zero, where the read should say what it means — unpaid lessons. The sample studio in our workbook carries a student 9 lessons past a 10-pack: $495 of teaching, given away one polite Monday at a time. Timing the renew conversation two lessons early is the entire fix.
Make-ups, sibling rates, and recital comps — without breaking the books
Studio life is full of exceptions, and they're where package books usually die. The rule that survives: every lesson logs, and a per-lesson rate override handles the exception. A recital-week comp logs at $0 — it counts against the package (the slot was taught) without pretending to be revenue. A sibling sharing the hour logs at the sibling rate. Billed stays billed, paid stays paid, and the balance — billed minus paid — stays meaningful: package credit sits as a negative balance burning toward zero, and a positive balance is an invoice, not a mystery.
The lesson log, the package countdown, and the honest balances
The Music Teacher Studio & Lesson Tracker runs this system live: a ten-second lesson log with instrument dropdowns and rate overrides, packages counted down with renew-ambers and past-the-package reds, balances netting billed against paid per family, and a dashboard naming the mainstay, the renew talk, and the invoice to send. Excel & Google Sheets, pure formulas.
Policy is yours; the ledger just remembers
Whether packages expire, how make-ups work, what a no-show costs — those are studio policy, set by you and stated to families up front. The books don't make those calls; they make sure that whatever policy you run, the count and the money underneath it are never a guess.