Skip to content
Omnikalc

Allowance for doubtful accounts calculator (aging of receivables): required allowance and adjustment

Enter the receivables by age group, the uncollectible rate for each group and the current allowance balance to get the required allowance, the bad debt expense to record and the net realizable value.

Updated on
Your inputs
$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

%

Value out of range

%

Value out of range

%

Value out of range

%

Value out of range

%

Value out of range

$

Value out of range

Results

Required allowance for doubtful accounts

$35,450

Bad debt expense to record (adjustment)
$17,450
Total accounts receivable
$705,000
Allowance as a share of receivables
5.03 %
Net realizable value of the receivables
$669,550

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.

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.

Frequently asked questions

What is the allowance for doubtful accounts?

The allowance for doubtful accounts is a contra-asset account that reduces the accounts receivable on the balance sheet to the amount that the company expects to collect. It follows the matching principle: the estimated loss from customers who will not pay is recorded as an expense in the same period as the sale, and not later when the debt is written off. The net of the receivables and the allowance is the net realizable value.

How does the aging method work?

The aging method groups the receivables by the number of days they are past due, and applies a higher estimated uncollectible rate to the older groups, since the probability of collection falls over time. The sum of the amounts times the rates is the required balance of the allowance. The method is balance-sheet based, so the expense is the amount needed to bring the existing balance of the allowance to the required balance.

How do I find the bad debt expense?

The bad debt expense is the required allowance minus the current credit balance of the allowance account. If the account has a debit balance, which happens when write-offs exceed the allowance, add the debit balance to the required allowance. The calculator accepts a negative balance for a debit balance. The adjusting entry debits the bad debt expense and credits the allowance.

Where do the percentages come from?

They come from the history of collections of the company, adjusted for the current economic conditions, the quality of the customers and the changes in credit policy. Many companies update them every year by comparing the estimated losses with the actual write-offs. The rates in the calculator are examples, and you should replace them with your own. Under the current accounting standard for credit losses (CECL in the US), the estimate also considers the expected future conditions.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.