Accounts Receivable Aging Calculator
Categorize outstanding invoices by age and estimate your bad debt allowance based on historical default rates. Critical for credit management and accurate financial reporting.
About this calculator
Accounts receivable aging is a method of sorting outstanding customer balances into time buckets — current, 31–60 days, 61–90 days, and over 90 days past due — to identify collection risk. The older a balance, the lower the probability of collection. To estimate the allowance for doubtful accounts, a single blended bad debt rate is applied to total outstanding receivables: Bad Debt Allowance = (Current + 31–60 Days + 61–90 Days + Over 90 Days) × (Bad Debt Rate / 100). A more sophisticated approach assigns different rates to each age bucket — typically 1–2% for current balances rising to 50%+ for accounts over 90 days. This calculator uses a single historical rate as a practical starting point. The result supports the balance sheet entry for the allowance for doubtful accounts and helps management prioritize collections efforts where recovery is still likely.
How to use
Suppose current receivables = $50,000, 31–60 days = $20,000, 61–90 days = $8,000, over 90 days = $4,000, and your historical bad debt rate = 3%. Step 1 — Total receivables: $50,000 + $20,000 + $8,000 + $4,000 = $82,000. Step 2 — Apply the formula: $82,000 × (3 / 100) = $82,000 × 0.03 = $2,460. Your estimated bad debt allowance is $2,460, which should be recorded as a contra-asset on the balance sheet and expensed in the current period.
Frequently asked questions
How does accounts receivable aging help with cash flow management?
An aging report gives you a real-time picture of which customers are slow to pay and how much revenue is at risk of never being collected. By identifying overdue balances early, your team can prioritize collection calls on accounts that are past due but still recoverable. Consistently monitoring aging also reveals patterns — such as specific customers or industries that habitually pay late — allowing you to tighten credit terms proactively. Tighter collections directly reduce the cash conversion cycle and improve working capital.
What is a reasonable bad debt rate to use for the allowance calculation?
A reasonable bad debt rate depends heavily on your industry, customer base, and credit policy. Business-to-business companies with vetted customers might experience rates of 0.5–2%, while businesses extending credit to consumers or in volatile industries may see 3–6% or higher. The most accurate approach is to analyze your own historical write-off data over three to five years and calculate the percentage of total invoiced revenue that was ultimately uncollected. Adjusting this rate upward during economic downturns is also considered prudent accounting practice.
When should a business write off an account receivable as uncollectable?
A receivable is typically written off when all reasonable collection efforts have been exhausted and there is no realistic expectation of payment. Common thresholds include balances unpaid for more than 180 days, customers who have declared bankruptcy, or accounts where legal collection costs would exceed the balance owed. Under the allowance method used in GAAP accounting, the write-off reduces both the allowance for doubtful accounts and the gross receivable balance, with no additional income statement impact at the time of write-off. Businesses should document their collection efforts thoroughly before writing off any balance for audit and tax purposes.