In: Accounting
The following summarizes the aging of accounts receivable for
Johnston Supplies, Inc. as of July 31, 2019:
| Number of Days Unpaid | Total Accounts Receivable | Historical % Uncollectible | |||||||
| Not yet due | $ | 127,200 | 5 | % | |||||
| 1-30 days past due | 89,900 | 10 | % | ||||||
| 31-60 days past due | 54,300 | 16 | % | ||||||
| Over 60 days past due | 32,500 | 37 | % | ||||||
Required:
a. The unadjusted balance of the Allowance for Doubtful Accounts of Johnston Supplies, Inc. is a credit balance in the amount of $29,157 on July 31, 2019. Prepare the required adjusting entry to record Bad Debt Expense for the year.
b. Johnston Supplies, Inc. writes off $3,151 of uncollectible accounts on August 15, 2019. Prepare the required adjusting entry to record the write-off.
c. Use a T-account to determine the account balance in the Allowance for Doubtful Accounts on August 15, 2019.
a. Adjusting entry to record Bad Debt Expense for the year is:
| Date | Particulars | L.F | Amount ($) | Amount ($) |
| July-31 | Bad Debt Expense | 6,906 | ||
| Allowance for doubtful accounts | 6,906 | |||
| (For bad debt created) |
Working:
| Age Group | Balance | Probability of | Amount uncollectible |
| Noncollection | |||
| Not past due | $ 127,200 | 5% | 6,360 |
| 1-30 days past due | 89,900 | 10% | 8,990 |
| 31-60 days past due | 54,300 | 16% | 8,688 |
| Over 60 days past due | 32,500 | 37% | 12,025 |
| $ 303,900 | $ 36,063 | ||
| Uncollectibles (Aging achedule) | 36,063 | ||
| Credit Balance in Allowance for dd | 29,157 | ||
| Bad Debts | 6,906 |
b. Adjusting entry to record the write-off is:
| Date | Particulars | L.F | Amount ($) | Amount ($) |
| Aug-15 | Allowance for doubtful accounts | 3,151 | ||
| Account Receivable | 3,151 | |||
| (For accounts written off as uncollectible) | ||||
c. T-account to determine the account balance in the Allowance for Doubtful Accounts on August 15, 2019 is as prepared below:
| Allowance for doubtful accounts | |||
| Particulars | Amount | Particulars | Amount |
| Aug-15 | 3,151 | Opening balance | 29,157 |
| Jul-31 | 6,906 | ||
| 3,151 | 36,063 | ||
| Closing Balance | 32,912 | ||