Accounts Receivable Aging Calculator
Tracks outstanding customer payments bucketed by days overdue
Invoices not yet past due
Amount outstanding for 1 to 30 days
Amount outstanding for 31 to 60 days
Amount outstanding for 61 to 90 days
Amount outstanding for more than 90 days
Sum of all outstanding receivables across all aging buckets
Average age of receivables weighted by amount
Percentage of receivables that are not yet due
Percentage of receivables 1 to 30 days overdue
Percentage of receivables 31 to 60 days overdue
Percentage of receivables 61 to 90 days overdue
Percentage of receivables more than 90 days overdue
Frequently Asked Questions
What is accounts receivable aging?
AR aging is a report that categorizes outstanding customer invoices by how long they have been unpaid. Standard buckets are Current, 1-30 days, 31-60 days, 61-90 days, and over 90 days past due. It helps identify collection problems and potential bad debt.
Why is tracking AR aging important?
The longer an invoice goes unpaid, the less likely it is to be collected. Studies show that invoices over 90 days past due have only a 50-70% collection probability. Monitoring aging helps you prioritize collection efforts and maintain healthy cash flow.
What is a healthy accounts receivable aging distribution?
Ideally, 80-90% of your receivables should be in the Current or 1-30 day buckets. If more than 10-15% of receivables are over 60 days past due, your collection process or credit policies likely need attention. Industry benchmarks vary significantly.
Related Calculators
Retail Price Calculator
Calculates optimal retail price from wholesale cost, markup, and competitive positioning
Handling Fee Calculator
Computes per-order or per-item handling fees for inventory fulfillment
Average Collection Period Calculator
Calculates the average number of days to collect payment after a sale
Profit Forecast Tool
Projects a business's revenue growth over time and shows scenarios for acceleration