Question

Error Code: OL-222

Forum|Forum|3 years ago
December 7, 2022
3 replies
0 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

@sfvaughan

What QB Desktop year version? 2024?

Yes. Accountant Plus, latest release. And we're not having this issue with any other of the dozens of banks connected the same way. And not with Truist until mid-day yesterday. Successfully imported multiple .qbo files from Truist as recently as yesterday morning, even another Truist account for the same client/file.

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