Question The November 31st, 2020 bank statement of Joe's Designer Warehouse has just arrived from TD Bank. To prepare Joe's Designer Warehouse' bank reconciliation, you collect the following information: 1. The November 31st bank balance is $8,400.82 2. Joe's Designer Warehouse cash account in the books shows a balance of $7,391.55 3. The following Joe's Designer Warehouse cheques are outstanding a November 31st: Cheque Number 616 802 806 809 810 811 Amount $403.00 $74.02 $36.60 $161.38 $229.05 $48.91 4. The bank statement includes two special deposits: $899.14, which is the amount of dividend revenue the bank collected from IBM on behalf of Joe's Designer Warehouse, and $16.86, the interest revenue Joe's Designer Warehouse earned on its bank balance during November. 5. The bank statement lists a $6.25 bank service charge. 6. On November 31st the Joe's Designer Warehouse accountant deposited $381.14, which will appear on the December bank statement. 7. The bank statement includes a $410.00 deduction for a cheque drawn by Ronald's Equipment Rentals. 8. The bank statement includes two charges for returned cheques from customers. One is a nonsufficient funds cheque in the amount of $67.50 received from a customer. The other is a $195.03 cheque received from another customer. It was returned by the customer's bank with the imprint "Unauthorized Signature". 9. A few customers pay monthly bills by EFT. The November bank statement lists an EFT deposit for sales revenue of $200.23. Required: 1. Prepare the bank reconciliation for Joe's Designer Warehouse at November 31st, 2020. 2. Journalize the transactions that are needed to update the Cash Account. Explanations are not required