Medical Spa Reconciliation: Complete Guide for 2025

Medical spa reconciliation is fundamentally different from reconciliation in retail, hospitality, or general healthcare. Your revenue flows through more systems, involves more third-party intermediaries, and carries more accounting complexity per transaction than almost any other small business category. This guide covers every reconciliation domain a med spa encounters, from daily POS-to-bank matching to annual gift card compliance.

What Makes Med Spa Reconciliation Different

A typical med spa transaction touches four to seven systems before it settles in your bank account. A client books a $1,200 treatment package online (booking system). They check in and the service is rendered (POS/EMR). They pay with a credit card (payment processor), redeem $50 in Allē points (loyalty vendor), and finance the remaining balance through CareCredit (financing provider). The credit card portion settles through your processor 1–2 days later. The Allē reimbursement arrives 15–30 days later. The CareCredit settlement hits 2–5 days later minus a merchant discount fee.

That single transaction creates entries in your POS, your payment processor's settlement report, your bank statement (multiple deposits on different days), your loyalty vendor's reimbursement report, and your financing provider's settlement report. Reconciling means confirming that every dollar from that original $1,200 transaction made it through all systems and landed in the correct accounts. Multiply this by 30–50 transactions per day, and you begin to see why med spa reconciliation is a full-time problem.

Daily POS-to-Bank Reconciliation

The foundation of med spa reconciliation is matching your POS daily totals to your bank deposits. This sounds simple, but several structural challenges make it harder than it appears.

First, timing. Credit card transactions processed on Monday don't deposit on Monday. Most processors batch and settle overnight, with funds arriving 1–2 business days later. If you process $15,000 on Friday, the deposit might not appear until Tuesday. This means your POS and bank statement are always out of sync by at least one day—and over weekends and holidays, the gap widens.

Second, aggregation. Your processor doesn't deposit each transaction individually. It batches all transactions from a given day into a single deposit, minus processing fees. Your POS shows 47 individual transactions totaling $15,000. Your bank shows one deposit of $14,580. The $420 difference is processing fees, but without comparing the processor's settlement report, you can't confirm that's all it is.

Third, multiple payment methods. A single day's transactions might include Visa, Mastercard, Amex (sometimes a separate processor), debit cards, cash, gift cards, loyalty redemptions, financing, and tips. Each settles differently. Amex might batch separately from Visa/MC. Tips might settle as a separate line item. Cash doesn't hit the bank at all unless you make a deposit. Gift card redemptions don't create a bank deposit—they reduce a liability.

The daily process: export your POS transaction register for the day, pull your processor's settlement report for the same batch date, and match the two. Then compare the processor's net settlement amount to the actual bank deposit. Any discrepancy needs investigation before it ages into an unresolvable mystery.

Credit Card Processor Reconciliation

Your credit card processor is the intermediary between your POS and your bank. Every dollar of card revenue passes through their system, and they take a fee on every transaction. Reconciling your processor means verifying two things: that every transaction your POS recorded also appears in your processor's records, and that the fees charged match your contract.

Transaction matching catches chargebacks, failed authorizations, and batch errors. If your POS shows a $500 transaction that doesn't appear in your processor's settlement, either the authorization failed (and you delivered a service without getting paid) or there's a system error. Both need immediate investigation.

Fee verification catches overcharges. Your contract might say 2.6% + $0.10 per transaction, but your effective rate (total fees / total volume) might be 3.1%. The difference comes from interchange downgrades (rewards cards cost more to process than standard cards), non-qualified surcharges (keyed-in transactions often get hit with higher rates), and monthly and batch fees that aren't included in the per-transaction rate.

Pull your processor's monthly statement and calculate your effective rate. If it's more than 0.2% above your contracted rate, audit the line items. Common hidden fees include PCI non-compliance fees ($20–$100/month if you haven't completed the annual PCI questionnaire), monthly minimum fees (charged when your volume falls below a threshold), and statement fees, gateway fees, and batch fees that weren't in your original agreement.

Loyalty Program Reconciliation

Allē, Aspire, and Xperience+ loyalty programs add a unique reconciliation layer. When a patient redeems loyalty points, three financial events need to be tracked: the POS records the redemption as a discount or payment method, the loyalty vendor owes you a reimbursement, and your GL needs to record the reduction in loyalty liability (not a revenue discount).

The POS side is straightforward—your system records that $75 in Allē points were applied to a transaction. The challenge is tracking the reimbursement. Allē reimburses practices for most redemptions, but the payment arrives 15–30 days later, often as a batch covering multiple redemptions. You need to match each reimbursement payment to the specific redemptions it covers.

Common loyalty reconciliation failures: redemptions processed in the POS but never submitted to the vendor for reimbursement (you gave the discount but never collected), reimbursements received but not matched to specific redemptions (your books show cash in but you can't tie it to transactions), and redemptions recorded as revenue discounts instead of liability reductions (distorts your P&L and balance sheet).

Build a redemption tracker that logs every loyalty transaction with the date, patient, amount, vendor (Allē/Aspire/etc.), submission status, and reimbursement receipt date. Reconcile this tracker to your bank deposits monthly. Any redemption older than 45 days without a reimbursement needs follow-up with the vendor.

Patient Financing Reconciliation

CareCredit, Cherry, PatientFi, and similar financing providers introduce merchant discount rates (MDR) that vary by plan length. A 6-month promotional plan might cost you 5.9% MDR, while a 24-month plan costs 14.9%. On a $5,000 treatment, that's the difference between $295 and $745 in fees.

Financing reconciliation requires matching each financed transaction to its settlement, verifying the MDR matches the plan type selected, and confirming the net settlement amount equals the gross transaction minus the correct MDR. Your POS records the gross amount. Your financing provider's settlement report shows the net amount after MDR. The difference should exactly equal the MDR for that plan type.

Watch for these common issues: wrong plan type applied (the patient selected 6-month but the system recorded 24-month, costing you an extra 9% in fees), settlements that don't match any POS transaction (possible duplicate or erroneous charge), and delayed settlements beyond the provider's stated timeline (CareCredit states 2 business days; if it's been 5, something is wrong).

Track each financing transaction in a sub-ledger: transaction date, patient, gross amount, plan type, expected MDR, expected net, actual settlement date, and actual net. Reconcile monthly. The MDR calculation is simple math, but nobody does it—and that's why financing providers occasionally apply the wrong rate without anyone noticing.

Gift Card and Package Reconciliation

Gift cards and prepaid treatment packages are deferred revenue under ASC 606. The cash you collect at sale is a liability, not revenue. Revenue is recognized only when the card or package is redeemed. This creates an ongoing reconciliation requirement: your GL deferred revenue balance must match your POS outstanding gift card and package balance.

For gift cards, the reconciliation is: total cards sold (cumulative) minus total redemptions (cumulative) minus breakage recognized equals current deferred revenue liability. Pull this from your POS and compare it to your GL. Any discrepancy means a sale, redemption, or breakage entry was missed or misrecorded.

For treatment packages, the math is similar but more complex. A $2,000 package of 4 Botox sessions recognizes $500 per session. If the patient has used 2 of 4 sessions, $1,000 is recognized revenue and $1,000 remains deferred. Partial redemptions, package modifications, and refunds all require careful journal entries.

Reconcile gift cards and packages monthly. The two most common errors: gift cards sold but never posted to deferred revenue (overstates current-period revenue) and packages partially redeemed but never partially recognized (understates revenue and overstates liability).

Tip and Gratuity Reconciliation

Tips in a med spa are pass-through funds—they're collected from the client, held briefly by the practice, and paid out to the provider. They are not revenue to the practice. But they complicate reconciliation because they flow through your processor and bank alongside revenue transactions.

Your processor deposits the full transaction amount including tips. Your POS separates tips from service revenue. Your bank shows one combined deposit. To reconcile correctly, you need to separate the tip component from each deposit and ensure it flows to your tip liability account, not your revenue account.

For practices with tipped providers on payroll, tips also create payroll tax obligations. Credit card tips must be reported as income, and the practice is responsible for withholding. If tips aren't properly tracked through your reconciliation process, they end up in the wrong accounts and create payroll tax discrepancies.

Month-End Close Checklist

A complete med spa month-end reconciliation touches every domain above. Here's the checklist in sequence.

Days 1–3 after month-end: verify all processor batches for the final 3 business days have settled (they may still be in transit). Confirm all financing settlements for end-of-month transactions have posted. Record any cash deposits made on the last business day.

Days 3–5: complete POS-to-bank reconciliation for the full month. Match every deposit to its corresponding POS batch. Flag and investigate all unmatched items. Calculate your effective processing rate and compare to contract.

Days 5–7: reconcile loyalty redemptions to reimbursements. Update the redemption tracker with any new reimbursement receipts. Follow up on redemptions older than 30 days without reimbursement. Reconcile financing settlements to POS transactions and verify MDR on each.

Days 7–10: reconcile gift card and package deferred revenue (POS balance vs. GL balance). Prepare and post all journal entries (revenue recognition, deferred revenue adjustments, tip allocations, loyalty liability adjustments). Review the trial balance for reasonableness.

Days 10–15: generate financial statements. Compare to prior month and same month prior year. Investigate any significant variances. Finalize and close the period.

Building Systems That Scale

Manual reconciliation works (barely) for a single-location practice doing under $80,000/month. Above that volume, or with multiple locations, the manual approach breaks down. The data volume overwhelms spreadsheets, the timing complexity across multiple processors and vendors creates unresolvable gaps, and the labor cost exceeds the cost of automation.

The transition from manual to automated reconciliation follows a predictable path. First, centralize your data: get all transaction sources (POS, processors, bank, loyalty vendors, financing providers) exporting to a single location in a consistent format. Second, automate the matching: use tools that can match transactions across sources by amount, date, and reference number. Third, build exception workflows: the system handles the 90% of transactions that match perfectly, and you handle the 10% that don't.

The goal isn't to eliminate human judgment from reconciliation—it's to focus human judgment on the items that actually need it. When your team spends 15 hours matching transactions that a computer could match in seconds, you're paying for data entry, not financial expertise. Redirect that expertise toward investigating the exceptions, negotiating better processor rates, and making strategic decisions based on accurate, timely financial data.