Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ADM-162-001 ADM-162 Job 4 Job 4 Balancing the monthly bank account statements with company records is an important task. Read Amy's note and create a
ADM-162-001
ADM-162
Job 4 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, SimP3J4 Reconciliation Statement.xlsx Minimize File Preview ZOOM + Pueblo Outfitters Reconciliation of Bank Statement DATE Check register balance 6/30/-- Deduct: Bank Stateme balance 6/30/ Add: I Deduct: Pueblo Outfitters Reconciliation of Bank Statement DATE Check register balance 6/30/- Deduct: Bank Statement balance 6/30/- Add: $32,411.28 Deduct: Adjusted check register balance 6/30/- Adjusted bank balance 6/30/- Job 4 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, SimP3J4Reconciliation Statement.xlsx, to complete the reconcilation statement. This is an Excel file, failure to use cell references results in a 50% deduction. a Save the file as LastNameP3J4. Submit to the correct dropbox. Job 4 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, SimP3J4 Reconciliation Statement.xlsx Minimize File Preview ZOOM + Pueblo Outfitters Reconciliation of Bank Statement DATE Check register balance 6/30/-- Deduct: Bank Stateme balance 6/30/ Add: I Deduct: Pueblo Outfitters Reconciliation of Bank Statement DATE Check register balance 6/30/- Deduct: Bank Statement balance 6/30/- Add: $32,411.28 Deduct: Adjusted check register balance 6/30/- Adjusted bank balance 6/30/- Job 4 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, SimP3J4Reconciliation Statement.xlsx, to complete the reconcilation statement. This is an Excel file, failure to use cell references results in a 50% deduction. a Save the file as LastNameP3J4. Submit to the correct dropboxStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started