How to Convert an American Express Statement to Excel or CSV (Free 2026)

American Express is unique among major card issuers. It offers both charge cards — where the full balance is due each month — and credit cards with revolving balances. It produces a proprietary PDF format with Membership Rewards summaries, promotional offer sections, and dense multi-page layouts that challenge generic PDF converters. And it offers a Year-End Summary that no other major issuer matches for bookkeeping convenience.

This guide covers everything you need to know about converting any Amex statement — personal or business, charge card or credit card, monthly statement or Year-End Summary — to a clean Excel or CSV file for accounting, expense reporting, or tax preparation.

Amex Charge Cards vs. Credit Cards

American Express is unusual in that it issues two fundamentally different types of cards, and understanding the difference matters for bookkeeping.

Charge Cards (Pay in Full Monthly)

Charge cards — the Gold Card, Platinum Card, and Green Card — have no preset spending limit and require the full statement balance to be paid each month. Because there is no revolving credit, your statement shows no interest charges, no minimum payment calculation, and no credit utilization line. The statement is a pure transaction ledger: date, merchant, amount, and any applicable rewards earned.

For bookkeeping purposes, this makes charge card statements exceptionally clean. Every line is a real transaction or credit — no interest accrual rows to filter out.

Credit Cards (Revolving Balance)

Credit cards — the Blue Cash Everyday, Blue Cash Preferred, Cash Magnet, and EveryDay — work like traditional credit cards with a credit limit, minimum payment, and the option to carry a balance. Statements include interest charge rows, minimum payment due information, and a statement balance distinct from the full balance. When converting to CSV, a dedicated converter filters these summary rows and returns only the transaction lines.

Amex Card Types and Use Cases

Why Amex PDFs Are Harder to Parse

Amex statements are among the most complex PDF formats produced by any major card issuer. Several structural features cause generic PDF-to-Excel tools to produce poor output.

Membership Rewards Points Summary Embedded in the Statement

Every Membership Rewards-earning card (Gold, Platinum, Business Gold, Business Platinum, Green, Business Green) includes a points summary section — points earned this period, points redeemed, and total balance — embedded directly in the statement PDF. Generic converters extract this as transaction rows, giving you rows like "Points Earned This Period: 4,218" mixed in with your purchase data. A dedicated converter recognizes and excludes this section.

Multi-Page Dense Format with Promotional Content

Amex statements are dense. A single month of moderate spending on a Gold or Platinum card can run 4–6 pages, with promotional offer notices, benefit reminders, and fine print occupying significant page real estate. Generic PDF converters extract all of this as text, flooding your spreadsheet with non-transaction content. Dedicated bank statement converters parse only the transaction table.

Statement Credits and Fee Rows

Amex Platinum cardholders receive dozens of annual statement credits — up to $200 hotel credit, $200 airline fee credit, $240 digital entertainment credit, $189 CLEAR credit, and more. These appear as transaction-like rows in the statement but are credits, not charges. They need to be correctly identified as credits (positive amounts) when converting to CSV for expense tracking.

Authorized User Transactions

Many Amex accounts have authorized users (additional cardholders), whose transactions appear in the same statement but may be grouped separately or indicated by a different card number suffix. Expense reporting often requires separating transactions by cardholder — a feature that Amex's own transaction download and dedicated converters support, but generic tools do not.

The Amex Year-End Summary (Unique to Amex)

American Express offers a feature that virtually no other major card issuer provides: the Year-End Summary. This is a single downloadable PDF covering all 12 months of transactions on your account for a given calendar year — pre-categorized into spending categories like dining, travel, entertainment, groceries, and other.

The Year-End Summary is typically available in January for the prior calendar year. It covers all transactions posted to your account January 1 through December 31, regardless of statement period boundaries.

When to Use the Year-End Summary

• Annual tax preparation: Get all 12 months of business expenses in one CSV to hand off to your accountant.
• Annual bookkeeping catch-up: If you've fallen behind on entering transactions, the Year-End Summary is the fastest way to catch up.
• Business expense reporting: For freelancers and small business owners using personal Amex cards for business, the Year-End Summary provides the full-year data needed for Schedule C or business tax returns.
• Spending analysis: Review and categorize 12 months of spending in one session rather than working through monthly statements.

How to Download Your Amex Statement PDF

Downloading a Monthly Statement

1. Log in to americanexpress.com. Use your User ID and password. Two-factor authentication may be required.
2. Go to Statements & Activity. From the account dashboard, click on your card, then select "Statements & Activity" from the menu.
3. Select your statement period. Click the Statement dropdown menu and choose the month you want (e.g., "May 2026 Statement"). Statements are typically available for up to 7 years.
4. Click Download PDF. The statement downloads as a PDF file to your computer's default download folder.

Downloading the Year-End Summary

1. Log in to americanexpress.com and navigate to Statements & Activity for your card.
2. Click the "Year-End Summary" tab. This tab appears alongside your regular statement list — it may be labeled "Year-End Summary" or found under the Statement dropdown.
3. Select the year. Choose the calendar year you want (e.g., 2025). The current year's summary is available in January of the following year.
4. Click Download. The Year-End Summary downloads as a PDF. It is typically larger than a monthly statement — 8–20 pages for a full year of activity.

Step-by-Step: Convert Your Amex PDF to Excel or CSV

Once you have your Amex PDF downloaded — whether a monthly statement or the Year-End Summary — the conversion process is the same.

1. Go to bankstatementtocsvfile.com. No account or signup required.
2. Upload your Amex PDF. Click the upload zone or drag and drop the file. The converter accepts single-month statements and multi-month Year-End Summary files equally well.
3. Wait 15–45 seconds. Processing time is longer for Year-End Summary files due to their size. The converter extracts all transaction rows, filters out points summaries, promotional rows, and non-transaction content, then sorts everything chronologically.
4. Review the transaction preview. Before downloading, check that the transaction count looks correct for your statement period and that the dates, descriptions, and amounts look right.
5. Download CSV or Excel. Choose CSV for importing into QuickBooks, Xero, FreshBooks, or other accounting software. Choose Excel (.xlsx) if you want to open it directly in a spreadsheet for analysis or review.

Amex Direct Transaction Download (Fastest Method for Recent Activity)

If you only need recent transactions — not a specific monthly statement PDF — American Express offers a direct transaction download under Account Services that bypasses the PDF conversion step entirely.

1. Log in to americanexpress.com and go to your card's account page.
2. Click "Download Transaction Data" — found under Account Services or in the Statements & Activity section. The exact location varies by card type.
3. Select your date range. Set the start and end dates for the transactions you want.
4. Choose your format: CSV, OFX, or QFX (Quicken). For QuickBooks Online, OFX or QFX gives the richest import. For Excel analysis or a general-purpose spreadsheet, CSV is simplest.
5. Click Download. The file saves immediately — no conversion needed.

Business Card Expense Tracking

American Express Business cards — Business Gold, Business Platinum, Blue Business Cash, and Business Green — are widely used for business expense tracking and reimbursement. Converting monthly statements or the Year-End Summary to CSV gives you a spreadsheet-ready expense report that can be imported directly into QuickBooks, Xero, FreshBooks, or used as the basis for a manual expense report.

What the Output CSV Contains

When you convert an Amex Business card statement, the resulting CSV typically includes:

• Date: Transaction posting date in YYYY-MM-DD or MM/DD/YYYY format
• Description: Merchant name and transaction identifier
• Amount: Transaction amount (charges as positive, credits as negative, or in separate debit/credit columns depending on your output preference)
• Category: Amex's own transaction category (Travel, Dining, Merchandise, etc.) where available in the statement

Importing Amex Business Data into QuickBooks

For QuickBooks Online, the fastest path is to use Amex's direct OFX download (see the previous section) rather than converting a PDF. OFX files import into QuickBooks with merchant names and dates pre-mapped, requiring only categorization review. If you have a PDF statement you need to convert, see our complete guide: How to Import a Bank Statement into QuickBooks.

Authorized User Separation

If your Amex Business account has multiple employee cards (authorized users), each employee's transactions appear in the same statement but are identified by the last few digits of their card number. When exporting a CSV for expense reporting, you can filter the spreadsheet by card number suffix to separate each employee's spend — a quick column filter in Excel or Google Sheets.

Related Guides