Revenue performance · Flagship tool
Revenue Leakage Calculator for Healthcare Organizations
Size the revenue that may be affected by denials, aged receivables, underpayments and collection performance, using your own figures and assumptions you can see and change. The calculator reports each indicator on its own terms. It does not add them into a single "leakage" number, because these categories overlap and that total would overstate the problem.
- What it calculates
- Revenue associated with denied claims, estimated denial write-offs, A/R over 90 days, underpayment exposure, a net-collection-rate comparison and RCM operating cost.
- Who it is for
- CFOs, VPs of revenue cycle, MSO and medical-group executives, and PE operating partners reviewing a practice or platform.
- What you'll need
- Trailing-12-month collections plus any of: denial rate, denial write-off share, A/R aging, net collection rate, underpayment variance, cost to collect.
- What it is not
- A recovery forecast. Revenue affected is not revenue recoverable; recovery depends on payer, claim status and filing limits.
Calculator
Only annual collections is required. Leave any other field blank and the related indicator is marked "not assessed" instead of being estimated.
Enter annual collections to see results
Every indicator is expressed relative to annual collections, so the calculator needs that figure first. Optional fields can stay blank.
Scale of each indicator relative to annual collections
Shown side by side for scale. Not additive.Bars share one scale: percent of annual collections. Tags describe what kind of number each bar is. The denial write-off bar is a subset of the denial bar, and aged A/R can contain both.
Supporting figures
Derived from your inputsAreas that may warrant review
Generated from what you entered. Each area lists the figure behind it and the questions an assessment would test. The figures point to where to look; they do not establish a cause.
What these numbers mean
- Revenue associated with denied claims
- The dollar value of claims that were initially denied. Many are paid after correction or appeal. This is revenue affected, not revenue lost.
- Denial write-off exposure
- The part of denied value you estimate is never paid. It is a subset of the figure above, driven entirely by the write-off rate you enter.
- A/R over 90 days
- A balance at a point in time. Part of it may be collectible, part may be past timely filing, and part may already be reserved. Aged A/R is not automatically collectible.
- Underpayment exposure
- Reimbursement that appears to fall short of contracted terms. Whether it is recoverable depends on contract language, appeal windows and payer behavior.
- Net collection comparison
- What collections would be at a rate you chose, holding expected collectible revenue constant. An illustration of sensitivity, not a forecast.
- RCM operating cost
- What the revenue cycle costs to run. A cost, not lost revenue. Lower is not automatically better if collections fall.
Why there is no total "leakage" figure
These indicators share dollars. Adding them would count the same dollar two or three times. The map below shows where they overlap.
| Indicators | How they overlap |
|---|---|
| Denials ↔ Denial write-offs | Write-offs are a subset of denied value. Summing them counts written-off dollars twice. |
| Denials ↔ A/R over 90 | Denials still being worked usually sit in aged A/R buckets. |
| Denial write-offs ↔ Net collection rate | Denial write-offs are one reason net collection rate falls below 100%. The NCR gap already includes them. |
| Underpayments ↔ Net collection rate | Depends on posting. If underpayments are adjusted as contractual allowances, they disappear from the NCR denominator and NCR looks better than it is. If not, they appear in both. |
| Underpayments ↔ A/R | Unresolved short-pays left open on the account sit in A/R. |
| Operating cost ↔ all | A cost of running the function, not revenue. It belongs in a different column of the P&L. |
How this calculator works
Every result traces to one of the formulas below. Percentages are entered as whole numbers (9 means 9%) and divided by 100 in the calculation.
Approximates charges net of contractual adjustments: the amount the organization expected to collect. Requires net collection rate.
where Denial base = Expected collectible revenue (default)
or Annual collections (fallback)
Assumes denied claims carry the same average value as all claims. If your denials skew toward high-dollar services, enter a dollar-based denial rate.
The write-off rate is your assumption. Use your own posting data by adjustment code where possible.
Total A/R × A/R over 90 %
Percent-of-A/R inputs convert to dollars only when total A/R is supplied. Collections are never used as the A/R base.
The rate is defined against reimbursement received, so collections is the matching base.
DifferenceExpected collectible revenue × (Comparison NCR − Current NCR)
Holds expected collectible revenue constant. Your comparison rate is a scenario, not a target the tool endorses.
Matches the HFMA cost-to-collect definition: total revenue-cycle cost ÷ total patient-service cash collected.
Gross collection rateAnnual collections ÷ Gross charges
Informational only. Used to check that inputs are internally consistent.
Methodology decisions
Common revenue-leakage calculators make several shortcuts that inflate results. This tool departs from them deliberately.
Common approachAdd denials, aged A/R, underpayments and the NCR gap into one "total leakage" figure.
This toolReports each indicator separately and shows how they overlap. Double counting cannot be removed reliably without claim-level data, so no aggregate is produced.
Common approachDenial exposure = annual collections × denial rate.
This toolApplies the denial rate to expected collectible revenue when net collection rate is known. Collections exclude denials that were never paid, so using collections understates the base. Collections remain available as a labeled fallback.
Common approachConvert "A/R over 90 %" into dollars by multiplying by collections.
This toolConverts only against total A/R, the denominator the percentage is defined on (HFMA AR-1: aged A/R ÷ total billed A/R). Without total A/R, the percentage is reported as-is.
Common approachCompare net collection rate to a fixed "industry target."
This toolAsks you to choose the comparison rate and quick-sets it relative to your own current rate. No universal target is imposed.
Common approachTreat a lower cost to collect as a saving.
This toolReports operating cost as a cost, next to revenue indicators but never netted against them.
Assumptions & limitations
- Affected is not recoverable. None of the dollar figures is an estimate of what an organization will recover. Recovery depends on payer, claim status, timely-filing and appeal limits, documentation and contract terms.
- Averages hide mix. The denial calculation assumes denied claims have average value. Specialty, payer and place-of-service mix can make denied dollars very different from the average.
- Definitions vary between systems. Denial rate may be measured by claim count or dollars, initial or final, and with or without rejections at the clearinghouse. Use one definition consistently.
- Net collection rate depends on adjustment posting. If underpayments or avoidable write-offs are posted as contractual adjustments, NCR is overstated and the expected-collectible estimate is understated.
- Timing. Annual collections include cash for services from prior periods. Collections, charges and A/R should come from the same trailing-12-month window.
- Point-in-time A/R. A/R over 90 days is a snapshot that varies month to month. A trend across several month-ends is more informative than one balance.
- No benchmarks. This page does not tell you whether a value is good or bad. Comparison values are the ones you enter.
Request a Revenue Cycle Assessment
The calculator shows where dollars may be affected. An assessment works from claim-level and remittance data to establish what is driving them, what is recoverable, and what it would take to change.
- Denial root cause by payer and CARC group
- Collectibility triage of aged A/R
- Expected-vs-paid variance against loaded contracts
Your calculator inputs stay in your browser. Nothing is shared unless you submit a request.
Frequently asked questions
What is revenue leakage in healthcare?
Revenue leakage is a general term for revenue an organization earned or expected but did not collect, or collected late or short. Common sources are claim denials that are never resolved, aged receivables that pass timely-filing limits, payments below contracted rates, and avoidable write-offs.
There is no single standard formula for revenue leakage. This calculator therefore reports each source separately rather than producing one total.
Why doesn't this calculator show a total revenue leakage number?
Because the categories overlap. Denial write-offs are a subset of denied revenue; unresolved denials sit inside aged A/R; and both reduce the net collection rate. Adding them counts the same dollars more than once. Removing that overlap requires claim-level data, which a summary calculator does not have, so it would be misleading to show a total.
Is revenue associated with denied claims the same as lost revenue?
No. Many denied claims are paid after correction, resubmission or appeal. The calculator labels denied value as revenue affected. Only the share you estimate is never paid, entered as the denial write-off rate, is shown as write-off exposure, and that figure is still an estimate based on your assumption.
Why is the denial rate applied to expected collectible revenue rather than collections?
Collections only include cash that was actually received, so dollars from denials that were never paid are already missing from that figure. Expected collectible revenue (collections ÷ net collection rate) approximates what the organization expected to collect before denials and other shortfalls, which is a better base. If you do not know your net collection rate, the tool falls back to collections and labels the result as an understatement.
How should A/R over 90 days be entered?
Either as a dollar balance or as a percentage of total A/R. If you enter a percentage, the calculator converts it to dollars only when you also provide total A/R. It does not multiply a percentage of A/R by annual collections, because the percentage is defined on A/R, not on collections.
What net collection rate should we compare against?
One you choose and can defend: your own best recent period, an internal target, a contracted vendor service level, or a licensed benchmark for a comparable specialty and payer mix. The calculator does not impose an industry target because published figures vary by specialty, payer mix and how adjustments are posted.
Does a high underpayment estimate mean we can recover that money?
Not necessarily. Underpayment exposure is the reimbursement that appears to fall short of contracted terms. Recovery depends on contract language, appeal and recoupment windows, payer responsiveness and whether the variance is real once modifiers, bundling and fee-schedule updates are accounted for.
Review, sources & updates
Methodology reviewer
[Reviewer name, credentials (e.g., CHFP, CRCR, CPA)] Assign before publication
Reviewer confirms formulas, definitions and limitation language. Do not publish this page with a placeholder reviewer.
Last updated
· Methodology v1.0
Formula or definition changes are versioned and dated on this page.
Sources
- Healthcare Financial Management Association (HFMA). MAP Keys: industry-standard revenue cycle KPIs.
- HFMA. "Ask the Experts: Net Days in A/R."
- HFMA. "A KPI Primer: 5 Steps for Creating Meaningful Revenue Cycle Metrics."
No industry benchmark figures are reproduced on this page. Where a comparison is useful, the tool asks you to enter your own reference value and record where it came from.