Question

Error Code: OL-222

Forum|Forum|3 years ago
December 7, 2022
3 replies
8 views

Hi,

I keep getting Error Code: OL-222 when trying to import a bank .qbo file. I've checked for updates, tried to fix the issue with the QB Tool Hub, and have repaired QB via the Windows Control Panel a couple times. This runs through the repair and says it has been fixed. When I open QB, it goes through the update process, downloads and installs files, but nothing has fixed it. Does anyone have any suggestions?

Using QuickBooks 2020 Pro

Windows 10

Thanks

QuickBooks Desktop

Adrian_A

Level 8

Let's get rid of the error so you can import transactions successfully, jaynew.

The Error OL-222 you're getting means QuickBooks didn't receive a valid response from the financial institution's server. This happens when you try to import one or more characters.

You'll want to correct the unsupported characters in the .QBO file which causes this error:

Right-click the .QBO file and select Edit.
Select any text editor app to open the file.
Find and remove &amp from the text as it is an invalid character.
Save the file again.

Visit this article for more details on how to fix Error OL 222 in QuickBooks Desktop: Error: OL-222 after downloading a Web Connect file from an approved bank.

Otherwise, use Excel to edit the .QBO file and search for a QBO to CSV converter online. (Like the one Fiat Lux - Asia suggested) After editing the file, make sure to convert it back to .QBO file format.

If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.

Anything else you need help with can be answered here in the Community. Just let me know and I'd be happy to assist.

sfvaughan

I removed all of the &/amps, re-saved the file, and got exactly the same message.

sfvaughan

Hello there, sfvaughan.

I appreciate your effort and for sharing the steps you’ve already taken to resolve Error OL-222. Since the issue persists despite these attempts, the problem may involve deeper formatting issues within the file or a compatibility issue with QuickBooks.

Before proceeding with additional troubleshooting, kindly ensure the following:

Back up your QuickBooks company file to ensure your data is secure.
Update QuickBooks Desktop to the latest release to ensure compatibility with your bank's systems.
Confirm that you’re using a supported version of QuickBooks.

Once these steps are completed, I recommend reaching out to the QuickBooks Live Support Team for specialized assistance. They can take a closer look at the problem, troubleshoot potential software-related issues, and guide you further in resolving this error.

Here’s how to contact QuickBooks Live Support:

Go to Help in your QuickBooks Desktop.
Select QuickBooks Help.
Click Contact Us.
Provide a brief description of your issue, then select Continue.
Sign in to your Intuit account, select Continue, then choose Continue with my account.
QuickBooks will email you a single-use code. Enter the code and select Continue.
Choose whether to Chat with us or Have us call you based on your preference.

Additionally, I suggest contacting your financial institution to verify the formatting of the original .QBO file and ensure it’s configured correctly for use with QuickBooks.

Please don’t hesitate to reach back out if you have questions. We're here to support you every step of the way.

Thanks. I've already run a Rebuild and reset/reinstalled all updates. Unfortunately I don't have time to also sit on the phone with Intuit, as that usually ends up being a pretty extensive time commitment.

A

Antitango

Ok, the short version of my story... QBO import file to desktop has stopped working for me. I do my bookkeeping in 1 session a year, January- February. Well, it didn't work in '24 for FY23.

WHY? after 24 hrs of studying and banging my head, i reached a nice young lady who informed me my 2020 MAC Desktop version didn't support this feature anymore. If you cannot find QB Help desk phone, it is 800-956-4442.

SO, if you are reading this and still struggling with OL-222 error, first make sure you have a supported version of QB Desktop. If you don't, the above information is useless! Mine is currently 2020 for MAC and this is Feb 2024. Apparently this feature was discontinued in May of 2023.

If you didn't know it, QB wants you to use QB Online. It's better for them and they claim it's better for you. But, in many cases, it isn't. I have heard this from experts outside QB and studied it a little. So, these money grabbers won't get my $300 until next year as I will just hand enter my 2023 detail over the next 4-5 days and show them who's the boss! Happy QBing everyone!

Fiat Lux - ASIA

Level 14

@Antitango

You need to run the bank feeds again on your QB Desktop Mac, correct?

I can share an option to explore. Contact me in private for details.

S

Sabinaell

I have tried removing the &amp didn't work. I just tried to import one day of my back statement that didn't not have any special characters in it and still got the error code. I am so frustrated - I was on the phone with QBO support they couldn't help - I talked to men bank they could not help. If this error code does not go away the software is useless. I have to hand type in all my bank statments as I did in the privious years as this error is not getting solved why even work with QBO? I would really like this issue solved it is huge problem!!

M

MEACCTant

I Right clicked my file and selected edit to compare to a file that worked. What i found is my new file did not have the ending bank balance and date. I corrected that info and the file worked.

File that didnt work had the following:

corrected this to the following:

<BALAMT>301689.03
<DTASOF>20241009120000

I suggest compare an old file that worked to the new file and look for the difference. I went line by line and this was near the bottom of my webconnect file.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded