In: Accounting
Winfrey Designs had an unadjusted credit balance in its
Allowance for Doubtful Accounts at December 31, 2017, of
$2,200.
Required:
a. Prepare the adjusting entry assuming that Winfrey
estimates uncollectible accounts based on an aging analysis as
follows. (If no entry is required for a transaction/event,
select "No journal entry required" in the first account
field.)
| December 31, 2017 Accounts Receivable | Age of Accounts Receivable | Expected Percentage Uncollectible | ||||
| $ | 148,000 | Not due (under 30 days) | 1 | % | ||
| 43,000 | 1 to 30 days past due | 4 | % | |||
| 10,000 | 31 to 60 days past due | 10 | % | |||
| 2,400 | Over 60 days past due | 60 | % | |||
1
Record the estimate for uncollectible accounts.
b. During 2018, credit sales were $1,406,000;
sales discounts taken were $26,000; accounts receivable collected
were $1,175,400; and accounts written off during the year totalled
$28,000. Prepare the adjusting entry required on December 31, 2018,
to estimate uncollectible receivables assuming it is based on the
following aging analysis. (If no entry is required for a
transaction/event, select "No journal entry required" in the first
account field.)
| December 31, 2018 Accounts Receivable | Age of Accounts Receivable | Expected Percentage Uncollectible | ||||
| $ | 280,000 | Not due (under 30 days) | 1 | % | ||
| 87,000 | 1 to 30 days past due | 4 | % | |||
| 24,000 | 31 to 60 days past due | 10 | % | |||
| 15,000 | Over 60 days past due | 60 | % | |||
1
Record the estimate for uncollectible accounts.
c. Show how accounts receivable would appear on the December 31, 2018, balance sheet.
Partial balance sheet
assets
current assets
Solution a:
| Computation of Allowance for Uncollectible Accounts - 2017 | |||
| Ageing | Accounts Receivables | % Uncollectible | Required Allowance |
| Not Due | $148,000.00 | 1% | $1,480.00 |
| 1 to 30 days past due | $43,000.00 | 4% | $1,720.00 |
| 31 to 60 days past due | $10,000.00 | 10% | $1,000.00 |
| Over 60 days past due | $2,400.00 | 60% | $1,440.00 |
| Total | $203,400.00 | $5,640.00 | |
| Journal Entries - Winfrey Designs | |||
| Date | Particulars | Debit | Credit |
| 31-Dec-17 | Bad debts Expense Dr ($5,640 - $2,200) | $3,440.00 | |
| To Allowance for doubtful accounts | $3,440.00 | ||
| (To record bad debts expense) | |||
Solution b:
| Computation of Allowance for Uncollectible Accounts - 2018 | |||
| Ageing | Accounts Receivables | % Uncollectible | Required Allowance |
| Not Due | $280,000.00 | 1% | $2,800.00 |
| 1 to 30 days past due | $87,000.00 | 4% | $3,480.00 |
| 31 to 60 days past due | $24,000.00 | 10% | $2,400.00 |
| Over 60 days past due | $15,000.00 | 60% | $9,000.00 |
| Total | $406,000.00 | $17,680.00 | |
| Journal Entries - Winfrey Designs | |||
| Date | Particulars | Debit | Credit |
| 31-Dec-18 | Bad debts Expense Dr ($17,680 + $28,000 - $5,640) | $40,040.00 | |
| To Allowance for doubtful accounts | $40,040.00 | ||
| (To record bad debts expense) | |||
Solution c:
| Winfrey Designs | ||
|
Balance Sheet (Partial) As of Dec 31, 2018 |
||
| Particulars | Amount | |
| Current Assets: | ||
| Accounts receivables, Gross | $406,000.00 | |
| Allowance for doubtful accounts | -$17,680.00 | |
| Accounts receivables, net | $388,320.00 | |