- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Error Code: OL-222
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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 & 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Hi,
Thank you for the reply. I opened the file with both Notepad and Excel, and did not find an instance of "&" using either app. Is there something else I can try?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Thanks for trying the steps shared by my peer, @jaynew.
This error code means that there are characters unrecognizable from QB in the Name field on the .QBO file from the Bank system, such as:
<NAME>ETIQUETTE PROSCAN</NAME>
To get this file read into QB, I'd recommend you manually remove all of the following characters in the "NAME" fields : * . , : / And double space " ".
Keep in mind also that if a Payee name field is longer than 32 characters, the rest of the info will go to the Memo field.
For more troubleshooting steps, check out this article: Fix Web Connect import errors.
Get back to us if you have additional concerns about using web connect. We're always here to help.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Hi Katherine,
Thanks for the reply. I see many instances of "NAME" throughout the file, such as this:
<NAME>Check #10366
</STMTTRN>.
Do you suggest I remove all '/' from </STMTTRN> ?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Hi,
I found this:
<NAME>GC<>PLAYOUTONE PL-DHBQTDC CCKE
Is the '>' what needs to be deleted? Or is it every instance of the '&' sign?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Thanks for getting back to us, @jaynew.
I'm here to provide clarification.
You have to remove the special characters in order to get this file read from QBO.
Additional troubleshooting steps are also provided here: Fix Web Connect Import Errors.
If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.
Don't hesitate to comment down below you need help with can be answered here in the Community. Just let me know and I'd be happy to assist.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
For the record, the special character that messed up my file was "¦" as in
SQ *BAR 21 LTD ¦ CAFE-119 WEST
Just delete the "¦" and the file worked again.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
For the record, the special character that messing up my file was "¦" as in:
SQ *BAR 21 LTD ¦ CAFE-119 WEST
Just delete the "¦" and the file worked again.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Thank you! This worked. I first got rid of the & and then removed the |.
This was making me crazy thinking I was going to have to manually input all the transactions if I couldn't find a fix.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
I have tried removing the & 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!!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
We know how urgent it is to fix this concern at your end. It is not the service that we want you to experience. I have some valuable insights to shed light on this matter, @Sabinaell.
When you encounter an error while trying to upload a file into QuickBooks Desktop, it is due to an unsupported file format such as .csv, .txt, or .docx, or if the file contains special characters like ampersands, plus signs, minus signs, or equals signs. If this is the case, you need to edit the file to remove these characters.
If the issue is related to an unsupported file format, you can use a converter tool to change it to a .qbo file. For more detailed troubleshooting steps on fixing bank import errors, refer to the article: Fix Web Connect import errors.
It's important to note that this error can only occur when using QBDT and not QBO. Since you mentioned that there are no special characters in the file, I recommend reaching out to our QuickBooks Desktop team to investigate this matter. Here's how you can do that:
- In QuickBooks, click Help and choose QuickBooks Desktop Help/Contact Us.
- Hit Contact Us.
- Put an explanation regarding your concern and select Continue.
- Use your Intuit account and hit Continue, then Continue with my account.
- Enter the code that we email you and tap Continue.
- If done, decide either to Chat with us or Have us call you.
To see the availability of our team support, see this as a guide: Contact QuickBooks Desktop support.
If you encounter other bank feed errors in the future, this link might be helpful: Fix OL and OLSU Bank Feeds errors in QuickBooks Desktop.
If you find yourself in need of assistance with importing bank feeds in QBDT , comment down below. We'll be right back to guide you. Take care.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Do you have QB Online or QB Desktop?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
I was on the phone last week for more that two hours with the Mac desctop team and they we were not able to solve the issue. I am downloading a QBO file ONLY. I am using not ANY other files.
I have this issues since years. It would be great to get it solved. I am sure I am not the only one.
Thanks,
Sabin
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Which QB Desktop year version do you have?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
The latest 2024
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Do you connect the same bank account to more than one company file?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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:
<BALAMT>
<DTASOF>
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.