Music Teacher Spreadsheet, Excel and Google Sheets, Piano Lesson Tracker, Student Tuition Invoice, Practice Log, Music Studio Planner

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/FDZ7GQ82B2U

✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers).

Run your private music studio from one file: your student roster and rates, a weekly lesson schedule that builds itself, attendance with makeup credits, monthly tuition with sibling discounts and late fees, a printable invoice, practice logs, repertoire and exam grades, recitals, your lending library, expenses, profit and tax set-aside. Works in Microsoft Excel and Google Sheets.

★ WHAT'S INCLUDED ★
• 15 tabs with a clickable Start Here page
• Dashboard: 16 KPI tiles (active students, tuition collected, net profit, average rate per lesson, pay per teaching hour, outstanding tuition, 12 month retention, new students, attendance, makeups owed, average practice minutes, hours taught, upcoming exams, next event, library items overdue and tax set aside), a month by month table, tuition to collect, upcoming exams, upcoming events, birthdays and makeups owed, plus 5 charts
• Students (60 rows): instrument, level, birthday, parent / guardian contact, lesson day, start time, length, billing (monthly plan or per lesson) and an optional custom rate. Age, months with you, per lesson rate, monthly tuition, sibling flag, attendance this term, makeups owed, balance due, paid this year, 4 week practice average, next exam and a Heads up flag (balance due, makeup owed, low practice, birthday soon, follow up trial) fill in
• Schedule: a weekly lesson grid (Monday to Sunday) built from each student's lesson day, time and length, color coded by instrument, with lessons, teaching hours and weekly tuition per day, your busiest day and a lessons per day chart
• Lesson Log (700 rows): date, student, lesson type (regular, makeup, trial, extra), attendance, notes and practice assignment. Makeup credits and whether the lesson is charged follow your own cancellation policy on Setup
• Tuition (700 rows): one row per student per month with lessons, extras, discounts and payments. Tuition, sibling discount, due date, late fee, balance, status (Paid, Paid late, Partial, Due, Overdue) and days late fill in
• Invoice: pick a student and month for a clean printable invoice with line items, balance due and the lessons from that month
• Practice Log (500 rows): minutes for each day of the week, total, days practiced, % of the weekly goal for the student's level, plus a 10 week chart for any student you pick
• Repertoire & Exams: pieces (250 rows) with progress bars, stage and target date flags, and exams (100 rows) with board, grade, registration deadline, exam date, fee, mark and result (Distinction, Merit / honors, Pass) using marks you can edit
• Recitals & Events: events (15 rows) with performers, fees in, costs and net, a performer and program order list (150 rows) that shows each piece's stage, and an editable event checklist with do-by dates
• Music Library (150 items): lend books, sheet music and instruments with due back dates and overdue flags
• Income & Expenses: expenses (400 rows, tag an event to count it in that event's net) and other income (150 rows) such as camps, workshops and accompanying
• Profit & Tax: monthly income, expenses and net profit, suggested tax set-aside vs what you actually set aside, quarterly estimated tax payments, expenses by category and 2 charts
• Rate Planner: try a rate increase, students leaving and new students joining to see weekly hours, monthly and yearly tuition and pay per teaching hour, plus a new rate card and chart
• Setup: studio details, lesson rates by length (per lesson and monthly plan), due day, grace days, late fee, sibling discount, makeup policy, trial fee, practice goals by level, exam boards and every drop-down list
• Sample data from a small home studio so you can see how it works

★ PERFECT FOR ★
✓ Private piano, guitar, voice, violin and other music teachers
✓ Home studios and teachers who travel to students
✓ Teachers who want tuition, makeups and practice in one place
✓ Studios that run recitals, exams and a lending library

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, add your studio name, lesson rates, due day, late fee, makeup policy and practice goals.
3. Add your students with their lesson day and time, then log lessons, practice and monthly tuition.
4. The schedule, invoices, dashboard, profit and tax set-aside update themselves.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• This is a record keeping tool, not financial or tax advice. Exam marks in the file are examples: check your exam board's current marking scheme.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.