OL-222 error from TCF Bank .qbo file since 03/07/2020. Test company, same. Bank say no changes on thier end. Pre 03/07 .qbo files-no error. Anyone having same issue?

Hello @tnecaboard1,

Currently, we don't have a similar case reported about the OL-222 from TCF Bank.

This is error is often caused by one or more characters in .QBO file that isn't compliant with the Open Financial Exchange (OFX) standard for exchanging financial data with QuickBooks. Sometimes, it's an incorrect format of your .qbo file.

Let's start our troubleshooting by updating your program to the latest release. Here's how:

1. Go to Help, then Update QuickBooks Desktop.
2. Select Update Now tab, then mark the Reset Update box to clear all previous update downloads.
3. Click Get Updates to start the download.

After that, restart your computer and import your .qbo file again. Please see this article for more information about the OL-222 error after downloading a Web Connect file from an approved bank.

I'm also adding our page about bank and bank feeds for future reference.

Should you have questions or other concerns, please let me know. I'd be sure to jump in as soon as I can. Thanks for posting and happy weekend.

I have found that, by excluding a particular days transactions from the .qbo file uploaded from TCF Bank, the OL-222 error is eliminated.  This supports the suspicion that there is a rogue character in the data from one of those transactions which I will continue to look for.

Alas, it appears the problem still exists in a file that contains some new transactions after 03/11/2020.  Therefore, I am forced to continue to work with the bank.

Hey there, Tnecaboard1.

So you're still getting these errors when you importing new files from your bank? If you haven't found the source to the issue or have any questions please let us know how we can help.

I have the same issue with TCF bank. I have edited the file and I don't see any invalid characters.  I am only using this method because the bank import stopped working about a month ago. I'm wondering if something changed when they merged with the new bank. If anyone knows the answer, I would appreciate hearing back.

Hi there, @Rblum.

When importing your QuickBooks file, you’ll want to make sure the accounts name from the file and Chart of Accounts are the same.

You can go to the Company menu then Chart of Accounts to double-check the transactions. Once done, try the process again.

If the issue persists, I recommend contacting our Customer Support team to check and assist you further. They have tools that can identify the cause of this issue.

Simply press F1 to route you to Contact us section and choose to Get a callback.

In case you need more ideas to organize your QuickBooks account, please see this link as your future reference: Help article.

Come back to me if you have an additional concern. I’ll be more than happy to assist you.

That is when my problem has started. I have tried everything, with no avail.

You can get in touch with us by starting a message, madpiroman. 

I appreciate your time and effort to get rid of the issue. We can open a case for you so our engineers can look into the root cause of the issue. You can follow the steps provided by my colleague above on how to contact us. Then, click Start a Message to connect. 

Feel free to get back to us if you need more help. Keep safe!

So I was able to download my banking info up to March 10th. After those dates I keep getting the OL-222 code. I have called QuickBooks help center, they advised me to call my bank. My banks only advise was to update my web browser.

Can you please help me?

jack

I'm here to help you get past this error, madpiroman.

The OFX/QBO (Web Connect) format is the most frequently used format as the majority of bookkeeping is bank and credit card related activities. Many banks allow downloading .QBO files from online banking. This error usually occurs when you try to import your .QBO file from your bank’s legit website.

Below are the possible reasons why you're getting the QuickBooks banking error OL-222:

• In server response, a scan error received
• Unsupported characters in .QBW file that defies Open Finance Exchange (OFX) standards (OFX defines the standards for exchange between the financial institutions and QuickBooks).
• Irregular formatting of QuickBooks company file may also lead to the QuickBooks banking error OL-222

To get this resolve, updating the QuickBooks Desktop release version is a good start when it comes to fixing program-related issues and make sure to create a backup copy of your company file.

Once done, rectify the .QBO file format and try to import the transactions again. Here's how:

1. Right-click the .QBO file and select Edit.
2. Choose any text editor app to open the file.
3. Find and remove &amp from the text as it is an invalid character.
4. From the File tab click Save.
5. Close the file and open it again in QuickBooks.

If the problem persists, you can visit this article and follow the next troubleshooting steps (proceed to Solution 3): Error: OL-222 after downloading a Web Connect file from an approved bank.

Please get back to me if you continue to get the same results so I can look further into this. Keep safe and have a good one!

I sent a message to TCF bank and they said they were aware of the problem and they were working on it to fix it.

I've been having this problem with TCF bank too. I tried just uploading one day at a time and it all works fine until 3/11. Thank you for contacting TCF. I will contact them as well as I have been very frustrated over the years by their lack of action when they make errors. I will check back here if I learn anything new.

I have been having this problem with TCF too. I have tried all the fixes above. I uploaded one day of transactions at a time and discovered the problem begins on 3/11/20. I'm glad you reached out to TCF. I will as well as I have found over the years that they are slow to respond to problems on their end. Not super impressed with them, unfortunately. 

I am having the same issue.  Do you have a contact name/dept or reference number so that I can "pile on" with TCF.   Their "help" desk wants to push back on it being a QB error.   I'm glad I found this thread.  

So its been two weeks since the last post.  Has anyone had any luck?  

Thanks!

I followed their instructions, including their instruction to “not hesitate to reach out to us if you require additional assistance ([removed])”.  Despite calling during the time the Automated Message says they are open, the TCF Support Center appears to only be reachable by Voice Mail.  I have left message and, at this point, the only options I have are to wait for a call back or change banks.  I’m seriously considering the latter.

Good news and bad news.  Bad news is that I have not heard back from TCF Bank.  Good news, the uploads are now working again.

I received the same error but not for TFC bank.  My bank was BMO Harris.  After trying the items listed on the treads I started downloaded day by day.  Found the problem to be specific to one day where there were several transactions on the banks website without a description.  After skipping this day I was able to import all the other transactions.  Manually entering one day is definitely better than the whole month.  Hope this helps someone.

I was dealing with the same issue and narrowed it down to a specific transaction on one day that wouldn't download. I opened the qbo file in notepad and found a blacked out question mark character after the business name from where the transaction was from. I deleted the unsupported character, added a space in place of it, saved it, turned the file back to a .qbo, then it downloaded with no error. See below.

L2G*ARDOCORDER�415-473 415-473-6<MEMO>

I am having the same issue.  When I go to Import a WebConnect file, some days it works and some days it doesn't.  I haven't been able to identify a trend.  Very Frustrating!  My bank says it is a QB issue.

Have you been able to get this fixed?  I am having the same issue and bank is saying it is QB problem and I am noty getting help with this.

Thanks for posting here, @ssbauer,

I know how it can be frustrating to be held up like this when you just want to use the bank feeds without any issues.

Error OL-222 indicates that QuickBooks didn't receive a valid response from the financial institution's server. A parsing error occurred in the server response. This is often caused by one or more characters in the bank file that aren't compliant with the Open Financial Exchange (OFX) standard for exchanging financial data with QuickBooks.

Irregular formatting of QuickBooks company file may also lead to the QuickBooks banking error OL-222. Make sure to double-check any invalid text on the file before importing them to QuickBooks.

If the same error comes up, I recommend contacting our Support Team for further troubleshooting. To contact us, follow the steps below:

1. On your QuickBooks company file, click the Help menu.
2. Tap the QuickBooks Desktop Help option.
3. Press Contact us on the pop-up box.
   
4. Click on the Search for Something else button then type your concern in the Ask us anything box.
5. Hit Search, then scroll down to get your contact options.

I'm also adding this article about our contact options and support availability for your reference: Contact QuickBooks Desktop support

Please post here again after contacting us. I want to make sure this is taken care of and I'll be right here if you need any help with QuickBooks.

I am having the same 0L-222 error, but it is a different bank; S. Bank and Trust. Spoken to them twice, but I am the only one have any issues according to their management. It started on 03/08/2021. Everything has been functioning seamlessly for years. I have opened the file with notepad and searched for "&amp" using Control+F. I didn't find anything. I searched for blacked out ? marks. Again, nothing. I visually searched for anything unusual in the file, but I do not see anything out of the ordinary or missing. I verified the data by using File/ Utilities/ Verify Data. It said that the file was okay. Has anyone found a  solution for this problem?

Hi @Reagan78757,

Thank you for this very detailed post. I'll provide the steps you need to take, so you can get help on this matter.

Since you already went through the troubleshooting above, I suggest you contact our Technical Support team for further assistance. They can pull up your account within a secure environment, and investigate this matter for you. 

See this article for the steps: Contact QuickBooks Desktop support. I also suggest you take note of their operating hours, so you know when they're available. 

In case you encounter similar bank feed errors in the future, keep this article for your reference: Fix OL and OLSU Bank Feeds errors in QuickBooks Desktop. 

Tap the Reply button and post a comment below if you have additional questions about bank feeds in QBDT. I'll be around to help you out. 

SOLUTION FOUND:

I began to download bank transactions on week at a time. The very first week would not work and gave the OL-222 error. I noted the dates and then downloaded another week of transactions that started at the end of the first week of transactions that I had downloaded. This time the file opened and the transactions imported without issue. I then attempted to download the remaining transactions that started immediately after the successfully downloaded 2nd week of transactions, a balance of about 7 weeks of transactions. They downloaded and imported without issue into QuickBooks. This indicated that the 1st week of transactions that would not open is where the issue would be located. Next, I will download the 1st week that would not open or import, one day at a time, When I pin down which day is the problem day, I will open that day with Windows 10 Notepad and locate the error, then edit the error and resave as a .qbo file. Then I will import the edited file into QuickBooks. Fortunately for me, I have a lot of experience with computer issues and having to do repairs. I feel sorry for the average person that has to try and figure out a solution.