In: Accounting
|
|
|
|
|
Accounts Receivable Reconciliation | |
Opening balance | 500000 |
Credit sales in year | 6705000 |
Accounts written off | -35300 |
Reinstatement of account collected | 4700 |
Cash collected on account | -6538000 |
Ending balance | 636400 |
Working:
Days Account Outstanding | Amount | Probability of Uncollectibility | Uncollectible Amount |
Less than 16 days | 353200 | 3% | 10596 |
Between 16 and 30 days | 124000 | 9% | 11160 |
Between 31 and 45 days | 76000 | 20% | 15200 |
Between 46 and 60 days | 38800 | 29% | 11252 |
Between 61 and 75 days | 19800 | 49% | 9702 |
Over 75 days | 24600 | 100% | 24600 |
Total | 636400 | 82510 |
Allowance for Doubtful Accounts | |||
Beginning balance 1/1/2020 | 35000 | ||
Write-off | 35300 | Monthly adj. (0.5% x $6705000) | 33525 |
Re-instatement | 4700 | ||
Bad debts expense (adj.) | 44585 | ||
Ending balance 12/31/2020 | 82510 |
Adjusting entry:
Date | Account Titles and Explanation | Debit | Credit |
Dec. 31 | Bad debts expense | 44585 | |
Allowance for doubtful accounts | 44585 | ||
(To record the adjusting entry) |
Sheffield Corporation | |
Statement of Financial Position (Partial) | |
Accounts receivable | 636400 |
Less: Allowance for doubtful accounts | 82510 |
Accounts receivable (net) | 553890 |
The year-end bad debt adjustment would decrease before-tax income $44585.