Solved

Why does QuickBooks Desktop keep disconnecting from Capital One, and how do I fix it?

Forum|Forum|4 years ago
July 15, 2022
24 replies
116 views

I am on QuickBooks Desktop Premier 2020, and I am attempting to download transactions through bank feeds. My Capital One - Credit Cards account has been working for months, and now I several issues out of nowhere.

Error One: I attempt normal download and I get a popup service notice "You're no longer connected to Capital One - Credit Cards. Setup your connection again to continue using bank feeds."

Error Two: I attempt to disable the bank feed for this account to reconnect it. I then get a popup error "Your attempt to de-activate account failed. Try again after some time. If this error persist, contact your administrator."

Error Three: I attempt to create a new connection to Capital One. I get all of the way through setting up a new bank feed and I popup error "Sorry, we've run into a problem. QuickBooks is having trouble connecting to Capital One-Credit Cards.

Your Options:

-Try again later: This is a temporary issue and will be resolved in a day or two. Try to setup your Capital One - Credit Cards then.

- 88888 :All accounts associated with this customer ID have been synced with QuickBooks' bank feeds. If otherwise, contact your financial institution."

This has persisted for about a week now, and I have called both Capital One and QB support with no luck. No one knows what is going on.

I have updated both Windows and QB, I have done a "Rebuild Data" on the company file, I have attempted to manually import transactions, all to no avail.

This is also persistent across three different company files.

QuickBooks Desktop

Best answer by Emma_P

If Capital One suddenly won’t connect to QuickBooks Desktop, it's because Capital One changed its security requirements and your old bank feed connection no longer works. The fix is to turn off the old connection and set it up again using the newer "Capital One Bank - New" option.

Step 1: Turn off the old bank feed connection

Before you start, update QuickBooks to the latest release and back up your company file. You'll also want to match or delete any pending downloaded transactions for the account first, since QuickBooks won't let you turn off bank feeds while transactions are still pending.

Go to Lists, then select Chart of Accounts.
Right-click the Capital One account, then select Edit Account.
Go to the Bank Settings tab.
Select Deactivate all online services, then OK.
Select Save & Close.

If deactivation won't go through

Sometimes QuickBooks won't let the account deactivate and shows a message like "Your attempt to de-activate account failed." If that happens, work through these in order:

Re-sort your lists. This puts your accounts back in their default order and can clear up whatever's blocking the deactivation.
Verify and rebuild your company file. This checks for data damage that can interfere with bank feeds and repairs it.
Deactivate manually through Excel. Export your chart of accounts to an IIF file (File > Utilities > Export > Lists to IIF Files), open it in Excel, scroll to the QB ONLINE section, and change OLBANKING, OLBILLPAY, OLENABLED, and OLTAB from Y to N. Save the file, then import it back in through File > Utilities > Import > IIF Files. Once it's imported, check the Chart of Accounts again. If the lightning bolt icon next to the account is gone, the bank feed is deactivated.

Step 2: Reconnect using the new Capital One connection

Go to Banking, then select Bank Feeds.
Select Set Up Bank Feed for an Account.
Type in Capital One, and when you see the matching results, choose Capital One Bank - New. Picking the old listing is what causes the setup to loop back to the same connection error.
Enter your Capital One username and password, then select Connect. Your bank may also ask for a one-time password.
Select the account(s) you want to connect, then select Connect, then Close.

Once you're reconnected, go to Bank Feeds, then Bank Feeds Center, select the account, and choose Download Transactions to pull in your latest activity.

If you're importing downloaded transaction files instead

If you download your Capital One activity as a file and import it manually, but nothing comes in and you don't see an error, a few things can cause that:

Make sure you downloaded the file directly from Capital One's website, not from inside QuickBooks.
Check your bank's website for any messages about reauthorizing or confirming your identity. Banks sometimes require this before a file will import correctly.
Try switching Bank Feeds to Classic mode (from Banking, hover over Bank Feeds, then select Change Bank Feeds Mode) and import the file again.
If you've already imported transactions for this account before, QuickBooks may be silently skipping them because it recognizes the same transaction IDs and is avoiding duplicates.

If none of that gets your transactions to come in, the file itself may need a fresh download from Capital One.

Let us know if you run into anything else while getting reconnected.

Resources:

Refresh connection for online banking in QuickBooks Desktop

Disconnect Bank Feeds for an account in QuickBooks Desktop

Fix issues when deactivating bank feeds

Fix Web Connect import errors

Error: Nothing imported after importing a Web Connect (.qbo) file

D

DebSheenD

Level 5

Welcome to the Community, Fifth Gear Automotive.

I'll share some important details about connecting bank accounts in QuickBooks Desktop (QBDT).

Rebranding accounts tied to QuickBooks Bank Feeds can help bank connection issues in QBDT. Before doing so, ensure to create a backup copy of your company.

Here's how:

Deactivate Bank Feeds for an account.
Create a new bank account.
- From the Lists menu, tap Chart of Accounts.
- In the Chart of Accounts window, right-click anywhere and hit New.
- Choose Bank for the Account Type.
- In the Account Name field, enter the name of the bank.
- Tick Save & Close.
Merge the two accounts by renaming the old account with the name of the new account.
- Right-click the old account, then tap Edit.
- In the Account Name field, type the name of the new account.
- Choose YES when you get the Merge warning dialog box.

For additional information, you can refer to this article: Re-brand or reset accounts for Bank Feeds access.

Additionally, I'd recommend reconciling your accounts every month. This is to effectively monitor your income, expenses, and the growth of your business: Reconcile an account in QuickBooks Desktop.

Let me know if you have concerns about bank connections in QBDT. We'll be with you all through the process. Take care.

F

Fifth Gear AutomotiveAuthor

Sorry, but this does not work at all.

1) I am not able to de-activate the account. The system does not let me for some reason.

2) I created a new chart of account and they do not merge.

M

Michael199

This does not work for me either.

"Your attempt to de-activate account failed. Try again after some time. If this error persists, contact your administrator."

P

Paying Customer

I was able to resolve a similar issue I was having with Discover. I posted details in my thread here, look for the accepted solution.

B

Bimmer32

I have the same exact problem with the Capital One credit card bank feed. I cannot deactivate the account in Quickbooks. I had to do the Solution 3, which is the manual deactivation of Bank Feed via Excel posted by Paying Customer. Make sure to follow the exact instruction by Paying Customer in his thread.

https://quickbooks.intuit.com/learn-support/en-us/banking/re-unable-to-disconnect-bank-feed-from-discover-account-qb/01/1124953/highlight/true#M84402

When you start a new activation, make sure to use the "Capital One - Credit Cards" one and link it to your current Capital One card account in QB Desktop.

I think the issue is caused by security change either with Capital One or QB, and it requires you to reconnect. The big problem is when you cannot deactivate the account in QB, which then you spend a couple of hours trying to figure out the solution. Once you can deactivate the bank feed for your account in QB, you can reconnect and relink OK.

K

Kc1119

Error 8888 - All accounts associated with this customer ID have been synced with QuickBooks' bank feeds

We can reset your Intuit ID settings, then let's log back into your Intuit account. These are the steps to follow:

From the Help menu, select Reset Intuit ID Settings.
Enter the word YES in the confirm field.
Click OK.

Once done, let's go to the Company menu and select My Company. Then, click on the Sign In button. Select you're the admin and will be managing the account. On the pop-up, enter your Intuit credentials, then hit Sign In.

Try and set up bank feeds again for that account.

K

Kc1119

Error 8888 - All accounts associated with this customer ID have been synced with QuickBooks' bank feeds

We can reset your Intuit ID settings, then let's log back into your Intuit account. These are the steps to follow:

From the Help menu, select Reset Intuit ID Settings.
Enter the word YES in the confirm field.
Click OK.

Once done, let's go to the Company menu and select My Company. Then, click on the Sign In button. Select you're the admin and will be managing the account. On the pop-up, enter your Intuit credentials, then hit Sign In.

Try and set up bank feeds again for that account.

J

jenniferneris

Has this been working for anyone as of yet? I have reset my Intuit ID and signed in anew. I have downloaded my Capital One statements as QBO files. I double click them to import and get a screen asking me if I want to import for save for later. I choose import and click ok. Then nothing happens. Nothing is imported. No errors are given. This is extremely frustrating.

JaeAnnC

Level 6

Thanks for chiming in on this thread, @jenniferneris. I'm here to share the proper format of the CSV file so you can import your bank transactions into QuickBooks Online (QBO).

CSV files are formatted differently by each bank. It means you're unable to import them since files don't have the format QBO needs.

You can upload CSVs with either the following 3-column or 4-column format. These are the only columns QBO can handle and this order.

For the full details, see these articles:

Additionally, we've assembled some frequently asked questions about importing data to further guide you through the process: Common questions about importing data to QuickBooks Online.

Please don't hesitate to return to this thread if you have more questions about importing bank transactions. The Community is more than willing to lend you a hand. Stay safe and have a nice day ahead.

J