A/R Days and Denial Rate Calculator
Enter your accounts receivable balance, the revenue or charges for a period and the number of days in it, and the calculator returns days in A/R. Enter claims submitted and claims denied, and it returns your denial rate as a percent.
Days in A/R
Enter the A/R balance, the revenue for the period and the number of days (above zero) to see days in A/R.
Use net A/R with net revenue, or gross A/R with gross charges. Do not mix them.
Denial rate
Enter the claims denied and the claims submitted (above zero) to see the denial rate.
Denial rate is claims denied divided by claims submitted (or remitted). Results are for your own tracking.
In short: the calculator divides your A/R balance by average daily revenue or charges to get days in A/R, and divides denied claims by submitted claims to get denial rate. It shows no benchmark. You choose the period and the inputs, so label both before you share the result.
How do I use the A/R days and denial rate calculator?
Fill in the two blocks above, one for days in A/R and one for denial rate. Each block works alone, so you can run only the one you need.
What are the formulas and what does each input mean?
Days in A/R equals the A/R balance divided by average daily revenue or charges, where the daily figure is the period total divided by the days in the period. Denial rate equals claims denied divided by claims submitted, shown as a percent. Every input is defined below.
| Input | What to enter | Where it comes from |
|---|---|---|
| A/R balance | Total receivable outstanding on the last day of the period | Aging report or balance sheet |
| Revenue or charges for the period | Total posted over the period, on one stated basis (net revenue or gross charges) | Income statement or charge report |
| Days in period | Calendar days covered by that revenue or charges figure. Default 90 | Calendar |
| Claims submitted | Number of claims sent to payers in the period | Clearinghouse or practice management report |
| Claims denied | Number of those claims that a payer denied | Remittance (835) or denial work queue |
HFMA, the Healthcare Financial Management Association, publishes the standard definitions in its MAP Keys. Its Net Days in Accounts Receivable (FM-1) uses net A/R divided by average daily net patient service revenue over the most recent three months, so a quarter ending June 30 uses 91 days. This calculator lets you set the period yourself, which is why a result can differ from an FM-1 figure.
HFMA's Remittance Denial Rate (AR-5) divides claims denied by claims remitted, at claim level, and counts only actionable denials. The calculator divides by claims submitted, as that is the count most teams have at hand. If you need the AR-5 definition for a report, enter claims remitted as the denominator and note it. Our KPI guide holds the full wording of both keys.
What does a worked example look like?
These figures are illustrative and describe no real organization.
Now suppose the same group enters only one month of charges, $1,200,000, but leaves the period at 90 days. The daily figure drops to about $13,333, and days in A/R jumps to 90.0. Nothing about collections changed. The period and the revenue figure did not match.
What mistakes skew A/R days and denial rate?
Four mistakes cause most bad readings. Each one changes the result without any change in how well the billing team is working.
- Mixing gross and net. Gross charges in the denominator give a lower days figure than net revenue. Pick one basis and keep it.
- Wrong period length. Revenue for 30 days divided by 90, or the reverse, distorts the daily average. The days must match the revenue.
- Counting lines instead of claims. A claim with five denied lines is one denied claim. HFMA states that line-item reports should not be used for its denial rate.
- Changing definitions mid-year. If you add secondary claims or drop a payer from one month to the next, the trend is no longer a trend.
Also check that claims denied and claims submitted cover the same set of claims. Counting denials received this month against claims sent last month is a common cause of a rate that looks too high or too low.
What does the result not tell you?
The result is one number from your own inputs, and it carries no benchmark. We state no target here because HFMA's MAP Keys page gives formulas, not target values. Compare your result with your own earlier periods and cut it by payer before you act.
Days in A/R does not say which balances are old. A few large aged accounts, or a shift in payer mix, can move it with no change in work quality. Read it next to the aging buckets. Denial rate does not say why claims were denied or whether they were later paid on appeal. For that, group denials by reason code and payer.
Neither number is a plan. If days in A/R is rising, look at accounts receivable follow-up. If denial rate is rising, look at the root causes through denial management. To test your claim filing windows, use the timely filing calculator. To compare payments with charges, use the collection rate calculator.
How we handle A/R and denial reporting
We report both measures by payer and by denial reason, with the formula written beside each figure. Claims go out within 24 hours of charge entry and denials are worked within 48 hours. Both measures sit inside our revenue cycle management reporting. To talk through your own figures, book a call.
We check every rule, code and deadline against the official source. See our editorial policy.
Common questions
Straight answers from the team that does the work.
Ask a billing lead directly. A 20-minute call, Monday to Friday, 9am to 5pm Eastern.
01How do you calculate days in A/R?
Divide the A/R balance by average daily revenue or charges. The daily figure is the period total divided by the number of days in the period. With a $1,200,000 balance and $40,000 a day, days in A/R is 30.0. State whether the revenue is net or gross, because the two give different answers.
02What is the formula for denial rate?
Denial rate is claims denied divided by claims submitted, shown as a percent. If 240 of 2,000 claims were denied, the rate is 12.0%. HFMA's AR-5 key divides by claims remitted instead, at claim level, so say which denominator you used.
03What period should I use for days in A/R?
Use a closed period of fixed length, and match the days to the revenue. HFMA's FM-1 uses the most recent three months, so a quarter ending June 30 uses 91 days. This calculator defaults to 90 days. Use the same period every time so months can be compared.
04Should I use gross charges or net revenue?
Either can work, but never mix them. HFMA's FM-1 uses net A/R over average daily net patient service revenue. A gross version uses gross A/R over gross charges. The results are not comparable, so write the basis next to the number.
05Do I count denied claims or denied lines?
Count claims. HFMA's Remittance Denial Rate (AR-5) states that any report counting line-item detail should not be used, because the claim is the unit. A claim with five denied lines counts once in the numerator, so pull the count from a claim-level report or the 835 file.
06Why does my result differ from the HFMA definition?
The calculator lets you pick the period and the revenue basis, and it divides denials by claims submitted. HFMA FM-1 uses net figures and the latest three months, and AR-5 divides by claims remitted and counts actionable denials only. Match those inputs to reproduce the HFMA figure.
Book a call about your A/R and denials
Tell us your payer mix and where the days build up. We will reply with how we would approach it. Our figure is 15 to 20% revenue recovered from denials and old A/R.