Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. Prepare Computer Wizard's bank reconciliation statement as of December 31, 2018, including the calculation of the book balance of December 31, 2018. B. Prepare

image text in transcribedimage text in transcribedimage text in transcribed
A. Prepare Computer Wizard's bank reconciliation statement as of December 31, 2018, including the calculation of the book balance of December 31, 2018. B. Prepare all necessary journal entries that would be required as a result of the December 31, 2018 bank reconciliation statement.Computer Wizard hired an accounting assistant, Joe John, who accidentally deleted some of Computer Wizard's November 30, 2018 data, including the cash balance and the bank reconciliation. Accountant Wendy World was able to obtain the following from Computer Wizard's accounting and banking records: a. Wendy World determined that two cheques (# 280 for $ 500.00 and # 287 for $ 660.00) had not been cashed as of December 01. Wendy World was positive that there was only one deposit in transit on the November 30 bank reconciliation, but she was unable to remember the amount. b. The cash receipts and cash payments journals contained the following entries for December 2018: Cash Receipts Cash Payments Amounts Cheque # Amount 5 900.00 300 5 300.00 1,800.00 301 140.00 3,500.00 302 160.00 3,000.00 303 800.00 700 00 304 570.00 $ 9.900 0.0 305 3,500.00 306 void 307 190.00 308 1,100.00 $ 7.660 00c. Computer Wizard's bank provided the following statement as of December 31, 2018: + Date Cheques and Other Debits Deposits and Other Credits Balance Dec. # 301 440.00 2,500.00 7,000.00 # 287 560.00 6,340.00 5 # 302 460.00 5,880.00 900.00 5,780.00 14 # 300 300.00 1,200.00 7,680.00 17 EFT 600.00 7,080.00 19 EFT 420.00 7,500.00 22 # 304 570.00 1.800.00 8,730.00 22 # 305 3,900.00 EFT 1.300.00 6,130.00 24 EFT 850.00 6,980.00 27 NSF 1,000.00 3.500.00 9.480.00 28 SC 50.00 9.430.00 31 # 308 1,100.00 8,330.00 d. The deposit made on December 14 was for the collection of a note receivable ($ 1,100.00) plus interest. e. The electronic transfers (EFTs) had not yet been recorded by Computer Wizard because the bank statement was the first notification of them. . The December 17 EFT was for the monthly payment on an insurance policy for Computer Wizard. . The December 19 and December 22 EFTs were collections on accounts receivable. . The December 24 EFT was in error, the transfer should have been to Computer World. E. The NSF cheque on December 27 was received from a customer as payment for computer repairs. g. Cheque # 305 was correctly written for $ 3,900.00 for the purchase of computers (assume a periodic inventory system) but was incorrectly recorded by the accounting assistant

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Auditing and Assurance services an integrated approach

Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley

14th Edition

133081605, 132575957, 9780133081602, 978-0132575959

Students also viewed these Accounting questions