The general ledger of Michelle Company Ltd. showed a cash balance of $23,400 on 31 December 20x2, while the bank showed a balance of $59,900. The following facts were available: a. The bank collected $11.810 as a direct deposit for one of Michelle's customer as a payment on account. A $30 fee was charged by the bank for administration. Michelle has yet to record either of these amounts. b. Michelle paid a utilities bill of $390 through direct transfer from its bank account but has not yet recorded the payment. c. There was an outstanding deposit of $17.300 at the end of December d. The bank had charged a cheque of $3,100, written by Mitchell Corp., to Michelle's bank account. The bank has been contacted about the error, and will reverse the cheque in January. e. A deposit of $1.300 from a customer on account was recorded by Michelle for $3,200. The bank noticed the error and deposited the correct amount of money, but the deposit is incorrectly recorded on Michelle's books. 1. Michelle's bank account shows a deposit of $27,000 in December, which is an increase in Michelle's bank loan. The amount has not been recorded by Michelle. g. At the end of November, outstanding cheques were $8,310. This month, cheques were issued for $199,500, and cheques of $187.400 cleared the bank account. Required: 1. Prepare a bank reconciliation, in good form, at the end of December 20X2. Bank Reconciliation 31 December 20X2 Bank Books Balances, 31 December Additions: Deductions Correct cash balance $ 0 S 0 2. Prepare any adjusting journal entries required as a result of the reconciliation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet 2. Prepare any adjusting journal entries required as a result of the reconciliation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet 1 3 3 Record the adjusting entry due to deposit recording error. Note: Enter debits before credits. Transaction Genral Journal Debit Credit Record entry Clear entry View general journal 2. Prepare any adjusting journal entries required as a result of the reconciliation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet