9.7: Appendix- Comprehensive Example of Bad Debt Estimation

Last updated
Save as PDF

Page ID: 10034

$ \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } $ $ \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} $$\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$ $\newcommand{\id}{\mathrm{id}}$ $ \newcommand{\Span}{\mathrm{span}}$ $ \newcommand{\kernel}{\mathrm{null}\,}$ $ \newcommand{\range}{\mathrm{range}\,}$ $ \newcommand{\RealPart}{\mathrm{Re}}$ $ \newcommand{\ImaginaryPart}{\mathrm{Im}}$ $ \newcommand{\Argument}{\mathrm{Arg}}$ $ \newcommand{\norm}[1]{\| #1 \|}$ $ \newcommand{\inner}[2]{\langle #1, #2 \rangle}$ $ \newcommand{\Span}{\mathrm{span}}$$\newcommand{\AA}{\unicode[.8,0]{x212B}}$

The following comprehensive example will illustrate the bad debt estimation process from the sales transaction to adjusting entry reporting for all three bad debt estimation methods: income statement, balance sheet, and balance sheet aging of receivables.

Furniture Direct sells office furniture to large scale businesses. Because the purchases are typically large, Furniture Direct allows customers to pay on credit using an in-house account. At the end of the year, Furniture Direct must estimate bad debt using one of the three estimation methods. It is currently using the income statement method and estimates bad debt at 5% of credit sales. If it were to switch to the balance sheet method, it would estimate bad debt at 8% of accounts receivable. If it were to use the balance sheet aging of receivables method, it would split its receivables into three categories: 0–30 days past due at 5%, 31–90 days past due at 10%, and over 90 days past due at 20%. There is currently a zero balance, transferred from the prior year’s Allowance for Doubtful Accounts. The following information is available from the year-end income statement and balance sheet.

2018 Year-end Totals for Furniture Direct: Credit sales $1,350,000, Accounts Receivable 745,000.

There is also additional information regarding the distribution of accounts receivable by age.

Past Due Category and Accounts Receivable Total, respectively: 0–30 days $485,000; 31–90 days 180,000; Over 90 days 80,000.

If the company were to maintain the income statement method, the total bad debt estimation would be $67,500 ($1,350,000 × 5%), and the following adjusting entry would occur.

Journal entry: December 31 debit Bad Debt Expense 67,500, credit Allowance for Doubtful Accounts 67,500. Explanation: “To record estimated bad debts, income statement method.”

If the company were to use the balance sheet method, the total bad debt estimation would be $59,600 ($745,000 × 8%), and the following adjusting entry would occur.

Journal entry: December 31 debit Bad Debt Expense 59,600, credit Allowance for Doubtful Accounts 59,600. Explanation: “To record estimated bad debts, balance sheet method.”

If the company were to use the balance sheet aging of receivables method, the total bad debt estimation would be $58,250, calculated as shown:

Past Due Category and Accounts Receivable Total, Uncollectible Percentage, Total respectively: 0–30 days $485,000, 5 percent, $24,250; 31–90 days 180,000, 10 percent, 18,000; Over 90 days 80,000, 20 percent, 16,000; Total Estimated Uncollectible: $58,250.

The adjusting entry recorded using the aging method is as follows.

Journal entry: December 31 debit Bad Debt Expense 58,250, credit Allowance for Doubtful Accounts 58,250. Explanation: “To record estimated bad debts, balance sheet aging method.”

As you can see, the methods provide different financial figures.

Bad Debt Estimation Method Comparison for Furniture Direct: Income Statement Method $67,500; Balance Sheet Method 59,600; Balance sheet Aging of Receivables Method 58,250.

While it is up to the company to determine which method best describes its financial position, as you see in Account for Uncollectible Accounts Using the Balance Sheet and Income Statement Approaches, a company may manage these methods and figures to present the best financial position possible.

CONTINUING APPLICATION

Grocery Store Offerings

Every week, millions of shoppers visit grocery stores. Consider the various transactions that are occurring at any given time. Most of the items found within a grocery store are perishable and have a finite shelf life. The majority of purchases are paid with cash, check, or credit card. Therefore, you might assume that a grocery store would not have a balance in accounts receivable.

However, grocery stores have evolved to become a one-stop shop for many items. You can now purchase gas, seasonal decorations, cooking utensils, and even fill your prescriptions at many stores.