The allowance for doubtful accounts is the part of the receivables that the company does not expect to collect. The allowance for doubtful accounts calculator uses the aging method to find the required allowance, the bad debt expense to record, the allowance as a share of receivables and the net realizable value.
How the calculation works
- Enter the amounts of receivables from the aging report, in the five groups: not yet due, 1–30, 31–60, 61–90 and more than 90 days past due.
- Enter the estimated uncollectible rate of each group, based on your past experience. Older groups have higher rates.
- Enter the current balance of the allowance account (a credit balance), which is the amount already set aside.
- The calculator gives the required allowance, the bad debt expense to record to reach it, and the net realizable value of the receivables.
Example
The aging report shows $420,000 not yet due, $150,000 at 1–30 days, $80,000 at 31–60, $35,000 at 61–90 and $20,000 over 90 days, with rates of 1 %, 3 %, 10 %, 25 % and 50 %. The required allowance is 4,200 + 4,500 + 8,000 + 8,750 + 10,000 = $35,450, or 5.03 % of the $705,000 of receivables. The allowance has a credit balance of $18,000, so the bad debt expense to record is $17,450. The net realizable value is $669,550.
Why it matters
The calculator helps bookkeepers, accountants, controllers and students to prepare the month-end or year-end adjusting entry for bad debts, to see the effect of a slowdown in customer payments and to compare the allowance with the receivables. It saves the long spreadsheet work of the aging analysis.
Good to know
The calculator uses the aging method with five groups and fixed rates. It does not specify the write-off of individual accounts, the recoveries, the specific identification of problem customers or the expected credit loss models for large companies. The rates must come from your own experience. Tax rules on bad debt deductions can differ from the accounting treatment.
Related tools
The cash conversion cycle calculator measures the time to turn the cash into inventory and receivables and back, the current ratio calculator measures short-term liquidity, the inventory turnover calculator measures the speed of the stock, and the working capital calculator gives the short-term funds.