Free Business Tool

Accounts Receivable Aging Calculator

Analyze your outstanding invoices and identify collection bottlenecks by aging bucket.

Instant Results

No Data Stored

100% Free

What Is Accounts Receivable Aging?

Accounts receivable aging is the process of categorizing unpaid customer invoices by how long they have been outstanding. Invoices are grouped into "aging buckets" -- typically Current (0-30 days), 31-60 days, 61-90 days, and 90+ days. This breakdown reveals not just how much money is owed to you, but how likely you are to actually collect it. The older an invoice gets, the less likely you are to receive payment. Days Sales Outstanding (DSO) is the companion metric: it measures the average number of days it takes to collect payment after a sale is made. DSO = (Accounts Receivable / Annual Credit Sales) x 365. A DSO of 45 means it takes an average of 45 days from invoice to cash in hand. Lower is better -- it means faster cash conversion and healthier working capital. The Collection Effectiveness Index (CEI) provides a more nuanced view than DSO alone. It measures how much of your receivables you actually collect within a given period, accounting for new credit sales. A CEI above 80% is acceptable; above 90% is strong. Below 70% signals a systemic collection problem that threatens the cash flow of even a profitable business.

How to Use This Calculator

Enter Total AR

Input the total amount of outstanding accounts receivable from your balance sheet or accounting software.

Break Down by Aging Bucket

Distribute the total across the four aging categories. Most accounting software (QuickBooks, Xero, FreshBooks) generates this aging report automatically. The sum of the four buckets should equal your total AR.

Enter Annual Credit Sales

Input your total credit sales (sales made on account, not cash sales) for the past 12 months. This is used to calculate DSO and collection effectiveness.

Analyze the Aging Profile

Healthy AR: 70%+ is current, less than 10% is 90+ days. If your 90+ bucket exceeds 15%, you have a collections problem. Each aging bucket has a different probability of collection -- address the oldest invoices first.

Key Concepts

Days Sales Outstanding (DSO)

Average number of days to collect payment. Industry medians: B2B manufacturing 45-55 days, professional services 35-45 days, construction 60-90 days. DSO above your payment terms signals collection issues.

Collection Probability

The likelihood of collecting an invoice declines with age. Current: 95%+ collection rate. 30-60 days: 85-90%. 60-90 days: 70-80%. 90+ days: under 50%. After 120 days, the industry collection rate drops below 25%.

Bad Debt Reserve

An accounting allowance for receivables you expect to never collect. Typically 1-5% of total AR, but should be higher if your 90+ bucket is large. GAAP requires recognizing expected credit losses under ASC 326.

Factoring

Selling your receivables to a factoring company at a discount (typically 1-5% of invoice value) for immediate cash. Common in trucking, staffing, and manufacturing where long payment terms strain cash flow.

Expert Insights

The Cash Flow Killer: More businesses fail from cash flow problems than from lack of profitability. You can be profitable on paper with $150,000 in receivables and still unable to make payroll because that cash is locked up in unpaid invoices. The aging analysis tells you how real your reported revenue actually is. Revenue is not real until the cash hits your bank account.

The 90-Day Collection Cliff: Industry data from commercial collection agencies shows that the probability of collecting an invoice drops by approximately 1% for each day it ages past 90 days. At 90 days, you have roughly a 50% chance of collection. At 120 days, about 25%. At 180 days, under 15%. This is why aggressive follow-up at the 60-day mark is critical -- once invoices cross 90 days, your options narrow to write-off or collection agency (which takes 25-50% of the recovered amount).

Prevention Over Collection: The best collection strategy is prevention: credit checks before extending terms, clear payment terms on every invoice, automated reminders at 7 and 14 days past due, and offering early payment discounts (2/10 Net 30 means 2% discount if paid within 10 days). Companies that implement automated AR workflows reduce DSO by 15-25 days on average.

Frequently Asked Questions

A healthy AR portfolio: 70-80% current (0-30 days), 10-15% at 31-60 days, 5-8% at 61-90 days, and less than 5% at 90+ days. If more than 20% of your AR is over 60 days, you have a systemic issue with either customer creditworthiness or collection processes.

Proven tactics: invoice immediately upon delivery (not end of month), offer multiple payment methods, send automated reminders before due date, implement early-pay discounts (2/10 Net 30), tighten credit terms for slow-paying customers, and assign dedicated follow-up for invoices past 30 days. Each day of DSO reduction frees significant working capital.

For invoices over 90 days, a collection agency often makes sense. They typically charge 25-50% of collected amounts, which feels steep but recovering 50% of a bad debt is better than writing off 100%. For amounts under $500, the cost may not justify it. Some agencies offer flat-fee services for small balances.

They are the same metric calculated slightly differently. DSO = (AR / Annual Revenue) x 365. Average Collection Period = (AR / Average Daily Sales). Both tell you how many days it takes to collect payment. The terms are used interchangeably in most business contexts.

Banks and lenders scrutinize AR aging when evaluating creditworthiness. A high concentration of 90+ day receivables reduces the value of your AR as collateral, lowers asset-based lending availability, and signals operational risk. Cleaning up your AR aging report before seeking financing can significantly improve terms.

This calculator provides estimates for educational purposes only. Actual results depend on your specific business circumstances, market conditions, and accounting methods. Consult a qualified CPA or business advisor before making major financial decisions.