solve on page i will give positive feedback

Q.3 The cashbook of Mr. Tahir only (bank column) is given below for the month of July 2013 (20) Rs. Rs. Balance b/d 8442 Payments 93120 Remits 90438 Balance c/d 5760 98880 98880 On comparing the Cashbook with the Bank Statement, the following discrepancies were noted: Bank charges of Rs.2100/- shown on the Bank Statement have not been recorded in the Cashbook. A cheque from Mr. Umer for Rs.1080/- has been returned dishonored by the bank but not written back in the Cashbook. c) Three cheques issued to the suppliers for Rs.12840/-, Rs.22200/- and Rs. 1800/- have not yet been presented to the bank. d) A pay-in-slip of the month of July, showing a deposit of Rs.92520/- has not yet been credited by the bank. e) Cheques amounting Rs.24000/- were deposited but not yet credited by bank. f) Dividend Rs. 1200/- collected and credited by bank was not recorded in the Cashbook. Required: 1) Revise the Cashbook for the month of July 2013. 2) Prepare a Bank Reconciliation Statement as on 31-07-2013