Every month you should be pulling revenue by provider, revenue per hour, rebooking rate, discounts as a percentage of revenue, and product consumed per treatment. Your P&L tells you what the practice earned. Your EMR tells you where it came from and who produced it. Neither report answers the important questions on its own. At Liguori Accounting, we work exclusively with medical aesthetic practices, which means we already know the systems our clients run on and which reports actually matter.
Why isn’t the P&L enough?
Because a P&L reports one blended number at the bottom, and a med spa is really several small businesses sharing a roof.
Injectables, energy based devices, skincare retail, memberships, and weight loss all behave differently on cost, pricing, and margin. When they get blended into a single bottom line, a strong performer covers for a weak one and you never see it. We covered the accounting side of this in how to measure med spa profitability by provider, treatment, payroll, and product margin.
Your EMR holds the detail that makes the P&L legible. The problem is that most owners have the data and never pull it, or pull it and have no financial context to interpret it against.
Which EMR reports should you pull every month?
Revenue by provider. The starting point for any productivity conversation. You cannot evaluate compensation without it.
Revenue per hour, per provider. Total revenue rewards whoever works the most hours. Revenue per hour tells you who is actually productive. A part-time injector can easily outperform a full-time one on this metric.
Rebooking rate. The percentage of patients who leave with their next appointment on the calendar. Industry averages sit well below what they should be, and this is one of the highest-leverage numbers in the practice because it costs nothing to improve.
Discounts as a percentage of revenue. The quietest margin leak in aesthetics. It rarely shows up as a line item on the P&L, so it hides until someone goes looking.
Product consumed per treatment. Units of neurotoxin or syringes of filler per service, by provider. Variance here is either a training issue or an inventory issue, and both cost real money.
Membership and package liability. What has been sold versus what has been delivered. This should tie back to the deferred revenue balance on your balance sheet.
What should a provider actually be producing?
The working benchmark we use is that a provider should generate roughly three to five times their total compensation cost. Total cost means salary or commission plus payroll taxes plus benefits, not just what shows up on their paycheck.
Top performers can run higher than that. Someone consistently below three times is not necessarily a bad provider, but the arrangement needs a look. It may be a scheduling problem, a service mix problem, or a compensation structure that no longer matches what they produce.
“Often profitability is misleading when you only look at the bottom line. When we get into provider-level metrics, that is usually where something jumps out.” Nick Liguori, CPA
How does EMR data connect to your books?
It only works if the chart of accounts is built to receive it. If all service revenue lands in one income account, no amount of EMR reporting will reconcile to your financials, because there is nothing on the accounting side to reconcile against.
The fix is a chart of accounts that mirrors your service lines, with cost of goods sold mapped to those same categories. We laid out that structure in our post on what to track every month and how to structure your chart of accounts.
Once both sides are aligned, EMR data stops being a separate report you glance at and becomes the explanation for what your financials are showing you.
Why does it matter whether your accountant knows your EMR?
Because a generalist has to ask you to pull the reports, and they will not know which ones to ask for.
“Something that sets us apart is the fact that we do know the EMR systems, and we know which reports to pull and where the common setup mistakes are, versus someone who is industry agnostic.” Nick Liguori, CPA
We work with whatever system a practice already has. The systems differ in how they name things and where they bury the reports, and a fair number of the reporting problems we find are setup issues from day one, like services categorized in a way that makes margin analysis impossible or discounts applied in a field that never reaches the revenue report.
That is not something an owner should have to discover on their own two years in.
Frequently asked questions
Do I need to switch EMR systems to get better reporting?
Almost never. Most practices we work with have far more reporting capability than they are using, and the issue is setup and configuration rather than the platform. Before you consider a migration, have someone look at how services, categories, and discounts are configured in what you already own.
How often should I actually be looking at this?
Monthly for the full set, and weekly for two or three numbers that drive decisions. Pulling everything every week creates noise. Pulling nothing until year end means you find out about a problem eleven months late.
My provider looks profitable on paper but I still feel broke. What’s going on?
Profit and cash are different things, and the gap usually comes from inventory, deferred revenue, or loan principal. We walk through it in why your med spa’s P&L isn’t telling you the whole story.
What do I do if a provider is below the three times benchmark?
Look at the inputs before the person. Check their utilization, their service mix, and their rebooking rate. A provider stuck doing low-margin services in an underfilled schedule will miss the benchmark regardless of skill.
Can you work with the system I already have?
Yes. We work with whatever platform a practice runs on, and part of onboarding is getting the right reports flowing so your financials and your EMR are telling the same story.
Book a discovery call and we will look at your EMR reporting and your books together.
