How to Convert Credit Card Statements to Excel (2026 Guide)
Credit card statements look like bank statements but parse very differently. Foreign fees, rewards summaries, multi-card sections, and Amex's currency tables trip up generic converters. Here's how to extract clean transaction data from any issuer.
Pop quiz. A Chase Sapphire Preferred and a Chase Freedom Flex on the same account. The statement PDF has both cards. Each card has its own transaction section, with a sub-header that reads "Sapphire Preferred - Cardholder Joe Smith." How many transactions does the spreadsheet your generic PDF-to-Excel converter just produced actually contain?
Often the answer is "fewer than you think" - because the converter treated the sub-header as a data row, then dropped half the transactions on the floor.
Credit card statements look superficially like bank statements. They aren't. The fields, the layout, and the issuer-specific quirks all differ. A converter built for bank statements will miss things - and a proper credit card converter has to handle Amex's currency tables, Chase's card-product groupings, Discover's rewards summaries, and Capital One's wrapped descriptions all at once.
This guide walks through what makes credit card statements distinct, how to convert them cleanly to Excel or CSV, and what to watch for with each major issuer.
Why Credit Card Statements Aren't Bank Statements
A bank checking account statement is structurally simple: a list of transactions with dates, descriptions, debits, credits, and a running balance. A credit card statement has all of that plus seven additional concepts that don't exist on bank statements.
1. Statement Period vs. Payment Due Date
Bank statements have a single date range. Credit card statements have two: the statement period (when transactions occurred) and the payment due date (when the minimum payment must arrive). These rarely match - the due date is usually 21–25 days after the statement period closes.
2. Statement Balance vs. Minimum Payment vs. Current Balance
Bank statements show one closing balance. Credit card statements show three:
- Statement balance - what you owe to avoid interest
- Minimum payment - the smallest amount that keeps the account in good standing
- Current balance - what you actually owe right now (statement balance + transactions since the statement closed)
Importing the wrong one to QuickBooks creates reconciliation chaos.
3. Foreign Transaction Fees and Multi-Currency Lines
A foreign purchase generates two or three lines on the statement:
- The original transaction in foreign currency (e.g.,
€127.45) - The converted USD charge (e.g.,
$138.92) - The foreign transaction fee (e.g.,
$4.17, typically 1–3%)
Some issuers (Amex, Capital One) format these as a single combined line with a sub-line for the fee. Others (Chase, Citi) put them as separate transactions. Generic parsers commonly merge or split these incorrectly.
4. Pending vs. Posted Transactions
Most credit card statements include both posted (cleared) transactions and pending charges. Pending transactions can change - the merchant might adjust the amount or even reverse the charge before posting. For bookkeeping, you want only posted; for reconciliation, you want both flagged separately.
5. Rewards / Cashback Summaries
Credit card statements include a rewards summary table - points earned, cashback by category, redemptions, balance forward. On Amex and Discover statements, this table sits adjacent to the transactions section and trips up parsers that don't know to skip it. On Chase, the rewards section is at the bottom and easier to ignore.
6. Multiple Cardholders on One Account
Joint accounts and authorized users mean a single statement might have transactions from 2–4 different physical cards, each with its own sub-section and sub-header. Each transaction has a "card ending in XXXX" identifier. For business expense splitting (employee-by-employee), this matters.
7. Multiple Cards on One Account
Issuers like Chase let you combine two card products on one statement (e.g., Sapphire Preferred + Freedom Flex). Each card's transactions appear in their own sub-section with a card-specific sub-header. Generic parsers treat the sub-headers as transaction rows, corrupting the output.
These seven differences are why a converter that nails bank statements can fail badly on credit card statements.
What's on a Credit Card Statement (Field by Field)
Most credit card statements follow the same general layout, with issuer-specific variations.
Header Section
- Account number (usually masked:
****1234) - Cardholder name(s)
- Statement closing date
- Payment due date
- Statement balance
- Minimum payment due
- Credit limit
- Available credit
Account Summary
- Previous balance
- Payments received
- Other credits
- Purchases
- Cash advances
- Balance transfers
- Fees charged
- Interest charged
- New balance
Transactions Section
For each transaction:
- Transaction date
- Posting date (sometimes hidden, sometimes shown)
- Merchant name and location
- Reference number / transaction ID (sometimes)
- Amount (USD, with currency conversion for foreign)
- Foreign transaction details (when applicable)
- Category (some issuers)
- Card ending (when multiple cards)
Payments and Credits
- Payment date
- Payment method or source
- Amount
- Returns and merchant credits
Fees and Interest
- Annual fee (if applicable)
- Late payment fee (if applicable)
- Foreign transaction fees (rolled up or per-transaction)
- Cash advance fee
- Balance transfer fee
- Interest charge breakdown by category (purchases, cash advances, balance transfers - each can have a different APR)
Rewards Summary
- Beginning balance
- Earned this period
- Redeemed
- Adjustments
- Ending balance
- Cashback / points by category
Disclosures
- APR explanations
- Minimum payment calculation
- Fee disclosures
- Mailing instructions
The transactions section is what most workflows want extracted. Everything else is noise - but the parser needs to know what's noise vs. what's data.
Issuer-Specific Quirks
The five major US issuers each have layout patterns that affect parsing.
American Express
Amex statements are the most complex to parse cleanly. Multi-currency formatting embeds the original currency, the conversion rate, and the USD amount into a structured sub-table beneath each foreign transaction. The Membership Rewards section sits next to transaction data, and a generic parser might pull a "1,247 points earned" line as if it were a transaction amount.
Common Amex pitfalls:
- Combining Membership Rewards lines with charges
- Splitting multi-currency transactions incorrectly
- Missing the "Payment Received - Thank You" credit on consolidated statements
- Mis-categorizing Pay Over Time interest charges
Chase
Chase statements often combine multiple card products on a single statement. Each product has its own sub-header (e.g., "Chase Sapphire Preferred - Joe Smith") and its own transaction list. Wrapped merchant descriptions are common when the merchant address or reference number occupies a second line.
Common Chase pitfalls:
- Treating product sub-headers as transactions
- Splitting wrapped merchant descriptions across two rows
- Mis-attributing transactions when both authorized users share a first name
- Mishandling the "Travel" category on Sapphire products
Capital One
Capital One groups transactions by category (Dining, Travel, Groceries, etc.) on some card products. Each category has a sub-header. The CSV download from Capital One's website is limited to 90 days, the shortest window of any major issuer - so PDF extraction is the only path for older transactions.
Common Capital One pitfalls:
- Treating category sub-headers as transactions
- Wrapped descriptions on multi-line merchant entries
- Missing the foreign transaction fee distinction on Quicksilver (no FX fee) vs. Platinum (FX fee applies) - same statement format, different fee handling
Discover
Discover puts the rewards summary table close to the transactions section, sometimes mid-statement. The rotating 5% category each quarter shows up in the rewards summary with its own line items.
Common Discover pitfalls:
- Pulling "Cashback Bonus earned this period" as a transaction
- Confusing the 5% category bonus tracker with regular transactions
Citi
Citi statements are relatively clean compared to the others - single-card sections, consistent layouts across product lines (Citi Premier, Citi Custom Cash, Citi Double Cash). The main quirk: Citi separates "Standard Purchases" from "Special Offer Promotions" (e.g., 0% intro APR balances), which means the same transaction can appear in either section depending on which offer was active.
Common Citi pitfalls:
- Missing the "Special Offer" section
- Mis-parsing the deferred interest disclosure as a transaction
How AI Extraction Handles These Quirks
Generic PDF-to-Excel converters use coordinate-based parsing: "everything between Y=200 and Y=600 is a transaction." This works when the layout is uniform. It fails when sub-headers, summary tables, and multi-line entries break the assumption.
AI extraction reads the document semantically:
- "This row has a date in the first column, a merchant name in the second, and an amount in the last - it's a transaction"
- "This row has just text in the first column and no amount - it's a sub-header, skip it"
- "This row's amount is in a different format (parentheses for credits, or a different currency) - flag it"
The result is a clean transaction list regardless of layout, with metadata indicating which card or section each transaction belonged to.
PDFSub's Bank Statement Converter handles credit card statements the same way it handles bank statements - Tier 1 coordinate extraction first (free, no AI credits), with AI fallback for documents the coordinate parser can't cleanly handle. The output preserves issuer-specific metadata: card last-4, foreign transaction fees, rewards categories.
What You Get in the Excel Export
For each credit card statement, the converter exports:
| Column | Example | Notes |
|---|---|---|
| Transaction Date | 2026-04-15 | The date the transaction occurred |
| Posting Date | 2026-04-17 | When the charge cleared |
| Description | TRADER JOES #234 LOS ANGELES CA | Cleaned merchant name + location |
| Category | Groceries | Issuer-assigned category (when present) |
| Amount | -127.45 | Negative for charges, positive for credits |
| Currency | USD | Original transaction currency |
| Foreign Amount | EUR 110.20 | Original foreign amount when applicable |
| Foreign Fee | 3.17 | FX fee for the transaction |
| Card Last 4 | 1234 | For multi-card statements |
| Cardholder | Joe Smith | When authorized users are present |
| Section | Posted Transactions | Where this row came from in the PDF |
Header rows (account info, balances, due dates) and rewards summaries are exported to a separate metadata sheet so the transactions tab stays clean.
Step-by-Step: Converting a Credit Card Statement with PDFSub
The workflow:
- Go to the Bank Statement Converter
- Upload your credit card statement PDF - supports up to 20MB
- Locale auto-detects - the tool identifies USD, multi-currency, or international issuers automatically
- Click "Extract Transactions" - Tier 1 (coordinate extraction, free) runs first; if the layout is too complex, AI fallback runs
- Review the transaction list - every row is labeled with section, card, and metadata
- Export - choose Excel, CSV, JSON, OFX, QBO, QFX, or QIF
For QuickBooks Online users, QBO export imports directly via "Upload bank file." For Excel-based bookkeeping, the CSV with negative-amount-for-charges convention is the most common format.
Pro tip: If your statement combines multiple card products (common on Chase), the export includes a "Card Last 4" column. Filter by card in Excel to split per-product spending - useful for separating personal and business charges on the same account.
Importing to QuickBooks, Xero, or Wave
Each accounting platform has its preferred format for credit card import.
QuickBooks Online
QBO format imports cleanest. Use the QBO export from the Bank Statement Converter, then in QuickBooks: Banking → Upload from file → select QBO. Transactions appear in the For Review tab. Set categorization rules to auto-classify recurring vendors so the next month's import is mostly pre-categorized.
Xero
Xero accepts CSV with custom field mapping. Use the CSV export, then in Xero: Accounting → Bank accounts → Manage account → Import a statement. Map columns to Xero's date/description/amount fields.
Wave
Wave accepts CSV directly. The import flow is Banking → Connections → Upload file. Wave auto-categorizes recurring vendors after the first manual pass.
Sage Business Cloud
Sage uses OFX. Use the OFX export and import via Banking → Bank Feeds → Import.
Excel/Sheets (manual bookkeeping)
CSV is the universal format. Open in Excel, add an "Account" column, paste into your master ledger. The negative-amount convention matches most accounting templates.
Use Cases
Different workflows benefit from credit card statement extraction.
Business Expense Tracking
Sole proprietors and LLCs running expenses through a dedicated business credit card need to categorize every charge for Schedule C or 1120-S deductions. Extracting 12 months of statements at year-end takes 5 minutes vs. 5 hours of manual entry.
Tax Deductions
For mixed-use cards (some business, some personal), the export's transaction-by-transaction list lets you tag each charge as deductible or not. Common deductions: meals (50%), office supplies, software subscriptions, business travel.
Mortgage Underwriting
Lenders increasingly request 12 months of credit card statements alongside bank statements. Extraction turns the PDF stack into a clean transaction history for the underwriter to review.
Audit Preparation
For an IRS audit on a business return, every Schedule C deduction needs documentation. Extracting credit card statements provides the source data; matching back to receipts (via the Receipt Scanner) closes the loop.
Fraud Detection
Reviewing 6 months of statements for suspicious charges is impossible by eye on a long PDF. In Excel, sorting by amount, merchant, or category surfaces patterns instantly.
Personal Budgeting
For a family with one or two credit cards, extracting and categorizing 12 months of charges produces a budget snapshot that no app's category-tagging quite matches.
Best Practices
Download from the Issuer Portal, Not from Email
The PDF you download from chase.com or americanexpress.com contains embedded text - extraction nails it. The PDF emailed to you may have been re-printed by your email client and lost the embedded text. Always download from the issuer.
Check the Statement Period
Most issuers have a fixed close date (e.g., always the 18th). When extracting multiple months, verify each statement's period is contiguous - a missed month creates gaps in your annual total.
Verify Foreign Transactions Manually
For travel-heavy months, spot-check 2–3 foreign transactions in the export against the PDF. The foreign amount, FX rate, and FX fee should all match. Errors are rare but high-value when they happen.
Categorize Once, Set Up Rules
After your first extraction and import, set up auto-categorization rules in QuickBooks/Xero for recurring vendors. The next month's import is then 90% pre-categorized.
Reconcile Against the Statement Balance
The sum of all transactions in the export should equal the "purchases" line from the statement summary, plus or minus any returns and credits. If the math doesn't match, you have an extraction error worth fixing before importing.
Don't Email Statements Unredacted
The full account number is usually masked, but the cardholder's name, address, and transaction history are still PII. If you need to send statements to a bookkeeper, accountant, or lender, use the Redact PDF tool to mask non-essential PII first.
Pull More Than 90 Days from Capital One via PDF
Capital One's CSV download is limited to 90 days. For year-end bookkeeping or audit support, the only way to get older transactions is via the PDF statement. Extracting from the PDF gets you 7+ years of history (the issuer's PDF retention window).
FAQ
Can I convert a credit card statement to QBO format directly?
Yes. The Bank Statement Converter exports to QBO (QuickBooks Online format) along with QFX, OFX, QIF, Excel, CSV, TSV, and JSON. The QBO format imports directly via QuickBooks' "Upload bank file" feature.
How does the converter handle Amex multi-currency transactions?
Each foreign transaction is exported as a single row with both the foreign amount and the USD-converted amount in separate columns, plus a column for the foreign transaction fee. The original currency code is preserved.
Does it work with statements from credit unions and store credit cards?
Yes. The same coordinate + AI extraction pipeline handles credit unions (Navy Federal, PenFed, etc.) and store cards (Target RedCard, Best Buy Visa, etc.). Layouts vary, but the AI generalizes - there's no per-issuer template to maintain.
What about merchant category codes (MCC)?
Most issuers don't print the raw MCC on statements - they print the issuer's own category label (e.g., "Restaurants" instead of MCC 5812). The export captures whatever the issuer prints. For mapping to MCC for tax purposes, you'd need a separate reference table.
Can I extract a year of statements at once?
Yes - upload 12 PDFs in a single session. Each is processed independently and exported as a separate sheet (or a single combined CSV with a statement-period column).
Does the converter handle scanned PDFs?
Yes. If the PDF doesn't have embedded text (scanned or photographed), AI vision extraction runs server-side. Accuracy is 88–95% on scans vs. 96–99% on digital PDFs.
How much does this cost compared to manual data entry?
A bookkeeper at $50/hr taking 30 minutes per statement pays $25 per statement to enter manually. AI extraction in PDFSub processes the same statement for a fraction of an AI credit. For 50 monthly statements across all clients, the time saved is 25 hours.
What's the difference between extracting bank statements and credit card statements?
Mechanically, they use the same tool - but credit card statements have additional fields (foreign fees, multi-card sections, rewards summaries) that the AI handles differently. The output for a credit card statement includes columns that don't appear on bank statements (Card Last 4, Foreign Amount, FX Fee).
Will the converter capture rewards points or cashback?
Yes - the rewards summary appears in the metadata export as a separate sheet. The transaction sheet stays focused on charges and credits. If you need to track rewards in your accounting, use the metadata sheet for monthly point earnings.
How do I split a single statement across personal and business expenses?
After export, sort the Excel by merchant or category and tag each row "Business" or "Personal" in a new column. For statements where the same merchant could be either (e.g., a hardware store used for both home and business projects), reference your receipts to make the call. The Receipt Scanner handles the matching side.
Are pending transactions included in the export?
Yes, but they're flagged in the "Section" column as Pending rather than Posted Transactions. Most accounting workflows filter to posted-only before importing, since pending charges can change before they clear.
Can I extract data from a business credit card statement with multiple employee cards?
Yes. Each authorized user's card has a sub-section with their name and card last-4. The export's "Cardholder" and "Card Last 4" columns let you split spending per employee for expense reports or per-employee budgets.
Beyond Credit Card Statements
Credit card extraction rarely exists alone. Most workflows pair it with:
- Bank statements - same tool, every major bank and 12+ international layouts (Bank Statement Converter)
- Receipts - match charges to receipts for documentation (Receipt Scanner)
- Invoices - for AP/AR workflows (Invoice Extractor)
- Tax forms - W-2, 1099, K-1, pay stubs (Extract Data tool)
One subscription covers the whole financial-document spectrum, with consistent extraction quality across documents.
Getting Started
If your workflow involves credit card statements - for bookkeeping, tax prep, expense reports, mortgage underwriting, or fraud review - manual entry is no longer the right choice. The 7-day free trial includes full access to the Bank Statement Converter and the rest of PDFSub's PDF tools.
Try PDFSub's Bank Statement Converter - upload an Amex, Chase, Capital One, Discover, or Citi statement and see the export in seconds.
For accountants and bookkeepers handling multiple client statements per month, the paid plans include batch processing and additional AI credits for high-volume extraction.