Complete Guide to Zenoti Reconciliation for Medical Spas

Zenoti is one of the most powerful POS systems for medical spas, but it's also one of the trickiest to reconcile. If you've ever spent hours trying to match your Zenoti sales to your bank deposit, you're not alone. The complexity comes from multiple payment types flowing through a single system, batch processing windows that don't align with bank deposits, and loyalty programs that settle outside your POS entirely.

This guide walks you through the complete Zenoti reconciliation process, highlights the most common stumbling blocks, and shows you how to export your data cleanly into QuickBooks.

Why Zenoti Reconciliation Is Uniquely Complex

Unlike simpler POS systems, Zenoti handles a lot of moving parts simultaneously. Understanding these parts is the first step to a clean reconciliation.

Multiple Payment Types in Single Transactions. A patient might pay with a credit card for a treatment, add a tip via cash, and apply a package credit—all in one transaction. Zenoti records each payment type separately, but your bank deposits them together. You need to know which payment method routed where.

Batch Timing Misalignment. Zenoti settles transactions at the end of day and sends them to your processor. Your processor then batches those transactions and deposits them to your bank 1–3 business days later. If you reconcile daily, your Zenoti totals and bank deposits will never match on the same calendar day.

Gift Cards and Package Credits. These aren't immediate cash deposits. When a patient pays for a package, Zenoti records it as revenue immediately, but your bank doesn't. You must track deferred revenue separately and only recognize it as it's consumed.

Loyalty Program Settlements. If you accept Allē (Allergan) loyalty points or Aspire (Hologic), those redemptions appear in Zenoti as discounts, but the reimbursement comes from AbbVie or Hologic—not directly from patient payments. These are entirely separate settlement streams.

Step-by-Step Zenoti Reconciliation Process

Here's the workflow that most med spa operators should follow weekly or monthly.

Step 1: Export the Zenoti Daily Sales Summary. Log into Zenoti, go to Reports > Sales Reports > Daily Sales Summary. Select your date range. This report shows gross sales, broken down by service category, payment method, and tips. Export as CSV.

Step 2: Export the Zenoti Payment Reconciliation Report. Go to Reports > Payment Processing > Payment Reconciliation. This report shows every transaction that hit your payment processor, including processing fees, chargebacks, and refunds. This is your source of truth for cash flow.

Step 3: Pull Your Bank and Processor Deposits. Log into your merchant processor portal and download the settlement report for the same date range. Also check your bank account for the deposits. Note: bank deposits typically lag processor settlements by 1–2 days.

Step 4: Match Gross Sales to Net Deposits. Your Zenoti Daily Sales Summary should show gross revenue. Subtract payment processing fees (typically 2–3%), any chargebacks, and refunds. The result should match your bank deposit. If it doesn't, proceed to Step 5.

Step 5: Identify Split-Tender Discrepancies. Split-tender transactions (multiple payment methods per customer) are where most reconciliation breaks happen. Pull a detailed transaction report from Zenoti and manually verify that each split transaction is accounted for in your processor settlement. Look especially at transactions where a patient paid partially with a gift card or package credit.

Step 6: Track Pending Loyalty Reimbursements Separately. Any Allē or Aspire redemptions should be pulled into a separate tracking sheet. Record the date redeemed, the amount, and the expected reimbursement date. When the reimbursement arrives from AbbVie or Hologic, match it to this sheet.

The Three Most Common Zenoti Mismatches

Based on conversations with med spa operators, these three issues account for the vast majority of reconciliation headaches.

1. Tip vs. Treatment Splits. When a patient adds a tip at the terminal, some processors route tips separately from the treatment payment. Zenoti might show $200 in service revenue + $20 in tips, but your bank deposit shows only $212 because tips and treatment are in different settlement batches. Always check your processor's settlement report for tip-specific line items.

2. Package and Membership Prepayments Recognized at the Wrong Time. A patient buys a $1,000 package for 4 sessions. Zenoti records the full $1,000 as revenue on day one, but accounting best practice says you should recognize $250 per session. If your bookkeeper is using Zenoti's revenue numbers directly in QuickBooks, your financial statements will be overstated in month one.

3. Refunds Processed but Not Reflected in the Next Bank Batch. Refunds can take 3–5 business days to appear in your bank account, depending on the card network. Your Zenoti Payment Reconciliation Report might show the refund, but the deposit doesn't arrive until days later. Always reconcile in a rolling window: don't close a month until all pending refunds have settled.

Exporting Zenoti Data to QuickBooks

Once you've reconciled your deposits, you need to record them in your general ledger. Zenoti doesn't connect directly to QuickBooks for most med spas, so a manual export process is standard.

Chart of Accounts Mapping. Before you export, map your Zenoti service categories to QuickBooks income accounts. For example:

• Zenoti "Injectables" → QB 4100 Medical Services Revenue
• Zenoti "Facials" → QB 4110 Aesthetic Services Revenue
• Zenoti "Retail" → QB 4200 Product Revenue

Deferred Revenue Handling. Create a separate liability account in QB (e.g., 2400 Gift Card Liability). When a patient buys a package, debit Cash and credit Gift Card Liability. As they redeem sessions, move the amount from liability to revenue. This keeps your financial statements accurate.

Automating the Export-to-Journal-Entry Pipeline. If you're exporting weekly, consider using a CSV template in QB to batch-upload transactions. Instead of manual journal entries, upload a properly formatted CSV from Zenoti and QB will create entries in bulk. This cuts reconciliation time from hours to minutes and eliminates manual entry errors.

Automating Zenoti Reconciliation

If your team spends more than a few hours each week on Zenoti reconciliation, automation is worth exploring. There are two main paths.

CSV Upload Path. Download your Zenoti reports as CSV, then upload them to accounting automation software. No API integration needed. This works well if you reconcile monthly and can tolerate a short manual export step.

Reconcilify's Zenoti Integration. We've built native connectors to Zenoti that pull your Daily Sales Summary and Payment Reconciliation Report automatically. Your data syncs daily, and mismatches are flagged before they become month-end surprises.

What Changes When You Automate. Manual reconciliation is typically a monthly or end-of-quarter task. Automated reconciliation can run daily, catching discrepancies while they're fresh and transactions are easy to trace. Instead of firefighting at month-end, your team reviews daily alerts and resolves issues in real time. The result: cleaner financial records, faster closing, and more time for strategic work.

Zenoti reconciliation doesn't have to be painful. With the right process, your team can stay on top of deposits, loyalty payments, and package revenue in just a few minutes each week.