Monthly billing reconciliation for a running coaching business ensures every active client is paying correctly and no revenue leaks through failed payments, expired cards, or system errors. Without regular reconciliation, coaches lose an average of 5-10% of expected revenue to preventable billing failures - failed cards that never get retried, clients on incorrect plan amounts, or subscriptions that expired without notice. A VA performing monthly reconciliation catches these issues within days rather than months, recovering revenue that would otherwise be silently lost.

For the complete list of VA tasks, see fitness virtual assistant tasks list.

Run the Monthly Reconciliation Process

The VA compares three data sources at the start of each month to identify discrepancies.

The three-way match:

  1. Active client list: Everyone the coach is currently coaching (from CRM or coaching platform).
  2. Payment processor records: All active subscriptions and payments received this month (from Stripe, PayPal, or Square).
  3. Bank account deposits: Actual money received (from bank statements or accounting software).

Reconciliation steps:

  1. Export the active client list with their expected billing amount and billing date.
  2. Export this month's successful payments from the payment processor.
  3. Match each active client to a successful payment this month.
  4. Flag discrepancies: clients with no matching payment, payments with no matching client, or amount mismatches.
  5. Investigate and resolve each discrepancy (following the resolution workflows below).
  6. Document the reconciliation results and report to the coach.

Timing:

  • Run reconciliation between the 3rd and 5th of each month (allows time for all billing cycles to process).
  • For coaches with multiple billing dates throughout the month, run a mini-reconciliation weekly.
  • Failed payment follow-up happens in real time (not just monthly) - see the recovery section below.

Tools needed:

  • Payment processor dashboard (Stripe, PayPal, Square, GoCardless).
  • Client roster (coaching platform, CRM, or spreadsheet).
  • Bank statements or accounting software (QuickBooks, Wave, Xero).
  • Reconciliation spreadsheet (template with columns: client name, expected amount, actual amount, payment date, status, notes).

Recover Failed Payments

The VA follows a structured process to recover payments that fail due to card issues.

Common failure reasons:

  • Expired credit card (most common).
  • Insufficient funds.
  • Card lost/stolen and replaced with new number.
  • Bank fraud protection blocking the charge.
  • Payment processor technical error.

Failed payment recovery sequence:

Day 0 (payment fails):

  • Payment processor automatically retries (most retry 3 times over 5-7 days).
  • VA notes the failure in the tracking system.
  • If the processor sends an automated update-card email, let it run first.

Day 1 (if no auto-retry success):

  • VA sends a personal message (not automated): "Hey [Name], quick admin note - your payment did not go through this month (looks like a card issue). Can you update your payment method here: [link]? No rush but wanted to flag it before it slips."

Day 4 (still outstanding):

  • Second message via a different channel if possible: "Just following up on the payment update - your card on file seems to need updating. Here is the direct link: [link]. Let me know if you need help."

Day 7 (still outstanding):

  • Escalate to the coach for a personal message. Frame it as a coaching relationship communication, not a billing demand.
  • Consider: "I noticed your subscription has not processed. I want to make sure we keep your coaching rolling without interruption. Can you update your card when you get a chance?"

Day 14 (still outstanding):

  • Final attempt: "Your coaching access will be paused if we cannot resolve the payment issue. I completely understand if circumstances have changed - just let me know and we can discuss options."
  • If no response by day 21: pause coaching access and notify the coach for a final decision (cancel or continue outreach).

Tone guidance:

  • Always assume good intent (they forgot, card expired, technical glitch).
  • Never threaten or use aggressive language.
  • Keep it brief and practical.
  • Offer to help (some people genuinely do not know how to update payment methods).

Resolve Discrepancies

The VA investigates and fixes common billing mismatches.

Active client with no payment:

  • Check if they are on a trial or comp period (legitimate no-payment).
  • Check if their billing date is later in the month (timing issue, not actual failure).
  • Check if payment went to a different processor or method (PayPal vs. Stripe).
  • If genuinely missing: follow failed payment recovery process.

Payment received with no matching active client:

  • Check if the client recently cancelled (final payment processing).
  • Check for one-time purchases (program, guide, or consultation fee vs. subscription).
  • Check for duplicate entries in the client list (same person, different name/email).
  • If unidentifiable: note it and investigate further (do not refund without understanding the source).

Amount mismatch:

  • Client paying less than expected: check for applied discounts, grandfathered pricing, or proration from a plan change.
  • Client paying more than expected: check for accidental double-charge, upgrade processed, or additional purchase.
  • Resolve by checking payment processor logs (which show plan changes and their dates).

Duplicate charges:

  • If a client is charged twice in one month: refund the duplicate immediately and notify the client before they notice.
  • Investigate cause (subscription created twice, manual charge plus auto-charge, plan migration error).
  • Document how it happened to prevent recurrence.

Generate the Monthly Financial Report

The VA compiles billing data into a clear report for the coach.

Monthly billing summary:

  • Total expected revenue (all active clients at their plan rate).
  • Total collected revenue (actual payments received).
  • Collection rate (collected / expected - target 95%+).
  • Failed payments this month (count and total dollar amount).
  • Recovered payments (previously failed, now resolved).
  • Outstanding payments (still unresolved from this and prior months).

Client movement report:

  • New clients added this month (with their plan and first payment amount).
  • Clients cancelled this month (with their last payment date and reason if known).
  • Plan upgrades and downgrades.
  • Paused clients (and expected reactivation dates).

Revenue metrics:

  • Monthly recurring revenue (MRR) at month end.
  • MRR change from prior month (growth or contraction).
  • Average revenue per client.
  • Client lifetime value update (average tenure x average monthly payment).
  • Churn rate (clients lost / clients at start of month).

Report delivery:

  • Deliver by the 5th-7th of each month (after reconciliation is complete).
  • Format: one-page summary with key metrics at the top, details below.
  • Flag anything requiring the coach's decision or attention (unresolved payments, pricing discrepancies, unusual activity).

Maintain Billing System Hygiene

The VA keeps the billing infrastructure clean and accurate ongoing.

Weekly tasks:

  • Check for newly failed payments (do not wait until month end).
  • Process any card updates received from clients.
  • Verify new client subscriptions are set up at the correct amount.
  • Monitor for unusual activity (unexpected cancellations, plan changes not initiated by the VA).

Monthly tasks (alongside reconciliation):

  • Update the client roster if any changes occurred.
  • Archive cancelled client billing records.
  • Check for expiring credit cards in the next 30 days (proactive outreach reduces failures).
  • Verify any discount codes or promotional pricing are still valid and intended.

Quarterly tasks:

  • Review all subscription amounts against current published pricing (catch grandfathered clients or errors).
  • Check payment processor fees (are they competitive? Any unexpected fee increases?).
  • Ensure tax collection settings are correct (if applicable to the coach's jurisdiction).
  • Back up all financial records and export transaction history.

For hiring a VA to manage financial operations, see how to hire a fitness virtual assistant.

Frequently Asked Questions

How much revenue do running coaches typically lose to failed payments?

3-8% of monthly revenue is common if failed payments are not actively managed. With a VA running structured recovery (personal outreach within 24 hours of failure), recovery rates reach 70-85% of failed payments. On a $10,000/month coaching business, that is $300-800 recovered monthly that would otherwise be lost.

Should the VA have direct access to the payment processor?

Yes - read access at minimum (to view payments, subscriptions, and client billing details). Write access to issue refunds, pause subscriptions, and update records is ideal but should follow a policy (e.g., VA can issue refunds under $50 without coach approval, larger amounts require confirmation). The coach should maintain owner-level access for security.

What is the best payment processor for a running coaching business?

Stripe is the industry standard for subscription-based coaching. It handles recurring billing, automatic retries, and provides clear dashboard reporting. PayPal is acceptable but harder to manage subscriptions. GoCardless (direct debit) works well in the UK/EU and has lower failure rates than card-based payments. Square is better for in-person session payments.

How does the VA handle a client who repeatedly has failed payments?

After 3 failed payment months in 6 months, have a direct conversation (coach-led) about whether a different billing arrangement would work better: annual payment (discounted), different billing date aligned with their pay schedule, or alternative payment method. Repeated failures often indicate financial stress - the client may benefit from a plan adjustment before they cancel entirely.

Should billing reconciliation be automated or manual?

Hybrid approach. Automate detection (payment processor alerts for failures, subscription analytics dashboards) but keep resolution manual (personal outreach, investigation, judgment calls). Fully automated dunning emails recover less revenue than personal VA messages because they feel impersonal and get ignored. The VA's human touch on recovery outreach is where the value lies.

#running coach#billing reconciliation#fitness va#payment management#financial operations