Why Rowing Studios Need Monthly Billing Reconciliation
Rowing studio monthly billing reconciliation is the financial hygiene task most owners skip - until a member disputes a charge or revenue numbers stop adding up. Recurring membership billing looks simple. Members sign up, payments auto-draft, money flows in. But failed payments, frozen accounts, promo codes, and membership changes create a mess that compounds month over month.
A fitness virtual assistant trained on a clear reconciliation SOP catches errors early, recovers failed payments, and gives you revenue numbers you can trust. This SOP walks your VA through every step.
Preparing for Reconciliation
Your VA starts on the first business day of each month, reviewing the prior month's activity.
Gather Data Sources
Pull reports from:
- MindBody or Mariana Tek - Membership billing report, failed payment report, refund log, package sales report
- Payment processor - Stripe or Square transaction history for the month
- Bank statements - Monthly statement for the operating account
- GoHighLevel - Any manual invoices or payment links sent outside the booking platform
Save all reports to a Google Drive folder labeled with the month and year.
Set Up the Reconciliation Spreadsheet
Use a standardized template with these tabs:
- Revenue Summary - Expected revenue versus collected revenue
- Failed Payments - Declined transactions with member name, amount, date, and failure reason
- Refunds and Credits - All refunds, credits, and promo adjustments
- Membership Changes - Upgrades, downgrades, freezes, and cancellations
- Discrepancies - Line items that do not match between platforms
Your VA duplicates this template each month and fills in the data.
The Reconciliation Process
Step 1: Match Platform Revenue to Processor Revenue
Compare total revenue in MindBody or Mariana Tek against total deposits in Stripe or your processor. If they do not match, investigate:
- Transactions that processed in the platform but failed at the processor
- Refunds showing in one system but not the other
- Manual payments (cash, check) recorded in the platform but not the processor
Document every discrepancy with amount, affected member, and likely cause.
Step 2: Review Failed Payments
Failed payments are the biggest revenue leak. Common reasons:
- Expired credit card
- Insufficient funds
- Bank block on the recurring charge
- Closed account
Your VA takes action on each:
- Send a payment update request: "Hi [First Name], your membership payment did not go through. Could you update your payment method at [link]?"
- Retry the payment after 3 business days if the member has not updated
- Follow up on day 7 if still unresolved
- Escalate to the studio manager on day 14 for a decision on freezing or cancellation
Track every failed payment's status until resolved.
Step 3: Reconcile Refunds and Credits
Verify each refund has:
- A documented reason
- Manager or owner approval
- Matching amounts in both the booking platform and processor
- A confirmation message sent to the member
Flag unauthorized refunds or credits lacking documentation for immediate owner review.
Step 4: Audit Membership Changes
Review all changes processed during the month:
- New memberships - Correct plan and rate applied
- Cancellations - Date aligns with billing cycle, cancellation fees collected per policy
- Freezes - Start and end dates correct, billing paused accordingly
- Upgrades and downgrades - Rate change on correct date, prorated charges accurate
Step 5: Reconcile Against the Bank Statement
Compare total bank deposits against collected revenue. Account for:
- Processor fees - Stripe charges 2.9% plus $0.30 per transaction
- Deposit timing - End-of-month payments may land in the next month
- Non-membership revenue - Retail, drop-ins, private sessions
The bank statement is the source of truth. If numbers do not match after accounting for fees and timing, dig into transaction-level details.
Delivering the Monthly Report
Your VA compiles a one-page summary by the 5th of each month:
- Gross revenue - Total billed before fees and refunds
- Net revenue - Deposited after fees and refunds
- Failed payment total - Outstanding from declined transactions
- Recovery rate - Failed payments recovered through outreach
- Membership count changes - Net new minus cancellations and freezes
- Open discrepancies - Unresolved items needing owner attention
Review on a 15-minute monthly call with your VA. For hiring guidance, read how to hire a fitness virtual assistant. For a full overview of operational tasks, visit the fitness virtual assistant tasks list.
FAQ
How long does monthly billing reconciliation take?
For a studio with 100 to 300 active members, expect 4 to 6 hours spread across the first week. The initial report pull takes 30 minutes. Failed payment outreach continues throughout the month.
What is a healthy failed payment rate?
Industry benchmarks for boutique fitness sit between 5% and 10% of recurring charges. Above 10%, review your collection practices - require backup payment methods, send pre-billing reminders, or switch to a processor with better retry logic.
Should my VA have access to the bank account?
No. Your VA needs read-only access to bank statements, not transactional access. Export monthly statements as PDFs and share them through a secure Google Drive folder. Never give a VA direct login to your banking portal.
How do I prevent billing errors before they happen?
Run a pre-billing audit on the 25th. Your VA reviews the upcoming billing list in MindBody or Mariana Tek, flags expired cards, and sends proactive payment update reminders. This reduces failed payments by 30% to 40%.
Can billing reconciliation be fully automated?
Data collection and basic matching can be partially automated through Stripe's reporting tools and MindBody's scheduled exports. But investigating discrepancies, contacting members, and making judgment calls on refunds require human attention. Your VA handles the nuanced work automation cannot.