Wellness Retreat Monthly Billing Reconciliation by a VA

Retreat finances get messy fast. You have deposits coming in three months early, installment plans spread across multiple guests, last-minute refunds, vendor invoices from caterers and venues, and instructor payments due on different schedules. A wellness retreat monthly billing reconciliation process gives your virtual assistant a repeatable system to keep every dollar accounted for.

Without reconciliation, you discover problems too late - a guest who never paid their final balance, an instructor invoice that was paid twice, or a refund that was processed but never recorded. This SOP prevents all of that.

What Monthly Billing Reconciliation Includes

Your fitness virtual assistant should reconcile five categories of financial activity each month:

• Guest payments (deposits, installments, final balances)
• Refunds and credits
• Vendor and venue invoices
• Instructor and contractor payments
• Platform fees and processing costs

Each category has its own verification process. Your VA works through them systematically during the first five business days of each month.

Step 1 - Export and Organize Payment Data

Before reconciling anything, your VA needs a clean data set. On the first business day of the month:

• Export transactions from Stripe, Square, or PayPal for the previous month. Download as CSV.
• Export bank statements from your business checking account. Match the date range exactly.
• Pull the guest payment tracker from Airtable or Google Sheets - this is your internal record of what should have been paid.
• Collect all vendor invoices from email, shared drives, or your accounting tool.

Create a working reconciliation spreadsheet for the month. Use a template with tabs for each category: Guest Payments, Refunds, Vendor Payments, Instructor Payments, and Discrepancies.

Step 2 - Reconcile Guest Payments

This is the most time-consuming step. Your VA compares three data sources:

• The payment processor records (what actually came in)
• The guest payment tracker (what should have come in)
• The bank statement (what landed in the account)

For each guest with activity during the month, verify:

• Deposit received - Amount matches the booking confirmation. Payment date matches expected timeline.
• Installment payments - Each installment matches the agreed schedule. Flag any that are late or short.
• Final balance - Paid in full before the retreat start date. Flag outstanding balances.
• Processing fees - Stripe charges 2.9% + $0.30 per transaction. Verify that net deposits (after fees) match what hit your bank account.

Common discrepancies your VA should watch for:

• Guest paid via bank transfer but it has not cleared yet
• Duplicate payments (guest paid twice by accident)
• Partial payments that do not match any installment amount
• Payments attributed to the wrong guest or wrong retreat

Flag every discrepancy in a dedicated tab. Do not resolve them yet - just document them for your review.

Step 3 - Reconcile Refunds and Credits

Pull all refunds processed during the month from Stripe or your payment processor. For each refund, your VA verifies:

• The refund matches an approved cancellation or no-show resolution
• The refund amount matches your cancellation policy (full, partial, or deposit only)
• The refund appears on the bank statement as a deduction
• The guest's record in the CRM has been updated to reflect the refund
• Any future retreat credit has been logged with an expiration date

Cross-reference refunds against your payroll processing records to make sure refunded amounts are excluded from revenue calculations.

Step 4 - Reconcile Vendor and Venue Invoices

Retreats involve multiple vendors: caterers, venue rentals, equipment suppliers, transportation providers, florists, photographers, and more. Your VA should:

• Collect all vendor invoices received during the month. Check email, shared folders, and physical mail.
• Match each invoice to a payment in the bank statement or payment processor.
• Verify amounts - Does the invoice match the contract or purchase order? Flag any overcharges.
• Check payment terms - Were invoices paid on time? Note any late payment fees incurred.
• Confirm receipt of goods/services - Did the vendor actually deliver? Your VA should verify with the retreat team before marking an invoice as correctly paid.

Organize vendor payments in QuickBooks, Wave, or a dedicated Google Sheets tab with columns for: vendor name, invoice number, invoice date, due date, amount, payment date, payment method, and status.

Step 5 - Reconcile Instructor and Contractor Payments

Instructors and facilitators may be paid per retreat, per session, or on a monthly retainer. Your VA verifies:

• Payment amounts match contracts - Check each instructor's agreement for their rate.
• Correct tax documentation - W-9 (US) or equivalent on file for every contractor paid more than $600 in the calendar year.
• Payment method - Confirm whether each instructor is paid via direct deposit, Zelle, PayPal, or check.
• Reimbursements - Any travel, accommodation, or supply reimbursements submitted by instructors. Match receipts to payments.

Maintain an instructor payment log separate from vendor payments. This makes year-end tax reporting significantly easier.

Step 6 - Calculate Monthly Financial Summary

After reconciling all categories, your VA compiles a one-page monthly summary:

• Total revenue collected (gross guest payments minus refunds)
• Total expenses (vendor invoices plus instructor payments plus platform fees)
• Net income for the month
• Outstanding receivables (guests who still owe money)
• Outstanding payables (vendor invoices not yet paid)
• Discrepancies requiring your attention (with recommended actions)

Deliver this summary to you by the 5th business day of each month. Use a consistent format - Google Slides, a PDF template, or a dashboard in Google Sheets - so you can compare months at a glance.

Step 7 - Resolve Discrepancies

After you review the monthly summary, your VA resolves flagged items:

• Contact guests with outstanding balances and send payment reminders
• Follow up with vendors on disputed invoice amounts
• Process any corrections in the payment processor
• Update the master financial tracker with all resolutions
• Note any write-offs or bad debt for your accountant

Document every resolution. If a discrepancy recurs across multiple months, flag it as a process issue that needs a systemic fix.

Tools for Billing Reconciliation

Your VA should work in these tools:

• QuickBooks or Wave - Accounting and invoice management
• Stripe Dashboard - Payment and refund verification
• Google Sheets or Airtable - Guest payment tracking and reconciliation worksheets
• Google Drive - Vendor invoice storage organized by month
• Slack - Flagging discrepancies to you in a dedicated finance channel

If your retreat operation processes more than $50,000 per month, consider upgrading to Xero or QuickBooks Online for more robust reporting.

FAQ

How long should monthly reconciliation take a VA?

For a retreat business running two to four retreats per month with 10-30 guests each, expect 6-10 hours of VA time for full reconciliation. This drops to 3-5 hours once your VA has a clean template and knows your vendor relationships well.

Should my VA have direct access to bank accounts?

Give your VA read-only access to bank statements for reconciliation purposes. They do not need the ability to initiate transfers or payments. Most banks allow you to create a view-only login. For payment processing, your VA can have admin access to Stripe or Square to verify transactions and process approved refunds.

What if my VA finds a payment discrepancy they cannot explain?

They should document it in the discrepancies tab with all available details: amount, date, parties involved, and what does not match. Do not ask them to guess or resolve it independently. Review these items during your weekly check-in and involve your accountant or bookkeeper if needed.

How do I handle tips or gratuities paid to instructors through the retreat?

Track tips separately from instructor base pay. If guests tip through your payment processor, your VA should identify those amounts and ensure they are passed through to instructors in full. Create a dedicated line item in the instructor payment log for tips received and tips disbursed.

When should I involve a professional bookkeeper instead of a VA?

Your VA handles the day-to-day reconciliation, data entry, and discrepancy flagging. Bring in a professional bookkeeper or CPA for quarterly tax prep, year-end financial statements, and any complex accounting questions (depreciation, multi-entity structures, international payments). Many retreat operators use both - a VA for the operational grunt work and a bookkeeper for the strategic tasks list review quarterly.