View source for 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 ===

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

=== Step 2: Download the Statement Activity ===

# Select '''Statements & Activity'''.
# Locate the '''most recent statement closing date'''.
# Download the statement activity file for that statement period.

=== Step 3: Determine the Reconciliation Information ===
The downloaded workbook contains multiple worksheets.

==== Reconciliation Date ====

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

==== Reconciliation Balance ====

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

=== Step 4: Reconcile in Aplos ===

# Open '''Aplos'''.
# Navigate to the '''American Express''' register.
# Start a new reconciliation.
# Enter:
#* '''Statement Ending Date:''' The ending date from the statement period.
#* '''Ending Balance:''' The Total from the '''Transaction Summary''' worksheet.
# Match and clear all applicable transactions until the reconciliation difference is '''$0.00'''.
# 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.