Dev Patel: Attempt 1 Question 2 (11 points) Spector Enterprises prepares their bank reconciliations at end of each month. Now that year-end is upon them, they need to prepare the June 30,2021 bank rec. The three source documents below should help in preparing the necessary bank reconciliation. Prepare a bank reconciliation for June and any required adjusting entries at the end of the month. Show your calculations! (11 marks) Bank Reconciliation - May 31, 2021 Spector Enterprises Bank Reconciliation May 31, 2021 Bank statement balance $ 15,474 Book balance Add: $ 17,386 6,230 21,704 Deposit in transit $ Deduct: Outstanding cheques: # 375 $ 400 # 440 $ 2,548 # 444 $ 1,370 $ Adjusted bank balance Bank Statement - June 30, 2021 4,318 17,386 Adjusted book balance $ 17386 Bank Statement To: Spector Enterprises June 30, 2021 TD Canada Trust Date Description Cheque Amount Deposits / Credits Balance $ 15,474 May 31 Opening balance $ Deposit 6,230 $ 21,704 Jun 1 400 $ Jun 7 375 2,901 447 Jun 8 $ 21,304 $18.403 JASSA MacBook Pro & Oo * 9 A a 7 6 28 40 Credit Memo Jun 30 5 Service charge $ Other information The bank deposited $250 to our account on Jun 28. This relates their collection of a $278 account on our behalf. 49,00 250 $ 26,199 . $ 26,199 $ 26,199 $ 26,199 $ 26,178 21 Spector Enterprises's owner writes handwritten cheques periodically. The bookkeeper sometimes makes transposition or keying errors when entering the cheques relating to the Supplies expense. Cash General Ledger Account - June 30, 2021 Cash Date Explanation PR May 31 Balance Jun 1 446 GL17 Jun 1 447 GL17 Jun 4 448 GL17 Jun 10 449 GL17 Deposit GL17 Deposit GL17 $ $ $ $ $ S Acct. No. 101 Debit Credit Balance $ 17,386 $ 561 $ 16,825 $ 2,901 $ 13,924 $ 565 $ 13,359 $ 2,926 $ 10,433 - $ 15,251 4,106 $ $ 19,357 $ 797 $ 18,560 - $ $ $ 4,818 $ 3,582 $ Jun 14 Jun 16 Jun 19 450 GL18 Jun 21 Deposit GL18 Jun 22 451 GL18 Jun 27 452 GL18 GL18 Jun 30 Deposit 22,142 67 $ 22,075 596 $ 21,479 $ 28,295 6,816 + v 1 UA B V Paragraph MacBook Pro & 8