If you pay with an American Express card, learning to convert American Express statement PDF to CSV is the simplest way to get card spending into QuickBooks Online without retyping it. Amex statements list charges, payments, fees, and credits across personal and business cards, and a clean CSV turns that list into categorized expenses in minutes.
This guide covers the cardholder workflow: downloading the statement from your Amex account, converting it to a QuickBooks-ready CSV, cleaning up supplementary cards and credits, and importing it as a credit card account — with the payment from your checking account recorded as a transfer, not as spending twice.
Downloading your American Express statement
Sign in to your American Express account, open the card you need, and download the monthly statement as a PDF. Choose the official statement for the billing period, not an activity view: the statement carries the opening balance, the closing balance, and the minimum payment and total due figures that let you reconcile later. If you hold several Amex cards, download each card separately — one card per file, one QuickBooks credit card account per card.
Business cardholders should note the same rule for employee cards. Supplementary card charges appear on the same statement, but they belong to different people and often different expense categories. Keep the full statement intact for conversion, and sort out who spent what in the cleanup pass below, while the purchases are still fresh in memory.
Converting the PDF to a QuickBooks-ready CSV
Upload the PDF to a statement converter and choose CSV output. Amex statements are usually clean tables, but check the preview for two common glitches: foreign-currency charges that show both the foreign amount and the converted dollar amount, and charges split across a page break. Keep the dollar amount column only, and repair any split row before import — a half-row in QuickBooks is a mystery expense later.
Strip currency symbols from amounts and keep one sign rule: charges positive, payments and credits negative, or the reverse, consistently. Dates should use one format for the whole file. Our Amex conversion guide covers the statement layout in more detail, and our TD Bank conversion guide walks through the same upload flow for a bank account.
Cleaning up cards, credits, and membership rewards
Amex statements reward a short cleanup pass. Expand truncated merchant names into plain English — a code that reads SQ COFFEE becomes a vendor you can actually report on — and tag supplementary card charges by cardholder so expense reports write themselves. Return credits should stay matched to their original charges rather than deleted, or your spending will look higher than it was.
Annual fees and interest charges are expenses in their own right: categorize the annual fee as a bank or card fee, and interest as interest expense, not as general spending. Membership Rewards points are not income when earned and not an expense when redeemed for statement credits; record a redemption credit against the purchases it offsets, and keep it simple rather than inventing a points asset account.
Importing as a credit card account in QuickBooks
In QuickBooks Online, open Banking, then Bank transactions, then Upload from file, and select the credit card account for this Amex card. Map Date, Description, and Amount, then study the preview: the first row should be a real charge, not a header, and the last row should be a real transaction, not a statement footer. Import one billing period at a time, oldest to newest.
Work through the For review tab methodically: match charges to bills and receipts, categorize the rest, and create bank rules for recurring vendors. The payment you make from checking appears on the Amex statement as a credit — in QuickBooks, record it as a transfer to the card account, matching the checking side, so the payment never counts as spending.
Reconciling and avoiding double-counted card spending
Reconcile the card account against each statement: the QuickBooks balance must equal the statement closing balance. The two classic errors are recording the checking-account payment as a new expense — which double-counts everything you bought that month — and importing the same billing period twice, once from a feed and once from a file. Pick one import path per card account and stick to it.
If a balance will not reconcile, check for a charge dated in the next period, a return credit you categorized as a purchase, or a supplementary card charge imported into the wrong card account. Our PNC conversion guide explains the same gap-hunting routine. A reconciled card account means your expense reports and tax deductions rest on numbers you can defend.
Frequently asked questions
Can I import Amex statements into QuickBooks Online?
Yes, through Banking and Upload from file. Convert the monthly PDF to CSV, map Date, Description, and Amount, and import into the credit card account for that Amex card.
How do I record the payment from my checking account?
As a transfer to the card account, not as an expense. The purchases were the expenses; the payment only moves money from checking to the card.
What about charges in foreign currency?
Keep the converted dollar amount from the statement and import that. The foreign amount is useful context, but QuickBooks needs the dollar figure that affects your balance.
Do supplementary card charges need separate handling?
Import them with the statement, then categorize by cardholder in QuickBooks so each person's spending reports correctly. One card account per card, not per cardholder.
Card spending should reconcile itself. Convert your American Express statement to a QuickBooks-ready CSV and import the billing period in minutes.