How to Import Discover Statements into QuickBooks

Discover works with QuickBooks through a live bank feed, a direct OFX or QFX export, and a CSV for manual upload. Here is how to use each route, what to do with cashback rewards, and how to pull in older history when the download window runs out.

One thing that trips people up with Discover is that it covers two different account types: credit cards (Discover it and related products) and Discover Bank deposit accounts (the Cashback Debit checking account and Online Savings). QuickBooks treats these differently - credit cards go under the Credit Card account type, while Discover Bank accounts go under Bank. The setup steps are the same, but it is worth getting the account type right from the start to avoid reconciliation headaches later.

Route 1: Live bank feed in QuickBooks Online

The most convenient ongoing setup is connecting Discover directly to QuickBooks Online. Transactions pull in automatically, and you categorize them at your own pace inside QuickBooks.

To connect:

• In QuickBooks Online, go to Banking (or Transactions) and click Link account.
• Search for Discover and select your account type (credit card or bank account).
• Authenticate using your Discover.com login credentials.
• QuickBooks will import approximately 90 days of recent history as an initial batch, then sync new activity automatically on an ongoing basis.

Important: the live feed only brings in history from the point where the connection was established forward, plus that initial 90-day batch. If you need older transactions - for example, you are importing a full calendar year for tax purposes - you will need to supplement the feed with a manual import of earlier data. Use Route 3 or Route 4 below for those periods.

Route 2: OFX or QFX export for QuickBooks Desktop

Discover's activity download includes OFX and QFX format options. Both are Web Connect formats that QuickBooks Desktop imports natively, making this the most direct path for Desktop users who do not want to set up a live feed.

Exporting from Discover

• Log into discover.com and open the account you want to export.
• Go to Statements and Activity and click Download Activity.
• Set a date range and choose OFX or QFX as the file format.
• Download the file and save it locally.

Importing into QuickBooks Desktop

• In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files.
• Select the OFX or QFX file you downloaded from Discover.
• QuickBooks will ask which account to import into. For Discover credit cards, select your Credit Card account. For Discover Bank, select your Bank account.
• Review the imported transactions and accept them into your register.

Discover's activity download covers up to 24 months of history - longer than most banks. For periods before that window, the PDF method in Route 4 handles the remainder.

Route 3: CSV import into QuickBooks Online

If you prefer not to set up a live bank feed, Discover's CSV export is a clean alternative for recent history.

• From the Download Activity screen on discover.com, choose CSV as the format and set a date range.
• Download the file. The Discover credit card CSV includes columns for Trans. Date, Post Date, Description, Amount, and Category. The Amount column uses negative values for charges and positive values for credits.
• In QuickBooks Online, go to Banking, click the dropdown arrow next to Link account, and choose Upload from file.
• Select your Discover account, upload the CSV, and map the columns: Date (use Post Date for statement reconciliation), Description, and Amount.
• QuickBooks Online will guide you through the column mapping and flag any rows it cannot parse.

A note on the amount sign convention: Discover's credit card CSV uses negative amounts for purchases. QuickBooks Online's upload tool expects a signed amount where expenses are positive. When you map the Amount column, QuickBooks will ask whether the amounts are signed or split into separate debit and credit columns. Select signed and let QuickBooks flip the sign as needed.

Route 4: Convert older Discover PDF statements and import

For any history older than Discover's activity download window, the official PDF statement is the only available data source. Getting that into QuickBooks requires two steps: extracting the transactions from the PDF, then importing the resulting CSV.

Step 1: Download the PDF from Discover

• Log into discover.com and go to Statements and Activity.
• Click Statements and select the month you need. Discover typically keeps several years of PDF statements available.
• Download the PDF and save it locally. Repeat for each additional month.

Step 2: Extract transactions with a local converter

Discover PDF statements for credit cards list each transaction on its own line with date, description, and amount in a fixed-width layout. The layout is clean, but pasting it into a spreadsheet still produces misaligned columns because the spacing is not preserved as tab stops. A dedicated converter reads the Discover format and produces a structured CSV: one row per transaction, with properly aligned date, description, and amount fields.

Quill parses Discover statement PDFs locally on your computer. Drop in the file and it extracts every transaction and exports to CSV - ready for QuickBooks import. No upload, no cloud account, no bank login required.

Step 3: Import the CSV into QuickBooks

For QuickBooks Online, use the Upload from file option in the Banking section and map the columns as described in Route 3 above.

For QuickBooks Desktop, you can convert the CSV to IIF format using QuickBooks' built-in import tools, or use a journal entry for small batches.

Handling Discover cashback rewards in QuickBooks

Discover Cashback Bonus credits appear as transaction rows in the statement with a description like "Cashback Bonus Award" and a positive amount. When these come through the bank feed or appear in an imported CSV, QuickBooks will try to categorize them as income by default. Here are the two common approaches:

• Other Income: Create an income account called "Credit Card Rewards" or "Cashback Rebate" and post all cashback credits there. This keeps your expense totals clean and makes the rewards visible as income.
• Reduction of expense: Post the cashback credit against the same expense account as the purchases that generated it. This reduces the net cost of those expenses. It is less visible but simpler if the rewards relate to a single spending category like office supplies or travel.

Either method is acceptable from an accounting standpoint. Pick one and apply it consistently. Your accountant can advise on which treatment makes more sense for your business structure.

Discover credit cards vs. Discover Bank in QuickBooks

If you have both a Discover credit card and a Discover Bank checking or savings account, set them up as separate accounts in QuickBooks with the correct account types:

• Discover credit card: Account type = Credit Card. Charges are expenses; payments reduce the credit card liability.
• Discover Bank checking (Cashback Debit): Account type = Bank. Deposits are income or transfers in; withdrawals are expenses or transfers out.
• Discover Online Savings: Account type = Bank (or Other Current Asset if you prefer to distinguish savings from operating accounts). Interest credits are Other Income.

Mixing up the account types - for example, importing credit card transactions into a bank account - will create reconciliation errors and may affect your financial reports.

For a focused guide on getting Discover statement data into spreadsheet format without the QuickBooks step, see our companion post on converting Discover PDFs to CSV.