Monthly Billing Reconciliation for Bootcamp Gym VAs: Memberships, Failed Payments, and Reporting
Billing errors cost bootcamp gyms real money. A member who should be paying $199 per month but got manually paused without a billing update is $199 of lost revenue per month, compounded over every month the error goes unnoticed. A VA who owns the billing reconciliation process with a clear monthly SOP prevents these leaks and keeps your financial data clean enough to actually use for decisions.
Pre-Billing Audit: The Week Before the Billing Cycle
Most boutique bootcamp gyms run monthly billing on the 1st or 15th. Whatever your cycle date, the VA runs a pre-billing audit five to seven business days before the charge date. This is your last chance to catch errors before they hit members' cards.
Active membership count: Pull the active membership report from MindBody, Zen Planner, or Wodify. In MindBody, this is the "Active Clients" report under Client Reports, filtered by membership type. In Zen Planner, use the Members report filtered by Status: Active. The VA records the total active member count in the monthly reconciliation sheet. Compare it to last month's count and flag any variance greater than five percent for owner review.
Plan type audit: For each active member, confirm they are on the correct membership plan. Common errors include:
- Members who signed up for a trial rate that was never converted to the standard rate
- Members who requested an upgrade or downgrade that was not processed in the system
- Corporate or referral discounts that expired but were not removed
- Founding member rates applied to members who joined after the founding period
The VA cross-references the active member list against the CRM (GoHighLevel) notes to catch any outstanding plan changes. If a coach verbally approved a rate change but it was never processed in MindBody or Zen Planner, it shows up here.
Pause and hold verification: Pull the list of members on active pauses from your membership software. Confirm each pause has an end date. Any pause without an end date is an open liability - the member may continue pausing indefinitely if no one checks. Confirm the pause terms (full pause, reduced billing, medical hold) match what was agreed to and logged in the client record.
Card expiration check: MindBody and Zen Planner both flag cards expiring within 30 days. The VA runs this report and contacts any member with an expiring card before the billing date. A short text is sufficient: "Hey [Name], your card on file expires at the end of this month - would you be able to update it in [Member Portal / app] before your next billing date? Here is the link: [link]." This single step dramatically reduces failed payment volume.
Processing Failed Payments: The Recovery Workflow
Even with pre-billing checks, failed payments happen. Card fraud replacements, bank changes, and insufficient funds create a batch of declined transactions on every billing cycle. The VA's job is to recover these as fast as possible.
Day-of billing audit: On billing day, the VA monitors the payment processing results in MindBody, Zen Planner, or your external processor (Stripe, Square, etc.). Most platforms send a daily batch report by email. The VA logs all failed transactions in the monthly reconciliation sheet: member name, amount, failure reason, and date.
First outreach - within 24 hours: Every failed payment gets a personal text or email within 24 hours of the declined charge. Keep the tone neutral and helpful, not accusatory. Template: "Hey [Name], just a heads up - your payment of [$X] did not go through this month. It happens! You can update your payment info here: [link], or text us back and we can help you sort it out. No rush - just want to get it squared away." Include a direct payment update link if your platform supports it.
Day three follow-up: If no response or action after 24 hours, the VA sends a second message on day three. This time, add a light urgency note: "Hey [Name], following up on the payment from [date]. Membership access may be affected if we do not get this sorted by [date, typically 7 days from billing]. Let me know if there is anything I can help with on my end." The access restriction deadline is real - enforce it consistently or members learn they can ignore payment follow-ups.
Day seven - access restriction: Members with unresolved failed payments at seven days should have their class booking access restricted in MindBody, Zen Planner, or Wodify, depending on your gym's policy. This is a system-level action (the VA does not need to manually block the member - the membership software typically handles access restriction for accounts in arrears). The VA notifies the member at the time of restriction: "Hey [Name], your membership access has been paused due to the outstanding balance. Once the payment is sorted, we will have you back active immediately. Here is the payment link: [link]."
Day 14 - escalation: Any failed payment still unresolved at 14 days is escalated to the gym owner. At this point, the decision may involve a payment plan, a collections referral, or a cancellation. The VA prepares a summary: member name, original amount, number of contact attempts, member responses (if any), and a recommendation. The owner makes the final call.
Tracking recovery rate: The VA logs the outcome of every failed payment in the reconciliation sheet. Categories: Recovered same day, Recovered within 7 days, Recovered within 14 days, Escalated to owner, Written off. Calculate your monthly recovery rate (recovered / total failed). A well-run recovery process recovers 75-85% of failed payments within 14 days.
For context on the full scope of operations a fitness VA can manage, see the fitness virtual assistant tasks list.
Monthly Billing Report: What the Owner Needs to See
At the end of each billing cycle, the VA delivers a one-page billing summary to the gym owner. This report should take no more than 30 minutes to prepare if the reconciliation sheet has been maintained throughout the month.
Report sections:
Revenue summary: Total billed for the month, total collected (billed minus failed), total recovered from prior failed payments, total written off. If you use an accounting integration between MindBody or Zen Planner and QuickBooks, verify that the numbers in both systems match before including them in the report.
Membership movement: New members added this month, members paused, members canceled, members returned from pause. This section tells the owner whether the gym is growing, flat, or contracting. Track the net change: new additions minus cancellations equals net member growth.
Failed payment summary: Total failed transactions, total amount at risk, amount recovered within seven days, amount outstanding at report date. Include a brief note on any patterns - specific card types failing more often, a spike in declines pointing to a processor issue, or a cluster of cancellations tied to billing friction.
Membership plan breakdown: How many members are on each plan type (monthly autopay, annual prepay, punchcard, trial). This snapshot tells the owner whether the revenue mix is shifting in ways that affect cash flow predictability. A gym with 80% annual prepay handles cash flow very differently than one with 80% month-to-month.
Action items for next month: Any cards expiring in the next 30 days, any pauses scheduled to end, any members on payment plans with upcoming installments. These are the VA's to-do list for the pre-billing audit next month.
Delivery format: A shared Google Sheet works for most gyms. The VA maintains a tab for each month and a summary tab that tracks trends over the past 12 months. If the gym owner prefers a PDF summary, the VA exports the relevant section monthly. Deliver by the fifth business day of the following month.
If you are building a VA role that covers billing operations alongside client communication and lead response, how to hire a fitness virtual assistant outlines how to scope the role and set performance benchmarks.
FAQ
How do we handle members who dispute a charge through their bank rather than coming to us first? Document the chargeback immediately in the member's record and in your processor dashboard. Gather evidence: signed membership agreement, billing authorization language, payment history. Submit your response through your processor's dispute process within their deadline (typically 7-14 days). The VA prepares the documentation; the owner or a manager submits the formal response. If you win the dispute, log it as recovered. If you lose, log it as written off and review whether your membership agreement and authorization language needs updating.
Should the VA have access to actual payment processing or just reporting? For most gyms, the VA should have read access to payment reports and the ability to send payment update links to members, but not the ability to issue refunds or process manual charges independently. Restrict those actions to the owner or manager level until a VA has demonstrated six or more months of reliable, error-free billing work.
What is the best way to reduce failed payments before the billing date? Card expiration outreach (seven to ten days before billing) is the single highest-impact pre-billing action. Pair it with annual card update campaigns in January and July when many cards are reissued. Some gyms also offer a payment method incentive - a small discount for ACH/bank transfer over card payments - to reduce card dependency for core memberships.
How do we reconcile billing data between our membership software and our accounting system? Run a monthly comparison between the revenue figure in MindBody or Zen Planner and the actual deposits in your bank account or QuickBooks. The VA pulls both numbers by the third business day of the month. Any variance of more than $50 triggers a line-by-line review. Common sources of variance: refunds processed after close, failed payments that hit bank before processor updates the software record, or integration sync delays. Log the reconciliation date and any variance notes in the monthly report.