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.

SWFT Comprehensive Vol 2020
43rd Edition
ISBN:9780357391723
Author:Maloney
Publisher:Maloney
Chapter16: Accounting Periods And Methods
Section: Chapter Questions
Problem 33P
icon
Related questions
Question
100%

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:

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:

  1. Provisional totals in the Cashbook Receipts and the Cashbook Payments on 31 July 2019 were R221 000 and R193 000, respectively.
  2. 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.
  3. Cheque No. 273 which was issued during the previous month still did not appear on the bank statement.
  4. Cheque No. 275 and the outstanding deposit of R18 600 appeared on the bank statement.
  5. 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.
  6. 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.
  7. 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.
  8. The bank statement revealed a R/D cheque for R4 000. This cheque had been received from a debtor, Kieran Knight.
  9. 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.

Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
Individual Income Taxes
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage