TLSZO3A2522 7 for marks Saved Help Save & Exit Submit Check my work The general ledger of Michelle Company Ltd. showed a cash balance of $24,640 on 31 December 20X2, while the bank showed a balance of $59,500. The following facts were available: a. The bank collected $11,610 as a direct deposit for one of Michelle's customer as a payment on account. A $10 fee was charged by the bank for administration. Michelle has yet to record either of these amounts. b. Michelle paid a utilities bill of $350 through direct transfer from its bank account but has not yet recorded the payment. C. There was an outstanding deposit of $16,900 at the end of December d. The bank had charged a cheque of $2,700, 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,100 from a customer on account was recorded by Michelle for $2,800. The bank noticed the error and deposited the correct amount of money, but the deposit is incorrectly recorded on Michelle's books. f. Michelle's bank account shows a deposit of $23,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,210. This month, cheques were issued for $199,100, and cheques of $185,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 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 ist Thes Journal entry worksheet 1 2 3 > Record the cash receipt from accounts receivable and notes payable. Note: Enter debits before credits Transaction General Journal Debit Credit