American Express isn't a bank; it's a credit card issuer (and increasingly a small business lender, but that's a separate product). Amex statements differ from bank checking statements in three important ways: there's no running balance column, the billing period is rarely a calendar month, and reward redemptions appear in ways that confuse standard bank-statement converters.
This guide covers Amex Business Platinum, Business Gold, Blue Business Cash, and the personal card lineup (Platinum, Gold, Green, Blue Cash, etc.). The conversion mechanics are largely the same across the card portfolio.
Short version: Amex statements use closing-cycle billing (not calendar months), itemize foreign transaction fees separately, and treat reward redemptions as negative transactions. None of these are bugs, but each one needs handling during QBO import.
Amex credit card statement notes for QBO
1. Closing cycle, not calendar month
Every Amex card has a billing cycle that ends on a specific day of the month (the Statement Closing Date). The statement covers the period between two closing dates — usually about 30 days, but rarely aligning with the calendar month.
If your client expects a "March P&L" in QBO, you have two options:
- Import each Amex statement period as-is, run reports by date range
- At month-end, manually pull mid-cycle transaction data from the Amex online account to align with the calendar month
Option 1 is easier and accurate. Option 2 is what some clients want but is honestly extra work that the client should pay for if they insist on it.
2. Reward redemptions as negative transactions
When your client uses Amex Membership Rewards points for a statement credit, the credit appears as a negative-amount line item in the transactions section. It's correctly treated as a credit to the card balance, but if you're auto-categorizing all "expenses" via a bank rule, the reward redemption gets miscategorized.
Add a bank rule for transactions with descriptions containing "MEMBERSHIP REWARDS" or "POINTS REDEMPTION" to route them to Other Income or a Rewards income account.
3. Foreign transaction fees on Business Platinum (no FX fee)
Note: Amex Business Platinum has no foreign transaction fees. Amex Business Gold has no FX fees either. But Amex Business Blue Cash and some personal cards do. If you see FX fees in your converted statement and the card is supposed to be no-FX, double-check the card type — you may be looking at a different card than the client thinks.
Three ways to do the actual conversion
Option 1: Copy-paste, one-time use
If this is a one-off and you have an hour, you can open the PDF, select the transaction table, paste into Excel, use Text-to-Columns to split, manually merge continuation rows, drop any extra columns, reformat the date, and save as CSV. Works for one statement. Doesn't scale.
Option 2: A generic PDF-to-Excel tool
Adobe Acrobat, Smallpdf, Tabula, and similar tools will extract the table mostly correctly. The catch: they don't know what a bank transaction is, so they won't merge continuation lines, they'll include columns you don't want, and they won't verify that the converted file reconciles. You'll spend cleanup time after.
Option 3: A bank-statement-specific converter that reconciles
A purpose-built converter recognizes the American Express statement format, handles the quirks above automatically, and — the part that matters most — reconciles the converted file against the statement's beginning and ending balances before handing you the file. If the totals don't tie, you find out immediately, not after the QBO import is already done.
Worth trying: If you're processing American Express statements regularly, an automated converter that reconciles to the statement totals before you download saves the manual cleanup. YourStatementConverter does this on every conversion — 25 pages free with no credit card to test on a real client statement.
Common errors and how to fix them
"My Amex import is way off month-to-month"
The statement closing date isn't the last of the month. Pull the statement and confirm the date range it covers. A typical statement might cover Feb 20-March 19, not March 1-March 31. Your QBO month-end totals will look weird if you import as though it were a calendar month.
"QBO is rejecting my date format"
QBO requires MM/DD/YYYY. If your conversion output uses a different format, fix it in Excel before importing. The simplest formula is =TEXT(A1,"MM/DD/YYYY") applied to the date column.
"Descriptions are showing up twice or in pieces"
Almost always a continuation-line problem. Sort the converted file by date; any row with a blank date is a continuation that should be merged into the row above. Filter for blank dates, copy descriptions up, then delete the empty rows.
Importing the converted file into QuickBooks Online
Once you have a clean Excel or CSV file from a American Express statement, the QBO import is the same as for any other bank. QBO expects three columns:
| Column | Format | Notes |
|---|---|---|
| Date | MM/DD/YYYY | QBO is strict on date formatting |
| Description | Plain text | Keep under 4,000 characters |
| Amount | Decimal, negative for debits | Or use separate Credit/Debit columns |
To import:
- In QBO, go to Bookkeeping → Transactions → Bank transactions
- Choose the bank account, click the dropdown next to "Link account," and pick Upload from file
- Drag in the CSV, map the columns, click Next
- Spot-check a few transactions on the preview
- Confirm and import
QBO will check against existing transactions to prevent duplicate imports, so re-running a statement won't double-count.
Final checklist before importing your American Express file to QBO
- Three columns only: Date, Description, Amount
- Date in MM/DD/YYYY format
- Debits are negative (or split into Credit/Debit columns)
- Any running balance column removed
- No empty rows or unmerged continuation rows
- Total of Amount column equals Statement ending balance minus Beginning balance
If all six are checked, the QBO import will be uneventful — which is the goal.
For more on the reconciliation discipline that makes catch-up work tractable, see our walkthrough on catching up 24 months of bookkeeping.