Monthly billing reconciliation for a bodybuilding coaching business prevents revenue leakage, catches failed payments before they compound, and gives the coach a clear picture of financial health. Without a VA running this process, coaches discover missed payments weeks late, accumulate involuntary churn from expired cards, and cannot answer basic questions like "how much did I actually collect this month?" The reconciliation process takes 60-90 minutes per month and protects thousands of dollars in annual revenue.
Pair this SOP with payroll processing to close month-end and roll billing data into your KPI dashboard. McKinsey reports 60% of occupations could automate 30%+ of activities.
Run Reconciliation on the First Business Day of Each Month
The VA performs a full billing reconciliation covering the previous month's transactions.
Data sources to reconcile:
- Payment processor (Stripe, PayPal, or equivalent): Actual money collected, failed payments, refunds, disputes.
- Client roster: Who should have been billed (active clients and their package rates).
- Coaching platform/CRM: Client status records (active, paused, cancelled, trial).
Step 1: Export transaction data.
Pull the previous month's transactions from Stripe (or equivalent):
- Successful charges (amount, date, client name).
- Failed charges (amount, date, client name, failure reason).
- Refunds issued.
- Disputes/chargebacks.
- Subscription changes (upgrades, downgrades, cancellations mid-month).
Step 2: Cross-reference against the client roster.
For every active client on the roster:
- Was a payment collected? (Yes = confirmed. No = investigate.)
- Was the correct amount collected? (Matches their package rate? Watch for clients still on an old rate after a price change.)
- Was the payment on time? (Check for delays that might indicate card issues.)
Flag any discrepancy: missing payments, wrong amounts, duplicate charges, or payments from clients who should not be billed (cancelled or paused).
Recover Failed Payments Immediately
Failed payments are the most common source of involuntary revenue loss. The VA follows up on every failure within 24 hours.
Common failure reasons and responses:
- Card declined (insufficient funds): Wait 24 hours, then retry. If retry fails, contact client: "Hey [Name], your payment did not go through this month. Looks like a card issue. Can you update your payment info here? [link]"
- Expired card: Contact immediately: "Your card on file has expired. Here is a link to update it: [link]. Takes 30 seconds."
- Authentication required (3D Secure): "Your bank requires you to confirm the payment. Check your email or banking app for an authentication request."
- Card reported lost/stolen: Client needs to provide new payment details: "Your card was declined - your bank may have flagged it. Could you add a new card here? [link]"
Follow-up cadence for failed payments:
- Day 1: First outreach (friendly, informational).
- Day 3: Auto-retry through Stripe + second message if retry fails.
- Day 7: Third message (slightly more direct): "Just following up on the billing issue. Your coaching access is uninterrupted but we do need to get this sorted. Any issues on your end I can help with?"
- Day 14: Final message + coach notification: "We have not been able to process your payment. Please update your details by [date] to keep your coaching active."
- Day 21: If unresolved, flag for coach's decision on whether to pause or terminate coaching.
Recovery rate target: 80%+ of failed payments should be recovered within 7 days. Most failures are genuine card issues, not intentional non-payment.
Handle Refunds, Credits, and Disputes
The VA processes refunds according to pre-defined policies and handles disputes before they become chargebacks.
Refund policy (VA enforces consistently):
- Define the coaching business's refund policy clearly (common: no refunds after program delivery, prorated refund if cancelled within first 7 days, full refund if onboarding not yet completed).
- VA processes approved refunds through Stripe (coach pre-approves the policy and the VA executes within those boundaries).
- Document every refund: date, amount, reason, client name, who approved it.
Credit handling:
- If a client was overcharged or billed during a planned pause, issue a credit immediately.
- Track credits in the reconciliation sheet: client name, credit amount, reason, applied date.
- Credits should be applied to the next billing cycle automatically or manually deducted.
Dispute/chargeback process:
- Stripe notifies of disputes immediately. The VA responds within 24 hours (Stripe gives 7-21 days, but faster is better).
- Gather evidence: signed agreement, service delivery records (program sent, check-ins completed, communication logs), payment history.
- Submit dispute response through Stripe with all supporting documentation.
- Alert the coach - chargebacks can indicate a client relationship problem that needs addressing.
Maintain the Financial Tracking System
The VA keeps a running financial record that makes monthly and annual reporting simple.
Monthly tracking spreadsheet columns:
- Client name
- Package type and rate
- Expected charge date
- Actual charge date
- Amount charged
- Status (paid, failed-recovered, failed-outstanding, refunded, disputed)
- Notes (reason for any anomaly)
Summary section (top of spreadsheet):
- Total expected revenue (all active clients x their rates).
- Total collected revenue.
- Revenue gap (expected minus collected, broken down by: failed-outstanding, refunds, disputes).
- Net new revenue (new clients this month).
- Lost revenue (cancellations that took effect this month).
- MRR at end of month.
Report Financial Health to the Coach
The VA delivers a monthly financial summary the coach can review in 2 minutes.
Report format (email or shared doc, delivered by 3rd of each month):
Revenue summary:
- Total collected: $X
- vs. last month: +/- $X (+/- X%)
- vs. expected: $X gap (with explanation)
Client movement:
- New clients: X ($X/month added)
- Cancellations: X ($X/month lost)
- Upgrades: X ($X/month added)
- Downgrades: X ($X/month lost)
- Net MRR change: +/- $X
Payment health:
- Failed payments: X
- Recovered: X
- Outstanding: X (and follow-up status)
- Refunds: X ($X total)
- Disputes: X ($X total, status)
Action items:
- Payments still outstanding that need coach decision.
- Any pricing inconsistencies found.
- Clients approaching renewal who might churn (based on engagement data).
Keep the report factual. The coach uses it to understand financial trajectory and make decisions about pricing, capacity, and marketing investment.
For hiring a VA to manage coaching finances, document your revenue streams and refund policies before reaching out.
Frequently Asked Questions
How much revenue do coaching businesses typically lose to failed payments?
Without active recovery, 5-10% of monthly recurring revenue is lost to involuntary churn from failed payments. With a VA running the recovery process described above, that drops to 1-2%. For a coach billing $10,000/month, the difference is $300-800/month in recovered revenue.
Should the VA have direct access to Stripe or the payment processor?
Yes - view access at minimum for pulling reports and monitoring failures. Refund and adjustment access depends on the coach's comfort level. Many coaches give the VA full access with clear policies on when refunds can be issued without checking first (e.g., under $50, clear policy violation by the business).
What is the best payment processor for online bodybuilding coaches?
Stripe is the standard for subscription-based coaching. It handles recurring billing, automatic retries on failed payments, invoicing, and dispute management in one platform. For coaches also selling programs or one-off products, Stripe combined with a platform like Kajabi or TrueCoach covers both models.
How should the VA handle a client who disputes a legitimate charge?
Respond through the payment processor's dispute resolution system with evidence: the signed coaching agreement, proof of service delivery (programs sent, messages exchanged, check-ins completed), and the refund policy the client agreed to. Most legitimate-charge disputes are won when documentation is thorough.
When should billing reconciliation happen if the coach bills clients on different dates?
If clients are billed on their signup anniversary (rather than the 1st of each month), the VA still reconciles monthly but checks each client against their individual billing date. A rolling 30-day view works better than a calendar-month view in this scenario. The monthly report still covers the same period for consistency.