Based on the following information, (a) prepare a bank reconciliation in the proper format using Excel and (b) prepare the necessary adjusting journal entries. 1. Ending balance per bank statement $7,349.46 2. Ending cash balance per general ledger $5,432.76 3, Check outstanding $2,131.85 4. Deposit in transit not recorded by bank $1,243.15 5. Note collected by bank $1,015 inclusive of $15 interest 6. A check in the amount of $46 for supplies was erroneously entered as $64. 7. Bank service charges were $5. Instructions: Use Excel to prepare the reconciliation and journal entries.