{"id":138,"date":"2015-03-18T23:52:21","date_gmt":"2015-03-18T23:52:21","guid":{"rendered":"https:\/\/courses.candelalearning.com\/finacct2x10xmaster\/?post_type=chapter&p=138"},"modified":"2015-05-31T15:39:47","modified_gmt":"2015-05-31T15:39:47","slug":"estimating-bad-debts","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/clinton-finaccounting\/chapter\/estimating-bad-debts\/","title":{"raw":"Estimating Bad Debts","rendered":"Estimating Bad Debts"},"content":{"raw":"Estimating uncollectible accounts<\/strong> Accountants use two basic methods to estimate uncollectible accounts for a period. The first method\u2014percentage-of-sales method\u2014focuses on the income statement and the relationship of uncollectible accounts to sales. The second method\u2014percentage-of-receivables method\u2014focuses on the balance sheet and the relationship of the allowance for uncollectible accounts to accounts receivable.\r\n\r\nhttps:\/\/youtu.be\/uE-umnuyRzQ?list=PL_PmoCeUoNMIX3zP2yYSAq8gi6irBVh-1\r\n\r\nPercentage-of-sales method<\/strong> The percentage-of-sales method estimates uncollectible accounts from the credit sales of a given period. In theory, the method is based on a percentage of prior years\u2019 actual uncollectible accounts to prior years\u2019 credit sales. When cash sales are small or make up a fairly constant percentage of total sales, firms base the calculation on total net sales. Since at least one of these conditions is usually met, companies commonly use total net sales rather than credit sales. The formula to determine the amount of the ending estimated bad debts\u00a0entry is:\r\n\r\nBad Debt Expense = Net sales (total or credit) x Percentage estimated as uncollectible<\/em>\r\n\r\nTo illustrate, assume that Rankin Company\u2019s estimates uncollectible accounts at 1% of total net sales. Total net sales for the year\u00a0were $500,000; receivables at year-end were\u00a0$100,000; and the Allowance for Doubtful Accounts had a zero balance. Rankin would make the following adjusting entry\u00a0 at year end:\r\n\r\n\u00a0<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\n\n \r\n\r\nDec.<\/strong><\/td>\r\n\n\n \r\n\r\n31<\/strong><\/td>\r\n\n\n \r\n\r\nBad Debt\u00a0Expense <\/strong><\/td>\r\n\n\nDebit<\/strong>\r\n\r\n5,000<\/strong><\/td>\r\n\n\n\u00a0Credit<\/strong>\r\n\r\n <\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nAllowance for\u00a0Doubtful Accounts <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n5,000<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nTo record estimated uncollectible accounts<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n($500,000 X 1%).<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nRankin reports Bad Debt Expense on the income statement. It reports the accounts receivable less the allowance among current assets in the balance sheet as follows:\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Accounts receivable<\/strong><\/td>\r\n$100,000 <\/strong><\/td>\r\n<\/tr>\r\n
Less: Allowance for\u00a0doubtful accounts<\/strong><\/td>\r\n(5,000)<\/strong><\/td>\r\n<\/tr>\r\n
Accounts receivable, Net<\/strong><\/td>\r\n\n\n\r\n\r\n
\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$95,000<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/tr>\r\n
Or\u00a0the balance sheet could show:<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
Accounts receivable (less estimated<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
uncollectible accounts, $5,000)<\/strong><\/td>\r\n\u00a0 $95,000<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nOn the income statement, Rankin would match the\u00a0bad debt expense against sales revenues in the period. We would classify this expense as a selling expense since it is a normal consequence of selling on credit.\r\n\r\nThe Allowance for\u00a0Doubtful\u00a0Accounts account can have either a debit or credit balance before the year-end adjustment. Under the percentage-of-sales method, the company ignores any existing balance in the allowance when calculating the amount of the year-end adjustment (except that the allowance account must have a credit balance after adjustment).\r\n\r\nFor example, assume Rankin\u2019s allowance account had a\u00a0 $300 credit balance before adjustment. The adjusting entry would still be for\u00a0$5,000. However, the balance sheet would show $100,000 accounts receivable less a\u00a0 $5,300 allowance for\u00a0doubtful accounts, resulting in net receivables of\u00a0 $\u00a094,700. On the income statement, Bad Debt Expense would still be 1%of total net sales, or\u00a0 $5,000.\r\n\r\nIn applying the percentage-of-sales method, companies annually review the percentage of uncollectible accounts that resulted from the previous year\u2019s sales. If the percentage rate is still valid, the company makes no change. However, if the situation has changed significantly, the company increases or decreases the percentage rate to reflect the changed condition. For example, in periods of recession and high unemployment, a firm may increase the percentage rate to reflect the customers\u2019 decreased ability to pay. However, if the company adopts a more stringent credit policy, it may have to decrease the percentage rate because the company would expect fewer uncollectible accounts.\r\n\r\nhttps:\/\/youtu.be\/mBuprTmisPw?list=PL_PmoCeUoNMIX3zP2yYSAq8gi6irBVh-1\r\n\r\nPercentage-of-receivables method<\/strong> The percentage-of-receivables method<\/strong> estimates uncollectible accounts by determining the desired size of the Allowance for Uncollectible Accounts. Rankin would multiply the ending balance in Accounts Receivable by a rate (or rates) based on its uncollectible accounts experience. In the percentage-of-receivables method, the company may use either an overall rate or a different rate for each age category of receivables.\r\n\r\nTo calculate the adjusting entry amount of the entry for bad debt expense under the percentage-of-receivables method using an overall rate, Rankin would use:\r\n\r\nBad Debt Expense = \u00a0(Accounts receivable ending balance x percentage estimated as uncollectible) \u2013 Existing credit balance in allowance for\u00a0doubtful accounts or + \u00a0existing debit balance in allowance for\u00a0doubtful accounts<\/em>\r\n\r\nUsing the same information as before, Rankin makes an estimate of uncollectible accounts at the end of the year. The balance of accounts receivable is\u00a0$100,000, and the allowance account has no balance<\/strong>. If Rankin estimates that 6% of the receivables will be uncollectible, the adjusting entry would be:\r\n\r\n\r\n\r\n\r\n\r\n
\n\n \r\n\r\nDec.<\/strong><\/td>\r\n\n\n \r\n\r\n31<\/strong><\/td>\r\n\n\n \r\n\r\nBad Debt\u00a0Expense <\/strong><\/td>\r\n\n\nDebit<\/strong>\r\n\r\n6,000<\/strong><\/td>\r\n\n\n\u00a0Credit<\/strong>\r\n\r\n <\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nAllowance for\u00a0Doubtful Accounts <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n6,000<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n($ 100,000 x 6%) - 0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAccounts Receivable would be reported on the balance sheet as (notice how the allowance for doubtful accounts equals 6% of accounts receivable):\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Accounts receivable<\/strong><\/td>\r\n$100,000 <\/strong><\/td>\r\n<\/tr>\r\n
Less: Allowance for\u00a0doubtful accounts<\/strong><\/td>\r\n(6,000)<\/strong><\/td>\r\n<\/tr>\r\n
Accounts receivable, Net<\/strong><\/td>\r\n\n\n\r\n\r\n
\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$94,000<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/tr>\r\n
Or\u00a0the balance sheet could show:<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
Accounts receivable (less estimated<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
uncollectible accounts, $6,000)<\/strong><\/td>\r\n\u00a0 $94,000<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nIf Rankin had a\u00a0 $300 credit balance in the allowance account<\/strong> before adjustment<\/strong>, the entry would be the same, except that the amount of the entry would be\u00a0$ 5,700. The difference in amounts arises because management wants the allowance account to contain a credit balance equal to 6% of the outstanding receivables when presenting the two accounts on the balance sheet. The calculation of the necessary adjustment is [($100,000 x 6%)- $300] =\u00a0$ 5,700. Thus, under the percentage-of-receivables method, firms consider any existing balance in the allowance account when adjusting for uncollectible accounts and must remove any previous amounts in the allowance for doubtful accounts.\u00a0\u00a0 The year end adjusting entry would be:\u00a0\u00a0\u00a0<\/strong>\r\n\r\n\r\n\r\n\r\n\r\n
\n\n \r\n\r\nDec.<\/strong><\/td>\r\n\n\n \r\n\r\n31<\/strong><\/td>\r\n\n\n \r\n\r\nBad Debt\u00a0Expense <\/strong><\/td>\r\n\n\nDebit<\/strong>\r\n\r\n5,700<\/strong><\/td>\r\n\n\n\u00a0Credit<\/strong>\r\n\r\n <\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nAllowance for\u00a0Doubtful Accounts <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n5,700<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n($ 100,000 x 6%) - $300<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAccounts Receivable would be reported on the balance sheet as (notice how the allowance for doubtful accounts still equals 6% of accounts receivable):\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Accounts receivable<\/strong><\/td>\r\n$100,000 <\/strong><\/td>\r\n<\/tr>\r\n
Less: Allowance for\u00a0doubtful accounts<\/strong><\/td>\r\n(6,000)<\/strong><\/td>\r\n<\/tr>\r\n
Accounts receivable, Net<\/strong><\/td>\r\n\n\n\r\n\r\n
\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$94,000<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/tr>\r\n
Or\u00a0the balance sheet could show:<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
Accounts receivable (less estimated<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
uncollectible accounts, $6,000)<\/strong><\/td>\r\n\u00a0 $94,000<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAs another example, suppose that Rankin had a $300 debit balance in the allowance account<\/strong> before adjustment<\/strong>. Then, a credit of\u00a0 $6,300 would be necessary to bad debt expense to get the balance to the required\u00a0$6,000 credit balance. The calculation of the necessary adjustment is [($ 100,000 x 6%) +\u00a0$300] =\u00a0$6,300.\u00a0 The year end adjusting entry would be:\r\n\r\n\r\n\r\n\r\n\r\n
\n\n \r\n\r\nDec.<\/strong><\/td>\r\n\n\n \r\n\r\n31<\/strong><\/td>\r\n\n\n \r\n\r\nBad Debt\u00a0Expense <\/strong><\/td>\r\n\n\nDebit<\/strong>\r\n\r\n6,300<\/strong><\/td>\r\n\n\n\u00a0Credit<\/strong>\r\n\r\n <\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nAllowance for\u00a0Doubtful Accounts <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n6,300<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n($ 100,000 x 6%) +\u00a0$300<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nNo matter what the pre-adjustment allowance account balance is, when using the percentage-of-receivables method, Rankin adjusts the Allowance for\u00a0Doubtful Accounts so that it has an ending credit balance of\u00a0 $\u00a06,000\u2014equal to 6% of its\u00a0$100,000 in Accounts Receivable. The desired\u00a0$6,000 ending credit balance in the Allowance for Doubtful Accounts serves as a \u201ctarget\u201d in making the adjustment.\r\n\r\nhttps:\/\/youtu.be\/AVseHnm4Ndk?list=PL_PmoCeUoNMIX3zP2yYSAq8gi6irBVh-1\r\n\r\nSo far, we have used one uncollectibility rate for all accounts receivable, regardless of their age. However, some companies use a different percentage for each age category of accounts receivable. When accountants decide to use a different rate for each age category of receivables, they prepare an aging schedule. An aging schedule classifies accounts receivable according to how long they have been outstanding and uses a different uncollectibility percentage rate for each age category. Companies base these percentages on experience. In Exhibit 1, the aging schedule shows that the older the receivable, the less likely the company is to collect it.\r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
ALLEN COMPANY<\/strong><\/td>\r\n<\/tr>\r\n
Accounts Receivable Aging Schedule<\/strong><\/td>\r\n<\/tr>\r\n
Customer<\/strong><\/td>\r\nTotal<\/strong><\/td>\r\nNot Yet Due\u00a0<\/strong><\/td>\r\nDays Past Due<\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n\u00a0<\/strong><\/td>\r\n0 - 30 <\/strong><\/td>\r\n31 - 60<\/strong><\/td>\r\n61 - 90<\/strong><\/td>\r\nOver 90<\/strong><\/td>\r\n<\/tr>\r\n
X<\/strong><\/td>\r\n\u00a0$\u00a0\u00a0 5,000 <\/strong><\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n\u00a0\u00a0\u00a0 5,000 <\/strong><\/td>\r\n<\/tr>\r\n
Y<\/strong><\/td>\r\n14,000 <\/strong><\/td>\r\n<\/td>\r\n12,000 <\/strong><\/td>\r\n\u00a02,000 <\/strong><\/td>\r\n<\/td>\r\n<\/td>\r\n<\/tr>\r\n
Z<\/strong><\/td>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0400 <\/strong><\/td>\r\n<\/td>\r\n<\/td>\r\n<\/td>\r\n\u00a0200 <\/strong><\/td>\r\n\u00a0\u00a0\u00a0\u00a0200 <\/strong><\/td>\r\n<\/tr>\r\n
all others<\/strong><\/td>\r\n808,600 <\/strong><\/span><\/td>\r\n560,000 <\/strong><\/span><\/td>\r\n240,000 <\/strong><\/span><\/td>\r\n2,000 <\/strong><\/span><\/td>\r\n\u00a0 600 <\/strong><\/span><\/td>\r\n\u00a06,000 <\/strong><\/span><\/td>\r\n<\/tr>\r\n
Total Accounts Receivable<\/strong><\/td>\r\n$ 828,000 <\/strong><\/td>\r\n$ 560,000<\/strong><\/td>\r\n\u00a0$\u00a0252,000 <\/strong><\/td>\r\n$\u00a04,000 <\/strong><\/td>\r\n\u00a0$\u00a0800 <\/strong><\/td>\r\n$ 11,200 <\/strong><\/td>\r\n<\/tr>\r\n
x Percent estimated as uncollectible<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nx 1%<\/strong><\/span><\/td>\r\nx\u00a05%<\/strong><\/span><\/td>\r\nx 10%<\/strong><\/span><\/td>\r\nx 25%<\/strong><\/span><\/td>\r\nx 50%<\/strong><\/span><\/td>\r\n<\/tr>\r\n
Estimated amount uncollectible<\/strong><\/td>\r\n\u00a0$\u00a0\u00a0\u00a0\u00a024,400 <\/strong><\/td>\r\n5,600 <\/strong><\/td>\r\n12,600 <\/strong><\/td>\r\n\u00a0\u00a0400 <\/strong><\/td>\r\n\u00a0 200 <\/strong><\/td>\r\n\u00a05,600 <\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nExhibit 1: Accounts receivable aging schedule<\/strong><\/em>\r\n\r\nClassifying accounts receivable according to age often gives the company a better basis for estimating the total amount of uncollectible accounts. For example, based on experience, a company can expect only 1% of the accounts not yet due (sales made less than 30 days before the end of the accounting period) to be uncollectible. At the other extreme, a company can expect 50% of all accounts over 90 days past due to be uncollectible. For each age category, the firm multiplies the accounts receivable by the percentage estimated as uncollectible to find the estimated amount uncollectible.\r\n\r\nThe sum of the estimated amounts for all categories yields the total estimated amount uncollectible and is the desired credit balance (the target) in the Allowance for Uncollectible Accounts.\r\n\r\nSince the aging schedule approach is an alternative under the percentage-of-receivables method, the balance in the allowance account before adjustment affects the year-end adjusting entry amount recorded for uncollectible accounts. For example, the schedule in Exhibit 1 shows that\u00a0$24,400 is needed as the ending credit balance in the allowance account. If the allowance account has a $5,000 credit balance before adjustment<\/strong>, the adjustment would be for $19,400\u00a0 calculated as $24,400 estimated amount uncollectible from Exhibit 1 - 5,000 existing credit balance in the allowance account.\u00a0 The entry would be:\r\n\r\n\r\n\r\n\r\n\r\n
\n\n \r\n\r\nDec.<\/strong><\/td>\r\n\n\n \r\n\r\n31<\/strong><\/td>\r\n\n\n \r\n\r\nBad Debt\u00a0Expense <\/strong><\/td>\r\n\n\nDebit<\/strong>\r\n\r\n19,400<\/strong><\/td>\r\n\n\n\u00a0Credit<\/strong>\r\n\r\n <\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\nAllowance for\u00a0Doubtful Accounts <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n19,400<\/strong><\/td>\r\n<\/tr>\r\n
\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n($ 24,400 - 5,000) <\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n\u00a0<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nAccounts Receivable would be reported on the balance sheet as (notice how the allowance for doubtful accounts equals the estimated amount uncollectible from Exhibit 1):\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Accounts receivable<\/strong><\/td>\r\n$828,000 <\/strong><\/td>\r\n<\/tr>\r\n
Less: Allowance for\u00a0doubtful accounts<\/strong><\/td>\r\n(24,400)<\/strong><\/td>\r\n<\/tr>\r\n
Accounts receivable, Net<\/strong><\/td>\r\n\n\n\r\n\r\n
\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$803,600 <\/strong><\/td>\r\n<\/tr>\r\n
<\/td>\r\n<\/td>\r\n<\/tr>\r\n
Or\u00a0the balance sheet could show:<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
Accounts receivable (less estimated<\/strong><\/td>\r\n<\/td>\r\n<\/tr>\r\n
uncollectible accounts, $24,400)<\/strong><\/td>\r\n\u00a0 $803,600<\/strong><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\nThe information in an aging schedule also is useful to management for other purposes. Analysis of collection patterns of accounts receivable may suggest the need for changes in credit policies or for added financing. For example, if the age of many customer balances has increased to 61-90 days past due, collection efforts may have to be strengthened. Or, the company may have to find other sources of cash to pay its debts within the discount period. Preparation of an aging schedule may also help identify certain accounts that should be written off as uncollectible.\r\n\r\nhttp:\/\/www.openassessments.com\/assessments\/1180","rendered":"

Estimating uncollectible accounts<\/strong> Accountants use two basic methods to estimate uncollectible accounts for a period. The first method\u2014percentage-of-sales method\u2014focuses on the income statement and the relationship of uncollectible accounts to sales. The second method\u2014percentage-of-receivables method\u2014focuses on the balance sheet and the relationship of the allowance for uncollectible accounts to accounts receivable.<\/p>\n