Free · Excel workbook Built for independent US medical practices

Know if your revenue cycle is bleeding money.
In five minutes. Every month.

Your P&L will not tell you. Your billing report will not tell you. But eight numbers, tracked monthly, will. We built the dashboard we wanted for our own practice, and we made it free for yours.

Get the dashboard
Your data stays with you. This is an Excel workbook that lives on your computer. The formulas calculate locally. Nothing you type gets transmitted anywhere, including to us. Your only data with us is the email you provide to receive the download.
No spam. Unsubscribe anytime. We will send you the workbook and occasional monthly benchmark updates.

Your download is starting.

We've also sent it to your inbox. If nothing kicked off, use the button below.

Download the workbook
Clean Claim Rate 96.4%
Practice Financial Health Dashboard preview
Patient Collections 67.9%
8
Revenue-cycle KPIs
12
Months of tracking
5 min
To fill in monthly
$0
Forever, no upsell
Section 01
What you actually get

The eight KPIs that reveal every revenue leak in an independent practice.

Each metric is calculated automatically from the numbers you enter once a month. Every one is color-coded against MGMA and HFMA benchmarks. When it turns red, you know exactly where money is leaving the practice.

COLLECTIONS

Net Collection Rate

Healthy ≥ 95%

The share of what you billed you actually collected. The single most important RCM number, and the one most practices cannot quote off the top of their head.

A/R AGING

Days in A/R

Healthy ≤ 35 days

How long it takes to collect on a claim, on average. Every extra day is working capital sitting on someone else's balance sheet instead of yours.

DENIALS

First-Pass Denial Rate

Healthy ≤ 5%

Claims kicked back on first submission. Every point above 5% is staff hours spent on rework and revenue delayed by 30 to 90 days.

CLAIMS

Clean Claim Rate

Healthy ≥ 95%

The inverse of your denial rate. High clean claim rate means your front-end and coding processes are catching problems before they cost you money.

BACKLOG

A/R Over 90 Days

Healthy ≤ 15%

The share of your receivables aged past 90 days. Older claims collect at sharply lower rates. A growing over-90 bucket is the clearest sign of a collections problem.

PATIENT PAY

Patient Collection Rate

Healthy ≥ 85%

Patient responsibility now exceeds 30% of revenue for most practices. If you are not collecting 85 cents on every dollar owed by patients, this is likely your fastest-growing leak.

SCHEDULE

No-Show Rate

Healthy ≤ 5%

Every no-show is revenue that cannot be recovered. High-performing practices operate below 5%. This is the leak most owners ignore and pay for every single day.

YIELD

Avg Charge / Encounter

Track the trend

No universal benchmark, but a declining trend is one of the earliest signals of coding under-capture or payer mix erosion. Watch this line month over month.

Section 02
How it works

Four steps. Five minutes. Once a month.

We designed this to fit into an existing month-end close, not to replace one. Pull the numbers you already report from your PM system. Type them in. The dashboard does the rest.

01

Open the Monthly Input tab

Enter that month's numbers in the yellow cells. Nothing else needs your attention. Every input comes straight out of a standard PM report.

02

Open the Dashboard tab

Every KPI is calculated automatically, color-coded against MGMA and HFMA benchmarks, and shown alongside a 3-month average, YTD, and trend arrow.

03

Attack the reds first

Any red or yellow KPI is a revenue leak. The dashboard tells you what to prioritize and where to look for root cause.

04

Repeat monthly

After three months, patterns emerge. After twelve, you know your practice. This is the tool we wish every independent physician owner had on hand.

Monthly Input tab preview
Section 03
Benchmarks that matter

These are the ranges we score against.

Pulled from MGMA DataDive, HFMA MAP Keys, and our own book of business across independent US practices. Directional, not absolute. Your specialty and payer mix will move some of these. Ask us for specialty-specific ranges.

KPI
Healthy
Watch
Leak
Direction
Net Collection Rate
≥ 95%
90 – 95%
< 90%
Higher is better
Days in A/R
≤ 35 days
35 – 45 days
> 45 days
Lower is better
First-Pass Denial Rate
≤ 5%
5 – 10%
> 10%
Lower is better
Clean Claim Rate
≥ 95%
90 – 95%
< 90%
Higher is better
A/R Over 90 Days
≤ 15%
15 – 25%
> 25%
Lower is better
Patient Collection Rate
≥ 85%
70 – 85%
< 70%
Higher is better
No-Show Rate
≤ 5%
5 – 10%
> 10%
Lower is better
Section 05
From the podcast

Deeper on the same eight KPIs.

The dashboard is a starting point. These three episodes of The Independent MD Podcast, hosted by Dr. Signorelli, walk through the leaks the dashboard flags and the systems that fix them.

EP 166 15 min

7 Hidden Revenue Leaks Costing Your Practice $100k+

The most common billing gaps we see across independent practices. Undercoding, eligibility errors, denials that never resolve, timely filing windows expiring quietly. Every one is a KPI in the dashboard.

Listen free
EP 178 18 min

The 4-Step Billing Audit Every Practice Should Run

The audit rhythm that turns a monthly dashboard from a nice-to-have into an operating cadence. What to look at, what to ignore, and the four questions every physician owner should ask their billing team.

Listen free
EP 184 22 min

One Bad Quarter Away: The Financial Firewall

A practice doing $380,000 a month is not evidence of wealth. It is evidence of revenue. The three systems that separate a practice that can absorb a bad quarter from one that cannot.

Listen free
Browse all 170+ episodes on The Independent MD Podcast
Section 06
Common questions

What owners ask us before downloading.

Written from actual conversations we have had with physician owners on discovery calls. If your question is not here, email us at info@natrevmd.com and we will answer it.

Every input is a standard field in Athena, Kareo, eClinicalWorks, DrChrono, Epic, and every other PM system we have worked with. If your system genuinely will not surface one of them, that itself is a signal, and we should probably talk. Email us and we will help you pull it.

The benchmarks in the workbook are directional across specialties. Your specialty and payer mix will move some of them. Reply to the download email with your specialty and we will send back the specialty-specific cut we use internally.

No. This is an Excel workbook that lives on your computer. The formulas calculate locally. Nothing you type gets transmitted anywhere, including to us. Your only data with us is the email you provide to receive the download.

Yes. Forward it freely. Most owners we work with delegate the monthly data entry to a practice manager or billing lead and review the Dashboard tab themselves in a 10-minute stand-up on the first of the month. That is exactly the rhythm we recommend.

Yes. NatRevMD is a physician-led revenue cycle management company. Independent practices hire us to run the whole revenue cycle or to remediate specific leaks. Our free RECOVER Diagnostic (linked in the workbook) is the way to see if we can help. No pressure either way. The dashboard is yours to keep regardless.

No. We send the download link, then a short benchmarking email once a month with what independent practices in our book are seeing. Unsubscribe anytime. We are not going to blast you.

Get the dashboard

Five minutes a month. Every leak in one view.

Download the same workbook we hand every independent practice we advise. Free forever. No credit card. No consultant follow-up unless you ask for one.

Your data stays with you. This is an Excel workbook that lives on your computer. The formulas calculate locally. Nothing you type gets transmitted anywhere, including to us. Your only data with us is the email you provide to receive the download.
We will send the workbook plus occasional monthly benchmark updates. Unsubscribe anytime.

Your download is starting.

We've also sent it to your inbox. If nothing kicked off, use the button below.

Download the workbook