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, 2020NOTES: Cheque #212 was a payment on account and was cashed for the correct amount by the bankThe NSF cheque was from a customer as payment of their accountThe EFT deposit was a customer paying their account

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 590 2,990 Mar-09 Deposit 900 3,890 Mar-11 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 Interes 5 3,575 Mar-31 Service Charge 20 3,555 Account: CASH GL No: 101 Date Description DR CR Balance Mar-01 Opening Balance 5,420 DR Mar-02 Cheque #211 275 5,145 DR Mar-04 Cheque #212 420 4,725 DR Mar-07 Deposit T Park 900 5,625 DR Mar-07 Cheque #213 690 1,935 DR Mar-15 Cheque #214 370 4,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 3,660 DR Mar-31 Deposit 1,450 5,110 DR 1 4 Words: 74 of 248