Most private teachers can name every student’s piece from memory — but couldn’t tell you, without digging through a notebook, who’s two lessons behind on payment, whose prepaid package is nearly used up, or who they still owe a makeup. Those are the balances that quietly leak money from a lesson studio, and they’re exactly what a plain list of names can’t track.
The Private-Lesson & Tutor Studio Manager turns your roster and a fuzzy sense of who owes what into one operating picture: who’s paid up, who’s owed a makeup, and what your studio actually earns each month. It’s a six-tab workbook for Excel, Google Sheets, and LibreOffice, plus five PDF guides and printable studio sheets — built for music teachers, tutors, and coaches running a recurring-revenue practice by hand.
Who’s paid up, and who’s owed a makeup
The Student Roster is the star. Fill in each student once — instrument or subject, their weekly slot, rate, and how they pay — and live columns pull straight from your Lesson Log to show, per student, the makeup credits you owe, the lessons left on a package, and the tuition collected and still unpaid. A contact list becomes a standing answer to the two questions you ask every week.
The makeup math a notebook always loses
The Lesson Log is one row per lesson, and it does the accounting a notebook can’t. Mark a lesson attended, cancelled with notice, a late cancel, or a no-show, and the workbook credits a makeup when a student cancels in time, spends that credit when you deliver the makeup, draws down a prepaid package automatically, and totals the tuition still outstanding. Makeup credits stop living in your memory — where memory always forgives — and start living in a number you both can trust.
Price a lesson from real cost
The Lesson Rate Setup tab is the floor under every price. Enter your overhead — instrument upkeep, your room, the scheduling app, method books, insurance — the salary you want to draw, and the hours you can realistically teach, and it returns your cost per teaching hour and a recommended rate for a 30, 45, or 60-minute lesson. You raise your rate with a reason, not an apology.
Plan the term, run a calm recital
The Term & Recital Planner lays out your teaching year in terms with their tuition-due dates — the date every parent asks about — and gives you a ready-made recital checklist so the concert runs on a list instead of a two-week scramble. The Dashboard rolls the whole studio into a few numbers: active students, expected monthly income, tuition collected versus outstanding, and the makeup credits you owe.
Own it, don’t rent it
This is a file you own, not a monthly app you rent. Buy once, keep it forever, and run your studio your way — no per-student fees, no subscription, no account. It sits right between a blank spreadsheet (free, but you build every formula and the makeup math yourself) and a monthly lesson app (powerful, but a recurring bill with your studio locked inside someone else’s software): the structure you need, in a file that’s yours.
Prefer Google Sheets? Your download includes a one-click “Make a copy” link to a native Google Sheet — every dropdown, formula, and calculated cell already set up and tested. No import, no fuss. Or use the .xlsx in Excel or LibreOffice. Same workbook, your choice.
Try it free first
Want a taste before you buy? The free Lesson & Payment Log is a single-tab starter — log each lesson, who attended, and whether it’s paid — a real slice of the full workbook, no signup.
When the studio outgrows a spreadsheet
A spreadsheet is a great place to learn your numbers and a hard place to run a growing studio. When the students, packages, and makeup credits outgrow a folder of files, Ardent Seller is the living version of this workbook — your students, lessons, payments, and balances tracked in one place, with income computed for you across the whole studio. There’s a free plan to start, on the same own-it ethic.
A business reference, not licensed tax, accounting, or legal advice. Every figure in the examples is illustrative — your overhead, rates, and hours are yours to enter. Whether lesson income is taxable, how you register a teaching business, and what your cancellation and makeup terms should be vary by jurisdiction; confirm your own. Created with AI assistance under Ardent Workshop’s creative direction, then reviewed and edited.
