QuickBooks HelpQuickBooksHelpIntuit

Fix issues when deactivating bank feeds

SOLVEDby QuickBooksQuickBooks Enterprise SuiteUpdated July 28, 2021

Find out what to do when you can’t deactivate your bank account’s online services in QuickBooks Desktop.

When you deactivate bank feeds for an account, the lightning bolt (Windows) disappears beside the bank account's name in the Chart of Accounts. If you can still see it, this means the bank feeds is still active for the account.

Important: Before you proceed with the following solutions, make sure to create a backup of your Windows company files.

Solution 1: Re-sort your lists

Re-sort your list to make the accounts go back to their default order and undo changes you made. This can often repair issues in your list that prevents you from deactivating bank feeds.

Solution 2: Verify and rebuild your company file

If there's possible data damage, verify your data to see data issues and use the rebuild tool to fix them. Here’s how to verify and rebuild in QuickBooks Desktop for Windows.

Solution 3: Deactivate bank feeds using Excel

If you still can’t deactivate bank feeds, here’s a manual process where you edit the file in excel, then import it in QuickBooks to deactivate bank feeds.

Note: If you’re in a multi-user setup, make sure to switch to single-user mode. To change, go to the File menu, then select Switch to Single user mode.

Step 1: Export Chart of Accounts

  1. Sign in to your company file as an admin.
  2. Go to the File menu, then 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 the File menu.
  2. Select Open, then browse to the folder where you saved the IIF file.

    Note: If you can’t find the IIF file, select All Files in the File type ▼ dropdown.

  3. Select the IIF file, then Open.
  4. In the Text Import Wizard, select Next, then Next and Finish.
  5. Scroll to the bottom of the page until you see QB ONLINE.
  6. Change Y to N for all the banking columns:
    • OLTAB
  7. Go to the File menu, then select Save.
  8. Confirm that you want to keep using the current format, then close Excel.

Step 3: Import the IIF file to QuickBooks

  1. Open QuickBooks.
  2. Go to the File menu, 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 if the import was successful.

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

To make sure that bank feeds is deactivated, check if the lightning bolt is gone. Go to the Lists menu, then select Chart of Accounts.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks DesktopQuickBooks Desktop PremierQuickBooks Desktop ProQuickBooks Enterprise Accountant Accountant

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this