How to Import American Express Transactions into QuickBooks

Short answer: If the period you need falls inside the last six billing statements, download it straight from American Express, which offers a QuickBooks, Quicken, or CSV download of your recent activity and the past six billing statements. If the period is older than that, or the card is closed, or you are a bookkeeper working from a forwarded PDF, convert the Amex statement into a .qbo Web Connect file and upload it to the Amex credit card account in QuickBooks.

Does American Express connect to QuickBooks?

Yes. American Express connects to QuickBooks Online as a bank feed, and the Amex website separately offers a direct download of transactions into QuickBooks and Quicken. On the face of it, that makes Amex one of the better-served issuers. The trouble is not whether the connection exists. It is how far back it goes.

Two limits stack on top of each other, and together they cover far less ground than people assume:

• The Amex download stops at six billing statements. American Express states that you can download your recent activity and the past six billing statements to Quicken, QuickBooks, or as a CSV file. Six statements is roughly six months.
• The QuickBooks feed will not backfill past 90 days. That ceiling belongs to Intuit, not Amex. Connect a card feed today and it typically brings in about the last 90 days. Older activity has to be added from a file you upload yourself.

So if you are current, you are fine. If you are behind, which is the normal state of affairs for a business doing a year-end catch-up, neither path reaches the months you actually need.

How far back can I download Amex transactions into QuickBooks?

Six billing statements plus recent activity, and no further. That is Amex's own stated limit. Meanwhile the statements themselves persist for years: on business accounts, American Express says program administrators can download statements up to seven years in the past at no fee, and on a personal card the previous two years of transactions can be viewed electronically and saved as PDF, Excel, or CSV.

Sit those two facts next to each other and the shape of the problem is obvious. The record exists. It goes back years. It is simply in a format QuickBooks will not read, and the one download that speaks QuickBooks only looks back six months.

How to import Amex transactions into QuickBooks Online

For recent months, the native download is the fastest route:

1. Sign in at americanexpress.com and open Statements & Activity.
2. Choose the billing period, then the download option, and pick the QuickBooks format.
3. In QuickBooks Online go to Transactions, then Bank transactions, open the Link account dropdown and choose Upload from file.
4. Select the file, and on the next screen choose the Amex credit card account, not a checking account. This is the step people get wrong.
5. Import. The rows land in For Review, where you categorize them and match anything the feed already brought in.

For anything older than six statements, download the PDF statement instead and convert the Amex statement to a QBO file, then follow the same upload path from step 3. QuickBooks treats a converted Web Connect file exactly like a bank download, duplicate detection included.

How to import Amex transactions into QuickBooks Desktop

Desktop is stricter, and the strictness is the whole story. QuickBooks Desktop imports Web Connect .qbo files for bank and credit card transactions. It has no native CSV import for them, and QIF does not work for a credit card account either. Any guide telling you to import a spreadsheet directly into Desktop is describing a third party add-on, not QuickBooks.

1. Get a .qbo file, either from the Amex download (inside the six-statement window) or by converting the statement PDF (for anything older).
2. Go to File, Utilities, Import, Web Connect Files. The equivalent route runs through Banking, Bank Feeds, Import Web Connect Files.
3. Choose the file and associate it with the Amex credit card account.
4. Review the transactions in the Bank Feeds Center and add them to the register.

One thing worth knowing before you plan a migration around it: Intuit stopped selling new QuickBooks Desktop Pro, Premier, and Mac subscriptions to US customers in 2024. Existing subscribers keep renewing and Enterprise is still sold, so a large number of US firms are still on Desktop and still need that .qbo file.

Why did my Amex charges import as payments?

Because the amounts arrived positive. In a QuickBooks credit card account, a charge has to be a negative number and a payment or refund has to be positive. Card issuers write their exports from their own point of view and list purchases as positive, so an untouched file posts every purchase as money paid toward the card and the balance walks the wrong way.

If you are fixing a spreadsheet by hand, add a helper column that multiplies the amount by negative one and paste the result back as values. Better, use the four column layout with separate Debit and Credit columns, where you place each amount in the right column and never argue about a sign at all. A converted .qbo file arrives already signed correctly, which is the main reason people stop hand-editing CSVs after the first month.

What the CSV route costs you

The Amex CSV is a legitimate option for QuickBooks Online, but it is more work than it looks. QuickBooks Online accepts a three column file of Date, Description, and Amount, or a four column file with Date, Description, Credit, and Debit. Before it will take yours, you need to use one date format throughout, remove dollar signs and thousands separators, leave zero-only cells blank, avoid descriptions that are purely numeric, and keep the file under 1,000 transactions and 350 KB. A busy card blows through the 1,000 line cap inside a year, so the period has to be split into several uploads.

None of that is hard. It is just an hour you spend every time, and it is an hour where a mis-signed column or a stray date format quietly corrupts a reconciliation you will chase down three weeks later.

Handling employee cards on a business account

An Amex Business account usually carries supplementary cards for employees, and all of them land on one statement. That is convenient for paying the bill and awkward for the books, because the spend has to be attributed before anyone can approve it. The statement names the cardholder against each charge, and a converted file keeps that detail in the transaction description, so you can filter, class, or tag the rows by cardholder in QuickBooks rather than reverse-engineering who bought what from a merchant name.

Annual fees, late fees, interest, and foreign transaction fees each come across as their own lines too. Those are the rows that get lost when someone retypes a statement into a spreadsheet, and they are exactly the rows a tax preparer will ask about.

Can I import a statement from a closed Amex card?

Yes, and it is one of the most common reasons anyone converts anything. Cancel a card and the download menu goes with it. There is no feed to connect and no export to pull, so the PDF statements you saved before closing the account become the only surviving record of that spend. Converting them is the only way it reaches QuickBooks. This is worth remembering before you close a card: save the statements first.

Avoiding duplicates when the feed is already running

If the Amex feed is live and you import converted history on top of it, you will double up. The fix is simple and mechanical. Open the register, find the oldest transaction the feed brought in, and end your converted file the day before that date. Load history behind the feed, never over it.

QuickBooks does attempt duplicate detection on a Web Connect import, but it matches on amount, date, and reference, so a description that got reworded or a posting date that shifted by a day will slip past it. Checking the boundary date yourself takes thirty seconds and saves an afternoon.

After the import: reconciling the card

Importing is half the month. Open Reconcile, pick the Amex card, and enter the statement ending balance and ending date exactly as the statement prints them. Card cycles rarely end on the last day of the month, and using the calendar month instead of the cycle end date is the single most common reason a card reconciliation refuses to close. Clear each line until the difference reads $0.00, then record the payment to the card so it matches the checking feed later instead of doubling up.

If receipts are part of your substantiation, this is also the point where matching them to charges pays off, and pulling the line items off those receipts into a spreadsheet is a job worth automating with receipt data extraction rather than doing by hand for a year of business card spend.

Frequently asked questions

Does American Express connect to QuickBooks?

Yes. Amex connects to QuickBooks Online as a bank feed, and the Amex website offers a direct download into QuickBooks and Quicken. The constraint is reach, not availability: the download covers recent activity plus the past six billing statements, and a new feed will not pull past roughly 90 days.

How far back can I download Amex transactions into QuickBooks?

Six billing statements plus recent activity. Your statement archive goes back much further, up to seven years for business program administrators, but those are PDFs, and QuickBooks cannot import a PDF on the standard upload path without conversion.

Can QuickBooks Desktop import an Amex CSV?

No. QuickBooks Desktop has no native CSV import for bank or credit card transactions, and QIF does not work for card accounts either. Desktop needs a Web Connect .qbo file, which you get either from the Amex download inside its six-statement window, or by converting the statement PDF.

Why did my Amex charges import as payments?

The amounts were positive. QuickBooks reads a positive number in a credit card account as money paid toward the balance, and Amex exports purchases as positive figures. Flip the sign, or use separate Debit and Credit columns. Delete the reversed batch before re-importing so you do not create duplicates.

How many Amex transactions can I upload at once?

QuickBooks Online caps a manual upload at 1,000 lines in a file of 350 KB or less. An active business card exceeds that within a year, so split the period into several files and upload them one after another, each pointed at the same credit card account.

Can I import a statement from a cancelled Amex card?

Yes. A closed card has no feed and no download menu, so the PDF statements are the only record left. Convert them and upload the file to the credit card account. Save the statements before you close a card, because retrieving them afterward is considerably harder.