Dental Payer Mix: Count People and Coverage Separately

What does payer mix count?

Payer mix groups a practice's activity or patients by a stated payer-related rule. A patient-count view must distinguish people from coverage memberships. One person may appear under more than one carrier, so adding carrier counts does not necessarily give the number of distinct people in the file.

Open Dental documents primary and secondary insurance and supports additional plans. Secondary insurance documentation. This establishes why a coverage list can need more than one plan field; it does not establish payment terms for a particular patient.

Dentrix Ascend's patient-insurance report lists carriers and patients covered by their plans. Its documentation identifies a data-sync cutoff. Patient-insurance report. Preserve the cutoff when comparing that export with another patient file.

This reference addresses overlap between patient groups. The payer-mix acquisition guide covers the separate money and network questions. A person-count chart cannot tell you who supplied each receipt or which fees would apply after a sale.

Build exclusive groups before making a whole-practice chart

Consider an invented file of 200 distinct people at one fixed cutoff. The supplied review has already resolved duplicate identities and verified the plan fields used here. Carrier A appears for 130 people and carrier B for 100. Fifty people have both. A and B are anonymous teaching labels, not real plans or network categories.

The question is how many people have either named carrier and how the overlap should appear in a chart. The file makes no assumptions about services, payments or whether a plan will cover a proposed treatment. People in the neither group may have other coverage; the label means only neither A nor B.

The count with either named carrier is 130 + 100 − 50 = 180. Subtract the overlap once because it entered both carrier totals. That gives 90% of the full file. The four exclusive groups add back to 200 without removing anyone from the denominator.

Separate carrier-presence rates are also valid: A appears for 65% and B for 50%. They total 115% because they answer overlapping questions. Present them as overlapping presence rates, not slices of a pie that claims to divide all people into separate groups.

A primary-plan view needs another field. Suppose the 50 people with both have A listed as primary for 30 and B for 20. Primary A then covers 80 + 30 = 110 people; primary B covers 50 + 20 = 70. Another 20 have neither named carrier. This allocation cannot be inferred from the carrier totals alone.

Test overlap and new membership independently

First, keep the file at 200 people and hold A's count at 130 and B's at 100. Change only their overlap to 70. A-only becomes 60 and B-only becomes 30. Either-carrier count is 160, or 80%; neither becomes 40. More overlap reduces unique reach even though both headline carrier counts stay unchanged.

For a separate test, restore the original 50-person overlap. Assume 15 of the original 20 people with neither named carrier acquire A coverage by a new cutoff, with no other changes. A becomes 145, B stays 100 and the overlap stays 50. Either-carrier count becomes 195, or 97.5%, while neither falls to five.

The second test changes the supplied coverage snapshot. It does not add new patients to the practice or predict appointments. Keep the two cutoffs visible. Do not combine this new membership with the first test's larger overlap unless both changes actually occurred.

Keep the person-count result within its limits

For a real report, record which people enter the population, how plan dates are handled and how identifiers are matched. Use controlled person keys approved for the review. Replacing names alone does not establish de-identification, and a public comparison should use aggregate results rather than account detail.

Check unexpected duplicates and blank plan fields before forcing them into a category. Keep unresolved records visible with an owner and a next request. A blank field does not prove that someone lacks insurance, and a listed plan does not itself prove that the service under review will be paid.

Begin sale outreach with a seller-blind description that omits the owner, practice identity, exact location and identifying financial or staff details. Obtain an NDA before authorized identifying disclosure. Agree when staff must explain enrollment records and who will brief the wider team. Patient-data access follows its own approved process.

Use the buyer due-diligence guide, production and collections guide, financing guide and DSO overview for the separate transaction questions.

Summary

Payer mix needs an explicit counting unit and overlap rule. The invented file has 230 carrier memberships but only 180 people with either named carrier. Exclusive groups explain the difference without making a revenue or coverage promise. Discuss the reporting scope before using the chart in a transaction.