Motsepe Traders sells costume jewellery via the world wide web and has one retail store in Johannesburg. Motsepe Traders sells their merchandise on both a cash and credit basis and has a current banking account with ABBA Bank. On 31 July 2019, Bonisile Dube, the bookkeeper, received the Bank Statement from ABBA Bank dated 31 July 2019 and wishes to complete the bank reconcilation process before she goes home. The following information is taken from the books of Motsepe Traders: Bank Reconciliation Statement of Motsepe Traders as at 30 June 2019 Favourable balance as per bank statement 23 600 Outstanding deposit 18 600 Outstanding cheques: No. 202 22 400 No. 273 6 600 No. 275 14 600 Balance as per bank account ???? Bonisile Dube’s comparison with the above reconciliation statement, the cashbooks for July 2019 and the Bank Statement for July 2019 revealed the following: Provisional totals in the Cashbook Receipts and the Cashbook Payments on 31 July 2019 were R221 000 and R193 000, respectively. The outstanding cheque No. 202 did not appear on the bank statement. The cheque was originally issued to Monk Studios more than six months ago for advertising. Cheque No. 273 which was issued during the previous month still did not appear on the bank statement. Cheque No. 275 and the outstanding deposit of R18 600 appeared on the bank statement. Cheque No. 285 appeared on the bank statement as R12 400 and had been recorded in the cashbook as R14 400. An investigation revealed that the amount in the cashbook was the correct amount. The cheque had been used for cash purchases of inventory. A deposit dated 7 July was recorded in the cashbook as R14 000 and on the bank statement as R4 000. An investigation revealed that the bank statement amount was the correct one. The money had been received for sales of merchandise. A direct deposit of R7 000 appeared on the bank statement but not in the cashbook. It had been deposited by Neil Naidoo, a debtor settling his account of R8 000. The bank statement revealed a R/D cheque for R4 000. This cheque had been received from a debtor, Kieran Knight. The bank statement showed the following charges: Interest on overdraft R135 Services fees and cash handling fees (Bank charges) R240 Interest on CR balance R75. 10. A deposit dated 30 July 2019 for R7 000 recorded in the cashbook did not appear on the bank statement. 11. The following cheques No. 286 and No. 287 for R12 000 and R3 500, respectively, appeared in the cashbook but did not appear on the bank statement. 12. The bank statement showed a favourable balance as at 31 July 2019 of R58 800 Required: Q .1. Q.1.1 The cashbook receipts and cashbook payments for July 2019. Total the journal. Q1.2. The Bank Account for July 2019 (Note you need to calculate the opening balance of the bank account on the 1 July 2019). Balance the account Q.1.3 The Bank Reconciliation Statement as at 31 July 2019.
Good day . Can you please assist me with my homework below
Motsepe Traders sells costume jewellery via the world wide web and has one retail store in Johannesburg. Motsepe Traders sells their merchandise on both a cash and credit basis and has a current banking account with ABBA Bank.
On 31 July 2019, Bonisile Dube, the bookkeeper, received the Bank Statement from ABBA Bank dated 31 July 2019 and wishes to complete the bank reconcilation process before she goes home.
The following information is taken from the books of Motsepe Traders:
|
|
Favourable balance as per bank statement | 23 600 |
Outstanding deposit | 18 600 |
Outstanding cheques: No. 202 | 22 400 |
No. 273 | 6 600 |
No. 275 | 14 600 |
Balance as per bank account |
???? |
Bonisile Dube’s comparison with the above reconciliation statement, the cashbooks for July 2019 and the Bank Statement for July 2019 revealed the following:
- Provisional totals in the
Cashbook Receipts and the Cashbook Payments on 31 July 2019 were R221 000 and R193 000, respectively. - The outstanding cheque No. 202 did not appear on the bank statement. The cheque was originally issued to Monk Studios more than six months ago for advertising.
- Cheque No. 273 which was issued during the previous month still did not appear on the bank statement.
- Cheque No. 275 and the outstanding deposit of R18 600 appeared on the bank statement.
- Cheque No. 285 appeared on the bank statement as R12 400 and had been recorded in the cashbook as R14 400. An investigation revealed that the amount in the cashbook was the correct amount. The cheque had been used for cash purchases of inventory.
- A deposit dated 7 July was recorded in the cashbook as R14 000 and on the bank statement as R4 000. An investigation revealed that the bank statement amount was the correct one. The money had been received for sales of merchandise.
- A direct deposit of R7 000 appeared on the bank statement but not in the cashbook. It had been deposited by Neil Naidoo, a debtor settling his account of R8 000.
- The bank statement revealed a R/D cheque for R4 000. This cheque had been received from a debtor, Kieran Knight.
- The bank statement showed the following charges:
Interest on overdraft R135
Services fees and cash handling fees (Bank charges) R240 Interest on CR balance R75.
10. A deposit dated 30 July 2019 for R7 000 recorded in the cashbook did not appear on the bank statement.
11. The following cheques No. 286 and No. 287 for R12 000 and R3 500, respectively, appeared in the cashbook but did not appear on the bank statement.
12. The bank statement showed a favourable balance as at 31 July 2019 of R58 800
Required:
Q .1.
Q.1.1 The cashbook receipts and cashbook payments for July 2019. Total the journal.
Q1.2. The Bank Account for July 2019 (Note you need to calculate the opening balance of the bank account on the 1 July 2019). Balance the account
Q.1.3 The Bank Reconciliation Statement as at 31 July 2019.
Step by step
Solved in 4 steps with 3 images