Convert an American Express statement to Excel, CSV or QuickBooks
Amex statements are billing-cycle documents, and the cycle is not the month. For bookkeeping that is the whole story — everything else about the conversion is straightforward.
Covers Personal charge and credit cards, Business Platinum and Business Gold, Supplementary cards.
Drop a PDF bank statement here
Only pages with transactions count against this.
Review
Example statementHabib Bank Limited · 0441-79002251-03 · 2026-04-01 to 2026-04-30
- Row-by-row running balance
- Page subtotals
- Opening + movement = closing
- Printed credit / debit totals
- Printed credit / debit totals
- Transaction count
Arithmetic only. Verifies that amounts, balances and totals agree. Does not verify descriptions or dates, and cannot detect two errors that cancel out.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Apr 02, 2026 | IBFT TRANSFER FROM ZAINAB TRADERS / INV-4471 | PKR 185,000.00 | PKR 1,247,350.00 | |
| Apr 03, 2026 | POS PURCHASE 4157 IMTIAZ SUPER MARKET KARACHI | PKR 12,480.00 | PKR 1,234,870.00 | |
| Apr 05, 2026 | UTILITY PAYMENT K-ELECTRIC ACCOUNT 04412297 | PKR 38,640.00 | PKR 1,196,230.00 | |
| Apr 08, 2026 | CHEQUE 000241 CLEARED — AL-NOOR PACKAGING | PKR 220,000.00 | PKR 976,230.00 | |
| Apr 11, 2026 | IBFT TRANSFER FROM MEHRAN ENTERPRISES / PO-8890 | PKR 342,500.00 | PKR 1,318,730.00 | |
| Apr 14, 2026 | SALARY DISBURSEMENT APRIL 2026 — 11 EMPLOYEES | PKR 685,000.00 | PKR 633,730.00 | |
| Apr 17, 2026 | BANK CHARGES — ONLINE TRANSFER FEE | PKR 1,150.00 | PKR 632,580.00 | |
| Apr 21, 2026 | IBFT TRANSFER FROM SIDDIQUI BROTHERS / INV-4488 | PKR 128,750.00 | PKR 761,330.00 | |
| Apr 24, 2026 | POS PURCHASE 9921 TOTAL PARCO FUEL STATION | PKR 18,900.00 | PKR 742,430.00 | |
| Apr 28, 2026 | PROFIT CREDITED — SAVINGS ACCOUNT | PKR 4,318.00 | PKR 746,748.00 | |
| Closing balance10 transactions | PKR 746,748.00 | |||
Export
Preview is free. Create a free account to download.
Guest plan · preview only, no downloads
The billing cycle straddles two calendar months
An Amex statement typically runs from the middle of one month to the middle of the next. Import it as though it were a month and roughly half the transactions land in the wrong accounting period — nothing errors, the totals for each statement are internally correct, and the monthly figures in your books are wrong all year. The two ways out are to keep the card on a cycle basis deliberately and reconcile to the statement rather than the month, or to convert several statements and split the rows by calendar date. Whichever you pick, pick it before the first import, because changing basis midway leaves a gap or an overlap that has to be found by hand.
How a Amex statement is laid out
Worth checking against the statement in front of you — Amex issues more than one layout, and which you have changes what to look for after converting.
| Date format | MM/DD/YY |
|---|---|
| Running balance | Absent — previous balance, charges, payments and new balance instead |
| Period | Billing cycle, commonly starting mid-month |
| Ordering | Grouped by card member on accounts with supplementary cards |
| Extra detail | Foreign transactions print the original currency and the converted amount |
Downloaded activity and statements are not the same thing
Every large US bank offers two different exports, and people reach for the wrong one constantly. Downloadable account activity — CSV, and often QFX or OFX — covers a recent window, typically a few months, and stops. Statements are PDFs, are issued per period, and go back years. If you need last March, the activity export will not have it and the statement will; converting the PDF is how that gap is closed.
Excel for Amex
Excel first, so the rows can be filtered by calendar date before anything is imported. On a cycle-based card that step is not optional.
Convert to ExcelQuestions
- Why do my Amex figures not match my monthly reports?
- The statement covers a billing cycle, not a calendar month. Half the transactions on any statement belong to the previous or next month, depending on how you account for the card.
- How do I handle supplementary cards?
- The statement groups transactions by card member. Keep the grouping if you need to attribute spending; if you do not, sort by date and treat it as one account.
- What about foreign currency charges?
- Amex prints both the original amount and the converted one. The converted amount is what hits your account and is what belongs in the books; the original is useful context and should not be imported as a second transaction.