Topic: Bank Reconciliation

The owner of Babasiga Hardware has completed bank reconciliation and cannot get the bank's records to agree with the cash records of his business. He concludes that internal control has somehow failed and cash is being misappropriated. He asks you to check the records and confirm otherwise his suspicions. He supplies the reconciliation statement at the end of last month, his cash records, and the most recent bank statement.

Last Month's Reconciliation statement is presented below:

Bank Reconciliation Statement as at 31 May 2010

($)

Balance as per Bank Statement 30 April 2010 4328.90 Cr

Add: Outstanding Deposit 1224.50

5553.40

Less: Unpresented Cheques 223.70

Balance per Cash at Bank Account at 31 May 2010 $5329.70 Dr

The total of the cash receipts journal for June is $64,776.30 and the total of the cash payments journal is $63,265.60. The current bank statement shows that cheques presented and paid amount to $59,725.10, and total deposits amount to $64,780.60. There are also additional debits on the statement for a dishonored cheque for $210.00, and account fees for $20.00.

An examination of the records reveals that all reconciling items at 31 May 2010 appear in the bank statement for June, unpresented cheques at 30 June total $7154.40, and the 30 June deposit of $1950.40 has not been credited by the bank. Your check of the cash journals reveals that addition errors have been made by the clerks responsible. Receipts should total $65,766.30 and payments should total $63,185.60.

Good Luck

Required:

a) Recalculate and present the general ledger Cash at Bank account balance as it should be at 30 June 2010. (5 marks)

b) Prepare the bank reconciliation statement at 30 June 2010. (5 marks)