A high-volume urgent care center submits a lot of claims, and the back end of the revenue cycle is where that volume turns into either cash or a write-off. This dashboard watches the two failure modes that strand money: claims that age in A/R until they're at risk, and claims that get denied. It shows how fast you pay, how much is stuck past 90 days, and exactly where denials are coming from by payer, reason, and center.
What this dashboard answers
The A/R aging page answers the cash-at-risk question: total open A/R, how much has aged past 90 days, the clean claim rate, and how open A/R is trending by month — with aging broken out by payer so you can see who's slow. The denials page answers the leakage question: the denial rate, denied dollars ranked by reason, and denial rate by payer and by center, so the billing team knows precisely where to aim appeals and process fixes.
The metrics that matter
A/R over 90 days is the early-warning line — in urgent care, where payers enforce timely-filing limits, the longer a claim ages the less likely it ever pays. Clean claim rate is the efficiency metric: every claim that has to be reworked costs labor and ages toward that 90-day cliff. Denial rate paired with denied dollars by reason is the actionable pair — it separates the eligibility and coding problems that start upstream at the front desk from the back-office throughput issues like timely filing.
Why the data is trapped
Submitted claims and their status live in Experity, eClinicalWorks, or athenahealth, but denial detail — the reason codes, the denied dollar amounts, the remittance dates that drive aging — comes from payer 835s through Waystar. Tying a denial reason back to the originating claim and center is the cross-system join the EMR's canned A/R report doesn't make, so denial dollars by reason usually live in a clearinghouse export that nobody reconciles against the practice management system.
How to read it
Start with A/R over 90 days and the aging-by-payer stack — a payer overweight in the 90-plus bucket needs a focused follow-up campaign now. Then read denial rate next to denied dollars by reason: eligibility and coding denials point upstream to registration and documentation, while timely-filing denials point to billing throughput. Use denial rate by center to find a site whose front desk needs retraining before the pattern spreads.
The sample on this page uses entirely synthetic claims data — generic payers, made-up dollar amounts, no real patient or financial records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Open A/R | Sum of open balances across all claims — cash billed but not yet collected. |
| A/R Over 90 Days | Open balance on claims aged past 90 days — the dollars at highest collection risk. |
| Denied Claims Count | Count of claims initially denied by a payer. |
| Denial Rate | Denied claims ÷ total claims submitted — the share denied on first pass. |
| Clean Claim Count | Count of claims paid on first submission with no rework. |
| Clean Claim Rate | Clean claims ÷ total claims — the share that paid without touching them twice. |
Used by: Billing managers and owners working the back end of the revenue cycle
Frequently asked questions
Why does A/R over 90 days matter in urgent care?
Claim volume is high and payers enforce timely-filing limits, so claims that age past 90 days are at real risk of never being collected. Watching the 90-plus bucket — and which payers fill it — lets a billing team work the most at-risk dollars before the filing window closes.
What are the most common urgent care claim denial reasons?
The recurring ones are eligibility lapses, coding and medical-necessity denials, missing information, timely filing, and duplicates. Ranking denied dollars by reason shows whether the fix belongs upstream at registration and documentation or in back-office billing throughput.
Where does the denial detail come from?
Claim status lives in your EMR/PM, but denial reason codes and denied amounts come from payer 835 remittances through a clearinghouse like Waystar. Export both and use this as a template; the sample here uses synthetic data so you can see the finished layout 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 →