To report realistic collectible accounts, you must estimate bad debts at the end of each period. The three main methods link bad debt expense to credit sales, accounts receivable, or the age of each unpaid invoice.
Here’s a high-level overview of each method:
Method 1 - Percentage of Sales Method
With the percentage of sales method, you estimate bad debts as a fixed percentage of your credit sales for the period. This method focuses on the income statement and matches expenses to revenue in the same period.
To find the average percentage of credit sales that became uncollectible, review past data. For example, if 2% of your $500K credit sales usually go unpaid, you record $10K as bad debt expense.
This method works well if your customer base and credit policies do not change often. It also gives you a steady way to estimate bad debts. But it does not directly adjust the allowance account to a target balance.
Method 2 - Percentage of Receivables Method
With the percentage of receivables method, you estimate bad debts as a percentage of your ending accounts receivable balance. This method focuses on the balance sheet and aims to show the correct amount of collectible accounts as you apply a set percentage to total receivables.
If, for instance, you end the year with $100K in receivables and expect 5% to be uncollectible, you set the allowance at $5K. Unlike the percentage of sales method, you adjust for the existing allowance balance. If the allowance already holds $3K, you record only the $2K difference.
Method 3 - Aging of Accounts Receivable
When using the aging of accounts receivable method, you group receivables by how long invoices remain unpaid. Older balances carry a higher risk of becoming bad debts.
A typical aging schedule looks like this:
Age Group
|
Balance
|
Estimated
Uncollectible
|
0–30 days
|
$60,000
|
1%
|
31–60 days
|
$25,000
|
5%
|
61–90 days
|
$10,000
|
10%
|
Over 90 days
|
$5,000
|
20%
|
By multiplying each balance by its risk rate and totaling the results, the total becomes your required allowance. This method gives you the most detail and highlights slow-paying customers while also helping you tighten credit terms. If you want tighter control over estimating bad debts, aging provides the strongest support.