Why Your Med Spa Practice Management System (PMS) Revenue Does Not Match QuickBooks
If the revenue in your med spa’s practice management system does not match the revenue
in QuickBooks, your first instinct may be to figure out which number is wrong.
Sometimes neither number is wrong. Your practice management system (PMS), bank account, merchant processor, financing platform, and QuickBooks can all be capturing different pieces of the same transactions.
The important question is whether you understand why the numbers are different and whether you can reconcile them.
I see med spa owners spend a surprising amount of time trying to force these systems to match when they were never necessarily designed to produce the same number.
Once you understand what each system is telling you, the differences become much more useful.
Your PMS and QuickBooks have different jobs
There are a lot of software options in the aesthetics industry. Boulevard, Aesthetic Record and Mangomint are common examples, but there are many others and new entrants constantly coming up. It can be hard for business owners to keep up.
One of the questions I see repeatedly in aesthetics groups (Facebook, Reddit thread, you name it) is some variation of:
“What system are you using, and do you like it?”
That is a reasonable question because these platforms are different. They handle scheduling, memberships, packages, payments, reporting, patient records and other workflows differently. They have different reports and user interface (UI).
And that matters for your accounting.
Your PMS is primarily designed to help you operate your practice like scheduling, billing, HIPPA compliance. QuickBooks is your accounting system.
Your payment processor tells you what moved through the processor. Your bank account tells you what cash actually arrived. Your tax return has its own rules for determining taxable income.
Those systems are looking at your business from different angles.
Four revenue numbers that may be different
A growing med spa may have at least four numbers to understand:
PMS sales or production
Cash collected
QuickBooks financial revenue
Taxable revenue
Those numbers can sometimes be close but they don't have to be identical. The goal is to understand the bridge between them. That distinction becomes especially important once your practice offers memberships, prepaid treatment packages, gift cards, patient financing and multiple payment options. All the fund things.
Example of a $2,000 dollar prepaid treatment package
Suppose a patient pays $2,000 today for treatments that will be performed over the next several months. Your PMS would report a $2,000 sale today. Your payment processor may process $2,000, less its fees. Dang those merchant fees right? Your bank account may receive something less than $2,000 after the processor takes its fee. For financial accounting purposes, some or all of that $2,000 may need to sit on the balance sheet as deferred or unearned revenue until the services are actually provided. Your P&L will have a different amount for revenue.
Then there is tax. The tax treatment does not automatically follow the book treatment. You are in for an education.
For federal tax purposes, advance payments are generally included in income when received.
Certain taxpayers using qualifying accounting methods may be able to defer eligible advance payments, generally for no more than one additional tax year. Your particular tax accounting method matters. IRS Publication 538.
For a cash-method taxpayer, income is generally reported when it is actually or constructively received. IRS Publication 17
That means your tax advisor needs to understand how your practice is accounting for these items before assuming that a deferred revenue balance on your books also creates a current tax deferral.
And if a deferral method is available to your business, it can affect the timing of your tax bill. The tax does not disappear. As services are performed and income becomes reportable, that tax timing difference catches up.
This is exactly why simply looking at one “revenue” number can be misleading.
Prepaid packages are only one reason the systems differ
Med spa transactions can become complicated quickly. Here are several common areas I look at when reconciling a PMS to QuickBooks.
Memberships
A monthly membership might include credits, discounted services, banked benefits or other features.
How does your PMS report the membership payment?
How does it track unused credits?
When are those credits redeemed?
How is the transaction recorded in QuickBooks?
Those questions matter because the answer may affect both your revenue reporting and the liabilities sitting on your balance sheet.
Gift cards and account credits
Receiving cash does not always mean you have completed the underlying service. A gift card balance or patient credit may represent an obligation to provide something in the future. If QuickBooks simply records every deposit as current-period revenue, you can lose visibility into that obligation.
Refunds
Refunds may be recorded differently depending on where they are processed. If someone processes a refund through the PMS, your reporting may capture it automatically. If a refund is processed manually through a merchant processor, bank account or another platform, the PMS may never see the transaction. Now you have a difference to reconcile.
Cancellation and no-show fees
Cancellation fees are another deceptively simple item. Some practices configure these fees directly through their PMS. Others charge them manually.
If the transaction happens outside the PMS, your QuickBooks activity may include revenue that never appears in the PMS revenue report you are comparing it against.
Patient financing
Patient financing platforms such as Cherry add another layer. Your PMS may reflect the full treatment amount. The financing company may remit a different net amount after fees. The timing of the payment may also differ from the date of service. Looking only at the bank deposit can make the transaction appear to be something it is not.
Tips
Tips can create another difference depending on how your PMS, payroll and accounting systems handle them. You need to know whether amounts collected as tips are included in a PMS sales report, how they flow through the merchant processor, and how they ultimately get recorded in QuickBooks.
Merchant fees
This is one of the easiest ways to create an accounting problem that will drive everyone crazy. So let's say a patient pays $1,000. Your processor retains $30 and deposits $970 into the bank. If your bookkeeping records the bank deposit as:
Revenue: $970
then you have lost part of the transaction.
The cleaner accounting may need to reflect the gross transaction and the related processing fee
separately:
Revenue: $1,000
Merchant processing expense: $30
Cash deposited: $970
The exact accounting depends on the transaction, but the broader point is important:
Your bank deposit is not necessarily your revenue, that's just cash flow (and yay).
Recording bank deposits as revenue can hide what is actually happening
This is one of the accounting practices I want med spa owners to understand. It is tempting when money hits the bank account. The bookkeeper categorizes it as sales. Done. No, not done.
This approach can work poorly for a med spa.
A single deposit could include activity related to:
services performed
memberships
prepaid packages
gift cards
tips
patient financing
refunds
merchant fees
sales tax
credits or adjustments
Recording the net deposit as revenue strips away the information needed to understand those
components. The books may reconcile to the bank and still give the owner a poor picture of the business.
When your PMS reports $300,000 dollars of revenue
This is where education makes a big difference. I have seen practice owners become frustrated because the PMS says one number and QuickBooks says another.
They start digging and then they run more reports. You can run reports until you are blue in the face. And the PMS is creating new reports all the time. Then they ask their bookkeeper and they spend hours trying to find the mistake. Sometimes there is a mistake but oftentimes it's not. The real problem is the assumption that the numbers are supposed to match. Once an owner understands what each system measures, that conversation changes.
Instead of asking:
“Why is QuickBooks wrong?” we can ask: “What explains the difference?”
That is a much more useful financial question and will save the business owner much more time.
This is why we built our own med spa reconciliation process
At Meliora, we developed our own med spa reconciliation process and tool to help bridge PMS activity to QuickBooks.
The objective is straightforward: show the owner what is sitting inside the difference.
For a selected period, we can bring together information such as:
PMS sales
prepaid package activity
memberships
gift cards and credits
refunds
cancellations or no-show fees
patient financing
merchant activity
deposits
other relevant adjustments
revenue recorded in QuickBooks
The dashboard then compares the PMS information with the amount recorded in QuickBooks and shows the difference at a high level.
More importantly, we explain why the difference exists.
The goal is not to manufacture a zero at the bottom of a reconciliation.
The goal is to give the business owner confidence that we understand the difference.
Better reconciliations create better KPIs
This is where I think this work becomes especially valuable.
Med spa owners make decisions from metrics.
Should I hire another injector?
Should we invest in another device?
Are memberships growing?
Which services are actually profitable?
Can I afford another location?
How much cash can I safely distribute?
Is revenue really growing?
Those decisions depend on the quality of the financial information behind them.
If PMS “revenue” includes $100,000 of prepaid treatments that have not been performed yet, you need to understand that before using the number to evaluate current performance.
If QuickBooks only contains net bank deposits, you also need to understand what has disappeared from the accounting.
If you are comparing inconsistent numbers month after month, your KPI dashboard can look sophisticated while still pointing you in the wrong direction.
Reliable books give you a much better foundation for reliable KPIs.
Deferred revenue matters for cash flow too
There is also a very practical business-owner reason to understand prepaid revenue.
That matters when deciding how much cash is really available to spend.
Imagine selling a large volume of annual memberships or packages in November and December.
The bank balance looks great.
You may have significant treatment obligations that your providers still have to perform over the following months.
That future work has a cost.
You may need labor.
You may need injectables or supplies.
You may have room utilization and scheduling demands associated with fulfilling those services.
And depending on your tax accounting method, the timing of the associated taxable income may create another consideration.
Understanding your deferred or unearned revenue helps keep a strong bank balance from creating a false sense of how much cash is truly available to distribute or reinvest.
Good bookkeeping makes better business decisions possible
This connects to something I tell business owners frequently.
Bookkeeping is worth the cost.
For a growing med spa, bookkeeping should give you more than a reconciled bank account.
It should create financial information you can actually use.
Once we trust the underlying accounting, we can do higher-value work around:
KPI reporting
service-line profitability
provider performance
cash-flow planning
hiring
expansion
owner compensation
tax planning
estimated taxes
equipment purchases
retirement planning
You cannot do that work confidently if the starting question every month is, “Do we trust this revenue number?”
Your PMS does not need to become QuickBooks
I would much rather see a practice owner understand what each system does well.
Your PMS contains incredibly valuable operational information.
QuickBooks gives us the accounting picture.
Your merchant processor explains cash movement.
Your bank confirms what actually arrived.
Your tax return applies another set of accounting rules.
When those systems are properly reconciled, they tell a much richer story together.
For a growing med spa, that story can help you make better decisions about where the business is going next.
Is your PMS revenue different from QuickBooks
If you have been trying to figure out why your PMS reports one revenue number while
QuickBooks reports another, the difference may be telling you something useful.
Meliora Consulting helps growing med spas connect their operations, accounting and tax picture so owners can understand what their numbers are really telling them.
Our med spa reconciliation process helps bridge the activity in your practice management system to the revenue in QuickBooks and explain the differences in a way that is easy to understand.
You can also download our Med Spa Guide for additional financial and tax considerations for growing aesthetic practices.
This article is for general educational purposes and is not tax or accounting advice for a specific business. The appropriate accounting and tax treatment depends on your facts, accounting method and applicable tax rules.
Comments