Med spa guides · Working with an accountant

Signs Your Med Spa's QuickBooks Needs a Cleanup Before Tax Season

Eight signs a med spa's QuickBooks file needs a cleanup before tax season: no deferred revenue, inventory at zero, deposits as income, negative payroll taxes.

Short answer

A med spa's QuickBooks Online file needs a cleanup before tax season if the balance sheet has no deferred revenue account for prepaid packages, memberships and gift cards, inventory sits at zero while the refrigerator is full, the QuickBooks bank balance does not match the bank, payroll liabilities are negative, sales tax payable does not match the filed returns, revenue equals processor deposits with no merchant fee expense, Ask My Accountant holds thousands of dollars, or MSO transfers show up as income. Two or more of those signs mean the year-end numbers are not usable for a return without a rebuild. A read-only diagnostic identifies the anchor date and scope, and the cleanup is quoted as a one-time fixed project before work starts.

Key takeaways

  • A med spa file built from the bank feed alone is current, reconciled and wrong, because packages, inventory, commissions and merchant fees never appear in the bank feed.
  • The balance sheet signs: no deferred revenue account or one that never changes, inventory at $0, a QuickBooks bank balance that differs from the statement, negative payroll liabilities, and sales tax payable that does not equal POS collections less filed payments.
  • The P&L signs: revenue equal to processor deposits with no merchant fee line (the 1099-K reports gross), large Ask My Accountant or uncategorized balances holding loan payments and personal items, and MSO or owner transfers recorded as income.
  • In the illustrative Austin diagnostic, $262,000 of booked income becomes about $248,000 on a cash-method return and about $118,000 on accrual books once $130,000 owed to patients is recognized.
  • A diagnostic is read-only and produces a written finding: anchor date, accounts and months in scope, what must be rebuilt, which filings are affected, and the deadline that sets the order (March 15 or April 15, 2027 for 2026 returns).
  • The cleanup is quoted as a one-time fixed project driven by scope, not hours; Med Spa Core, from $1,500 a month, keeps the file clean afterward.
In this guide

A med spa's QuickBooks Online file can look healthy right up to the week the tax organizer arrives. The bank feed is categorized, the balance in QuickBooks is close to the balance at the bank, and the profit and loss shows a number the owner can live with. Then the accountant asks for the year-end package liability, the inventory count and the merchant statements, and the file has no answer to any of them.

What follows are the signs we look for when a practice sends us its file before tax season, grouped by where they show up, with a self-check you can run in fifteen minutes, an illustrative diagnostic of an Austin practice, and how a fixed-fee cleanup is scoped. If you already know the file is behind, our cleanup and catch-up plan covers the rebuild itself.

Why a med spa file breaks differently

A generalist bookkeeper reconciles the bank and categorizes expenses. A med spa's money does not move that way. Revenue is earned in the POS or EMR (Aesthetic Record, Boulevard, Zenoti, Vagaro and the like) and arrives at the bank a day or two later, net of processor fees, with sales tax on retail and tips mixed in. Patients prepay for packages, memberships and gift cards that the practice owes back in treatments. Neurotoxin and filler sit in the refrigerator as inventory until dispensed. Injectors earn commissions a month after the treatments. In an MSO and professional-entity structure, cash moves between two companies that must each have their own books.

None of that is visible from the bank feed. A file built only from the bank feed is current, reconciled and wrong, and the error shows up where the owner does not look: on the balance sheet.

Signs on the balance sheet

No deferred revenue account, or one that never moves

Open the balance sheet. If there is no liability for prepaid packages, memberships and gift cards, every dollar a patient prepaid has been booked as revenue the day it was collected, and the practice is carrying an obligation to deliver treatments that appears nowhere. If the account exists but shows the same balance it did in January, nobody is tying it to the POS outstanding-balance report each month. The test is simple: run that report for the last month-end and compare it to the balance sheet. Our guide to memberships, packages and gift cards explains the rollforward that should produce the number.

Inventory asset at zero

A practice that buys $300,000 of neurotoxin, filler and skincare a year has product on the shelf on December 31. If the inventory asset reads $0, every purchase has been expensed when the invoice was paid, so cost of goods sold follows ordering patterns rather than treatments, the gross margin by service line is meaningless, and the tax return is built on a number no one counted. A year-end count sheet and the injectables and retail inventory method fix it, but only if someone notices before the return is filed.

The QuickBooks bank balance does not match the bank

The most common cause in med spa files is duplicate deposits: sales receipts or invoices entered manually from the POS, then the bank feed deposit added as new income instead of matched. The second is a reconciliation forced to balance with an adjusting entry, which hides the difference rather than finding it. Look at the reconciliation report for the last month: a reconciliation discrepancy line or a large uncleared-transactions list means the balance agrees on paper only.

Payroll liabilities below zero

A negative payroll liability means the payroll provider's tax debits were posted against the liability account but the payroll itself, the wages, commissions, tips and employer taxes, was never recorded, or was recorded to expense without the liability side. The P&L then understates provider cost, and the W-2s and Forms 941 will not tie to the books. Compare the year-to-date payroll register from Gusto, ADP, Paychex or QuickBooks Payroll to the wage accounts; they should agree to the dollar.

Sales tax payable that does not match the filed returns

The POS collects sales tax on retail skincare and devices, and in Florida the practice remits it on Form DR-15, due on the 1st and late after the 20th of the following month. The balance sheet liability at month-end should equal the tax collected per the POS less what has been paid, and the payment should equal the filed return. When the liability is far smaller than a month of collections, or negative, the tax is usually sitting inside revenue and the payments are sitting in an expense account, so revenue is overstated by the tax and the return was prepared from the POS rather than the books. A clean file also books the small Florida collection allowance as other income rather than leaving it as an unexplained difference.

Signs on the profit and loss

Merchant deposits recorded as income

If revenue in QuickBooks equals the processor deposits, the practice has recorded net sales and has no merchant fee expense. The processor's Form 1099-K reports the gross amount of card transactions, which the IRS instructions define as being "without regard to any adjustments for credits, cash equivalents, discount amounts, fees, refunded amounts," so a return built on net deposits shows less revenue than the IRS has already been told. Revenue should come from the POS sales summary by service line, with fees as an expense and the deposit clearing through an in-transit account.

Large "Ask My Accountant" or uncategorized balances

Every file has a few. A med spa file with tens of thousands of dollars parked there usually contains device loan payments (which should split into principal and interest), the owner's personal card paid from the practice, transfers between the practice's own accounts, and payments to the medical director that nobody knew how to label. Sort the account by amount; the ten largest lines tell you what the bookkeeper did not understand about the practice.

MSO transfers booked as income

In a practice with a management services organization and a professional entity, money moves between them constantly: the professional entity pays the management fee, the MSO funds payroll or rent, and one side often pays the other's bills. Each transfer is intercompany, a receivable on one side and a payable on the other, never income or expense. When the professional entity's file shows "Other income" from the MSO, or the MSO's file shows the physician's fee as its own expense, the two sets of books cannot be reconciled and the tax returns for both entities are wrong. Our MSO and professional-entity accounting guide covers the recharge entries.

The fifteen-minute self-check

Where to look in QuickBooks OnlineA clean med spa file showsA file that needs cleanup shows
Balance sheet, current liabilitiesA deferred revenue or package liability equal to the POS outstanding-balance reportNo such account, or a balance unchanged since the file was set up
Balance sheet, current assetsInventory that moves monthly and ties to a countInventory at $0 while cost of goods sold shows every supplier invoice
Reconciliation report, last monthEnding balance matches the statement; few uncleared itemsA reconciliation discrepancy entry or dozens of uncleared deposits
Payroll liabilitiesSmall positive balance between payroll and depositNegative balance; wage accounts do not match the payroll register
Sales tax payableEquals POS tax collected less payments; payments equal filed returnsNear zero or negative; tax inside revenue, payments in expense
Profit and loss, incomeRevenue by service line from the POS; separate merchant fee expense lineOne "Sales" line equal to bank deposits; no merchant fees
Ask My Accountant / UncategorizedA handful of items awaiting a questionThousands of dollars, including loan payments and transfers
Other income (MSO or PC file)Nothing from the related entity; intercompany due to/from accounts insteadTransfers from the other entity recorded as income

Two or more rows in the right-hand column means the year-end numbers are not usable for a return, a loan or a valuation without a cleanup. Five or more usually means the problem reaches back into a prior year.

Worked example: an Austin practice's diagnostic (illustrative)

Take an illustrative practice in Austin, Texas, that opened in March 2026 with an owner who is a nurse practitioner, two injectors and an esthetician, operating as a professional entity with a separate MSO, and heading toward $1.6 million in annualized revenue. The owner's QuickBooks Online file shows 2026 net income of $262,000 and she wants to know whether to prepay the fourth-quarter estimate. A read-only diagnostic finds eight issues.

Finding (illustrative)What the file showsEffect on 2026 net income as booked
No deferred revenue accountPOS outstanding balances at year-end: $130,000 of packages, memberships and gift cards owed to patientsAccrual books overstated by $130,000; cash-method return unaffected
Inventory asset at $0Year-end count: $34,000 of neurotoxin, filler and skincare on hand, all expensedIncome understated by $34,000
MSO transfers as income$60,000 of MSO funding transfers posted to "Other income" in the PC fileIncome overstated by $60,000
Bank balance $12,000 over the statement14 duplicate deposits posted to SalesIncome overstated by $12,000
Ask My Accountant: $61,000Includes $9,000 of the owner's personal card payments and $18,000 of device loan payments, of which about $15,000 is principalIncome understated by $24,000 once personal and principal items are removed from expense
Payroll liabilities at negative $6,800No payroll entries since March; only provider debits postedWages misstated; W-2s will not tie to books
Sales tax payable at $2,100POS shows $12,400 collected in the last quarter; payments booked to expenseRevenue and expense both overstated by about $41,000 for the year; net income unchanged
Revenue equals depositsNo merchant fee expense; processor statements show $46,000 of feesRevenue and expense both understated by $46,000; net income unchanged; 1099-K will not match

On a cash-method return, the corrections net to about $248,000 of income rather than $262,000, a small change that hides large ones: revenue restated for sales tax and fees, $60,000 that was never income, and product on the shelf that was never an expense. On the management books, recognizing the $130,000 owed to patients takes accrual net income to about $118,000, which is the number that should drive the estimate, the owner's draw and the decision about a second esthetician. Since the practice opened in 2026 there is no prior return to amend; had it opened in 2025 with the same file, the diagnostic would have flagged the 2025 return as well.

What a diagnostic looks like, and how the cleanup is quoted

A diagnostic is read-only. We take accountant access to the QuickBooks Online file, the last statement for every bank, card and merchant account, the POS year-end sales summary and outstanding-balance report, the payroll filings, the sales tax returns, and the prior return and depreciation schedule if there is one. Nothing in the file is changed. The output is a written finding: the anchor date (the last month that is trustworthy, or the opening balance sheet), the accounts and months in scope, what has to be rebuilt rather than recategorized, which filings are affected, and the deadline that sets the order of work. For a calendar-year S corporation or partnership that is March 15, 2027; for a single-member LLC on the owner's return or a C corporation, April 15, 2027.

The cleanup is quoted from that finding as a one-time fixed project, in writing, before any work starts. What drives the number is scope, not hours: how many months and accounts, how many transactions, whether POS exports exist for every month or the revenue has to be rebuilt from processor statements, whether the package liability must be reconstructed month by month, whether sales tax or income tax returns must be amended, and whether there is an MSO and professional entity to reconcile against each other. A six-month, single-entity file with good POS exports is a different project from a two-year, two-entity file with none. Once the file is clean, keeping it that way is what our monthly service is for; Med Spa Core starts at $1,500 a month and is month-to-month after onboarding with thirty days' written notice.

What usually goes wrong

Owners who try to fix the file themselves in January tend to make the same moves. Starting a new QuickBooks file, which loses the history and does nothing about the opening balances the new file needs. Deleting transactions in bulk, which breaks every past reconciliation and changes periods already reported. Forcing the bank reconciliation with an adjustment so the screen turns green. Cleaning only the bank feed, which cannot create a deferred revenue balance or an inventory count no matter how carefully it is categorized. Reconnecting the bank feed and discovering that, per Intuit's own guidance, the download reaches back only 90 days for some banks (Intuit puts the range at 90 days to 24 months), so the early months have to come from statements anyway.

The other pattern is sequencing: filing the return from the uncleaned file to meet the deadline and promising to fix the books afterward. An extension costs nothing if the estimate is paid; an amended return, a sales tax assessment, or a loan application built on revenue that does not match the 1099-K costs considerably more. Keep the records that make a cleanup possible, the POS exports, processor statements and count sheets, for as long as the return they support, which the IRS puts at a minimum of three years and four years for employment tax records.

When to get help

If one row of the self-check is off, your bookkeeper can probably fix it in a month-end close. If the balance sheet has no package liability and no inventory, revenue equals deposits, and the uncategorized account has a device loan in it, the file needs a cleanup before anyone prepares a return from it, and the time to find that out is November, not March.

Our med spa cleanup and catch-up service starts with that diagnostic and quotes the rebuild as a fixed one-time project; the monthly close checklist shows what the file looks like once it is maintained properly. If your tax organizer is sitting unanswered because the numbers in QuickBooks do not feel right, request a 20-minute fit call and bring your balance sheet and the POS outstanding-balance report.

Want this handled for your practice, not just explained?

Request a 20-Minute Fit Call → Med Spa Cleanup & Catch-Up →

Frequently asked questions

My QuickBooks bank balance matches the bank. Doesn't that mean the books are right?

It means cash is right. A med spa's errors live on the balance sheet and in how revenue was recorded: prepaid packages booked as income, inventory expensed on purchase, sales tax inside revenue, merchant fees netted out of sales, MSO transfers counted as income. None of those change the bank balance, which is why the self-check starts with the balance sheet rather than the reconciliation.

What is the single biggest sign a med spa file needs a cleanup?

No deferred revenue account. If the balance sheet shows nothing for packages, memberships and gift cards while the POS outstanding-balance report shows six figures owed to patients, every prepaid dollar has been treated as earned, the P&L overstates the months with promotions, and nobody has tied the books to the POS. The inventory asset at zero is a close second.

Can I just start a new QuickBooks file for the new year?

You can, but it does not solve the problem. The new file needs opening balances for cash, inventory, the package liability, fixed assets, loans and equity, and those come from cleaning up the old file. Starting fresh also loses the transaction history a lender, buyer or examiner will ask for. A cleanup that fixes the old file and locks it is almost always the better route.

How is a med spa QuickBooks cleanup priced?

As a one-time fixed project, quoted in writing after a read-only diagnostic and before any work begins. The quote depends on how many months and accounts are in scope, the transaction volume, whether POS exports exist for every month, whether the package liability must be rebuilt month by month, whether returns must be amended, and whether an MSO and professional entity must be reconciled. We do not bill cleanup by the hour.

Should I file my 2026 return from the uncleaned file and fix the books later?

Usually not. An extension costs nothing if the estimated tax is paid, while a return built on net deposits will not match the processor's 1099-K, an understated inventory changes cost of goods sold, and an amended return costs more than the cleanup. Run the diagnostic first, then decide whether the return can wait for the rebuild or whether a partial cleanup of the tax-relevant items is enough.

What should I gather before asking for a diagnostic?

Accountant access to QuickBooks Online, the most recent statement for every bank, credit card and merchant account, the POS year-end sales summary and outstanding-balance report, the payroll filings and year-to-date register, the sales tax returns filed, and the prior-year return and depreciation schedule if the practice has one. Nothing is changed in the file during the diagnostic.

Jenny Gao, CPA, EA
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.

Prefer answers about your practice specifically?

A 20-minute fit call gets you further than any article. No obligation — if we’re not the right fit, we’ll say so.

Request a 20-Minute Fit Call →