TOTAL MARKS 20 MARKS QUESTION 1 BANK RECONCILIATION The information given below was extracted from the accounting records of Mika Stores REQUIRED Complete the Cash Receipts Journal and Cash Payments Journal of Mika Stores for March 2018 after taking the information provided into account. Use only the columns illustrated below. In the details column write down the name of the contra account e.g. Rent income Cash Receipts Journal Details Bank Total (11) Cash Payments Journal Details Bank Total (3) (6) 1.2 Post to the Bank account in the General ledger of Mika Stores Balance the account 13 Prepare the Bank Reconciliation Statement as at 31 March 2018. Use the following format: Bank Reconciliation Statement as at 31 March 2018 Debit Credit INFORMATION 300 000 350 000 The bank column of each of the cash journals showed the following totals before the March 2018 bank statement was received: Cash Receipts Journal Cash Payments Journal A comparison of the cash journals of Mika Stores for March 2018 and the Bank Reconciliation Statement for February 2018 with the bank statement from Key Bank for March 2018 revealed the following differences: Entries that appeared on the bank statement but not in the cash Journals: A cheque previously received from the lessee for rent was dishonoured because of insufficient funds. A debit order in favour of Telkom for the personal telephone account of the proprietor Charges levied by Key Bank: Service fees Cash deposit fee Interest on overdraft A deposit by a debtor to settle his account of R6 200 A deposit by Key Bank for a successful loan application 6 800 2.12 3 800 2.1.3 1 500 1 000 100 6 000 50 000 2.1.4 2.1.5 12 Post to the Bank account in the General Post to the d a Stores Balance the account repare the Bank Reconciliation Statement as at 31 March 2018 Use the following format Bank Reconciliation Statement as at 31 March 2018 Debit Credit (6) INFORMATION The bank column of each of the cash journals showed the following totals before the March 2018 bank statement was received: Cash Receipts Journal 300 000 Cash Payments Journal 350 000 A comparison of the cash journals of Mika Stores for March 2018 and the Bank Reconciliation Statement for February 2018 with the bank statement from Key Bank for March 2018 revealed the following differences: Entries that appeared on the bank statement but not in the cash journals: A cheque previously received from the lessee for rent was dishonoured because of insufficient funds. 6 800 A debit order in favour of Telkom for the personal telephone account of the proprietor 3 800 Charges levied by Key Bank: Service fees 1 500 Cash deposit fee 1 000 Interest on overdraft 100 A deposit by a debtor to settle his account of R6 200 6 000 A deposit by Key Bank for a successful loan application 50 000 2.1.4 2.1.5 22.1 2.2.2 Entries in the cash lournals that did not appear in the bank statement: A deposit made on 31 March 2018 The following cheque issued during March 2018: Cheque no. 520 102 400 8700 3.1 16 140 4 800 Additional information Cheque no. 490 (dated 23 February 2018) which appeared in the Bank Reconciliation Statement for February 2018 did not appear in the bank statement for March 2018 Cheque no 460 issued to Rix Soccer Club during January 2018 as a donation must be cancelled as the club no longer exists. A deposit made by Rika Stores was erroneously reflected on the bank statement of Mika Stores An entry was made in the Cash Payments Journal for a cheque to a creditor MS Suppliers for R10 000. The bank statement reflected the correct amount of the cheque, R11 000 The bank account in the ledger of Mika Stores reflected a debit balance 4000 3.5 On 38 800 01 March 2018 The bank statement showed an unfavourable balance on 31 March 2018 3.6 END
