How to Convert a Discover Statement PDF to CSV

Discover gives you a built-in activity download for recent transactions and a PDF statement archive for anything older. Here is how to use both, and what to watch for when cashback rewards show up in your data.

Discover is one of the more conversion-friendly banks: the activity download covers a longer window than most (up to two years of history), and the statement PDFs are consistently formatted. The main complication is that Discover covers two distinct product lines - credit cards and Discover Bank deposit accounts - and the statement formats differ between them. Knowing which type you have saves a lot of guesswork when the CSV columns do not look like you expected.

Which Discover account type do you have?

Before starting, identify what you are working with:

• Discover credit card (Discover it, Discover it Cash Back, Discover it Chrome, etc.): these are credit accounts. Statements show purchases, payments, fees, and cashback credits. The statement balance represents what you owe.
• Discover Bank account (Discover Cashback Debit checking or Discover Online Savings): these are deposit accounts. Statements show deposits, withdrawals, and interest credits. The balance represents funds you hold.

Both product lines live at discover.com under the same login, but the statement format and column layout differ. The steps below apply to both; differences are noted where they matter.

Method 1: Download a CSV directly from Discover

For recent history, Discover's activity export is the fastest route and requires no conversion at all.

Steps to download the activity CSV

• Log into discover.com and navigate to the account you want to export.
• Click Statements and Activity in the account menu.
• Scroll down to the activity section and look for a Download Activity or Download Transactions link.
• Choose a date range and select CSV as the file format. Discover also offers OFX and QFX for use with accounting software directly.
• Download the file and open it in Excel, Google Sheets, or Numbers.

Discover's CSV download typically covers the past 24 months of activity - a longer window than many banks. If the data you need falls within that window, you are done. For anything older, move to the PDF method below.

Understanding the Discover CSV columns

Discover credit card CSV files include columns for Trans. Date, Post Date, Description, Amount, and Category. The Amount column uses negative numbers for purchases (charges) and positive numbers for credits (payments and cashback rewards). This is the opposite of what some spreadsheet formulas expect, so check your signs when summing expenses.

Discover Bank account CSV files typically include Date, Description, Amount, and Balance. The Amount column uses a signed format where deposits are positive and withdrawals are negative.

Method 2: Convert a Discover PDF statement to CSV

For periods outside the 24-month download window, Discover keeps official statement PDFs in the Statements section of online banking. These go back several years and are the reliable source for older data.

Step 1: Download the PDF statement from Discover

• Log into discover.com and go to Statements and Activity.
• Click Statements to see the list of available monthly PDFs.
• Select the statement period you need and click to download the PDF.
• Save it locally and repeat for any additional months you need to cover.

Step 2: Extract the transactions

Discover credit card PDF statements are formatted in a single-column layout with each transaction on its own line, showing the post date, transaction date, description, and amount. This is cleaner than many bank statement PDFs, but copy-pasting into a spreadsheet still breaks because the column structure relies on fixed character spacing that does not survive a paste.

Discover Bank checking and savings statement PDFs follow a slightly different layout, with a transaction table that includes date, description, debit or credit columns, and a running balance. The running balance column in particular causes problems when pasting directly because it looks like an additional transaction amount.

A dedicated PDF converter reads the Discover statement structure and produces a clean output: one row per transaction, with date, description, and a signed amount. No manual cleanup required.

Quill parses Discover statement PDFs locally on your computer. Drop in the file and it extracts every transaction and lets you export to CSV - no upload, no account connection, no subscription.

Step 3: Handle cashback rewards in the CSV

Discover credit card statements include Cashback Bonus credits as transaction rows. In the PDF and the exported CSV, these appear with descriptions like "Cashback Bonus Award" and a positive amount (since they are credits to your account). When you import this CSV into a spreadsheet or accounting tool, these rows need to be tagged differently from ordinary payment credits:

• For personal budgeting, you can record cashback credits as income or simply leave them to offset your statement balance.
• For business bookkeeping, tag them as "Other Income" or as a rebate that reduces your card expense. Do not treat them as a payment reversal, as that can distort your expense totals.

Step 4: Clean up and verify the CSV

Once you have the CSV, a few checks before importing anywhere:

• Transaction count. Compare the number of rows in your CSV against the statement's transaction summary to confirm nothing was missed or duplicated.
• Amount signs. Verify a few rows against the original PDF. Discover credit card CSV amounts use negative values for charges, which may need to be flipped depending on how your destination tool expects the data.
• Statement closing date vs transaction date. Discover statements close on a fixed date each month. Transactions that posted close to the closing date may appear in a different statement period than the purchase date. If you are reconciling by month, use the post date column rather than the transaction date.

Discover-specific quirks worth knowing

Interest charges and minimum payment details

Discover credit card statements begin with a summary section showing the previous balance, payments, purchases, fees, interest charged, and the new balance. This summary is for reference and does not repeat as individual transactions. The transaction detail section below it is what you want for your CSV.

Discover it Student and Discover it Secured cards

The statement format for Discover's student and secured credit cards is identical to the standard Discover it format. The PDF-to-CSV conversion works the same way, and the download options in online banking are also the same.

Discover Online Savings statements

Discover Online Savings accounts have fewer transaction types than checking accounts - primarily transfers in, transfers out, and interest credits. The statement PDFs are short and clean. One thing to watch: if you have an automatic transfer set up between Discover Bank and an external checking account, those transfers appear as single-line debit or credit entries without a counterpart transaction (since the other side lives at a different bank).

Which method to use

• Recent transactions (within the past 24 months): Use Discover's built-in CSV download. It is the fastest path and requires no conversion step.
• Older history: Download the PDF statement from Discover's Statements section and convert it locally.
• For QuickBooks or accounting software: Consider the OFX or QFX export option in Discover's download menu, which maps cleanly to accounting software formats without a manual CSV import step. See our companion guide on importing Discover statements into QuickBooks.