Skip to main content
C
chris111
November 16, 2023
Solved

Bank feed removal error help

  • November 16, 2023
  • 2 replies
  • 0 views

I am unable to remove bank feed from one bank i no longer am using. when i click deactivated all online serves i get the error "Invalid Customer ID. Customer ID can only contain alpha numeric values". I tried re sorting, rebuilding, creating  a portable company file and restoring and nothing.

Any advice?

QB pro plus 2023, windows 11

Best answer by CamelleT

I appreciate your efforts in troubleshooting, chris111.

 

Since you already performed the two solutions, we can do the third one, deactivating bank feeds using Excel. Here's how:

 

For Windows (Make sure to switch to single-user mode. Go to File menu, then click Switch to Single-user mode.)

 

Step 1: Export Chart of Accounts

 

  1. Sign in to your company file as an admin.
  2. Go to File and select Utilities.
  3. Select Export, then Lists to IIF Files.
  4. Select Chart of Accounts, then OK.
  5. Browse to where you want to save the file.
  6. Enter a filename, then select Save.

Step 2: Edit the IIF file in Excel

  1.  Open Microsoft Excel, then go to File, and select Open. Then browse to the folder where you saved the IIF file.
  2. Select the IIF file, then Open.
  3.  In the Text Import Wizard, select Next, then Next, and then Finish.
  4. Scroll to the bottom of the page until you see QB ONLINE.
  5. Change Y to N for all the banking columns:
      • OLBANKING
      • OLBILLPAY
      • OLENABLED
      • OLTAB

  6. Go to File, then select Save. Select Yes to keep using the current format, then close Excel.

Step 3: Import the IIF file to QuickBooks 

 

Note: For more details on how to import IIF files, see Improved IIF Import.

  1. Open QuickBooks.
  2. Go to File, then select Utilities.
  3. Select Import, then IIF Files.
  4. Browse to the location of your IIF file.
  5. Select the IIF file, then Open.
  6. Select OK to confirm the import was successful.

 

To ensure bank feeds are deactivated, check if the lightning bolt icon is gone. Go to Lists, then select Chart of Accounts.

 

After performing this and the issue persists, I suggest contacting our customer support team.

 

Additionally, I'll share this article to help you manage your bank feeds in QBDT: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop (intuit.com).

 

Drop a reply below if you have further questions about fixing issues when deactivating bank feeds. I'll be around to help you. Have a nice day!

2 replies

C
CamelleTAnswer
November 16, 2023

I appreciate your efforts in troubleshooting, chris111.

 

Since you already performed the two solutions, we can do the third one, deactivating bank feeds using Excel. Here's how:

 

For Windows (Make sure to switch to single-user mode. Go to File menu, then click Switch to Single-user mode.)

 

Step 1: Export Chart of Accounts

 

  1. Sign in to your company file as an admin.
  2. Go to File and select Utilities.
  3. Select Export, then Lists to IIF Files.
  4. Select Chart of Accounts, then OK.
  5. Browse to where you want to save the file.
  6. Enter a filename, then select Save.

Step 2: Edit the IIF file in Excel

  1.  Open Microsoft Excel, then go to File, and select Open. Then browse to the folder where you saved the IIF file.
  2. Select the IIF file, then Open.
  3.  In the Text Import Wizard, select Next, then Next, and then Finish.
  4. Scroll to the bottom of the page until you see QB ONLINE.
  5. Change Y to N for all the banking columns:
      • OLBANKING
      • OLBILLPAY
      • OLENABLED
      • OLTAB

  6. Go to File, then select Save. Select Yes to keep using the current format, then close Excel.

Step 3: Import the IIF file to QuickBooks 

 

Note: For more details on how to import IIF files, see Improved IIF Import.

  1. Open QuickBooks.
  2. Go to File, then select Utilities.
  3. Select Import, then IIF Files.
  4. Browse to the location of your IIF file.
  5. Select the IIF file, then Open.
  6. Select OK to confirm the import was successful.

 

To ensure bank feeds are deactivated, check if the lightning bolt icon is gone. Go to Lists, then select Chart of Accounts.

 

After performing this and the issue persists, I suggest contacting our customer support team.

 

Additionally, I'll share this article to help you manage your bank feeds in QBDT: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop (intuit.com).

 

Drop a reply below if you have further questions about fixing issues when deactivating bank feeds. I'll be around to help you. Have a nice day!

M
MSBP
April 16, 2025

I had such high hopes for this! I've had an inactive checking account show connected to my bank feeds for over a year. The account was never able to download transactions (while active) and has never been able to be disconnected.  I tried this fix of exporting the COA to iif, changed the online banking colums to "N" and reimported. It was useless. Waste of time and still get the same error message when trying to disconnect from bank feeds: You attempt to de-activate account has failed. Try again after some time. If this error persists, contact your administrator. The error repeated/persisted when upgrading desktop versions - so it appears it will persist when I upgrade to 2024.  For context, I am accountant user who has worked in every version of QuickBooks since 2005. This is just another bug which can't be fixed.

I
indomitabletroubleshooter
June 28, 2024

I have had a similar problem since upgrading to QB Desktop 2024. My primary checking account shows as connected (lightning bolt present) in the Chart of Accounts, but does not show in the Bank Feeds window. When I go to import the bank feed, it does not give the option to connect it to this checking account, apparently because it thinks that account is already connected.

 

Trying to disconnect by the normal means does not remove the lightning bolt.

If I switch the radio button to Activate, and back to Deactivate before I save, the program crashes every time.

I have tried Sorting, Verify and Rebuild, etc. to no effect.

When I download the IIF file for the chart of accounts, this checking account is NOT LISTED at the bottom with my other accounts (which I was able to Deactivate and Reactivate after the upgrade just fine).

 

So, is there ANOTHER method for Deactivating an account from bank feeds when the normal method and the work-around using the IIF file won't do it?

J
JamaicaA
June 28, 2024

Hi, indomitable.

 

I appreciate the thorough information you've provided regarding the issue with your bank feed and your efforts to troubleshoot the connection. Connecting your Checking account is crucial for seamlessly importing transactions into the program. I can guide you to our experts for further help with this.

 

Since the primary checking account appears connected in the Chart of Accounts but doesn't show up in the Bank Feeds window after attempting various methods to deactivate and activate it, I recommend reaching out to our Support Team. They can securely access your account to assist you with linking your bank account and investigating the program's crashing issue when saving. I'll show you how:

 

  1. Go to the Help icon, then select QuickBooks Desktop Help.
  2. Press Contact Us.
  3. Enter a description of your subscription concern, then click Continue.

 

Please ensure you check our operating hours for a prompt response in this article: Contact QuickBooks Desktop Support.

 

Once everything is fine, refer to this guide to match the entries: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop.

 

Moreover, this reference will help automate things for your convenience: Create rules to categorize transactions in QuickBooks Desktop.

 

I'm always ready to address any banking concerns or connection issues. You can add them by leaving a comment below. I'll make sure to provide a quick response.

Terms & ConditionsAccessibility statement