Dance Studio Monthly Billing Reconciliation: A VA's Step-by-Step SOP

Dance studio monthly billing reconciliation is the process your virtual assistant uses to verify that every dollar owed has been collected and every charge matches the student's actual enrollment. Dance studios have some of the most complex billing in the fitness industry. You are not just collecting a flat gym membership fee. You are tracking monthly tuition across multiple classes, costume deposits, recital fees, competition entry fees, private lesson charges, and merchandise purchases - all for students who may add or drop classes mid-semester.

Without a monthly reconciliation process, money leaks. A student drops a class but keeps getting charged. Another student adds a class but the billing never updates. A costume fee goes uncollected because it was entered incorrectly. Your VA catches all of this with a structured monthly review.

Tuition Verification Against Active Enrollment

The foundation of monthly reconciliation is confirming that every active student is being billed the correct tuition amount. This sounds simple. It is not. Class changes, family discounts, scholarship adjustments, and mid-month enrollments create constant billing variations.

The Tuition Audit Process

Your VA should complete this audit in the first three business days of each month, reviewing the prior month's billing:

  1. Pull the active enrollment roster. Export a list of every currently enrolled student with their class assignments from the studio management software.

  2. Pull the billing report. Export all tuition charges processed during the month, including successful payments, pending payments, and failed payments.

  3. Cross-reference enrollment to billing. For each student on the enrollment roster, verify:

    • The number of classes billed matches the number of classes enrolled
    • The per-class rate matches the studio's published pricing or any documented special rate
    • Multi-class discounts are applied correctly
    • Sibling discounts are applied correctly
    • Scholarship or financial aid adjustments are accurate
    • Pro-rated charges for mid-month enrollments or withdrawals are correct
  4. Identify discrepancies. Flag any student where the amount billed does not match what should have been billed. Common discrepancies include:

    • Student added a class but billing was not updated
    • Student dropped a class but is still being charged
    • Discount was applied incorrectly or not at all
    • Rate increase was not reflected in billing
    • Trial class was charged at full rate instead of the promotional rate
  5. Resolve discrepancies. For each flagged item, your VA determines the correct action - issue a credit, add a charge, adjust the ongoing billing profile - and either executes it (if within their authority) or submits it to the studio owner for approval.

Tracking Enrollment Changes

Your VA should maintain a running log of all enrollment changes throughout the month - new enrollments, class additions, class drops, withdrawals, and transfers. This log becomes the primary reference during reconciliation. If a discrepancy appears, the VA checks the change log first to determine whether the billing adjustment was simply delayed.

Fee Reconciliation - Costumes, Recitals, and Competitions

Beyond tuition, dance studios collect multiple fee types throughout the year. Each requires separate tracking and reconciliation.

Costume Fee Reconciliation

Costume billing varies by studio but typically involves deposits and final payments on a per-class basis. Your VA should:

  • Maintain a costume fee schedule showing the total cost per class/routine, deposit amounts, and payment due dates
  • Track which families have paid each installment
  • Generate a list of outstanding costume balances at the start of each month
  • Send payment reminders five days before each due date
  • Follow up on missed payments within 48 hours of the due date

Cross-reference costume payments against enrollment. If a student dropped a class before the costume order cutoff, they should not be charged. If they dropped after the cutoff, the studio's refund policy determines the outcome. Your VA needs to know this policy cold.

Recital Fee Reconciliation

Recital fees are typically a flat charge per student (not per class) collected once per season. Your VA should:

  • Confirm every recital-eligible student has been charged the recital fee
  • Verify the fee amount matches the published rate
  • Track payment status and follow up on outstanding balances
  • Cross-reference against the recital participation list - students who opted out should not be charged

Competition Fee Reconciliation

For studios with competitive teams, competition fees add another layer. These may include entry fees, coaching fees, and travel costs. Your VA tracks:

  • Per-competition charges against the competition schedule
  • Payment status for each team member per event
  • Any credits or refunds for cancelled competitions
  • Group fees divided correctly among team members

Failed Payment Recovery

Failed payments are inevitable. Credit cards expire. Bank accounts have insufficient funds. Autopay authorizations lapse. Your VA needs a systematic recovery process.

The Failed Payment Workflow

  1. Same-day notification. When a payment fails, your VA sends a text and email to the account holder within 24 hours. The message should be matter-of-fact, not accusatory. State that the payment did not process, provide the amount, and give clear instructions for updating payment information or making a manual payment.

  2. Auto-retry schedule. Most payment processors automatically retry failed payments. Your VA should know the retry schedule (typically 3, 7, and 14 days after failure) and not send duplicate manual requests during the retry window.

  3. Second notice at day 7. If the first retry fails, your VA sends a second notice. This message should reference the original failure, state the updated balance (including any late fees per studio policy), and request action within 48 hours.

  4. Phone call at day 14. If two retries and two written notices have not resolved the issue, your VA makes a phone call. This conversation is an opportunity to understand the situation. The family may be experiencing financial hardship, in which case the VA can offer a payment plan (if authorized) or escalate to the studio owner.

  5. Final notice at day 21. If the balance remains unpaid, your VA sends a formal written notice stating the total amount due, the deadline for payment, and the consequences of non-payment (typically suspension from classes until the balance is resolved).

  6. Escalation at day 30. Unpaid balances older than 30 days get escalated to the studio owner for a final decision on suspension, payment plan, or write-off.

Failed Payment Tracking

Your VA should maintain a monthly aging report showing:

  • Total number of failed payments
  • Dollar amount of outstanding failed payments
  • Aging buckets: 0-7 days, 8-14 days, 15-30 days, 30+ days
  • Recovery rate: percentage of failed payments successfully collected
  • Accounts currently in the recovery workflow with status notes

Present this report to the studio owner by the fifth business day of each month alongside the reconciliation summary.

Monthly Reconciliation Report and Documentation

The final output of your VA's reconciliation work is a clear, concise report that gives the studio owner full visibility into billing health.

Report Contents

Your VA should deliver a monthly billing reconciliation report that includes:

  • Total tuition collected vs. total tuition expected, with variance explanation
  • Fee collection summary - costume fees, recital fees, competition fees, and other charges collected vs. outstanding
  • Discrepancy log - every billing error found, the root cause, and the resolution
  • Failed payment summary - aging report, recovery actions taken, and current outstanding balance
  • Enrollment change impact - financial impact of new enrollments, class changes, and withdrawals during the month
  • Credits and refunds issued - itemized list with reasons
  • Recommendations - any process improvements, policy changes, or system updates the VA recommends based on recurring issues

Record Keeping

Your VA should archive each month's reconciliation report and supporting data. Keep at minimum 24 months of records. This history is essential for tax preparation, financial planning, and resolving any disputes that arise months after the original transaction.

Store reconciliation files in a shared cloud folder organized by month and year. Use consistent naming conventions so any authorized person can find a specific month's report quickly.

Connect reconciliation results to your payroll processing run and your KPI dashboard setup for a complete financial picture. BLS data shows bookkeeping and auditing roles are in steady demand, reflecting how much small businesses rely on accurate financial tracking to stay solvent.

Frequently Asked Questions

How often should a dance studio VA reconcile billing?

Monthly reconciliation is the standard. Your VA should complete the full reconciliation within the first three business days of each month, reviewing the prior month. Additionally, your VA should run a quick weekly check on failed payments and new enrollment billing to catch issues early.

What is the most common billing error in dance studios?

The most common error is a mismatch between enrollment and billing after a class change. A student adds or drops a class, but the billing profile is not updated to reflect the change. Monthly cross-referencing of the enrollment roster against active billing catches this consistently.

How should a VA handle a parent who disputes a charge?

Your VA should pull the student's enrollment record, the billing history, and any relevant communication (class change requests, signed agreements). Present the facts calmly and reference the studio's documented policies. If the dispute has merit, issue a credit promptly. If it does not, explain the policy clearly and offer to connect the parent with the studio owner for further discussion.

What tools work best for dance studio billing reconciliation?

Studio management platforms like Jackrabbit Dance, Studio Director, or DanceStudio-Pro include billing and reporting features designed for this purpose. Your VA can supplement with spreadsheets for custom tracking. The key requirement is that the tool connects enrollment data to billing data so cross-referencing is efficient.

When should a VA escalate an unpaid balance to the studio owner?

Escalate at 30 days past due if standard recovery efforts have not resolved the balance. Also escalate immediately if a family requests a payment plan, disputes a charge the VA cannot resolve, or indicates financial hardship. The studio owner should make the final call on exceptions to billing policy.