LedgerPortConvert an American Express CSV to QBO
Download your American Express transactions as CSV, drop the file below, and get a QBO file QuickBooks can import. The file is converted in your browser and never uploaded.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
Getting the CSV from American Express
Sign in on the American Express website, open the account, and look for the option to download or export activity. Choose the date range you need and pick CSV (sometimes labelled "Spreadsheet" or "Excel CSV") as the file type. Mobile apps often lack this option, so use a desktop browser.
How the American Express file is read
American Express exports have the columns Date, Description and Amount, sometimes with Card Member and Account # as well.
- Purchases are listed as positive numbers and payments as negative, the opposite of what an import needs. The converter recognises this, reverses the signs and sets the account type to credit card, and tells you it has done so.
- Check the preview before downloading: purchases should be shown in red with a minus sign. If they are not, tick Reverse signs.
- The Card Member and Account # columns are ignored.
Importing the QBO file
QuickBooks Desktop: choose File → Utilities → Import → Web Connect Files, select the file, and pick the account. QuickBooks Online: go to Transactions → Bank transactions, open the menu next to Link account, and choose Upload from file. The import guide has the full steps, and there is a page on fixing import errors.
Need a different output? The same file converts to QFX for Quicken, OFX or QIF.
Questions and answers
Does American Express see or approve this?
No. LedgerPort is an independent tool and is not affiliated with American Express. It only reads the file you downloaded, on your own device.
What if my export looks different from the one described?
Banks change their exports from time to time. The converter works from the column names and the data rather than a fixed template, and you can reassign any column in the Columns panel.
Is it free?
Your first 10 documents are free, whatever their size, with no card and no licence key. After that, plans start at $9. See pricing.