Cash Book and Bank Reconciliation Statement Q8

Q.
On 31st December, 2012, the bank column of TNT's cash book showed a debit balance of RM1,500. The monthly bank statement written-up to 31st December, 2012 showed a credit balance of RM2,950.

On checking the cash book with the bank statement, it was discovered that the following transactions had not been entered in the Cash Book:

i) Dividend of RM240 had been paid directly to the bank.
ii) A credit transfer - customs and Excise refund of RM260 - had been collected by the bank.
iii) Bank charges RM30.
iv) A direct debit of RM70 for the AVON subscription had been paid by the bank.
v) A standing order of RM200 for TNT's loan repayment had been paid by the bank.
vi) TNT's deposit account balance of RM1,400 was transferred into his bank current account.


A further check revealed the following items:-

i) Two (2) cheques drawn in favour of All RM250 and Faizal RM290 had been entered in the cash book but was not presented for payment.

ii) Cash of RM90 and cheques amounted RM600 had been paid to the bank on 31st December, 2012 but were not credited by the bank until 2nd January, 2013.

You are required to:

a) Starting with the debit balance of RM1,500, update the Cash Book (Bank Column) until the current date and show the balance of the bank statement.

b) Prepare a Bank Reconciliation Statement as at 31st December, 2012.

(20 marks, 2013 Q8)