APPLY YOUR SKILLS 5-5 QG Reconcile a Credit Card Account In this exercise, you will reconcile the American Express account. 1. Use this statement to reconcile the June American Express account: American Express 75 Big Apple Way New York, NY 10012 (800) 555-2639 Statement of Account 6/1/2023 -6/30/2023 American Express Account #7777 888899 99944 New Balance $579.27 Account Summary Minimum Payment Due $35.00 Previous Balance $0.00 Payment Due Date 07/30/2023 Payments and Credits: $38.29 New Charges $617.56 Fees $0.00 Interest Charged $0.00 Transaction Details Charge Credit Balance Date Beginning Balance 0.00 6/1/2023 Bothell Pet Supply Company 115.43 115.43 6/4/2023 Glen's Handyman Service 108.70 224.13 6/10/2023 Thrifty Grocery 26.73 250.86 6/12/2023 Billy's Van Service 256.49 507.35 6/14/2023 Karel's Gardening Service 60.00 567.35 6/20/2023 Bothell Pet Supply Company 38.29 529.06 6/22/2023 Laura's Cafe 50.21 579.27 2/28/2022 Interest Paid 0.00 579.27 2/28/2022 Fees 0.00 579.27 2/28/2022 Ending Balance $579.27 2. Run the Summary Reconciliation report, write a check to American Express for the entire amount on 07/03/2023, using AMEX June 2023 for both memo fields. Choose to Print Later and then run the Summary Reconciliation report. 3. Ensure the Summary Reconciliation report is showing and then click the Excel button and export this list to a new workbook saved as: CH5_A5 Summary Reconciliation 4. Run the Balance Sheet Standard report as of 06/30/2023 to display the balance for all balance sheet accounts. Total Assets should equal Total Liabilities & Equity! Click the Excel button and export this list to a new workbook saved as: CH5 A5 Balance Sheet Close Excel and close the company file, choosing not to memorize the report