7 QuickBooks Online Errors We See in Med Spa Books (And How to Fix Each)

When a med spa's QuickBooks Online file lands on our desk, we open the balance sheet before the P&L and look for four accounts: deferred revenue, inventory, sales tax payable and tips payable. If any is missing, we already know most of what the P&L gets wrong, because a med spa's money moves in ways a default QuickBooks setup was never built for: patients pay before treatment, product is bought in lots and used by the syringe, providers are paid on last month's production, and in many states the clinical and management sides are separate entities.

Here are the seven we find most often, how to spot each, why it matters and the fix, then a worked example of all seven in one practice.

Errors on the revenue side

1. Merchant deposits booked as revenue, net of fees

Spot it: income is fed by bank-feed deposits from the processor, the merchant fee line is missing or tiny, and monthly revenue does not match the sales-by-category report from Aesthetic Record, Boulevard, Zenoti or whatever POS you run.

Why it matters: the processor deposits sales net of fees, a business day or more after the batch, so revenue is understated by the fee, the fee is invisible, and month-end sales fall into the next month. The processor's Form 1099-K reports gross card transactions, an amount the IRS says "isn't adjusted for any" fees, refunds or credits, per its guidance on Form 1099-K, so books built on net deposits never agree with it, and revenue by service line does not exist.

Fix: record sales from the POS summary, gross, by service line, as a daily or monthly sales receipt. Record each processor deposit as a bank deposit clearing those receipts, with the fee as a negative line to merchant fee expense, as Intuit's instructions for recording bank deposits describe. The feed deposit is matched, never added.

2. Package, membership and gift card sales booked as income

Spot it: no deferred revenue liability on the balance sheet while the POS outstanding-balance report shows tens of thousands of dollars unredeemed.

Why it matters: money collected for treatments not yet delivered is a liability. Booked as income, the promotion month shows a profit that belongs to patients, the delivery months show provider cost without revenue, and the owner draws against money she still owes. IRS Publication 538 sets the tax side (cash-method practices report advance payments when received; accrual-method practices may defer at most one year), but the books should be right whichever method the return uses.

Fix: create a deferred revenue liability with sub-accounts for packages, memberships and gift cards, map the POS items to it, post redemptions monthly from the POS redemption report to the service line where the treatment was performed, and roll the balance forward to the POS outstanding-balance report. Mechanics and forfeiture rules are in memberships, packages and gift cards accounting.

3. Sales tax and tips sitting in revenue

Spot it: revenue is higher than the POS gross sales report, which almost always means it contains sales tax collected on retail, tips, or both. The Sales Tax Liability report (Reports, Standard reports, then search for it, per Intuit's instructions) is empty because the sales tax feature was never turned on.

Why it matters: retail product is taxable in essentially every state with a sales tax and most states do not tax the treatments, so the tax lives on a small slice of sales that is easy to lose in one income account. Booked as income, revenue is overstated, remittances land in expense and the unpaid balance is missing from the balance sheet. Tips are the staff's money: under IRS Topic 761, employees report cash tips of $20 or more in a month to the employer by the tenth of the next month, the employer withholds income tax and the employee share of Social Security and Medicare on them and pays the employer share, and a mandatory service charge paid to staff is wages, not a tip. Tips run through revenue and expense usually bypass payroll.

Fix: turn on the sales tax feature, set retail items taxable and services non-taxable, reclassify collected tax to Sales Tax Payable and record remittances as sales tax payments. Create Tips Payable, map the POS tip line to it and clear it through payroll each run, so the tips reach the W-2.

Errors on the cost side

4. Injectables expensed when purchased, with no inventory account

Spot it: distributor payments post straight to a "medical supplies" expense, there is no inventory asset, and gross margin swings ten points after every stock-up.

Why it matters: neurotoxin, filler and biostimulators are the most valuable items in the building and the easiest to waste or lose. Expensing on purchase makes cost follow the shipping calendar rather than the treatment calendar, so the monthly margin is meaningless, the balance sheet is missing an asset worth tens of thousands of dollars, and nobody compares units purchased with units billed in the POS, the only shrink control a med spa has.

Fix: create inventory asset accounts for injectables and retail, post distributor invoices there, count on the last day of the month, and book cost of goods sold as opening plus purchases less closing. The gap between units relieved and units billed is waste, samples or shrink. See inventory accounting for injectables and retail.

5. Commissions in payroll that never match the service revenue

Spot it: commission expense appears in the month the payroll ran, inside one payroll line beside the front desk, calculated on the POS sales report including package sales.

Why it matters: October's commissions paid in the first November payroll land against November's revenue, so every month compares this month's treatments with last month's provider cost. Commission on package sales pays the injector before any treatment exists. And with provider pay in overhead rather than cost of goods sold, there is no gross margin by line to read.

Fix: calculate commissions from the production report on recognized service revenue, net of discounts and excluding tax, tips and gift card sales, with package treatments counted when delivered. Accrue to Commissions Payable when earned, pay through the next payroll and reverse. Map injector wages, commissions and employer taxes to cost of goods sold; see injector compensation and commission payroll.

Errors in the structure of the file

6. MSO and professional-entity transfers booked as income and expense

Spot it: transfers between the management company's and the professional entity's bank accounts appear as "management fee income" in one file and "management fees" in the other, in amounts that match neither the agreement nor each other.

Why it matters: where the corporate practice of medicine doctrine applies, a med spa often runs as a professional entity for clinical services plus a management services organization providing non-clinical services for a contractual fee; AmSpa's overview of the structure notes that Texas treats non-invasive aesthetic services as the practice of medicine. Whether you need it is a question for a health-care attorney licensed in your state. Once it exists, only the contractual fee is MSO income and professional-entity expense. Sweeps of collections, payroll one entity paid for the other and shared rent are intercompany balances, due to and due from, equal and opposite in both files. Booked as income and expense, the MSO shows phantom revenue, the professional entity a phantom loss, and taxable income moves between two owners.

Fix: set up Due to and Due from accounts in both files, invoice the contractual fee monthly, record every transfer and shared cost as intercompany, and reconcile the two balances to the dollar at each close. See MSO and professional-entity accounting.

7. The Undeposited Funds pile-up

Spot it: an Undeposited Funds balance that keeps growing, holding POS sales receipts from months ago, while the processor's deposits were added from the feed as new income.

Why it matters: this is the double-count. The POS integration records the sale once, into Undeposited Funds, the account Intuit says "holds everything before you record a deposit." When the net deposit arrives in the feed and someone clicks Add instead of Match, the sale is recorded again: revenue is doubled for every dollar still in the account and the balance sheet shows an asset that does not exist; a few months of this is usually the largest error on the return.

Fix: for each real deposit, open Bank deposit, select the receipts that make it up, add the fee as a negative line and match it to the feed. Where the feed deposit was already added as income, edit it to pull in the waiting receipts and remove the income line. A true duplicate still in For review is excluded; excluded transactions "move to the Excluded tab" and "won't be added to QuickBooks or downloaded again" per Intuit's guidance. Never delete a reconciled transaction; fix the unreconciled twin.

Before and after: what each fix changes

Worked example: an Austin MSO and professional entity at September 30 (illustrative)

Take an illustrative Austin, Texas practice: a nurse owner's management company and a physician-owned professional entity under a management services agreement, about $1.6 million of combined annual revenue, collections running through the professional entity. The owner kept both files through September 2026; together they showed $186,000 of year-to-date profit. Figures are rounded and illustrative.

The two files overstated combined profit by $47,600, and the errors did not cancel: two pushed one way, four the other, and the gross errors ran to nearly $90,000 before the intercompany problem, the expensive one. With $290,000 of sweeps booked as income, the management company's return would have reported profit that belonged to the professional entity, a different taxpayer. The sales tax finding was small in dollars and large in exposure: Texas imposes a 6.25% state rate plus local tax of up to 2%, a combined rate of up to 8.25%, with monthly returns due on the 20th of the following month, per the Texas Comptroller, and the practice had been remitting from the POS report while its books showed no liability. The corrected balance sheet gained a $93,000 deferred revenue liability and a $37,000 inventory asset, and lost a $34,000 asset that did not exist.

What usually goes wrong when owners fix these themselves

Deleting instead of matching or excluding, which breaks reconciled months. Clearing Undeposited Funds or deferred revenue with one journal entry, which fixes the total and leaves every patient balance wrong. Cleaning up a year already filed without telling the preparer. Turning the POS integration on mid-year without turning off manual deposit entries, which doubles revenue from that date.

Trusting bank-feed categorization: a distributor payment, a sweep to the MSO account and a patient refund look alike in the feed, none is an expense, and a rule that learned last year's wrong coding repeats it. And fixing the symptom without the setup: a file that booked packages as income because the POS items were mapped to income will do it again next month unless the mapping changes.

When to get help

If you found one or two of these and the rest of the file reconciles, the steps above are enough, and your preparer should review the year-end balance sheet before filing. If you found four or more, or there is no deferred revenue account, or two entities' intercompany balances were never reconciled, the faster and cheaper route is a proper cleanup: every account reconciled from the last clean month, the chart of accounts rebuilt for a med spa, and a corrected balance sheet your preparer can rely on. That is our med spa cleanup and catch-up service, quoted as a one-time fixed project after a diagnostic; the sequence is in catching up months of med spa bookkeeping.

A cleanup is usually followed by monthly bookkeeping, because a file that drifted for a reason will drift again. To learn which of the seven you have before year-end, request a 20-minute fit call and bring your balance sheet, P&L and POS outstanding-balance report; together they are enough to tell.

Jenny Gao, CPA, EA

Founder of Balance Partners, a CPA-led accounting, tax and fractional CFO practice for med spas. Florida-licensed CPA and IRS Enrolled Agent with more than 13 years of accounting and tax experience. Jenny writes and reviews every guide on this site. About Jenny

This guide is general educational information for owners of med spas and aesthetics practices in the United States and is not accounting, tax, legal, medical, payroll or financial advice for your situation. Rules change and vary by entity, state and facts. Balance Partners, LLC does not provide audit, review, compilation or other attest services. Last reviewed November 8, 2026.