In: Accounting
Web Wizard, Inc., has provided information technology services for several years. For the first two months of the current year, the company has used the percentage of credit sales method to estimate bad debts. At the end of the first quarter, the company switched to the aging of accounts receivable method. The company entered into the following partial list of transactions during the first quarter.
Number of Days Unpaid | ||||||||||||||||
Customer | Total | 0–30 | 31–60 | 61–90 | Over 90 | |||||||||||
Alabama Tourism | $ | 200 | $ | 100 | $ | 80 | $ | 20 | ||||||||
Bayside Bungalows | 400 | $ | 400 | |||||||||||||
Others (not shown to save space) | 17,000 | 6,800 | 8,400 | 1,000 | 800 | |||||||||||
Xciting Xcursions | 400 | 400 | ||||||||||||||
Total Accounts Receivable | $ | 18,000 | $ | 7,300 | $ | 8,480 | $ | 1,020 | $ | 1,200 | ||||||
Estimated Uncollectible (%) | 2 | % | 10 | % | 20 | % | 40 | % | ||||||||
Required:
For items (a)–(j), analyze the transaction to determine effects on specific financial statement accounts and the overall accounting equation. (Enter any decreases to Assets, Liabilities, or Stockholders Equity with a minus sign. Do not round intermediate calculations.)
Solution:
Event | Assets | = | Liabilities | + | Stockholder's Equity | |||
a | Accounts receivables | $40,000.00 | Service revenue | $40,000.00 | ||||
b | Allowance for doubtful accounts | -$400.00 | Bad debts expense | -$400.00 | ||||
c | Cash | $20,000.00 | ||||||
Accounts receivables | -$20,000.00 | |||||||
d | Allowance for doubtful accounts | $100.00 | ||||||
Accounts receivables | -$100.00 | |||||||
e | Accounts receivables | $30,000.00 | Service revenue | $30,000.00 | ||||
f | Allowance for doubtful accounts | -$300.00 | Bad debts expense | -$300.00 | ||||
g | Note receivables | $2,400.00 | ||||||
Cash | -$2,400.00 | |||||||
h | Accounts receivables | $100.00 | ||||||
Allowance for doubtful accounts | -$100.00 | |||||||
Cash | $100.00 | |||||||
Accounts receivables | -$100.00 | |||||||
i | Interest receivables (2200*6%*1/12) | $12.00 | Interest revenue | $12.00 | ||||
j | Allowance for doubtful accounts (1678-1200) | -$478.00 | Bad debts expense | -$478.00 |
Computation of allowance for estimated uncollectibles - Web Wizard Inc. | |||||
Customer | Balance | 0-30 days | 31-60 days | 61-90 days | Over 90 days |
Total Receivables | $18,000 | $7,300 | $8,480 | $1,020 | $1,200 |
Percentage uncollectibles | 2% | 10% | 20% | 40% | |
Allowance for doubtful accounts | $1,678 | $146 | $848 | $204 | $480 |