- 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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
I removed all of the &/amps, re-saved the file, and got exactly the same message.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
What QB Desktop year version? 2024?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
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.