For an outpatient rehab clinic, the revenue cycle runs from a submitted charge to a paid claim — and it's where margin is won or lost. High denial rates, slow payer turnaround, and aging accounts receivable can strand a large share of billed revenue, and because rehab is high-volume — many visits and CPT units per patient per week — even a low denial percentage represents real money. This dashboard makes the whole pipeline visible: what was collected, what's stuck, and why claims are being denied.
What this report answers
The Collections & Denials page leads with net collections and the net collection rate — payments collected against the allowed amount, the single best read on revenue-cycle health. Next to them sit the denial rate weighted by dollars and the clean claim rate, the share of claims paid on first pass without rework. A submitted-vs-collected bar by payer exposes which payers pay cleanly and which create friction, a stacked bar ranks denied dollars by reason, and a trend line tracks the collection rate month over month. The AR Aging page turns the open balance into action: outstanding dollars by aging bucket, AR-over-90 by payer, and a table of the largest open claims to work first.
The metrics that matter
Net collection rate is the headline — a strong clinic collects the large majority of its allowed amount, and a rate dragging below that signals denials, underpayments, or write-offs. Read the denial rate next to its reasons: authorization/referral-missing and eligibility denials point upstream to the front desk and verification, while timely-filing denials point to billing throughput. AR over 90 days is the early-warning line — the longer a claim ages, the less likely it ever pays.
Why the data is trapped across the systems
Claims, remittances, and adjustments live inside the billing module of Prompt, Raintree, Net Health / Clinicient, WebPT, TheraOffice, Jane, or Fusion — and the canned A/R report rarely lets an owner slice denied dollars by reason and payer at the same time, let alone roll AR across multiple locations. Getting to a clean collection-rate-and-denials view means exporting claim and remittance detail and modeling it yourself, which is exactly the gap this template fills.
How to read it
Start with net collection rate, then read the denial mix to see whether the fix belongs at intake or in billing, and finish on AR-over-90 to find the at-risk dollars before timely-filing windows close. The sample here uses fully synthetic, anonymized claims data — no PHI and no real remittance — so you can see the finished layout before bringing your own export.
Metrics it tracks
| Metric | What it means |
|---|---|
| Net Collections | SUM of payment dollars actually received across all claims in the period. |
| Net Collection Rate | Payments collected ÷ allowed amount — the share of collectible revenue you actually capture, and the truest measure of RCM health. |
| Denial Rate (Charges) | Denied dollars ÷ submitted dollars, using a 1/0 denied flag — denials weighted by money, not claim count. |
| AR Dollars Outstanding | Outstanding balance across all open claims not yet fully paid. |
| AR Over 90 Days | Outstanding balance in the 90-plus aging band — the bucket most at risk of write-off. |
| Clean Claim Rate | Claims paid on first submission ÷ all claims — the share that sail through without rework. |
Used by: Clinic owner and billing manager
Frequently asked questions
What is a good net collection rate for an outpatient rehab clinic?
Net collection rate is payments collected divided by the allowed amount. Healthy clinics collect the large majority of what payers allow; a rate dragging well below that points to denials, underpayments, or write-offs. It's a better health measure than gross charges because it reflects what actually lands in the bank after contractual adjustments.
What are the most common rehab claim denial reasons?
The recurring ones are missing authorization or referral, eligibility lapses, coding and modifier errors (the 8-minute rule and modifier 59/KX trip up rehab billing in particular), timely filing, and medical necessity. Ranking denied dollars by reason shows whether the fix belongs at the front desk and verification or in billing throughput.
Why does AR aging matter so much in rehab?
Because visit and claim volume is high and payers enforce timely-filing limits, claims that age past 90 days are at real risk of never being collected. Watching AR over 90 days by payer lets a billing team work the most at-risk dollars before the window closes.
Build this report on your own data
Clone this Rehab therapy 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 →