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.
- 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
| Bucket | Receivables | Loss rate | Allowance |
|---|---|---|---|
| 1 | $50,000.00 | 1% | $500.00 |
| 2 | $20,000.00 | 5% | $1,000.00 |
| 3 | $8,000.00 | 20% | $1,600.00 |
| 4 | $4,000.00 | 50% | $2,000.00 |
Formula
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:
- Required allowance: $5,100.00
- Total receivables: $82,000.00
- Net realizable value: $76,900.00
- Allowance as % of receivables: 6.22%
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
- Days Sales Outstanding (DSO) CalculatorCalculate days sales outstanding and receivables turnover from accounts receivable and credit sales.
- Current Ratio and Working Capital CalculatorCalculate working capital, current ratio and quick ratio from current assets, inventory and current liabilities.
- Accrued Interest CalculatorCalculate interest accrued on a loan or note for a number of days, on a 365-day or 360-day basis.
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.