Receivables Aging Calculator
Analyse your accounts receivable aging by breaking down balances into current, 30, 60, 90-day, and over-90-day buckets. Calculate percentage distribution and weighted average days outstanding.
How to Use the Receivables Aging Calculator
- Enter current (0–30 days) receivables amount.
- Enter amounts for 30–60, 60–90, and 90-day buckets.
- Enter over-90-day receivables.
- Click Calculate to see percentages and weighted average days.
使用场景
- •Identifying overdue accounts requiring collection action.
- •Reporting AR aging to management and lenders.
- •Monitoring collection performance over time.
- •Setting reserves for doubtful accounts based on aging.
公式
Total = current + 30d + 60d + 90d + 90d+. Each bucket % = bucket / total × 100. Weighted avg days = weighted sum / total.
常见问题
What is receivables aging?
Receivables aging categorises outstanding invoices by how long they have been unpaid, helping identify collection risks.
What is a healthy aging distribution?
Most receivables should be current or 0–30 days. More than 20% over 60 days indicates collection problems needing attention.
How do I use the weighted average days?
Weighted average days outstanding (WAD) summarises the overall age of your receivables. Compare to your payment terms to assess collection efficiency.