Aquatic Fitness Monthly Billing Reconciliation for Virtual Assistants
Billing errors in aquatic fitness are more common than most owners realize. Duplicate charges, failed auto-drafts that were never retried, pro-rated session credits that were applied incorrectly, and refunds that were processed in MindBody but not reflected in QuickBooks - these issues accumulate silently and either damage client trust when discovered or create revenue leakage that never gets corrected.
A monthly billing reconciliation, run by your VA on a fixed schedule, catches these issues before they become problems. This workflow is designed for aquatic fitness businesses using any combination of SwimOffice, Jackrabbit, MindBody, and QuickBooks.
What Monthly Reconciliation Covers
Reconciliation in this context means confirming that:
- Every active client was billed the correct amount
- Every payment that was due was actually collected or flagged as failed
- Refunds processed in your management software match what was actually returned to clients
- Revenue in your management platform matches what appears in QuickBooks
- Any adjustments (credits, discounts, comp sessions) are documented and authorized
This is not a full accounting audit. It is an operational check that keeps your billing clean and your books accurate between professional accounting reviews.
Pre-Reconciliation Setup (One-Time)
Before your VA can run this monthly, you need to establish a reconciliation template. Create a Google Sheet with the following columns:
- Client name
- Membership or enrollment type
- Expected monthly charge
- Actual charge processed
- Date processed
- Payment method
- Status (collected, failed, refunded, adjusted)
- Notes
Your VA populates this sheet monthly by exporting client billing data from SwimOffice, Jackrabbit, or MindBody. The export columns from your management software should map to the template columns. Spend 30 minutes configuring the export once and your VA can run the process monthly in under two hours.
The Monthly Reconciliation Workflow
Week 1 of the Month: Pull and Compare Billing Data
Within the first three business days of the month, your VA completes the following:
Step 1: Export the previous month's transaction report from your management software. In Jackrabbit, this is under Reports > Financial > Transaction Report. In SwimOffice, use the Payment History report. In MindBody, export the Revenue report filtered by the previous calendar month. Export to CSV.
Step 2: Import the CSV data into your reconciliation template. Your VA maps the exported columns to the template and populates the sheet. Any client who appears in the active roster but is missing from the billing export is flagged immediately - that is a missed billing.
Step 3: Compare against QuickBooks. Export the same month's transaction data from QuickBooks (the Transactions by Customer report works well). Compare the total revenue figure against the management software export. Discrepancies above a defined threshold (typically $50 or any individual transaction) get flagged for investigation.
Step 4: Flag payment failures. Identify every transaction with a failed, declined, or pending status. These clients need a follow-up workflow (see the no-show and billing follow-up workflow). Your VA creates a task for each failed payment to trigger the recovery sequence.
Week 1-2: Resolve Discrepancies
Your VA works through the flagged items:
- Missed billings: Determine whether the client should have been billed (active enrollment vs. cancelled). If active and missed, process the charge manually and send a notification to the client.
- Incorrect amounts: Review the enrollment record in Jackrabbit or SwimOffice to confirm the correct rate. If an error was made, process a correction and document the reason.
- Refund discrepancies: Compare refunds in your management software against refunds logged in QuickBooks. If a refund was processed in MindBody but not yet reflected in QuickBooks, note the date and confirm with your bookkeeper.
- Unauthorized adjustments: Any credit or discount applied by a staff member that does not have a corresponding approval note should be flagged to you for review.
Your VA documents every resolution step in the notes column of the reconciliation sheet.
End of Month: Produce the Reconciliation Summary
Your VA produces a one-page reconciliation summary that includes:
- Total billings processed vs. total expected (variance)
- Total payment failures by count and dollar amount
- Total refunds issued
- Total adjustments applied
- Any unresolved items requiring owner decision
This summary goes to you at the end of the month. It takes you five minutes to review and approve. If everything is clean, you confirm. If there are unresolved items, you decide. Your accountant or bookkeeper gets the full reconciliation sheet on their regular schedule.
Handling Recurring Problem Patterns
If your VA sees the same issue appear across multiple months, that is a signal that your billing setup has a structural problem. Common patterns in aquatic fitness:
- Frequent pro-ration errors usually mean your software is not configured correctly for mid-month enrollments.
- Repeated payment failures from the same clients may indicate a need to switch their payment method or update their auto-draft profile.
- Credits applied without approval often signal a staff training issue.
Your VA's job is to flag these patterns, not to fix the root cause. You fix the root cause.
For a broader view of financial and operational tasks your VA can handle, see aquatic fitness virtual assistant tasks. For help structuring your VA hire, see what is a fitness virtual assistant.
FAQ
Does my VA need full access to QuickBooks to run reconciliation? They need read access to run the transaction reports and compare figures. Write access is needed only if you want your VA to enter adjustments directly. Many owners prefer to have their VA flag discrepancies and handle the QuickBooks entries themselves or through their bookkeeper. Start with read-only access and expand as trust is established.
How long should monthly reconciliation take for a typical swim school? For a business with 50 to 150 active clients, the full reconciliation process takes 2 to 4 hours per month. The first month takes longer because your VA is learning the export and comparison process. By month three, a trained VA runs this in under two hours.
What if my management software and QuickBooks never fully reconcile due to timing differences? This is common with payment processors that have a 1 to 3 day settlement lag. Establish a reconciliation window (e.g., compare month-end totals as of the 5th of the following month to allow settlements to clear) and document it as your standard. Consistent methodology matters more than perfect real-time accuracy.
Should I involve my bookkeeper in this process? Your VA handles the operational reconciliation to catch errors. Your bookkeeper handles the accounting treatment of those errors. The two are complementary. Share the monthly reconciliation sheet with your bookkeeper on their regular schedule so they are working from the same data your VA has already cleaned.