Question

Exercise 7-15 (Static) Aging of Receivables Schedule LO P3

Following is a list of credit customers along with their amounts owed and the days past due at December 31. Following that list are five classifications of accounts receivable and estimated bad debts percent for each class.

	Days Past Due
		0		1 to 30				31 to 60				61 to 90				Over 90
Percent uncollectible		1	%			3%				5%				8%				12%

Customer	Accounts Receivable			Days Past Due
BCC Company	$	4,000			12
Lannister Co.		1,000			0
Mike Properties		5,000			107
Ted Reeves		500			72
Jen Steffens		2,000			35

1. Create an aging of accounts receivable schedule of accounts receivable by age similar to the table given above. Calculate the estimated balance for the Allowance for Doubtful Accounts.
2. Assuming an unadjusted credit balance of $100, record the required adjustment to the Allowance for Doubtful Accounts.

Answer 1

1
Calculation of estimated balance for allowance for doubtful accounts
Customer	Accounts receivable	Days past due	Aging schedule	Percent uncollectible	Amount uncollectible
BCC Company	4,000	12	1 to 30	1%	$40
Lannister Co	1,000	0	0	1%	$10
Mike Properties	5,000	107	Over 90	12%	$600
Ted Reeves	500	72	61 to 90	5%	$25
Jen Steffens	2,000	35	31 to 60	3%	$60
					$735
Thus, estimated balance for allowance for doubtful accounts is $735
2
Bad debt expense	$635	735-100
Date	General Journal	Debit	Credit
31-Dec	Bad debt expense	$635
	Allowance for doubtful accounts		$635
	(To adjust allowance for doubtful account)