Barre Studio Monthly Billing Reconciliation: VA Standard Operating Procedure

Barre studio monthly billing reconciliation is the process of verifying every dollar coming into your studio matches what your booking platform says should be coming in. Unlimited memberships, class packs, drop-in fees, retail purchases, and failed payments all create a tangle of transactions that need monthly review. Pair this SOP with payroll processing to close month-end and roll billing data into your KPI dashboard so owner reports stay in sync. McKinsey reports 60% of occupations could automate 30%+ of activities.

Most barre studio owners avoid reconciliation because it feels tedious. But unreconciled billing means missed revenue. A client whose card declines and never gets followed up on is pure loss. A class pack that expired without the client knowing is a retention problem. Your VA catches all of it.

Unlimited Membership Payment Verification

Unlimited memberships are your bread and butter. They provide predictable recurring revenue - but only if every payment actually processes. Your VA runs this verification on the 1st-3rd of each month.

Step 1: Export the membership roster. Pull a full list of active unlimited members from MindBody, Momence, or your booking platform. Include member name, billing date, amount, and payment status.

Step 2: Cross-reference with your payment processor. Compare the booking platform's records against Stripe, Square, or your processor's transaction log. Look for discrepancies - a membership marked "active" in your booking software but no corresponding charge in Stripe means something broke.

Step 3: Identify failed payments. Filter for declined, failed, or pending transactions. Common reasons include expired cards, insufficient funds, and bank-issued fraud holds. Your VA categorizes each failure by reason code.

Step 4: Verify membership tiers are correct. Barre studios often have multiple tiers - 4x/month, 8x/month, unlimited. Your VA confirms each member is on the correct tier and the correct rate. Watch for clients who should have graduated from intro pricing to standard pricing but were never updated.

Step 5: Check for frozen and paused accounts. Members who paused their membership should not be charged. Your VA verifies that paused accounts show zero transactions and that their resume date is correctly set in the system.

Reconciliation math: Total active unlimited members x their respective monthly rates = expected revenue. Compare against actual received revenue. Any gap needs investigation.

Class Pack Usage and Expiration Tracking

Class packs are trickier to reconcile because they are pre-paid and consumed over time. Your VA tracks usage monthly to catch anomalies and prevent revenue leakage.

Usage audit:

• Pull all active class packs with remaining credits
• Check each pack's purchase date and expiration date
• Flag packs expiring within 14 days (these clients need outreach)
• Flag packs with zero usage in the last 30 days (possible churn signal)

Common issues your VA catches:

• Classes deducted incorrectly (double-deductions from booking glitches)
• Packs that should have expired but are still active (system error)
• Clients attending class without a valid pack or membership (front desk override not logged)
• Complimentary classes applied to the wrong account

Expiration outreach: Your VA sends a notification to clients whose packs expire within 14 days. A simple message: "Hi [Name], you have [X] classes remaining on your pack, which expires on [Date]. Want me to book you in this week?" This drives urgency and prevents the "I forgot I had classes left" complaint.

Revenue recognition: Track how many pack credits were consumed this month across all clients. Multiply by the per-class value of each pack tier. This gives you your realized class pack revenue for the month - distinct from cash collected (which happened at purchase).

Drop-In Charges and Retail Purchases

Drop-in clients and retail sales create one-off transactions that are easy to lose track of. Your VA reconciles these separately.

Drop-in payments:

• Pull all drop-in class purchases for the month
• Verify each has a matching payment in your processor
• Check for drop-in clients who attended but were never charged (front desk missed the payment)
• Flag repeat drop-in clients who might convert to a pack or membership (pass names to sales)

Retail reconciliation (grip socks, merchandise, accessories):

• Export all retail transactions from your POS or booking platform
• Match against inventory records: units sold should equal units reduced from inventory
• Check for unrecorded sales (inventory discrepancy suggests a sale was missed)
• Verify pricing accuracy - were any items sold at incorrect prices?

Grip socks are particularly important for barre studios. You sell dozens per month to new clients. Your VA tracks:

• Total pairs sold
• Revenue from grip socks
• Current inventory level
• Reorder trigger point (when stock hits X pairs, place a new order)

Merchandise margins: Your VA calculates gross margin on retail monthly. Track whether retail revenue justifies the inventory investment.

Failed Payment Recovery Process

Failed payments are where your VA directly recovers revenue. Without a follow-up system, failed payments become permanent losses. Here is the recovery workflow.

Day 1 (payment fails): Automatic retry. Most processors retry automatically after 24-48 hours. Your VA monitors but does not act yet.

Day 3 (second failure): First outreach. Your VA sends a friendly text or email: "Hi [Name], we had trouble processing your membership payment. Could you update your card on file? Here is the link: [payment update link]."

No accusatory language. No urgency yet. Just a helpful nudge.

Day 7 (still failed): Second outreach. More direct: "Hi [Name], your membership payment has not processed and your account is on hold. Please update your payment method by [date] to avoid interruption to your class bookings. Update here: [link]."

Day 14 (still failed): Final notice. "Hi [Name], this is a final reminder that your membership payment has not been received. Your account will be suspended on [date] and your class bookings will be cancelled. Please reply or update your card to resolve this."

Day 21 (no response): Account suspension. Your VA suspends the membership, cancels upcoming bookings, and logs the account as churned-due-to-payment. She sends one last message acknowledging the suspension and inviting them to reactivate anytime.

Recovery metrics your VA tracks:

• Total failed payments this month (count and dollar value)
• Recovered by Day 3
• Recovered by Day 7
• Recovered by Day 14
• Lost (suspended)
• Recovery rate percentage

A healthy studio recovers 60-75% of failed payments when the follow-up is consistent. Without follow-up, recovery drops below 20%.

Monthly Reconciliation Report

Your VA produces a summary report by the 5th of each month covering the prior month. The report includes:

• Total revenue received (all sources)
• Membership revenue (expected vs. actual)
• Class pack revenue consumed
• Drop-in revenue
• Retail revenue
• Failed payments outstanding
• Failed payments recovered
• Net revenue variance (actual vs. expected)
• Inventory status (grip socks and merchandise)
• Clients flagged for outreach (expiring packs, frozen accounts approaching resume dates)

This report takes 2-3 hours to compile if your VA has maintained clean records throughout the month. If she does reconciliation weekly in smaller chunks, the monthly report becomes a simple rollup.

For a broader view of what a VA can manage across your studio operations, document your operations checklist during onboarding to identify additional delegation opportunities.

Frequently Asked Questions

How often should my VA reconcile billing - weekly or monthly?

Weekly light checks with a full monthly reconciliation works best. Your VA should review failed payments and flag anomalies every Monday (15-20 minutes). The comprehensive reconciliation - cross-referencing all sources, compiling the report, running recovery outreach - happens monthly on the 1st through 5th.

What tools does my VA need access to for billing reconciliation?

Your booking platform admin panel (MindBody, Momence, Mariana Tek), your payment processor dashboard (Stripe, Square), your retail POS if separate, and a spreadsheet or Notion workspace for tracking. Your VA also needs permission to update payment statuses and send client communications.

Should my VA have the authority to issue refunds?

Set a dollar threshold. Most studio owners authorize their VA to issue refunds up to $25-$50 without approval (covering a single class credit or a late cancel fee reversal). Anything above that threshold requires owner sign-off. Document this rule clearly so your VA never hesitates.

How do I handle clients who dispute charges with their bank instead of contacting the studio?

Chargebacks are costly - you lose the revenue plus a $15-$25 processor fee. Your VA should flag any chargeback immediately and gather documentation (signed waiver, booking confirmation, cancellation policy agreement) to submit a dispute response. Prevention is better: clear policies, easy cancellation processes, and responsive communication reduce chargebacks significantly.

What is a normal failed payment rate for a barre studio?

Between 3-8% of monthly membership charges will fail in any given month. Seasonal spikes happen in January (new year sign-ups with shaky commitment) and summer (travel and forgotten cards). If your rate exceeds 10%, review whether your pricing is causing financial strain or if your payment update process is broken.