To understand Accounts Receivable Aging, let’s consider an example

XYZ Medical Clinic provides healthcare services to its patients and maintains a list of outstanding accounts receivable. The clinic categorizes these accounts based on the length of time they have been unpaid, typically in intervals such as 0-30 days, 31-60 days, 61-90 days, 91-120 days and over 120 days.

Let’s assume XYZ Medical Clinic has the following outstanding accounts receivable balances:

$25,000 in accounts unpaid for 0-30 days

$10,000 in accounts unpaid for 31-60 days

$5,000 in accounts unpaid for 61-90 days

$2,500 in accounts unpaid for 91-120 days

$7,500 in accounts unpaid for over 120 days

To calculate Accounts Receivable Aging:

Step 1: Determine the outstanding balance for each aging category.

In this example, the outstanding balances for each category are:

0-30 days: $25,000

31-60 days: $10,000

61-90 days: $5,000

91-120 days: $2,500

Over 120 days: $7,500

Step 2: Total the outstanding balances across all aging categories.

In this example, the total outstanding accounts receivable balance is $25,000 + $10,000 + $5,000 + $2,500 + $7,500 = $50,000.

Step 3: Determine the percentage of the outstanding balance for each aging category.

To calculate the percentage, divide the outstanding balance for each category by the total outstanding accounts receivable balance and multiply by 100.

Percentage of 0-30 days: ($25,000 / $50,000) * 100 = 50%

Percentage of 31-60 days: ($10,000 / $50,000) * 100 = 20%

Percentage of 61-90 days: ($5,000 / $50,000) * 100  = 10%

Percentage of 91-120 days:  ($2,500 / $50,000) * 100 = 5%

Percentage of over 120 days: ($7,500 / $50,000) * 100 = 15%

In this scenario, XYZ Medical Clinic’s Accounts Receivable Aging analysis reveals that 50% of the outstanding balance is in the 0-30 days category, 20% is in the 31-60 days category, 10% is in the 61-90 days category, 5% is in the 91-120 days category  and 15% is in the over 120 days category.

The Accounts Receivable Aging analysis helps medical practices identify the aging of their receivables and take appropriate actions. It allows them to focus on collecting payments for the accounts that have been outstanding for a longer period, implement strategies to reduce aging, and improve cash flow.

While the specific ideal Accounts Receivable Aging will depend on the payer mix, specialty and Geographical location of the practice and it can differ from one practice to another.

0-30 days: It is ideal to have a significant portion of the outstanding AR in this category. A high percentage (e.g., 70% or more) in the 0-30 days category is considered excellent.

31-60 days: Ideally, a lower percentage (e.g., 15-20%) of the outstanding AR should fall into this category, indicating that only a small portion of accounts are slightly delayed in payment.

61-90 days: An ideal percentage (e.g., 5-10%) in this category suggests that the practice has minimal accounts that are overdue by 61 to 90 days.

91-120 days: The ideal percentage of the outstanding AR in this category should be relatively low (e.g., 3-5%). It indicates that the practice has a small number of accounts that are significantly overdue.

Over 120 Days: The ideal percentage of the outstanding AR in this category should be relatively low (e.g., 5% or less). It indicates that the practice is managing its revenue cycle efficiently.

Conclusion

Effective healthcare revenue cycle management is essential for the financial well-being of medical practices. By utilizing key metrics such as Days in AR, Collection Rate, Net Collection Rate, Clean Claim Rate and Accounts Receivable Aging, healthcare providers can gain valuable insights into the performance of their revenue cycle and identify areas for improvement. By proactively monitoring and optimizing these metrics, medical practices can enhance their financial health, streamline billing processes, minimize revenue leakage, and ultimately provide better care to their patients.