Amex Credit Card Statement to Excel Converter

For corporate cards managed through American Express @ Work, Program Administrators can download statements up to seven years back at no fee, in PDF or CSV, selecting up to twelve statement archives at a time. Requested archives stay available to download for fifteen days.

Fifteen days is short. Download the archives as soon as they're ready, then convert the PDFs in batches — Smart Merge takes up to 100 at once.

Each charge becomes a row with the transaction date, the merchant description as Amex printed it — with any location or reference text that follows the merchant name — and the amount. Payments and credits get the opposite sign, so the column sums to the change in what you owe. Where the statement prints a Membership Rewards summary, the points earned this period and the points balance are captured alongside the money figures.

One thing the export deliberately does not add: a per-row running balance. An Amex statement prints one previous balance and one new balance per cycle, never a balance after each transaction — so a running balance column would be an invented number. The cycle arithmetic is verified instead.

Foreign transactions keep the description Amex printed, including the original currency details where they appear in the text, with the dollar amount in the amount column.

If you searched for an example of an American Express statement converted to Excel, the sample block near the top of this page is exactly that: a fictional card statement — invented issuer, invented cardholder, watermarked SAMPLE — whose account summary ties to the cent, converted by the same engine you get.

Flip between the source PDF and the Excel tab, or download both files and compare them row by row. The Excel you see there is byte-for-byte what the product produces, not a marketing mock-up.

Some Amex cards are charge cards where the balance is due in full; others carry a revolving balance with interest. The statement summary differs accordingly — interest and pay-over-time lines appear only where they apply.

The check adapts: only the previous and new balance are required anchors, and any summary figure that isn't printed counts as zero. A charge card with no interest line still reconciles cleanly.

Amex publishes a Year End Summary for card members — a categorised view of the year's spending, available in your online account for the previous calendar year and downloadable in QuickBooks, Quicken, Excel, PDF or CSV formats. It is a report, not a statement: it groups charges but doesn't replace the monthly statements an accountant reconciles against.

Use both. The summary for a quick overview, the converted statements for the actual ledger, where each charge has a date, a merchant and a figure that ties to a statement balance.

For a small business, the Amex statement is the backbone of expense bookkeeping. Each charge needs a category and, often, a receipt.

Converted, the charges become a list you can sort by merchant and amount, tag by category, and match to receipts in one pass. The QBO file then imports into QuickBooks as credit card transactions.

The common case: a business that hasn't booked its Amex card for months. The six-statement export doesn't reach back far enough, and typing the rest is days of work.

Download the PDFs for the whole year — requesting archived ones where needed — and upload them in one go. Smart Merge returns one workbook in date order, every statement checked, and the chain from one statement's new balance to the next statement's previous balance confirms nothing is missing.

A design agency in Austin puts software subscriptions, travel and client lunches on an Amex business card. The accountant needs the year in QuickBooks, coded by category. The figures here are an illustration.

The office manager downloads twelve statement PDFs and uploads them. FlowParse returns one workbook with each charge, its date and a category; the QBO file goes into QuickBooks, and the category column makes the expense review quick.

Check coverage: twelve statements for the year, each new balance equal to the next previous balance. Check the summary: every statement reconciled against its own summary box. Check categories: adjust any that don't fit your chart of accounts.

Keep the PDFs. The spreadsheet is a working copy; the statement is the record your accountant and the IRS rely on.

The IRS generally asks taxpayers to keep the records behind a return for three years after filing, and longer in some situations. A business deducting expenses charged to an Amex card needs those statements for the whole period.

Amex's two-year online view doesn't cover it. A folder of saved statement PDFs does — and converts into a searchable ledger whenever you need it.

When a charge is disputed and credited, the statement shows the original charge and, later, the credit. In a PDF they can sit months apart.

Merged and converted, a search for the merchant shows both lines side by side, so you can confirm the credit arrived and book it against the right expense.

Statements received on paper can be scanned flat, one per file. FlowParse reads them through OCR and checks each against its printed summary.

On a scan, that check is what tells you a 7 wasn't read as a 1 — the summary simply won't close if it was.

The monthly Amex payment leaves the bank account as one debit and arrives on the card as one credit. Upload the bank statements and the Amex statements together and Smart Merge lines them up by date.

The payment appears on both sides and can be paired and excluded, so the workbook shows real spending and not the transfer between your own accounts.

If you only need the last six months in QuickBooks, Amex's own export is the shortest route and there's nothing to convert. FlowParse earns its place beyond that window, or whenever the source is a PDF someone handed you.

In both cases the goal is the same: transactions in your books that tie to Amex's own figures.

The QBO file imports into QuickBooks Online and Desktop as credit card transactions, with the merchant description on each line. The CSV carries the same columns for Xero, a spreadsheet or another package.

Because each statement was checked against its own summary, a difference in the credit card reconciliation points at the bookkeeping, not at the conversion.