Accounts Receivable Aging Calculator
Analyze your outstanding invoices and identify collection bottlenecks by aging bucket.
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
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.
Run These Numbers Too
Need Cash While You Wait for Payment?
Compare invoice factoring and AR financing to bridge the cash flow gap.
Compare AR FinancingEconomic Snapshot
Source: Federal Reserve Economic Data (FRED). Indicators refresh daily.
Financial News & Regulation
Apr 24, 2026Holding Government Contractors Accountable for Wrongdoing
Jan 21, 2025Argus Information and Advisory Services, a subsidiary of TransUnion, has agreed in writing that it will not seek any government contract with the Consumer Financial Protection Bureau for three years.
Blog | Consumer Financial Protection BureauStrengthening Appraisal Oversight: Progress at the Appraisal Subcommittee
Jan 17, 2025CFPB Deputy Director Zixta Martinez discusses changes at the ASC since she became Chair in 2022, including enhanced state oversight, landmark hearings on appraisal bias, and improved collaboration with The Appraisal Foundation to create a more equitable and accountable appraisal industry.
Blog | Consumer Financial Protection BureauBack from the Dead: Zombie Second Mortgages
Jan 17, 2025Forgotten second mortgages may be coming back to haunt homeowners who haven’t received notices or account statements for years.
Blog | Consumer Financial Protection BureauHeadlines sourced from government agencies and legal publications. Updated every 12 hours.
Did You Know?
BNPL (Buy Now, Pay Later) usage tripled between 2020 and 2025, with over 40% of U.S. consumers having used it.
Cost of living varies dramatically: the same salary goes 30-50% further in states like Texas or Tennessee vs. California or New York.
The average 401(k) balance hit $118,600 in 2025, though the median is much lower at $35,286.
Roughly 40% of small businesses fail within the first 5 years, with cash flow problems being the #1 cause.