Strength and Conditioning Monthly Billing Reconciliation

Strength and conditioning monthly billing reconciliation is the process of verifying that every active member was charged correctly, every failed payment was followed up on, and your revenue numbers match reality. Skip it and you accumulate silent revenue leaks - members on expired payment methods who train for free, duplicate charges that generate chargebacks, or pricing errors that go unnoticed for months. A VA running this reconciliation monthly catches problems while they are still small and fixable.

This SOP covers the reconciliation checklist, failed payment recovery, common billing errors, and the monthly close process.

The Monthly Reconciliation Checklist

Your VA runs this reconciliation on the first business day of each month, covering the prior month:

Step 1 - Pull the data:

• Export the active member list from your management software with membership type and monthly rate
• Export the billing transactions for the month from your payment processor (Stripe, Square, or your platform's billing module)
• Export any manual adjustments, credits, refunds, or one-time charges processed during the month

Step 2 - Cross-reference members against charges:

• Every active member should have exactly one membership charge for the month (or the correct number of charges if billing frequency varies)
• Flag members who are active but have no charge for the month - these are potential missed billings
• Flag members who have charges but are marked inactive, frozen, or cancelled - these are potential erroneous charges

Step 3 - Verify amounts:

• Check that each member was charged at their correct membership rate
• Flag any discrepancies: a member on a $200/month plan who was charged $150, or a member who received a promotional rate that has expired
• Verify that any mid-month changes (upgrades, downgrades, freeze starts/ends) were prorated correctly

Step 4 - Review failed payments:

• Pull the list of failed transactions for the month
• For each failure, check: was the member contacted, was the payment retried, was it eventually collected, or is it still outstanding?
• Calculate total outstanding revenue from failed payments

Step 5 - Review credits and refunds:

• Verify that every refund or credit issued during the month has documentation (a reason logged in the system)
• Flag any refund that lacks a documented reason or approval

Step 6 - Compile the reconciliation report:

• Total expected revenue (active members multiplied by their rates)
• Total collected revenue
• Total outstanding (failed payments not yet recovered)
• Total credits and refunds issued
• Discrepancy list with explanations and action items

Failed Payment Recovery Workflow

Failed payments are the biggest source of revenue leakage. Your VA runs this recovery process:

Day 1 (payment failure detected):

• The billing system retries automatically (most processors retry at day 1, 3, and 5)
• Your VA sends a text: "Hey [Name], it looks like your payment for [Facility Name] did not go through. Could you update your payment info when you get a chance? Here is the link: [payment update URL]"

Day 3 (if still failed after first retry):

• Email with more detail: "Hi [Name], we have been unable to process your monthly membership payment of $[amount]. This is usually due to an expired card or insufficient funds. Please update your payment method here: [link]. If you have any questions, just reply to this email."

Day 7 (if still outstanding):

• Phone call or voicemail from your VA: direct, friendly, no judgment
• Text follow-up if the call goes to voicemail

Day 14 (final notice):

• Email: "This is a final notice regarding your outstanding balance of $[amount]. If we are unable to collect by [date], your membership access may be temporarily suspended per our billing policy. Please update your payment method or contact us if you need to discuss options."

Day 21 (if still unpaid):

• Your VA escalates to you for a decision: suspend access, offer a payment plan, or write off the balance
• Your VA suspends access in the system if you direct them to

Your VA tracks recovery rates: what percentage of failed payments are eventually collected, and at which touch point. This data helps optimize the recovery messaging.

For a comprehensive view of VA tasks in fitness, see Fitness Virtual Assistant Tasks List.

Common Billing Errors to Catch

Your VA watches for these recurring issues:

Members training without active billing:

• A member's payment fails, they are never contacted, and they continue attending sessions. Your VA cross-references the attendance log against billing status weekly (not just monthly) to catch this early.

Expired promotional rates:

• A member signed up at a promotional rate ($149/month for the first 3 months) that should have increased to the standard rate ($199/month) after the promotion ended. Your VA flags members approaching promo expiration dates and ensures the rate adjustment happens on schedule.

Duplicate charges:

• System errors or manual billing mistakes can charge a member twice. Your VA catches these during reconciliation and processes the refund immediately.

Frozen members being charged:

• A freeze was entered incorrectly in the system and the member continues to be billed at the full rate. Your VA audits all frozen accounts monthly to confirm billing is paused or reduced per policy.

Cancelled members with residual charges:

• A cancellation was processed but the next billing cycle still fired. Your VA checks all cancellations processed in the prior month to confirm billing stopped on the correct date.

The Monthly Close Process

Your VA finalizes the month's billing with this close process:

Revenue summary:

• Total membership revenue collected
• Total class pack and drop-in revenue
• Total personal training or programming revenue
• Total retail or merchandise revenue
• Total credits, refunds, and adjustments
• Net revenue for the month

Outstanding items:

• Total still-outstanding failed payments with expected recovery amounts
• Members on payment plans with balances remaining
• Any billing disputes or chargeback cases in progress

Comparisons:

• Month-over-month revenue change
• Average revenue per member
• Failed payment rate (failed charges as a percentage of total charges attempted)
• Recovery rate (failed payments eventually collected as a percentage of total failures)

Your VA delivers this report by the 3rd business day of each month. The report feeds into your KPI dashboard and quarterly business reviews.

If you are considering hiring a VA for your facility, What Is a Fitness Virtual Assistant explains the role.

FAQ

How much revenue do facilities typically lose to failed payments?

Industry benchmarks suggest 5-10% of membership charges fail in any given month. With a structured recovery process, 60-80% of those can be recovered. Without follow-up, most failed payments are never collected. For a facility with $20,000 in monthly membership revenue, that is $1,000-$2,000 at risk every month.

Should the VA have access to the payment processor?

Yes, with appropriate permissions. Your VA needs read access to view transaction reports and failed payments. They need limited write access to process refunds (with your approval), retry payments, and update member billing details. They should not have access to transfer funds or change bank account settings.

How do we handle members who dispute a charge with their bank?

Your VA documents the charge with evidence: the membership agreement, billing history, attendance records, and any communication with the member. They submit this documentation through the payment processor's dispute response process. You make the decision on whether to fight the dispute or accept it. Your VA handles the paperwork.

Is monthly reconciliation enough or should we do it weekly?

Monthly reconciliation is the minimum. Your VA should check for failed payments weekly so the recovery process starts sooner. The full reconciliation (cross-referencing members, rates, and transactions) is a monthly task. Weekly failed payment checks take 15-20 minutes and significantly improve recovery rates.