How to Convert Discover and American Express Credit Card Statements to Excel

Discover Card and American Express are among the most popular credit cards in the United States, with Discover offering cashback rewards and Amex known for premium travel rewards and business expense management. While both issuers provide online transaction downloads, the formats and limitations vary significantly—and for historical statements or detailed expense analysis, converting PDF statements to Excel is often the best solution.

This comprehensive guide covers everything you need to know about converting Discover and American Express credit card statements to Excel, including cashback tracking, Membership Rewards points, expense categorization, foreign transaction handling, and business card reconciliation.

---

Discover Card: Direct Downloads vs. PDF Conversion

What Discover Offers

Discover Card provides multiple download formats through their online banking platform:

✅ CSV format - Available for recent transactions ✅ Excel format - Direct .XLS download option ✅ PDF statements - Full monthly statements ✅ QuickBooks Web Connect - For QuickBooks users

Sounds great, right? But there are limitations:

Limitations of Discover's Direct Downloads

1. CSV/Excel Downloads:

• Only recent transactions (typically 90-180 days)
• Missing statement metadata (closing balance, payment due date, minimum payment)
• No rewards summary (cashback earned, redeemed, pending)
• Basic transaction data only (date, merchant, amount)

2. QuickBooks Format:

• Requires QuickBooks Desktop or QuickBooks Online
• Not compatible with Xero, FreshBooks, Wave, or other accounting software
• Limited to current statement period

3. PDF Statements:

• Complete monthly statement with all details
• Cashback rewards summary included
• Payment history and interest charges
• Cannot be edited or analyzed without conversion

Bottom Line: For comprehensive expense analysis, tax preparation, or when you need historical data beyond 90 days, converting PDF statements is essential.

---

American Express: QFX, QBO, and PDF Options

What American Express Offers

American Express provides more download options than most issuers:

✅ QFX format - For Quicken ✅ QBO format - For QuickBooks ✅ OFX format - Open Financial Exchange standard ✅ CSV format - Comma-separated values ✅ PDF statements - Full monthly statements

However, limitations exist here too:

Limitations of Amex's Direct Downloads

1. QFX/QBO Formats:

• Specific to Quicken or QuickBooks only
• Not compatible with Excel, Google Sheets, or other tools
• Limited date ranges (current statement or last 12 months)

2. CSV Format:

• Basic transaction data only
• No Membership Rewards points detail (points earned per transaction missing)
• Missing spend by category summaries
• No year-end statement data

3. PDF Statements:

• Complete monthly statements with detailed summaries
• Membership Rewards breakdown by transaction
• Spend by category charts
• Annual fee, interest charges, and payment history
• Locked format requiring conversion for analysis

Bottom Line: Amex PDF statements contain far more valuable data than CSV downloads. For expense reports, business reconciliation, or rewards optimization, PDF conversion is superior.

---

How to Download Discover Card Statement PDFs

Step 1: Log Into Discover Online Account

1. Go to discover.com and click "Log In"
2. Enter your User ID and Password
3. Complete multi-factor authentication (SMS code or security questions)

Step 2: Navigate to Statements

1. From the account dashboard, click "Statements"
2. Select the statement period you need
3. Click "View PDF" or "Download PDF"

Discover Card Types Supported:

• Discover it® Cash Back (5% rotating categories + 1% on everything)
• Discover it® Miles (1.5x miles on all purchases)
• Discover it® Chrome (2% gas and restaurants, 1% everything else)
• Discover it® Student (cashback for students)
• Discover it® Secured (secured card for credit building)

---

How to Download American Express Statement PDFs

Step 1: Log Into American Express Account

1. Go to americanexpress.com and click "Log In"
2. Enter your User ID and Password
3. Complete authentication

Step 2: Navigate to Statements & Activity

1. From the dashboard, select "Statements & Activity"
2. Click "Statements"
3. Choose your statement period
4. Click "Download PDF"

American Express Cards Supported:

• Amex Platinum (5x travel, premium perks)
• Amex Gold (4x dining and supermarkets, 3x flights)
• Amex Green (3x travel and dining)
• Amex Blue Cash Preferred (6% groceries, 6% streaming, 3% gas)
• Amex EveryDay (2x groceries, 1x everything else)
• Amex Business Platinum, Gold, Green (business expense management)
• Amex Delta SkyMiles, Hilton Honors, Marriott Bonvoy (co-branded rewards cards)

---

Converting Credit Card PDF Statements to Excel

Step 1: Upload to Data River

1. Go to Data River
2. Click "Upload Statement" or drag and drop your PDF
3. Wait 20-30 seconds for AI-powered processing

Step 2: Download Your Excel File

1. Click "Download CSV"
2. Open in Excel, Google Sheets, or import to QuickBooks

Output Format (Discover Example):

Output Format (American Express Example):

---

Credit Card Statement Format Quirks

Credit card statements differ significantly from bank account statements. Here's what makes them unique:

1. Transaction Date vs. Posted Date

Credit cards show two dates for each transaction:

Transaction Date: 01/15/26
Posted Date:      01/17/26
Description:      AMAZON.COM
Amount:           $47.99

Transaction Date = When you made the purchase Posted Date = When it cleared and hit your account

Why it matters: For expense reports and tax deductions, you typically use the Transaction Date. For reconciliation with your statement closing date, you use the Posted Date.

Data River Solution: Extracts both dates, defaulting to Transaction Date in the Date column and preserving Posted Date in the description when different.

2. Rewards Earnings Per Transaction

Discover and Amex show rewards earned for each transaction:

Discover:

01/15/26    GAS STATION     $45.00    5% Cashback: $2.25

American Express:

01/15/26    DELTA AIRLINES  $450.00   Points Earned: 2,250

Problem: Generic converters either:

• Treat rewards as a separate transaction (doubling your spending)
• Skip rewards entirely (losing critical tracking data)

Data River Solution: Includes a Rewards column (Cashback or Points) separate from the Amount, allowing you to:

• Track total rewards earned in Excel pivot tables
• Calculate effective discount (cashback ÷ spending)
• Identify which categories maximize rewards

3. Foreign Transaction Fees

International purchases include:

• Original foreign currency amount
• Exchange rate used
• Foreign transaction fee (typically 0% for Discover, 0-3% for Amex)

Example:

01/20/26    RESTAURANT PARIS     EUR 65.00
            Exchange Rate:       1 EUR = 1.08 USD
            Amount in USD:       $70.20
            Foreign Trans Fee:   $2.11 (3%)
            Total Charged:       $72.31

Problem: Generic tools create 3-5 separate transactions from this single purchase.

Data River Solution:

• Extracts the total USD amount charged ($72.31) as the transaction
• Preserves foreign currency (EUR 65.00) in description
• Separates foreign transaction fee as distinct line item for expense tracking

4. Authorized User Transactions

Family members or employees with authorized user cards generate transactions tagged with their name:

01/15/26    GROCERY STORE    $87.43    Card Member: JANE SMITH

Data River Solution: Preserves authorized user name in description for tracking who made each purchase.

5. Pending Transactions

Credit card PDF statements only include posted transactions. Pending charges (authorized but not yet cleared) don't appear.

Note: If you need current pending activity, use the card issuer's online transaction export. PDF statements are for closed statement periods only.

---

Discover Card: Tracking Cashback Rewards in Excel

Discover's rotating 5% categories make reward tracking essential. Here's how to maximize your analysis:

Quarterly 5% Categories

Discover rotates bonus categories:

• Q1 (Jan-Mar): Groceries, Drugstores
• Q2 (Apr-Jun): Gas Stations, Wholesale Clubs
• Q3 (Jul-Sep): Restaurants, PayPal
• Q4 (Oct-Dec): Amazon, Target, Walmart

Problem: You need to track which purchases earned 5%, which earned 1%, and if you've hit the $1,500 quarterly cap.

Excel Analysis Setup

After converting your Discover statement:

1. Add Category Column (if not auto-categorized):

   • Gas, Groceries, Restaurants, Shopping, etc.

2. Calculate Cashback Per Transaction:

=IF(Category="Gas", Amount*0.05, Amount*0.01)

3. Track Quarterly Cap:

=SUMIF(Category,"Gas",Cashback)

(Shows how much 5% cashback you've earned in gas category; cap is $75 per quarter = $1,500 spend)

4. Annual Cashback Summary:

=SUM(Cashback_Column)

Discover Cashback Match

For first-year cardholders, Discover matches all cashback earned. Track this in Excel:

=Total_Cashback * 2

---

American Express: Tracking Membership Rewards Points

Amex Membership Rewards are more complex than Discover cashback due to varying earn rates:

Amex Gold Example Earn Rates

• 4x points on US restaurants (up to $50k/year)
• 4x points on US supermarkets (up to $25k/year)
• 3x points on flights booked directly with airlines
• 1x points on everything else

Excel Analysis Setup

After converting your Amex statement:

1. Categorize Spending:

=IF(Merchant contains "RESTAURANT", "Dining",
    IF(Merchant contains "GROCERY", "Groceries",
    IF(Merchant contains "AIRLINES", "Travel", "Other")))

2. Calculate Points Earned:

=IF(Category="Dining", Amount*4,
    IF(Category="Groceries", Amount*4,
    IF(Category="Travel", Amount*3, Amount*1)))

3. Track Annual Spend Caps:

• Dining: $50,000/year cap on 4x (200,000 points)
• Groceries: $25,000/year cap on 4x (100,000 points)

=SUMIF(Category,"Dining",Amount)  // Should stay under $50,000

4. Points Redemption Value:

Membership Rewards transfer 1:1 to airline/hotel partners, but redemption value varies:

• Transfer to Delta, Virgin Atlantic: ~1.5¢ per point
• Transfer to Hilton, Marriott: ~0.7¢ per point
• Pay with Points (Amazon): ~0.7¢ per point
• Statement credit: 0.6¢ per point

Excel Calculation:

=Points_Earned * 0.015  // Assumes 1.5¢/point transfer value

---

Business Credit Cards: Expense Categorization for Tax Deductions

American Express Business Platinum, Gold, and Green cards require detailed expense tracking for tax purposes.

IRS Expense Categories

Common business expense categories:

• Travel (airfare, hotels, rental cars)
• Meals & Entertainment (50% deductible for business meals)
• Office Supplies
• Advertising & Marketing
• Professional Services
• Utilities (phone, internet)

Excel Setup for Business Cards

After converting your Amex Business statement:

1. Add IRS Category Column:

Date,Merchant,Amount,IRS_Category
01/15/26,DELTA AIRLINES,450.00,Travel
01/16/26,STAPLES,87.43,Office Supplies
01/17/26,RESTAURANT,125.00,Meals (50%)

2. Calculate Deductible Amount:

=IF(IRS_Category="Meals (50%)", Amount*0.5, Amount)

3. Quarterly Tax Summary:

=SUMIF(IRS_Category,"Travel",Deductible_Amount)

4. Export to QuickBooks:

Import your categorized CSV to QuickBooks with IRS categories mapped to Chart of Accounts.

---

Annual Fee, Interest Charges, and Statement Credits

Credit card statements include more than just purchases:

Fees and Credits to Track

Annual Fee:

01/01/26    ANNUAL MEMBERSHIP FEE    $695.00    (Amex Platinum)

Interest Charges:

01/31/26    INTEREST CHARGE ON PURCHASES    $45.23

Statement Credits:

01/15/26    AIRLINE FEE CREDIT    -$200.00    (Amex Platinum perk)
01/20/26    UBER CASH CREDIT      -$15.00     (Amex Gold perk)

Data River Handling:

• Annual Fee = separate transaction for expense tracking
• Interest = separate transaction (non-deductible for personal cards, may be deductible for business)
• Credits = negative amounts, preserving credit description (e.g., "AIRLINE FEE CREDIT")

---

Converting Multiple Months for Year-End Tax Prep

For annual expense reports or tax preparation:

Process:

1. Download all 12 monthly PDFs (January-December)
2. Name consistently: Discover_2024-01.pdf, Discover_2024-02.pdf, etc.
3. Convert each PDF individually using Data River
4. Combine CSVs in Excel:

// Create master workbook, import each month
='Jan'!A2:E50
='Feb'!A2:E50
='Mar'!A2:E50
...
='Dec'!A2:E50

5. Add Month Column:

6. Create Annual Summary:

// Pivot Table: Total Spend by Category
=SUMIF(Category,"Travel",Amount)

// Pivot Table: Total Rewards Earned
=SUM(Cashback_Column)  // Discover
=SUM(Points_Column)    // Amex

---

Discover vs. Amex: Key Differences

For Personal Use: Discover is simpler to track (cashback in dollars) For Business Use: Amex offers better expense categorization and integrations For International Travel: Amex Platinum/Gold (no foreign fees) vs. Discover (no foreign fees but limited acceptance)

---

Security: How Data River Protects Your Credit Card Statements

Credit card statements contain sensitive purchase data. Here's how Data River protects your information:

What We Don't Do

• Never send files to third-party APIs (OpenAI, Google Vision, etc.)
• Don't store statements after conversion - Files deleted immediately
• Don't use your data for training - Your purchase history remains private
• Don't require card numbers or credentials - You upload PDFs directly

What We Do

• Process locally with CPU-only OCR (no cloud AI services)
• Encrypt in transit - HTTPS for all uploads/downloads
• Auto-delete files - Purged after conversion completes
• PCI DSS aligned - Same security standards as credit card processors

---

Frequently Asked Questions

Can I convert Discover statements even though Discover offers CSV downloads?

Yes. Discover's CSV downloads are limited to recent transactions (90-180 days) and exclude statement metadata, rewards summaries, and closing balances. Converting PDF statements gives you complete historical data and reward tracking.

Why convert American Express statements if Amex offers QBO/QFX?

Amex's QBO/QFX formats are specific to QuickBooks and Quicken. If you use Excel, Google Sheets, Xero, FreshBooks, or Wave, you need CSV format. Plus, PDF statements include Membership Rewards breakdowns and spend-by-category summaries that QBO files lack.

Does the converter track cashback/rewards separately?

Yes. Data River extracts Discover cashback amounts and American Express Membership Rewards points into separate columns, allowing you to track earnings in Excel pivot tables.

Can I convert business credit card statements for tax deductions?

Absolutely. Data River supports Amex Business Platinum, Gold, and Green cards, extracting all transactions for IRS expense categorization. The CSV output can be imported to QuickBooks with proper Chart of Accounts mapping.

What about foreign transactions with multiple currencies?

Data River extracts the USD amount charged to your card and preserves the original foreign currency amount in the description. Foreign transaction fees are captured as separate line items for expense tracking.

How far back can I convert credit card statements?

You can convert any PDF statement you've downloaded, regardless of age. Discover and Amex typically provide 7 years of statements online. For older records, contact customer service.

Does this work for co-branded cards (Delta Amex, Hilton Amex)?

Yes. Data River supports all American Express cards including Delta SkyMiles, Hilton Honors, Marriott Bonvoy, and other co-branded cards. Points earned are extracted into the rewards column.

---

Summary

While Discover Card and American Express offer direct downloads in various formats (CSV, Excel, QFX, QBO), these exports often lack critical data—rewards summaries, statement metadata, and complete historical records. Converting PDF statements to Excel provides comprehensive expense analysis, cashback/points tracking, and tax-ready categorization that standard downloads can't match.

Whether you're tracking Discover's rotating 5% cashback categories, optimizing American Express Membership Rewards transfers, preparing business expense reports for tax deductions, or reconciling authorized user spending, automated PDF conversion delivers clean, analyzable data ready for Excel pivot tables, QuickBooks import, or Xero reconciliation.

Ready to convert your Discover or American Express credit card statements? Try Data River for free →