INSTRUCTIONS -- ASSIGNMENT 6.55 This problem asks you to "prepare a corrected reconciliation and explain the problem." If there is a manipulation in the bank statement, prepare a corrected bank reconciliation. In this problem, the report Reconciliation contains a bank reconciliation working paper.The working paper is intended to give you some hands-on experience in creating audit documentation in Excel. The bank reconciliation is empty--awaiting your entry of amounts and notations of audit work. When you get the Reconciliation, select the word "index". Type an index number for your working paper and press [Return].You will then need to move the cursor around to enter amounts and arithmetic functions. Enter the proper "Bank Bal." Enter the appropriate amounts where the question marks appear. You must decide the amounts to enter. For example, if you think other checks should be entered as outstanding or deposits in transit need correction, enter the proper amounts. Where the word "Total" and the symbol "+/-" appear, you need to put arithmetic functions to add and subtract the amounts in the schedule. The "TM" are places for you to put letters a,b,c,d,e,f which are "tick marks" indicating the audit work you performed. Put the cursor on the "TM" and enter the letters that describe your audit work. After you print your working paper, enter other names and dates by hand. Index Iman Said 10/10/18 Reviewed CAULCO, INC. Bank Account Reconciliation (Date) Balance per bank statement: TM Bank Bal Add: Deposit in transit TM ? Deposit in transit TM ? --------- Total of reconciling additions Total Deduct outstanding checks: Ck. # Date Payee Amount # TM ? TM # TM ? TM # TM ? TM # TM ? TM # TM ? TM # TM ? TM Total outstanding checks Total Other deduction items TM ? Total of reconciling deductions Total Reconciled bank balance +/- Balance per books TM Book Bal Unreconciled difference +/- a Vouched bank balance to bank statement b Vouched to bank statement deposit dated c Vouched to bank statement credits d Vouched to cancelled checks returned next bank statement e Same as amount recorded in cash disbursements journal f Traced to general ledger cash account