American Express statements differ from many Visa and Mastercard issuers because they may include supplementary cards, Membership Rewards references, charges and credits labels, and account-level summaries. This guide explains the Excel layout that keeps Amex statements usable.
Last updated 2026-06-12
Amex is its own card network, not just an issuer — and its statement layout reflects that. Three quirks consistently break conversions designed for Visa/Mastercard: supplementary cardholder grouping, the Membership Rewards column, and the Charges/Credits/Adjustments wording.
Amex groups transactions per cardholder. If the primary card has two supplementary cards on the account, the statement prints three sections, each with its own subtotal:
Generic converters either drop the supplementary sections (the subtotal looks like a footer) or merge them without preserving who spent what. The correct Excel adds a "Cardholder" column so finance teams can attribute spend.
Every transaction row on a Membership Rewards card prints the points earned alongside the amount. A 1,200 INR charge might show "1,200.00 INR" and "1,200 MR" on the same row. Tools that don't know about this column either sum the points into the amount (turning the row into 2,400.00) or pick the wrong column entirely.
ClearlyLedger detects the MR column, keeps it as an optional "Rewards Points" column, and excludes it from the Debit/Credit math.
Amex labels transactions as "Charges" (debits) and "Credits" / "Adjustments" (credits). Some statements also use "Payments Received" as a separate section header rather than an inline row. Normalising these into the standard Debit/Credit columns is what makes the export importable into QuickBooks and Xero.
| Date | Cardholder | Description | Debit | Credit | Points |
|---|---|---|---|---|---|
| 2026-05-03 | Primary | AMAZON MUMBAI | 2,499.00 | 2,499 | |
| 2026-05-07 | Supplementary | UBER BLR | 385.00 | 385 | |
| 2026-05-22 | Primary | PAYMENT RECEIVED | 15,000.00 |
Amex handles FX similarly to Visa/Mastercard — three rows (original currency, home currency, markup). The handling rules in FX rows on credit cards apply directly. EMI is rarer on US-issued Amex but common on India-issued cards; the principal/interest split is the same as covered in EMI conversion accounting.
India-issued Amex statements use DDMM of birth + last 5 digits of card number. US-issued Amex e-statements are typically unprotected; the security comes from the AmexOnline portal login.
ClearlyLedger keeps the cardholder column, the rewards column, and normalises Charges/Credits into a standard Excel layout.
Loading interactive converter… Try ClearlyLedger free