Troubleshoot Online Banking Webconnect import issues and errors
When downloading or importing a .QBO file from a supported financial institution, an error message occurs (OL-222) or nothing happens.
- Error: OL-222
- "An error occurred while processing your online banking data."
- "Your data was not imported in to QuickBooks."
- "QuickBooks is unable to verify the Financial Institution information for this download."
- No error
This article guides you through the basic troubleshooting steps to will help you isolate the cause of the problem and possibly resolve it.
Why this is happening
- 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 in to QuickBooks (fi.intuit.com).
- You're trying to import a .qbo file in to an older version of QuickBooks that no longer supports the online banking service.
- Your import file is not the correct file type. (.QFX, .IIF, .CSV, etc.)
How to fix it
Intuit recommends several solutions for this problem. The first solution may solve your problem, or you may need to try all of them to resolve the issue. For best results, perform the solutions in the order shown.
- Always make a backup of your Company file prior to any import.
- As a standard troubleshooting step, switch to Register (Classic) mode to perform the same action.
- If you get the same results, proceed to Solution 1.
- From the Edit menu, go to Preferences.
- On the left pane, choose Checking then click the Company Preferences tab.
- In the Bank Feeds section, select Classic Mode.
- Click Ok.
- Visit your bank's website outside of QuickBooks.
- Download and Save the .QBO file to your Desktop.
- In QuickBooks, using the main menu across the top, click:
- File > Utilities > Import > Webconnect files...
- Browse to the file location, select the file and click Open.
- Follow the import wizard to complete the import.
If the import fails: proceed to Solution 2.
Note: 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.
- From the QuickBooks File menu, click New Company.
- Click Express Start.
- On the newly created test company, add your bank account to the Chart of Accounts
- Set up the account for Bank Feeds.
- Download or import the qbo file.
If the import is successful in a new test file: the issue lies in the original data file.
- Run the Verify Data utility to check for data damage. Refer to Resolve data damage issues (basic troubleshooting) for details.
- If you've ever successfully imported transactions from the problem bank account to this company data file (.QBW):
- Reset the problem account in QuickBooks by deactivating the online connection.
- Re-establish the connection to the bank by importing the webconnect file.
If the import fails in a new test file: the issue is with the .QBO file formatting provided by your bank.
- Contact your financial institution to report the problem.
- Proceed to Solution 3 to review the .QBO file for errors and self correction.
- Download and Save the .qbo file to your Desktop.
- Edit the .QBO file: Right-click > Open with > Notepad (or Excel).
- Review the download for common errors.
Remove invalid characters. Check the file for ampersands (&) and other invalid character strings such as:
- Add or Edit missing data.
All Tags should have data.
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.
If your .QBO download file is missing the bank identification information (BID), the transactions will not import.
- Save the .QBO file.
- Make a backup of your data file before importing.
- Test importing the corrected .QBO file in to the Test file created in Solution 1.
- Report the formatting errors to your bank for resolution in future downloads.
Information Source: Intuit Community Answers