calculate in detailed pls

The following information relates to the banking transactions of R Brown for the month of March Year 4: CASH BOOK (Bank columns only) 2 69 Year 4 Mar 1 Balance b/d 2,370 3 Sales 1,100 4 Sales 1,780 13 S Johnson 440 20 Sales 900 23 Sales 1,200 27 D Evans 640 Year 4 Mar 2 Purchases (81) 3 F Flinton 5 Wages (82) 10 Drawings (83) 16 Purchases (84) 24 Rent (85) 26 T Smith 28 Wages (86) 530 830 1,780 520 1,440 160 750 840 6 Provisional Dr Balance 1,580 BANK STATEMENT Dr () Cr () 530 1,100 830 1780 69 Year 4 Mar 1 Balance 2 81 4 Sales 4 F Flinton 5 82 10 Credit transfer: A Zimm 14 S Johnson 1684 20 S/O Block & Trent 24 Sales 26T Smith 28 D Evans 29 Direct Debit: B Traders 150 440 Balance () 2,370 Cr 1,840 Cr 2,940 Cr 2,110 Cr 330 Cr 480 Cr 920 Cr 520 Dr 660 Dr 540 Cr 210 Dr 430 Cr 350 Cr 1,440 140 1,200 69 750 49 640 69 80 REQUIRED 1. Starting with the Cash Book Balance on 31 March Year 4, bring the Cash book up to date by entering the appropriate items at the end of March and bring down the revised balance at 1 April year 4. (15pts) 2. Prepare the Bank reconciliation statement for R Brown at 31 March Year 4, starting with the Cash Book balance. (15pts)