20 2020 Question 1 (Marks: 20) The following information was taken from the books of Underwood Traders for December 2019 and January 2020: Items appearing on the bank reconciliation statement of Underwood Traders as at 31 December 2019 Bank Reconciliation Statement of Underwood Traders as at 31 December 2019 Details Amount (R) Balance per bank statement (favourable) 405 670 Outstanding cheques: No CQ221 6 780 No CQ276 12 450 No CQ298 21 560 No CQ305 13 240 Outstanding deposit: DS205 18 700 Correction of bank error on Deposit DS200- amount overstated by Bank 2 500 Balance per Bank account(favourable) 367 840 Cheque counterfoils of Underwood Traders-January 2020 Date Cheque Counterfoil no. 3 CQ306 Amount (R) 6 540 12 2410 CQ307 CQ308 16 12 500 17 CQ309 23 560 20 CQ310 1 470 3 260 21 CQ311 22 CQ312 15 320 23 CQ313 27 650 8 950 26 CQ314 29 CQ315 2 250 103 910 20 2020 Deposit slips of Underwood Traders- January 2020 Date Deposit Slip no. 5 DS206 Amount (R) 8 900 12 DS207 32 400 18 DS208 17 430 20 DS209 9650 21 DS210 27 890 22 DS211 36 540 132 810 Bank Statement from Capital Bank for Underwood Traders-January 2020 Date Description Debit(R) Credit(R) Balance(R) 1 Balance 405 670 Cr 1 CQ276 12 450 393 220 Cr 1 Deposit 18 700 411 920 Cr 3 CQ306 6540 405 380 Cr 5 Deposit 8 900 414 280 Cr 7 Correction of error on deposit 2 500 411 780 Cr 7 Monthly Service fees 1 760 410 020 Cr 12 CQ307 2410 407 610 Cr 12 Deposit 32 400 440 010 Cr 15 Debit Order 3 420 436 590 Cr 15 Internet bank fees 320 436 270 Cr 16 CQ308 12 500 423 770 Cr 17 CQ298 21 560 402 210 Cr 18 Deposit 15 430 417 640 Cr 20 CQ310 1470 416 170 Cr 20 Deposit 2 400 418 570 Cr 21 CQ311 1 260 417 310 Cr 22 Deposit 36 540 453 850 Cr 23 CQ313 27 650 426 200 Cr 23 CQ313 27 650 398 550 Cr 26 Transaction Fees 670 397 880 Cr 20 2020 27 CT402 13 400 28 Interest on credit balance 1 450 29 CQ315 2 250 384 480 Cr 385 930 Cr 383 680 Cr 382 710 Cr 369 910 Cr 394 770 Cr 30 970 30 Debit Order-Sky Wise Debit Order-JB Properties Deposit 12 800 30 24 860 Additional information: 1) 2) 3) ) 4) 5) Cheque no.CQ221 is now stale and must be cancelled. The bank has recorded cheque CQ311 at the incorrect amount. The deposit corresponding with DS208 was credited on the bank statement at the correct amount of R 15 430 The bank statement reflects a direct deposit (R 24 860) on 30 June, this was from tenant, K. Moody for his January rent. The debit order of R3 420, reflected on the bank statement, was in favour of Cellfirst who is the business's cellphone provider. The direct deposit on 20 January was a dividend received from XY Capital. Cheque no CT402 was incorrectly debited to the business bank account. The debit order in favour of Sky Wise is in favour of monthly fibre costs. The debit order in favour of JB Properties is for the business rent expense. CQ313 was incorrectly debited twice on the bank statement. 6) 7) 8) 9) 10) Required: Use the information given above to complete the following for January 2020: (74) Q.1.1 Record any differences identified in the bank reconciliation process in a supplementary cashbook receipts and payments with columns for details and amount. Begin with the totals before any amendments. Q.1.2 Open, post to and balance the bank account in the general ledger. (37) Q.1.3 Compile the bank reconciliation statement as at 31 January 2020. (6) 20 2020 (3) Q.1.4 After you have completed a bank reconciliation, there can be numerous un- reconciled bank statement debits. In your own words, explain the difference between a debit order and a stop order. 20 2020 Question 1 (Marks: 20) The following information was taken from the books of Underwood Traders for December 2019 and January 2020: Items appearing on the bank reconciliation statement of Underwood Traders as at 31 December 2019 Bank Reconciliation Statement of Underwood Traders as at 31 December 2019 Details Amount (R) Balance per bank statement (favourable) 405 670 Outstanding cheques: No CQ221 6 780 No CQ276 12 450 No CQ298 21 560 No CQ305 13 240 Outstanding deposit: DS205 18 700 Correction of bank error on Deposit DS200- amount overstated by Bank 2 500 Balance per Bank account(favourable) 367 840 Cheque counterfoils of Underwood Traders-January 2020 Date Cheque Counterfoil no. 3 CQ306 Amount (R) 6 540 12 2410 CQ307 CQ308 16 12 500 17 CQ309 23 560 20 CQ310 1 470 3 260 21 CQ311 22 CQ312 15 320 23 CQ313 27 650 8 950 26 CQ314 29 CQ315 2 250 103 910 20 2020 Deposit slips of Underwood Traders- January 2020 Date Deposit Slip no. 5 DS206 Amount (R) 8 900 12 DS207 32 400 18 DS208 17 430 20 DS209 9650 21 DS210 27 890 22 DS211 36 540 132 810 Bank Statement from Capital Bank for Underwood Traders-January 2020 Date Description Debit(R) Credit(R) Balance(R) 1 Balance 405 670 Cr 1 CQ276 12 450 393 220 Cr 1 Deposit 18 700 411 920 Cr 3 CQ306 6540 405 380 Cr 5 Deposit 8 900 414 280 Cr 7 Correction of error on deposit 2 500 411 780 Cr 7 Monthly Service fees 1 760 410 020 Cr 12 CQ307 2410 407 610 Cr 12 Deposit 32 400 440 010 Cr 15 Debit Order 3 420 436 590 Cr 15 Internet bank fees 320 436 270 Cr 16 CQ308 12 500 423 770 Cr 17 CQ298 21 560 402 210 Cr 18 Deposit 15 430 417 640 Cr 20 CQ310 1470 416 170 Cr 20 Deposit 2 400 418 570 Cr 21 CQ311 1 260 417 310 Cr 22 Deposit 36 540 453 850 Cr 23 CQ313 27 650 426 200 Cr 23 CQ313 27 650 398 550 Cr 26 Transaction Fees 670 397 880 Cr 20 2020 27 CT402 13 400 28 Interest on credit balance 1 450 29 CQ315 2 250 384 480 Cr 385 930 Cr 383 680 Cr 382 710 Cr 369 910 Cr 394 770 Cr 30 970 30 Debit Order-Sky Wise Debit Order-JB Properties Deposit 12 800 30 24 860 Additional information: 1) 2) 3) ) 4) 5) Cheque no.CQ221 is now stale and must be cancelled. The bank has recorded cheque CQ311 at the incorrect amount. The deposit corresponding with DS208 was credited on the bank statement at the correct amount of R 15 430 The bank statement reflects a direct deposit (R 24 860) on 30 June, this was from tenant, K. Moody for his January rent. The debit order of R3 420, reflected on the bank statement, was in favour of Cellfirst who is the business's cellphone provider. The direct deposit on 20 January was a dividend received from XY Capital. Cheque no CT402 was incorrectly debited to the business bank account. The debit order in favour of Sky Wise is in favour of monthly fibre costs. The debit order in favour of JB Properties is for the business rent expense. CQ313 was incorrectly debited twice on the bank statement. 6) 7) 8) 9) 10) Required: Use the information given above to complete the following for January 2020: (74) Q.1.1 Record any differences identified in the bank reconciliation process in a supplementary cashbook receipts and payments with columns for details and amount. Begin with the totals before any amendments. Q.1.2 Open, post to and balance the bank account in the general ledger. (37) Q.1.3 Compile the bank reconciliation statement as at 31 January 2020. (6) 20 2020 (3) Q.1.4 After you have completed a bank reconciliation, there can be numerous un- reconciled bank statement debits. In your own words, explain the difference between a debit order and a stop order