It is working!!!!! FINALLY!!!!

It is still not working for me?

Still not working for me?  Still receive OL-222 message

QBO file downloaded and imported web connect or direct connect ?

If that is question for desktop user - I am using web connect

Hi there,

I’m here to provide troubleshooting solutions to resolve Error code OL-222.

To start, I recommend updating the QuickBooks Desktop release version and making sure to create a backup copy of your company file and have the latest supported version of QuickBooks.

After that, let's correct again the unsupported characters in the .QBO file which causes this error:

1. Right-click the .QBO file and select Edit.
2. Select any text editor app to open the file.
3. Find and remove &amp from the text as it is an invalid character.
4. Save the file.

Once done, import the file once more to QuickBooks Desktop.

If 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. 

For future reference, here's a link on how to add and match Bank Feed transactions in QuickBooks Desktop.

Please let me know if you have follow-up questions or concerns with bank transactions. I'm always here to help. Take care and have a nice day ahead.

I updated to 2024 and now it is working!!!!

I did not have to edit the file to remove bad characters

If only I had known that was a fix before.

Thanks for updating us on this, @DesktopUserRoswell.

We're glad to hear that you're now able to import your bank transactions again after updating your QuickBooks Desktop.

Please let us know if you need help with other QuickBooks-related concerns in this forum. We're always here to help you out. Have a great day ahead!

I’m using QB desktop pro 2023. I downloaded the qbo file and opened it which allowed the import to update the feed. 

My local Citizens Bank told us we need to switch to something called "Autobooks." They say they can't support Quickbooks any longer. Can't believe we might actually have to change our whole financial software, or all of our bank accounts over this...

I was able to download transactions for the first time since June for September transactions when I upgraded to QuickBooks 2024.  When I saw your post I tried and it is not working yet again!!!  QuickBooks WebConnect is till in the Export window but it is not working - I guess I have to go back to Plan B.

I could not find the converter for $60.00 one time charge -all the ones I looked at were monthly subscriptions?

Could you provide the link to the one time charge website?

I found the converter - https://www.moneythumb.com/shop/csv2qbo-convert/

It is $59.95 for unlimited conversions and very easy to use.  I tested and it worked beautifully!!!

Thank you very much for providing this option.

Thank you for providing the converter information - I was able to find the correct page to order and it is working great!!!!

https://www.moneythumb.com/shop/csv2qbo-convert/

Yes. the converter tool is the workaround at this time.

https://www.moneythumb.com/?ref=110

If you have older QBO files saved that worked you can compare them with the new ones to see if there are any obvious differences, needle in a haystack approach.  There's a nice addon to notepad++ called compare that can help. I make a backup of file and work on the copy, then import it once fixed. 

the two issues I've come across have nothing to do with the Ampersand "&" or as QB support file says &amp.

One issue is my banks sometimes doesn't put a date after <DTPOSTED> it should look something like this <DTPOSTED>20230530 for the total payments/credits/purchases debits.  Since I don't use these I just delete the section with the missing dates from <STMTTRN> to </STMTTRN>.  The latest issue they started using NULL for <BALAMNT> QB doesn't like this.  I changed it to <BALAMNT>99999 so if it does get imported I can find it.  

What if you’re unable to manually import them also?  I find the bank and it gives me 4 steps to manually import transactions. When I get to step 4, "Simply double-click the file and Quickbooks will automatically open to import your transactions”, nothing happens.

On desktop I do file, utilities, import. Web connect files. Then select the .QBO.

Let's do some steps so we can fix when importing bank transactions, Noemi. 

In most cases, when you get to step 4 and double click the file, you'll see prompts to proceed with the import. Let's see if the import works for the one  window option. Sometimes, working with multiple windows doesn't let you see the next step or prompt. To switch to one window, follow the steps below:

1. Go to the Edit menu, select Preferences.
2. Under Desktop View, select One Window.
   
3. Click OK.

Once done, re-import and double-check if you have the option to proceed. If you're unable to see it, you can use a sample company file and a dummy data for the import. If everything is working fine using the sample company, it's possible your data has been corrupted. 

We can fix this using the verify rebuild tool to fix common issues. To verify, follow the steps below:

1. Go to Window then select Close All.
2. Go to File, then select Utilities.
3. Select Verify Data. If you see:
   1. QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
   2. An error message—search for it on our QuickBooks Desktop support site for how to fix it.
   3. Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

For more information on how you can rebuild your company file data, check out this article for more details: Verify And Rebuild Data In QuickBooks Desktop.

Furthermore, learn how you can add and match bank feeds. Read this article for your reference: Add And Match Bank Feed Transactions In QuickBooks Desktop.

Please get back to us if you have any questions when importing transactions. We're here to ensure to address all your concerns.

true