Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
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:
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.
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?
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.
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.
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.
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.
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.
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.
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
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!
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.
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!!
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:
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.
Do you have QB Online or QB Desktop?
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
Which QB Desktop year version do you have?
The latest 2024
Do you connect the same bank account to more than one company file?
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here