Calculator
Accounts Receivable Aging Calculator
Calculate days sales outstanding and estimate bad debt exposure from an accounts receivable aging schedule.
AnswerCanvas Calculator
Accounts Receivable Aging Calculator
Estimated bad debt exposure
$8,050.00
28.7% of the $203,500.00 total AR balance is past due.
- Total accounts receivable
- $203,500.00
- % past due
- 28.7%
- Estimated bad debt exposure
- $8,050.00
- Over 90 days (highest risk)
- $6,500.00
Result chart
Formula
Estimated bad debt reserve applies increasing collection-risk percentages to each aging bucket (illustrative reference rates: ~1% for current, ~5% for 31-60 days, ~15% for 61-90 days, ~40% for over 90 days) - the older a receivable, the LESS likely it is to ever be collected, which is why bad debt reserve percentages increase sharply with age. Your specific business's actual historical collection rates by aging bucket may differ from these illustrative reference percentages.
Worked example
$145,000 current + $38,000 (31-60 days) + $14,000 (61-90 days) + $6,500 (over 90 days), totaling $203,500 AR: about 28.7% is past due, with estimated bad debt exposure of about $8,050.
Money-page insight
The dramatic increase in bad-debt-risk percentage as receivables age (from roughly 1% for current to 40%+ for over-90-days in this illustration) reflects a well-established collections reality - the LONGER an invoice goes unpaid, the LESS likely it ever gets collected, which is exactly why proactive, early collections follow-up (before receivables age into the higher-risk buckets) is one of the most effective ways to actually improve cash collection rates, rather than waiting and hoping older receivables eventually get paid.
Calculation history
Stored locally on this deviceHow the accounts receivable aging calculator works
How to use this calculator
Adjust the assumptions on the left and the result updates instantly. Use the summary as a planning estimate, then compare it with quotes, local rules, lender disclosures, or professional guidance for decisions involving taxes, loans, construction, or health.
Learn more
Stage 1 - Inputs
Collect the required accounts receivable aging and bad debt exposure values and confirm that each value is physically and logically possible.
Stage 2 - Formula
Estimated bad debt reserve applies increasing collection-risk percentages to each aging bucket (illustrative reference rates: ~1% for current, ~5% for 31-60 days, ~15% for 61-90 days, ~40% for over 90 days) - the older a receivable, the LESS likely it is to ever be collected, which is why bad debt reserve percentages increase sharply with age. Your specific business's actual historical collection rates by aging bucket may differ from these illustrative reference percentages.
Stage 3 - Substitute values
Replace each variable in the formula with the current input value. This keeps the calculation transparent and easy to audit.
Stage 4 - Intermediate calculations
Calculate the supporting values first, such as totals, rates, balances, volumes, or ratios, before producing the final result.
Common mistakes
- Mixing units, such as monthly and annual rates, inches and feet, or gross and net income
- Entering rounded guesses when exact quotes or measurements are available
- Ignoring fees, taxes, risk factors, local rules, or physical constraints
- Treating an estimate as a final professional decision
Tips
- Change one input at a time to understand sensitivity
- Use conservative assumptions when the result affects safety, debt, taxes, or health
- Save or print the result with assumptions before comparing alternatives
- Recheck units whenever a result looks surprisingly large or small
Accounts Receivable Aging Calculator mastery
Calculate days sales outstanding and estimate bad debt exposure from an accounts receivable aging schedule.
Use this business calculator as a working model: enter realistic inputs, read the primary answer first, then use the supporting rows to understand what changed and why.
Read the result correctly
Treat the primary answer as the headline result and the supporting values as the evidence trail behind it.
Improve accuracy
Small input changes can shift the output. Recheck units, time periods, percentages, and any assumptions before using the result.
Use it professionally
Save or print the result with the inputs visible so the calculation can be reviewed, repeated, or compared later.
Expert suggestions
Professional perspective
How to get more value from the accounts receivable aging calculator
A strong calculation is not only a final number. It is a repeatable way to compare choices, understand assumptions, and see which inputs deserve the most attention.
Start with a baseline
Use the most realistic inputs you have today before testing optimistic or conservative cases.
Change one variable
Adjust one assumption at a time. This makes cause and effect easier to understand.
Keep the evidence visible
Save or export the result with inputs included so the answer can be checked later.
Learning path
What to understand next
- Understand the main formula
- Review the assumptions
- Compare alternate scenarios
- Decide what information would improve accuracy
Business insight guide
Understand the answer
Use the accounts receivable aging calculator as a decision aid, not just a number.
A calculator is most useful when the result, assumptions, and practical meaning are read together. Use the output as a structured estimate and review the inputs before making a decision.
The primary answer summarizes the model. Supporting values explain the path from inputs to output and reveal which assumptions matter most.
The result usually changes when units, rates, time periods, quantities, prices, thresholds, or rounding assumptions change.
Confirm that each input uses the intended unit, time period, percentage basis, and sign. A correct formula can still produce a poor estimate from inconsistent inputs.
Use extra care when the answer affects money, health, safety, legal exposure, construction quantities, or long-term planning.
Accuracy checklist
- Confirm every unit before comparing outputs.
- Use current inputs rather than outdated estimates.
- Test at least one conservative and one optimistic scenario.
- Review whether rounding changes the practical decision.
How professionals use this
- Document the inputs beside the result.
- Compare scenarios instead of relying on a single run.
- Share the assumptions when asking for review.
- Use expert review for high-stakes decisions.
Frequently asked questions
- Why does bad debt risk increase so dramatically with receivable age?
- Customers who haven't paid within a reasonable initial period become progressively less likely to ever pay - this could reflect genuine financial distress, disputes, or simply deprioritization - this well-established pattern is exactly why aging-based bad debt reserves increase risk percentages sharply for older receivables.
- Should every business use these same illustrative percentages?
- No - these are illustrative reference rates only; your specific business's ACTUAL historical collection experience by aging bucket (tracked over time) gives a much more accurate, business-specific basis for your bad debt reserve calculation than generic reference percentages.
- How does this analysis help improve cash collection?
- Identifying which receivables are aging into higher-risk buckets highlights where PROACTIVE collections follow-up is most needed - addressing receivables before they age further (into the 60+ or 90+ day buckets, where collection likelihood drops sharply) is generally far more effective than waiting.
- What does the Accounts Receivable Aging Calculator calculate?
- Calculate days sales outstanding and estimate bad debt exposure from an accounts receivable aging schedule.
- How should I read the Accounts Receivable Aging Calculator result?
- Read the primary answer first, then review the supporting values, formula notes, assumptions, and expert suggestions. The supporting values explain why the answer moved and which inputs deserve more attention.
- Which input matters most in the Accounts Receivable Aging Calculator?
- The most important input depends on the calculator, but the highest-impact variables are usually rates, time periods, quantities, income, balance, measurements, or unit choices. Change one input at a time to see which variable drives the result.
- Why might my Accounts Receivable Aging Calculator result differ from another website?
- Different calculators may use different assumptions, rounding rules, formulas, default values, tax years, unit conversions, or included costs. Compare the formula and assumptions before comparing final answers.
- Can I use this business result for an important decision?
- Use the result as a structured estimate and learning tool. For financial, tax, medical, legal, construction, or safety-sensitive decisions, verify the inputs and review the output with a qualified professional.
- How often should I update the inputs in the Accounts Receivable Aging Calculator?
- Update the inputs whenever the underlying facts change: rates, prices, measurements, dates, balances, income, rules, or goals. Outdated inputs create outdated answers.
- What is the safest way to compare scenarios?
- Keep all inputs the same except one variable. That makes it clear whether the difference came from rate, time, quantity, price, measurement, or another assumption.