Reconcile med spa revenue in three separate bridges: POS transactions to payment activity, payment activity to bank settlements, and collections to earned revenue. Preserve identifiers, dates, and source reports. Explain taxes, tips, refunds, fees, reserves, non-card payments, deposits, and membership obligations rather than forcing unrelated totals to match.
What is the buyer trying to prove?
The objective is to establish what was sold, how customers paid, what reached the bank, and what was earned in the analyzed period. Those questions overlap but are not identical. A POS sales report can include unpaid invoices, taxes, tips, deposits, packages, and reversals, while a processor deposit can net several days of activity.
A reproducible reconciliation lets another reviewer follow the same records and obtain the same result. It does not require every report’s headline total to be equal. The buyer should seek a documented explanation of differences rather than a spreadsheet that hides them in an unexplained “other” line.
The IRS recordkeeping guidance identifies supporting records such as sales and deposit information. These records are a foundation for the analysis, not a substitute for defining the acquisition’s reporting basis and testing earned revenue with an accountant.
Which exports should be preserved?
| Source | Needed fields | Purpose |
|---|---|---|
| POS transactions | ID, date, entity, location, service, tax, tip, tender, refund | Population and sale classification |
| Processor activity | Charge ID, balance ID, fee, adjustment, payout ID | Payment and settlement bridge |
| Bank transactions | Date, amount, reference, account | Cash receipt verification |
| Customer obligation ledger | Collection, redemption, expiry terms, refund, balance | Earned-versus-unearned analysis |
| General ledger | Account, period, entry source, supporting schedule | Financial statement reconciliation |
Retain original files with export date, filters, timezone, report name, and system version where available. Work on copies and keep a change log. A screenshot of a dashboard is less useful than a complete transaction export when the buyer needs to test cutoff, duplicates, refunds, and mapping.
How do you define a consistent population?
Choose one entity, location group, date interval, currency, and report basis. State whether dates reflect sale, charge, service, settlement, or bank posting. A calendar-month POS report and a bank statement can legitimately contain different transaction cohorts because settlement crosses the month end.
List every tender type: card, cash, check, financing partner, bank transfer, gift balance, membership credit, and unpaid receivable. A redemption of previously collected value can appear as a service sale without new cash. Treating it as another bank receipt would duplicate collections.
Confirm whether refunds are assigned to the original sale period or refund date and whether voids remain in exports. Test system changes and location transfers. A missing store or duplicated migration file can create a large apparent revenue movement without any underlying change in customer demand.
What is an illustrative POS-to-payment bridge?
Assume an invented monthly POS activity total of $150,000, including $5,000 sales tax and $7,000 tips. Subtracting those items leaves $138,000 sales before other classification. Assume $12,000 of the $138,000 was paid in cash and $6,000 remains unpaid. The card-charge population is $120,000.
The calculation is $150,000 − $5,000 − $7,000 − $12,000 − $6,000 = $120,000. This is a teaching example, not a prescribed tax treatment or a typical med spa tender mix. The real accountant must determine which items belong in revenue, liabilities, receivables, and cash under the relevant basis.
Match the $120,000 charge population to processor transaction IDs. Investigate duplicates, split tenders, reversals, and missing transactions. A match at the total level can conceal two offsetting errors, so sample individual records and use full-population matching where the exports support it.
How do charges become bank payouts?
Continue the illustrative case with $120,000 card charges. Assume $4,000 refunds, $3,000 processing fees, a $2,000 reserve increase, and $8,000 still pending at month end. The expected bank settlements from that activity are $103,000: $120,000 − $4,000 − $3,000 − $2,000 − $8,000.
If the bank also receives $9,000 from the prior period, actual monthly deposits could be $112,000. That does not make the current activity worth $112,000. The $9,000 is a timing bridge that should be traced to its original population, not labeled new revenue.
Stripe’s payout-reconciliation guidance explains how certain payout reports connect underlying activity with settlements. Manual payouts and provider-specific reporting can require a different approach. Preserve the processor balance reconciliation as well as the payout-to-bank match so pending and restricted balances remain visible.
Why does earned revenue need another bridge?
A customer can pay now for future services or receive a service now using earlier collections. The payment-to-bank bridge verifies cash but does not decide when the service was earned. Reconcile packages, memberships, gift balances, deposits, refunds, and unpaid services under a consistent accounting policy.
For an illustrative separate population, assume $138,000 sales after tax and tips includes $18,000 newly collected future-service value and $11,000 services delivered using earlier prepaid balances. If the system’s sales figure excludes those redemptions from earned sales, the teaching earned-revenue bridge is $138,000 − $18,000 + $11,000 = $131,000.
The exact bridge depends on the POS report definition. Do not add redemptions if they are already included in the report’s service sales. Request a data dictionary and verify samples. The purpose is to prevent double counting, not to apply the same formula blindly to every platform.
What role does Form 1099-K play?
The IRS Form 1099-K guidance explains that reported gross payment amounts are not adjusted for several items, including fees and refunds. A 1099-K can therefore provide a useful cross-check without being identical to payouts, book revenue, or taxable profit.
Confirm payee identity, processor coverage, period, and any corrected forms. Multiple channels can produce multiple forms, while cash activity is outside that particular reporting path. A missing form does not prove missing revenue, and a high gross figure does not prove that every dollar was earned service revenue.
Use tax returns, forms, ledgers, bank records, and transaction exports together. If they disagree, request the original reconciliation and investigate material unexplained differences with the accountant. Do not choose whichever document produces the desired earnings or acquisition price.
Which errors deserve special attention?
- Deposits posted as revenue despite outstanding service obligations.
- Refunds omitted from one report and included in another.
- Tax and tips treated as revenue without review.
- Cash tender recorded but not reconciled to deposits and cash use.
- Duplicate exports or system-migration opening balances.
- Unexplained manual journal entries near closing.
- Processor reserves or prior-period settlements counted as new sales.
Materiality should reflect both dollars and the nature of the issue. A small recurring mapping error can affect multiple periods, and an intentional override can matter even when the sample amount is modest. The buyer should document the evidence, explanation, correction, and remaining uncertainty.
A mismatch is not automatically fraud. Different dates and report definitions often explain differences. But an explanation should be supported and reproducible. Repeated refusal to provide underlying records is a separate diligence concern from an ordinary timing difference.
What is the final deliverable?
Produce a source index, data dictionary, three bridges, exception log, sampling notes, proposed corrections, and reconciliation to the earnings schedule. Another reviewer should be able to repeat the calculations without relying on undocumented verbal instructions from the seller.
Use the buyer roadmap, valuation hub, operations guidance, and seller hub. The diligence guide, membership ledger guide, and Four-Number Med Spa Valuation Screen connect verified revenue to normalized earnings. Replace the fictional amounts with actual exports before using the method in a deal.
What else do owners and buyers ask?
Should POS sales equal bank deposits for the same month?
Not necessarily. Taxes, tips, tender types, unpaid invoices, refunds, fees, reserves, pending settlements, and prior-period payouts can explain differences. Define the report population and date basis, then reconcile each bridge separately. The goal is a supported explanation of cash and earned revenue rather than forcing unrelated headline totals to match.
Does matching bank deposits prove EBITDA?
No. It verifies particular cash movements, not complete earned revenue, expenses, liabilities, or replacement costs. A business can collect for future services or incur unpaid costs. Revenue reconciliation should feed a broader earnings analysis that reviews accounting basis, payroll, products, obligations, owner roles, and other operating expenses with qualified advisers.
Can the buyer use a 1099-K instead of transaction exports?
It is a useful cross-check but usually lacks the detail needed for acquisition reconciliation. Gross reporting can differ from payouts and earned revenue, and multiple providers may cover different channels. Obtain underlying transactions, processor statements, bank records, and ledger support, then explain how the form fits the complete population.
What should happen to an unexplained revenue difference?
Record it in an exception log with amount, period, source, responsible reviewer, and requested evidence. Investigate report definitions and timing before drawing conclusions, then evaluate corrections and remaining uncertainty. Do not hide the gap in a balancing entry. Material unresolved differences may change earnings, funding, price, or the decision to proceed.
Which sources support this guide?
Sources were checked during research. Regulations, lender policies, and market conditions can change. Use the linked primary material and your advisors to confirm applicability.
- What kind of business records should I keep? — Internal Revenue Service
- Find transactions included in or affecting a payout — Stripe
- What to do with Form 1099-K — Internal Revenue Service
Educational analysis prepared with AI-assisted research for The Med Spa Broker. “Last reviewed” records the source and editorial check date; it does not imply review by an attorney, clinician, or independent appraiser. Read our editorial standards.