Allowance for Doubtful Accounts Calculator

Example scenario

Using aging with $142,000 in receivables and loss rates of 0%, 1%, 5%, 15%, and 40% across buckets, the allowance totals approximately $9,370, yielding net realizable value of $132,630 and an effective rate of 6.

Sample inputs

Estimation method: percentage
Total receivables ($): 142000
Estimated uncollectible (%): 3
Current bucket ($): 85000

Sample results

Method: See calculator result
Allowance for doubtful accounts ($): See calculator result
Net realizable value ($): See calculator result

Common mistakes

Misunderstanding: Which method should I use — Aging is more precise when you have reliable historical loss data by bucket.
Misunderstanding: How do I determine loss rates for each bucket — Analyze 3–5 years of write-off data by aging category.
Using default inputs without adjusting them to match your allowance for doubtful accounts calculator scenario.
Treating this estimate as a final number without checking accounting assumptions that apply to your situation.

Decision guide

The allowance for doubtful accounts (contra-asset) reduces accounts receivable to net realizable value on the balance sheet. Use the result as a planning checkpoint — not a substitute for professional advice where rules are complex.

Trust the projection more when

Select the estimation method: percentage of receivables or aging-based
For the percentage method, enter total receivables and your estimated uncollectible rate
For the aging method, enter each bucket balance and the historical loss rate for that bucket

Revisit inputs when

Review the computed allowance, net realizable value, and effective uncollectible percentage
Compare the allowance to prior periods and actual write-off history before posting bad debt expense
Your jurisdiction, tax status, or contract terms differ from the example.

The allowance for doubtful accounts (contra-asset) reduces accounts receivable to net realizable value on the balance sheet. Under US GAAP and IFRS, entities must estimate expected credit losses. This calculator supports two common approaches: a flat percentage of total receivables and aging-based loss rates applied to each delinquency bucket.

How to use this calculator

Select the estimation method: percentage of receivables or aging-based.
For the percentage method, enter total receivables and your estimated uncollectible rate.
For the aging method, enter each bucket balance and the historical loss rate for that bucket.
Review the computed allowance, net realizable value, and effective uncollectible percentage.
Compare the allowance to prior periods and actual write-off history before posting bad debt expense.

Formula

Percentage method: Allowance = Total receivables × Uncollectible %. Aging method: Allowance = Σ (Bucket balance × Bucket loss rate). Net realizable value = Total receivables − Allowance. Effective uncollectible % = (Allowance ÷ Total receivables) × 100.

Example

Frequently asked questions

Which method should I use?

Aging is more precise when you have reliable historical loss data by bucket. The flat percentage method works for smaller operations with stable write-off patterns. ASC 326 (CECL) may require forward-looking adjustments beyond historical rates.

How do I determine loss rates for each bucket?

Analyze 3–5 years of write-off data by aging category. Divide historical write-offs in each bucket by the average receivable balance in that bucket to derive empirical loss rates.

What journal entry does this produce?

If the allowance increases: Debit Bad Debt Expense, Credit Allowance for Doubtful Accounts. The calculator estimates the reserve — your controller posts the adjusting entry.

Does this comply with CECL?

This is a planning tool using simplified methods. CECL under ASC 326 requires lifetime expected credit losses with forward-looking factors. Consult your auditor for formal compliance.

Allowance for Doubtful Accounts Calculator