Convert an American Express CSV export into a QuickBooks .qbo file. When the Amex feed misses charges, upload the CSV and get a clean Web Connect file.
No account needed for your first conversions. We never store your bank login.
Short answer: Download your American Express activity as a CSV, upload it here, and the converter builds a QuickBooks Web Connect (.qbo) file with every charge, credit, and payment mapped correctly. QuickBooks Online imports the .qbo directly, and QuickBooks Desktop reads it through File, Utilities, Import, Web Connect Files. Desktop has no native CSV transaction import, so the .qbo is the one file both versions accept.
It handles exports from American Express Business Green, Gold and Platinum cards, Business Line of Credit, corporate cards, Amex personal cards, and the Amex savings and checking products. Statements downloaded per billing period work the same way as a custom date range pulled from the Activity page.
The converter is the reliable middle path. You keep the completeness of the CSV, which contains every posted charge for the range you selected, and you end up with a properly structured .qbo that QuickBooks reads without a mapping screen.
| Method | Works with QuickBooks Online | Works with QuickBooks Desktop | Best for |
|---|---|---|---|
| Convert the Amex CSV to a .qbo (this tool) | Yes, upload the .qbo | Yes, Import Web Connect file | Any Amex card, history older than the six statements Amex keeps online, and books where charges went missing from the live feed |
| Upload the raw CSV to QuickBooks Online | Yes, with manual column mapping | No native CSV transaction import | A single small file, once you map the columns and correct the sign on credits |
| Connect the Amex account to the bank feed | Yes, for supported Amex Business accounts | Limited | Ongoing sync, when the connection is healthy and you accept the roughly 90 day lookback |
Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.
Every transaction is parsed and checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
Sign in at americanexpress.com on a desktop browser, open Statements and Activity, pick your date range, and download the file in the CSV or Excel format. Upload that CSV here. The converter reads the date, description, and amount columns, checks the transaction total against your file, and returns a .qbo you import into QuickBooks Online or QuickBooks Desktop.
Open your card account at americanexpress.com, go to Statements and Activity, and choose the Download option. American Express offers a CSV or Excel download alongside Quicken (.qfx), Microsoft Money (.ofx), and a QuickBooks download. Select CSV, pick either a billing statement or a custom range, and save the file. The mobile app does not offer the export, so use a desktop browser.
The live American Express connection is widely reported to post some charges and skip others, which leaves the account looking reconciled when transactions are actually absent. Pending charges that later settle at a different amount are a common cause, and so are authorization holds that never convert. A CSV download of posted activity is complete for the range you pick, so converting it gives you a file you can trust.
American Express keeps recent activity plus roughly the past six billing statements available for download, and a single export usually covers about 90 days. Anything older has to be pulled statement by statement while it is still online. If you are catching up a year of bookkeeping, download each available statement as a CSV, convert them, and import the .qbo files in order.
American Express does offer a QuickBooks download for many card accounts, but it is bound to the same recent activity and six statement window as the feed, and the file it produces has been a frequent source of import complaints. The CSV export has no such reliability problem. Converting that CSV yourself produces a .qbo built to the Web Connect structure QuickBooks expects, with your account name and transaction types set correctly.
No. QuickBooks Desktop cannot import bank or credit card transactions from a raw CSV file. Its transaction import path is Web Connect, which accepts only .qbo files, so a CSV has to be converted first. QuickBooks Online can accept a CSV, but it requires you to map columns on every upload and it does not resolve the sign convention Amex uses for credits and payments.
Amex CSV exports carry extra columns such as card member name, account number, category, and reference, none of which QuickBooks expects. QuickBooks Online accepts a three column layout of date, description, and amount, or a four column layout that splits debit and credit. It also caps a single upload at 350 KB. The converter strips the extra columns, normalizes the dates, and sets the signs before it writes the .qbo.
American Express writes charges and credits into one amount column, and the sign convention on a credit card export is the reverse of what a checking account uses. The converter reads the sign in your file, maps charges as increases to the card balance and payments or refunds as decreases, and shows you the resulting totals in the preview before you download. That is what stops a reconciliation from ending up backwards.
Yes. Business Green, Gold, Platinum, corporate cards, and the Business Line of Credit all export the same CSV structure from the Activity page, and all convert the same way. Corporate card programs that distribute statements to individual card members work too, since each downloaded CSV is converted separately into its own .qbo before import.
QuickBooks caps a single CSV upload at 350 KB, which is roughly 1,000 transactions, and that limit is one of the reasons a heavy card month fails to import. A .qbo file is not held to the same cap. If you are converting a full year across several cards, run the files together with the bulk CSV to QBO converter rather than one at a time.
Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Yes, and the accuracy check is the point. Before the .qbo downloads, the converter totals every transaction it parsed and compares that figure to the total in your Amex CSV. A misread or missing row shows up in the preview instead of surfacing months later during reconciliation. Working from a different card or bank? Use the CSV to QuickBooks Online converter for any account, handle statements from other issuers with the credit card CSV to QuickBooks converter, turn a spreadsheet into a .qbo with the Excel to QBO converter, or compare tools on the best CSV to QBO converter roundup. Sister cards are covered by the Chase CSV to QBO converter and the Capital One CSV to QBO converter. For the long form walkthrough, read American Express CSV to QuickBooks, and for the import step itself see how to import a QBO file into QuickBooks.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
