To download Discover card transactions to QuickBooks, sign in to your Discover account on a computer, open the card's activity, use the download option, and pick a QuickBooks (.qbo) file or a CSV. Upload it into a QuickBooks credit card account, not a bank account, so charges raise the balance and payments lower it.
Finding the Discover card activity download
The Discover card download sits with the account's transaction activity, not with the PDF statements. Sign in on the full website, open the card's activity or recent transactions, and look for a download or export control near the list. Discover can rename or move it, so follow the words on your own screen.
Work through it in this order:
- Sign in on a laptop or desktop browser. Card apps are made for checking spending, and file exports are often missing from them.
- Open the activity view for the card.
- Choose the period you want. Some card sites let you pick a statement cycle, some take any two dates.
- Select download and choose the file type.
- Save the file and rename it, for example
discover-card-2026-08.qbo.
If you have more than one Discover card, download each separately. Each card needs its own credit card account in QuickBooks, because each has its own balance and its own statement to reconcile against.
A Discover bank account, if you have one, is a different product with its own activity page. The steps are similar, but its file goes into a bank account in QuickBooks, not a credit card account.
Discover QBO or CSV: which file should QuickBooks get?
A QBO file is the better choice for QuickBooks when Discover offers one for your account. It needs no column matching, and QuickBooks reads each line's date, amount and description without help. A CSV works in QuickBooks Online as a fallback. In QuickBooks Desktop, only the QBO file will go in through Web Connect.
Intuit's guide to manually uploading transactions in QuickBooks Online lists CSV, TXT, QBO, OFX and QFX as upload types and suggests QBO. For Desktop, Intuit's article on downloading bank feed transactions in QuickBooks Desktop says Web Connect accepts only .qbo files, and a bank's QFX or QIF export won't import.
| You use | Pick | Notes |
|---|---|---|
| QuickBooks Online | QBO, or CSV if no QBO is offered | CSV needs column mapping |
| QuickBooks Desktop | QBO | QFX and CSV won't import through Web Connect |
| A spreadsheet first | CSV | Good for checking lines before any upload |
A Quicken (.qfx) option may also appear. QuickBooks Online will accept it, but it is made for Quicken, so pick QBO when both are on the list.
Keeping Discover charges and payments the right way round
On a credit card account, a purchase increases what you owe and a payment decreases it. QuickBooks handles that correctly when the Discover file goes into an account set up with the credit card type. Most sign problems come from uploading into the wrong account type, or from a CSV whose amounts run the opposite way from what QuickBooks expects.
A worked example
The five lines below are examples, not real data. They show how each kind of card line should land in a QuickBooks credit card account:
| Date (example) | Description | What it is | Effect on the card balance in QuickBooks |
|---|---|---|---|
| 08/02/2026 | EXAMPLE OFFICE SUPPLY | Purchase | Goes up by 64.10 |
| 08/05/2026 | EXAMPLE AIRLINE | Purchase | Goes up by 312.00 |
| 08/09/2026 | EXAMPLE AIRLINE REFUND | Refund | Goes down by 312.00 |
| 08/15/2026 | INTERNET PAYMENT - THANK YOU | Payment | Goes down by 500.00 |
| 08/20/2026 | CASHBACK BONUS REDEMPTION | Statement credit | Goes down by 25.00 |
After an upload, open one purchase and one payment in the review list. If the purchase shows as a charge and the payment as a credit or payment, the file is the right way round.
When a Discover CSV runs backwards
A CSV has no account type of its own. It is just numbers in columns, and card issuers differ on whether purchases are positive or negative. If the test above shows purchases as payments, delete the upload, open the CSV in a spreadsheet, multiply the amount column by minus one, save it as CSV and upload again.
The card payment itself is worth one more look. It appears twice in your books: as a payment on the Discover account and as money leaving your checking account. Record it as a transfer between the two accounts, or match one side to the other, so it isn't counted as an expense.
Setting the date range on a Discover download
The best date range for a Discover download follows the card's statement cycle, not the calendar month. A card statement closes on a set day each month, and reconciling in QuickBooks works against that statement. Start each file the day after the previous statement closed and end it on the closing date.
Here is an example. If a card statement closes on the 22nd, download August 23 to September 22 as one file. Its total change in balance should equal the change between the two statement balances. That makes the reconciliation a single comparison.
Other points about the range:
- Leave pending charges out. End the range at the last closing date, not today. Pending lines can change amount or disappear.
- Keep to the upload limit. Intuit caps a QuickBooks Online upload at 350 KB and 1,000 lines. A busy business card might need to be split into two files per cycle.
- Check the earliest date you received. Card sites keep only a window of recent activity for export. If the file starts later than you asked, the gap needs another source.
How long that window lasts varies from one bank and card issuer to the next. The guide on how far back you can download bank transactions explains why statements reach further than downloads and how to plan around the limit.
Mapping a Discover CSV in QuickBooks Online
When you upload a Discover CSV to QuickBooks Online, the upload asks which column holds the date, the description and the amount. Intuit says each file needs either three columns (date, description, amount) or four (date, description, credit and debit). Anything else in the file should be removed first.
| CSV column (example names) | Map it to | Notes |
|---|---|---|
| Trans. Date or Post Date | Date | Keep the posting date if there are two |
| Description | Description | Leave the text as the issuer wrote it |
| Amount | Amount | One signed column |
| Category | Not mapped | Delete it before the upload |
The column names in that table are illustrations. Your file's header row is the authority.
Intuit adds a few clean-up rules for CSV uploads: dates should all use the same format, cells that hold only zero in the amount columns should be left blank, and the word "amount" should be removed from credit and debit headers. A card export with a "Category" column and a "Post Date" column beside a "Trans. Date" column needs two columns deleted before it fits.
Discover cashback and statement credits in QuickBooks
Cashback redeemed as a statement credit shows up in a Discover download as a credit line, much like a refund. It lowers the card balance, but it isn't a refund of a business purchase. Give it its own category in QuickBooks so it doesn't quietly reduce an expense account.
How you categorise rewards is a choice for you or your accountant. Common options are an "other income" account or a reduction of the related expense. What matters is that you pick one treatment and use it every month, and that the credit is not matched against an unrelated purchase.
Watch for the reverse case too. Rewards redeemed as a deposit into a bank account appear on the bank side, not the card. In that case the card download shows nothing, and the bank download shows a small incoming payment from the card issuer.
What if Discover gives you no QuickBooks file at all?
If your Discover account offers no QuickBooks download, or the months you need are older than the export reaches, you still have options. You can use the CSV in QuickBooks Online, connect the card through a bank feed, or convert the monthly PDF statements, which go back further than the activity download.
The guide to what to do when a bank does not support a QuickBooks download compares those routes. For PDF statements, SimpleBankConvert turns a digital card statement into a CSV or QBO file for the QuickBooks Online upload. It is in early access and not yet open for accounts, and you can ask to be told when it opens.
One route that doesn't work: if you tracked the card in Quicken for years, the Quicken data file can't simply be turned into a bank download. Why a QDF file can't be converted to QFX explains what to export from Quicken instead.
Whichever route you take, compare each month's total with the Discover statement before moving on. A month that agrees is finished. A month that doesn't is usually missing one line, or holds a line with the wrong sign.