American Express is different from a bank account
American Express statements are credit card statements, so the signs need more care than checking-account statements.
A bank account usually has deposits and withdrawals. A credit card statement has purchases, fees, payments, credits, refunds and rewards-related lines. If those signs are imported backwards, your books can look wrong very quickly.
That is why bookkeepers should treat Amex conversions as credit-card work, not ordinary bank-account work.
What American Express lets you download
American Express publishes two useful facts for US accounts:
| Amex data | Official download options |
|---|---|
| Recent activity and past six billing statements | Quicken, QuickBooks or CSV |
| Previous two years of transactions | PDF, Excel or CSV |
| Archived statement PDFs | Available online after request, with archived statements available within 24 hours |
So for recent Amex work, the official export may be enough. But if a client sends PDF statements, you still need to convert them into a working file.
When to convert the Amex PDF statement
Use the official Amex export if:
- the client can access it
- it covers the full period
- it imports cleanly
- you do not need the exact PDF statement layout
Convert the PDF statement if:
- the client only sent PDFs
- the period is older or archived
- you need the exact billing-cycle statement
- your software needs a different CSV layout
- you want to keep the statement as source and the spreadsheet as the working file
For accountants and CAs, that last point matters. The PDF supports the period. The spreadsheet supports the work.
Convert American Express PDF statements to Excel
Use Excel for review and cleanup before the accounting import.
- Upload the American Express PDF statement.
- Choose Excel (.xlsx).
- Use OCR mode if the statement is scanned or image-based.
- Check the statement total, payments and credits.
- Categorise transactions and flag client questions.
A useful Amex spreadsheet should separate:
- date
- description or merchant
- purchases / charges
- payments / credits
- balance or statement amount where available
Convert American Express PDF statements to CSV
Use CSV when you need to import or combine several Amex statement periods.
A credit-card CSV needs special checking:
| Field | Check |
|---|---|
| Purchases | Usually treated as money out / expense |
| Payments | Usually reduce the card balance; not income |
| Credits and refunds | Need review so they do not become sales |
| Fees and interest | May need separate categories |
| Transfers | Should not be duplicated in the bank account and card account |
If you import blindly, a credit card payment can appear as income in one place and expense in another. Review signs first.
American Express to QuickBooks
American Express says recent activity and the past six billing statements can be downloaded to QuickBooks directly. If that covers your period and maps correctly, that may be the simplest route.
If you are working from PDFs, convert to QuickBooks CSV:
| QuickBooks output | Best when |
|---|---|
| 3-column CSV | One Amount column is easier for your card account import |
| 4-column CSV | You want charges and credits split before upload |
After import, choose the credit card account, not a bank account. Then check payments, credits and refunds before categorising.
American Express to Xero
Use the Xero CSV output when the destination is Xero. Xero can import statement lines from CSV, but the credit-card signs still need review.
Check:
- purchases appear as spend / money out
- payments do not become revenue
- refunds and credits are mapped correctly
- the import period does not overlap with a bank feed
- statement periods are not duplicated
For monthly bookkeeping, import one Amex statement period at a time and reconcile before moving to the next.
Workflow for bookkeepers and accounting teams
For an Amex cleanup job:
- Collect the PDF statements. Use the exact billing periods the client needs.
- Ask whether an official export exists. Use it if it covers the whole period and imports cleanly.
- Convert PDFs when needed. Use Excel for review or QuickBooks/Xero CSV for upload.
- Check signs. Purchases, payments, refunds and credits need different treatment.
- Match card payments. A payment out of a checking account should match the payment into the Amex account.
- Keep the original PDFs. They are the source record.
American Express is often the messiest account in a client file because it mixes purchases, travel, subscriptions, reimbursements and payments. A clean converted file makes the questions visible before they become reconciliation problems.