When you download or import a .QBO file from a supported financial institution through Web Connect, you may get any of the following messages:

User-added image

  • QuickBooks found an error. We can’t read the file {Your financial institution} sent.
  • "An error occurred while processing your online banking data." -OR- "Your data was not imported in to QuickBooks."
  • "QuickBooks is unable to verify the Financial Institution information for this download."
  • "QuickBooks prompts you to select a new or existing account when you try to download"
  • No Error

Web Connect import issues may occur if:

    • The qbo file provided by your financial institution contains an invalid information or formatting. QuickBooks cannot read the data from your Web connect (.qbo) file.
    • Your financial institution does not support import into QuickBooks (fi.intuit.com).
    • You're trying to import a .qbo file into an older version of QuickBooks that no longer supports the online banking service.
    • Your import file is not the correct file type.  Note that QuickBooks only accepts a .QBO file, not a .QFX, .IIF, .CSV, etc.
  • You're not on a supported version of QuickBooks Desktop.

Here are a couple of solutions you can follow to fix your web connect issue. The first solution may solve your problem, or you may need to try all of them. For best results, perform the solutions in the order shown.

Important

  1. Always back up the QuickBooks company file prior to any import.
  2. Ensure that you're using a supported version of QuickBooks and Internet Explorer to prevent any issues when importing web connect files.
  3. As a standard troubleshooting step, switch to Register (Classic) mode to perform the same action (applies to US only). If you get the same results, proceed to Solution 1.
    1. From the Edit menu, go to Preferences.
    2. On the left pane, choose Checking then go to the Company Preferences tab.
    3. In the Bank Feeds section, select the Classic Mode (Register Mode) radio button.
    4. Select OK.

Solution 1: Download directly from the banks website (outside of QuickBooks)

  1. Visit your bank's website outside of QuickBooks.
  2. Download and Save the .QBO file to your Desktop.
  3. In QuickBooks, using the main menu across the top, select:
    1. File > Utilities > Import > Webconnect files...
    2. Browse to the file location, choose the file and select Open.
    3. Follow the import wizard to complete the import.

If the import fails, proceed to Solution 2.

Important: A .QFX file is a financial data file format used for importing data into Quicken financial software and can not be imported into QuickBooks. If your financial institution doesn't offer Online Banking for QuickBooks, they can sign up at http://fi.intuit.com.

Solution 2: Duplicate the issue in a new test file

  1. From the QuickBooks File menu, select New Company.
  2. Choose Express Start.
  3. On the newly created test company, add your bank account to the Chart of Accounts.
  4. Set up the account for Bank Feeds.
  5. Download or import the .qbo file.

If the import is successful in a new test file: the issue lies in the original data file.

  1. If you've ever successfully imported transactions from the problem bank account to this company data file (.QBW):
    1. Reset the problem account in QuickBooks by deactivating the online connection.
    2. Re-establish the connection to the bank by importing the webconnect file.
  2. Resolve data damage on your company file.

If the import fails in a new test file: the issue is with the .QBO file formatting provided by your bank.

  1. Contact your financial institution to report the problem.
  2. Proceed to Solution 3 to review the .QBO file for errors and self correction.

Solution 3: Review the web connect (.qbo) download for obvious errors

  1. Download and Save the .qbo file to your Desktop.
  2. Edit the .QBO file: Right-click > Open with > Notepad (or Excel).
  3. Review the download for common errors.

    Remove invalid characters. Check the file for ampersands (&) and other invalid character strings such as:

    User-added image

  4. Add or Edit missing data.

    All Tags should have data.

    User-added image

    If the Payee name field exceeds the character limit (<=32), the remaining Payee information will appear in the Memo field. QuickBooks cannot auto-match payee information appearing in the Memo field. These transactions need to be manually matched.

    User-added image

    If your .QBO download file is missing the bank identification information (BID), the transactions will not import.

    1. Select your QuickBooks version to find the unique BID information for your bank:
    2. Use Ctrl + F on your keyboard to search for your banks official name. Jot down the 5 digit number in the left hand column for entry as shown below.

      User-added image

  5. Save the .QBO file.
  6. Make a backup of your data file before importing.
    1. Test importing the corrected .QBO file in to the Test file created in Solution 1.
    2. Report the formatting errors to your bank for resolution in future downloads.

Solution 4: Contact the bank

Banks have a support channel: All U.S. and Canadian financial institutions that currently support QuickBooks Online Banking have an escalation path to the Online Connectivity Group at Intuit via https://fi.intuit.com/.

  • Collect Bank Feeds log files before contacting the bank. The Connlog file helps pinpoint the origin of the connection failure or error.
  • For proper assistance when contacting your bank, ask to be transferred to a bank representative familiar with QuickBooks Bank Feeds and account activation.
  • Have the agent verify your account(s) are activated for the services you require for QuickBooks (not Quicken).
  • If the issue remains unresolved, ask the bank representative to escalate the case via  https://fi.intuit.com/ for resolution. Take note of your case/ticket #.

Identity Confirmation Request

Important: This may be required after installing a new version of QuickBooks or an update to your current version.

Most banks require identity confirmation prior to accessing data from PFM (Personal Financial Management) software. To satisfy the bank security requirement, log in to your account outside of QuickBooks and check your Message Center or Notifications inbox for details. If needed, contact your bank directly for instructions.