You have been given the bank statement and general ledger for College Consultants Ltd.

Prepare the bank reconciliation and journal entries based on the two documents on March 31, 2020

NOTES: Cheque #212 was a payment on account and was cashed for the correct amount by the bank

The NSF cheque was from a customer as payment of their account

The EFT deposit was a customer paying their account

Q Search in Document A Home Layout Document Elements Tables Charts SmartArt Review Font Paragraph Styles Insert Themes Calibri (Body) - 11 - A- A- Adv Ab = AaBbCcDdEe AaBbCcDdEe AaBbCcD AaBbCcDdi |AaBb( AaBbCCDdE AoBbCcDdEe A Aa" BIUA AZABABE Normal No Spacing Heading 1 Heading 2 Title Subtitle Subtle Empha Text Box Shape Picture Themes 20.1 .1 . 2 . 1 .3 . 1 .4 . 1.5 . 1.6 . 1 .7 . 1.8 . 1. 9 . 1 10 141 . 142. 1 13 . 1 14 . 1 15 1 16. 147 . 1 18. 1 121 20 Student Name: BANK RECONCILIATION You have been given the bank statement and general ledger for College Consultants Ltd. Prepare the bank reconciliation and journal entries based on the two documents on March 31, 2020 NOTES: Cheque #212 was a payment on account and was cashed for the correct amount by the bank The NSF cheque was from a customer as payment of their account The EFT deposit was a customer paying their account Bank Statement March 1-March 31, 2020 Date Description Withdrawal Deposit Balance Mar-01 Opening Balance 5,420 Mar-01 EFT Rent 1,500 3,920 Mar-05 Cheque #212 240 3,680 Mar-08 Cheque #213 690 2,990 Mar-09 Deposi 900 ,890 Mar-1 NSF Cheque 900 2,990 Mar-11 NSF Fee 15 2,975 Mar-18 Deposit 1,100 4,075 Mar-19 Cheque #215 780 3,295 Mar-27 Cheque #216 525 2,770 Mar-28 EFT Deposit 800 3,570 Mar-31 Interest 5 3,575 1 16. 1 Mar-31 Service Charge 20 3,555 Account: CASH GL No: 101 Date Description DR CR Balance Mar-01 Opening Balance DR 1 20. 1 19. 1 Mar-02 Cheque #211 275 DR Mar-04 Cheque #212 420 4,725 DR Mar-07 Deposit T Park 900 5,625 DR Mar-07 Cheque #213 690 4,935 DR 1 26 . 1 24 . 1 23 . 1 22. 1 Mar-15 Cheque #214 370 1,565 DR Mar-17 Deposit 1,100 5,665 DR Mar-18 Cheque #215 780 4,885 DR Mar-25 Cheque #216 525 4,360 DR Mar-29 Cheque #217 700 ,660 DR Mar-31 Deposit 1,450 5,110 DR Print Layout View c 1 Pages: 1 of 4 Words: 74 of 248 97%