Bank Reconciliation and Entries The cash account for Coastal Bike Co. at October 1, 2019, indicated a balance of $13,150. During October, the total cash deposited was $65,700 and checks written totaled $61,000. The bank statement indicated a balance of $22,270 on October 31, 2019. Comparing the bank statement, the canceled checks, and the accompanying memes with the records revealed the following reconciling items! a. Checks outstanding totaled $9,920. b. A deposit of $8,080, representing receipts of October 31 had been made too late to appear on the bank statement c. The bank had collected for Coastal Bike Co. $4,270 on a note left for collection. The face of the note was $3,940. d. A check for $270 returned with the statement had been incorrectly charged by the bank as $720. e. A check for $970 returned with the statement had been recorded by Coastal Bike Co. as $790. The check was for the payment of an obligation to Rack Pro Co. on account. f. Bank service charges for October amounted to $70. 9. A check for $990 from Bay View Condos was returned by the bank due to insufficient funds. Instructions: 1. Prepare a bank reconciliation as of October 31, 2019. Coastal Bike Co. Bank Reconciliation October 31, 2019 Cash balance according to bank statement Adjustments: Deposit of October 31, not recorded by bank 1. Prepare a bank reconciliation as of October 31, 2019, Coastal Bike Co. Bank Reconciliation October 31, 2019 Cash balance according to bank statement Adjustments: Deposit of October 31, not recorded by bank Check returned because of insufficient funds Outstanding checks Total adjustments Adjusted balance Cash balance according to company's records Adjustments: Odo Total adjustments Adjusted balance Total adjustments Adjusted balance 2. Journalize the necessary entries (a.) that increase cash and (b) that decrease cash. The accounts have not been closed. For a compound transaction, if an amount box does not require an entry, leave it blank a. 2079 Oct. 31 W dll 100 b. Oct. 31 3. If a balance sheet were prepared for Coastal Bike Co. on October 31, 2019, what amount should be reported as cash? Previous MA