How to Import Discover Transactions into QuickBooks

Short answer: Discover no longer offers a .QBO or .QFX download. It retired Web Connect on 27 September 2022 and moved everyone to Express Web Connect, a live feed. For QuickBooks Online you can connect that feed, or upload a CSV from the Activity page after fixing the signs and column layout. For QuickBooks Desktop, which imports Web Connect files and nothing else, you have to convert the Discover statement PDF into a .qbo file yourself.

Does Discover offer a QBO file for QuickBooks?

No, and it has not for years. Discover discontinued support for Web Connect on 27 September 2022. Web Connect was the mechanism for manually downloading an importable Quicken or QuickBooks file from your online account, and when it went, the .QFX and .QBO downloads went with it.

What replaced it was Express Web Connect, a live feed that signs into your Discover account on your behalf and pulls transactions into QuickBooks. Discover published a migration document titled Discover Bank and Discover Credit Card Connectivity Change that walks QuickBooks Windows users step by step through deactivating the old connection and setting up the Express Web Connect feed. Read it end to end and you will notice something: there is no file to download anywhere in it, because Discover does not make one any more.

This makes Discover unusual. Most issuers leave you at least one importable file. Chase still offers CSV, QFX, and QBO from its Activity page. American Express still downloads to QuickBooks and Quicken, though only for the past six billing statements. Discover leaves you a feed and a spreadsheet.

What Discover actually gives you now

How to import Discover transactions into QuickBooks Online

You have two routes, and which one you want depends entirely on whether you need history.

Route one, the feed. Go to Transactions, Bank transactions, Link account, and search for Discover. Sign in through the bank-hosted form and pick the card. This handles the current month well enough. What it will not do is reach backward: a newly connected card typically brings in about the last 90 days, and that limit is Intuit's rather than Discover's. If you are behind on the books, the feed cannot fix it.

Route two, a file. Go to Transactions, Bank transactions, open the Link account dropdown and choose Upload from file. Drag in a .qbo or .csv, then on the next screen choose the Discover credit card account, not a checking account. Map the columns if you brought a CSV, confirm the date format, and import. The rows land in For Review.

A .qbo is the better file of the two, because it needs no mapping and arrives signed correctly. Since Discover will not produce one, you get it by converting the Discover statement to QBO.

How to import Discover transactions into QuickBooks Desktop

Here the missing file stops being an inconvenience and becomes a wall. QuickBooks Desktop imports Web Connect .qbo files for bank and credit card transactions. It has no native CSV import for them. QIF does not work for a credit card account. Discover does not make a .qbo. Those three facts leave exactly one path open:

1. Download the Discover statement PDF from the Statements section of your account.
2. Convert it to a .qbo Web Connect file.
3. In QuickBooks Desktop go to File, Utilities, Import, Web Connect Files, or take the route through Banking, Bank Feeds, Import Web Connect Files.
4. Choose the file and associate it with the Discover credit card account.
5. Review the transactions in the Bank Feeds Center and add them to the register.

Discover's own migration guide does describe setting up an Express Web Connect feed inside QuickBooks Desktop, so a live connection is technically possible there. But a feed is not a file. It cannot be archived with the year end papers, it cannot be forwarded to a bookkeeper who has no Discover login, and it still will not reach back past 90 days. For any historical period, the converted statement is the answer.

Can I import a Discover CSV into QuickBooks?

Into QuickBooks Online, yes, with preparation. Into QuickBooks Desktop, no.

QuickBooks Online accepts a three column CSV of Date, Description, and Amount, or a four column file with separate Credit and Debit columns. Before it will take yours, you need to:

• Use one date format for every row, with no weekday text inside the date cell.
• Strip dollar signs and thousands separators, leaving a plain signed number.
• Leave zero-only cells blank rather than typing 0.
• Avoid descriptions that are purely numeric, since a bare reference number is rejected.
• Keep the file under 1,000 transactions and 350 KB.
• Flip the sign on every purchase, so charges are negative.

That last one catches almost everybody, and it deserves its own section.

Why did my Discover charges import as payments?

Because they arrived positive. In a QuickBooks credit card account a charge must be a negative number and a payment or refund must be positive. Discover, like every issuer, writes its export from its own point of view and lists purchases as positive amounts. Import that file untouched and QuickBooks reads each purchase as money paid toward the card, so the balance moves in precisely the wrong direction and the reconciliation will never close.

Fix it with a helper column that multiplies the amount by negative one, then paste back as values. Or sidestep it entirely with the four column layout, where each amount goes in the Debit or the Credit column and the sign never comes up. A converted .qbo file comes out signed correctly to begin with. If you already have the Activity CSV in hand and only need it in Web Connect form, a dedicated CSV to QBO converter does that single step without touching the rest of your workflow.

What the Activity CSV leaves out

There is a second, quieter problem with working from the Activity export. Interest and fees are assessed at the statement level, not the transaction level. Pull a date range from the Activity page and you get posted transactions, while the finance charges, the late fees, and the closing balance you are supposed to reconcile against stay behind on the PDF.

For a personal card nobody cares. For a business card being reconciled properly, those missing rows are the difference between a clean month and a balance that is off by exactly the interest charge, which is a genuinely annoying thing to hunt down. The statement carries everything. The Activity export carries most things.

Does this apply to Discover Bank accounts too?

Yes. Discover's connectivity change was explicitly issued for Discover Bank and Discover Credit Card together, so a Cashback Debit checking account or an Online Savings account sits in the same position as the card: an Express Web Connect feed, and no Web Connect file.

Convert the statement the same way. The one thing to get right is the destination. A Discover Bank statement imports into a bank account in QuickBooks, while a Discover card statement imports into a credit card account. Sending a card statement to a checking account is a fast route to a reconciliation that cannot be closed and a balance sheet that makes no sense.

Did Capital One buying Discover change anything?

Not so far. Capital One completed its acquisition of Discover in May 2025, and Discover branded cards have continued to operate as before. Statements are still issued under the Discover name, the Activity page still exports CSV and Excel, and there is still no Web Connect download.

It may change. Integrations of that size take years, and file formats are exactly the sort of thing that gets quietly harmonized somewhere along the way. The practical lesson is to build your process around the document rather than around whichever connection an issuer happens to offer this year. A statement PDF converts regardless.

Avoiding duplicates

If the Express Web Connect feed is running and you import converted history on top of it, you will get duplicates. Open the register, find the oldest transaction the feed brought in, and end your converted file the day before that date. Load history behind the feed, never over it. QuickBooks does try to catch duplicates on a Web Connect import, but it matches on amount, date, and reference, so a reworded description or a posting date that shifted by a day will get through.

Frequently asked questions

Does Discover offer a QBO file for QuickBooks?

No. Discover discontinued Web Connect on 27 September 2022, and Web Connect was the process for downloading an importable .QBO or .QFX file. It was replaced by Express Web Connect, a live feed. The only downloads available today are CSV and Excel from the Activity page.

How do I get Discover transactions into QuickBooks Desktop?

Convert the statement. Desktop imports Web Connect .qbo files, has no native CSV import for card transactions, and Discover no longer produces a .qbo. Convert the statement PDF, then import it under File, Utilities, Import, Web Connect Files and point it at the Discover credit card account.

Why did Discover stop supporting Quicken and QuickBooks downloads?

Discover moved from Direct Connect to Express Web Connect in September 2022 and dropped Web Connect at the same time. Its published migration guide routes QuickBooks users to the Express Web Connect feed instead. The file download has not been restored since.

Can I import a Discover CSV into QuickBooks?

Into QuickBooks Online, yes, after mapping the columns, using one date format, stripping currency symbols, keeping the file under 1,000 rows, and flipping the sign so charges are negative. Into QuickBooks Desktop, no. Desktop has no native CSV import for bank or credit card transactions.

How far back does the Discover feed go in QuickBooks?

Roughly 90 days on a new connection, and that ceiling is Intuit's rather than Discover's. Anything older must be added from a file you upload. Since Discover does not produce an importable file, converting the statement PDF is how older periods get in.

Does this work for Discover Bank accounts as well as cards?

Yes. Discover's connectivity change covered Discover Bank and Discover Credit Card alike, so a Cashback Debit or Online Savings account has the same missing file. Convert the statement the same way, but import it into a bank account rather than a credit card account.