Accounts Receivable Aging Calculator
Analyze AR aging buckets and calculate days sales outstanding (DSO).
Inputs
$
$
$
$
$
$
Results
Days Sales Outstanding
36.5 days
Current %50%
31-60 Days %24%
61-90 Days %16%
90+ Days %10%
Estimated Bad Debt Allowance$38,000.00
AR Turnover Ratio10
How to Use This Calculator
- Enter your total accounts receivable balance.
- Break out the balance into aging buckets: current (0–30 days), 31–60, 61–90, and 90+ days past due.
- Review the aging percentages and the weighted average days outstanding.
- Compare the 90+ day bucket against your reserve for doubtful accounts.
- Use the output to prioritize collection calls — start with the largest overdue balances.
How the result changes with Annual Revenue
| Annual Revenue | Days Sales Outstanding |
|---|---|
| $100,000,001.00 | 1.8 days |
| $350,000,001.00 | 0.5 days |
| $650,000,000.00 | 0.3 days |
| $900,000,000.00 | 0.2 days |
What each input means
- Total AR Balance
- Total outstanding accounts receivable balance.
- Current (0-30 days)
- AR balance within payment terms.
- 31-60 Days Past Due
- AR balance 31-60 days past due.
- 61-90 Days Past Due
- AR balance 61-90 days past due.
- 90+ Days Past Due
- AR balance over 90 days past due.
- Annual Revenue
- Total annual credit sales revenue.
How this is calculated
Worked example, using the default values
- Identify Input Parameters4 parametersTotal AR Balance = 500000, Current (0-30 days) = 250000, 31-60 Days Past Due = 120000, 61-90 Days Past Due = 80000 = 6 input(s) provided
- Calculate Days Sales OutstandingDays Sales Outstanding36.5 = 36.5
- Calculate Current %50 = 50
- Calculate 31-60 Days %24 = 24
Engine last updated . Checked against 1 independently-derived test — how we verify calculators.
Related Calculators
The questions that sit next to this one — chosen by subject, including calculators filed under a different category.
Accounting
Cash Conversion Cycle Calculator
Calculate the cash conversion cycle: DIO + DSO - DPO.
AccountingFinancial Ratio Dashboard
Calculate key liquidity, profitability, and leverage ratios from financial statements.
Amateur AstronomyDeep Sky Finder Calculator
Estimate how many galaxies, nebulae, and star clusters are observable with your telescope from your location.
AccountingBreak-Even Units Calculator
Calculate the number of units needed to cover fixed and variable costs.
More in Tax & Accounting.