Rounding Robin

Home › Accounting › Allowance for Doubtful Accounts Calculator

Allowance for Doubtful Accounts Calculator

Enter the receivables in each aging bucket and the expected loss percentage for each, in the same order.

$
Required allowance$5,100.00
Total receivables
$82,000.00
Net realizable value
$76,900.00
Allowance as % of receivables
6.22%
Bad debt expense to record
$5,100.00
BucketReceivablesLoss rateAllowance
1$50,000.001%$500.00
2$20,000.005%$1,000.00
3$8,000.0020%$1,600.00
4$4,000.0050%$2,000.00

Formula

Allowance = Σ (Receivables in bucket × Expected loss rate)
Bad debt expense = Required allowance − Existing allowance balance

How it works

The aging method assumes the older an invoice, the less likely it is to be paid. Typical buckets are current, 31 to 60, 61 to 90 and over 90 days. Loss rates should come from your own collection history, adjusted for current conditions.

The adjusting entry brings the allowance to the required balance, so the expense is the difference from what is already there. Enter a debit balance in the allowance as a negative number.

Worked example

Using the starting figures above (Receivables by aging bucket: 50000, 20000, 8000, 4000; Expected loss % per bucket: 1, 5, 20, 50; Existing allowance balance: $0.00), the calculator returns:

Common questions

What is net realizable value?

The amount of receivables you actually expect to collect: gross receivables less the allowance. It is the figure shown on the balance sheet.

Related calculators

Something look wrong, or missing a calculator you need? Send feedback.

Results are estimates for general information. They are not financial, tax or legal advice. Check important figures with a qualified professional before acting on them.