P6-12 Preparing a Bank Reconciliation and Related Journal Entries LO6-7 The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying instead, I don't have time. You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (summarized): Bank Statement Cheques Deposits Balance $34,200 71,900 $37,700 1,340 Balance, April 1, 2018 Deposits during April Notes collected for company (including $86 interest) Cheques cleared during April NSF cheque-A. B. Wright Bank service charges Balance, April 30, 2018 $46,100 176 86 73,240 27,140 26,964 26,878 26,878 Cash in Bank Apr. 1 Apr. Apr. 42,700 Balance Deposits 25,100 43,900 Cheques written Cash on Hand Apr. 30 Balance 260 A comparison of cheques written before and during April with the cheques cleared through the bank showed that cheques of $5,700 are still outstanding at April 30. No deposits in transit were carried over from March, but a deposit was in transit at April 30. Required: 1. Prepare a detailed bank reconciliation at April 30, 2018. HOPKINS COMPANY Bank Reconciliation, April 30, 2018 Company's Books Bank Statement Additions: Additions: Deductions: Deductions: Ending correct cash balance Ending correct cash balance