Purple Bank Dute Description Det C BEC's adjusted cash general ledger balance at January 31, 2036 $5,16. The bookkeeper has compiled the following information and notes 12,500 ILTON $ 622 Depot in December 31, 2017 Outstanding chegues December 31, 2017 1. LABO 23 Amount 14.250 12.00 12.ME 14 77 70 88 $ $ $ 180 da DORTY GOOD - NOT ODPOST 05-18 NIGHT DEPOST NOTLO NE 11- NOT DEPOT - Director 15- Mered 11 OCR 15--OGRS NOM DOO 161 OORTO DO SOOMS INGEPOST 2014 2- NO DEPOSIT 15.00 All 14,7 Rece Jauny Depositing 1. 14. 22 Amount $ 05-Jan-18 Cheques and Com 10-18 Cheques and Con 14.14 19-18 Chand Can 26-18 Chers and Cashot 31- Cheques and Cash LO $ $ $ $ $ Rec Co. Cheque Register - Jan 2018 Che Amount $ $ 484 84 $ Las As $ 30 $ 4.520 $ 52 $ $ L950 1.6 825 1,020 BASS 10:58 U20 DOO 472 1,000 26 13 1112 26 1444 BIGHT DEPOST LORD Required Prepare the bank reconciliation for Reco's bank accountary 31, 2018 - Prepare any adjusting journal entries needed awing from the bank reconciliation Show transcribed image text Recy Co.'s unadjusted cash general ledger balance at January 31, 2018 is $5,386. The bookkeeper has compiled the following information and notes: Information from Dec 31, 2017 Bank Reconciliation Deposit in transit at December 31, 2017 $ 622 Outstanding cheques December 31, 2017: Cheg # Amount 70 $ 50 77 $ 722 79 $ 128 81 $ 880 Recy Co. January Deposit Listing Date Notes 05-Jan-18 Cheques and Cash total 10-Jan-18 Cheques and Cash total 15-Jan-18 Cheques and Cash total 19-Jan-18 Cheques and Cash total 26-Jan-18 Cheques and Cash total 31-Jan-18 Cheques and Cash total Amount $ $ $ $ $ $ 1,936 2,202 822 1,650 825 1,020 8,455 Recy Co. Cheque Register - Jan 2018 Cheq # Amount 82 $ 68 83 $ 484 84 S 1,958 85 S 328 86 $ 880 87 $ 4,620 88 67 89 3,300 90 725 91 $ 833 92 $ 1,112 93 $ 36 $ 14,411 $ $ Bank Statement Date Description Debit Credit Balance Bookkeeper notes 01-Jan-18 12,500 02-Jan-18 722 CHQ#77 CHQ#82 02-Jan-18 86 bank recorded incorrect amt 11,778 11,692 12,314 14,250 02-Jan-18 NIGHT DEPOSIT 622 1,936 05-Jan-18 NIGHT DEPOSIT 09-Jan-18 1,430 follow up with customer NSF Cheque - TIL CO. NSF fee 09-Jan-18 28 12,820 12,792 14,994 charge back to customer 2,202 594 11-Jan-18 NIGHT DEPOSIT 12-Jan-18 Direct Deposit - XYZ Co. 15-Jan-18 MM Insurance direct payment 15,588 pmt of customer account correct amt - for January insu not booked 490 15,098 15-Jan-18 CHQ#81 880 14,218 15-Jan-18 CHQ#85 382 13,836 bank has correct amt- pmt of Accts payable 15-Jan-18 NIGHT DEPOSIT 822 14,658 CHQW70 50 14,608 16-Jan-18 17Jan-18 CHQ#83 484 CHQ989 3,300 18-Jan-18 19-Jan-18 1,650 NIGHT DEPOSIT CHQU84 22-Jan-18 1,958 26-Jan-18 NIGHT DEPOSIT 825 14,124 10,824 12,474 10,516 11,341 6,721 5,609 5,583 5,596 29-Jan-18 CHQ987 29-Jan-18 31-Jan-18 CHQw92 Bank charges Interest 4,620 1,112 26 31-Jan-18 13 01-Feb-18 NIGHT DEPOSIT 1,020 6,616 Required: a) Prepare the bank reconciliation for Recy Co.'s bank account at January 31, 2018 b) Prepare anv adiusting iournal entries needed arisine from the bank reconciliation
