Discover Bank's online-only model means consistent, well-formatted PDF statements. Compared to legacy banks with multiple legacy formats running concurrently, Discover is a relatively easy bank to convert. But there are still a few specifics that affect a clean QuickBooks import — particularly around their cashback debit account and how they label internal transfers.
Short version: Discover's two main quirks: cashback debit transactions show as separate negative-then-positive line items (the purchase and the cashback reward), and Discover savings statements use a calendar-month period that doesn't always align with checking statements at the same bank.
Discover Bank's specific things to watch for
1. Cashback debit transactions
Discover's Cashback Debit account credits rewards monthly, and each cashback reward appears as a separate transaction in your statement — not embedded in the original purchase. So when you process a month's worth of debit activity, you'll see the purchases on their original dates and then a single "CASHBACK REWARD CR" entry at month-end.
For QBO categorization, the cashback reward should route to an Other Income account, not to whatever category the original purchase belonged to. Set up a bank rule for transactions containing "CASHBACK REWARD" to handle this automatically.
2. Internal transfers between Discover accounts
If your client has both Discover checking and Discover savings, transfers between the two appear in BOTH statements with paired descriptions like TRANSFER TO SAVINGS and TRANSFER FROM CHECKING. When you import both statements to QBO, the same transfer will appear twice unless QBO recognizes it as a matched transfer.
The fix in QBO: use the Transfer transaction type (not a regular deposit/withdrawal) so the system pairs them correctly. If you import as separate transactions, you'll need to manually pair them via the "Record transfer" action.
3. Savings statement period
Discover savings statements cover the full calendar month (1st through 30th/31st). Their checking statements cover the same period. So they're aligned with each other — but if your client also banks at, say, Chase or Capital One whose statements end mid-month, you'll be reconciling two different period definitions in the same QBO file.
Three ways to do the conversion
Option 1: Manual copy-paste
Open the PDF, select the transaction table, paste into Excel, use Text-to-Columns, manually merge any continuation rows, drop extras, reformat the date, save as CSV. Works for one statement; tedious for more.
Option 2: Generic PDF-to-Excel tools
Adobe Acrobat, Smallpdf, Tabula will extract the table but won't merge continuation lines or skip the running balance. Output usually needs cleanup.
Option 3: A bank-statement-specific converter
Purpose-built tools recognize the Discover Bank format, handle the quirks above automatically, and reconcile to the statement totals before download.
Worth trying: If you're processing Discover Bank statements regularly, an automated converter that reconciles to the statement totals saves the manual cleanup. YourStatementConverter does this on every conversion — 25 pages free with no credit card.
Common errors and fixes
"My QBO balance is double what it should be"
You probably imported both sides of a Discover-to-Discover transfer. Find the dates with paired transactions matching to the dollar (one debit, one credit, same amount), and either delete one or convert them to a proper QBO Transfer.
"QBO is rejecting my date format"
QBO requires MM/DD/YYYY. If your conversion output uses a different format, fix it in Excel before importing using =TEXT(A1,"MM/DD/YYYY").
Importing the converted file into QuickBooks Online
Once you have a clean Excel or CSV file from a Discover Bank statement, the QBO import is the same as for any other bank. QBO expects three columns: Date (MM/DD/YYYY), Description (plain text), Amount (decimal, negative for debits).
To import:
- Go to Bookkeeping → Transactions → Bank transactions
- Pick the bank account, click the dropdown next to "Link account," and choose Upload from file
- Drag in the CSV, map the columns, click Next
- Spot-check the preview
- Confirm and import
Final checklist before importing your Discover Bank file
- Three columns only: Date, Description, Amount
- Date format MM/DD/YYYY
- Debits are negative
- No empty rows or unmerged continuation lines
- Amount total equals Statement Ending minus Beginning balance
For more on the reconciliation discipline that makes this kind of work tractable, see our catch-up bookkeeping playbook.