Percentage-of-sales approach and percentage-of-receivables approach
3.1. Calculating allowance under percentage-of-receivable approach
The rate can be estimated either as a composite rate (i.e., total uncollected amounts divided by total gross receivables) or as a set of rates based on the aging of accounts receivable. The first one – composite rate – is self-explanatory and may not be as accurate as the second one – a set of rates based on receivables aging. Thus, we will review the accounts receivable aging method in more detail.
Accounts receivable aging represents a schedule showing how long amounts comprising the total accounts receivable balance have been outstanding.
An example of such aging for Company XYZ as of December 31, 20X2 is provided below:
Customer |
Total |
Current |
31-60 |
61-90 |
91-120 |
121+ |
Customer A |
14,000 |
14,000 |
||||
Customer B |
50,000 |
50,000 |
||||
Customer C |
6,000 |
6,000 |
||||
Customer D |
3,000 |
3,000 |
||||
Customer E |
26,000 |
26,000 |
||||
Customer F |
1,000 |
1,000 |
||||
Total |
$ 100,000 |
$ 76,000 |
$ 14,000 |
$ 6,000 |
$ 3,000 |
$ 1,000 |
(*) The total balance column equals the sum of amounts in columns to the right.
Most accounting software packages are capable of producing such aging reports (and if not, maybe a different accounting software package should be considered).
This aging report can be summarized by aging “buckets” as follows:
Aging Bucket |
Amount |
Current |
76,000 |
31-60 Days |
14,000 |
61-90 Days |
6,000 |
91-120 Days |
3,000 |
121+ Days |
1,000 |
Total |
$ 100,000 |
This aging report shows that amounts which are current (i.e., not overdue) equal $76,000; amounts which are overdue by 31-60 days equal $14,000; and so forth. The total gross accounts receivable balance is $100,000.
Next, to calculate the required balance in the allowance for doubtful accounts, Company XYZ needs to apply rates of uncollectable amounts. Assume that the company determined (based on prior experience with collecting outstanding amounts from customers) that the percentages are 1%, 5%, 10%, 25%, and 50% for respective aging “buckets.” The company can estimate the allowance for doubtful accounts as follows:
Aging Bucket |
Amount |
Rate |
Allowance |
A |
B |
C = A x C |
|
Current |
76,000 |
1% |
760 |
31-60 Days |
14,000 |
5% |
700 |
61-90 Days |
6,000 |
10% |
600 |
91-120 Days |
3,000 |
25% |
750 |
121+ Days |
1,000 |
50% |
500 |
Total |
$ 100,000 |
$ 3,310 |
For example, the allowance amount for the current “bucket” is $760 = $76,000 x 1%. You can also see that the rate increases with the aging of accounts receivable. That appears logical because the longer an amount is outstanding from a customer, the less probable it is that the amount will be collected.
Note: A company is not required to utilize the same aging “buckets” as those provided in our example. In addition, the rates for different aging “buckets” provided in the table above will differ from one company to another because such rates depend on the company’s experience with accounts receivable collections.
Finally, assume that before any adjustments the balance in allowance for doubtful accounts of Company XYZ at December 31, 20X2 was $350. The balance that should be in this account after the adjusting entry equals $3,310 (see table above). Thus, the company should make such an adjustment so that the balance becomes $3,310:
$2,960 = $3,310 - $350
And the journal entry that Company XYZ would post is as follows:
Account Titles |
Debit |
Credit |
Bad Debt Expense |
$2,960 |
|
Allowance for Doubtful Accounts |
$2,960 |
When a particular account becomes uncollectible in a later period, the company will write it off against this allowance balance. For instance, if during 20X3 the company learnt that the $1,000 balance due from Customer F became uncollectable, the company would make the following entry:
Account Titles |
Debit |
Credit |
Allowance for Doubtful Accounts |
$1,000 |
|
Accounts Receivable |
$1,000 |
As with the percentage-of-sales approach, the percentage-of-receivables approach only impacts the income statement when the allowance of doubtful accounts is adjusted (i.e., uncollectible balance is estimated). When a particular account becomes uncollectible and is written off, there is no impact on the income statement. The percentage-of-receivable approach satisfies requirements of the matching principle as well, even though it may not be as precise in terms of matching revenues and bad debt expenses as the percentage-of-sales approach.
- What is the relationship between accounting period assumption and matching principle?
- How to analyze accounts receivable
- What are notes receivable?
- Accounting for deferred financing costs
- What is meant by materiality in accounting?
- Ten reasons working capital requirements can increase
- 15 most popular articles on Simplestudies.com