American Express CSV to QBO

American Express exports charges as positive numbers, which imports them backwards unless something flips the sign — the converter below does that, and builds the QuickBooks .qbo file in your browser.

Drop a CSV or Excel statement here

.csv, .txt, .xlsx and .xls — or choose a file

Your file never leaves your browser.

The American Express Card preset is selected for you. Switch the Format dropdown to Auto-detect if you are converting a file from somewhere else.

How to export a CSV from American Express

  1. Sign in at americanexpress.com and open the card account. Statements and activity have a download control, usually an icon above the transaction list.
    Screenshot: amex-export-1
    The American Express activity page with the download control.
  2. Choose the period: a specific statement, or a custom range for catching up several months at once.
  3. Pick CSV as the file type. Amex offers an "Include all additional details" option that adds category, transaction type and address columns — tick it or not, both convert.
    Screenshot: amex-export-2
    The download dialog: file type on the left, the additional details checkbox below it.
  4. Download the file, which arrives as activity.csv or with the statement date in the name.
  5. Drop it into the converter on this page. The Amex preset is preselected, including the sign flip.
  6. Confirm in the preview that charges are negative, then download the .qbo.

Online banking screens change; if a label has moved, look for a download or export control above the transaction list.

Known quirks of the American Express export

  • The basic export has four useful columns: Date, Description, Card Member and Amount, plus an account number column. Ticking Include all additional details adds category, type and merchant address columns, which the converter ignores rather than forcing into the memo.
  • American Express exports a charge as a positive number, the opposite of most issuers. The preset therefore flips every sign, so a $60 dinner becomes -60.00 and a payment to the card becomes positive. This is the single easiest thing to get backwards on an Amex import, so check two or three rows in the preview against your statement before downloading.
  • The file identifies itself with Intuit bank id 03106, the American Express Web Connect entry in Intuit's financial institution directory, and FID 03101. If the upload is refused, check the account type first: card files must go into a credit card account.

Import the .qbo file into QuickBooks

  1. Open the upload screen. In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file (on older layouts: Banking, then the arrow next to Update, then File upload).
  2. Pick the .qbo file. Drag the .qbo file the converter produced into the drop area and select Continue.
  3. Choose the QuickBooks account. Select the bank or credit card account the transactions belong to, or add it first. The account type has to match the one used when converting: a card statement belongs to a credit card account.
  4. Let QuickBooks read the file. Web Connect files carry their own column layout, so there is no column-mapping screen — QuickBooks reads the dates, amounts, payees and memos straight from the file.
  5. Review and accept. The transactions land in the For review tab. Categorise or match them there; nothing hits the books until you accept them.

QuickBooks Online accepts up to 1,000 transactions per upload. Larger statements are split automatically into numbered files by the converter. Import errors are covered in the import error guide.

The sign convention is the whole story

Every other quirk on this page is minor next to this one: American Express reports what you spent as a positive number. Read literally, a month of spending becomes a month of deposits, your card balance moves the wrong way, and the mistake is easy to miss because every transaction is wrong in the same direction — nothing looks out of place until you reconcile.

The Amex preset flips every amount as it converts. That is the correct default, but it is also an assumption about a file format that changes from time to time, so the preview is not decorative: check two or three real charges against your statement. If they are negative, the file is right.

Additional details do not break anything

The Include all additional details option adds columns for category, transaction type and merchant address. They are extra, not different — the date, description and amount stay where they were. The converter reads the columns it needs by name and leaves the rest alone, so you can export either way. If you want the merchant address in QuickBooks, the column mapper can point the memo field at it.

Multiple cards on one account

An Amex business account with several supplementary cards exports every cardholder into one file, identified by the Card Member column. QuickBooks has no matching concept, so decide before converting: one register for the whole account (convert as is), or one per cardholder (filter the CSV by Card Member first, then convert each part).

Frequently asked questions

Why do my Amex charges import as income?
Because Amex writes charges as positive numbers and the importer took them at face value. The preset on this page flips every amount, which is why the preview shows purchases as negative before you download anything.
What is the Card Member column for?
It names the cardholder on multi-card accounts. It is not imported as the payee — the Description column holds the merchant — but it is useful for splitting an export per employee before converting.
Should the QuickBooks account be a credit card?
Yes. Charge cards and credit cards both belong in a credit card account. A .qbo file built for a bank account has a different internal structure and will not import cleanly into a card register.
Can I import an Amex statement older than 90 days?
Yes. The 90-day restriction is a bank feed behaviour. An uploaded Web Connect file can be as old as the export you downloaded.
Does the converter see my card number?
Nothing is transmitted. The file is parsed in your browser, and the account number column is not written into the .qbo file at all — QuickBooks uses the account you pick at import time.

Related banks

Other formats: OFX to QBO · QBO to CSV

Last updated .