Financial statement analysis (Excel chart)with explanation

20. BANK RECONCILIATION D.J. Hunter's checkbook lists the following: Check Date No. Item Check Deposit Balance 9/1 $ 525 4 622 La Petite French Bakery $ 19 506 9 Dividends Received $ 116 622 13 623 General Tire Co. 43 579 14 624 Exxon Oil Co. 58 521 18 625 Cash 50 471 26 626 Fellowship Bible Church 25 446 28 627 Bent Tree Apartments 275 171 30 Paycheck 1,800 1,971 Hunter's September bank statement shows the following: Balance . . . . .. . .. . .. $525 Add: Deposits . .. .... Deduct checks: 116 No. Amount 622 360.0 $19 623 43 624 68 625 50 (180) Other charges: Printed checks $ 8 Service charge 12 (20) Balance $441 *This is the correct amount for check number 624. Prepare Hunter's bank reconciliation at September 30