Money Matters

Dental group profitability reporting by location and provider

Multi-location dental groups running on blended P&Ls are flying blind. See how reporting by location, provider & payer turns month-end data into decisions.

Published September 16, 20268 min read Share

Dental group margins have compressed, wages for hygienists and assistants rose 10-20% between 2022 and 2024, and equipment and supply costs are climbing 5-10% annually against insurance reimbursement rates that have been essentially flat for a decade. In that environment, a blended P&L is not a management tool. It is a liability.

This post walks through why the visibility gap has become acute for independent multi-location groups, why the legacy accounting stack cannot close it, and what dimensional reporting by location, provider, payer and service line actually makes possible.

Key takeaways

• Dental group margins are under sustained pressure from rising labor and supply costs against flat reimbursement – making per-location and per-provider margin data a strategic necessity for any group trying to hold its position.
• 22% of dentists dropped some or all of their insurance networks during 2025, and 35% say they are likely to drop certain networks in 2026 (ADA Health Policy Institute), but that decision only pays off when finance can prove which carriers are unprofitable at the payer, provider and service-line level.
• The legacy stack of a single-entity general ledger, spreadsheet consolidation and practice-management systems like Dentrix, Eaglesoft or Open Dental typically produces 10-15-day closes and consumes 40-50 hours a month on manual consolidation – time that cannot be spent on analysis.
• Dimensional reporting tags one general ledger by location, provider, payer and service line, so any P&L cut is a filter, not a spreadsheet rebuild, enabling weekly decisions on payer strategy, provider compensation and site-level capital allocation.
• Village Family Dental cut departmental reporting from 10 days to 10 minutes, shortened its close by 70%, increased revenue by as much as $40,000 per month by expanding pediatrics and OR cases while reducing certain insurance carriers, and lifted provider profitability by 6% and gross margin by 7%.

Here’s what we’ll cover

Why the visibility gap has become acute now

The cost structure of a multi-location dental group has shifted materially. Wages for hygienists and dental assistants increased 10-20% between 2022 and 2024. Equipment and supply costs are rising 5-10% annually. Insurance reimbursement, meanwhile, has been largely flat for a decade.

Top-quartile multi-location groups reach 17-20% margins through scale efficiencies, but that gap between median and top-quartile performance does not close by accident. It closes when finance leaders can see exactly where margin is being made and lost: by location, by provider, by payer and by service line.

The payer question is now urgent. 22% of dentists dropped some or all of their insurance networks during 2025, and 35% say they are likely to drop certain networks in 2026 (ADA Health Policy Institute). Exiting a carrier network is a significant operational decision: it affects patient volume, provider scheduling and collections. Getting it wrong is expensive. Getting it right – dropping the carriers that are genuinely unprofitable at the service-line and provider level – can add meaningful revenue. That decision requires data a blended P&L cannot supply, and the cost of guessing wrong is measured in patient volume and collections.

What the legacy stack cannot show you

Most independent groups in the 3-25 site range are running their finances on a combination of a general ledger built for single-entity accounting, spreadsheets for consolidation and reporting, and a practice-management system such as Dentrix, Eaglesoft or Open Dental for production and collections data. Each of those tools does something useful. Together, they create a reporting problem.

The practice-management system holds clinical and billing data. The general ledger holds costs. The spreadsheet is the bridge, and the bottleneck. Consolidating multiple entities, allocating shared costs across locations, and reconciling production data with actual collections requires manual work that typically consumes 40-50 hours a month and still produces a close that takes 10-15 days. By the time the numbers are ready, the decisions they should inform are already two weeks old.

A general ledger that is not dimensionally tagged cannot answer the questions that matter most to your CFO:

• Which of my locations is generating the strongest EBITDA per chair?
• Which providers are profitable after accounting for their full cost of delivery – fees, assistants, equipment time?
• Which payer contracts are margin-positive at the service-line level, and which are subsidized by higher-margin work?
• Where should I invest in de novo growth, and which sites should I consider divesting?

Without that visibility, decisions default to intuition or blended averages. When a single underperforming site or carrier contract can move the group’s overall margin by a full percentage point, neither is a reliable guide.

What dimensional reporting actually means in a dental context

Dimensional reporting starts in the general ledger itself: every transaction is tagged at the point of entry with the dimensions that matter to your business: location, provider, payer and service line. There is no separate reporting layer sitting on top; the structure is built into how costs and revenue are recorded.

Once those tags are in place, any P&L view is a filter, not a rebuild. You can pull a margin report for your hygiene service line across all locations, then narrow it to a single carrier, then narrow further to a specific provider – without touching a spreadsheet. The same underlying data supports your consolidated group financials, your location-level EBITDA, and your provider-level production-to-cost analysis.

For a multi-location dental group, the practical dimensions typically include:

• Location: site-level revenue, cost and margin, supporting expansion and divestiture decisions
• Provider: production, collections and profitability per provider, informing compensation design and scheduling
• Payer: net revenue by carrier after adjustments, enabling evidence-based network decisions
• Service line: margin by procedure category – hygiene, ortho, implants, oral surgery – to guide capacity and mix decisions

Integration with practice-management systems like Dentrix, Eaglesoft or Open Dental brings production and collections data into the same dimensional structure, so finance and operations are working from one version of the numbers.

What finance leaders do with that view

Village Family Dental is a multispecialty group that expanded from a single office to multiple locations and ambulatory surgery centers. Before moving to a dimensional financial platform, the finance team had no way to see which offices, service lines or individual providers were genuinely profitable. One specialist was generating high revenue but, because of the associated costs of fees, assistants and equipment, was actually the lowest-profit provider in the group – invisible in the previous system.

After moving to Sage Intacct, Village Family Dental cut departmental reporting that used to take 10 days to 10 minutes, and shortened its monthly close by 70% (Sage Intacct Village Family Dental case study). That shift changed what finance could do. Weekly provider and service-line visibility supported the decision to expand pediatrics and OR cases while reducing certain insurance carriers, which increased revenue by as much as $40,000 per month. Provider profitability in one service area increased by 6%. Gross margin across the group rose by 7%.

The same visibility supported growth from three locations to 14 with only one addition to the finance team, a 25% overall efficiency improvement, and $350,000 in staffing costs avoided.

Chief Operating Officer Virginia Jones, Ph.D. has described the platform as giving the team constant visibility into profits per case, per hour and per chair, and enabling creative billing approaches that drive revenue and margin improvement.

That visibility applies across the decisions that define a multi-location group’s trajectory:

• Payer strategy: exit low-margin networks based on carrier-level margin data, not estimates
• Provider compensation: tie incentives to per-provider profitability, accounting for the full cost of delivery
• Service-line mix: expand high-margin services like pediatrics or implants where capacity exists
• Capital allocation: direct de novo investment and acquisition activity toward the site profiles that actually perform

Frequently asked questions

What is dental group profitability reporting by location and provider?

It is a financial reporting approach in which every transaction in the general ledger is tagged by location, provider, payer and service line, so finance leaders can generate a P&L for any combination of those dimensions without manual consolidation. It replaces blended group-level reports with granular margin data that supports operational and strategic decisions.

Why can’t spreadsheets and a single-entity general ledger handle multi-location dental group reporting?

A single-entity general ledger and spreadsheet consolidation were not designed for multi-entity, multi-dimensional reporting. Consolidating several locations, allocating shared costs and reconciling practice-management data manually typically consumes 40-50 hours a month and produces closes that take 10-15 days – too slow and too aggregated for weekly payer, provider or site-level decisions.

How do dental groups use provider-level profitability data to make decisions?

Provider-level data lets finance leaders see net margin per provider after accounting for all associated costs – fees, assistant time, equipment and supplies. That view informs compensation design, scheduling, and decisions about which service lines to expand or contract. Village Family Dental used this analysis to identify and address a high-revenue but low-profit specialist, contributing to a 6% profitability improvement in that service area.

How does payer-level reporting help dental groups decide which insurance networks to drop?

Payer-level reporting shows net collections by carrier after adjustments, broken down by service line and provider. That granularity reveals which contracts are margin-positive and which are subsidized by other work. 35% of dentists say they are likely to drop certain networks in 2026 (ADA Health Policy Institute); dimensional reporting gives finance the evidence to act on that instinct rather than guess.

What results can a multi-location dental group expect from dimensional financial reporting?

Results vary by group, but Village Family Dental’s experience illustrates the range: departmental reporting that took 10 days now takes 10 minutes, a 70% shorter close cycle, revenue up by as much as $40,000 per month from expanding pediatrics and OR cases while reducing certain carriers, a 6% provider profitability gain and a 7% gross margin improvement.

If your board is asking questions about payer mix, per-provider economics or site-level EBITDA that your current reports cannot answer, see how Sage Intacct supports multi-location dental groups – request a demo tailored to your group’s structure, or read the Village Family Dental case study to see the outcomes in detail.

Browse more topics from this article

• Business intelligence
• CFO
• Cloud financial management