Amex reconcilation

Reconciling the American Express Credit Card in Aplos

Purpose

To accurately reconcile the American Express credit card register in Aplos using the monthly American Express statement activity.

Frequency

Monthly, after the American Express statement has closed.

---

Procedure

Step 1: Log into American Express

1. Navigate to the American Express online account portal.
2. Sign in using your authorized credentials.

Step 2: Download the Statement Activity

1. Select Statements & Activity.
2. Locate the most recent statement closing date.
3. Download the statement activity file for that statement period.

Step 3: Determine the Reconciliation Information

The downloaded workbook contains multiple worksheets.

Reconciliation Date

1. Open the Transactions (first) worksheet.
2. At the top of the transaction list, locate the statement period (for example, June 22 – July 22).
3. Use the ending date of the statement period (in this example, July 22) as the reconciliation ending date in Aplos.

Reconciliation Balance

1. Open the Transaction Summary worksheet (second tab).
2. Locate the Total for the statement.
3. Record this amount as the ending balance for the reconciliation in Aplos.

Step 4: Reconcile in Aplos

1. Open Aplos.
2. Navigate to the American Express register.
3. Start a new reconciliation.
4. Enter:
   • Statement Ending Date: The ending date from the statement period.
   • Ending Balance: The Total from the Transaction Summary worksheet.
5. Match and clear all applicable transactions until the reconciliation difference is $0.00.
6. Complete and save the reconciliation.

---

Verification

Before finalizing, verify that:

• The reconciliation ending date matches the statement ending date.
• The ending balance matches the Total on the Transaction Summary worksheet.
• All cleared transactions agree with the downloaded statement.
• The reconciliation difference is $0.00 before completing the reconciliation.