Weight Loss Coach Monthly Billing Reconciliation

Weight loss coach monthly billing reconciliation is the process of verifying that every client payment, refund, and charge matches what should have occurred. Your virtual assistant runs this process at the end of each month to catch errors before they snowball. Missed charges, duplicate payments, and failed renewals quietly drain your revenue. A disciplined reconciliation habit keeps your books clean and your clients happy.

---

Why Monthly Reconciliation Matters

Billing mistakes are more common than most coaches realize. Here are the problems that surface when you skip reconciliation:

• Failed payments go unnoticed. A client's card declines, and nobody follows up. You deliver coaching for free.
• Duplicate charges create disputes. Clients see two charges and file a chargeback. You lose the money plus a penalty fee.
• Refunds are not tracked. You issue a refund but never record it. Your revenue projections are off.
• Subscription gaps appear. A client pauses, their pause period ends, but the subscription does not restart.
• Tax reporting gets messy. Inaccurate monthly records create headaches at year-end.

Your VA catches all of this during reconciliation. It takes two to three hours once a month and saves you thousands in lost or misattributed revenue.

Tools You Need in Place

Before your VA can reconcile billing, set up these systems:

Your payment processor - usually Stripe - is the ultimate source of truth. Every other system gets compared against it.

The Monthly Reconciliation Workflow

Your VA follows these steps between the 1st and 3rd of each month, covering the previous month's transactions.

Step 1: Export Transaction Data

Pull transaction reports from each system:

• Stripe or Square: Export all charges, refunds, and failed payments for the month
• GoHighLevel: Export subscription payments and one-time charges
• MindBody: Export session package purchases and recurring membership payments
• Trainerize: Export subscription billing records if you bill through the platform

Save each export as a dated CSV file in a shared Google Drive folder. This creates an audit trail.

Step 2: Build the Reconciliation Worksheet

Open your Google Sheets reconciliation template. It should have these columns:

• Client name
• Expected charge amount
• Expected charge date
• Actual charge amount (from Stripe)
• Charge status (successful, failed, refunded, pending)
• Platform source (GoHighLevel, MindBody, Trainerize)
• Notes

Your VA populates the "expected" columns from your CRM's active client list and their billing terms. Then they fill in the "actual" columns from the Stripe export.

Step 3: Match Expected vs. Actual Charges

Go row by row. For each active client:

• Match found, amounts agree. Mark as reconciled. No action needed.
• Match found, amounts differ. Flag for review. Common causes include mid-month plan changes, proration, or discount codes applied incorrectly.
• Expected charge, no actual charge. The payment failed or was never triggered. This is lost revenue until resolved.
• Actual charge, no expected charge. Could be a duplicate, a one-time purchase, or a client who should have been canceled. Investigate.

Color-code the worksheet: green for reconciled, yellow for discrepancies, red for missing payments.

Step 4: Resolve Failed Payments

For every failed payment, your VA follows this process:

1. Check the failure reason in Stripe (card declined, expired card, insufficient funds, etc.)
2. Send the client a friendly payment update message: "Hi [Name], we noticed your payment for [month] did not go through. Could you update your card on file? Here is the link: [link]"
3. Set a 48-hour follow-up reminder
4. If unresolved after 7 days, escalate to the coach
5. Log every action in the CRM

Failed payment recovery is one of the highest-value tasks your VA performs. Even recovering two or three missed payments a month pays for the VA's time.

Step 5: Verify Refunds and Credits

Cross-reference all refunds issued during the month:

• Was the refund authorized by the coach?
• Does the refund amount match what was processed in Stripe?
• Is the refund recorded in your accounting software?
• Was the client's subscription canceled or adjusted after the refund?

Document any refund that was processed without proper authorization. Flag it for the coach.

Step 6: Check Subscription Status Changes

Review all subscription changes that happened during the month:

• New subscriptions started
• Subscriptions canceled
• Subscriptions paused or resumed
• Plan upgrades or downgrades

Verify that each change in the CRM matches the corresponding change in Stripe. Mismatches here are common - a client cancels in GoHighLevel, but the Stripe subscription keeps charging, or vice versa.

Step 7: Update Accounting Records

Once reconciliation is complete, your VA updates your accounting software. In QuickBooks or Wave:

• Record total revenue collected
• Record total refunds issued
• Record outstanding payments (failed but not yet recovered)
• Categorize income by type (monthly subscription, one-time package, consultation fee)

Step 8: Generate the Monthly Report

Your VA creates a one-page summary that includes:

• Total expected revenue vs. total collected revenue
• Number of successful payments vs. failed payments
• Total refunds issued
• Failed payment recovery rate
• List of clients with outstanding balances
• Subscription changes summary

Send this report to the coach by the 5th of each month. Keep it simple. One page, key numbers, action items highlighted.

For a broader view of what your VA can handle, check our guide on what is a fitness virtual assistant.

Preventing Common Billing Issues

Your VA should also implement these preventive measures:

Card expiration alerts. Run a monthly check in Stripe for cards expiring in the next 30 days. Send clients a proactive update request before their payment fails.

Subscription audit. Once per quarter, compare your active client list against active Stripe subscriptions. Every active client should have exactly one active subscription. Catch duplicates and orphaned subscriptions early.

Discount code review. Verify that discount codes are expiring as intended. A "first month free" code that never expires silently costs you money.

Proration checks. When clients change plans mid-cycle, confirm the proration calculation is correct in Stripe. Automated proration usually works, but edge cases happen.

Setting Up the Reconciliation Template

Your VA needs a reusable template. Build it once in Google Sheets with these tabs:

• Monthly Transactions - the main reconciliation worksheet
• Failed Payments - tracker with client name, amount, failure reason, follow-up status
• Refunds - log with date, client, amount, reason, authorization status
• Summary - auto-calculated totals pulled from the other tabs

Lock the template structure so it stays consistent month to month. Your VA duplicates it at the start of each reconciliation cycle.

Frequently Asked Questions

How long does monthly billing reconciliation take?

Two to three hours for a coaching business with 30 to 80 active clients. Larger rosters take longer. The first month takes more time as your VA builds the template and learns your billing setup. After that, it becomes routine.

What is the most common billing error for weight loss coaches?

Failed payments that go unnoticed. Card declines happen silently, especially with subscription billing. Without reconciliation, you can lose weeks or even months of revenue from a single client before anyone notices.

Should the VA have direct access to Stripe?

Yes, but with read-only access plus the ability to send payment update links. Your VA should not issue refunds or modify subscriptions in Stripe without coach approval. Set permission levels appropriately.

How do you handle clients who repeatedly fail to pay?

After two consecutive failed payments with no response to follow-up messages, escalate to the coach. The coach decides whether to pause the program, have a direct conversation, or end the engagement. Your VA documents the decision and executes it.

Can reconciliation be fully automated?

Not entirely. Automated matching catches the obvious cases, but discrepancies, failed payment follow-ups, and subscription mismatches require human judgment. Your VA provides that judgment layer between your automated systems and your accounting records.