Answer

les Cells A B C D E F G H K L M N Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Prepare a Bank Reconciliation Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use The following information relates to Ceilo Limited's Cash mathematical formulas with cell references to the Problem and work area account. as indicated. Reconciled cash balance from June's bank reconciliation $ 18,920 Prepare the necessary journal entries required on July 31 for Ceilo. Amounts from the general ledger: July cash receipts 21,700 Cash balance per books $ 21,700 July cash payments 24,300 Add: NSF cheque and fee 21,700 Amounts from the July bank statement: (2,780) 14 Balance, July 31 19,260 Less: NSF cheque and fee (2,780) 15 Outstanding cheques 3,630 Bank service charge S 50 16 Deposit in transit 1,450 EFT collections on account that were Bank service charge S 50 18 not yet recorded on the books 2,170 Add: Cash balance per books 90 19 NSF cheque IH 90 20 NSF fee 50 Less: Bank service charge 21 Bank service charge 90 Cash balance per books 22 Cash balance per books 23 24