Monthly Billing Reconciliation for Nutrition Coach VAs

Revenue leaks quietly. A failed payment here, a subscription that was supposed to cancel but did not, a client who is still in your program but never got invoiced correctly - these problems compound over months and cost real money. A nutrition coach VA running a structured monthly billing reconciliation process catches these issues before they become significant losses.

This article covers how to set up payment tracking, how to handle failed payment recovery, and how to produce a monthly billing report that gives the coach a clear view of revenue. For an overview of what else a VA can handle, see the fitness virtual assistant tasks list.

Setting Up a Payment Tracking System

Before you can reconcile, you need a source of truth. Most nutrition coaching businesses run billing through one of three systems: Stripe (often via GoHighLevel or Practice Better), a direct platform like TrueCoach or Trainerize that has payment built in, or a separate invoicing tool like Dubsado or HoneyBook. Your VA needs to know which system is authoritative and have access to it.

The billing roster

Your VA should maintain a billing roster - a simple spreadsheet or a view inside GoHighLevel - that lists every active client with:

• Name
• Program type and monthly rate
• Billing date (the day of the month their payment processes)
• Payment method on file
• Last successful payment date
• Last payment amount
• Status: active, paused, or in failed payment recovery

This roster does not replace your payment processor's records. It is a working document your VA uses to flag discrepancies quickly. The processor is the source of truth; the roster is the working view.

Syncing the roster monthly

On the first business day of each month, your VA pulls a payment report from your processor for the prior month and compares it to the billing roster. Every client on the roster should have a matching payment record. Any gaps - a client on the roster with no payment record, or a payment that came through for more or less than the expected amount - gets flagged immediately.

Common discrepancies to look for:

• A client whose billing date fell on a weekend or holiday and was processed at a different amount than expected
• A client who was supposed to cancel but still has a payment record
• A client who was paused but had a payment process anyway
• A new client who onboarded mid-month and whose prorated amount does not match expectations

None of these are automatically problems. All of them require a review before the month closes.

Failed Payment Recovery

Failed payments are the highest-priority billing task your VA handles. A failed payment is revenue you have earned that is sitting uncollected. Recovering it requires speed and a clear sequence.

When a payment fails

Most payment processors will retry a failed payment automatically (Stripe retries 3 to 4 times by default over several days). Your VA should not wait for retries to run their course before taking action. The moment a failed payment notification comes through - in GoHighLevel, via Stripe webhook, or through Practice Better - the recovery sequence starts.

Failed payment recovery sequence

Day 1 (same day as failure):

Send an SMS or email to the client: "Hi [Name], just a quick heads up - it looks like your payment on [date] didn't go through. This sometimes happens with expired cards or bank holds. If you can update your payment info at [link], we'll take care of it right away. Let us know if you have any questions."

Keep the message practical, not apologetic or accusatory. Most failed payments are not intentional. The client with an expired card is not trying to avoid paying - they just forgot to update it.

Day 3 (if not resolved):

Follow-up message: "Hey [Name], just following up on the payment from [date]. Your access to the program is still active, but we want to make sure we get this sorted quickly. Can you update your card here: [link]? Or if you would prefer to pay via a different method, just reply and we'll sort it out."

Note: whether you keep program access active during a failed payment period is a policy decision for the coach. Define this in your SOP so your VA is never guessing.

Day 7 (if not resolved):

Escalate to the coach. The VA sends a final message: "Hi [Name], I want to make sure this doesn't affect your program. We still have an outstanding payment from [date] - can you give me a call, or let me know the best way to sort this out? [Coach Name] wants to make sure you're taken care of."

Mentioning the coach by name on the final escalation message signals that this has moved beyond routine admin. It is not a threat - it is a genuine signal that the situation is being noticed at the decision-making level.

Day 10 (no resolution):

The coach decides whether to pause or cancel the client's access. The VA executes the decision and sends the appropriate message. If access is paused, the message includes a clear path to reinstatement. If canceled, the message is professional and leaves the door open for return.

Tracking recovery rates

Your VA should log every failed payment in the billing roster: the failure date, the amount, the recovery date (if recovered), and the recovery method (card update, manual payment, alternative payment method). At the end of each month, calculate the recovery rate: how many failed payments were recovered versus how many resulted in churned clients. Track this quarterly. A recovery rate below 50 percent suggests either a process problem or a client base with chronic payment instability.

Building the Monthly Billing Report

The monthly billing report is a one-page summary the coach reviews at the start of each month. It should take your VA about 45 to 60 minutes to produce and should cover:

Revenue summary

• Total recurring revenue collected in the prior month
• Total expected recurring revenue (based on the billing roster)
• Variance (collected minus expected) with explanation for any gap
• Number of new clients added (and their first payment date and amount)
• Number of clients who canceled (and their last payment date)

Payment status

• Number of successful payments processed
• Number of failed payments initiated
• Number of failed payments recovered (and recovered amount)
• Number of failed payments outstanding at month-end

Subscription changes

• Clients who upgraded or changed plans
• Clients whose rates changed (annual renewal, promotional pricing expiring)
• Paused clients and their pause end dates

Outstanding invoices

• Any invoices that have not been paid (for coaches on non-recurring invoice billing rather than subscriptions)
• The invoice date, client name, amount, and follow-up status

Notes

A brief section for anything unusual: a prorated charge that looks odd, a client whose payment method needed to be updated manually, a refund processed in the month and the reason.

This report does not need to be a financial statement. It needs to give the coach a clear picture of what came in, what did not, and what is outstanding - in 5 minutes of review time.

Refund and Adjustment Handling

Your VA should have a defined refund policy to execute, not interpret. The coach defines when refunds are appropriate; the VA processes them.

Standard scenarios your SOP should address:

• A client who cancels before their billing date and requests a prorated refund
• A failed payment that was retried and collected twice (duplicate charge recovery)
• A client who was charged after a pause or cancellation was supposed to take effect

For any refund over a defined threshold (define this with the coach - commonly $100 or $200), the VA requests coach approval before processing. Below that threshold, the VA can process and notify the coach in the monthly report.

All refunds get logged in the billing roster with the date, amount, reason, and processor reference number. This log is essential for reconciling your payment processor's records with your revenue numbers.

FAQ

How often should the billing roster be updated? Your VA should update the billing roster in real time when a client onboards, cancels, pauses, or changes their plan. The monthly reconciliation is a check, not the primary update mechanism.

What payment processors work best with GoHighLevel for nutrition coaching businesses? Stripe is the standard integration and works well for recurring subscriptions. PayPal is an option but creates more reconciliation complexity due to delayed settlement and different reporting formats. If you use GoHighLevel payments natively, the reporting is built in.

Should the VA have refund processing access in Stripe? This depends on the coach's risk tolerance. A VA with refund access can move faster on legitimate requests. A VA without refund access requires coach approval for every refund. Most coaches find that a threshold-based policy (VA processes below $X, coach approves above $X) is the right balance.

How do I reconcile billing if clients pay through different channels (Stripe, Venmo, bank transfer)? Maintain a single billing roster that captures all payment methods. For non-Stripe payments, your VA logs receipt date, amount, and method manually. The monthly report then reconciles all channels together rather than trying to pull everything from one processor. This adds work but is manageable if your non-Stripe payments are a small minority.