Allowance for Doubtful Accounts Calculator

How it is calculated

The tool applies one flat rate to the whole receivables balance. allowance = receivables × rate ÷ 100 and net realizable value = receivables − allowance. Receivables is the gross amount customers owe, rate is the estimated share that will never be collected, written as a percentage (4.5 for 4.5%). You supply the rate; it is not estimated from history, and a single rate is used for everything, so receivables are not aged into overdue buckets. Receivables must be above zero and the rate must lie between 0 and 100; anything outside that range shows no result, because an allowance cannot exceed the receivables. Which method and rate are acceptable for financial statements depends on the accounting framework and the company's own loss history.

Common mistakes

• Entering the rate as a decimal such as 0.045. The field takes a percentage, so 0.045 is read as 0.045% and the allowance comes out about 100 times too small.
• Applying the rate to credit sales for the year when the method is based on the receivables balance at the period end. Use the outstanding balance, not total revenue.
• Using one blended rate when old invoices are much riskier than new ones. A single rate hides the difference, so a heavily overdue book may need a higher rate than the average.
• Confusing the allowance with a write-off. The allowance is an estimate booked in advance, while a write-off removes a specific invoice once it is truly uncollectible.
• Typing a rate above 100, for example 120 instead of 12. The tool then shows no result at all instead of a negative net value.