5. Below are the bank columns of the cash journal of WWE and its account statement...

Transcribed Image Text:

5. Below are the bank columns of the cash journal of WWE and its account statement for November 2014. Cashbook (bank column only) 2014 $ 2014 $ 01-Nov Balance b/d 19,800 02-Nov Jada Ventures 3,700 05-Nov Cash deposit 5,600 08-Nov Veg Utilities 4,500 08-Nov Great Khali 5,500 10-Nov Tripple H 3,600 12-Nov Batista 2,500 15-Nov Kurt Angle 2,800 15-Nov Cash deposit 6,500 22-Nov John Cena 450 25-Nov King Buka 1,900 28-Nov Umaga 2,900 28-Nov Bobby Lashley 1,300 29-Nov Undertaker 2,400 30-Nov JH Medics 2,800 30-Nov Balance c/d 19,950 43,100 43,100 Balance b/d 19,950 Account Statement Date Description Withdrawal Deposit Balance 2014 $ $ $ 1-Nov Balance brought forward 19,800 4-Nov Cheque withdrawal - J Ventures 3,700 16,100 5-Nov Cash deposit 5,600 21,700 10-Nov Cheque deposit - G Khali 5,500 27,200 11-Nov Cheque withdrawal - Veg Utilities 4,500 22,700 12-Nov Cheque withdrawal - Tripple H 3,600 19,100 14-Nov Cheque deposit - Batista 2,500 21,600 15-Nov Cash deposit 6,500 28,100 18-Nov Cheque withdrawal - Kurt Angle 2,800 25,300 24-Nov Cheque withdrawal - John Cena 4,500 20,800 25-Nov Wire transfer - Randy Orton 2,100 22,900 28-Nov Mortgage payment - Papa's Property 2,500 20,400 29-Nov Pre-authorised payment - Insurance 1,200 19,200 30-Nov Monthly charge 10 19,190 Additional information: i. The mortgage deduction (i.e. to Papa's Property) was a mistake on the part of the bank. WWE made the final payment to Papa's Property at the end of September 2014. ii. The amount on the cheque to John Cena is $4,500. Required: (a) Update the cashbook of WWE. (b) Prepare a statement to reconcile the cashbook balance with the bank statement balance. 5. Below are the bank columns of the cash journal of WWE and its account statement for November 2014. Cashbook (bank column only) 2014 $ 2014 $ 01-Nov Balance b/d 19,800 02-Nov Jada Ventures 3,700 05-Nov Cash deposit 5,600 08-Nov Veg Utilities 4,500 08-Nov Great Khali 5,500 10-Nov Tripple H 3,600 12-Nov Batista 2,500 15-Nov Kurt Angle 2,800 15-Nov Cash deposit 6,500 22-Nov John Cena 450 25-Nov King Buka 1,900 28-Nov Umaga 2,900 28-Nov Bobby Lashley 1,300 29-Nov Undertaker 2,400 30-Nov JH Medics 2,800 30-Nov Balance c/d 19,950 43,100 43,100 Balance b/d 19,950 Account Statement Date Description Withdrawal Deposit Balance 2014 $ $ $ 1-Nov Balance brought forward 19,800 4-Nov Cheque withdrawal - J Ventures 3,700 16,100 5-Nov Cash deposit 5,600 21,700 10-Nov Cheque deposit - G Khali 5,500 27,200 11-Nov Cheque withdrawal - Veg Utilities 4,500 22,700 12-Nov Cheque withdrawal - Tripple H 3,600 19,100 14-Nov Cheque deposit - Batista 2,500 21,600 15-Nov Cash deposit 6,500 28,100 18-Nov Cheque withdrawal - Kurt Angle 2,800 25,300 24-Nov Cheque withdrawal - John Cena 4,500 20,800 25-Nov Wire transfer - Randy Orton 2,100 22,900 28-Nov Mortgage payment - Papa's Property 2,500 20,400 29-Nov Pre-authorised payment - Insurance 1,200 19,200 30-Nov Monthly charge 10 19,190 Additional information: i. The mortgage deduction (i.e. to Papa's Property) was a mistake on the part of the bank. WWE made the final payment to Papa's Property at the end of September 2014. ii. The amount on the cheque to John Cena is $4,500. Required: (a) Update the cashbook of WWE. (b) Prepare a statement to reconcile the cashbook balance with the bank statement balance.