Troubleshoot Bank Feeds Web Connect Import Errors: Unable To Import Into QuickBooks

QuickBooks Web Connect Import Errors prompts when trying to import or download the .QBO file from a financial institution or importing transactions from your bank using Web Connect but unable to do so, there may be some issues with your Web Connect. These error problems can also occur when your files in the bank are not completed and have an inaccurate format. Some changes in your bank end might be a reason for causing this error problem. 

Save Time & Effort
Get Help From Expert
Get your accounting work done by experienced accountants. Fix all your accounting software errors & problems. Dial our toll-free number.

You Must Know: Web Connect files are known as .QBO files and are online transactions of your bank that are saved and downloaded on your system.

From here, you can know briefly about your QB Web Connect import errors. Also, you can see, how the error messages appear on your computer screen, just check out below:

  • “QuickBooks found an error. We can’t read the file {Your financial institution} sent.”
  • “An error occurred while processing your online banking data.”
  • “Your data is unable to be imported into QuickBooks.”
  • “QuickBooks is unable to verify the Financial Institution Information for this download.”
  • QuickBooks seems stuck and asks you to select a new or existing account when you try to download.
  • No new transactions error

Signs of Web Connect Import Errors in QuickBooks

Before starting troubleshooting, you must be aware of QuickBooks web connect import errors indications. Know completely from the below:

  • No longer able to import data into QuickBooks
  • Unable to process banking data due to banking issues
  • Issues in verifying the downloaded financial institution information
  • Stuck to work on QuickBooks and asks you to use another account to process your downloads

Also Read: How to Fix QuickBooks Banking Error 102

Possible Causes of Bank Feeds Web Connect Import Errors

We have not listed all the causes here, there may be some left to figure out, but don’t worry these are common ones due to which QuickBooks Web Connect import errors occur. Have a look at it:

  • Due to some wrong information and formatting in the Web Connect files provided by your bank
  • Your bank doesn’t support importing into QuickBooks.

Note: Contact your bank executives to solve the issue entirely as early as you can.

  • If you are importing your .qbo files in an outdated version of QuickBooks that is no longer supported online banking services
  • Due to irrelevant extensions of imported files. You must remember that QuickBooks supported only .qbo extensions rather than others(.QFX, .IIF, .CSV)

What To Do Before Importing Transactions Into QuickBooks

Before you get started importing your transactions into QuickBooks, you must take care of these points listed down:

  • You must create a backup of all your company files(to keep your data secure and restore it at any time)
  • Check your version on which you work then verify that there are no compatibility issues with web connect files
  • You have an updated Internet Explorer(updated to the latest version of I.E.)
  • Pick the right bank account from the drop-down list, if not found then visit the “Deactivate Bank Feeds for an account” section to settle your inactive accounts

How to Fix Bank Feeds Web Connect Import Errors in QuickBooks

To fix your bank feeds Web Connect import errors in QB you have to follow the simple and easy steps mentioned below:

Step 1: Download the Web Connect file Directly from your Bank

In step 1, you have to download your Web Connect file directly from your bank outside of QuickBooks.

  • To begin, click twice on your Internet Explorer to Sign in to your bank’s website with your valid credentials
  • Browse and download the Web Connect file (.qbo file) to QuickBooks Desktop
  • Open QuickBooks and your company files then follow the simple steps to import the .qbo files. Learn from below how to do the following:

1. From the left menu choose File > Utilities > Import > Webconnect files

2. Now Browse to the file location, choose the file, and click on Open.

3. Follow the import wizard to end the importing process.

Note: If any error prompts while downloading or importing the file, this means that there may be something wrong with your bank. Visit your bank and ask your questions to get help.

If the Web Connect import error still continues, move to the next step.

Step 2: Check your File from the Bank

In this step, make sure that the file you have saved from your bank is .qbo file. Only these files are supported by Web Connect. If you have a file other than .qbo file this means your Web Connect is unable to read it and due to this you face import errors. 

For a different type of File:

  • Sign in to your bank website with your valid credentials
  • Then, attempt to download your .qbo files

If you are unable to find .qbo files then reach out to your bank to find it early. Move back to QuickBooks and then follow the same steps you have done in Step 1 to import the .qbo files.

If you have a .qbo file from your bank then move onwards. 

Step 3: Review notifications from your bank

Check your Bank’s Website

If any changes are made to your bank with regards to support offered to their QuickBooks Desktop, they will notify you. To get it to know, do the following:

  • Sign in to your bank website with your valid credentials
  • Then check the notifications related to QuickBooks Desktop
  • If you have nothing to show regarding QuickBooks Desktop there, just move back and close it else follow the instructions defined in the notifications.

Note: If your bank has stopped their services to support Web Connect, just go through the simple steps to disconnect your account. 

To disconnect your specific bank account from your bank, go through the steps to deactivate Bank Feeds listed down. You must remember to contact your financial institution directly for everything else related to your bank accounts.

Step 1: Finish your Online Banking

Ensure that you matched or deleted all of the downloaded transactions for the account before you start deactivating your bank feeds. QuickBooks won’t accept any changes if you have any pending transactions right now.

Step 2: Deactivate Bank Feeds

You are only eligible to disconnect your accounts from Bank Feeds one at a time. You have to perform distinct steps if you are having Windows OS or Mac. Learn what to do and how to do from here.

QuickBooks Desktop for Windows:

  • Visit Lists and then click on the Chart of Accounts
  • Pick the account you would like to deactivate by right-clicking on it. Then choose Edit Account
  • Reach out to the Bank Settings tab
  • Click on the Deactivate all online services and then hit OK to confirm the deactivation 
  • Click on the Save & Close option to end it

QuickBooks for Mac

  • Visit Lists and then click on the Chart of Accounts
  • Spot the account and click on the pencil icon to edit
  • Click on the Online Settings
  • Choose the Not enabled option inside the Download Transactions drop-down menu
  • Choose OK to confirm it, then click on the OK to close the opened window

Important: Once you have disconnected your bank feeds account, QuickBooks is no longer able to download new transactions.

Check your Bank’s website for Requesting the verifications

Several banks have policies that they don’t give permissions to access QuickBooks data until you will verify and confirm your identity yourself after you update your existing QuickBooks to the latest release version. 

To do this:

  • Sign in to your bank website with your valid credentials(including username/email or password) and then check for new messages
  • If you have found something related to the requests just follows their provided guidelines to approve it

If there are no messages will be shown, just move to step 4.

Step 4: Switch your Bank modes

  • Open QuickBooks and click on their Banking menu
  • Flutter over the Bank Feeds and then click on the Change Bank Feeds Mode
  • In the Bank Feeds section, you need to click on the Classic Mode or Register Mode
  • Then follow the same steps we have previously discussed in step 1 to import the .qbo files(Know all from step 1).

If the error still hasn’t been resolved then you have to move forward.

Step 5: Make a Test File

First, you need to check out whether the issue is with your company files or your .qbo files accordingly follow the steps. Check that you can import your transactions into a new company file. To do this, just go through the following listed down below:

  • First, from the File menu, click on the New Company
  • Now click either on Express Start or Start Setup then fill all the required fields. To prevent you from unrecognizing your file advised adding “Test” to the name of your company file.
  • Inside the test company, you have to follow the same steps we have previously discussed in step 1 to import the .qbo files. Importing your transactions inside the same bank account you are having problems with under your main company files.

Go through the other steps to check whether you could import the .qbo file or you couldn’t import the .qbo file into QuickBooks separately. 

If you could import the file

If your transactions will appear inside the test file, means that there may be some issues with your settings. Just move back to your original company file and click on the Reset to reset them.

  • Open your company file(original)
  • Choose the account that you would like to disconnect
  • Then reconnect the account
  • After reconnecting the account, import the .qbo file one more time

Note: If you are now able to import your transactions to the original company files, this means your issue is resolved now. 

If you couldn’t import the file

If your transactions will not appear inside the test company file, means that there may be some issues with your .qbo file from your bank. Just visit your bank to get the right file because your bank and financial institutions well-known how to get rid of these kinds of banking error issues. 

  • Still before connect to your bank executives just check your bank .log files will be very helpful in detecting the error issues
  • Ask for an interactive session with a bank representative having good knowledge of bank feeds or account activation 
  • If you would like to file a case through the Open Financial Exchange, contact your bank executives as early as possible and keep noted your case number.

If your Bank Feeds web connect import error issue still has not gotten resolved then we have some advanced troubleshooting steps for you. Now try to fix your issues with advanced troubleshooting steps briefly described below:

Review the Web Connect File for Errors

  • First, open your .qbo web file which you have downloaded from your bank
  • Right on the .qbo file and then click on the Open with Notepad(or excel)
  • Check whether there is an error issue present in the file such as remove invalid characters, ampersands(&), and other strings. To get it know more see the below:

Example: <Name> Point of Sale withdrawal ARBY&#39;S

Modified to: <Name> Point of Sale withdrawal ARBYS

  • Now add or edit the non appear or missing markups. All the tags in the file must have the following:

<STMTTRN> (This tag must have an end tag)

<TRNTYPE>Check

<DTPOSTED>20141027120000

<TRNAMT>-30.00

<FITID>00xxxxxxxxxxxxxxxx56(Length must be less than equals to 32)

<CHECKNUM> 4526

<NAME> (Tag containing no data but should have) (Length must be less than equals to 32)

<MEMO> (Length must be less than equals to 255)

</STMTTRN> (this is an end tag)

Point to be noted: In case the Payee name field is longer than 32 characters, this means the rest of the information will appear to you inside the Memo Field.

<NAME>ACH DEBIT(AUTO)PAYMENT  ***C

<MEMO>ACH DEBIT(AUTO)PAYMENT  ***CITI CARD ONLINE CITICTP 5/18

Note: You are required to match the payee information inside the Memo Field manually QuickBooks won’t offer the facility to do this automatically.

Check your Bank’s Identification Number

If the web connect files are missing the bank identification information, normally says BID and also all your transactions won’t import.

  • You have to choose your QuickBooks version to get to know about the bank identification number(BID) for your bank either 2020(including US, UK, CA), 2019 and 2018
  • Press and hold Ctrl + F together to find your bank name as well as an identification number
  • Now you have to write down a 5-digit number. Ensure that the following are correct inside your .qbo file just check it now:

<FI>

<ORG> (cannot be left blank) Example: My Bank

<FID> (cannot be left blank) Example: 01234

</FI>

<INTU.BID> (can’t be left blank) Example: 01234

<INTU.USERID> (can’t be left blank) Example: 01234

  • Now save and store the .qbo file
  • In the end, you have to follow the complete steps to create a backup of your QuickBooks company file before you start importing by following the same steps you have done in Step 1 to import the .qbo files. Now do the same to import accurate .qbo files one more time.

You May also like: How to Fix QuickBooks Error 101

Wrapping Up

We have tried every way in this article to explain to you in the best way possible and also give good solutions. But if the error persists or you are still experiencing the error, contact our QuickBooks ProAdvisors through the toll-free number and try the remaining solutions. Connect us right now and schedule your interactive session with our hardworking expert’s team to keep all your error issues and problems away from yourself.

Didn't find your solution?
Don't worry as our team of Certified Public Accountants are here for your help. They have certification & proficiency in QuickBooks, Sage, Xero, Quicken & other accounting software and can help you get rid of your problem. Dial our toll-free number.


Call Now

    Contact our Experts

    Get instant help, advice & answers from our experts