Function: SUM; Formula: Add, Subtract; Cell Referencing BE7.10 Using Excel to Prepare a Bank Reconciliation PROBLEM The folowing information relates to Southco Limited's Cash account. Student Work Area Required: Provide input into colls shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work area as indicated $ 18,920 Prepare the necessary Journal entries required on July 31 for Southco, 11 21,700 24,300 Add: 13 Reconciled cash balance from June's bank reconciliation Amounts from the general ledger; July cash receipts July cash payments Amounts from the July bank statement: Balance, July 31 Outstanding cheques Depost in trans EFT collections on account that were not yet recorded on the books NSF cheque NSF to Bank service charge Less: 15 10 17 19.260 3,630 1.450 Add: 1 20 21 22 2.170 1,270 50 90 Less: Bank service charge 34 25 Prepare the necessary journal entries required on July 31 for South Cash balance per books Cash balance per bank EFT collections on account Deposits in transit Outstanding cheques Bank service charge NSF cheque and fee Reconciled cash balance per bank Reconciled cash balance per books