Chapter 8 Excel Exercise Instructions: The cash account for West Co. on October 1 indicated a balance of $73,035. During October, the total cash deposited was $291,380 and checks written totaled $302,060. The bank statement indicated a balance of $96,122 on October 30. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: 1. Prepare a bank reconciliation as of October 31. a. Bank service charges for October amounted to $tos. b. A check for $860 returned with the statement had been recorded by West Coas 88,600. The check was for the payment of an obligation to Clinical Co on account c. Checks outstanding totaled 32,867, d. A check for $7.520 had been incorrectly charged by the bank as $7,250 c. A deposit of $10,980 representing receipts of October 31, had been made too late to appear on the banke statement. f. The bank had collected for West Co.$5,675 on a note left for collection. The face amount of the note was $5,200, g. A check for $1,700 from Sports Co was returned by the bank because of insufficient funds. I 2. Journalize the necessary entries. The accounts have not been closed. 3. If the balance sheet is prepared for West Co. on October 31, what amount should be reported as cash? 1. WEST CO. Bank Reconciliation October 31 Balance per bank statement Add: Deduct: Adjusted balance Balance per company's records Add: Deduct: Adjusted balance . 2. Oct 30 30 3. Amount to be reported as cash on Oct. 31 balance sheet