Build your retirement plan for free.Explore Plan Builder →

Aged Receivables Analysis Calculator

Enter your receivables by aging bucket and allowance to analyze collection risk, Days Sales Outstanding, allowance adequacy, and credit-adjusted risk across your accounts receivable portfolio.
Luis GonzalezCreated by Luis GonzalezLast updated:

How to Use This Calculator

  1. 1

    Enter balances in each aging bucket

    Enter outstanding invoices in Current Receivables (0-30 Days), Receivables (31-60 Days), Receivables (61-90 Days), Receivables (91-120 Days), and Receivables (Over 120 Days). Use the same reporting date for every balance.

  2. 2

    Add collection and credit-risk assumptions

    Enter Allowance for Doubtful Accounts, Bad Debt Expense, Collection Expenses, Credit Sales, Average Collection Period (days), Industry Avg Collection Period (days), and Risk-Free Rate (%). Select the overall Customer Credit Rating.

  3. 3

    Review aging concentration and collection metrics

    Compare High Risk Receivables and Allowance Adequacy with the aging table. Days Sales Outstanding is calculated from total receivables and credit sales, not from the entered average collection period.

Example Calculation

A business has $210,000 in outstanding receivables across five aging buckets, $8,000 reserved for doubtful accounts, and $1,000,000 in credit sales for the period.

Current Receivables (0-30 Days) ($)

50,000

Receivables (31-60 Days) ($)

75,000

Receivables (61-90 Days) ($)

45,000

Receivables (91-120 Days) ($)

25,000

Receivables (Over 120 Days) ($)

15,000

Allowance for Doubtful Accounts ($)

8,000

Bad Debt Expense ($)

5,000

Collection Expenses ($)

3,000

Credit Sales ($)

1,000,000

Average Collection Period (days)

45

Industry Avg Collection Period (days)

40

Risk-Free Rate (%)

3

Customer Credit Rating

B - Good

Results

Net Realizable Value

$202,000.00

High Risk Receivables

$40,000.00 (19.0%)

Collection Efficiency

80.95%

Days Sales Outstanding

76.7 days

Allowance Adequacy

20.00%

Adjusted Collection Risk

19.05%

Risk-Adjusted Return

2.43%

Bad Debt Ratio

0.50%

Insights card shows each aging bucket’s balance, share of total, and risk level.

Tips

Moving $20,000 into the oldest buckets raises high-risk exposure to $60,000

Transfer $20,000 from Current Receivables (0-30 Days) to Receivables (Over 120 Days), keeping total receivables unchanged. High Risk Receivables rises from $40,000 to $60,000, and the high-risk share rises from 19.05% to 28.57%.

Customer rating changes the adjusted risk indicator, not invoice balances

Change Customer Credit Rating from B - Good to D - Poor. The adjusted-risk multiplier rises from 1.0 to 1.6, so the displayed adjusted risk increases even though the aging buckets do not change.

Compare collection speed with the benchmark you enter

Change Industry Avg Collection Period from 40 to 50 days. The entered 45-day Average Collection Period will then be 5 days below that benchmark instead of 5 days above it.

What this calculator measures

Aged receivables are unpaid customer balances grouped by the time they have been outstanding. This calculator totals the aging buckets and estimates net realizable value, overdue concentration, collection metrics, and selected risk indicators; these outputs are management estimates, not a determination that a balance is collectible or uncollectible.

How the calculation works

Total receivables = Sum of all aging buckets
Net realizable value = Total receivables − Allowance for doubtful accounts
High-risk receivables = Receivables 91–120 days + Receivables over 120 days
High-risk share = High-risk receivables / Total receivables × 100
Collection efficiency = (Total receivables − High-risk receivables)
                       / Total receivables × 100
Days sales outstanding = Total receivables / Credit sales × 365
Allowance adequacy = Allowance / High-risk receivables × 100
Bad debt ratio = Bad debt expense / Credit sales × 100

For the example, total receivables are $50,000 + $75,000 + $45,000 + $25,000 + $15,000 = $210,000. Net realizable value is $210,000 − $8,000 = $202,000. High-risk receivables are $25,000 + $15,000 = $40,000, or $40,000 ÷ $210,000 × 100 = 19.05% of the total.

Days sales outstanding is $210,000 ÷ $1,000,000 × 365 = 76.65 days, displayed as 76.7 days. The entered average collection period and industry average are used for the comparison subheader; they do not replace the calculator’s DSO formula.

How aging concentration changes the risk picture

These scenarios keep total receivables at $210,000 and change only how much is more than 90 days old.

Receivables over 90 days Share of total Allowance Allowance coverage of high-risk balances
$40,000 19.05% $8,000 20.00%
$60,000 28.57% $8,000 13.33%
$80,000 38.10% $8,000 10.00%

A rising old-balance share can justify prioritizing customer contact and reviewing disputed invoices, but the appropriate allowance depends on evidence such as historical losses and subsequent collections. The calculator’s allowance adequacy ratio is a simple coverage comparison, not a prescribed accounting benchmark.

Interpreting the risk indicators

The Customer Credit Rating adjustment is a heuristic: the calculator multiplies the share of receivables over 90 days by a rating factor. It does not score individual customers or estimate a probability of default. The Risk-Adjusted Return similarly reduces the entered risk-free rate according to the high-risk share; it is not an investment return or a measure of expected cash collections.

Use the aging table to choose collection actions: contact owners of older balances, verify invoice delivery, resolve disputes, and document payment commitments. For a turnover-based view of collections, compare the receivables turnover ratio calculator or the accounts receivable days calculator. For related business metrics, use the financial ratio analysis calculator.

When to use a different calculator

Frequently Asked Questions

What is an aged receivables analysis?

An aged receivables analysis groups unpaid customer invoices by how long they have been outstanding. It helps a business identify overdue balances and prioritize follow-up, but aging alone does not establish that an invoice will be collected or written off.

How do I calculate days sales outstanding?

1. Add the outstanding receivables balances. 2. Divide the total by credit sales for the period. 3. Multiply by 365 days. This calculator uses that formula, so use a credit-sales figure that matches the period and reporting basis of the receivables data.

What is a good allowance adequacy percentage?

There is no universal target because expected credit losses depend on customer mix, payment history, economic conditions, and the aging profile. Here, Allowance Adequacy is the allowance divided by balances more than 90 days old, so compare it with your own loss history and accounting policy rather than treating a particular percentage as a standard.

Does high-risk receivables mean the invoices will become bad debt?

No, it is a screening label for balances aged 91 days or more, not a prediction that those balances are uncollectible. Review individual invoices, disputes, customer payment history, and subsequent receipts before deciding what to reserve or write off.

Is this calculator's allowance a complete accounting estimate?

No, it uses a simplified aging-based coverage ratio and does not apply a formal expected-credit-loss model. The U.S. Small Business Administration’s guide to managing business finances offers practical cash-flow guidance, but financial-statement estimates should follow the accounting rules that apply to your business.