Merge & Center $ - % 98-98 Clipboard Com Form Font Alignment Number A3 X f M 315 A B G D E F G 5 Bank Reconciliation 6 October 31, 2020 7 Bank statement balance 21,010 Book balance 29,855 8 Add 9 Deposit of Oct 31 in transit 10,000 10 31,010 11 Deduct 12 Outstanding cheques 13 #14 840 14 #22 1,155 15 Adjusted bank balance 29,855 Adjusted book balan 29,855 16 17 18 19 Cash Acct. No. 101 20 Date Explanatic PR Debit Credit Balance 21 2020 31 22 Oct 29,855 Balance 23 Nov 100,595 CR17 30 70.740 9.423 91.172 CD13 30 24 25 26 27 A list of deposits made and cheques written during November taken from the Cash Reraints Inurnal and Cash Dishuisements lournal is shown below Akshar Sheet + UN B c D E F G H A list of deposits made and cheques written during November, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below. 28 29 30 Deposits Made 31 November 7 32 13 33 18 34 23 35 27 36 30 37 Total Cash Receipts 38 690 4,600 5,200 13,900 1.750 44.600 70.740 $ Bg 40 41 42 No 43 114 45 46 47 Cheques Written 23 24 26 26 27 28 29 BO 5.200 B.150 1940 10 14230 900 19330 000 48 49 Font Alignment Number A3 U K M A B D F G H 48 29 19,630 49 30 41,000 50 31 412 51 32 11,400 52 Total Cash Disbursements 91,172 53 54 55 56 The following bank statement is available for November 57 58 Bank Statement 59 60 To: Stewart Recording Studio 61 Cheques/Charges Deposits/Credits 62 63 64 65 66 67 68 69 70 71 72 #31 #28 #26 NSF #24 #23 #29 PMT INT SC 10-Nov 07-Nov 10-Nov 18-Nov 21-Nov 27-Nov 30-NOV 30-Nov 30-Nov 30-Nov 412 490 310 14.200 3,150 5.200 19,630 15.900 450 176 10-Nov 07-Nov 10-Nov 18-Nov 21-Noy 27-Nov 30-Nov 10,000 690 4,600 5,200 13,900 750 85.000 30-Nov-20 Bank of Canada Balance 21,010 30,598 30,798 35,088 26,088 36,838 32.388 97,758 81,858 EFT 81408 81,233 Akshar Sheet aste Wrap lext BIU General - A E53 Merge & Center Flipboard $ - % 9 98 Font Cone Form Alignment Number 3 A B C D E F G H 1 M In reviewing cheques returned by the bank, the bookkeeper discovered that cheque #28, for delivery expense, was recorded in the Cash Disbursements Journal incorrectly The NSF cheque was that of customer Oden Withers, deposited in Oct The EFT was a customer payment from Lionel Lu On the bank statement, the payment (PMT) is regarding a note payable. There is also a deposit dated November 30. It is an investment made by the owner into the business (the bank transferred the funds electronically from the owner's personal account to his business accountwhich is why it was not recorded in the Cash Receipts Journal) Required: a. Prepare a bank reconciliation at Month end b. Prepare the necessary journal entries for the end of the month