Swimming Coaching Monthly Billing Reconciliation: A VA's Step-by-Step SOP

Swimming coaching monthly billing reconciliation is the process that keeps your revenue accurate and your client relationships clean. Without it, you find out about failed payments three months too late. Credits pile up untracked. Clients get charged for sessions they never attended - or worse, attend sessions they never paid for.

Your VA can run this entire reconciliation process on the first business day of each month. It takes 2 to 4 hours depending on your client count and complexity. The return is complete financial clarity without you touching a spreadsheet.

For a broader view of what a fitness VA handles beyond billing, explore our fitness virtual assistant tasks list.

Preparing for Reconciliation Day

Before your VA starts matching payments to sessions, they need clean data. The preparation step takes 15 to 20 minutes and prevents errors that waste hours later.

Data Sources to Pull

Your VA gathers reports from these systems:

1. Payment processor (Stripe, Square, or GoHighLevel Payments): Export all transactions for the previous month - successful charges, failed charges, refunds, and disputes.
2. Scheduling or attendance system (Mindbody, Acuity, GHL Calendar, or a shared Google Sheet): Export attendance records showing every session each client attended, missed, or canceled.
3. Membership or billing plan records: Pull the current plan for each active client - how many sessions per month they are entitled to, their billing amount, and billing date.
4. Credit and makeup log: Any outstanding credits, makeup sessions owed, or promotional discounts that should affect this month's reconciliation.

Setting Up the Reconciliation Spreadsheet

Your VA should use a standardized spreadsheet template with these columns:

• Client name
• Billing plan and monthly rate
• Payment date and amount collected
• Payment status (successful, failed, pending, refunded)
• Sessions included in plan
• Sessions attended
• Sessions missed (no-show)
• Sessions canceled with notice
• Makeup sessions used
• Credits applied
• Balance owed or credit remaining
• Notes and action items

Create this template once and reuse it monthly. Your VA fills in the data, highlights discrepancies, and flags items that need your decision.

Step 1: Verify All Payments Were Collected

This is the core of swimming coaching monthly billing reconciliation. Your VA checks every active client to confirm that the correct amount was charged and the payment went through.

Matching Payments to Plans

For each active client, your VA confirms:

• The charge amount matches their plan rate
• The charge was processed on the correct billing date
• The payment status shows "succeeded" in the payment processor

Any mismatch gets flagged immediately. Common issues include:

• Charge amount differs from plan rate: This happens when a client upgraded or downgraded mid-cycle, a promotional rate expired, or a manual override was applied incorrectly.
• Charge date is wrong: Billing dates can drift if a client's card was retried after a failure. Note the actual charge date and whether it matters for the client's session access.
• Duplicate charges: Rare but damaging. If a client was charged twice, your VA initiates a refund for the duplicate immediately and notifies the client proactively.

Handling Failed Payments

Failed payments are the highest-priority item in reconciliation. Every failed payment represents lost revenue that gets harder to collect with each passing day.

Your VA should categorize failed payments by reason:

• Card declined (insufficient funds): Most common. The card will often succeed on a retry 3 to 5 days later.
• Card expired: Requires the client to update their payment method.
• Card reported lost or stolen: Requires a new card entirely.
• Bank block or fraud flag: The client needs to authorize the charge with their bank.

Failed Payment Recovery Sequence

For each failed payment, your VA follows this sequence:

Day 1 (same day as failure): Automatic retry through Stripe or your processor. Most processors retry automatically, but your VA should verify the retry is scheduled.

Day 2: If the retry fails, your VA sends a text:

Hi [First Name], we had trouble processing your payment of [$XX] for [Child's Name]'s swim lessons. Could you update your payment method at this link: [URL]? This will keep [his/her] spot secured.

Day 5: If unresolved, send an email with the payment update link and a reminder that session access may be paused if payment is not received within [X days per your policy].

Day 10: Your VA escalates to you with a list of all unresolved failed payments. You decide whether to pause the client's access, make a courtesy call, or extend the grace period.

Day 14: If still unresolved, your VA pauses the client's booking access in your scheduling system and sends a final notice:

Hi [First Name], we have been unable to process your payment for [month]. [Child's Name]'s lessons are on hold until this is resolved. Please update your payment method here: [URL] or reach out if you need to discuss your account.

Your VA logs every communication attempt in the CRM so there is a clear record if disputes arise later.

Step 2: Reconcile Sessions Attended vs. Sessions Paid For

This step catches two problems: clients who attended more sessions than they paid for and clients who paid for sessions they did not use.

Over-Attendance

If a client attended 6 sessions but their plan includes 4, your VA needs to determine why:

• Did they use makeup sessions they were owed? Check the credit log.
• Were they added to extra sessions by mistake? Check with the coach or front desk.
• Did they upgrade their plan mid-month? Verify the plan change was processed in billing.

If the extra sessions are not accounted for, your VA calculates the overage charge based on your per-session rate and prepares an invoice for your approval before sending it to the client.

Under-Attendance

If a client attended 2 sessions but paid for 4, your VA checks:

• Were the missed sessions no-shows or cancellations? Reference the no-show log.
• Is the client owed makeup sessions under your policy? If yes, log the credits.
• Did the client request a hold or pause that was not processed? If so, calculate the appropriate credit or refund.

Under-attendance reconciliation protects you from refund requests months later. When your records clearly show how each session was accounted for, disputes are resolved quickly.

Session Rate Verification

For clients on per-session billing rather than monthly memberships, your VA verifies:

• Number of sessions attended multiplied by the per-session rate equals the total charged
• Any applicable discounts (sibling discount, multi-session package discount) were applied correctly
• Package sessions remaining are accurate in the system

Step 3: Process Refunds and Credits

Your VA should never issue a refund without your approval. They prepare the refund, document the reason, and present it to you for sign-off.

When Credits Are Appropriate

• Client missed sessions due to facility closure (pool maintenance, weather)
• Client missed sessions due to instructor absence and no substitute was provided
• Billing error resulted in an overcharge
• Client is on a plan that includes rollover credits

When Refunds Are Appropriate

• Client cancels their membership and has unused prepaid sessions
• Duplicate charge was processed
• Service was not delivered as promised (class canceled without notice, wrong level placement not corrected)

Refund Processing Steps

1. Your VA documents the reason in the CRM with supporting evidence (attendance logs, communication records)
2. Your VA sends you a refund request summary: client name, amount, reason, and supporting documentation
3. You approve or deny
4. If approved, your VA processes the refund through Stripe, Square, or your processor
5. Your VA sends the client confirmation: "A refund of [$XX] has been processed to your card ending in [XXXX]. Please allow 5 to 10 business days for it to appear."
6. Your VA updates the reconciliation spreadsheet

Step 4: Update Membership Statuses

As part of reconciliation, your VA reviews and updates every client's membership status:

• Active: Paid current, attending sessions
• Past due: Payment failed, in recovery sequence
• On hold: Client requested a temporary pause
• Canceled: Client terminated their membership
• Pending cancellation: Client submitted a cancellation request effective at the end of the billing cycle

Status accuracy matters because it controls booking access. A client marked "active" with a failed payment can keep booking sessions you are not getting paid for. Your VA ensures the status in your CRM matches the payment reality.

End-of-Month Cancellation Processing

If clients submitted cancellation requests during the month, your VA processes them on reconciliation day:

1. Confirm the cancellation effective date
2. Calculate any remaining credits or refunds owed
3. Remove the client from upcoming class rosters
4. Send a cancellation confirmation email with final billing details
5. Tag the client in the CRM for a "win-back" campaign 30 to 60 days later

Step 5: Generate the Owner's Monthly Report

The final deliverable from your VA's reconciliation work is a summary report that gives you a clear financial picture in under 2 minutes of reading.

Report Contents

• Total revenue collected for the month
• Total failed payments and amount outstanding
• Number of active clients vs. previous month
• New enrollments and cancellations
• Refunds and credits issued (with reasons)
• Clients on hold
• No-show rate and its revenue impact
• Clients flagged for attention (payment issues, high no-show rates, pending cancellations)

Your VA delivers this report as a PDF or shared Google Doc by the third business day of the month. Pair it with a 15-minute call or Loom video walkthrough if your VA wants to highlight specific trends.

To learn more about hiring a VA who can manage your billing operations confidently, read how to hire a fitness virtual assistant.

Frequently Asked Questions

How long does monthly billing reconciliation take?

For a swim school with 50 to 100 active clients, your VA should complete reconciliation in 2 to 4 hours. Larger programs with 200+ clients may take a full day. The first reconciliation takes the longest because your VA is building the template and cleaning up historical data. Subsequent months go faster.

What if my billing and scheduling tools do not integrate?

Your VA manually exports data from each tool and matches it in a spreadsheet. This adds 30 to 60 minutes to the process. If you are doing this every month, it is worth investing in an integration through Zapier or native connectors between your scheduling platform and payment processor.

Should my VA have direct access to my Stripe or Square account?

Yes, but with limited permissions. Most payment processors offer team member roles with restricted access. Give your VA the ability to view transactions, issue refunds (with your approval process in place), and update client payment methods. Do not give them access to payout settings or bank account information.

How do I handle clients who are consistently late on payments?

Your VA can offer to change their billing date to better align with their pay schedule. If the issue persists, consider requiring prepayment for the upcoming month rather than post-payment. Your VA communicates the policy change professionally and processes the billing adjustment.

What is an acceptable failed payment rate for a swim school?

Industry benchmarks for subscription-based fitness businesses put failed payment rates between 5% and 10% of total charges. If your rate exceeds 10%, your VA should investigate whether the issue is concentrated among specific client segments, billing dates, or payment methods. Switching from card-on-file to ACH/bank transfer reduces failure rates significantly for recurring billing.