Two urgent care centers can see the same number of patients and earn very different money — the difference is payer mix. Commercial visits pay the most, government plans pay less, and self-pay carries the most collection risk. This dashboard makes mix visible: the share of visits in each payer category, how net revenue per visit varies across them, and how the mix is shifting month over month so you catch erosion before it shows up in the bank.
What this dashboard answers
The mix snapshot answers where your visits sit: self-pay share, commercial share, and government share, plus the payer breakdown by center so you can see which sites carry the risk. The mix-versus-revenue page connects mix to money: net revenue by payer, net revenue per visit by payer, and a monthly line tracking commercial share against self-pay share — the single chart that flags mix erosion while there's still time to react.
The metrics that matter
Commercial share is the yield driver — it's typically the best-paying segment, so a center sliding out of commercial mix loses revenue per visit even at flat volume. Self-pay share is the risk driver, because those balances are the hardest to collect and most likely to age into bad debt. Net revenue per visit by payer is the proof: it shows, in dollars, exactly how much a percentage-point shift in mix is worth to the center.
Why the data is trapped
Payer assignment lives in Experity, eClinicalWorks, or athenahealth, but the realized revenue that turns mix into dollars per visit comes from what payers actually paid — the 835 detail in Waystar. Mix on its own (visit counts by payer) is easy; mix weighted by realized revenue, trended by month and split by center, requires joining the visit record to its remittance. That join is the work most operators do by hand, if at all.
How to read it
Watch the commercial-versus-self-pay trend line first — a widening gap in the wrong direction is the early signal of mix erosion. Compare self-pay share by center to find the site carrying the most collection risk, then read net revenue per visit by payer to size the dollars at stake. A center with healthy volume but low net revenue per visit has a mix problem, not a throughput problem.
The sample on this page uses entirely synthetic visit and revenue data — generic payers, made-up dollar amounts, no real patient or financial records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Visits | Count of visits with a payer assigned in the period. |
| Self-Pay Share | Share of visits with no insurance billed — the highest-collection-risk segment. |
| Commercial Share | Share of visits billed to commercial payers — typically the highest-yield segment. |
| Government Payer Share | Combined Medicare, Medicaid, and Tricare share of visits. |
| Total Net Revenue | Sum of realized revenue dollars across all visits. |
| Net Revenue per Visit | Total net revenue ÷ visits — blended realized dollars per visit, sliced by payer on the charts. |
Used by: Owners and regional directors watching payer mix and self-pay exposure
Frequently asked questions
Why does payer mix matter so much in urgent care?
Reimbursement varies sharply by payer — commercial plans typically pay the most, government plans less, and self-pay carries the highest collection risk. Two centers with identical volume can earn very different revenue purely on mix, so a shift toward self-pay or government quietly erodes net revenue per visit.
What's a concerning self-pay share?
There's no universal threshold — it depends on your market and front-desk collection process — but self-pay is the segment most likely to age into bad debt, so the watch-it metric is the trend. A self-pay share rising month over month, especially concentrated in one center, is the flag to act on.
Can I build this on my own data?
Yes. Export visit-and-payer data from your EMR/PM and realized revenue from your clearinghouse, and use this as a template. We model it into a Power BI report; the sample here uses synthetic data so you can see the finished shape first.
Build this report on your own data
Clone this Urgent care template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →