Data File: Part 3 Sim Check Register 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. 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 Triple Star Bank Pueblo, Colorado Pueblo Outfitters Account No. 948723 200 Victoria Avenue Statement Date 7/4/ Pueblo, CO 81003-3435 Statement Period 6/16/30,20. Job 4 Page 2 lancing 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 djustments - Follow all instructions from the Simulation packet. - Use the datafile, [ Minimize File Preview Clipboard Font Alignment Number y A B 1 C D F Pueblo Outfitters Reconciliation of Bank Statement DATE Check register Bank Statement balance 6/30/ balance 6/30/ - $32,411.28 Deduct: Add: Deduct: 7 Adjusted check register Adjusted bank balance 18 balance 6/30/.- 6/30/ \begin{tabular}{|l|l|l|l|l|} \hline 20 & \\ \hline 21 & \\ 23 & \\ 24 & \\ 25 \\ 26 \\ 27 \\ \hline 28 \\ \hline 29 \\ \hline 30 \\ 31 \\ \hline 32 \\ \hline 33 \\ \hline 34 \\ \hline 35 \\ \hline 36 \\ \hline 37 \\ \hline 38 \\ \hline \end{tabular} to complete the reconcilation statement. This is an Excel file. failure to use cell-references results in a 50% deduction. ve the file as LastNameP3J4. Submit to the correct drophox. Data File: Part 3 Sim Check Register 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. 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 Triple Star Bank Pueblo, Colorado Pueblo Outfitters Account No. 948723 200 Victoria Avenue Statement Date 7/4/ Pueblo, CO 81003-3435 Statement Period 6/16/30,20. Job 4 Page 2 lancing 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 djustments - Follow all instructions from the Simulation packet. - Use the datafile, [ Minimize File Preview Clipboard Font Alignment Number y A B 1 C D F Pueblo Outfitters Reconciliation of Bank Statement DATE Check register Bank Statement balance 6/30/ balance 6/30/ - $32,411.28 Deduct: Add: Deduct: 7 Adjusted check register Adjusted bank balance 18 balance 6/30/.- 6/30/ \begin{tabular}{|l|l|l|l|l|} \hline 20 & \\ \hline 21 & \\ 23 & \\ 24 & \\ 25 \\ 26 \\ 27 \\ \hline 28 \\ \hline 29 \\ \hline 30 \\ 31 \\ \hline 32 \\ \hline 33 \\ \hline 34 \\ \hline 35 \\ \hline 36 \\ \hline 37 \\ \hline 38 \\ \hline \end{tabular} to complete the reconcilation statement. This is an Excel file. failure to use cell-references results in a 50% deduction. ve the file as LastNameP3J4. Submit to the correct drophox