How to Convert an American Express Statement to Excel or QuickBooks
Turn an Amex statement PDF into Excel, CSV, or a QuickBooks .QBO file — Business Gold, Platinum, and personal cards, with charge/payment polarity handled.
American Express statements are long, dense, and PDF-only once they age out of the download window. Here is how to convert an Amex statement — Business Gold, Business Platinum, Blue Business, or a personal card — into Excel, CSV, or a QuickBooks .QBO file with the signs pointing the right way.
Get your Amex statement PDF
- Sign in at americanexpress.com.
- Go to Statements & Activity → Billing Statements.
- Pick the closing date and download the PDF.
Amex keeps up to 7 years of statements online (older ones may take a day to retrieve) — more than enough runway for catch-up work.
Convert it
- Open Convert Bank Statements and drop the Amex PDF in.
- Every charge, payment, and credit is extracted automatically.
- Check the balance badge: the statement must reconcile — previous balance + new charges − payments/credits = new balance.
- Export as Excel, CSV, QuickBooks (.QBO), or OFX.
Amex-specific tips
- Polarity is the classic Amex trap. Credit-card statements flip signs relative to bank accounts; a naive converter posts charges as deposits. Charges and payments carry the correct sign into QuickBooks here.
- Employee cards on one statement: business statements grouping several cardmembers convert as one account with every cardmember's charges included — nothing dropped between sections.
- Membership Rewards summaries and promotional pages are ignored — you only pay for pages with transactions.
- Scanned copies work; the balance check catches OCR misreads. See the scanned statement guide.
Is it accurate?
Every statement must reconcile against its own printed balances before you export. Rows that break the math get flagged for review — misreads don't reach your books. Details on our security page.
FAQ
Does this work for Amex Business cards? Yes — Business Gold, Platinum, Blue Business, and personal cards.
What about statements with several employee cards? Yes — all cardmember sections are captured on the one account.
Is my data safe? Your PDF is auto-deleted in 24 hours and never used to train AI. See our Privacy Policy.
How much does it cost? Sign up and get 15 free pages. Page packs start at $12 and never expire — see pricing.
Convert an Amex statement now →
Related guides
- Convert a bank statement to QuickBooks (.QBO)
- Import bank statements into QuickBooks Desktop
- Convert a scanned bank statement (OCR)
- Convert a Chase bank statement
Not affiliated with or endorsed by American Express. American Express is a trademark of American Express Company. QuickBooks is a trademark of Intuit Inc.
Author
Categories
More Posts
The Best Bank Statement Converter in 2026: How to Choose
There's no single best bank statement converter — there's the right one for your job. Here are the six criteria that actually matter, and an honest look at the options.
How to Convert a KeyBank Statement to Excel or QuickBooks
Turn a KeyBank statement PDF into Excel, CSV, or a QuickBooks .QBO file — including older statements KeyBank no longer offers as data downloads. Every balance verified.
How to Convert a PNC Bank Statement to Excel or QuickBooks
Turn a PNC statement PDF into Excel, CSV, or a QuickBooks .QBO file — including Virtual Wallet statements with Spend, Reserve and Growth accounts split correctly.
Newsletter
Join the community
Subscribe to our newsletter for the latest news and updates