Sheet1 Sheet2 A1 fx CHECKREGISTER \begin{tabular}{c|c} \hline 1 & Pueblo Outfitters \\ \hline 2 & Reconciliation of Bank Statement \\ \hline \end{tabular} DATE \begin{tabular}{|c|l|l|l|} \hline 4 & & \\ \hline 5 & Check register & Bank Statement \\ \hline 6 & balance 6/30/- & balance 6/30/ \\ \hline 7 & Deduct: & Add: \\ \hline 8 & Service Charge & \\ \hline 9 & & 18.00 & \\ \hline 10 & & Deduct: \\ \hline 11 & & \\ \hline 12 & & \\ \hline 13 & & \\ \hline 14 & & \\ \hline 15 & & \\ \hline 16 & & \\ \hline 17 & Adjusted check register & Adjusted bank balance \\ \hline 18 & balance 6/30/- & 6/30/ \\ \hline \end{tabular} 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 - Page 2 Sheet1 Sheet2 A1 fx CHECKREGISTER \begin{tabular}{c|c} \hline 1 & Pueblo Outfitters \\ \hline 2 & Reconciliation of Bank Statement \\ \hline \end{tabular} DATE \begin{tabular}{|c|l|l|l|} \hline 4 & & \\ \hline 5 & Check register & Bank Statement \\ \hline 6 & balance 6/30/- & balance 6/30/ \\ \hline 7 & Deduct: & Add: \\ \hline 8 & Service Charge & \\ \hline 9 & & 18.00 & \\ \hline 10 & & Deduct: \\ \hline 11 & & \\ \hline 12 & & \\ \hline 13 & & \\ \hline 14 & & \\ \hline 15 & & \\ \hline 16 & & \\ \hline 17 & Adjusted check register & Adjusted bank balance \\ \hline 18 & balance 6/30/- & 6/30/ \\ \hline \end{tabular} 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 - Page 2