How to Convert Discover Statements to CSV or Excel

Why Convert Discover Statements?

Discover Financial Services is best known for its Discover it credit card with rotating 5% cashback categories, but also offers online banking products including savings accounts and checking through Discover Bank. With over 50 million cardholders, Discover generates a massive volume of monthly statements. Discover credit card statements have a distinctive layout that groups transactions by category and includes detailed cashback reward tracking. For users who need their Discover transaction data in a spreadsheet for expense tracking, tax deductions, or accounting, BankRead extracts everything cleanly from the PDF.

Understanding the Discover Statement Format

Discover credit card statements use a portrait PDF beginning with an account summary showing previous balance, payments, purchases, cash advances, fees, interest, and new balance. The detailed transaction section follows, listing each transaction with Trans Date, Post Date, Description, and Amount. Transactions are grouped into sections: Payments and Credits, then Purchases. Discover Bank checking and savings statements use a simpler layout with Date, Description, Amount, and Balance in a standard table.

How to Convert with BankRead

Follow these steps to convert your Discover PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Discover online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your Discover Statement PDF

1. Log in to your Discover account at discover.com with your user ID and password.
2. Click on 'Statements' in the top navigation under your account.
3. Select the billing period from the list of available statements.
4. Click 'View Statement' to open the PDF viewer.
5. Click the download icon to save the PDF statement to your computer.

What Data Gets Extracted

BankRead extracts the following fields from your Discover statement:

• Transaction date (the date you made the purchase)
• Post date (the date it posted to your Discover account)
• Description / merchant (e.g., 'WHOLEFDS MKT 10234 CHICAGO IL')
• Purchase amount (charges, fees, cash advances)
• Payment/credit amount (payments, returns, statement credits)
• AI-assigned category (e.g., Groceries, Gas, Restaurants, Entertainment)

Export Options

Once your Discover statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for Discover Statements

• Discover statements separate Payments/Credits and Purchases into distinct sections — BankRead combines them into one chronological list.
• The cashback reward summary section is informational and not extracted as transactions.
• Discover's promotional rate and balance transfer sections are skipped — only actual transactions are extracted.
• Discover Bank (savings/checking) statements have a different, simpler layout than credit card statements — both are supported.
• Discover statements with many transactions may span 6+ pages — all are processed in a single upload.

Common Issues and Solutions

• Discover credit card statements show both Trans Date and Post Date. BankRead uses the Trans Date as the primary date, since it reflects when the purchase was actually made.
• Discover cashback bonus categories change quarterly. BankRead's AI categorization is independent of Discover's category system and assigns categories based on the merchant description.
• Some Discover statements include a mid-cycle payment reminder insert. This is not a transaction page and is skipped during extraction.

Frequently Asked Questions