In: Accounting
| The ABC company has an ending cash balance at October 31, 2020 in its general ledger of | $ 27,290.00 | |||||
| The balance per the bank statement at October 31, 2020 was | $ 26,455.00 | PART 1: BANK RECONCLIATION | ||||
| The accounting has identified the following information related to the month of October: | Cash balance per bank statement | |||||
| On October 31, deposit of $2,500 not reflected on the bank statement. | ||||||
| Outstanding cheques of $3,000 on October 31 | ||||||
| Cheque for utility expense, $430, was incorrectly recorded in the books as $340. | ||||||
| Cheque of $1,000 from Customer A returned and marked "non-sufficient funds". | ||||||
| The bank teller accidentally entered the deposit total as $805 instead of $850. | ||||||
| Bank service charges of $200, per bank statement | Adjusted cash balance per bank statement | |||||
| Using the following worksheet to record your answers, prepare the following: | Cash balance per books | |||||
| 1. A bank reconciliation for ABC company at October 31, 2020. | ||||||
| 2. Any necessary journal entries resulting from the bank reconciliation | ||||||
| Adjusted cash balance per books | ||||||
| PART 2: JOURNAL ENTRIES | ||||||
| No | General Journal | Debit | Credit | |||
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| ABC Company | ||||||
| Bank Reconciliation | ||||||
| Oct. 31 | ||||||
| Bank Statement Balance | 26,455 | Book Balance | 27,290 | |||
| Add: | Add: | |||||
| Deposit in Transit | 2,500 | |||||
| Error by bank teller | 45 | |||||
| Deduct: | Deduct: | |||||
| Outstanding Checks | 3,000 | Error in recording check | 90 | |||
| Bank CHARGES | 200 | |||||
| NSF Check | 1,000 | |||||
| Adjusted Bank Balance | 26,000 | Adjusted Book Balance | 26,000 | |||
| Journal Entries | ||||||
| General Journal | Debit | Credit | ||||
| 1) | Accounts Receivable | 1,000 | ||||
| Cash | 1000 | |||||
| (To record NSF Check) | ||||||
| 2) | Utilities Expense | 90 | ||||
| Cash | 90 | |||||
| (To record error correction) | ||||||
| 3) | Bank Charges | 200 | ||||
| Cash | 200 | |||||
| (To record bank charges) |