Amex Statement to CSV: Converting a Card Statement That Has No Balance Column

You need American Express transactions in a spreadsheet — every charge, every credit, every refund, in the right direction. Maybe you are separating business spend from personal for a Schedule C, assembling twelve months of statements for a lender, or handing a year of card activity to a bookkeeper who does not want forty PDFs.

Amex is a card issuer, not a checking-account bank, and that matters more than it sounds. A card statement has no running account balance beside each row, so the usual way of proving a conversion is correct does not exist here. This post covers both routes to a CSV, the Amex-specific layout problems, and the reconciliation that replaces the balance chain.

Quick answer

Two ways to get Amex transactions into CSV:

1. Amex's own download. In your online account you can download recent activity and your past six billing statements to Quicken, QuickBooks or as a CSV file. Amex also states you can view roughly the previous two years of transactions online and download them as PDF, Excel or CSV.
2. Convert the PDF statement. For billing cycles older than the online window, for a cancelled card, for a corporate card you no longer log into, or for statements someone forwarded you, the only artifact is the PDF. Upload it to BankStatementKit and the charges come out as rows, reconciled against the statement's own printed summary.

Rule of thumb: if the cycle is still inside Amex's online window and you can log in, take the native CSV. Everything older or handed to you second-hand goes through the PDF.

Turn an Amex statement PDF into a CSV

Option 1: American Express's built-in transaction download

If you have online account access, start here — the data comes straight from the issuer and needs no extraction.

1. Log in to your American Express online account.
2. Open the statements and activity area for the card you want.
3. Choose the billing period or a custom date range.
4. Select a download format. Amex offers Quicken, QuickBooks and CSV for recent activity and the past six statements, and PDF, Excel or CSV across the wider transaction view.
5. Open the downloaded file in Excel or Google Sheets.

Where the built-in download stops

• Six statements is not a tax year. The direct statement download covers the past six billing cycles. Anything older has to come from the archived PDFs or the wider activity view.
• Business and corporate cards behave differently. Amex Business Blueprint, a separate product from a personal card, documents a maximum of 2,000 transactions per export — and the report builder is a different tool from the personal one.
• Cancelled cards. Once a card is closed, online access to its history is limited or gone. Saved PDFs are what you are left with.
• Supplementary cards. If you need all card members' spend in one file, you may be exporting per card and stitching afterwards.
• The CSV is Amex's shape, not yours. Column names, sign conventions and date formats are whatever Amex chose, which usually means a cleanup pass before anything imports.

Option 2: Convert the Amex PDF statement to CSV

1. Open the statement PDF. Amex statement PDFs are sometimes password-protected when emailed; if yours is, have the password ready.
2. Upload it. If a password is needed, supply it at upload — the file is unlocked in memory and never written to disk.
3. The charges are read into the standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance. On a card statement the Balance column stays empty, because Amex does not print one.
4. Check the verification label, then download the CSV.

Convert an American Express statement

Why Amex PDFs trip up generic converters

Amex statements are not laid out like account statements, and naive extraction fails on that difference.

There is no balance column to anchor rows to. Most converters use the running balance as a structural hint: a row is a row because it ends in a balance. Amex gives you a date, a merchant description and an amount, and nothing else per line. Rows have to be assembled from the date and amount positions alone, which is a strictly harder problem and the main reason generic tools drop or merge charges here.

Detail is grouped, not flat. The transaction detail is broken into sections — new charges, payments and credits, fees, interest, and on family accounts a separate block per card member. A converter that reads the PDF as one flat table will treat section headers and their subtotals as transactions, inflating the file with rows that are really headings.

Charges spill onto extra lines. A merchant entry can carry a second line of location, reference or travel detail, and foreign spend prints the original currency amount as well as the dollar figure. Treat each physical line as a transaction and you get phantom rows with no amount attached.

Prove the CSV matches the statement

On a checking-account statement you check a conversion by walking the running balance: previous balance minus debits plus credits equals the printed balance, row after row. An Amex statement gives you no such chain. What it gives you instead is the Account Summary block near the top of the statement, and that becomes the reconciliation:

1. The summary arithmetic. Previous Balance, less Payments and Credits, plus New Charges, plus Fees, plus Interest Charged, must equal the New Balance. That identity is printed on the statement, so it is a fact you can test against.
2. The extracted rows must add up to it. Sum the charges you extracted and they should equal Amex's printed New Charges figure. Sum the credits and payments and they should equal the printed Payments and Credits figure. If either is off, a row was dropped, duplicated, or read with the wrong sign.

That second check is the one that catches real errors, and it is exactly as strong as a balance chain for the purposes of "did anything go missing" — it just cannot point at the individual row the way a balance chain can. BankStatementKit runs the printed-totals reconciliation on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, so you know before you use the file whether the numbers agree with the statement.

More on the layout: Amex statement converter.

FAQ

The bottom line

If the billing cycle is inside Amex's online window and you can log in, take the native CSV — it is free and it is the issuer's own data. For older cycles, cancelled cards and statements you were sent, convert the PDF, and reconcile against the Account Summary rather than pretending a card statement has a balance chain. A converted card statement that has not been checked against Previous Balance and New Balance is just a guess with a spreadsheet icon.