Question

Aging of Receivables; Estimating Allowance for Doubtful Accounts

Wig Creations Company supplies wigs and hair care products to beauty salons throughout Texas and the Southwest. The accounts receivable clerk for Wig Creations prepared the following partially completed aging of receivables schedule as of the end of business on December 31, 20Y1:

			Days Past Due
Customer	Balance	Not Past Due	1-30	31-60	61-90	91-120	over 120
Subtotals	690,900	383,400	165,800	76,000	25,600	22,800	17,300

The following accounts were unintentionally omitted from the aging schedule:

Customer	Due Date		Balance
Arcade Beauty		May 28, 20Y1	$2,600
Creative Images		Sept. 7, 20Y1	5,400
Excel Hair Products		Oct. 17, 20Y1	700
First Class Hair Care		Oct. 24, 20Y1	1,800
Golden Images		Nov. 23, 20Y1	600
Oh The Hair		Nov. 29, 20Y1	3,100
One Stop Hair Designs		Dec. 2, 20Y1	2,000
Visions Hair and Nail		Jan. 5, 20Y2	6,600

Wig Creations has a past history of uncollectible accounts by age category, as follows:

Age Class	Percent Uncollectible
Not past due	2	%
1-30 days past due	4
31-60 days past due	10
61-90 days past due	15
91-120 days past due	35
Over 120 days past due	75

Required:

1. Determine the number of days past due for each of the preceding accounts. If an account is not past due, enter a zero.

Customer	Due Date	Number of Days Past Due
Arcade Beauty	May 28, 20Y1	days
Creative Images	Sept. 7, 20Y1	days
Excel Hair Products	Oct. 17, 20Y1	days
First Class Hair Care	Oct. 24, 20Y1	days
Golden Images	Nov. 23, 20Y1	days
Oh The Hair	Nov. 29, 20Y1	days
One Stop Hair Designs	Dec. 2, 20Y1	days
Visions Hair and Nail	Jan. 5, 20Y2	days

2. Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. If an amount box does not require an entry, leave it blank.

Wig Creations Company
Aging of Receivables Schedule
December 31, 20Y1
Customer	Balance	Not Past Due	Days Past Due 1-30	Days Past Due 31-60	Days Past Due 61-90	Days Past Due 91-120	Days Past Due Over 120
Subtotals
Arcade Beauty
Creative Images
Excel Hair Products
First Class Hair Care
Golden Images
Oh The Hair
One Stop Hair Designs
Visions Hair and Nail
Total
Percent uncollectible		2%	4%	10%	15%	35%	75%
Estimate of uncollectible accounts

3. Estimate the allowance for doubtful accounts, based on the aging of receivables schedule.
$

4. Assume that the allowance for doubtful accounts for Wig Creations has a credit balance of $1,630 before adjustment on December 31, 20Y1. Journalize the adjustment for uncollectible accounts.

5. Assume that the adjusting entry in (4) was inadvertently omitted, how would the omission affect the balance sheet and income statement?

On the balance sheet, assets would be   by   because the allowance for doubtful accounts would be   by  . In addition, the owner’s capital account would be   by   because bad debt expense would be   and net income   by   on the income statement.

Answer 1

1.

Customer	Due Date	Number of Days Past Due
Arcade Beauty	May 28, 20Y1	217 days
Creative Images	Sept. 7, 20Y1	115 days
Excel Hair Products	Oct. 17, 20Y1	75 days
First Class Hair Care	Oct. 24, 20Y1	68 days
Golden Images	Nov. 23, 20Y1	38 days
Oh The Hair	Nov. 29, 20Y1	32 days
One Stop Hair Designs	Dec. 2, 20Y1	29 days
Visions Hair and Nail	Jan. 5, 20Y2	Not past due

2.

Aging of Receivables Schedule
December 31, 20Y1
Customer	Balance	Not Past Due	Days Past Due 1-30	Days Past Due 31-60	Days Past Due 61-90	Days Past Due 91-120	Days Past Due Over 120
Subtotals
Arcade Beauty	$          2,600						$             2,600
Creative Images	$          5,400					$          5,400
Excel Hair Products	$             700				$           700
First Class Hair Care	$          1,800				$         1,800
Golden Images	$             600			$           600
Oh The Hair	$          3,100			$        3,100
One Stop Hair Designs	$          2,000		$         2,000
Visions Hair and Nail	$          6,600	$           6,600
Total	$        22,800	$           6,600	$         2,000	$        3,700	$         2,500	$          5,400	$             2,600
Percent uncollectible		2%	4%	10%	15%	35%	75%
Estimate of uncollectible accounts	$          4,797	$              132	$              80	$           370	$           375	$          1,890	$             1,950

3.
Allowance for Doubtful Debts = $4797

4.

Account Titles	Debit	Credit
Bad Debt Expense	$              3,167
Allowance for Doubtful Accounts		$              3,167

5. On the balance sheet, assets would be overstated by $3167 because the allowance for doubtful accounts would be understated by $3167. In addition, the owner’s capital account would be overstated by $3167 because bad debt expense would be understated and net income overstated by $3167 on the income statement.