Convert an American Express bank statement for litigation discovery

Hand a paralegal a stack of American Express statements for a discovery production and the first problem is not the redactions or the Bates stamps. It is the document itself. Paste the transaction table into a spreadsheet and the category subtotals come along as if they were charges, a foreign purchase splits into two lines with two different amounts, and the total at the bottom of the sheet does not match the new balance printed on the statement.

This is the specific problem behind converting an American Express bank statement for litigation discovery: the document was built to summarise a cardholder's spending, not to serve as a row-by-row ledger, and the conversion has to correct for that before the spreadsheet can stand as an exhibit.

Why an Amex statement is not a bank statement

A checking or savings statement is a chronological ledger: one column of dates, one of descriptions, one of amounts, one running balance that ticks up or down with every line. An American Express statement is a card statement. It groups charges by category, spends a page or two on a summary block near the top that totals each category and the account as a whole, and only then lists the individual transactions underneath.

That summary block is the first thing that trips up a generic conversion. A parser that reads every line of text as a transaction will pick up the category subtotals ("Merchandise & Supplies", "Travel", "Restaurants") as if they were charges in their own right, inflating the transaction count and duplicating figures that already appear further down the page. In a discovery production, a duplicated total is not a rounding error; it is a discrepancy opposing counsel can point to.

Foreign transaction lines carry two amounts, not one

The second Amex-specific quirk is the foreign transaction line. When a charge is billed in a currency other than US dollars, the statement prints both the billed USD amount and the original currency amount on the same line. A converter that does not recognise this format will often read the two figures as two separate transactions, or drop one of them entirely, which changes the total spend for that statement period.

For an exhibit, this matters twice over. It changes the count of transactions attributed to the account, and it changes the amount available to reconcile against the printed total. Either error is the kind of thing that gets a converted spreadsheet questioned during a deposition, and questioned spreadsheets slow down a case.

What American Express's own export does not solve

American Express does let a cardholder download an account's transactions as CSV directly from the online portal, and for personal bookkeeping that export is often enough. For a discovery production it usually is not. The native export carries the transaction list but not the summary block totals printed on the statement, so there is nothing on the page to check the export against once it lands in a spreadsheet. A closed or replaced account may not offer a live export at all, and the download window in the portal typically does not reach back across the multi-year span most discovery requests cover.

That gap is why the underlying statement documents, not the account's own export, are usually the starting point for a production. Converting from the statement preserves the printed totals you need for verification and works for accounts no longer active.

Converting an American Express statement for litigation discovery

The workflow for a defensible conversion is short, but every step earns its place in the record.

1. 1

   Separate the summary block from the transaction list

   Confirm the converted spreadsheet's transaction rows start after the category summary, not within it. Any row whose "description" reads like a category name rather than a merchant is a summary line that leaked through.
2. 2

   Check foreign transaction rows for a single line, two amounts

   Scan for any transaction with a currency symbol other than the dollar sign next to it, and confirm it appears as one row carrying both the billed USD figure and the original currency figure, not as two separate charges.
3. 3

   Reconcile the total against the printed new balance

   Sum the converted transaction column and compare it to the new balance printed at the top of the statement. A mismatch means a row was misread, duplicated, or dropped, and it has to be found before the spreadsheet goes into the production set.
4. 4

   Attach the original statement alongside the spreadsheet

   Produce the converted spreadsheet as a working document for review and the original statement document as the record of what was issued, so either party can check one against the other.

Producing the converted statement as an exhibit

Once the totals reconcile, the statement is ready to be marked and produced. If the matter involves a full production set, the numbering and pagination conventions matter as much as the accuracy of the figures; the piece on producing bank statements as numbered exhibits covers how to Bates-stamp and paginate a multi-account production without breaking the link between the exhibit and the underlying document.

Where the case spans several accounts, checking, a business card, and a personal Amex card, the transfers between them often need to be traced independently of any single statement's own totals. Tracing transfers between accounts walks through matching a payment leaving one statement against the matching charge or credit on another, which is the usual next step once the individual Amex statement itself reconciles.

Keeping the conversion defensible under cross-examination

A converted spreadsheet only helps a case if the other side cannot credibly argue it says something the original document does not. That means the conversion process itself needs to be repeatable: the same statement, run through the same check, should produce the same figures every time, and the person who ran it should be able to explain, in plain terms, what was verified and against what.

The broader discussion of what this requires, and where a conversion can fall short of defensible, is covered in bank statements in litigation discovery. It applies directly to Amex statements: the category summary block and the foreign transaction lines are simply the specific places where an Amex conversion needs its own extra check.

If the statement documents you are working from are password protected, which is common when they arrive from a party's own account portal rather than from the issuing institution directly, resolve that before conversion; the mechanics are covered in what to do when a password-protected statement won't open. Handling the documents through a process that keeps them off shared drives and out of email threads matters here too, and the security page describes how statement documents are handled during conversion.