How to track profitability by provider or location in a medical or dental practice

The cleanest way to see which providers and which locations actually make money is not to divide total profit across doctors. It is to build two dimensions, provider and location, into the books and calculate profitability in four layers, starting from net collections rather than billed charges. Start from charges and a provider who is not getting paid will look like a star. This page lays out the four layers, the one rule that makes the whole thing honest, how to allocate shared costs without cheating, and the matrix that puts it all on one view.

The one rule: start with net collections, not billed charges

Before any layers, fix the denominator. Gross charges are what a practice billed, not what it earned. Because contractual adjustments write those charges down to each payer's contracted rate, two providers with identical production can have very different real revenue depending on their payer mix. So the number that drives every profitability calculation on this page is net collectible revenue, gross charges minus contractual adjustments, not the charges themselves.

This is also why it depends on getting the bookkeeping right upstream. If contractual adjustments are booked as an expense or ignored, net collectible revenue is wrong, and every provider and location number built on it is wrong too. We cover that treatment in detail in our guide on recording insurance reimbursements and contractual adjustments. Get that right, and the four layers below become straightforward.

The four layers

Work up from the most direct measure to the most complete one. Each layer answers a different question, and stopping at the wrong one is how practices misjudge a provider or a site.

Layer	How it is built	What it answers
1. Attributable net revenue	Per provider and location: gross production, contractual adjustments, net collections, visits, service lines and payer mix. Medical revenue ties to the rendering provider; dental practice-management systems usually already hold production and collections by provider.	What did this provider or location actually earn?
2. Provider contribution	Net revenue minus direct provider costs: provider compensation, clinical labor, supplies and lab costs, and other direct clinical costs. Nothing broader is allocated yet.	What does this provider's clinical activity contribute before overhead?
3. Location contribution	Revenue minus direct clinical costs, then minus costs that belong to that site: rent, utilities, front-desk staff, office manager, local marketing, and location-specific software.	Does this office make money as an operating unit?
4. Fully loaded profit	Contribution minus an allocated share of corporate and shared overhead, spread using documented drivers rather than dumped on one site.	After carrying its fair share of the whole organization, how much does this activity really make?

The distinction between the layers is the whole point. A provider can post excellent contribution but work in an expensive location, and a location can look strong at the contribution line yet consume a great deal of central resource once overhead is loaded. So what for you: read all four layers before you conclude anything about a provider or a site.

The production problem versus the collections problem

Here is what starting from net collections buys you, and why it matters more than any other single choice on this page. When a provider's contribution looks weak, there are two completely different causes that look identical on gross production.

The problem	What it looks like, and where to fix it
A production problem	The provider is not doing enough clinical work, or is doing low-value work. Both production and collections are low. The fix is scheduling, case mix, or capacity.
A collections problem	The work is being done but the practice is not being paid for it. Production is strong, collections are weak, the net collection rate is low. The fix is in the billing cycle: denials, underpayments and patient collection, not the provider.

If you profile providers on gross charges, these two look the same, and practices routinely blame a producing provider for a billing failure. Because the layers above start from net collectible revenue, the collections problem shows up as a gap between strong production and weak net revenue, and you can send it to the revenue cycle instead of the provider.

Allocating shared costs without cheating

Layer four is where practices go wrong, usually by dumping all central costs onto one location or splitting them evenly. Instead, put corporate and shared costs in their own bucket and allocate each with a documented driver that reflects how it is actually used. Direct costs like rent and supplies should never sit in the shared bucket at all.

Cost	A sensible allocation driver
Corporate administration	Revenue, or full-time-equivalent headcount
Central billing	Claims or collections handled
Human resources	Headcount
Marketing	Revenue, leads, or campaign attribution
Practice-management or accounting software	Number of providers or users
Rent, clinical staff, supplies, lab	Not shared: assign directly to the location or provider

Tag the ledger so all of this comes from one place

None of this requires separate spreadsheets. The practical way to produce provider, location, service-line and payer profitability from the same books is dimensional tagging: every transaction carries a small set of tags. In effect, each entry answers several questions at once.

Account × Location × Provider × Service line × PayerExample: dental supplies × Location 2 × Dr. Smith × implant × Blue Cross

In QuickBooks Online this maps directly onto classes and locations, which is why the setup guide on configuring QuickBooks for a medical practice puts class and location tracking near the top. Tag consistently and the four layers become reports you run, not spreadsheets you rebuild every month.

The one view to build: a provider-by-location matrix

For a multi-provider, multi-location group, the single most useful output is a contribution matrix, providers down the side, locations across the top, contribution in the cells. It shows at a glance who produces where, and which combinations carry the group.

Contribution (dollars)	Location A	Location B	Location C	Total
Dr. Smith	45,000	32,000	–	77,000
Dr. Jones	38,000	–	51,000	89,000
Hygiene / ancillary	22,000	18,000	25,000	65,000

Beside the matrix, a handful of KPIs sharpen the read: net collections, collections per clinical hour, revenue per visit, contribution percentage, provider compensation as a percentage of revenue, and payer mix. The guiding discipline throughout is the same, do not start by allocating every expense to every doctor. Establish direct contribution first, then location profitability, and only then fully loaded profitability with transparent allocations.

Where Numetix fits

This is reporting work that stands on clean, dimensionally tagged books, which is exactly what Numetix maintains. Numetix tags the ledger by provider, location, service line and payer, records contractual adjustments correctly so net collectible revenue is real, and produces the layered provider and location profitability, including the matrix, as part of the monthly close rather than a special project. If you would rather run these reports than build them, that is the work Numetix does. It sits alongside the monthly review a practice owner runs.

Frequently asked questions

Should profitability be based on charges or collections?

Collections, specifically net collectible revenue. Gross charges are what was billed, not what was earned, and contractual adjustments make two providers with identical production earn very different amounts. Profiling on charges makes a collections problem look like strong performance, which is exactly the mistake the layered method is designed to avoid.

How do you allocate shared costs across locations?

Put them in a separate corporate or shared bucket and allocate each with a documented driver that reflects real usage, revenue or headcount for administration, claims for billing, users for software. Direct costs like rent and supplies are assigned straight to the location or provider and never enter the shared bucket. The point is that the driver is written down and applied consistently.

Can QuickBooks Online do provider and location profitability?

Yes, using class and location tracking on the Plus or Advanced plans. A class per provider and a location per site let you tag each transaction and then run profitability reports by either dimension without maintaining separate spreadsheets. The reports are only as good as the tagging discipline and the underlying bookkeeping, so both have to be in place.

Why not just split total profit evenly across providers?

Because it tells you nothing and it is unfair. Providers differ in production, payer mix, direct costs and the location they work in, so an even split hides the very differences you are trying to see. The layered method exists precisely so that each provider and location is measured on what it actually contributes, not on an average.

The matrix figures are an illustrative example, not any specific practice's numbers. Allocation methods and the right level of detail depend on your practice's size and structure. This article is general information, not accounting, tax, or legal advice.