Cycling Studio Monthly Billing Reconciliation: A VA's SOP

Cycling studio monthly billing reconciliation is not the most exciting task on a VA's plate, but errors in this process cost real money and erode client trust. A VA who can run a clean monthly close, recover failed payments, and produce a summary report gives the studio owner clear financial visibility without them touching a spreadsheet. This SOP covers the full process from payment processor review to final reporting.

Payment Processor Reconciliation: Stripe and Square

Most cycling studios process payments through MindBody's built-in payment system (which runs on Stripe), Square, or a direct Stripe integration. Some studios use both. Your VA reconciles each processor separately, then combines the results.

Stripe reconciliation steps:

1. Log into the Stripe dashboard. Navigate to Reports, then Payouts.
2. Pull the payout summary for the month. This shows the total funds transferred to the studio's bank account.
3. Export the transactions CSV for the full month.
4. Cross-reference against the bank statement: every payout in Stripe should appear as a deposit in the bank. Flag any discrepancies.
5. Check for chargebacks in the Disputes section. Note each one with the client name, amount, and current status.

Square reconciliation steps:

1. Log into the Square dashboard. Go to Reports, then Sales Summary.
2. Select the full month. Export the report.
3. Review the deposit schedule: Square pays out on a rolling 1 to 2 business day cycle, so the final few days of the month may land in the following month's bank activity.
4. Reconcile deposits against the bank statement, accounting for the payout timing difference.

MindBody + Stripe integration: If your studio uses MindBody's payment processing, run the Sales by Payment Method report in MindBody Reports and compare the total to the Stripe payout summary. These should match within a rounding margin. Differences greater than $10 require investigation.

Your VA logs all reconciliation findings in a shared Google Sheet with columns: Date, Source, Amount Expected, Amount Received, Variance, Notes.

Failed Payment Recovery

Failed payments are a predictable monthly task. Your VA owns the recovery process from detection to resolution.

Detection:

• MindBody generates a Failed Transactions report under Reports, then Client Transactions. Run this at the start of each month for the prior month.
• In Stripe, failed charges appear in the Payments section filtered by "Failed" status.
• In GoHighLevel, flag contacts with a failed payment tag and assign a follow-up task.

Recovery sequence:

Day 1: Your VA sends an automated or manual payment failure notification to the client. Use a direct, non-embarrassing tone: "Hi [Name], we had a hiccup processing your payment for [membership/pack]. Could you log into your account and update your card details, or reply here and I can help sort it out."

Day 3: If no response, send a second message. Include a direct link to update billing info in MindBody or your client portal.

Day 7: If still unresolved, suspend access temporarily per your studio policy. Send a final message: "Your account is currently on hold due to the outstanding balance of [$X]. Update your payment info to restore access."

Day 14: If unresolved after 14 days, escalate to the studio owner for a decision on whether to cancel the membership or pursue collection.

Retry logic in Stripe: Stripe's Smart Retries automatically retries failed payments at optimized intervals. Make sure this is turned on in your Stripe account settings under Billing, then Subscriptions, then Smart Retries. This reduces the number of failed payments your VA needs to chase manually.

Track monthly failed payment recovery rate: percentage of failed payments resolved within 14 days. Aim for above 75%.

Membership vs. Class Pack Revenue Tracking

Your VA separates revenue by product type in the monthly report. This matters for understanding business health and projecting cash flow.

Revenue categories to track:

• Monthly memberships (recurring): predictable, billed on a fixed cycle.
• Annual memberships (prepaid): recognized monthly over the term (your accountant may handle this separately).
• Class packs (5, 10, or 20 class packs): one-time payments, recognized as classes are used.
• Drop-in single classes: transactional, fully recognized at time of purchase.
• Retail (shoes, apparel, water bottles): separate line item.
• Late-cancel and no-show fees: note these separately as they represent a policy enforcement revenue line, not service delivery.

In MindBody, pull the Revenue Summary report under Reports, then Business. Filter by product type. Export to your reconciliation spreadsheet.

Class pack liability: Unused class pack credits represent a future service obligation. Your VA tracks the total outstanding pack credits at month-end as a liability note in the report. This is not standard accounting practice for small studios but gives the owner visibility into what has been paid for but not yet delivered.

Refund Processing

Refunds require documentation, authorization, and accurate processing. Your VA does not process refunds without a documented request and, depending on amount, owner approval.

Refund authorization levels:

• Under $50: VA can process with documentation.
• $50 to $200: VA processes after confirming via message with the studio owner or manager.
• Over $200: Owner handles directly or VA processes only after written (email or text) approval.

Refund process in MindBody:

1. Locate the original transaction in the client's account.
2. Click the transaction and select Refund.
3. Enter the amount and reason.
4. MindBody returns the funds via the original payment method (Stripe or Square).

Refund documentation: Your VA logs every refund in the reconciliation spreadsheet: Date, Client Name, Amount, Reason, Approved By. This creates an audit trail and helps identify patterns (e.g., a specific class or instructor generating a high refund rate).

Chargebacks: When a client disputes a charge with their bank, Stripe or Square notifies you via email and dashboard alert. Your VA collects all evidence (signed waiver, booking confirmation, cancellation policy) and submits a dispute response within the required window (usually 7 to 10 days). Missing the response window means automatically losing the dispute. Set a calendar reminder when a chargeback arrives.

Financial Reporting for the Studio Owner

At the end of each month, your VA produces a one-page summary for the studio owner. This is not a full financial statement but a clear operational view.

Monthly billing report sections:

1. Total revenue by product type (memberships, packs, drop-ins, fees, retail).
2. Total processed vs. total deposited (variance explanation if applicable).
3. Failed payment count and recovery rate.
4. Refunds issued (count and total dollar amount).
5. Outstanding chargebacks (count, amount, status).
6. New memberships added, memberships cancelled, net membership movement.

Format this as a Google Doc or Google Sheet shared with the owner. Keep it consistent month to month so trends are visible.

Tools your VA should be comfortable with:

• MindBody Reports dashboard.
• Stripe dashboard (Payments, Payouts, Disputes).
• Square Reports (if applicable).
• Google Sheets for reconciliation tracking.
• GoHighLevel for failed payment follow-up workflows.

Tie monthly close into your payroll processing cadence and surface variance trends through the KPI dashboard setup. BLS projects fitness instructor jobs to grow 14% through 2032.

Frequently Asked Questions

How long does monthly billing reconciliation take for a typical cycling studio?

For a studio with 150 to 400 active clients, a VA who knows the process should complete the full reconciliation (processor review, failed payment identification, report production) in 3 to 5 hours per month.

Should the VA have direct access to Stripe or Square?

Yes, with appropriate access levels. Give the VA team member access in Stripe (not Administrator) and restricted reporting access in Square. The VA should be able to view and export reports but not transfer funds or change bank account details.

What is the difference between a late-cancel fee and a no-show fee in billing?

Both are fees charged to clients, but they may be processed differently. Late-cancel fees are often deducted from a class credit rather than charged to a card. No-show fees are usually a direct card charge. Your VA needs to know how each is set up in MindBody to reconcile them correctly.

How do you handle a client who claims they were charged incorrectly?

Your VA pulls the original transaction record and compares it to the class booking history. If the charge is correct, your VA explains the charge with documentation. If the charge is an error, the VA processes a refund (within the authorization level guidelines) and logs the correction.

Can a VA handle the full monthly close without accounting software?

For most independent cycling studios, yes. A VA using MindBody reports, Stripe exports, and a Google Sheet can produce an accurate monthly summary. For studios with more complex revenue structures (multiple locations, instructor revenue share, retail inventory), a bookkeeper or accounting software like QuickBooks is a better fit for the formal close, with the VA handling the operational layer.