please answer this question

MERCU TANDA BANK BERHAD (7029030-K) STATEMENT OF ACCOUNT ACCOUNT NO. BRANCH DATE 08379224146 ALOR SETAR 30 JUNE 2011 DATE PARTICULARS DEBIT June 1 Balance Cheque 376 200.00 7 Cash deposit 18 Cheque book 15.00 25 Dividend - HP Bhd 26 Cheque 377 400.00 28 Cash deposit 30 Interest 6 PAGE 1 CREDIT BALANCE 1,750.00 CE 1,550.00 Cr 120.00 1,670.00 CM 1,655.00 CM 60.00 1,715.00 C 1,315.00 C 45.00 1,360.00 Cr 95.00 1,455.00 Cr OPENING BALANCE WITHDRAWAL DEPOSIT CLOSING BALANCE . . NO. TOTAL 615.00 TOTAL 320.00 1,750.00 1,455.00 Prepare a bank reconciliation statement as at 30 June 2011 (Note: Please prepare your answer in excel) Q6. (20 marks) Ref Springfield Enterprise received a bank statement showing a different balance than reported in the company's bank account as at 30 June 2011. The details of the bank statement and Cash at Bank account are as follows: Bank Account Date Particulars Debit Credit Balance June 1 Balance 1,750.00 DE 4 Mahat - Cheque No. 376 200.00 1,550.00 Dr 7 Jamal 120.00 1,670.00 Dr 12 Rajan - Cheque No. 377 400.00 1,270.00 Dr 25 Karim 45.00 1,315.00 Dr 27 Omar - Cheque No. 378 175.00 1,140.00 Dr 30 Latit 80.00 1,220.00 Dr