In: Accounting
The following is the Summary of Aged Accounts Receivable List as at December 31, 2016Total ReceivablesCurrent(not overdue)Overdue 1-30 days Overdue 31-60 daysOverdue 61-90 daysOverdue > 90days$897,000$325,000$228,000$174,000$128,000$42,0001% is estimated to be uncollectable.5% is estimated to be uncollectable.10% is estimated to be uncollectable.15% is estimated to be uncollectable.20% is estimated to be uncollectable.On December 30, 2016, the company wrote off a total amount of $100,000 accounts receivable. On December 31, 2016, the unadjusted balance in the Allowance for doubtful accounts is a debit balance of $54,000.Assume the company uses the allowance account method for bad debts based on the Summary ofAged Accounts Receivable List. The company does not estimate the uncollectible percentage based on the total outstanding receivables. Rather, the company applies different percentages depending on the aging of Accounts Receivable, as shown in the Summary of Aged Accounts Receivable List. What should be the bad expense amount that should be reported on the income statement ended on December 31, 2016?
Age of account | Accounts receivable | Estimated Percentage Uncollectible | Estimated uncollectibles |
Current not over due | 325,000 | 1.0% | 3,250 |
1 to 30 days | 228,000 | 5.0% | 11,400 |
31 to 60 days | 174,000 | 10.0% | 17,400 |
61 to 90 days | 128,000 | 15.0% | 19,200 |
Over 90 days | 42,000 | 20.0% | 8,400 |
Total | 897,000 | 56,400 |
Allowance for doubtful accounts, unadjusted = $54,000 (debit)
Accounts receivable written off = $100,000
Allowance for doubtful accounts, ending = $56,400
Allowance for doubtful accounts unadjusted for accounts receivable written off = Allowance for doubtful accounts, unadjusted + Accounts receivable written off
= 54,000+100,000
= $154,000
Bad debt expense = Allowance for doubtful accounts, ending + Allowance for doubtful accounts unadjusted for accounts receivable written off
= 56,400+154,000
= $210,400
the bad expense amount that should be reported on the income statement ended on December 31, 2016 = $210,400