How to Connect Capital One to QuickBooks Online (Credit Card Feed, Older Transactions, CSV)
To connect a Capital One credit card to QuickBooks Online, go to Transactions → Bank transactions → Connect account, search for Capital One, sign in with your Capital One online banking login and link the card to a credit card account. Two things catch people out: the feed usually brings in only about 90 days of history, and each card has to be added on its own. Below are the steps, how to get older transactions in, and what to do when a CSV upload or a Desktop connection fails.
Capital One’s own menus change, and it doesn’t publish download steps for every account type. On the website, look for Download Transactions on the card’s or account’s activity page.
Connect a Capital One credit card to QuickBooks Online
These are the steps Capital One gives for its business cards. The same flow works for other Capital One accounts that show up in the QuickBooks bank list.
- In QuickBooks Online, open Transactions → Bank transactions and choose Connect account (or Link account).
- Search for Capital One and pick it from the list.
- Sign in with your Capital One online banking username and password, not your QuickBooks login.
- Finish Capital One’s security check (a code by text, call or email).
- Choose which accounts to share and authorize. You’ll be sent back to QuickBooks.
- Pick the accounts to connect. You don’t have to connect all of them.
- Choose how far back to pull transactions.
- Match the card to its credit card account in your chart of accounts, or let QuickBooks create one. A card connected as a bank account will have its signs the wrong way round.
- Click Connect. Posted transactions appear under For review. Pending charges don’t show until they post.
Several Capital One cards? QuickBooks support says each card with its own account number can be connected, but you add each one through Bank transactions, not through the chart of accounts. A replacement card that moves you from another issuer to Capital One is simply added as a new connection.
Getting transactions older than 90 days
A QuickBooks team member has confirmed that the automatic feed for a Capital One credit card can’t go back further than about 90 days, however far back you pick in step 7. Capital One keeps about 2 years of business card activity online, so download the rest as a file:
- In Capital One, open the card, choose Download Transactions, set the date range and pick QuickBooks (.qbo) if offered, otherwise CSV or Excel.
- In QuickBooks Online: Transactions → Bank transactions, the Link account ▾ arrow → Upload from file, choose the file and the same credit card account.
- Import only the dates before the feed’s first transaction, so nothing is entered twice.
Capital One needs a separate download for each card, and exports work on the website, not in the app.
Capital One CSV won’t upload (“Darn. File upload failed”)
Capital One’s credit card CSV usually has seven columns: Transaction Date, Posted Date, Card No., Description, Category, Debit, Credit. Purchases are in Debit, and payments and refunds are in Credit. QuickBooks Online often rejects this file or maps it wrongly. In April 2026, a QuickBooks moderator suggested these fixes:
- Keep only Date, Description, Debit, Credit. Delete Posted Date, Card No. and Category.
- Leave cells blank instead of 0.
- Use one date format all the way down. On a Mac, save as Windows CSV.
- Remove currency symbols and thousands separators from amounts, and remove unusual characters from descriptions.
Or skip the cleanup: drop the Capital One CSV into CSV to QBO (or Excel to QBO for the Excel export). It reads the Debit and Credit columns as they are, ignores Card No. and Category, and gives you a .qbo file that QuickBooks imports without column mapping. Choose Credit card as the account type. In the preview, purchases should be negative and payments positive. If yours are the other way round, tick Reverse signs. The conversion runs in your browser, so the file isn’t uploaded anywhere.
QuickBooks Desktop
Bank feed: Banking → Bank Feeds → Set Up Bank Feed for an Account and search for Capital One. You’ll see several listings. In August 2026, an Intuit community manager explained that Capital One changed its security requirements, so older Desktop connections stopped working, and that you should connect with Capital One Bank - New. Picking an older listing leads to the same error again.
To switch an old connection to Capital One Bank - New:
- Update QuickBooks Desktop and back up the company file.
- Add or match everything waiting in the Bank Feeds Center.
- Lists → Chart of Accounts, right-click the card → Edit Account → Bank Settings → Deactivate all online services.
- Banking → Bank Feeds → Set Up Bank Feed for an Account, choose Capital One Bank - New, sign in and link it to the existing account.
- Pick a start date after the last transaction already in QuickBooks.
If deactivating fails with error 88888 or “Your attempt to de-activate account failed”, the same thread suggests signing in to QuickBooks as the admin and trying again.
Files: for business credit cards Capital One lists QuickBooks, Quicken and Excel downloads. Import a .qbo with File → Utilities → Import → Web Connect Files. A Quicken .qfx has to be converted with QFX to QBO first, because Desktop only imports .qbo as Web Connect.
“QuickBooks is unable to verify the Financial Institution information for this download”: Desktop users have reported this with Capital One .qbo files. Intuit’s steps for Web Connect import errors are: download the file again, switch Bank Feeds to Classic (Register) mode, and test the import in a new company file. If it still fails, open Settings in the QFX to QBO converter and try a different bank ID. See what is a QBO file for why that matters.
Tips
- Import each card separately, into a credit card account in QuickBooks, not a bank account.
- Don’t import the same dates through both the bank feed and a file. A note from an Intuit thread: rows with transaction IDs QuickBooks has already seen can be skipped without a warning, so if something seems missing after an import, compare the totals with the statement before importing again.
- On Desktop 2023 or older, bank downloads stopped after May 31, 2026: Desktop bank feeds not working.
- Other connection errors: QuickBooks bank feed errors.
Sources
Read November 4 and 19, 2026: Capital One Business and QuickBooks, Spark Cash Select; QuickBooks Community: limited history for Capital One credit card, connecting three Capital One credit cards, Capital One CSV download won’t import (Apr 2026), Capital One credit cards connection issues (Aug 2026), Desktop 2024 and Capital One QBO; Intuit: common errors importing bank transactions, fix Web Connect import errors.