Home › Guides › American Express statement to Excel

American Express statement to Excel

American Express lets US card members download the previous two years of transactions as Excel, CSV or PDF, and recent activity plus the past six billing statements as CSV, Quicken or QuickBooks files, from the online account (Amex US help pages, checked November 13, 2026). For anything older, or when you only have the statement PDF, convert the PDF to Excel in your browser and check that previous balance + charges − payments and credits = new balance.

Updated November 13, 2026

First choice: Amex’s own Excel or CSV download

American Express’s help page How do I access my transaction history and billing statements? says your previous two years of transactions can be viewed online, sorted, filtered and downloaded as a PDF, Excel or CSV file. A separate page, How do I download my transactions to accounting/financial management software?, says recent activity and the past six billing statements can be downloaded to Quicken, QuickBooks or as a CSV file (both checked November 13, 2026).

  1. Sign in at americanexpress.com on a computer and open the card’s statements and activity.
  2. Pick a billing period, or set a date range inside the last two years.
  3. Choose the download option and select Excel (or CSV).
  4. Open the file in Excel. If you set a date range rather than a statement period, the total will not match a statement — that is expected.

Menu names differ between personal, business and corporate accounts; follow Amex’s current help if your screen looks different.

Watch the signs. In the Amex CSV a charge is a positive number and a payment is negative — the reverse of a checking-account file. QuickBooks and Xero treat card purchases as negative amounts, so flip the sign or use the card-account option when importing.

When you only have the Amex statement PDF

The billing statement PDF is the complete record for one cycle: previous balance, payments and credits, new charges, fees, interest and the new balance. Use it when:

  • the period is older than the two-year transaction download;
  • you need rows that match a specific statement exactly, for reconciliation or a client file; or
  • a client sent you PDFs and you have no Amex login.

Amex says older, archived statements can be selected from the statement list and become available online within 24 hours, so request them a day before you need them. Regulation Z requires a card statement to show the previous balance, each transaction, credits, fees, interest, the closing date and the new balance (12 CFR 1026.7); that new balance is what a conversion should reconcile to.

Convert the Amex PDF to Excel in the browser

  1. Download the statement PDF from your Amex account, or use the PDF you were sent.
  2. Open Credit card statement PDF to Excel.
  3. Drop the PDF. It is processed in your browser; the file is not uploaded to CSVLedger.
  4. Check for Reconciled: previous balance + charges − payments and credits = new balance (how the check works).
  5. Download Excel (.xlsx), or CSV / QBO / Xero CSV if you are importing next.

In CSVLedger’s card export, charges are negative and payments and credits positive — the convention QuickBooks and Xero use for card accounts. When a line shows both a transaction and a posting date, the transaction date is kept. CSVLedger has no Amex-only template and has not tested every Amex statement layout (business cards with several card members can be laid out differently); the reconciliation result is how you know a particular PDF was read correctly. Clear scanned PDFs use browser-only English OCR; review every recognised row.

Fictional balance check

Suppose an Amex statement shows previous balance 520.00 and new balance 432.14, and the conversion produces these fictional rows:

DateDescriptionAmount
2026-10-03COFFEE SHOP-18.75
2026-10-09AIRLINE TICKET-129.99
2026-10-15ONLINE PAYMENT - THANK YOU300.00
2026-10-21OFFICE SUPPLIES-63.40

Check: 520.00 + 18.75 + 129.99 − 300.00 + 63.40 = 432.14, which matches the printed new balance. Matching totals do not prove every description is perfect, so spot-check payees against the PDF.

When a browser converter helps

Disclosure: I built CSVLedger. It converts text and clear English scanned bank and credit card statement PDFs to Excel, CSV, QuickBooks .qbo and Xero CSV in your browser (no upload), with an automatic balance check. It does not do anything useful with an Amex CSV or Excel file you already have, and it does not turn a CSV into a .qbo file. Prefer Amex’s own download when it covers your dates.

Open credit card to Excel → · Amex download formats · Accuracy · Plans (free: 10 pages a day)

Frequently asked questions

Can I download an American Express statement as Excel?

Yes for transactions. American Express says your previous two years of transactions can be sorted, filtered and downloaded as a PDF, Excel or CSV file from your online account. The official billing statement itself is a PDF.

How far back can I download Amex transactions?

Amex’s US help says two years of transactions can be downloaded as PDF, Excel or CSV, and recent activity plus the past six billing statements can be downloaded to Quicken, QuickBooks or CSV. Anything older is available only as a statement PDF (archived statements become available online within 24 hours of selecting them).

Why are Amex charges positive in the CSV?

In the American Express CSV a charge is a positive amount and a payment is negative, the reverse of a bank account file. QuickBooks and Xero expect card purchases as negative amounts, so flip the sign (or choose the card account option in the import) before importing.

Does CSVLedger convert an Amex CSV to .qbo?

No. CSVLedger converts PDF bank and credit card statements. If you already have an Amex CSV, open it in Excel or import it as CSV; for QuickBooks Web Connect, use Amex’s own QuickBooks download for the last six statements.

Related guides

Sources and scope

Based on two American Express US help pages fetched November 13, 2026, and the Regulation Z citation. Limits are for US accounts as Amex describes them; other countries and corporate programs can differ. Examples marked fictional are illustrative. CSVLedger is not affiliated with American Express.