Calculate net collection rate from total payments received and expected, or find expected or received payments from the other two values.
Customize This Calculator
Build your own version. Describe what you want changed, added, or compared.
Related Calculators
- Gross Sales Calculator
- Close Rate Calculator
- Operating Ratio Calculator
- Sales Growth Calculator
- All Business Calculators
Net Collection Rate Formula
The net collection rate shows what percentage of expected payments were actually collected. It is commonly used in medical billing, accounts receivable, and revenue cycle reporting.
- NCR = Net Collection Rate, as a percentage
- TPR = Total Payments Received, in dollars
- TPE = Total Payments Expected, in dollars
The calculator can solve for any one missing value when you enter the other two.
- Use this when you know the total payments received and the net collection rate.
- The result is the total amount that was expected to be collected.
- Use this when you know the total payments expected and the net collection rate.
- The result is the total amount actually received.
Net Collection Rate Benchmarks
Benchmarks vary by industry, payer mix, contract terms, and write-off policies. The table below gives a general way to read the result.
| Net Collection Rate | General Interpretation | What It May Suggest |
|---|---|---|
| 98% to 100% | Very strong collection performance | Most expected payments are being collected. |
| 95% to 97.9% | Acceptable to strong | Some missed collections, denials, or underpayments may exist. |
| 90% to 94.9% | Needs review | Payment follow-up, contracts, or adjustment handling may need attention. |
| Below 90% | Low collection performance | A significant share of expected revenue is not being collected. |
Example
Example 1: Calculate net collection rate
You expected to collect $50,000 and received $47,500.
The net collection rate is 95%.
Example 2: Calculate total payments received
You expected to collect $80,000 and the net collection rate is 96.5%.
The total payments received are $77,200.
FAQ
What does net collection rate measure?
Net collection rate measures how much of the money you expected to collect was actually received. It focuses on collectible revenue, not total billed charges. A higher rate usually means fewer missed payments, denials, underpayments, or preventable write-offs.
Can net collection rate be over 100%?
Yes, it can happen if payments received are greater than payments expected. This may be caused by late payments from prior periods, incorrect expected payment amounts, payer adjustments, or posting errors. A rate over 100% should usually be reviewed.
What is the difference between net collection rate and gross collection rate?
Net collection rate compares payments received to payments expected. Gross collection rate compares payments received to total charges billed. Net collection rate is usually more useful when billed charges are not the same as the amount you realistically expect to collect.
