To export Amex transactions to CSV, sign in to your American Express account on a computer, open the card's statement or activity page, choose a statement period or a custom date range, then pick the download option and the CSV format. Before importing, check the signs: charges may arrive as positive numbers and need flipping.
Exporting Amex transactions to CSV from the activity page
The export starts from the card's activity view on the American Express website, where a download control sits near the transaction list. You choose the dates, then the file format, and the CSV saves to your computer. This post does not quote Amex's current menu labels, because they change. Go by your screen.
The usual sequence:
- Sign in on a desktop browser and select the card, if you hold more than one.
- Open the statements or activity view.
- Choose the period you want, either a closed statement or a custom range.
- Find the download control and pick CSV from the formats offered.
- Save the file with a clear name, such as
amex-gold-2026-09.csv.
Why CSV and not a QuickBooks file? A CSV works with nearly everything: Excel, Xero, QuickBooks Online and most other tools. It is also easy to open and correct. Business card holders have one more reason. Intuit's page on connecting bank and card accounts to QuickBooks Online says American Express Business accounts cannot be connected with its standard method, so a file is often the practical route.
Which Amex date range should the CSV cover?
Match the CSV to one closed statement period whenever you can. A statement period has a fixed start and end and a printed new balance, so you can check the file against it. A calendar month rarely lines up with an Amex closing date, which makes the totals hard to prove.
Pick a custom range only for a specific gap, such as the days since the last closed statement. In that case, leave out the most recent day or two. Pending charges can still change or drop off, and a CSV taken too early may hold lines that never post.
Two more points:
- Ranges should touch, never overlap. If your last file ended on the statement close of September 12, start the next on September 13.
- Keep files small. Intuit's guide to uploading transactions manually caps a QuickBooks Online upload at 1,000 lines and 350 KB. One statement per file stays well inside that.
Why might Amex charge signs need flipping?
A card export is written from the card issuer's point of view, so a charge can appear as a positive number and a payment as a negative one. Accounting software often expects the opposite in an upload: spending as a minus. If you import the file unchanged, every purchase may land as money received.
Whether your file needs the flip depends on the software and on how you set up the account. Do not guess. Look at one familiar charge in the file and see which sign it carries, then check what your import screen shows. QuickBooks Online makes this easy: on the review step of an upload, Intuit's guide to uploading transactions manually says you can choose to reverse all values if they came in backwards.
In Xero or in a spreadsheet, flip the signs yourself before importing. In Excel, put -1 in an empty cell, copy it, select the amount column and use Paste Special with Multiply.
Reading an Amex CSV row by row before import
A quick read of the file catches most problems before they reach your books. Check the dates, the descriptions, the amount column and any rows that are not purchases, such as payments and refunds. The worked example below uses invented rows to show what to look for.
| Date | Description | Amount in file | Amount after flip |
|---|---|---|---|
| 09/03/2026 | OFFICE SUPPLY STORE | 84.20 | -84.20 |
| 09/09/2026 | ONLINE PAYMENT - THANK YOU | -1,500.00 | 1,500.00 |
| 09/11/2026 | SOFTWARE SUBSCRIPTION REFUND | -29.00 | 29.00 |
After the flip, the purchase is a minus, while the payment and the refund are plus. That matches how a card account in your books should move: spending raises what you owe, payments and refunds lower it.
The payment line deserves a second look. That same 1,500.00 also leaves your checking account. If both the checking import and the card import record it as an expense, you count it twice. Record it once, as a transfer between the two accounts.
Undoing an Amex CSV that went into Xero wrong
If an Amex CSV went into Xero with the wrong signs, the wrong dates or into the wrong account, remove that import rather than fixing lines one by one. Xero lets you delete an imported statement, after which you fix the file and import again. Do it before you reconcile any of the lines.
Deleting an imported bank statement in Xero gives the steps and explains what happens to lines you already reconciled. The usual causes of a bad Amex import are a skipped sign flip, a date column read as month-day when it was day-month, and the file sent into the checking account instead of the card account.
If the CSV itself is unusable, the monthly PDF statement is another starting point. SimpleBankConvert, in early access, is designed to turn a digital card statement into a CSV laid out the way Xero's import expects. There is a sample on the homepage.
PayPal and Discover exports beside an Amex CSV
Other card and payment exports follow the same logic: one account per file, a date range that matches a statement, and a sign check before import. The details differ. PayPal files carry fees and currency conversions, and card issuers lay out their columns in their own way.
If you also use them, downloading PayPal transactions as CSV covers PayPal's activity export, and getting Discover card transactions into QuickBooks covers Discover. Run the same row-by-row read on each file before it goes in.