Avyth Moneyby Avyth

Guides by bank

How to convert a Discover card statement to QuickBooks, Excel or CSV

Discover is now part of Capital One, and Discover card accounts are moving to Capital One's website and app during 2026 and early 2027. This page covers getting a statement or transaction file from Discover, turning it into a clean CSV, Excel, QuickBooks (.qbo) or OFX file with Statement Converter, and importing it into QuickBooks Online or QuickBooks Desktop.

Statement Converter runs in your browser. Your statement is read on your own computer and is never uploaded. This guide covers Discover credit cards.

Step 1: Download your statement from Discover

Where you download depends on whether your account has moved. Capital One says: "Discover card accounts will move to Capital One throughout 2026 and early 2027. We'll send you information directly when it's time to get ready to manage your account with Capital One." Until then, "you can continue to manage your Discover card using Discover.com or the Discover app." After the move: "When your account is ready with Capital One, you'll no longer be able to view or manage that account on Discover.com or in the Discover app." You keep your Discover card: "Once we set up your credit card account with Capital One, you'll manage it using the Capital One website and app."

Sources: Capital One — Discover card FAQs · Discover — Contact us

Still on Discover.com. Steps vary; check your bank's help. Discover's card help center needs you to sign in, so we couldn't check how to download statements or transactions, which formats are offered or how far back they go. If Discover offers a CSV download, choose it; otherwise save the monthly statement as a PDF. Statement Converter reads CSV and PDF only, not QFX, OFX or QIF.

Moved to Capital One. You download from capitalone.com. Our Capital One guide quotes Capital One's own statement steps.

Step 2: Convert it with Statement Converter

  1. Open statements.avyth.com/convert and click Choose CSV or PDF statements. Pick your Discover CSV or PDF file. The free version converts one statement at a time; the paid version takes several at once.
  2. Check the preview. The page tells you how each file was read. Card files record charges and payments differently from bank accounts, so if money coming in shows as money going out, click Flip signs for that file.
  3. Under Download as, pick CSV, Excel (.xlsx), QuickBooks (.qbo) or OFX.
  4. If you picked QuickBooks (.qbo), answer Where should QuickBooks put it?
    • New account in QuickBooks: Under This is a:, choose credit card statement. Then Pick the bank this statement came from: type Discover in the search box. Discover card statements are not on Intuit's list (checked 2026-09-25): no entry has Discover's name or website, so for a Discover card choose My bank isn't listed and download CSV or Excel. The list is Intuit's own, and for a card statement it only shows entries Intuit lists for credit cards. If you can't find the bank, click My bank isn't listed. You won't get a .qbo file; download CSV or Excel instead. QuickBooks Desktop only accepts files for banks registered with Intuit, and we won't label your file as another bank.
    • An account I already import into from my bank: this needs a .qbo file you downloaded for that card account (from Discover, or from Capital One after the move). The converter copies its bank ID and account number, so QuickBooks treats the converted file like the one you downloaded. That .qbo file is also read in your browser and never uploaded. If you don't have one, use CSV or Excel.
  5. Click the download button. Its label names the format you picked, for example Download QuickBooks (.qbo) or Download CSV.

What's free: one statement at a time, converted to CSV. $5 a month: any number of statements together, plus Excel, QuickBooks and OFX.

PDFs need a text layer. A scanned PDF (a picture of a page) can't be read.

Step 3: Import into QuickBooks Online

  1. Open Bank transactions. In the newer QuickBooks layout it's under All apps → Accounting → Bank transactions.
  2. Select the Link account dropdown, then Upload from file.
  3. Choose the .qbo file (or the CSV), pick the QuickBooks account it belongs to, and follow the prompts.

Intuit's limits: files up to 350 KB and 1,000 transactions per upload. If you hit either one, convert fewer months at a time. For a CSV upload, Intuit says the file should have 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit). Statement Converter's CSV has more columns than that, so the .qbo file is the simpler route.

Source: Intuit — Manually upload transactions into QuickBooks Online

Step 4: Import into QuickBooks Desktop

  1. Go to Banking → Bank Feeds → Import Web Connect Files (or File → Utilities → Import → Web Connect Files).
  2. Select the .qbo file and click Open.
  3. Choose Use an existing account if the account is already in QuickBooks, or Create a new QuickBooks account.

Things to know:

  • Intuit says importing a .qbo file requires you to be signed in to your Intuit account inside QuickBooks Desktop.
  • In our experience (not from Intuit's articles), QuickBooks Desktop rejects a Web Connect file from a bank it doesn't recognize. That's why the converter asks which bank the statement came from and writes that bank's own QuickBooks ID from Intuit's list. It never labels your file as a different bank.
  • In our experience, Desktop can refuse to import into an account that has a live automatic bank feed. If it does, turn that feed off first (Edit Account → Bank Feed Settings → Deactivate All Online Services), or import into a new account.
  • Intuit ended online banking services for QuickBooks Desktop 2023 on May 31, 2026 ("You won't be able to download transactions"). Earlier versions were already unsupported. If you're on 2023 or earlier, plan on a supported version.

Sources: Intuit — Set up bank feeds in QuickBooks Desktop · Intuit — Fix Web Connect import errors · Intuit — Desktop 2023 discontinuation

FAQ

Can I get a QuickBooks file for my Discover card? Not from a new account. Intuit's list (checked 2026-09-25) has no Discover entry, so click My bank isn't listed and download CSV or Excel instead. QuickBooks Desktop only accepts files for banks registered with Intuit, and we won't label your file as another bank. If you already have a .qbo downloaded for that card, An account I already import into from my bank can match it.

My account moved to Capital One. Can I still convert my old Discover statements? Yes, if you have them as text-based PDFs or CSVs. Capital One says you won't be able to view the account on Discover.com afterwards, and its page doesn't say whether old statements carry over, so as a precaution save the ones you need before the move.

Why are my charges positive numbers? Card files often show purchases as positive numbers. Statement Converter reads text-based PDF statements and CSVs that have a date, description and amount (or debit and credit) for each transaction, tells you when it can't read a file with confidence, and says how it read each file. Flip signs fixes it if it guessed wrong.

Is my statement uploaded anywhere? No. The file is read and written in your browser. Statement Converter is an independent tool from Avyth LLC. It isn't affiliated with or endorsed by Discover or Capital One, or by Intuit (QuickBooks).

Open Statement Converter →