Good Evening, need help with this assignment for bank reconciliation and journal entries.

A B 1 D E Before you begin, print out all the pages in this workbook. G H 2. 3 Gibson Energy Ltd.'s general ledger account for Cash in Bank showed the following at December 31, 2019: 4 5 6 Cash in Bank 7 Folio Debit 7 8 Date 9 Nov. 30 10 | Dec. 1-31 11 Dec. 1-31 12 13 14 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: 15 16 17 18 19 20 2.1 Deposits Date Amount Dec. 5 30,000 7 210,000 9 85,000 12 32,000 15 26,000 21 420,000 24 16,000 26 51,000 28 21000 Required Bank Red Un Entries Checks No. Amount 232 110,000 233 83,000 234 25,000 235 59,000 236 590,000 237 17,000 238 28,000 239 77,000 22 23 24 25 copyright Alignment For 22 fo Number is B D E E F G K L M Gibson Energy Ltd. Bank Reconciliation At December 31, 2019 Unreconciled general ledger Cash balance at Dec. 31 Add: Rec. XYZ CORP. $62,000 $131,620 Unreconciled bank statement balance at Dec. 31 Add: Dec.9 85,000 Dec. 31 15,000 Check wrongly drawn $62,000 80,000 Less: Less: NSF check Overdraft check Bank charges -7,000 -1,320 -60 ISR380 Entries Copyright Required Bank Rec. Calculat O Type here to search a **S dc D 1 > u > 5 > > Es Merge & Center lipboard Font L2 Alignment -1 * fo Gibson Energy Ltd. A B D E C Gibson Energy Ltd. GENERAL JOURNAL Description PR Debit Credit Dec. 2019 5 5 7 3 9 10 11 12 13 14 15 16 17 18 19 20 Required Bank Rec Inl. Entrier Copyright Read calculate o C D E F 21 G H 1 24 26 28 420,000 16,000 51,000 21,000 15,000 $813,000 237 238 239 17,000 28,000 77,000 31 $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 6 Ck. 231 70,000 6 Deposit 30,000 z Deposit 210,000 10 Ck. 234 25,000 12 Ck. 236 590,000 Balance 215,000 295,000 185,000 115,000 145,000 355,000 330,000 (260,000) GA DAN PAS D E F G H 12 Ck. 236 590,000 (260,000) 13 Deposit 32,000 (228,000) 14 Ck. 52094* 62,000 (290,000) 14 NSF ABC. Inc. 7,000 (297,000) 15 Deposit 26,000 (271,000) 16 Ck. 238 28,000 (299,000) 17 Deposit 420,000 121,000 18 Ck. 235 59,000 62,000 20 Ck. 237 17,000 45,000 24 Deposit 16,000 61,000 26 Deposit 51,000 112,000 28 Deposit 21,000 133,000 31 OD int 1,320 131,680 31 SC 60 131,620 *drawn in error on Gibson's bank account NR = note receivable collected from XYZ Corp. $1,951 including interest of: NSF = not sufficient funds SC = service charge OD int = overdraft interest expense Outstanding items at November 30, 2019 were as follows: Bank Rec Anl. Entries Required Copyright SA B F G C D E H including interest of: $1,951 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. 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