American Express statement to Excel
Amex splits activity into Payments and Credits and New Charges, and prints a conversion line under every foreign purchase. Keeping the sections apart and dropping the conversion detail is what makes the sheet add up to the statement total.
Column layout
Consumer and business cards print three columns; there is no running balance on a charge card.
| Account type | Date column | Description column | Amount column |
|---|---|---|---|
| Amex consumer cards | Date | Description | Amount |
| Amex business cards | Date | Description / Card member | Amount |
Two sections, one sign convention
Payments and credits are money reducing the balance; new charges increase it. The export uses negative for charges and positive for payments and credits, which is the convention a spreadsheet needs to net them.
Foreign currency purchases
A purchase abroad prints the billed amount plus the original amount and exchange rate underneath. Those two extra lines are informational:
- The billed amount in your card currency is kept as the row.
- The original currency amount and rate are dropped.
- A separately charged FX fee is kept, because it is real money.
Questions
Does it include the Membership Rewards summary?
No. Points earned and the rewards summary are not transactions and are left out of the sheet.
Why is my total off by the payment amount?
Payments come through as positive amounts. Sum of the amount column therefore equals charges minus payments, which is the change in balance for the period.
Are employee names on business card statements kept?
Yes. The description keeps the card member name, so you can filter spend by employee in Excel.
Other banks
Try it on your own statement
No account, no card, no email. Convert one file and check the rows against the original.
Open the converter