Dance Studio Business Profit Tracker Excel for your dance studio — family plans, class log, expenses, and a monthly P and L dashboard. Know what every family actually pays — and whether the month actually made money.…
About this template
Dance Studio Business Profit Tracker Excel for your dance studio — family plans, class log, expenses, and a monthly P and L dashboard. Know what every family actually pays — and whether the month actually made money. Built for dance studio owners who need to know, family by family and class by class, what the class package is really worth per class — without accounting software. If a family is eating hours at a discount rate, this workbook shows it before the next class package.
$39
Excel & Google Sheets template — instant download on Etsy
Family and Class Package — family, class package, monthly tuition, classes per month, effective rate, add-on revenue, and total monthly revenue for every family. Change a fee and the rate and totals update.
Class Log — date, family, task, hours, hourly rate, amount, and whether it was billable for every class. Retainer rates are pulled from sheet 1 by formula; add-on classes are priced per class.
Expenses — rent, supplies, software, marketing, insurance, licensing, and other overhead, with a monthly cost for each.
Monthly P and L — revenue, rent, supplies, software, marketing, insurance, licensing and other expenses by month, Jan-Dec, with net profit and margin. Revenue is a formula from the Class Log.
Dashboard — total revenue, families, hours, billable vs non-billable hours, capacity used, average rate, expenses, net profit and margin, best and weakest families, revenue by family, costs by category, and hours by family.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Dance Studio Business Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Dance Studio Business Profit Tracker track?
The Dance Studio Business Profit Tracker tracks Family and Class Package; Class Log; Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: 12 families; monthly fees 2,280; add-on revenue 530; total revenue 2,810.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.