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.