Pilates studio monthly billing reconciliation is the process that keeps your revenue numbers honest and your cash flow predictable. Skip it and you will discover problems months later - expired cards going unnoticed, unused session credits piling up, and membership revenue that does not match your bank deposits.
Most Pilates studios use a mix of memberships, class packs, private session packages, and drop-in rates. That complexity makes reconciliation essential. This SOP walks you through every step, from failed payment recovery to final revenue reporting.
Failed Payment Recovery
Failed payments are the most time-sensitive part of your monthly reconciliation. Every day a failed payment sits unresolved is a day of lost revenue.
Daily Monitoring (Throughout the Month)
Do not wait until month-end to catch failed payments. Set up a daily check:
- Pull the failed payment report from your booking system. MindBody, Vagaro, and Glofox all have this report.
- Review each failed transaction for the reason - expired card, insufficient funds, bank decline, or processing error.
- Categorize by type: autopay membership renewals, class pack purchases, or individual session charges.
Recovery Workflow
Day 1 (payment failure date):
- Send an automated notification to the client. Most booking platforms handle this automatically - verify yours is configured.
- Log the failure in your tracking spreadsheet (Google Sheets works well for this).
Day 3 (if still unresolved):
- Send a personal text or email from your team. Keep it simple:
Hi [Name], it looks like your payment on [date] did not go through. Could you update your card on file so we can process it? You can update it here: [link]. Let me know if you have any questions.
- Retry the payment through your booking system if the client confirms a card update.
Day 7 (if still unresolved):
- Make a phone call. Some clients ignore texts and emails but will respond to a call.
- If you reach voicemail, leave a brief message and follow up with a text.
Day 14 (if still unresolved):
- Send a final notice explaining that their membership or package will be suspended if payment is not resolved within 7 days.
- Pause their booking privileges if your system allows it.
Day 21 (if still unresolved):
- Suspend the membership. Do not cancel it outright - suspended memberships are easier to reactivate when the client is ready.
- Send a "we'd love to have you back" message with reactivation instructions.
A fitness virtual assistant can run this entire recovery workflow. They monitor the failed payment report daily, send outreach at each stage, and escalate to you only when a suspension decision is needed. Pair this SOP with payroll processing to close month-end with both sides of revenue.
Membership Credits and Package Tracking
Pilates studios sell a variety of packages. Each one has different expiration rules, session counts, and rollover policies. Reconciling these monthly prevents disputes and gives you accurate liability numbers.
What to Reconcile
- Unlimited memberships: Verify each active membership processed successfully. Check for any that should have been paused, cancelled, or downgraded.
- Class packs: Review remaining session counts. Flag packs expiring in the next 30 days so your team can notify clients before they lose sessions.
- Private session packages: Track sessions used versus sessions remaining. Confirm that instructor payroll aligns with sessions delivered.
- Complimentary sessions: Track any free sessions given for promotions, referrals, or service recovery. These affect your revenue-per-session calculations.
- Intro offer conversions: Check how many intro package clients converted to full memberships or packages. This is a key health metric for your studio.
Monthly Package Audit Steps
- Export your active memberships and packages from MindBody or Vagaro
- Cross-reference with your payment processor (Stripe, Square, or the platform's built-in processor) to confirm charges match
- Identify discrepancies - memberships showing as active with no corresponding payment, or payments processed for cancelled memberships
- Flag expiring packages and schedule client notifications
- Calculate total outstanding session liability (sessions purchased but not yet used)
Outstanding session liability matters. If you have sold 500 sessions that have not been used yet, that represents future service obligations. Track this number monthly so it does not surprise you.
Revenue Reporting
Your monthly revenue report should give you a clear picture of where your money comes from and where the gaps are.
Revenue Categories to Track
Break your revenue into these categories:
- Membership revenue: Recurring monthly charges for unlimited or limited memberships
- Class pack revenue: One-time purchases of session bundles (reformer group, mat, specialty)
- Private session revenue: Individual or packaged private and duet sessions
- Drop-in revenue: Single-session purchases at your walk-in rate
- Retail revenue: Equipment sales, grip socks, accessories
- Other revenue: Workshop fees, teacher training tuition, rental income
Building the Monthly Report
Use Google Sheets or a dedicated accounting tool. Your report should include:
- Total revenue by category (compared to previous month and same month last year)
- Revenue per session (total revenue divided by total sessions delivered)
- Revenue per client (total revenue divided by active clients)
- Collection rate (revenue collected divided by revenue billed)
- Failed payment total and recovery rate
- New membership revenue versus churned membership revenue
Pull data from your booking system and cross-reference with your bank statements. The numbers should match. If they do not, work backwards through the discrepancies until you find the source.
Common Discrepancies and How to Fix Them
- Booking system total is higher than bank deposits: Look for pending transactions, refunds processed outside the system, or payment processor holds.
- Bank deposits are higher than booking system total: Check for manual payments (cash, check, Venmo) that were not logged in the system.
- Session counts do not match instructor hours: Review class rosters for errors, double-bookings, or sessions marked as completed that were actually cancelled.
Document every discrepancy and its resolution. This creates an audit trail you will appreciate during tax season.
The Monthly Reconciliation Checklist
Complete this checklist between the 1st and 5th of each month for the previous month:
- Run the failed payment report and confirm all recoveries are logged
- Export active memberships and verify payment status
- Audit class packs and private session packages for accuracy
- Flag expiring packages and send client notifications
- Calculate outstanding session liability
- Pull revenue by category from your booking system
- Cross-reference booking system totals with bank deposits
- Investigate and document any discrepancies
- Calculate key metrics (revenue per session, collection rate, churn)
- Compare to previous month and flag significant changes
- Compile the final report and share with studio ownership
This process takes 2 to 4 hours for a single-location studio. A virtual assistant familiar with your booking system can handle steps 1 through 8 independently, leaving you to review the final numbers and make strategic decisions.
Roll billing data into your KPI dashboard so owner reports stay in sync. McKinsey reports 60% of occupations could automate 30%+ of activities.
FAQ
How often should a Pilates studio reconcile billing?
Run failed payment recovery daily. Complete the full reconciliation monthly, between the 1st and 5th of the following month. Quarterly, do a deeper audit that includes year-over-year comparisons and session liability trends.
What tools do I need for Pilates studio billing reconciliation?
Your booking system (MindBody, Vagaro, or Glofox) handles most of the data. Use Google Sheets for tracking and reporting. Your payment processor dashboard (Stripe, Square) provides the bank-side verification. No specialized accounting software is required unless you have multiple locations.
How do I handle clients with expired class packs who want to use remaining sessions?
Set a clear policy during purchase - most studios allow a 30-day grace period after expiration. After that, sessions are forfeited. Communicate this in writing at the time of purchase and again 7 days before expiration. Consistency prevents disputes.
What is a healthy collection rate for a Pilates studio?
Aim for 97 percent or higher. If your collection rate drops below 95 percent, you have a systemic failed payment problem that needs immediate attention - likely outdated cards on file or a billing date that does not align with when your clients get paid.
Can billing reconciliation be fully delegated to a virtual assistant?
A trained VA can handle 80 to 90 percent of the reconciliation process. They can run reports, chase failed payments, audit packages, and compile the monthly summary. Final review, strategic decisions, and any client escalations involving refunds or policy exceptions should stay with the studio owner or manager.