Mindbody QuickBooks Reconciliation: QBO Steps
A Mindbody payment can reach your bank as one net deposit, while QuickBooks Online needs the full sales activity behind it. That difference makes Mindbody QuickBooks reconciliation easy to get wrong, especially when processing fees, marketplace commissions, tips, sales tax, or refunds are involved.
The central rule is simple: record the gross activity , record deductions separately, and match the final net amount to the bank. These steps help studio, salon, spa, and wellness-business owners keep revenue accurate without counting the same deposit twice.
Why Mindbody deposits don't match your sales
MINDBODY payment reports may show the full amount customers paid. Your bank statement may show only the amount MINDBODY transferred after payment-processing fees and other adjustments.
For example, a client might pay for a class package, sales tax, and a tip. The settlement report could show all three amounts, less card fees. The bank then receives one smaller deposit. If you categorize that deposit as service income, QuickBooks records only the net amount as revenue. If you also import the full sale through an integration, you may record the revenue twice.
Common differences include:
- Card and online payment-processing fees
- Consumer marketplace commissions
- Refunds and chargebacks
- Sales tax collected
- Tips owed to employees
- Gift card sales or redemptions
- Timing differences between the sale date and payout date
- Deposits grouped into one daily or multi-day batch
MINDBODY reports such as Daily Closeout , One Day Sales , or the credit card payment reconciliation reports can help connect individual activity to each payout. Report names and details can vary based on your account setup, payment method, and integration.
A net bank deposit is not the same thing as net revenue. The deposit reflects cash received after deductions, while revenue usually starts with the gross customer charge.
Mindbody QuickBooks reconciliation starts with the right reports
Before opening the reconciliation screen, collect the records for the same period. A clean review usually includes the bank statement, the MINDBODY settlement or daily closeout report, and the QuickBooks Online bank register.
You should also have payment processor statements, refund details, sales tax reports, and payroll records for tips when those items apply. Keep the payout date and the sale date separate. A sale recorded on Tuesday may not reach the bank until Wednesday or later.
QuickBooks Online works best when you use a clearing account for MINDBODY payments. Name it something clear, such as Mindbody Payments Clearing . This account holds the gross activity until the money settles into the bank.
A common account structure includes:
- Service or class revenue accounts
- Retail sales, if the business sells products
- Sales Tax Payable
- Tips Payable, if tips are passed to staff
- Payment Processing Fees
- Marketplace Commissions
- Mindbody Payments Clearing
- The operating bank account
For a Fort Myers business, sales tax collected belongs in the appropriate sales tax liability account rather than service revenue. A separate sales tax payable reconciliation guide can help when the tax report, QuickBooks liability balance, and payment do not agree.
If a MINDBODY integration already creates sales receipts, invoices, or journal entries, inspect those transactions before adding anything manually. Choose one posting method. Recording imported sales and then categorizing the matching bank deposit as new income creates duplicate revenue.
Step-by-step Mindbody reconciliation in QuickBooks Online
Use the following process for each payout batch or reporting period.
1. Identify the settlement period
Start with the MINDBODY payout date and settlement number. Then identify every sale, refund, fee, and adjustment included in that deposit.
Daily reconciliation is usually easier than waiting several months. For high-volume studios, reconcile each daily closeout or payout batch. For smaller businesses, a weekly review may work if the reports clearly tie each batch to the bank.
Write down the following amounts:
- Gross customer payments
- Sales tax collected
- Tips collected
- Refunds or chargebacks
- Payment-processing fees
- Marketplace commissions
- Other adjustments
- Expected net deposit
The report total should explain the deposit without relying on a plug or unexplained adjustment.
2. Separate revenue from liabilities and deductions
Gross customer activity does not all belong in revenue. Service charges and product sales usually go to income accounts. Sales tax goes to a liability account. Tips may go to Tips Payable until they are paid to employees.
Refunds reduce the related income account or use a refunds and allowances account, depending on your chart of accounts. Processing fees and commissions belong in expense accounts unless your accountant has set up another approved treatment.
This separation gives you useful financial statements. Revenue shows what customers purchased, while expenses show what MINDBODY charged to process or acquire those payments.
3. Record the gross activity in QuickBooks
The first entry should capture the full amount collected before deductions. Use the MINDBODY report as the support for this entry.
A sample settlement might look like this:
| Account | Debit | Credit |
|---|---|---|
| Mindbody Payments Clearing | $5,500.00 | |
| Class and Service Revenue | $5,000.00 | |
| Sales Tax Payable | $350.00 | |
| Tips Payable | $150.00 |
The debit places the full customer payment into the clearing account. The credits send each component to the correct account.
If your integration creates individual sales receipts, you may not need this manual journal entry. Instead, check that the integration posts the gross proceeds to Mindbody Payments Clearing and uses the correct income and liability accounts.
4. Record fees and other deductions separately
Next, record the items that reduced the payout. In this sample, the processing fee is $165 and the marketplace commission is $60.
| Account | Debit | Credit |
|---|---|---|
| Payment Processing Fees | $165.00 | |
| Marketplace Commissions | $60.00 | |
| Mindbody Payments Clearing | $225.00 |
After this entry, the clearing account contains the expected net deposit of $5,275.
Don't combine fees with revenue to force the bank deposit to match. That approach hides the cost of accepting payments and can make gross sales look smaller than they are.
5. Match the net deposit to the bank
Record the payout into the operating bank account:
| Account | Debit | Credit |
|---|---|---|
| Operating Bank Account | $5,275.00 | |
| Mindbody Payments Clearing | $5,275.00 |
When the deposit appears in the QuickBooks bank feed, match it to this existing deposit. Do not select an income category for the bank-feed transaction if the gross sale and payout have already been recorded.
If MINDBODY sends gross deposits and withdraws fees in a separate bank transaction, use a different flow. Match the gross deposit to Mindbody Payments Clearing, then categorize the separate withdrawal as Payment Processing Fees or another appropriate expense.
6. Complete the bank reconciliation
In QuickBooks Online, open Accounting , or All apps > Accounting > Reconcile , and select the bank account. Enter the ending date and ending balance shown on the bank statement, then select Start reconciling .
Check the MINDBODY deposit and any related fee withdrawals that cleared during the statement period. Continue matching transactions until the Difference is $0.00. Select Finish now , then review the reconciliation report.
The reconciliation date is based on the bank statement, not the MINDBODY sale date. Transactions still in transit may belong in the clearing account until they settle.
Review the gross-to-net flow before closing the month
The bank reconciliation can reach zero while the books still contain an accounting error. A zero difference proves that cleared bank activity agrees with the statement. It doesn't prove that every MINDBODY sale went to the right account.
Run a report for Mindbody Payments Clearing after each reconciliation. The balance should consist only of legitimate timing differences, such as a payout recorded by MINDBODY but deposited by the bank after month-end.
A growing or unexplained balance often points to one of these problems:
- A bank deposit was categorized directly to revenue instead of matched to the clearing account.
- Processing fees were omitted from the books.
- A refund was recorded twice.
- A payout was entered manually and also imported by an integration.
- The settlement report covers a different date range than the bank deposit.
- Sales tax or tips were included in income.
- A chargeback or adjustment was posted to the wrong account.
Review the income statement as well. Compare gross MINDBODY sales with revenue by service type, then compare payment-processing fees with the settlement reports. Large unexplained swings deserve attention before tax returns or financial statements are prepared.
Reconciliation checklist for studios and salons
Use this checklist at the end of each period:
- Confirm the bank statement ending date and balance.
- Download the MINDBODY daily closeout or settlement report.
- Tie each payout to the correct bank deposit.
- Confirm gross sales before fees and commissions.
- Separate service revenue, retail sales, sales tax, and tips.
- Record processing fees as expenses.
- Record marketplace commissions and other deductions separately.
- Check refunds, chargebacks, and failed payments.
- Match the bank deposit to the clearing-account entry.
- Review the Mindbody Payments Clearing balance.
- Finish the QBO reconciliation only when the Difference is $0.00.
- Save the reports supporting the journal entries and reconciliation.
Monthly bank reviews also help catch duplicate deposits, missing transactions, and incorrect owner withdrawals. This QuickBooks Online bank reconciliation checklist provides a useful month-end reference for reviewing the bank register and supporting records.
Conclusion
Accurate Mindbody QuickBooks reconciliation depends on separating three amounts: what the customer paid, what MINDBODY deducted, and what reached the bank. Record gross sales and related liabilities first, post fees and commissions separately, then match the net payout through a clearing account.
That process prevents duplicate revenue, keeps expenses visible, and gives you financial statements that reflect how the studio or salon actually operates. When the clearing account contains only valid timing items and the QBO Difference reaches $0.00, the deposit has a clear audit trail from customer payment to bank settlement.
