Question 1.4 The records from a cash book and a bank statement are provided below. Use Template 4 in the spreadsheet provided to set out a bank reconciliation using the information below. (10 marks) Use template 4 of the XL workbook Question 1.4 Fill in the green blocks Cash book- Bank statement-R DR DR CR CR Balance Otober 2021 Description Otober 2021 Description 1 Opening balance 144 600 1 Opening balance 144 600 144 600 CR 195 000 195 000 4 Deposit 1 8 EFT pmnt 1 14 Ch 2193 21 Ch 2194 22 Ch 2195 29 Deposit 2 Balc/f 108 900 38 670 43 956 14 691 4 Deposit 1 8 EFT pmnt 1 14 Ch 2193 20 Debit - Top stores 29 Deposit 2 Bank charges 108 900 38 670 1448 339 600 CR 230 700 CR 192 030 CR 190 582 CR 205 273 CR 204 328 CR 14 691 55 350 945 188 733 394 950 394 950 188 733 Question 4 Fill in the green blocks Balb/d Bank balance 204 328 Cash book balance 188 733 1