Music Teacher Billing Spreadsheet, Lesson Invoices and Makeup Credit Tracker, Google Sheets and Excel

A music teacher billing spreadsheet and private lesson tracker that turns your lesson log into family invoices, makeup credits and studio income totals - all in one file.

Made for piano, voice, guitar and violin teachers, tutors and any one-on-one instructor who bills families per lesson or by monthly tuition. Log each lesson once with what happened (attended, cancelled, makeup, no-show) and every charge, credit, invoice and balance works itself out. Nothing hidden: problems are flagged on the Dashboard, and it says ALL CLEAR only when every check passes.

WHAT IT DOES FOR YOU
- Monthly family invoices: pick a family and a month. Every sibling's lessons, tuition, books and fees, the payments received, the previous balance and the balance due fill in - with an invoice number, date and due date. Prints on one page or saves as PDF.
- Two billing plans: per lesson (each lesson charged at the student's price) or monthly tuition (a flat amount from a start month to an end month; lessons show "In tuition").
- Makeup credits by your cancellation policy: cancelled with notice earns a credit up to your yearly limit, teacher cancellations always earn one, a makeup lesson uses one. Credits are counted in date order and printed on every invoice. A makeup with no credit left, or a cancellation over the limit, is flagged.
- Late cancels and no-shows: charged for per-lesson students, no credit for monthly-tuition students.
- Prices: up to 6 lesson types (30, 45, 60 minutes, group class...), an optional rate override per student and a sibling discount % that applies to lessons and tuition.
- Charges and credits: recital fees, method books, materials, summer break credits.
- Family balances: opening balance, lessons, tuition, other charges, payments and balance for every family - who owes and who has credit on account.
- Studio Dashboard: billed, collected, expenses and net income, outstanding and credit, lessons taught, makeup credits left, a month-by-month table and chart, expenses by category, payments by method, and problem flags by tab.

WHAT'S INCLUDED
- ReadyFileCo-Lesson-Studio-Billing.xlsx with 10 tabs: Start Here, Settings, Students, Lesson Log, Charges & Credits, Payments, Expenses, Families, Invoice, Dashboard
- Quick-Start Guide (PDF) with a one-click "Get your Google Sheets copy" link
- Example data for a fictional music studio (14 students, 10 families, 2026) so you can see how it works, plus easy steps to clear it
- Room for 40 students, 30 families, 1,500 lessons, 200 charges, 500 payments and 300 expenses

HOW IT WORKS
1. Settings: your studio name, payment instructions, lesson prices, billing month and cancellation policy.
2. Students: one row per student - the family who pays, lesson type, per lesson or monthly tuition.
3. Log lessons and payments as they happen, then pick a family on the Invoice tab and print or save as PDF.
Google Sheets: click the link in the Quick-Start Guide and choose "Make a copy". Excel: open the .xlsx file.

WORKS IN
- Microsoft Excel 2010 or newer (Windows or Mac)
- Google Sheets (free): use the link in the guide, or upload the file and choose File > Save as Google Sheets
- Not tested in Apple Numbers

PLEASE NOTE
- You need a computer to set it up; viewing on a tablet works, but typing is easiest on a computer.
- This spreadsheet organizes your studio's billing records and estimates. It is not tax or legal advice - ask a tax professional about deductions and self-employment tax.
- This is a digital download. Nothing will be shipped. You'll get a .zip file (spreadsheet and guide) and a separate Quick-Start Guide PDF.
- License: for use by one teacher or studio. Please don't resell or share the file.
- Colors on your screen may vary slightly from the listing images.
- This template was designed by ReadyFileCo with the help of AI tools.

Questions? Message ReadyFileCo on Etsy. I'm happy to help.