How to Use This Calculator
- 1
Enter Receivables by Aging Bucket
Input the dollar amount outstanding in each aging category: 0-30, 31-60, 61-90, 91-120, and over 120 days.
- 2
Provide Allowance for Doubtful Accounts
Enter the reserve your business has set aside for accounts that may not be collected.
- 3
Optionally Expand Advanced Options
Click 'Show advanced options' to enter Bad Debt Expense, Collection Expenses, Credit Sales, Average and Industry Collection Periods, Risk-Free Rate, and Customer Credit Rating for deeper analysis.
- 4
Review Your Receivables Health
Examine the Net Realizable Value, High Risk Receivables, Collection Efficiency, Days Sales Outstanding, Allowance Adequacy, and Bad Debt Ratio. The Receivables Health Assessment panel shows allowance coverage, credit-adjusted risk, and collection cost efficiency. The pie chart and table break down aging distribution by bucket.
Example Calculation
A manufacturing business wants to analyze its accounts receivable health with $210,000 in total receivables across five aging buckets.
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
Results
Net Realizable Value
$202,000.00
High Risk Receivables
$40,000.00
Collection Efficiency
80.95%
Days Sales Outstanding
76.7 days
Allowance Adequacy
20.00%
Bad Debt Ratio
0.50%
Insights card shows receivables health assessment with allowance coverage, credit-adjusted risk, and collection cost efficiency.
Tips
Benchmark Your DSO Regularly
Compare your Days Sales Outstanding against industry averages. With a DSO of 76.7 days vs. a 40-day industry average, this business has $210,000 tied up in receivables that should be closer to $110,000 — freeing $100,000 in working capital.
Increase Allowance for High-Risk Accounts
The Allowance Adequacy metric shows coverage of high-risk receivables. At 20% coverage ($8,000 allowance on $40,000 high-risk), this business should consider increasing to at least 50% ($20,000) to accurately reflect net realizable value.
Focus on the 61-90 Day Bucket
Collectibility drops significantly after 90 days. The $45,000 in 61-90 day receivables (21.4% of total) should receive urgent collection attention — automated reminders and early payment discounts can recover 15-20% more than waiting.
Monitor Credit-Adjusted Risk
Expand advanced options to set your Customer Credit Rating. A B-rated customer base has 19.0% adjusted collection risk, but a C-rated base would increase that to 24.8% — signaling the need for tighter credit terms.
Optimizing Cash Flow with Aged Receivables Analysis
The Aged Receivables Analysis Calculator provides businesses with critical insights into the health and collectibility of outstanding invoices.
By categorizing accounts receivable into aging buckets (0-30, 31-60, 61-90, 91-120, and over 120 days), companies can identify overdue payments, assess collection risk, and manage cash flow proactively.
Key outputs include Net Realizable Value, Days Sales Outstanding (DSO), Collection Efficiency, Allowance Adequacy, and credit-adjusted risk assessment.
In 2026, with receivables over 90 days carrying a 19% high-risk rate in this example, understanding these metrics is essential for sound financial management.
Why Aged Receivables Analysis Matters
Understanding the age of accounts receivable directly impacts working capital and liquidity.
Without proper analysis, a business might overestimate available cash, leading to poor decisions or inability to cover expenses.
A DSO of 76.7 days when the industry averages 40 days means $100,000+ in unnecessary capital tied up.
Proactive management can prevent bad debt, reduce collection costs, and ensure steady cash flow for operations, supplier payments, and growth — without relying on external financing.
The Financial Mechanics of Receivables Aging
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)
Collection Efficiency = ((Total - High Risk) / Total) × 100
Days Sales Outstanding (DSO) = (Total Receivables / Credit Sales) × 365
Allowance Adequacy = (Allowance / High Risk Receivables) × 100
Bad Debt Ratio = (Bad Debt Expense / Credit Sales) × 100
Worked Example: Analyzing a Manufacturing Business
A manufacturing company has the following outstanding receivables: $50,000 (0-30 days), $75,000 (31-60 days), $45,000 (61-90 days), $25,000 (91-120 days), and $15,000 (over 120 days).
The Allowance for Doubtful Accounts is $8,000, with $5,000 in Bad Debt Expense, $3,000 in Collection Expenses, and $1,000,000 in Credit Sales.
- Calculate Total Receivables:
$50,000 + $75,000 + $45,000 + $25,000 + $15,000 = $210,000 - Determine Net Realizable Value:
$210,000 - $8,000 = $202,000 - Identify High Risk Receivables:
$25,000 + $15,000 = $40,000 (19.0% of total) - Calculate Collection Efficiency:
($210,000 - $40,000) / $210,000 × 100 = 80.95% - Compute Days Sales Outstanding:
($210,000 / $1,000,000) × 365 = 76.65 days - Calculate Allowance Adequacy:
($8,000 / $40,000) × 100 = 20.00% - Calculate Bad Debt Ratio:
($5,000 / $1,000,000) × 100 = 0.50%
The Net Realizable Value is $202,000.
The DSO of 76.7 days (vs. 40-day industry average) signals a need for improved collection strategies.
The 20% Allowance Adequacy is low — increasing to at least 50% ($20,000) would better reflect expected losses.
The 0.50% Bad Debt Ratio is healthy.
Industry Benchmarks for Receivables Health
DSO varies significantly by industry: technology companies typically target 20-30 days (subscription models), manufacturing 45-60 days (project cycles), healthcare 60-90 days (insurance processing), and construction 60-90 days (milestone billing).
High-risk receivables (over 90 days) should ideally stay below 10-15% of total.
A bad debt ratio under 2% is considered healthy across most sectors.
Regularly comparing against industry-specific benchmarks helps identify areas for improvement in credit and collection policies.
Frequently Asked Questions
What is Net Realizable Value in accounts receivable?
Net Realizable Value (NRV) is the amount of receivables a company expects to actually collect — total receivables minus the allowance for doubtful accounts. For $210,000 in receivables with an $8,000 allowance, NRV is $202,000. This provides a realistic picture of expected cash inflows.
Why are Days Sales Outstanding (DSO) important?
DSO measures the average days to collect payment after a sale. A DSO of 76.7 days (vs. a 40-day industry average) means this business takes nearly twice as long to collect. Lower DSO means better cash flow — a healthy range is 30-45 days for most B2B operations.
What is an acceptable Bad Debt Ratio?
A bad debt ratio of 0.5-2% of credit sales is considered healthy. This business's 0.50% ratio ($5,000 on $1,000,000 in credit sales) is at the low end — indicating effective credit screening. Ratios consistently above 3% suggest overly lenient credit policies.
How does customer credit rating affect collection risk?
The credit rating multiplier adjusts raw high-risk percentages: A-rated (×0.8) reduces risk, B-rated (×1.0) is neutral, C-rated (×1.3) and D-rated (×1.6) increase it. With 19.0% high-risk receivables, a B-rated portfolio stays at 19.0% adjusted risk, while D-rated jumps to 30.5%.
What does Allowance Adequacy mean?
Allowance Adequacy measures what percentage of high-risk receivables (over 90 days) is covered by the allowance for doubtful accounts. At 20%, only $8,000 of $40,000 in high-risk receivables is provisioned — best practice is 50-75% coverage to avoid write-off surprises.