# Convert American Express CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/american-express.html_

American Express is generous with download formats, from the Activity page you can export CSV, QFX, OFX, and even a native QBO Web Connect file, covering roughly the last 12-18 months in 90-day chunks. So in theory Amex-to-QuickBooks should be painless. In practice, plenty of bookkeepers land here because the direct download or bank-feed connection keeps failing, the QBO file gets rejected by QuickBooks, or they need older activity that only the CSV will give them in a usable shape. When the native route misbehaves, the CSV is the dependable fallback, and QuickBooks won't accept a raw Amex CSV without column mapping.QBO Maker rebuilds your Amex CSV (or Excel) into a clean, valid .QBO that imports through QuickBooks' Web Connect / file-upload flow. Because Amex is a charge/credit card, the trick is importing into a credit card account so charges and payments post on the correct side, import into a credit card account, and if your charges come in as payments, tick Flip plus and minus signs so they post on the correct side. It can also output .QFX and .OFX for Quicken and other tools. Everything runs locally in your browser, so your Amex statement data is never uploaded. Drop your American Express CSV into the converter to get a QuickBooks-ready file in seconds.

## Steps

1. Export your transactions from American Express online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Amex already exports a QBO file, why use a converter?**
American Express does offer a native .QBO Web Connect download. But if that file fails to import, the bank feed won't connect, or you need data the CSV represents more cleanly, exporting CSV and converting it here gives you a .QBO that imports reliably.

**How far back can I download Amex transactions?**
The Amex Activity download covers roughly the last 12 to 18 months and lets you pull about 90 days at a time. Download each window as a CSV and convert it; anything older than that range generally isn't available through the export.

**Why do my Amex payments show as negative in QuickBooks?**
On a credit card, a payment reduces the balance and can appear as a negative amount. Import the converted file into a credit card account in QuickBooks rather than a bank account, and charges and payments will post to the correct side.

**Does my American Express data get uploaded?**
No. The conversion happens entirely in your browser. Your Amex transactions are never sent to or stored on a server, keeping your card activity private.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.