Billing errors in a yoga studio compound quietly. One failed payment ignored becomes two. A client on the wrong membership tier for three months means you have been undercharging -or overcharging -without realizing it. Monthly billing reconciliation is the process that catches these problems before they become owner headaches or client disputes. When a trained VA runs this SOP, your books close clean every month without you spending a day in spreadsheets.
This is the exact yoga studio monthly billing reconciliation workflow your VA should follow.
What Billing Reconciliation Actually Covers
Reconciliation is not just chasing declined cards. It is a full audit of three things:
- Revenue accuracy: Did every active membership charge correctly? Did class packs deduct correctly? Did intro offers expire and convert as expected?
- Failed payment recovery: Which charges failed? Why? What is the status of each recovery attempt?
- Plan integrity: Is every client on the membership tier they are supposed to be on? Are any plans mismatched, expired, or suspended in error?
Your VA runs this process once per month, starting on the 2nd business day after your billing cycle closes. Most studios bill on the 1st. That means the reconciliation window opens on the 3rd.
Step 1: Pull the Billing Report
In MindBody: Go to Manager Tools > Reports > Sales. Run the "Payments" report for the billing period. Filter by payment status: All. Export to CSV. You need both the successful and failed transactions in the same file.
In Vagaro: Reports > Financial > Sales Summary. Select the billing month. Export. Also pull the "Failed Transactions" report separately -Vagaro separates these.
In Glofox: Navigate to Payments > Transactions. Filter by date range and status. Export both "Successful" and "Failed" in separate CSVs.
The VA opens the exported data in Google Sheets. Create three tabs: Raw Data, Failed Payments, and Plan Audit.
Paste the raw export into the Raw Data tab. Apply a filter to isolate failed, declined, or pending transactions into the Failed Payments tab. Everything that processed successfully stays in Raw Data for the plan audit step.
Step 2: Work the Failed Payments List
Every failed payment gets its own row in the Failed Payments tab with the following columns:
- Client name and email
- Membership or plan type
- Amount
- Failure reason (declined, expired card, bank issue, etc.)
- Date of failure
- Outreach attempt 1 (date, method, outcome)
- Outreach attempt 2 (date, method, outcome)
- Resolution status
Day 1-2 of reconciliation window: The VA sends a direct, non-alarming email to each client with a failed payment. The message states the amount, the reason if known (e.g., "your card on file was declined"), and provides a direct link to the client portal to update their payment method. No threats, no urgency language -just a clear prompt.
Day 4-5: For clients who have not updated their payment method, the VA sends a second outreach via SMS (if opted in) or a second email. This message is slightly more direct: the account is on hold and access may be affected if payment is not resolved by [date].
Day 7: Any unresolved failed payments get escalated to the owner. The VA provides a summary row for each: client name, amount owed, number of outreach attempts, and any responses received. The owner decides whether to suspend access, offer a payment plan, or write off the amount.
The VA does not suspend memberships without owner instruction. They surface the situation; the owner acts.
Step 3: Plan Integrity Audit
This is the part most studios skip -and it is where real revenue leakage hides.
The VA cross-references the active membership list against your expected membership configuration. What you are looking for:
Expired intro offers still active. A 30-day unlimited intro offer that expired but was never converted to a paid plan means the client has been attending free. In MindBody, run the "Active Clients" report filtered by membership type and check expiration dates. In Vagaro, use the Memberships report and sort by expiry.
Wrong tier charges. A client who signed up for a premium unlimited plan but is being charged for a basic plan has a real grievance if they ever notice. Check that each client's charged amount matches their stated plan rate.
Paused memberships that should have resumed. If a client requested a pause (for travel, injury, etc.) and the pause end date has passed, confirm their billing resumed. Studios that manage pauses manually miss re-activations regularly.
Cancelled members still being charged. Run your cancellation log from the previous month and verify that each cancelled member has zero charges in the current cycle. One wrongful charge is a refund request and a trust problem.
The VA logs any discrepancy in the Plan Audit tab with the client name, the issue, and a recommended correction. Corrections that change billing amounts require owner sign-off before the VA makes any changes in the software.
Step 4: Reconcile Against Your Accounting System
If your studio uses QuickBooks, Wave, or Xero, your VA exports the final reconciled transaction summary and compares the total processed revenue figure to what shows in your accounting tool.
The numbers should match within rounding. If they do not, the VA identifies the gap line by line before closing the report. Common gap sources: refunds processed in the scheduling software but not recorded in accounting, or gift card redemptions that reduce revenue on one side but not the other.
Your VA is not your accountant. They do not make journal entries without instruction. They surface the discrepancy, document it, and flag it for your bookkeeper or CPA.
Step 5: Deliver the Monthly Summary
By the 10th business day of the month, the VA delivers a one-page billing summary to the owner. It covers:
- Total successful charges processed
- Total failed payments, amount, and recovery status
- Number of plan discrepancies found and corrected
- Any open items requiring owner decision
- Time spent on the reconciliation (for scope tracking)
This is a table and a short bullet list, not a narrative. The owner should be able to scan it in under three minutes.
A fitness virtual assistant who runs this monthly saves the average yoga studio owner 4-6 hours of administrative work per billing cycle. More importantly, they catch the revenue leakage that never shows up in your P&L because it never gets recorded. McKinsey reports 60% of occupations could automate 30%+ of activities.
Tools the VA Needs
- MindBody, Vagaro, or Glofox: report access, membership management view
- Google Sheets: reconciliation tracker
- Shared inbox: client outreach for failed payments
- QuickBooks, Xero, or Wave (view access): reconciliation cross-check
- CRM (optional): tagging clients with open billing issues
Roll billing data into your KPI dashboard so owner reports stay in sync. Pair this SOP with payroll processing to close month-end with both sides of revenue.
FAQ
How long does monthly billing reconciliation take a VA? For a studio with 100-200 active members, expect 3-5 hours spread across the first 10 business days of the month. Larger studios or those with complex membership structures take longer. Track hours the first three months to set an accurate scope expectation.
Should the VA have permission to process refunds? No. The VA identifies refund situations and flags them. Only the owner or a designated manager should process refunds, since they involve both financial and relationship decisions.
What if a client disputes a charge directly with their bank? The VA flags chargebacks to the owner immediately -same day. Chargebacks require a response within a defined window (usually 7-10 days depending on the payment processor). The VA gathers the documentation (signed contract, attendance records, prior communications) but the owner or a designated manager submits the chargeback response.
How do we prevent failed payments from happening in the first place? Enable card updater services if your payment processor offers them (Stripe and many MindBody-integrated processors do). These automatically update expired card numbers. Pair that with automated pre-billing reminders sent 3 days before the charge date.
Can this workflow be run quarterly instead of monthly? No. Quarterly reconciliation lets errors compound for too long. A client on the wrong plan for 90 days is a difficult conversation. A client on the wrong plan for 30 days is a quick fix. Monthly is the minimum cadence.