QuickBooks Desktop Bank Feeds Stay On After Deactivation

Some QuickBooks Desktop users deactivate a bank account’s online services and find that nothing changes. The connection marker stays beside the account name in the Chart of Accounts, and the feed is still live. The fix that resolves this is an export, a small edit in Excel, and an import back into the company file.

The symptom is easy to spot

Windows marks a connected account with a lightning bolt beside its name in the Chart of Accounts. On Mac, the same signal is a blue circle. Deactivating the feed should remove that marker. When it survives, the online service is still active no matter what the account settings show. That leftover marker is the target of this fix.

Start with the lighter repairs

Two routine repairs sometimes clear the blockage on their own. Make a fresh backup of your company file before you try either one.

Re-sorting returns your lists to their default order and undoes stray changes that can block deactivation. If nothing improves, run the verify utility to look for data damage, then run rebuild to repair what it finds. Both tools come with the program on Windows and on Mac. These steps are worth a few minutes each. When they work, you avoid editing anything by hand.

The accepted fix: edit the banking flags in an export

When the light repairs fail, the resolution is direct. You export the Chart of Accounts to an IIF file, flip four flags from Y to N in Excel, and import the file back. Sign in to the company file as the admin before you begin.

1. In QuickBooks, open the File menu, choose Utilities, then Export, then Lists to IIF Files.
2. Select Chart of Accounts, then save the file somewhere easy to find.
3. Open Excel, choose File, then Open, and browse to that folder. If the file does not appear, set the file type box to All Files.
4. The Text Import Wizard will start. Accept the defaults on each screen until the sheet opens.
5. Scroll to the bottom of the sheet and find the rows labeled QB ONLINE.
6. In those rows, change every Y to N in four columns: OLBANKING, OLBILLPAY, OLENABLED, and OLTAB.
7. Save the file, agree to keep the current format when Excel warns you, then close Excel.
8. Back in QuickBooks, go to File, Utilities, Import, then IIF Files, and select the edited file.
9. Confirm the success message.

Does Excel import IIF files?

No. Some write-ups of this fix end with a step that tells you to import the IIF from Excel’s own File menu. Excel has no such command, and hunting through its menus for one is a dead end. Excel’s only job here is to open and edit the file. The import happens on the QuickBooks side.

We point this out because the stray step looks like part of the procedure. It is not. Skipping it costs nothing and saves the confusion.

Confirm the feed is off

Export the Chart of Accounts to an IIF file once more and open it in Excel the same way. The four banking columns should now read N in the QB ONLINE rows. In QuickBooks, the marker beside the account name should be gone: no lightning bolt on Windows, no blue circle on Mac. The account now behaves like any account you reconcile by hand.

If a backup prompt appears during that second export, you can cancel it when you already hold a current backup.

The fault sits in the file, not at the bank

The guidance around this issue points to list trouble and possible data damage inside the company file. Re-sorting handles the list side. Verify and rebuild handle file damage. The flag edit covers whatever survives both. Nothing in the fix touches your bank, its portal, or its connection. The leftover flags live in your own data, which is why a local edit clears them.

Keep a backup until the marker is gone

The edit touches your account list, so the backup matters more than usual here. Take one before the export and keep it until the marker disappears and a reconciliation checks out. If anything looks wrong afterward, restoring that backup returns you to the starting point.