Flexibility and mobility coaches who run memberships, session packages, and drop-in classes deal with a messy billing picture at the end of every month. Stripe charges, MindBody invoices, PayPal transfers, and the occasional manual bank transfer all land in different places. Reconciling them without a clear process means missed revenue, duplicate charges, and disputes that could have been caught in week one. A trained virtual assistant running a monthly billing reconciliation SOP keeps every dollar accounted for and flags problems before they become client complaints.
What Monthly Billing Reconciliation Covers for a Flexibility Coach
Monthly billing reconciliation is not just checking that payments came in. It is a systematic comparison of what should have been charged against what was actually collected, plus a record of any exceptions.
For a flexibility and mobility coach, the billing picture typically includes monthly membership subscriptions billed through Stripe or MindBody, session pack purchases that may have been bought at any point during the month, drop-in class fees, and any one-off charges such as workshops or retreats. If you sell digital products - mobility programs, video libraries, self-paced courses - those transactions come through a separate channel and need to be included in the same monthly close.
Your VA pulls records from each payment source and cross-references them against your client roster in a master reconciliation spreadsheet. The goal is a single document that shows, for every active client, what they were supposed to pay, what they actually paid, and whether any action is required.
Tools your VA will work in: Stripe dashboard (for direct charges and subscriptions), MindBody or Vagaro (for studio bookings and memberships), GoHighLevel (if you run automated billing follow-ups through your CRM), Google Sheets (for the master reconciliation log), and your email inbox for any manual payment confirmations.
Step-by-Step SOP for a VA Running Monthly Reconciliation
Run this process in the first three business days of each new month, covering the prior month.
Step 1: Export payment records from each source.
Pull a full transaction export from Stripe for the prior month - CSV format, all successful and failed charges. Do the same from MindBody or Vagaro. If you use PayPal for any clients, export that report too. Save each file with a consistent naming format: stripe-2026-04.csv, mindbody-2026-04.csv.
Step 2: Update the master client roster. Open the Google Sheets reconciliation template. Confirm the client list is current - add any new clients who joined during the month and mark any clients who cancelled. Pull the expected billing amount for each client from their contract or membership tier.
Step 3: Match payments to clients. For each transaction in the Stripe export, match it to a client in the roster. Use the customer email or Stripe customer ID. Mark matched transactions as reconciled. Repeat for each payment source.
Step 4: Flag exceptions. Any client in the roster who does not have a matching payment is a flag. Common exceptions:
- Failed card (Stripe marks these as
failedorrequires_payment_method) - Paused membership that was not reflected in the export
- Duplicate charge (same client charged twice)
- Amount mismatch (client was on an old pricing tier)
Create a separate exceptions tab in the spreadsheet with the client name, expected amount, actual amount, and a notes column.
Step 5: Send failed payment follow-ups. For each failed charge, send the client a payment retry notification using your approved email template. Most failed charges are card expirations - a simple "your card on file has expired, please update your payment method" message with a Stripe payment link resolves the majority. Set a three-day window and follow up once by SMS if no action is taken.
Step 6: Flag disputes and refund requests. Any Stripe dispute or refund request gets escalated to the coach immediately with full context: client name, payment history, what service was delivered, and any prior communication. Do not attempt to respond to disputes without coach sign-off.
Step 7: Deliver the reconciliation report. By the third business day of the month, send the coach a summary covering: total collected, total outstanding, number of failed charges, number resolved, and any unresolved exceptions. Attach the reconciliation spreadsheet.
A virtual assistant who owns this process monthly eliminates the chaotic end-of-quarter scramble most solo coaches experience. Pair billing reconciliation with your payroll processing and KPI dashboard setup. BLS notes bookkeeping and financial tracking roles remain essential for service businesses.
What Good Reconciliation Results Look Like
A well-run monthly reconciliation process has measurable outcomes you can track over time.
Failed charge recovery rate. Track how many failed charges were resolved within the billing month versus carried into the next month. A well-managed process recovers at least 70-80% of failed charges within seven days through prompt follow-up.
Days to close. The reconciliation report should be complete within three business days of month-end. If it takes longer, the process or the data sources need to be streamlined.
Exception rate. Monitor the percentage of clients who have an exception each month. If the exception rate is climbing, the underlying billing setup needs attention - pricing tiers may be misaligned, or Stripe subscriptions may not match the client list in the booking software.
Revenue variance. Compare expected monthly recurring revenue against actual collected revenue. A consistent gap indicates churn, paused memberships, or billing errors that are silently reducing income.
Run these metrics in a simple dashboard tab within the same Google Sheet. The coach gets a one-page view of billing health every month without touching a single payment record.
Frequently Asked Questions
How long does monthly billing reconciliation take for a small flexibility coaching practice?
For a practice with fewer than 50 active clients across two or three payment sources, a trained VA can complete the full reconciliation in two to four hours per month. The first month takes longer while the template is being built. After that it is routine.
Should the VA have full access to the Stripe account?
The VA needs read access and the ability to generate payment links for failed charge follow-ups. They do not need the ability to issue refunds or change subscription pricing. Most billing platforms support role-based access - create a restricted staff account rather than sharing your full admin credentials.
What happens if a client disputes a charge after the monthly close?
Disputes can arrive weeks after the original charge. Your VA should check the reconciliation log for the original transaction, pull the service delivery record, and escalate to you with a complete summary within 24 hours of the dispute notification. Stripe disputes have a response deadline - usually seven days - so speed matters.
Can a VA reconcile billing across multiple currencies or countries?
Yes, but the process requires additional steps to handle exchange rate conversions and tax reporting. If you have international clients, your reconciliation template needs a currency column and your VA needs to understand whether you are reporting in a base currency or tracking actuals per currency.
What tools make reconciliation easiest?
Stripe's built-in reporting is the cleanest for subscription businesses. MindBody and Vagaro have transaction export features but require some cleanup before they are usable in a spreadsheet. GoHighLevel can trigger automated failed payment sequences, reducing the manual follow-up workload. Google Sheets handles the reconciliation log well for most small coaching practices.