On December 2017, Remy's cash book showed a debit balance of N29,520. His bank Statement showed a credit balance of N26,500. The reason for the difference were as follows: a. A cheque for N1960 was received and enter in the cash book but was not recorded in the bank statement. b. Un-presented cheques total N3,740 c. The payment side of the cash book had been under cast by N2,000 d. Standing order N1,260 appearing in the bank statement was yet to be posted in the cash book. e. A bill of exchange of 1,340 had matured and the bank had paid on Remy's behalf but it has not been recorded in the cash book. f. Dividends credited to his account of N1,240 had not been recorded in the cash book. g. A withdrawal of N1,440 by River another customer of the bank had been charged in error to Remy s account You are required to resolve the discrepancy using spread sheet