A dance studio needs five revenue reports: money received, tuition by class, failed and overdue payments, refunds and credits, and a payout reconciliation against your bank. Run the first two weekly, the others as often as your billing cycle demands, and review the full picture monthly. Everything else, including profit and loss, cash flow and retention, builds on those five.
This guide shows what each report should contain, how often to look at it, and how to move from a pile of spreadsheets to one reliable source of numbers. It is written for studio owners and administrators who want to know where the money came from, where it went and what to do next.
TL;DR
- Track five core revenue reports: payments received, income by class or category, failed and overdue payments, refunds and credits, and processor payouts matched to your bank deposits.
- Check receipts and failed payments weekly. Review the whole financial picture monthly, because that cadence is what supports decisions on pricing, promotions and growth.
- Revenue is not profit and it is not cash. Keep the income statement and cash flow view separate, because payment plans and expense timing make them differ.
- Keep transaction-level records. The IRS expects records that clearly show income and expenses, and a report you cannot trace back to individual payments is hard to defend.
- Moving from spreadsheets starts with standard categories and payment statuses, then one system that feeds every report.
Table of Contents
- The five revenue reports every dance studio needs
- What the five reports look like side by side
- How often to run them
- Revenue is not profit and it is not cash
- Metrics worth putting next to the revenue numbers
- Keep transaction-level records
- Our perspective: reports should come from the work, not after it
- Moving from spreadsheets or an older system
- Where StudioFlare fits
- Common mistakes with studio revenue reports
- FAQ
- Sources
The five revenue reports every dance studio needs
Most studio owners say they "look at the numbers", but the numbers they see are often a bank balance and a half-updated spreadsheet. A bank balance tells you what arrived. It does not tell you which family paid, for which class, or what is still outstanding. These five reports do.
1. Payments received
This is the foundation: a list of every payment received in a date range. Each line should carry the date, the student or family, the amount, the payment method and what it paid for. You should be able to filter by date, by family and by payment type (card, cash, check, autopay), and the report should total the result.
It answers the simplest and most important question: how much money came in this week, and from whom? When a parent says "I already paid", this is the page you open.
2. Income by class or category
The same money, grouped differently. Instead of listing families, you list classes, programs or revenue categories: recreational classes, competition team, private lessons, camps, recital fees, costumes, merchandise. Each row shows the income it produced.
This is the report that tells you which offerings carry the studio and which are quietly subsidized. The IRS makes the same point in its guidance on recordkeeping: good records are not only for taxes, they are how you monitor how the business is doing and which parts of it perform best.
3. Failed and overdue payments
In a studio running automatic monthly tuition, a declined card is the most common leak. You need a live list of payments that failed, who they belong to, how long they have been outstanding and whether a retry is scheduled. Without it, collections depend on someone remembering to check.
A useful version shows the amount, the due date, the number of days overdue and the last contact. If you want a deeper look at how billing structure affects these numbers, our guide to tuition payment plans that keep revenue predictable covers the setup choices.
4. Refunds, credits and adjustments
Refunds and credits should appear as their own lines on the date they happened, not be silently netted against tuition. If a family drops mid-month, receives a prorated credit or gets a deposit returned, you want to see it. Otherwise gross income looks healthier than it is, and a dispute months later becomes a guessing game.
Proration is the usual source of these entries. Our proration playbook with three formulas shows how to calculate them consistently, so the report matches what parents were told.
5. Processor payouts versus bank deposits
If you collect tuition through a payment processor, the money that lands in your bank account is not the same as what families paid. Fees are deducted, refunds are subtracted and deposits are batched. A payout report lists each batch with the charges, refunds, fees and net amount, so you can match it to the line on your bank statement.
This reconciliation is what makes every other report trustworthy. When the payout total and the bank deposit agree, you know the payments report is complete.
What the five reports look like side by side
| Report | Main question it answers | Key columns | Suggested rhythm |
|---|---|---|---|
| Payments received | Who paid what, and when? | Date, family, amount, method, purpose | Weekly |
| Income by class or category | Which programs earn the most? | Class or category, income, number of students | Monthly |
| Failed and overdue payments | What money is at risk? | Family, amount, due date, days overdue | Weekly, or daily in the first week of the month |
| Refunds, credits, adjustments | What did we give back? | Date, family, reason, amount | Monthly |
| Payout reconciliation | Does the bank match the records? | Payout date, gross, fees, refunds, net | Monthly |
How often to run them
Studios commonly split reporting by frequency, and it is a sensible habit. The point is to match each report to how quickly the problem it catches becomes expensive.
Daily or at each billing run
During the first days of the month, when autopay charges run, glance at failed payments. A declined card caught on day two is a quick text. Caught on day twenty, it is an awkward conversation and possibly a lost family.
Weekly
Once a week, look at payments received and the overdue list. Fifteen minutes is enough. Check that the week's deposits look normal, that registrations for upcoming sessions are coming in and that nobody has been sitting in arrears for more than a cycle.
This is also the right time to compare enrollment against attendance. A family that pays but has stopped coming is a retention risk, not a safe account. Our guide to managing dance studio attendance without the clipboard explains how to capture that data without extra work.
Monthly
Monthly is the review that matters most. The U.S. Chamber of Commerce recommends reviewing financial reports every month, and notes that this cadence can inform decisions on pricing, promotions, productivity and growth. Established businesses may look at some financial and marketing reports quarterly, but a studio with monthly tuition has a monthly rhythm anyway.
At the monthly review, run income by category, refunds and credits, and payout reconciliation, then read your profit and loss statement alongside them.
Quarterly and at season changes
Dance studios have a calendar business owners feel in their bank accounts: registration surges in late summer, recital costs in spring, slower stretches in between. Once a quarter, compare the same period to the one before. Look at how many students are active, average revenue per student and which programs grew or shrank. Review pricing before a new season opens, not after.
Revenue is not profit and it is not cash
A revenue report tells you what your studio earned. It does not tell you whether you made money, and it does not tell you whether you can make payroll next Friday. These are three different views.
The U.S. Chamber describes four core financial statements: the income statement (profit and loss), the balance sheet, the statement of shareholders' equity and the cash flow statement. Together they show where money came from, where it went and where it stands now. The income statement specifically reports the revenues earned and the expenses incurred, and the resulting net income or loss, for a specific period.
For a studio, the practical split looks like this:
- Revenue report: tuition, fees and retail income by date, family and category.
- Profit and loss: that revenue minus rent, instructor pay, processing fees, insurance, music licensing, marketing and costumes.
- Cash flow: what actually moves in and out of the account, which is shaped by payment plans, annual recital fees paid early and expenses that arrive in lumps.
A family that pays a year of tuition in September gives you cash now and revenue across the year. A big costume order in March is cash out well before the recital income arrives. Keep cash flow planning separate from the profit and loss, so a strong revenue month does not trick you into spending money you need in August.
Payroll belongs in the same review
For most studios, instructor pay is the largest expense after rent. Reading it next to revenue by class shows whether a program covers its own teaching cost. If your time clock and payroll data live in one place and your income lives in another, that comparison takes an afternoon. If they sit together, it takes minutes.
Metrics worth putting next to the revenue numbers
Revenue totals are lagging indicators. By the time a month's income drops, the cause happened weeks earlier. Add a few leading numbers to the same review.
- Active students. Count the students who are currently enrolled and attending, not everyone in your database. Historical records inflate your sense of size.
- Average revenue per active student. Total tuition income divided by active students. If it falls while enrollment rises, discounts or lower-priced classes are doing more work than you think.
- Enrollment by class. Fill rate shows where to add a section and where to merge two.
- Attendance. Falling attendance usually shows up before cancellations do. A simple rule is to reach out after a student misses two classes in a row.
- Cancellations and drops. Track how many families leave each month and when in their first year. Early dropouts point to onboarding problems rather than price.
If you want a method for measuring recurring cancellations and testing retention changes, this walkthrough on measuring membership retention is a practical companion. For the dance-specific version, our 90-day playbook for stopping early dropouts turns the same numbers into actions for the first three months of a student's enrollment.
Be careful with industry benchmarks you find online. Churn rates and retention-to-profit claims circulate widely, but many come from blogs without a traceable method. Use them as a rough orientation at most and rely on your own trend line, month against month.
Keep transaction-level records
A report is only as good as what stands behind it. The IRS says in Publication 583 that you may use any recordkeeping system suited to your business, as long as it clearly shows income and expenses. The publication also expects records that identify the source of receipts, separate business from nonbusiness and taxable from nontaxable money, and support the income, deductions and credits you report.
For a studio, that means a revenue total should always trace back to individual payments: this family, this amount, this class, this date. A summary that cannot be broken down is a liability at tax time.
The IRS's current recordkeeping guidance adds that businesses should keep supporting documents such as sales slips, invoices, receipts, paid bills and canceled checks. It also describes a basic system with daily and monthly summaries of cash receipts and records of employee compensation. Your monthly revenue export, saved with the payout report, covers a good part of that.
For the bookkeeping side, from chart of accounts to monthly close, see our practical setup guide to bookkeeping for dance studios. For tax questions specific to your situation, talk to a CPA or enrolled agent who works with small businesses.
Our perspective: reports should come from the work, not after it
We built StudioFlare for dance studios only, and that shapes how we think about reporting. Most of the report pain we hear about is not about missing formulas. It is about data scattered across a registration form, a spreadsheet, a payment processor and a group text thread, so every report starts with copying and reconciling.
Our view is simple. If registration, billing, attendance and communication happen in one system, the revenue report is a byproduct of running the studio rather than a separate chore. A payment is recorded when it is made, tied to the family and the class. A failed charge shows up the same day. An attendance record sits beside the enrollment it belongs to.
We also think studios should pay for the students they actually serve. Historical records do not cost you anything to keep, and they should not inflate your software bill. That is why our per-student charge applies to active students only.
And a report is only useful if someone reads it. That is why we added an AI assistant that answers everyday questions about classes and payments directly, so an owner does not need to build a pivot table to learn who is behind on tuition.
— StudioFlare Team
Moving from spreadsheets or an older system
Switching is easier if you treat it as a data cleanup first and a software change second. Here is a sequence that works.
- Decide on one source of truth. Pick the system that will hold every payment going forward. Everything else becomes a reference copy.
- Standardize categories. Agree on a short list: tuition, registration fees, costume fees, recital fees, private lessons, camps, retail. Map your old labels onto it before you import anything.
- Standardize payment statuses. Paid, pending, failed, refunded, credited. If your spreadsheet used colors or notes, translate each into one of these.
- Import active families and open balances. You do not need years of old records inside the new system. Bring in current students, current plans and anything outstanding, and archive the rest.
- Reconcile to your bank and processor. For the first month, match every payout to the deposit it produced. If they agree, your reports can be trusted.
- Keep the archive. Export old records and store them with your supporting documents. The IRS expects records that clearly show income and expenses, and the U.S. Chamber suggests choosing tools that integrate with your existing software and automate your financial statements.
Then run your first monthly review in the new system and compare it to the previous month's spreadsheet total. Small differences are normal while categories settle. Large ones mean something was mapped wrongly, and it is far easier to find in month one.
Where StudioFlare fits
StudioFlare brings online registration, automated tuition billing through Stripe, attendance and check-in, revenue tracking, reports and exports, and the staff time clock and payroll into one platform for dance studios. Because the data is entered once, the reports described above draw on the same records your front desk and parents already use.
Pricing is month to month, with no setup fee and no contract: Starter is $29 per month and Pro is $49 per month, plus $1 per month for each active student. Livestreaming is available as an add-on without a published price. You can see the plans on our pricing section, or look at the dashboard and features to see what reporting looks like in practice.
Common mistakes with studio revenue reports
- Counting registrations as revenue. A signed-up family has not paid until the payment clears. Report received money and expected money separately.
- Netting refunds into tuition. You lose the ability to see how often you give money back, and why.
- Mixing deposits with earned income. Deposits are held against a future class or event. Our checklist on class deposits explains how to handle them cleanly.
- Treating private lessons as an afterthought. They often have their own cancellation rules and pay rates. Our private lesson policy guide shows how to set policies that match your accounting.
- Reviewing only when something looks wrong. Monthly review on a fixed day catches the slow problems, such as creeping discounts, that never trigger an alarm.
- Ignoring the fee schedule. Families often face 20 to 30 percent more in costs beyond base tuition. If those fees are not tracked as their own categories, you cannot see how much of your income they represent. Our tuition fee schedule guide covers what to itemize.
FAQ
What is the most important revenue report for a dance studio?
The payments received report, filtered by date range, is the most important because every other number depends on it. It lists who paid, how much, when and for what. If it is accurate and traceable to individual transactions, you can build income by class, overdue lists and monthly totals from it.
How often should I review my studio's financial reports?
Review them monthly. The U.S. Chamber of Commerce recommends monthly review for small businesses, noting that more established companies may look at some reports quarterly. Add a quick weekly check of payments and failed charges so problems do not wait a full month.
What is the difference between a revenue report and a profit and loss statement?
A revenue report shows money earned from tuition, fees and sales. A profit and loss statement, also called an income statement, subtracts expenses such as rent, instructor pay and processing fees to show net income or loss for a period. You need both, and you also need a separate cash flow view.
Do I need to keep payment records for taxes?
Yes. The IRS expects businesses to keep records that clearly show income and expenses, along with supporting documents such as invoices and receipts. Keep transaction-level detail and your monthly exports, and ask a CPA or enrolled agent what applies to your studio.
Can I move from spreadsheets without losing history?
Yes. Import active families and open balances into the new system, then export and archive the older records. Reconcile the first month's payouts against your bank deposits to confirm the new reports match reality.
Sources
- IRS Publication 583, Starting a Business and Keeping Records (December 2024)
- IRS Publication 583 (Rev. January 2021)
- Key Statements of Financial Reporting, U.S. Chamber of Commerce
- Monthly Reports Every Small Business Should Monitor, U.S. Chamber of Commerce