Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you show me steps please Question 4 The following is a summary of a cash book as presented by Excel Trading for the month

image text in transcribed can you show me steps please
Question 4 The following is a summary of a cash book as presented by Excel Trading for the month of November 20x8: 107,610 182 620 150,690 Payments 139.540 Balance dld 290.230 Balance b/d Receipts All receipts are banked and all payments are made by cheques. Upon investigation you discovered 1. Interest expense of $860 entered on the bank statement has not been entered in the cash book 2. Choques drawn amounting to $18,340 had not been presented to the bank for payment. 3. Cheques received in total $19,386 had been entered in the cash book and paid into the bank but had not been credited by the bank until 3 December 20x8. 4. A cheque drawn for $920 had been entered in the cash book as a receipt instead of as a 5. 6. payment A cheque received from K Wong for $1,800 had been returned by the bank and marked 'refer to drawer. No adjustment has been made in the cash book. An auto payment of $630 for management fce on 20 November had not been entered in the cash book . Total credit transfer during November was $23,620. No entry was made in the cash book on 8. A cheque of $860 to pay for motor expenses had been incorrectly entered in the cash book as this $60. 9. Dividends of $6,700 received had not been recorded in the cash book 10. The opening balance should be $1 50,960 instead of S150,690. Required: a) Update the cash book of Excel Trading for the month ended 30 November 20x8. (15 marks) (b) Prepare a bank reconciliation statement as at 30 November 20x8. (8 marks) (Total 23 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Industrial Energy Efficiency Energy Auditing Energy Management And Policy Issues

Authors: Patrik Thollander, Magnus Karlsson, Patrik Rohdin, Johan Wollin, Jakob Rosenqvist

1st Edition

0128172479, 978-0128172476

More Books

Students also viewed these Accounting questions

Question

Classify delivery styles by type.

Answered: 1 week ago