Comparison of cash book and bank statement of Ocean Co. revealed the following information: Debit balance as per cash book Rs:10,000

(ii) Debit balance as per bank statement Rs 17.000

(iii) Debit memo for a cheque of Rs.10,000 marked NSF

(iv) Cheque deposit totaling Rs 40,000, but only Rs. 4,000 were cleared.

(v) Cheque issued for Rs.311000, but only Rs.19,000 were presented.

(vi) Late deposit not shown in bank statement Rs.32,000.

(vii) Advice received from bank that a customer had made direct deposit into the bank Rs,18,000. PAPA

(viii) Interest credited by bank Rs.2,500.

(ix) Locker charges debit by bank Rs.500,

REQUIRED: Prepare a bank reconciliation statement as of June 30. 2015.