Job 4 Simulation Part Three Job 4 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.xlsx, to complete the reconcilation statement. This is an Excel file, failure to use cell references results in a 50% deduction. Save the file as LastNameP3J4. Submit to the correct dropbox. Previous Next From the Desk of Amy Mosley 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 Check register balance 6/30/-- Deduct: Pueblo Outfitters Reconciliation of Bank Statement DATE A Bank Statement balance 6/30/- $32,411.28 Add: Deduct Adjusted check register balarice 6/301- Adjusted bank balance 6/30/- he reconcilation statement. all references reculte in 50% deduction 1 ZOOM +