In urgent care, the number the owner cares about most isn't charges — it's net reimbursement per visit, the realized dollars each visit actually earns after contractual adjustments and write-offs. This dashboard follows the money from charge to cash: what you billed, what you were contractually owed, what you collected, what you adjusted away, and what landed as patient responsibility — sliced by payer and by center.
What this dashboard answers
The charges-to-cash page answers the headline questions: total charges, net collections, the net collection rate against what you were contractually owed, and net reimbursement per visit by center. The charges → expected → adjustments → paid waterfall shows where the gross-to-net erosion happens. The adjustments-and-patient-share page breaks paid versus adjustment versus patient responsibility by payer, and ranks adjustment dollars by reason — so you can see how much of the gap is contractual and how much is avoidable write-off.
The metrics that matter
Net collection rate — collected over contractually expected — is the truest measure of revenue-cycle health, because it strips out the contractual discount you were never going to collect and shows what you're leaving on the table. Net reimbursement per visit is the per-unit economics that drive the whole business, and it's almost entirely a function of payer mix and coding. Patient responsibility matters more every year as high-deductible plans push more of the bill onto the patient — and onto your front desk's ability to collect at point of care.
Why the data is trapped
Charges and the claim record live in Experity, eClinicalWorks, or athenahealth, but the expected (allowed) amount, the actual paid amount, and the adjustment breakdown come from payer 835 remittances flowing through Waystar. Net collection rate is impossible to compute correctly without joining the charge to its remittance — which is exactly the cross-system match standard EMR reports skip. So the most important revenue metric in the business usually gets approximated, not measured.
How to read it
Lead with net reimbursement per visit by center — a low outlier is almost always a mix or coding problem, not a billing one. Read net collection rate next to the adjustment-by-reason donut: a high contractual share is expected, but timely-filing and coding write-offs are recoverable dollars and a process flag. Watch patient responsibility as a growing slice you must collect up front, because it ages into bad debt faster than insurer balances.
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 Charges | Sum of charge amount across all visit claims in the period. |
| Net Collections | Sum of payments received — insurer plus patient — against those charges. |
| Net Collection Rate | Collected ÷ contractually expected (allowed) dollars — the share of earnable revenue you actually collected. |
| Net Reimbursement per Visit | Net collections ÷ number of visit claims — the average realized revenue per visit. |
| Total Write-offs / Adjustments | Sum of contractual adjustments plus write-offs against billed charges. |
| Total Patient Responsibility | Sum of copay, coinsurance, and deductible owed by patients. |
Used by: Owners, medical directors, and billing managers tracking per-visit economics
Frequently asked questions
What is net reimbursement per visit and why does it matter in urgent care?
It's net collections divided by visits — the average dollars a visit actually earns after contractual adjustments and write-offs. It's the per-unit economics the whole center runs on, and because it's driven mostly by payer mix and E&M coding, a low number usually points to mix or coding rather than billing effort.
Why use net collection rate instead of gross collection rate?
Gross collection rate compares cash to billed charges, which are inflated by contractual discounts you were never going to collect. Net collection rate — collected over contractually expected (allowed) dollars — strips that out and shows the share of earnable revenue you actually captured, which is the truer health measure.
Can I build this on my own billing and remittance data?
Yes. Export charges from your EMR/PM and remittance detail from your clearinghouse (Waystar 835s), and use this as a template. We model it into a Power BI report you open in Power BI Desktop; 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 →