HW work on excel or paper (take a photo)

Page 1 of 2 - ZOOM + Cash Account No. 101 Date Item Urnl. Ref. Debit Credit Balance October 1 Balance 7,950 31 CR 6 9,330 17,280 31 CP 11 10,122 7,158 Cash Receipts (CR) Cash Payments (CP) Date Cash Debit Check No. Cash Credit October 2 $ 2,828 113 1,542 597 3114 1,729 10 1,652 115 1,830 16 837 3116 47 22 360 3117 782 29 904 3118 169 30 2.152 3119 478 1$ 9.330 3120 1,023 3121 234 3122 2.288 Total $ 10,122 Additional data for the bank reconciliation include the following: a. The EFT deposit was a receipt of monthly rent. The EFT debit was a monthly insurance payment. 5 The unauthorized signature check was received from a customer and returned by the bank unpaid. C. The correct amount of check number 3115, a payment on account, is $1,380. (Eddy Automotive's accountant mistakenly recorded the check as $1,830.) Prepare Eddy Automotive's bank reconciliation at October 31, 2018. 1 Prepare the journal entries required at October 31, 2018. . Describe how a bank account and the bank reconciliation help the general manager control Eddy Automotive's cash.Page 2 of 2 - ZOOM + 12/19/2019 Data Table Bank Statement for October 2018 Beginning balance $ 7,950 Deposits and other additions: October 600 EFT 2,828 A 9 597 12 1,652 17 837 22 360 23 ,500 BC 3,374 Checks and other deductions: October 1,542 13 1,380 14 419 US 15 1,729 18 47 21 441 EFT 26 782 30 169 30 10 SC (6,519) 9.805 Ending balance Explanation: BC - bank collection of note receivable from customer, EFT - electronic funds transfer, US - unauthorized signature, SC - service charge