Using Excel to Prepare a Bank ReconciliationThe following information relates to Ceilo Limnited's Cashccount.Reconciled cash balance fromJune's bank reconciliationPROBLEMAmounts from the general ledger:July cash receiptsJuly cash paymentsAmounts from the July bank statement:Balance, July $31$Outstanding chequesDeposit in transitEFT collections on account that werenot yet recorded on the booksNSF chequeNSF feeBank service charge$ $18,92021,70024,30019,2603,6301,4502,1701,2705090$Student Work AreaRequired: Provide input into cells shaded in yellow in this template. Usemathematical formulas with cell references to the Problemn and work areaas indicated.Prepare the necessary journal entries required on July $31$ for Ceilo.Cash balance per bankAdd: Deposits in transitLess: Outstanding chequesReconciled cash balance per bankCash balance per booksAdd: EFT collections on accountLess: Bank service chargeNSF cheque and feeReconciled cash balance per books$901,320$S$19,2601,45020,7103,63017,0802,1701,410$