Question

In: Accounting

QUESTION 2 The bank reconciliation statement on 30 September 2018 included the following:        Outstanding cheques...

QUESTION 2

The bank reconciliation statement on 30 September 2018 included the following:
       Outstanding cheques
Cheques not yet presented for payment No. 148 (Dated 10 November 2017) No. 358 (Dated 10 October 2018)
No. 400 (Dated 15 October 2018)
Debits
R 17.00 R 360.00 R 956.50
Credits
R1 255.00
               The bank statement on 31 October 2018 showed a favourable balance of R25 427.50. The general ledger account on the 1 October 2018 showed a debit balance of R25 249.50.
The comparison of the bank statement of October with the bank reconciliation statement of September and the cash journals of October showed the following differences:
1. Entries credited on the bank statement which do not appear in the cash journal for October 2018:
• Deposit R1 255
• Direct deposit R480 by Mr. King.
2. Entries debited on the bank statement which do not appear in the cash journal for October 2018:
• Debit order, R325. It is in favour of Knight Rental for rent.
• Cheque no 358, R360.
• Unpaid cheque, R582.50. This cheque was received from Ms. Queen but the cheque
was returned on 27 October 2018 marked insufficient funds.
• Unpaid cheque, R234.50. This cheque was received from Mr. Jack, deposited on 27
October, and returned on 28 October due to irregular signature.

• Unpaid cheque, R247.50. This cheque was received from Ms. Ace and deposited. It was returned by the bank since it was dated 1 November 2018.
• Cheque no. 223 issued to Mr. Ace for inventory, R1 285, was accidentally entered in the CPJ as R1 375.
• Charges for services fees, R30.50, and cash handling fees, R18.
3. Entries in the cash journal that do not appear on the bank statement:
• Cheque no 229 for R1 150 to Castle Wholesalers dated 15 October 2018.
• Cheque no 243 for R112.50 to Z Zeven dated 1 October 2018.
• Deposited on 1 October 2018, R2 445.
4. Cheque no 48 has not been re-issued to date.
You are required to:
a) Prepare the bank account in the general ledger for the month of October 2018.
b) Prepare the bank reconciliation statement as at 30 October 2018.

Please answer a and b.

Solutions

Expert Solution

Bank A/c in General Ledger
Balnce 1 October 2018 R25,250
Cash Deposited in Bank R1,255
King - Directly Deposited R480
Rent -Debit Order R325
Cheque 223 Difference Recorded R90
Service Charges R31
Cash Handling Charges R18
Balnce 31 October 2018 R26,701
R27,075 R27,075
BANK RECONCILIATION STATEMENT AS ON 31ST OCTOBER 2018
Balnce 31 October 2018 (GL) R26,701
Add: Cheques issued not yet presented
• Cheque no 229 for R1 150 to Castle Wholesalers dated 15 October 2018. R1,150
• Cheque no 243 for R112.50 to Z Zeven dated 1 October 2018. R113
.Cheque no 148 R17
.Cheque no 400 R957 R2,236
Total R28,937
Less: Cheque deposited Dishonored
Cash not credited in bank R2,445
• Unpaid cheque, R582.50. This cheque was received from Ms. Queen but the cheque R583
• Unpaid cheque, R234.50. This cheque was received from Mr. Jack, deposited on 27 R235
• Unpaid cheque, R247.50. This cheque was received from Ms. Ace and deposited. It was returned by the bank since it was dated 1 November 2018. R248 R3,510
Balance as per Bank statement Oct31,2018 R25,428
RECONCILIATION FROM 1ST OCTOBER 2018 GL BALANCE
Balance as per General ledger 1 Oct, 2018 R25,250 Dr
Add
Credited on the bank statement not in cash journal R1,255
Direct deposit by King into Bank R480
• Cheque no. 223 issued to Mr. Ace for inventory, R1 285, was accidentally entered in the CPJ as R1 375. R90
in journal not in bank statement:
• Cheque no 229 for R1 150 to Castle Wholesalers dated 15 October 2018. R1,150
• Cheque no 243 for R112.50 to Z Zeven dated 1 October 2018. R113
.Cheque no 148 R17
.Cheque no 400 R957 R4,061
Total R29,311
Less:
In Bank statement not in GL
• Debit order, R325. It is in favour of Knight Rental for rent. R325
• Unpaid cheque, R582.50. This cheque was received from Ms. Queen but the cheque R583
• Unpaid cheque, R234.50. This cheque was received from Mr. Jack, deposited on 27 R235
• Unpaid cheque, R247.50. This cheque was received from Ms. Ace and deposited. It was returned by the bank since it was dated 1 November 2018. R248
• Charges for services fees, R30.50 R31
• handling fees, R18. R18
• Deposited on 1 October 2018, R2 445. R2,445 R3,883
Balance as per Bank R25,428 Cr

Related Solutions

A cheque that was outstanding las month's bank reconciliation was not among the cancelled cheques returned...
A cheque that was outstanding las month's bank reconciliation was not among the cancelled cheques returned by the bank this month. As a result in preparing this month reconciliation, the amount of this cheque should be a. added to book balance of cash b. deducted from the book balance of cash c. Added to the bank balance of cash d. deducted from the bank balance of cash e. Noted as a memo
GENERAL COMPANY Bank Reconciliation: 1st National Bank September 30, 2018 1 Balance per bank 28,375 2...
GENERAL COMPANY Bank Reconciliation: 1st National Bank September 30, 2018 1 Balance per bank 28,375 2 Deposits in transit 29-Sep 4,500 30-Sep 1,525 6,025 34,400 3 Outstanding Check 31-Aug 2,200 26-Sep 675 27-Sep 850 29-Sep 2,500 30-Sep 7,225 (13,450) 20,950 4 Customer note collected by the bank -3,000 5 Error: Check #1282, written on 26-Sep for 270 was erroneously charged by the bank as $720; bank was notified 2-Oct. 450 6 Balance per books 18,400 Assume these facts: • The...
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank Reconciliation For the Month Ended June 30, 20Y7 Cash balance according to bank statement $16,185 Adjustments: Outstanding Check No.1067 $575 Outstanding Check No.1106 470 Outstanding Check No.1110 1,050 Outstanding Check No.1113 910 Deposit of June 30 not recorded by bank (6,600) Total adjustments (3,595) Adjusted balance $12,590 Cash balance according to company’s records $8,985 Adjustments: Proceeds of note collected by bank: Face value $6,000...
A table for a monthly bank reconciliation dated September 30 is given below. For each item...
A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation. (Select the answers in the appropriate cells. Leave no cells blank. Be certain to select "NA" in fields which are not applicable.)
A table for a monthly bank reconciliation dated September 30 isgiven below. For each item...
A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation.(Select the answers in the appropriate cells. Leave no cells blank. Be certain to select "NA" in fields which are not applicable.)
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores for January 2020. The financial year of the business ends in January each year. Bank overdraft as per bank statement R35 000 Outstanding deposit on 10 January 2020 R12 900 28 January 2020 R10 000 Outstanding deposit: Cheque received from B Brother dated 24 February 2020 R1 800 Outstanding cheques: No. 1642 (dated 20 July 2019) R7 000 No. 9172 (dated 25 January 2020)...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores for January 2020. The financial year of the business ends in January each year. Bank overdraft as per bank statement R35 000 Outstanding deposit on 10 January 2020 R12 900 28 January 2020 R10 000 Outstanding deposit: Cheque received from B Brother dated 24 February 2020 R1 800 Outstanding cheques: No. 1642 (dated 20 July 2019) R7 000 No. 9172 (dated 25 January 2020)...
Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash...
Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash balance of $7,582. The cash account in the company's general ledger (G/L), according to the company's records on April 30, had a balance of $4,643. The following additional data were revealed during the reconciliation process: 1.A deposit of $652 that had been made by the company on March 31 was processed by the bank in April, and a deposit of $1,531 made on April...
In a company‘s bank reconciliation and outstanding check is a check that?
In a company‘s bank reconciliation and outstanding check is a check that?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT