D 125% ED l Table Chart Copyright T Text Shape Insert Jnl Entries Media Comment Required Bank Rec. O A B C D E Before you begin, print out all the pages in this workbook. Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31, 2019: Cash in Bank Folio Debit Date Nov. 30 Dec. 1-31 Dec. 1-31 Description Balance (overdraft) Cash receipts Cash Payments Acct. No. 101 Balance DR Credit (CR) 221,000 1,034,000 972,000 62,000 CRJ10 CDJ21 813,000 December deposits made and checks issued were as follows: Deposits Date Amount Dec. 5 30,000 210,000 85,000 32,000 26,000 420,000 16,000 51,000 21,000 15,000 $813,000 Checks Amount 232 110,000 233 83,000 25,000 59,000 590,000 17,000 28,000 77,000 NO $972.000 The December bank statement showed: First Chartered Bank Gibson Energy Ltd. Bank Statement Month Ended December 31, 2019 Date Type Out in Dec. 3 Deposit 70.000 4 NR XYZ Corp. 80,000 5 Ck. 232 110.000 Balance 215,000 295,000 185.000 D 125% Chart Text Shape Medic Regulred Bank Rec. Jnl. Cetries Copyright OA SS SS SEE O 4 NR XYZ Corp 80,000 5 ck 232 110,000 6 Ck. 231 70,000 6 Deposit 30,000 7 Deposit 210.000 10 Ck. 234 25,000 12 Ck. 236 590,000 13 Deposit 14 Ck. 52094" 62,000 14 NSF ABC. Inc. 7,000 15 Deposit 26.000 16 Ck. 238 28,000 17 Deposit 420,000 18 Ck. 235 59,000 20 Ck. 237 17,000 24 Deposit 26 Deposit 51.000 28 Deposit 21,000 31 OD int 1.320 31 SC drawn in error on Gibson's bank account NR - note receivable collected from XYZ Corp. including interest of: NSF - not sufficient funds SC -service charge OD int - overdraft interest expense Outstanding items at November 30, 2019 were as follows: Nov. 30 deposit $70,000 Ck. 231 $70,000 Required: 1 Complete the bank reconciliation at December 31, 2019 295,000 185,000 115.000 145,000 355,000 330,000 (260,000) (228,000) (290,000) (297.000) (271,000) (299,000) 121,000 62,000 45,000 61,000 112,000 133,000 131.680 131,620 16,000 60 $1.951 DEB BOSS SS 2 Prepare the adjusting journal entries required to make the Cash in Bank account in the general ledger agree with the adjusted cash balance on the December 31 bank reconciliation. Include descriptions D 125% a .TO Table Chart Teart Shape Copyright Media Comment Insert Jl. Entries + Required Bank Rec. Gibson Energy Ltd. Bank Reconciliation At December 31, 2019 Unreconciled general ledger Cash balance at Dec. 31 Add: Unreconciled bank statement balance at Dec. 31 Add: Adjusted general ledger Cash balance at Dec. 31 Adjusted bank balance at Dec. 125% D T Text insert l Table Chart Copyright Shape Media Required Gibson Energy Ltd. GENERAL JOURNAL Description Debit Credit