American Express CSV to QuickBooks: Convert and Import

Short answer: Download your American Express activity as a CSV, then convert that CSV to a .qbo Web Connect file and import it into QuickBooks. The Amex direct connection often misses charges or stops syncing, and QuickBooks Desktop has no native CSV transaction import, so a .qbo file is the one format both QuickBooks Online and Desktop accept. Converting first also fixes the sign and date problems behind most failed Amex imports.

American Express business and corporate cards are some of the most common accounts US bookkeepers reconcile, and they are also some of the most common to break the feed. If your Amex connection keeps dropping, only pulls part of the charges, or downloads a file QuickBooks won't read, the manual route below is the dependable fix. You export the data straight from Amex, convert it to the format QuickBooks actually imports, and bring in exactly the transactions you need.

How do I export American Express transactions to a CSV file?

Sign in to americanexpress.com on a desktop browser, open the card account, and use the Statements and Activity area to download your recent activity. Amex lets you export recent activity and the past six billing statements as a CSV file, and also offers Quicken (.qfx) and QuickBooks (.qbo) formats from the same screen. Set the date range you need before you download, because the CSV covers a limited window rather than your full history.

The Amex CSV gives you the raw fields (date, description, card member, amount, and sometimes a separate category column) but no running balance. That is fine for QuickBooks, which only needs the date, description, and amount to post a transaction. The trouble usually starts when you feed that CSV straight into QuickBooks Desktop, or when Amex's own QuickBooks download fails partway through and leaves charges missing.

Can QuickBooks import an American Express CSV directly?

QuickBooks Online can import a CSV, but only if it matches a strict layout: a date column, a description column, and either one amount column or separate credit and debit columns, kept under 1,000 rows and 350 KB. QuickBooks Desktop has no native CSV transaction import at all. So a raw Amex CSV works in Online only after you clean it to match that exact format, and it never works directly in Desktop. Converting the CSV to a .qbo Web Connect file sidesteps both problems and gives you one file that imports the same way in either version.

Why does my American Express download to QuickBooks keep failing?

The most common cause is the Amex connection in QuickBooks dropping or only syncing part of your charges, a well-documented issue where pending or recently posted transactions never download. Amex also periodically forces you to re-authorize the connection, and a security or login change on the Amex side breaks the live feed until you reconnect. When that happens, the reliable workaround is to download the CSV directly from Amex, convert it to .qbo, and upload it manually so nothing is left out.

How do I convert an American Express CSV to a .qbo file?

Upload the Amex CSV to the converter at the top of this page, check that the date, description, and amount columns mapped correctly, and download the .qbo Web Connect file. The tool reads your debit and credit columns, normalizes the dates, and writes a proper QuickBooks Web Connect file with the right account type. You get back a single .qbo you can import into QuickBooks Online or Desktop without touching Amex's connection again.

How do I import the converted Amex .qbo file into QuickBooks Online?

In QuickBooks Online, go to Transactions, then Bank transactions, select the matching American Express account, choose Upload from file, and pick the .qbo file you converted. QuickBooks reads the transactions, you confirm the account, and the charges land in the For review tab ready to categorize. Because a .qbo is the native Web Connect format, QuickBooks treats it exactly like a bank feed download, so there is no column mapping to redo each time.

How do I import the Amex .qbo file into QuickBooks Desktop?

In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and select the .qbo you converted. Desktop matches it to the American Express account (or lets you create one on first import) and brings the charges into the Bank Feeds center. This is the only way to get Amex transactions into Desktop from a downloaded file, since Desktop cannot import a CSV of transactions on its own.

Why are some of my American Express charges missing in QuickBooks?

Missing Amex charges almost always come from the live connection, which can skip pending transactions, drop charges during a re-authorization, or stop at a date cutoff. The fix is to pull the full activity as a CSV for the exact period you need, convert it to .qbo, and import that file, which captures every posted charge in the range. Reconciling from the downloaded data rather than the feed is how most bookkeepers close the gaps.

How far back can I download American Express transactions?

Through your online account you can download recent activity plus the past six billing statements, so roughly six months to a year depending on your cycle. For anything older you typically need the PDF statements, which Amex keeps for several years. If the period you need only exists as a PDF, convert that statement to a spreadsheet first, then run the resulting CSV through the converter to get your .qbo.

Does this work for an American Express Business or Corporate card?

Yes. The CSV export and the .qbo conversion work the same for personal, Business, and Corporate Amex cards, because the converter only cares about the date, description, and amount columns in the file. Business and Corporate statements often carry more charges and multiple card members, which is exactly where a clean .qbo import beats fighting a flaky live connection. Map each card to its own QuickBooks account and import the matching .qbo.

Should I connect Amex to QuickBooks or upload a file?

Connect the live feed if it stays reliable for your account, since it updates daily with no manual steps. Switch to the CSV-to-.qbo route whenever the connection drops charges, stops syncing, or won't reconnect, and for any historical cleanup the feed can't reach. Many bookkeepers run both: the feed for day-to-day, and a converted .qbo to backfill or repair the months the feed missed.

Is it safe to convert my American Express CSV?

Yes. The converter only reads the transaction rows (date, description, and amount) to build the .qbo file, and it does not need your Amex login or card number. You are working from a file you already downloaded, so nothing connects back to your American Express account. For a business reconciling sensitive card activity, that is often safer than handing a third-party app live access to your Amex credentials.

What if my Amex statement is only a PDF?

If the only file you have is a PDF statement, you need to turn it into a spreadsheet before converting. Extract the transactions to a clean CSV or Excel file first, then upload that CSV here to produce the .qbo. This two-step path covers older Amex periods that fall outside the six-statement CSV window, so you can still reconcile months the download tool no longer reaches.

You convert one CSV at a time on the free widget above, and each .qbo file imports into its matching QuickBooks account. If you reconcile several Amex cards or whole client books every month, the batch tools on the paid plans let you convert multiple files in one pass instead of repeating the steps for each card.

Once your file is converted, follow the exact import path in our guides on CSV to QuickBooks Online and CSV to QuickBooks Desktop, handle several cards at once in importing multiple CSV files into QuickBooks, and pick the right tool in our roundup of the best CSV to QBO converter. For card-specific tips see credit card CSV to QuickBooks, and for the full walkthrough read how to convert CSV to QBO and how to import a .qbo file into QuickBooks. If a feed keeps failing, our guide on QuickBooks bank feed not working walks through the manual fix. Bank elsewhere? See the same flow for a Chase CSV to QuickBooks or a Capital One CSV to QuickBooks. If your Amex statement is a PDF, first turn it into a clean spreadsheet with bankxlsx or a QBO file with pdfqbo, and once those card charges are booked, automate paying vendors with autopayables.