Guide · Payer mix analysis
How to calculate payer mix for a treatment center, by days and by dollars.
Payer mix is each plan's share of your work, or of your money. Most guides calculate it once. Calculate it twice, by days and by dollars, and the gap shows which plans fill the program and which ones pay for it.
This is the method behind our revenue intelligence work. Every number on this page is invented, and no client result is claimed.
The payer mix formula, used twice.
The payer mix calculation is one division. What changes the answer is the thing you count.
one plan's program days ÷ all program days × 100
one plan's payments ÷ all payments × 100
share of dollars − share of days, in points
- Count days, not clients
- A client who attends five days a week and one who attends twice are not the same amount of work. Program days, by level of care, are the unit that matches how treatment centers bill.
- One period for both
- Days and dollars must cover the same weeks. Payments arrive later than services, so the most recent weeks are provisional.
- Plans, not payer types
- "Commercial" hides plans that pay very differently. Group plan names under one spelling first, then calculate per plan.
A payer mix analysis example.
One center, one month, four plan groups. One hundred program days and $100,000 paid, so the arithmetic is easy to follow.
| Plan | Program days | Share of days | Paid | Share of dollars | Gap | Reading |
|---|---|---|---|---|---|---|
| Plan group A | 34 | 34% | $22,000 | 22% | −12 pts | More days than dollars |
| Plan group B | 27 | 27% | $38,000 | 38% | +11 pts | More dollars than days |
| Plan group C | 22 | 22% | $26,000 | 26% | +4 pts | More dollars than days |
| All other | 17 | 17% | $14,000 | 14% | −3 pts | More days than dollars |
| Total | 100 | 100% | $100,000 | 100% |
By days alone, plan group A looks like the center's main payer. By dollars alone, it looks minor. Neither view is wrong. The gap is the finding: it fills a third of the days and brings about a fifth of the money.
Billed, allowed and paid are three different numbers.
The dollar side of a payer mix depends on which dollars you use. Keep the three apart.
- Billed
- Your own price list. A mix built on charges mostly repeats the day count, so it hides the gap.
- Allowed
- What the plan's contract or policy recognizes. The difference from billed is not a loss; it was never owed.
- Paid
- What the plan sent. Use this for the dollar share. The patient's portion is tracked separately.
If you only have the billing company's expected amounts, you can still calculate a mix. Label it as expected, and replace it with paid when payment files arrive.
Payer mix calculator.
Type your own totals over the sample. It runs in your browser and sends nothing. Enter totals by plan only, never anything about a client.
Read the gap carefully.
- Compare centers over the same weeks. A center with a missing week looks smaller than it is. Show missing weeks as missing.
- Split by level of care. A day of one program is not paid like a day of another. A mix shift can be a program shift.
- The plan in the EMR is not always the plan billed. Some plans are correctly billed through a different plan name. Confirm the crosswalk with your billing company before calling it an error.
- Hide small groups. A plan with a handful of clients is noise, and a privacy risk on a leadership view.
- Paid is not profit. Collected revenue says nothing about what the care cost to provide.
- It describes contracts, not people. Payer mix is for contracting, planning and follow-up with payers. Admission and clinical decisions belong to clinicians, and decisions based on a person's plan carry legal limits. This is not legal advice.
What payer mix does not tell you.
A mix shows who fills the program and who pays for it. It does not show which plans deny, which pay late, or which attended days never became a charge. Those need a payer scorecard and a line-by-line comparison of attendance and charges.
Both are part of revenue intelligence, with a sample scorecard. The line-by-line checks are in the five billing census checks, and the leadership view follows the rules for multi-location dashboards.
- In buildA first-month view on this method, using days and the billing company's expected amounts. A first draft exists for one five-center network and is not yet in weekly use.
- DesignedThe payer scorecard on paid amounts. It needs claim-level payment and denial files.
Not claimed: a benchmark, an underpayment finding or a measured result for any client.
What operators ask about payer mix.
What is payer mix in healthcare?
Payer mix is each payer's share of a provider's work or revenue: commercial plans, Medicaid, Medicare and self-pay. It can be counted by volume (days, visits or clients) or by dollars. The two answers are usually different.
How do you calculate payer mix?
Divide one payer's amount by the total for all payers and multiply by 100. Do it once with days of service and once with payments, over the same period. The difference between the two shares is the gap.
Is it payer mix or payor mix?
Both spellings mean the same thing. "Payer" is more common in general use; "payor" appears in contracts and some finance teams. Use the one your billing company uses.
What is a good payer mix?
We do not publish a benchmark. It depends on your contracts, levels of care, market and costs. The useful comparison is your own mix over time, and one center against another over the same weeks.
Should payer mix use charges, allowed amounts or payments?
Payments, when you have them. Charges are your own price list, so a mix built on charges mostly repeats the day count. If you only have the billing company's expected amounts, use those and label the result as expected, not paid.
Can we do a payer mix analysis in Excel?
Yes. One row per plan, one column for days and one for payments, each divided by its column total. The calculator on this page does the same arithmetic in your browser.
Do you know which plans fill your program, and which ones pay for it?
Bring last month's totals to a free 20-minute call. We will show you what your current reports can and cannot answer.