Question

In: Accounting

Bank statement for the month ending 30 April 2020. Bank statement Date Details Debit Credit Balance...

Bank statement for the month ending 30 April 2020.

Bank statement

Date

Details

Debit

Credit

Balance

01 Apr

Balance

19 200,00 Cr

02 Apr

Cheque No. 674

2 250,00

16 950,00 Cr

Deposit

4 800,00

21 750,00Cr

03 Apr

Deposit

1 500,00

23 250,00 Cr

05 Apr

Cheque No. 675

1 800,00

21 450,00 Cr

Bank charges

     195,00

21 255,00 Cr

08 Apr

Deposit

9 000,00

30 255,00 Cr

Cheque No. 678

     900,00

29 355,00 Cr

14 Apr

Deposit

3 000,00

32 355,00 Cr

Deposit

1 200,00

33 555,00 Cr

20 Apr

Cheque No. 679

3 300,00

30 255,00 Cr

23 Apr

Deposit

9 750,00

40 005,00 Cr

Cheque No. 680

1 650,00

38 355,00 Cr

R/D cheque

     450,00

37 905,00 Cr

25 Apr

Cheque No. 681

2 775,00

35 130,00 Cr

Debit order – Insurance

       75,00

35 055,00 Cr

28 Apr

Cheque No. 682

30 000,00

5 055,00 Cr

Cheque No. 683

2 250,00

2 805,00 Cr

29 Apr

Cheque No. 239

     228,75

2 576,25 Cr

30 Apr

Cheque No. 685

1 650,00

   926,25 Cr

ADDITIONAL INFORMATION

1.                  Cheque No. 239 shown on the bank statement was not drawn by Mantal Traders but instead by another client of the bank.

2.                  Cheque No. 685 was incorrectly recorded in the cash payments journal.

3.                  The deposit of R1 200 reflected on the bank statement was made by a debtor N Nets, without notifying the business.

4.                  Cheque No. 500, issued to V Vicks (a creditor) on 01 September 2019, has become stale and must be cancelled. A replacement cheque has not yet been issued.

5.                  The R/D cheque shown on the bank statement was from debtors, T Hamede.

REQUIRED:

a)      Balance as per bank account? ( 10 Marks)

(Example of an answer: 1750; NOT N$1750, NOT N$1750.00 don’t add a comma, space or full stop)

USE TWO DECIMAL PLACES WITH A FULL STOP WHERE APPLICABLE ONLY

Solutions

Expert Solution

ANSWER:

Balance as per Bank Account = 1155

CALCULATION:

Balance as on 30 Apr 926,25
Add: Cheque no 239 wrongly debited by bank 228,75
1155,00

EXPLANATION:

1) Cheque No. 239 shown on the bank statement was not drawn by Mantal Traders but instead by another client of the bank:

It is an incorrect debit by bank so it will be rectified by bank and accordingly amount of the cheque debited on Apr 29, will be credited by bank.

2) Cheque No. 685 was incorrectly recorded in the cash payments journal:

Incorrect recording in cash payment will shrunk cash balance in cash book, but bank has made correct entry of the transaction, so no correction is required regarding this.

3) The deposit of R1 200 reflected on the bank statement was made by a debtor N Nets, without notifying the business:

Deposit without our knowledge is already credited in bank account so no adjustment in bank statement, we require to add the amount in bank column of cash book.

4) Cheque No. 500, issued to V Vicks (a creditor) on 01 September 2019, has become stale and must be cancelled. A replacement cheque has not yet been issued:

Cheque issued to V Vicks is not presented at bank, and becomes stale does not require any adjustment in bank statement. however it would be deducted from bank column in cash book at the time of issuing cheque, so it need to be added back there.

5) The R/D cheque shown on the bank statement was from debtors, T Hamede.:

returned cheque is given effect in bank statement, so we require to enter it in cash payment journal, i.e. deduct from bank column of cash book.

***********************************************************************************************************************************

Please like if you got your query solved, reach back to us via comment if any query to understand. All the Best!


Related Solutions

10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The...
10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The balance on the bank statement is $8,000. At the end of April, the balance per the books is $5,020. There are checks outstanding of $5,800 and a deposit in transit of $4,000. On the bank statement there is a EFT received of $1,500. There is an NSF check from Steve Mayberry for $300 and a bank service fee of $20. What is the reconciled...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance of $4,188.30 as at 31 January 2020. The cash balance on the company’s books at 1 January 2020 was $176.00 (debit). The progressive totals of the Cash Receipts Journal and the Cash Payments Journal before considering items 1 to 5 below were $21,475.40 and $17,622.10 respectively. The following reconciling items were identified: (1) Un-presented cheques amounted to $501.25. (2) Debits included in the bank...
Crane Cable Trial Balance April 30, 2020 Debit Credit Cash $4,200 Accounts Receivable 3,100 Supplies 900...
Crane Cable Trial Balance April 30, 2020 Debit Credit Cash $4,200 Accounts Receivable 3,100 Supplies 900 Equipment 10,500 Accumulated Depreciation―Equip. $1,360 Accounts Payable 2,300 Salaries and Wages Payable 700 Unearned Service Revenue 900 Owner’s Capital 13,040 Service Revenue 5,500 Salaries and Wages Expense 3,500 Advertising Expense 700 Miscellaneous Expense 350 Depreciation Expense 550 $23,800 $23,800 Horace Culpepper reviewed the records and found the following errors. 1. Cash received from a customer on account was recorded as $630 instead of $580....
Seattle Coffee Limited's bank statement for the month of November 30, 2020 showed a balance per...
Seattle Coffee Limited's bank statement for the month of November 30, 2020 showed a balance per bank of $7,000. The company's general ledger Cash account showed a balance of $5,904 at November 30, 2020. Other information is as follows: 1. Cash receipts for November 30 recorded on the company's books were $5,200, but this amount does not appear on the bank statement. 2. The bank statement shows a Bank charge fee for $40 for cheque printing charges. 3. Cheque #119...
The Circus Company's bank statement for the month of April showed a balance per bank of...
The Circus Company's bank statement for the month of April showed a balance per bank of $7,000. The company's Cash account in the accounting records had a balance of $5,659 at April 30. Other information is as follows:  Cash receipts for April 30 recorded on the company's books were $6,000 but this amount does not appear on the bank statement.  The bank statement shows a debit memorandum for $40 for check printing charges.  Check No. 119 payable...
On April 30, First Blade receives its bank statement. The bank statement balance of cash as...
On April 30, First Blade receives its bank statement. The bank statement balance of cash as of April 30 is $3,490. The company deposits its receipts in the bank and makes all payments by check. There is a $110 debit memo on the bank statement. This is for an NSF check written by one of the company’s customers, R. Jacobs for $100 plus a bank fee of $10. The April 29th deposit for $154 was recorded in the company’s cash...
Auburn Company Worksheet (partial) For the Month Ended April 30, 2020 Adjusted Trial Balance Income Statement...
Auburn Company Worksheet (partial) For the Month Ended April 30, 2020 Adjusted Trial Balance Income Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash 10,000 Accounts Receivable 7,840 Prepaid Rent 2,280 Equipment 23,050 Accumulated Depreciation—Equip. 4,900 Notes Payable 5,700 Accounts Payable 4,920 Owner’s Capital 27,960 Owner’s Drawings 3,650 Service Revenue 15,590 Salaries and Wages Expense 10,840 Rent Expense 760 Depreciation Expense 650 Interest Expense 57 Interest Payable 57 Totals 59,127 59,127 Worksheet data for auburn company are...
The adjusted trial balance at April 30, 2017, for Willard Co. follows. Account Debit Credit Cash...
The adjusted trial balance at April 30, 2017, for Willard Co. follows. Account Debit Credit Cash $106,300 Accounts receivable 25,620 Trucks 560,000 Accumulated depreciation, trucks $84,000 Franchise 55,000 Accounts payable 20,540 Salaries payable 10,200 Unearned revenue 35,000 Sid Willard, capital 250,000 Sid Willard, withdrawals 75,000 Plumbing revenue 850,630 Depreciation expense, trucks 84,000 Salaries expense 272,450 Rent expense 60,000 Advertising expense 12,000 Income summary Totals $1,250,370 $1,250,370 Required: 1.      Prepare the four closing entries. 2.      Prepare a post-closing trial balance.
Roper Electronics received its bank statement for the month of August with an ending balance of...
Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for...
Roper Electronics received its bank statement for the month of August with an ending balance of...
Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT