quick response needed

Bank Reconciliation and Entries The cash account for Deaver Consulting at October 31, 20Y6, indicated a balance of $15,750. The bank statement indicated a balance of 531,095 on October 31, 2016. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $10,125 b. A deposit of $4,120, representing receipts from October 31, had been made too late to appear on the bank statement. C. The bank had collected $10,400 on a note left for collection. The face of the note was $10,000. d. A check for $1,200 returned with the statement had been incorrectly recorded by Deaver Consulting as $120. The check was for the payment of an obligation to Oxford Office Supplies Co. for the purchase of office supplies on account. e. A check drawn for $320 had been incorrectly charged by the bank as 5230. 1. Bank service charges for October amounted to S70. Instructions: 1. Prepare a bank reconciliation Deaver Consulting Bank Reconciliation October 31, 2016 Cash balance according to bank statement Add: Deposit of October 31, not recorded by bank 31.095 4,120 Deduct: Outstanding checks Adjusted balance Cast balance according to Deaver Consulting Adjusted balance Next 2. Illustrate the effects on the accounts and financial statements of the bank reconciliation. If no account or activity is affected, select "No effect from the dropdown and leave the corresponding number entry box blank. Enter account decreases and cash outflows as negative amounts. Increase in Cash: Balance Sheet Income Statement of Cash Flows Assets Liabilities + Stockholders' Equity Statement Oct. 31. Statement of Cash Flows Income Statement Decrease in Cash: Balance Sheet Income Statement of Cash Flows Assets Liabilities Stockholders' Equity Statement Oct. 31 Statement of Cash Flows Income Statenrent Check My Work