Lesson & Student Billing Tracker

KNOW WHO'S PAID. AND WHO HASN'T.

WHY THIS ONE

• Built for how lessons really work: prepaid packages that count down, pay-per-lesson students, late cancels, no-shows and makeup credits, all in one file.
• Family billing: siblings share one family, so each family gets one monthly statement.
• Built for real use: gray cells are the only place you type, and formulas are protected so nothing breaks.
• Buy once: no subscription, no app, no monthly fee.

For music teachers, tutors, swim and sports coaches, personal trainers, art and dance instructors, and anyone who teaches lessons.

WHAT IT DOES

• Lesson Types: minutes and price for each lesson you offer, with the per-hour rate.
• Students: family (who pays), usual lesson, and billing: Prepaid package or Pay per lesson. PACKAGE LEFT, charges, paid, OWED (or credit) and makeup credits fill in. Status shows PACKAGE LOW, PACKAGE USED UP, OWES, HAS CREDIT or PAID UP.
• Packages and Payments: log package purchases and pay-per-lesson payments by date.
• Lesson Log: one row per lesson: Attended, Late cancel (charged), No-show (charged), Cancelled (no charge), Cancelled - makeup owed, or Makeup lesson. Charges and package use fill in.
• Family Statement: pick a family and month: every lesson, what happened, charges, payments, balance owed and package lessons left. Print it or save as PDF.
• Monthly: lessons taught, teaching hours, money in, late cancels + no-shows, active students, and what you really earn per teaching hour.
• Overview dashboard with a money-in-by-month chart and what needs attention.
• A Start Here tab with step-by-step instructions.

WHAT THIS IS NOT (no surprises)

• Not a scheduling or calendar app: use your calendar for times, this for money and attendance.
• Doesn't send reminders or charge cards: you send the statement yourself.

Works In: Google Sheets (free Google account) on a computer or phone, AND Microsoft Excel: a tested Excel version (.xlsx) is included for Excel 365, Excel 2021 or newer, and free Excel for the web.

What You Get: a PDF with a link to make your own copy in your Google Drive, plus a download link for the Excel version. Digital product.

Great for: Music Teacher, Tutor Business, Lesson Tracker, Piano Teacher, Studio Billing, Lesson Packages, Student Tracker, Attendance Tracker, Coach Business, Private Lessons, Makeup Lessons, Tutoring Invoice, Google Sheets