Bank Statement to QuickBooks for Med Spas: Convert PDF Statements to QBO

When a member pays a monthly draft, you have collected cash for services or product they have not redeemed yet. That money is a deferred revenue liability, not income the day it hits the bank. You recognize it as revenue when the member actually redeems the benefit, or on whatever recognition schedule your CPA sets. Booking the draft straight to income overstates earnings in the month you collect and leaves nothing to cover the visit later.

The PDF to QBO converter at the top of this page brings every membership draft into QuickBooks with its real date and amount. From there you split it to the deferred revenue account and move it to income as it is earned. See our note on recognizing membership and package revenue for the mechanics.

A package of six laser sessions or a prepaid Botox membership bank works the same way as a membership. The client pays up front for treatments you owe over time, so the whole payment is deferred revenue on day one. You recognize a portion as income each time a session is delivered, drawing the liability down as the client works through the series.

This is the single most mishandled med spa item. Recording the full package price as revenue when it sells inflates that month, understates the months when treatments are actually performed, and can throw off sales tax on any product bundled inside. Track the redemption count so the deferred balance always reflects sessions still owed.

Your processor does not deposit each cosmetic service as it is charged. It batches a day or a few days of sales and sends one payout, and that payout lands net of merchant processing fees. To record it honestly you split the net deposit into its parts: gross service and retail sales as income, the processor fee as a merchant fee expense, sales tax collected on retail product as a sales tax payable liability, and any card tips as a tips payable liability.

Services are often not sales-taxed while retail skincare product usually is, but this is state-specific, so confirm how your state treats cosmetic services and product with your CPA. If you book the lump payout as revenue and skip the split, your income runs low, your fee expense disappears, and your sales tax math drifts out of line.

A serum or a bottle of cleanser you resell is not service revenue. It is inventory that carries its own income account, its own cost of goods sold, and usually sales tax. Keeping retail apart from treatment revenue matters for margin, since product and service earn very differently, and for tax, because your sales tax return keys off taxable product sales that you cannot file accurately if they are buried in service income.

Botox and Dysport vials, dermal filler syringes, and laser consumables are inventory, not an expense the day you buy them. When you purchase from a distributor such as Allergan or Galderma or a specialty pharmacy, the cost hits an inventory asset account. It becomes cost of goods sold as the product is used on patients. Tracking units, vials and syringes, keeps your on-hand value real and shows true treatment margin.

Multi-location spas and bookkeepers handling several clients can run every location's supply statements at once through bulk statement conversion instead of keying them in one at a time.

When a patient pays with CareCredit, Cherry, or Alle and Allergan financing, the financing company keeps a fee and deposits the rest. Treat it like a merchant fee: record the gross service revenue the patient owed, then record the financing company's fee as an expense, so the net matches the deposit on your bank statement. Booking only the net deposit understates both your revenue and your financing costs.

Selling a gift card is not income. You have taken cash for a service or product the buyer has not used yet, so the sale is a deferred revenue liability. You recognize revenue when the card is redeemed against a treatment or product, then clear the liability. Unredeemed balances stay on the books until they are used or handled under your state's escheatment rules.

Injectors and providers may be W-2 employees or 1099 contractors, and a supervising medical director is often paid as a 1099 contractor. Track contractor pay in a contract labor or professional fees account so it is easy to total at year end. The 1099-NEC reporting threshold is 2,000 dollars for payments made on or after January 1, 2026, indexed after that, up from the old 600 dollar figure. Confirm current requirements with your CPA, since worker classification carries its own rules.

Lasers and treatment devices are capitalized fixed assets that you depreciate over their useful life, not an expense in the month you buy them. When you make a monthly equipment loan payment, it splits into two parts: principal, which reduces the loan liability, and interest, which is an expense. Do not book the whole payment as one expense, or you will overstate costs and never pay the loan balance down in your books.

How do I record med spa membership revenue in QuickBooks?

Record the monthly draft as a deferred revenue liability, not income, because the member has not redeemed the benefit yet. Move it to service income as it is earned, either when the member redeems or on the recognition schedule your CPA sets. Booking the draft straight to income overstates earnings in the month you collect it.

How do I account for prepaid treatment packages in QuickBooks?

Record the full package price as deferred revenue when it sells, since you owe the client treatments over time. Recognize a portion as income each time a session is delivered, drawing the liability down as the series is used. Track the redemption count so the deferred balance always matches sessions still owed.

How do I record Botox and filler inventory in QuickBooks?

Record vials and syringes as inventory when you buy them from a distributor, not as an expense. The cost moves to cost of goods sold as product is used on patients. Track units on hand so your inventory value stays real and each treatment shows its true margin. Confirm your method with your CPA.

How do I record CareCredit payments in QuickBooks?

Record the gross service revenue the patient owed, then post the financing company's fee as an expense, so the net matches the deposit on your bank statement. Treat CareCredit, Cherry, and Alle financing like a merchant fee. Booking only the net deposit hides both your real revenue and your financing costs.

Are med spa services subject to sales tax?

It depends on your state. Many states do not tax cosmetic or medical services but do tax retail skincare product you resell, so the two often need different treatment on the same receipt. Because rules vary widely and change, confirm how your state taxes services and product with your CPA before you file.

How do I import a bank statement into QuickBooks?

Convert the PDF or image statement to a .qbo file with the converter at the top of this page, then import it. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file, and map the columns before you categorize.