Daily revenue reconciliation is the discipline of confirming that every dollar your fitness studio collected yesterday actually arrived in your accounts and was recorded correctly. Without it, discrepancies accumulate silently for weeks before you notice them on a bank statement. A fitness VA can run this process every morning, catch errors in real time, and deliver a report you can scan in under 60 seconds before your first client.
This is a core operations task that fits naturally into the workflow a fitness VA handles at the 20-hour-per-week tier. If you are still building out your delegation list, read through that overview before scoping this role.
POS-to-Bank Reconciliation: The Daily Match
The core of daily revenue reconciliation is a three-way match: your point-of-sale system, your payment processor, and your bank account. Each one should tell the same story about yesterday's revenue. When they do not, the VA finds out why.
Step 1: Pull the POS close report. Most fitness studios run MindBody, Glofox, or Pike13 as their primary POS. Each platform produces a daily close report showing gross sales, refunds, payment method breakdown (card, cash, membership auto-billing), and net revenue. The VA pulls this report every morning, ideally before 9 a.m., and logs the totals into the daily reconciliation sheet.
Step 2: Pull the processor settlement report. Stripe, Square, or a MindBody-integrated processor each produce a daily settlement report showing what was batched and what is pending transfer. The settlement amount should match the card total on the POS close report minus any processing fees. The VA logs the settlement total and notes the fee percentage.
Step 3: Check the bank feed. The VA checks the business bank account (read-only access via the bank portal or accounting software like QuickBooks or Wave) for the prior-day deposit. ACH and card settlement deposits typically land one to two business days after the transaction, so the VA is matching two different calendar dates: the transaction date (from POS) and the deposit date (from bank). The reconciliation sheet tracks both.
If all three numbers reconcile within normal tolerance (most studios set a $5-10 tolerance for rounding), the VA marks the day green. If there is a gap beyond tolerance, the VA flags it immediately with the specific line item that does not match.
Common discrepancies the VA catches: a refund processed in MindBody that was not applied in Stripe, a cash transaction logged in the POS but not deposited, a membership auto-charge that failed but was still counted in the daily close, or a duplicate charge on a client account.
Cash Handling Rules
Cash is the highest-risk component of daily revenue reconciliation. Card transactions have a processor audit trail. Cash does not. For studios that accept cash payments (drop-in fees, pro-shop sales, personal training deposits) the VA needs a clear cash handling protocol to reconcile.
The protocol has four rules:
Count-and-log at close. Whoever closes the studio each night counts the cash drawer and logs the total on a physical sheet or in a shared Google Form. The VA pulls this log the next morning. If the studio does not have a close-of-day count procedure, the VA should flag this to the owner immediately. Reconciling cash without a count log is guesswork.
Separate the starting float. The drawer starts each day with a float, typically $100-200 in small bills. The net cash collected is total drawer minus the starting float. The VA uses the net number, not the total drawer amount, when reconciling against the POS cash line.
Log every discrepancy. Any variance between the POS cash line and the drawer count, even a small one, gets logged with a date, amount, and the initials of the person who counted. Over time, patterns in cash discrepancies reveal training gaps or worse. The VA does not investigate; they document and escalate.
Weekly deposit confirmation. Cash should be deposited at the bank weekly at minimum. The VA tracks deposit dates and amounts in the reconciliation sheet and confirms the bank credit matches the total logged cash from the prior week. If cash sits in a safe for more than seven days without a deposit, the VA flags it.
The 60-Second Founder Report
Every morning, after the reconciliation is complete, the VA sends a brief daily revenue report. It should take you under 60 seconds to read and three seconds to respond to if everything looks fine.
The report template covers five lines:
- Yesterday's gross revenue: total from POS close report
- Card settlement: amount batched to processor, net of fees
- Cash collected: from close-of-day log
- Reconciliation status: Green (reconciled within tolerance) or Red (discrepancy flagged)
- Open items: any unresolved flags from prior days
When the status is green, you read it and move on. When the status is red, the VA includes a one-sentence description of the discrepancy and the specific accounts involved. You decide whether to investigate immediately or give the VA authority to resolve it directly.
Most days are green. The report earns its keep on the days that are not, when it catches a $400 discrepancy that would have been invisible until month-end close.
Building the Reconciliation Stack
To run this workflow, the VA needs read-only access to four systems: your POS platform, your payment processor portal, your bank account (via accounting software or direct portal access), and your cash log (a shared Google Sheet or Form is sufficient).
Setting up read-only access takes about 30 minutes per platform. Do this in the first week of the engagement. The VA builds the reconciliation template (typically a Google Sheet with one row per day and conditional formatting that flags red automatically when a variance exceeds tolerance) and runs the first live reconciliation on day one.
For studios using QuickBooks or Wave, the VA can optionally post a daily journal entry that splits revenue by category (membership, drop-in, pro-shop, personal training) and reconciles to the bank feed. This step integrates the daily reconciliation into your P&L automatically and eliminates a manual step for your bookkeeper at month-end.
Frequently asked questions
How long does daily revenue reconciliation take a VA each morning?
For a single-location studio with straightforward payment methods, the reconciliation takes 20-35 minutes per day. Multi-location studios or studios with complex membership structures (sliding scale, unlimited punch cards, corporate accounts) take longer. Plan for 45-60 minutes. The report drafting adds five minutes.
What is an acceptable reconciliation tolerance for a fitness studio?
Most studios set a tolerance of $5-10 per day. This accounts for rounding differences between POS reports and processor reports. Anything beyond $10 should be investigated. If you are seeing regular variances in the $10-50 range, that is a workflow problem worth diagnosing, not a threshold to raise.
What should the VA do if they find a discrepancy they cannot resolve?
The VA documents the discrepancy in detail (date, amount, which systems show different figures, and what they checked) and escalates to the owner. The VA does not have authority to issue refunds, adjust account balances, or contact clients directly to resolve payment issues unless you have explicitly granted that authority.
Can a fitness VA reconcile revenue without accounting software?
Yes. A Google Sheet with the right template handles this workflow entirely. Accounting software makes it faster and reduces duplicate data entry, but it is not required. Many studios start with a spreadsheet and migrate to QuickBooks integration after three to six months once the workflow is stable.
How does daily reconciliation differ from monthly reconciliation?
Daily reconciliation catches discrepancies in real time, within 24-48 hours of the transaction. Monthly reconciliation catches them at the end of a 30-day window, by which point the transaction details are harder to trace and the impact on cash flow is already felt. Daily reconciliation does not replace monthly close; it makes monthly close faster and cleaner because the discrepancies have already been resolved.