Prepare a corrected bank reconciliation *corrected adjusted balance must be $19,780 preferably formatted so it would be easy to translate into excel

Corrected adjusted balance: $19.780 Obj. 5 EX 7-22 Bank reconciliation The following bank reconciliation was prepared as of June 30, 2017: Poway Co. Bank Reconciliation For the Month Ended June 30, 2017 Cash balance according to bank statement... Add: Outstanding Check No. 1067 Outstanding Check No. 1106 Outstanding Check No. 1110 Outstanding Check No. 1113 Total additions. Deduct: Deposit of June 30 not recorded by bank.. Adjusted balance. Part B only 516,185 $ 575 470 1,050 910 3,005 16,600) $12,590 $ 8.985 $6,000 300 15 Cash balance according to company's records. Add: Proceeds of note collected by bank: Face value Proceeds of note collected by bank: Interest. Service charges Total additions. Deduct: Check returned because of insufficient funds Error in recording June 17 deposit of S7, 150 a $1,750....... Total deductions Adjusted balance.... 6,315 $ 890 5,400 (6,2901 $ 9,010