Pueblo Outfitters Reconciliation of Bank Statement DATE Check register Bank Statement balance 6/30/ balance 6/30/ - $32,411.28 Deduct: Add: Deduct: Adjusted check register Adjusted bank balance balance 6/30/-- 6/30/- Triple Star Bank Pueblo, Colorado Account No. 948723 July 17 I have finished reconciling the bank statement with our records for our money market account NO. 948725. Will you please do a reconciliation report in Excel for the checking account? The bank statement for the checking account is attached. I sent you the Excel file that contains the check register for the checking account for June. Remember to update the check register to show the service charge and any corrections that are needed. Thanks Amy Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a spreadsheet to prepare the reconciliation that she requests. Adjustments - Follow all instructions from the Simulation packet. - Use the datafile, SimP3J4ReconciliationStatement.xIsx, E Fto complete the reconcilation statement. - This is an Excel file, ilure to use cell references results in a 50\% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. Ready iT Rx Accessibility: Investigate Holidavs Are.ls Sheet2 Sheet3 Accessibility: Investigate