Revenue performance
Healthcare A/R Aging Calculator & Analyzer
Enter accounts receivable by aging bucket to see where balances are accumulating, how much sits beyond 90 and 120 days, and how many days of revenue your A/R represents. Follows HFMA MAP Key definitions for aged A/R and net days in A/R.
- What it calculates
- Total A/R, share by bucket, A/R over 90 and 120 days in dollars and percent, days each bucket represents, and days in A/R.
- Who it is for
- Revenue cycle and business office leaders, CFOs and diligence teams reviewing receivables quality.
- What you'll need
- An aging report as of one date. Optional: revenue for a recent period on the same basis (net or gross) as the A/R.
- Key rule
- Aged A/R is a balance to review, not an amount to be collected. Collectibility is assessed account by account.
Calculator
Enter balances from one aging report, as of one date. Total A/R calculates automatically.
Enter at least one aging bucket
Total A/R and every percentage are calculated from the buckets you enter. Blank buckets are treated as $0.
Aging distribution
Share of total A/R by bucketBucket detail
| Bucket | Balance | % of total | Cumulative % | Days of revenue |
|---|
What your A/R distribution may indicate
The observations below are generated from the shape of your distribution, not from external thresholds. An aging profile shows where balances sit; it cannot by itself establish why.
Possible contributors to aging
| Possible issue | How it tends to appear in aging | What confirms it |
|---|---|---|
| Denials | Balances move from 31–60 into later buckets after a denial and wait for rework or appeal. | Denial and adjustment codes on aged claims; share of aged A/R with a denial on file. |
| Payer follow-up delays | Claims with no response accumulate in 61–90 and 91–120. | Last-activity date, follow-up touch frequency, claims with no payer status. |
| Payment posting problems | Paid claims remain open; unapplied cash and credit balances grow. | Unapplied cash report, 835 to deposit reconciliation, credit balance aging. |
| Eligibility problems | Balances age after coverage denials and transfers to patient responsibility. | Eligibility-related CARCs, self-pay transfers, coordination-of-benefits denials. |
| Coding issues | Claims held before submission (date-of-service aging) or denied after. | Unbilled/DNFB inventory, coding-related denials, coder backlog. |
| Appeal delays | Balances concentrate in 91–120 and over 120 while appeals are pending. | Appeal status, appeal filing dates against payer appeal limits. |
| Staffing constraints | Broad drift across all later buckets rather than one payer or category. | Work queue backlog per FTE, untouched accounts by age. |
Reviewing aged balances for collectibility
Aged A/R is not automatically collectible. Before an aged balance is treated as recoverable, it should be reviewed against these six factors.
Payer
Filing and appeal limits, responsiveness and recoupment behavior differ by payer and product line, including Medicare, Medicaid managed care, commercial and workers' compensation.
Claim status
Whether the claim was received, is pending, denied, paid incorrectly or never submitted determines what work is possible.
Timely-filing rules
Balances past the payer's filing limit may not be collectible regardless of the underlying service, unless proof of timely filing exists.
Denial history
Repeated denials on the same claim, and the reason codes involved, indicate how likely further rework is to succeed.
Appeal status
Which appeal level has been reached and how much time remains at the next level.
Collectibility
For patient balances, financial assistance eligibility, statement history and balance size; for payer balances, expected value net of rework cost.
How this calculator works
HFMA MAP Key AR-1: aged A/R as a percentage of total billed A/R.
A/R over 120 daysOver 120
Days in A/RTotal A/R ÷ Average daily revenue
HFMA MAP Key FM-1: net A/R ÷ average daily net patient service revenue. With gross balances, the result is gross days in A/R.
Shows how many of the total days each bucket contributes. The figures sum to days in A/R.
Methodology decisions
Common approachDays in A/R = total A/R ÷ (annual collections ÷ 365).
This toolAsks which basis the balances use and requires revenue on the same basis. It defaults to a recent 3-month period, because a 12-month average lags when volume is changing. Collections are allowed as a labeled proxy.
Common approachLabel aging buckets "good" or "bad" against fixed thresholds.
This toolDescribes the shape of the distribution (for example, whether balances grow after 90 days) without external thresholds.
Common approachPresent aged A/R as "money you can recover."
This toolTreats every aged balance as an amount to review, with the six collectibility factors listed explicitly.
Assumptions & limitations
- One snapshot. A single aging report can be distorted by month-end timing, large batch payments or write-off cleanups. Compare several month-ends.
- Credit balances. Most aging reports net credit balances against debit balances. Large credits reduce total A/R and can hide aged debits.
- Payer mix. Workers' compensation, auto and personal injury balances legitimately age longer. Without a payer split, an aggregate distribution can mislead.
- Basis consistency. Gross and net balances, and date-of-service and submission aging, produce different results and should never be mixed.
- Reserves. Aged A/R may already be partly reserved for bad debt in the financial statements. This tool does not estimate collectible value.
Request an A/R Performance Review
An A/R review segments aged balances by payer, claim status, denial history and filing-limit exposure, then produces a prioritized work plan that separates workable balances from those that need a write-off decision.
Frequently asked questions
How do you calculate the percentage of A/R over 90 days?
Add the balances in every bucket older than 90 days (91–120 and over 120) and divide by total A/R. This follows HFMA's MAP Key for aged A/R as a percentage of total billed A/R, which reports each aging bucket as a share of the total.
How is days in A/R calculated?
Days in A/R = total A/R ÷ average daily revenue, where average daily revenue = revenue for the period ÷ days in the period. HFMA's net days in A/R uses net A/R and net patient service revenue. If your aging report shows gross charges, compare it to gross charges for the same period instead, and expect a different number.
Is all A/R over 90 days collectible?
No. Some aged balances are still workable, some are in appeal, some are past the payer's timely-filing limit, and some are patient balances with low likelihood of payment. Collectibility has to be assessed account by account using payer, claim status, filing limits, denial history and appeal status.
Should A/R be aged from date of service or date of billing?
Either can be valid, but they answer different questions and should not be mixed. Aging from date of service includes delays in charge capture and coding; aging from claim submission isolates payer and follow-up performance. Record which basis your report uses when you compare periods or organizations.
What does a large over-120 bucket indicate?
On its own, it shows that balances are not being resolved before they age. Possible contributors include unresolved denials, slow payer follow-up, unapplied or misposted payments, credentialing gaps and staffing constraints. The distribution points to where to look; claim-level review is needed to establish the cause.
What A/R over 90 percentage is good?
This tool does not set a universal threshold. Appropriate levels depend on specialty, payer mix (workers' compensation and personal injury balances age differently), and aging basis. Compare against your own trend or a licensed benchmark for a comparable population, and record the source.
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."
- X12. Claim Adjustment Reason Codes (CARC) code list.
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.