How to Delete Bank Feed in QuickBooks Desktop & Online?

Errorgenie-How to Delete Bank Feed in QuickBooks

QuickBooks provides an online banking feature for its users that is called Bank Feeds. This feature lets you connect to the banking institution so you can easily download the transactions. However, for some reason, you may want to stop importing transactions. For this, you will have to deactivate the bank feeds for the account. For more information, learn with us how to delete bank feed in QuickBooks Desktop.

Furthermore, we will draw your attention to how to disconnect a bank account from QuickBooks Online and how to fix the issues that you may encounter when deactivating bank feeds.

Why Do You Need to Disconnect Bank Account from QuickBooks Online/Desktop?

There are some advantages of using the Bank Feeds feature as you can process credit card and bank transactions efficiently and take advantage of other online services. This gives you more time to handle other business requirements. However, there can be certain reasons for disconnecting the account from the bank.

Here are the following reasons for which you may have to delete or deactivate the bank feeds in QuickBooks Desktop:

  • If you are not willing to import transactions from the bank to QuickBooks, you can deactivate the bank feeds feature.
  • When the bank no longer supports bank feeds, you need to disconnect the bank feeds in QuickBooks.
  • Sometimes you delete the bank feeds when you want to cancel the accounts with the banking institution.

These could be the scenarios when you want to deactivate your bank feeds in QuickBooks Desktop. In case you have any queries regarding your accounts, you can directly contact your banking institution.

How Do I Delete a Bank Feed in QuickBooks Desktop?

To delete the bank feeds in QuickBooks Desktop, one has to finish online banking. You will have to download all the transactions and match them. Thereafter, you can deactivate the bank feeds feature in QuickBooks. This will not let QuickBooks download any new transactions. Find out more details and learn  how to delete bank feed in QuickBooks Desktop:

Step 1: Complete the Online Banking

Before you deactivate the bank feeds, one has to match or delete all your transactions downloaded for the account. If there is any pending transaction, QuickBooks will not let you edit it. To download, review and match the transactions, you can perform the following steps in QuickBooks:

Download the Transactions to QuickBooks

There are different ways for downloading the transactions depending on how you have connected to the bank. For instance, you can download the transactions by using Direct Connect and Web Connect (by using QuickBooks or outside of QuickBooks).

Method 1: Direct Connect
  • Open the “Banking” tab.
  • Hover the mouse over the “Bank Feeds” option.
  • Choose the “Bank Feeds Centre” option.
  • Switch to the “Bank Accounts” list. From here, you can select the account you wish to connect to.
  • Go to the “Send items to your bank” section. Here, you can make changes or remove the item by using the drop-down menu.
  • Once done, you can click on the “Download Transactions” option.
  • Now, click the “Synchronize” option.
    • If you want to download the transactions for a particular account then click on the “Sync this account” option.
    • If you want to download the transactions for all the accounts at your same bank then hit the “Sync all for this Bank” option.
  • Move to the “Access to” window and add your “PIN” or “Password” in order to connect to the bank.
  • After that, click the “OK” button.
Method 2: Web Connect
  • Select the “Banking” menu.
  • Hover the mouse over the “Bank Feeds” option.
  • Click on the “Bank Feeds Center” option.
  • Here, you can search for the bank and click on the “Download Transactions” option. This will take you to the browser to the bank website. Thereafter, you can login to the account by entering the ID and password.

You can also use the Web Connect method outside of the QuickBooks Desktop. In addition, you can sync the transactions from different accounts of the bank. Once you are done downloading the transactions, you can review them and match the transactions.

Match the Transactions

Once the transactions are downloaded, QuickBooks classifies them into three categories. However, it depends on what information QuickBooks collected from the bank transactions. The process of reviewing the transactions will be different depending on the banking mode you are using currently. It could be Advanced Mode, Classic Mode, or Express Mode. You can match the transactions manually as well.

Step 2: Disconnect Bank Account from QuickBooks

To deactivate the bank feeds from QuickBooks, you need to make changes to the bank settings and deactivate all online services. To know how to delete bank feed in QuickBooks Desktop, you can perform these steps on Windows and Mac systems.

How to Delete Bank Feeds in QuickBooks Desktop on Windows?

  • Click on the “Lists” menu.
  • Then, choose the “Chart of Accounts” option.
  • Click right on the account you need to remove.
  • After this, click the “Edit Account” option.
  • Select the “Bank Settings” tab.
  • Click on the “Deactivate all online services” option.
  • Press the “OK” button to confirm your action.
  • Click the “Save & Close” button.

How to Delete Bank Feed in QuickBooks Desktop on Mac?

  • Open the “Lists” menu.
  • Now, click on the “Chart of Accounts” option.
  • Here, you can highlight your account and click the “Pencil” icon so you can edit the details.
  • Click the “Online Settings” option.
  • Move to the “Download Transactions” drop-down list.
  • Choose the “Not Enabled” option.
  • Hit the “OK” button to confirm.
  • Click “OK” again to finish the process.

This is how you can disconnect your account from bank feeds. This should be remembered, once you deactivate bank feeds, QuickBooks will not download any new transactions.

How Do I Disconnect My Bank Account from QuickBooks Online?

If you are not willing to download new bank transactions, you can disconnect your bank account from QuickBooks Online. If required, you can delete the duplicate transaction from bank feeds and exclude the downloaded transactions.

To understand the whole procedure, you can learn here how to disconnect a bank account from QuickBooks Online:

Option 1: Disconnect the Bank Accounts in QuickBooks Online

To disconnect the bank accounts, you can go through the Banking tab and make the required changes to the account. Here are the detailed steps for the same:

  • Click on the “Banking” option.
  • Then, choose the “Banking” tab.
  • After that, pick the tile for your bank account.
  • Now, click on the “Pencil” icon.
  • Here, choose the “Edit account info” button.
  • Once done, click on the “Disconnect this account on save” option. You might not see this option if your accounting system is currently downloading the new transactions. In such moments, you can wait and try later once the update is completed.
  • Press the “Save and Close” button.

By following these steps, you can easily disconnect the bank account from QuickBooks Online. If required, you can reconnect the bank later to download the transactions.

Option 2: Duplicate Transactions from Bank Feeds in QuickBooks Online

In case you have duplicate transactions in QuickBooks, you can delete them in the Side-by-Side mode. Ave a look at the following instructions:

  • Click on the “Banking” menu.
  • Then, select the “Bank Feeds” option.
  • Choose the “Bank Feeds Center” option.
  • Switch to the “Items Reviewed” field, choose the account that has the transaction you wish to remove.
  • Once found, you can choose the item to remove them.
  • Here, you can choose the transactions you wish to delete.
  • Press the “Delete” button.

If you have many transactions, you can delete the transactions in bulk. This way you can easily remove the duplicate transactions in QuickBooks.

Option 3: Exclude the Downloaded Transactions in QuickBooks Online

You can also delete the transactions that are downloaded in your QuickBooks Online account. This way you can clear all the bank transactions from your account. Check out the following steps to understand better:

  • Click on the “Banking” menu.
  • Then, choose the appropriate bank.
  • Select the “For Review” tab.
  • After this, mark the transansactions you need to remove.
  • Once done, click the “Batch actions” option.
  • Press the “Exclude selected” option.
  • Switch to the “Excluded” tab.
  • Now, mark the transactions you wish to delete.
  • Here, click on the “Batch action” option.
  • Click the “Delete” button.
  • When you see the confirmation prompt, click the “Yes” button.

By following these steps, you can easily remove the downloaded transactions in QuickBooks Online.

What If You Encounter Issues When Deactivating the Bank Feeds in QuickBooks?

There can be instances when you deactivate the bank feeds for the account, the blue circle in Mac and the lightning bolt in Windows disappears located beside the bank account’s name. If these icons still appear, it indicates that the bank feeds option is still active. When you fail to deactivate the bank feeds in QuickBooks, you can perform the troubleshooting methods.

For instance, you can re-sort the list, run the verify & rebuild data utility, or try deactivating the bank feeds by using the Excel sheet. Let us help you with detailed instructions so you can easily deactivate the bank feeds for the account.

Fix 1: Deactivate the Bank Feeds with Excel

If you are unable to deactivate the bank feeds, you can do it manually. For this process, an Excel sheet will be required. All you have to do is export the Chart of Accounts, edit the IIF file in Excel, and import the IIF file to your QuickBooks account. Have a look at the detailed steps:

Please Note: Before moving forward, you need to click on the File menu and choose the Switch to Single User Mode.

Step 1: Export the QuickBooks Chart of Accounts

  • Make sure you are logged into the company file as an administrator.
  • Click on the “File” menu.
  • Select the “Utilities” option.
  • Press the “Export” option.
  • Click on the “Lists to IIF Files” option.
  • Click the “Chart of Accounts” option.
  • Hit the “OK” button.
  • Here, you can browse where you wish to keep your file.
  • Once done, add the file name and click the “Save” button.

Step 2: Edit Your IIF File in Excel

  • First of all, launch “Microsoft Excel”.
  • Then, select the “Open” button.
  • Here, you can browse the folder to which you save an IIF file. If you are unable to find the file then click on the “All Files” by using the “File type” drop-down arrow.
  • Once found, click the “Open”.
  • When you see the “Text Import” wizard,click the “Next” buttons.
  • Click the “FInish” button.
  • Scroll down to “QuickBooks Online”
  • Here, you can change the “Y” to “N” for the following banking columns:
    • OLBANKING
    • OLENABLED
    • OLBILLPAY
    • OLTAB
  • Click the “File” menu.
  • Select the “Save” button.
  • Later, you can confirm that you wish to preserve the currency format and then you can close the “Excel” sheet.

Step 3: Start Importing the IIF File to Your QuickBooks

  • Launch “QuickBooks”.
  • Click the “File” menu.
  • Choose the “Utilities” option.
  • Click on the “Import” option.
  • Choose the “IIF Files”.
  • Here, you can browse the location for the IIF file.
  • Once found, pick the “IIF File” and then hit the “Open” button.
  • Press the “OK” button.

As you follow these steps, the IIF file will be imported successfully. Similarly, you can deactivate the bank feeds manually on a Mac computer.

Fix 2: Resort the Lists

By re-sorting your list, you can reset the list order. This will make the account return to the default order and undo your changes. In the following discussion, we will show you how to re-sort a list in QuickBooks for Windows and Mac users.

Resort Lists in QuickBooks on Windows

  • Click on the “Lists” menu.
  • Choose the list you want to re-sort.
  • After this, click on the “Include Inactive” option. If you see it in grey colour, it indicates there is no inactive item.
  • Now, click on the “View” menu.
  • Then, choose the “Re-sort Lists” option.
  • Press the “OK” button.
  • Now, close the company file and reopen it.

Resort Lists in QuickBooks on Mac

  • For Customer List
    • You can click on the “Customer Centre” menu.
    • Then, click on the “Edit” button located at the top.
    • Press the “Re-sort List” option.
    • Click the “OK” button.
  • For Master Names List
    • Click on the “Banking” menu.
    • Then, choose the “Write Checks” option.
    • Now, place your pointer on the “Pay to the Order Of” section.
    • Press the “cmd ⌘+L” keys together.
    • Here, select the “All Names” option.
    • Click the “Edit” button located at the top.
    • Press the “Re-sort List” option.
    • Press the “OK” button.
  • For Chart of Accounts, Classes, or List
    • Open the “Lists” menu.
    • Then, click on the preferred option; “Chart of Account”, “Classes”, or “Items”.
    • Press the “All Names” option.
    • Click the “Edit” button located at the top.
    • Select the “Re-sort List” option.
    • Hit the “OK” button.

This is how you can re-sort the list in QuickBooks on Windows and Mac computers. These steps will repair the issue and allow you to deactivate the bank feeds successfully in QuickBooks Desktop.

Fix 3: Run the Verify and Rebuild Company File

If there is any damage, you can verify it by running the Verify Data Utility. If it detects any error, you can repair it by using the Rebuild Data Utility. These steps can be performed on Windows and Mac computers.

  • Click on the “File” option.
  • Then, hover the mouse over the “Utilities” option.
  • Click on the “Verify Data” option. If you find any errors for the data, you can run the rebuild data utility.
  • To run the “Rebuild Data Utility” you can again go to the “File” menu.
  • Go to the “Utilities” menu and click on the “Rebuild Data” option.

This way you can detect the data issues and repair them instantly. You can also use the QuickBooks File Doctor tool to repair the company file.

Conclusive Words

Although there are numerous benefits of connecting bank feeds for the account, you may still need to deactivate it to stop transaction import. Here, we have shown you how to disconnect bank account from QuickBooks Online and QuickBooks Desktop. In case you confront any errors when deactivating the bank account, we have also provided some helpful solutions.

To remove the bank account or vendor profile from QuickBooks, you can check out the following guides:

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments