on 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, ports 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 73F Sunny ourse Evaluation Course Eval Reports marthinking Modules Harmonize Credentials Harmonize C Check register balance 6/30/-- Deduct: Pueblo Outfitters Reconcillation of Bank Statement DATE Bank Statement balance 6/30/-- Add: $32,411.28 Deduct: Adjusted check register balance 6/30/-- Adjusted bank balance 6/30/- 73F Sunny 11:12 AM 4/12/2023 E 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 Corrections that any are needed. Thanks Amy 200 Victoria Avenue Pueblo, CO 81003-3435 Balance from Previous Statement 35,897.53 Number of Total Deposits Credits 26 and Credits 95,286.50 Statement Date 174- Number of of Debits 36 Statement Period 6/1 6/30, 31 Total Withdrawals and Debits Statement Balance Date Description 98,771.75 32,411.38 Checks Deposits Withdrawals Balance Beginning Balance 35.897.53 6/1/- Check 13370 202.16 35,695.37 6/1/- Deposit 3,660.25 39,355.62 6/2/- Deposit 3,705.45 43,061.07 6/3/- Deposit 3,548.74 46,609.81 6/3/- Check 13371 156.00 46,453.81 6/3/- Check 13372 1,067.89 45,385.92 6/3/- Check 13373 601.59 44,784.33 6/3/- Check 13374 533.10 44,251.23 6/3/- Check 13375 414.64 43,836.60 6/3/- Check 13376 444.44 43,392.15 6/3/- Check 13377 820.25 42,571.91 6/3/- Check 13378 451.27 42,120.64 6/3/- Check 13379 952.50 41,168.14 6/3/- Check 13380 496.21 40,671.93 6/3/- Check 13381 472.29 40,199.64 6/3/- Check 13382 484.58 39,715.06 6/4/- Deposit 4,798.74 44,513.80 6/6/- Check 13383 58.93 44,454.87 6/6/- Deposit 2,998.61 47,453.48 6/7/- Deposit 3,587.35 51,040.83 6/8/- Deposit 3,487.52 54,528.35 6/8/- Check 13384 2,400.00 52,128.35 6/9/-- Check 13385 15,892.25 36,236.10 6/9/- Check 13386 18,945.26 17,290.84 6/9/- Check 13387 3,496.40 13,794.44 6/9/- Deposit 3,677.22 17,471.66 6/10/-- Deposit 3,599.23 21,070.89 Date Description Deposits Checks/ Withdrawals Balance 6/11/-- Deposit 4,486.24 25,557.13 6/13/-- Deposit 4,005.36 29,562.49 6/14/- Deposit 2,875.48 32,437.97 6/14/- Check 13388 260.23 32,177.74 6/14/- Check 13389 585.75 31,591.99 6/15/- Deposit 3,788.59 35,380.58 6/16/- Deposit 3,899.64 39,280.22 6/17/- Deposit 3,974.15 43,254.37 6/17/-- Check 13390 6/17/- Check 13391 1,067.89 601.59 42,186.48 41,584.89 6/17/-- Check 13392 533.10 41,051.79 6/17/-- Check 13393 414.64 40,637.15 6/17/- Check 13394 444.44 40,192.71 6/17/- Check 13395 820.25 39,372.46 6/17/-- Check 13396 451.27 38,921.19 6/17/- Check 13397 952.50 37,968.69 6/17/- Check 13398 496.21 37,472.48 6/17/- Check 13399 472.29 37,000.19 6/17/-- Check 13400 484.58 36,515.61 6/18/-- Deposit 4,758.92 41,274.53 6/20/-- Deposit 3,699.54 44,974.07 6/21/-- Deposit 3,278.52 48,252.59 6/22/-- Deposit 3,189.56 51,442.15 6/23/-- Deposit 3,410.63 54,852.78 6/24/-- Deposit 3,489.61 58,342.39 6/24/-- Check 13401 1,280.00 57,062.39 6/24/-- Check 13402 1,200.00 55,862.39 6/24/-- Check 13403 800.26 55,062.13 6/25/-- Deposit 3,799.65 58,861.78 6/27/-- Transfer to Act. No. 948725 40,000.00 18,861.78 6/27/-- Deposit 3,678.25 22,540.03 6/28/-- Deposit 3,589.65 26,129.68 6/29/-- Deposit 3,488.51 29,618.19 6/30/-- Deposit 2,811.09 32,429.28 6/30/-- Service Charge 18.00 32,411.28 Page 2 m D A Date 1 anul 2 3 Positio 4 Pueblo Oufitters Expense Budget For the Month Ending June 30,2023 04/12/ 5 04/12/2 Variance Variance 04/12/6 Expense Item June Actual June Budget Amount Percent 04/12/17 Payroll Expense $22,860.00 $23,000.00 -$140.00 -0.61% 04/12/8 Payroll Tax Expense $1,748.79 $1,800.00 -$51.21 -2.85% 5 04/12/9 Health Insurance Expense $2,400.00 $2,400.00 $0.00 0.00% 7 04/12/10 Rent Expense $1,200.00 $1,200.00 $0.00 0.00% 8 04/12/11 Utilities Expense $800.26 $785.00 $15.26 1.94% 19 04/12/ 12 Telephone/Internet Expense $202.16 $200.00 $2.16 1.08% 20 04/12/ 13 Advertising Expense $558.75 $500.00 $58.75 11.75% 21 04/12/14 Office Supplies Expense $260.23 $250.00 $10.23 4.09% 22 04/12/15 Insurance Expense $1,280.00 $1,280.00 $0.00 0.00% 23 04/12/16 Depreciation Expense $1,000.00 $1,000.00 $0.00 0.00% 24 04/12/17 Miscellaneous Expense $462.25 $500.00 -$37.75 -7.55% 25 04/12/18 Total Expenses $32,772.44 $32,915.00 -$142.56 0.43% 26 04/12/19 27 04/12/20 28 04/12/21 29 04/12/1 22 30 04/12/23 31 04/12/1 24 32 04/12/1 25 33 04/12/26 34 04/12/1 27 35 04/12/ 28 36 04/12/29