Subject is basic accounting

please show the calculation, you may show excel and calculation. Thank you.

Question 3 The following extract from the cash book of Johan for the month of January shows the company's bank transactions: RM RM 01 Jan Balance b/f 13 Jan Uno 31 Jan Latif 600 224 186 18 Jan Ali 28 Jan Utility (PBA) 30 Jan TNB 31 Jan Balance c/f 145 72 109 684 1,010 1,010 The company's bank statement for the same period is as follows: Debit (RM) Credit (RM) Balance (RM) 35 01 Jan Balance 03 Jan Halim 13 Jan Uno 23 Jan Ali 31 Jan Standing order 224 635 600 824 679 649 145 30 Required: (16 marks) (a) Prepare a corrected cash book using the information given above. (b) Draw up a bank reconciliation statement. (4 marks)