Discover it Cash Back, Miles, Chrome, Student and Secured cards
Convert a Discover card statement to Excel, CSV or QuickBooks
Discover cards are moving to Capital One in waves. Convert your Discover statements to get any cycle into Excel, CSV or QuickBooks, checked against the Account Summary, whichever side of the move it is on.
- Account Summary used as the proof, Cashback Bonus box ignored
- Three-line descriptions joined into one row
- Merchant Category kept with each purchase
- Statements from before and after the Capital One move
7 years
of statement history at Capital One
Once your Discover account has moved
In waves
Discover cards moving to Capital One
From July 2026 into early 2027
MM/DD
dates on each row
Year from the Account Summary period
Merchant Category
printed beside each purchase
Discover’s own category
The short answer
Can you export a Discover statement to Excel?
You can download recent activity, but the statement itself is a PDF, and where you download it from depends on whether your account has moved to Capital One. Capital One completed its purchase of Discover in May 2025 and started moving Discover card accounts to the Capital One website and app in July 2026, in waves through early 2027. Capital One says it will tell you when your account is ready; until then, you keep using Discover.com and the Discover app.
After the move, Capital One says you will no longer be able to view or manage that account on Discover.com, and that you will be able to view the last 7 years of your credit card statement history on the Capital One website. It also says your Capital One statement will look very similar to your Discover statement. So the PDFs stay available, but the site, the download menus and any app connections change.
Converting the PDF statement gives you Excel, CSV, QBO or QFX for any cycle, Discover-era or Capital One-era. A card statement has no running balance, so each converted cycle is checked against the Account Summary instead: previous balance, minus payments and credits, plus purchases, balance transfers, cash advances, fees and interest, must equal the new balance.
Two boxes say “Previous Balance”, and descriptions run to three lines
Sample statement
What a Discover statement looks like
Hover or tap a number to see what each part means for a conversion.
DISCOVER
Discover it Cash Back · Account ending 2290
Account Summary 03/07/2026 – 04/06/2026
Payment Due Date 05/03/2026
Account Summary
- Previous Balance
- $642.10
- Payments and Credits
- -$692.10
- Purchases
- +$1,031.56
- Balance Transfers
- +$0.00
- Cash Advances
- +$0.00
- Fees Charged
- +$0.00
- Interest Charged
- +$0.00
- New Balance
- $981.56
Payments and Credits
| Trans. Date | Payments and Credits | Amount |
|---|---|---|
| 03/18 | INTERNET PAYMENT - THANK YOU | -$642.10 |
| 03/18 | CASHBACK BONUS REDEMPTION PYMT/STMT CRDT | -$50.00 |
Purchases
| Trans. Date | Purchases | Merchant Category | Amount |
|---|---|---|---|
| 03/09 | TRADER JOE S #552 PHOENIX AZ | Supermarkets | $74.18 |
| 03/14 | CHEVRON 0384221 SCOTTSDALE AZ | Gasoline | $52.40 |
| 03/21 | AMAZON MKTPLACE PMTS AMZN.COM/BILLWA | Merchandise | $318.75 |
| 4K8T2WQXJ | |||
| 03/29 | HYATT REGENCY SCOTTSDALE AZ | Travel/ Entertainment | $547.83 |
| 04/02 | CHIPOTLE 1183 TEMPE AZ | Restaurants | $38.40 |
Fees and Interest Charged
| Amount | |
|---|---|
| TOTAL FEES FOR THIS PERIOD | $0.00 |
| TOTAL INTEREST FOR THIS PERIOD | $0.00 |
| TOTAL FEES CHARGED IN 2026 | $0.00 |
| TOTAL INTEREST CHARGED IN 2026 | $0.00 |
Native export
What you can export from a Discover card
Where you get the files depends on the move. Converting the statement works the same on both sides.
Activity download on Discover.com (until your account moves)
Not published
Recent card activity for the dates you choose. Quicken users reported in 2022 that the options were PDF, Excel and CSV, with QFX removed.
Where it stops: No statement totals, the range is not published, and the account disappears from Discover.com once it moves.
Statements at Capital One (after the move)
Last 7 years
Capital One shows the last 7 years of statement history and says its statements look very similar to Discover’s.
Where it stops: A PDF only, and paperless has to be set up again within 120 days or statements go back to paper.
Converting the statement with VouchRow
Any statement you have
The PDF becomes rows in the format your software takes, checked against the Account Summary, with every row linked to its line.
Where it stops: Needs the statement PDF. A cycle you never saved has to come from Discover.com or Capital One first.
How far back
How far back each Discover option reaches
The answer depends on whether your account has moved to Capital One yet.
Statements at Capital One (after the move)
Last 7 years
Capital One’s Discover FAQ: you can view the last 7 years of your credit card statement history on the Capital One website.
Statements and downloads on Discover.com (before the move)
Not published
Discover does not publish its archive or download range on a public page. Check what your account lists.
Discover.com access after the move
Ends at the move
Capital One says a moved account can no longer be viewed or managed on Discover.com or in the Discover app.
A dashed bar means the bank does not publish a figure; check your own online banking.
Step by step
How to convert a Discover card statement
- 1Save the statements from wherever your account isIf your card has not moved yet, sign in at Discover.com and save the statements you need. If it has moved, sign in at capitalone.com, where Capital One shows the last 7 years of statement history.
- 2Save before your move date if you canCapital One says some Discover features are limited for a period before an account moves. Saving the PDFs you need beforehand avoids a gap while you set up Capital One access.
- 3Upload and convertSign in to VouchRow and add the PDFs, one card account per batch. Digital statements convert in batches. A scanned paper statement is read with OCR, one at a time. A password-protected PDF is unlocked in your browser; the password is never sent.
- 4Check each cycle against the Account SummaryThe rows must add back to the new balance. If they do, the cycle shows as balanced. If not, VouchRow shows the difference in dollars, and clicking any row shows its line on the PDF.
- 5ExportExcel or CSV to review, QBO for a QuickBooks credit card account, QFX for Quicken, or the Xero CSV preset.
Formats
Where is your Discover data going?
Pick the destination. The advice changes with it.
Discover statement to Excel
An .xlsx with one row per transaction: date, the joined description, Discover’s Merchant Category and one signed amount. The export is written from your side of the card: purchases, fees and interest negative, payments and credits positive, the reverse of how the statement prints them.
Convert a year of statements in one batch, including months from before and after the move to Capital One. Sorted by date, the cycles run end to end.
PDF to ExcelDiscover statement to CSV
CSV is for when another tool reads the file: a budgeting app, a script or an import screen. The Merchant Category comes along as its own column, which many budgeting tools can map.
Choose the date format the importer expects before you export; an importer set for DD/MM will misplace MM/DD dates.
PDF to CSVDiscover statement to QuickBooks
Export QBO and import it into the credit card account in QuickBooks (in QuickBooks Online, upload from file under bank transactions; in Desktop, as a Web Connect file). If the account’s connection broke at the move to Capital One, converted statements fill the gap.
Each row carries a transaction ID, so a converted cycle that overlaps what a feed already brought in is recognised rather than duplicated. Charges arrive as charges and payments as credits to the card.
PDF to QBODiscover statement to Quicken
QFX is Quicken’s Web Connect format. Import the converted file into the existing Discover card account so older cycles join the history you already have, rather than starting a new account.
QIF also imports, but it has no transaction IDs, so a cycle imported twice will duplicate. Prefer QFX.
PDF to QFXDiscover statement to Xero
Use the Xero CSV preset: one signed amount column and the date format Xero expects. Import it into the credit card account in Xero, then reconcile as usual.
Purchases come out negative and payments and credits positive, which is how Xero expects statement lines on a credit card account.
Statements into XeroStatement layout
How a Discover statement is laid out
The facts to check against the statement in front of you. Accounts covered: Discover it Cash Back, Discover it Miles and Chrome, Discover it Student and Secured, Discover cards after the move to Capital One.
| Date format | MM/DD on each row (Trans. Date); the year comes from the Account Summary period, printed MM/DD/YYYY |
|---|---|
| Running balance | None. Each cycle is proved against the Account Summary |
| Amount column | One Amount column: payments and credits printed with a minus sign, purchases without one |
| Purchases | A Merchant Category column (Merchandise, Restaurants and so on) beside each purchase, and descriptions that wrap onto two or three lines |
| Rewards box | A Cashback Bonus Rewards box with its own Previous Balance, earned and redeemed lines |
Why it works
Built around how Discover prints a card statement
The right Previous Balance
The Account Summary is the proof. The Cashback Bonus Rewards box, with its own Previous Balance and earned and redeemed lines, is kept out of both the rows and the check.
Wrapped descriptions joined
Merchant, parent company and reference code print on separate lines. They come out as one description on one row, with one amount.
Merchant Category kept
Discover’s own category for each purchase (Merchandise, Restaurants, Supermarkets and so on) stays with the row, ready to use when you label spending by hand.
Cashback Bonus redemptions labelled
A Cashback Bonus applied as a statement credit is a credit to the card, not a payment from your bank. It keeps its own description so it can be booked as rewards.
Every row traced to its line
Click a row and the PDF opens at the line it came from, useful when the description you see joins three printed lines.
Both sides of the move
Statements saved from Discover.com and statements downloaded from Capital One convert the same way, so a year that spans the move is one continuous set of checked cycles.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
Layout
How a Discover card statement is laid out
The Account Summary carries the cycle dates in its heading (for example 09/07/2024 – 10/06/2024) and the lines Previous Balance, Payments and Credits, Purchases, Balance Transfers, Cash Advances, Fees Charged and Interest Charged, each with a plus or minus sign, then New Balance, Credit Line, Credit Line Available and the cash advance lines. Payment information, the minimum payment warning, the Cashback Bonus Rewards box and a FICO score panel sit around it. None of these are transactions.
The Transactions section has two groups. Payments and Credits lists the date (Trans. Date), the description and the Amount, with a minus sign. Purchases adds a Merchant Category column between the description and the Amount. Descriptions often take two or three printed lines for one purchase.
Fees and Interest Charged follows, with “TOTAL FEES FOR THIS PERIOD”, “TOTAL INTEREST FOR THIS PERIOD” and a year-to-date block (total fees and total interest charged in the year). The Interest Charge Calculation table closes the statement. All of these are summaries used as checks, not rows.
Capital One
Discover statements after the move to Capital One
Capital One is moving Discover card accounts in waves, and cardholders with more than one Discover account may see them move on different dates. When yours moves, you sign in at capitalone.com or in the Capital One app; Discover.com and the Discover app stop showing that account. Capital One says you can view the last 7 years of statement history there.
Paperless statements do not carry over on their own: Capital One says you need to set up online access and accept its paperless terms within 120 days, or the account goes back to paper statements. Third-party app connections also have to be re-established after the move, which is why Discover data can stop arriving in a budgeting or bookkeeping app around the move date.
Authorised users and joint account holders get new cards with their own numbers after the move, and Capital One says all of their transactions still appear on the primary cardholder’s statement. Converted statements keep each row as printed, so the card that made a purchase can still be traced from the description and the source line.
Downloads
Downloading Discover activity yourself
Before the move, Discover.com offers an activity download for the card. Discover does not publish the formats or how far back it reaches on a public page, and Quicken users reported in 2022 that the Quicken (QFX) option had gone, leaving PDF, Excel and CSV. After the move, downloads come from Capital One’s site instead, so check what it offers for your card.
Either way, a download covers the dates you pick, not a billing cycle, and has no Account Summary to prove it against. For a tax year, a dispute or a QuickBooks catch-up, the statements are the complete record, and converting them gives the same rows with the cycle checked.
Rewards
Cashback Bonus and Miles on the statement
The Cashback Bonus Rewards box shows Previous Balance, amounts earned this period (by rate, such as 1% and 5%), amounts redeemed and the Cashback Bonus Balance. It is a rewards ledger, not the card balance, and is left out of the rows.
When you redeem rewards as a statement credit, the redemption appears in Payments and Credits, for example “CASHBACK BONUS REDEMPTION PYMT/STMT CRDT”, with a minus sign like a payment. It is kept as its own credit row so a bookkeeper can record it as rewards income or a reduction in expense, not as money paid from a bank account.
Troubleshooting
Common Discover conversion problems
Most Discover errors come from the two summaries, the wrapped lines and the move.
- The cycle check is off by a small odd amount: it was run against the Cashback Bonus box, which also has a Previous Balance. The Account Summary is the proof.
- One purchase became three rows: the parent company and reference lines were read as transactions. They belong to the purchase above.
- A Merchant Category like “Restaurants” ended up in the description or the amount: it is its own column.
- Cashback redemption booked as a bank payment: it is a statement credit from rewards. Keep its description.
- Discover.com no longer shows the account: it has moved to Capital One. Sign in at capitalone.com, where the last 7 years of statements are listed.
- An app stopped importing Discover transactions: connections have to be re-established after the move. Converted statements fill the gap.
Side by side
Downloading Discover activity vs converting the statement
| Activity download (Discover.com or Capital One) | Converting the PDF statement | |
|---|---|---|
| How far back | Not published | Up to 7 years of statements at Capital One, plus any you saved |
| Formats | Check the site your account is on | Excel, CSV, QBO, QFX, OFX, QIF, IIF, Tally XML |
| Matches the billing cycle | Only if you pick the exact dates | Always: one statement, one cycle |
| Checked against the statement | No | Against the Account Summary of each cycle |
| Across the move to Capital One | Two sites, two sign-ins | One set of PDFs, converted the same way |
| Proof for a reviewer | A list of rows | Every row linked to its line on the PDF |
Before you import
After converting a Discover statement, check these
- The cycle balancesPrevious balance plus the rows equals the New Balance on the Account Summary, not the Cashback Bonus balance.
- One row per purchaseNo rows that are only a parent company name or a reference code with no amount.
- Payments are creditsYour payment and any Cashback Bonus statement credit are positive in the export, not charges.
- Rewards credits labelledCashback Bonus redemptions keep their description so they are not booked as payments from a bank account.
- Dates in the right yearOn a cycle that crosses New Year, December rows are in the old year and January rows in the new one.
- No gap at the moveThe last Discover.com statement and the first Capital One statement meet: one’s new balance is the next one’s previous balance.
Downloaded activity and statements are not the same thing
QBO for Discover
Who uses it
Who converts Discover statements
A tax year that spans the move
Months from Discover.com and months from Capital One converted into one consistent set of checked cycles.
Bookkeeping after a broken connection
A QuickBooks or budgeting connection that stopped at the move date, with the missing cycles filled from converted statements.
Household budgets by category
Discover’s Merchant Category kept with each purchase, as a starting point for labelling a year of spending.
Disputes, divorce and audit files
Older cycles, each row traceable to its line on the statement Discover issued, with rewards credits kept separate from payments.
FAQ
Discover statements: questions
How do I export a Discover statement to Excel?
Download the statement PDF from Discover.com, or from capitalone.com if your account has moved, and convert it here to Excel. The rows are checked against the Account Summary. For recent activity only, the site’s download may be enough.
How do I get my Discover statement now that Discover is part of Capital One?
If your account has not moved yet, use Discover.com or the Discover app. Once it has moved, sign in at capitalone.com or in the Capital One app. Capital One says you can view the last 7 years of your statement history there.
Why is my Discover statement not showing up on Discover.com?
Most likely your account has moved to Capital One. Capital One says that once an account is ready there, you can no longer view or manage it on Discover.com or in the Discover app.
Can I download Discover transactions to Quicken or QuickBooks?
Discover does not publish its download formats, and Quicken users reported in 2022 that the QFX option had been removed. For a dependable file, convert the statement PDFs to QFX for Quicken or QBO for QuickBooks and import them into the card account.
What does a Discover credit card statement look like?
An Account Summary with the cycle dates, a Cashback Bonus Rewards box, then Transactions in two groups (Payments and Credits, and Purchases with a Merchant Category column), then Fees and Interest Charged with period and year-to-date totals, and the Interest Charge Calculation.
How far back can I get old Discover statements?
After your account moves, Capital One shows the last 7 years of statement history. Discover does not publish a figure for Discover.com, so check what your account lists before it moves.
Does a Discover statement have a running balance?
No. Converted rows are checked against the Account Summary instead: previous balance, minus payments and credits, plus purchases, balance transfers, cash advances, fees and interest, must equal the new balance.
My Discover statement PDF has a password. Can I still convert it?
Yes. Enter the password when you upload. The PDF is unlocked in your browser and the password is never sent to us.
Keep going
Related guides and converters
Formats for Discover cards
Other card pages
Sources
The facts about Discover on this page come from these pages, checked in October 2026. Banks change their online banking; if something here no longer matches, the bank’s own help page wins. Tell us and we will update it.
- Capital One: Discover card FAQs, 7 years of statement history, paperless and third-party apps (capitalone.com)
- Discover: Discover is part of Capital One, integration FAQ (discover.com)
- Discover: How to read a credit card statement, sample statement (discover.com)
- The Points Guy: Discover cards begin move to Capital One, timing from Capital One (July 2026)
- Quicken Community: Discover Card no longer has .QFX download (user reports, 2022)
Convert your Discover statements
Upload the PDFs, check every cycle against its Account Summary, and export Excel, CSV, QBO or QFX.