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

I am not sure how to start a few thread so I am going to ask this here. I am fairly new to using this First Citizens Bank for one of my clients and when we set up the Visa card through bank feeds it didn't set it up as a credit card account it set it up as "Current Liabilities" like a line of credit but now every entry is a General Journal Entry which is really not what I want. Is there anyone that has dealt with this?

Hello LG Business,

Thank you for chiming in on the thread! I will be happy to help. You can inactivate that item and create a new credit card account with the correct settings. Here's how:

1. Go to the Banking or Transactions menu and choose Banking.
2. Click Add Account.
3. Search for your bank or use the correct URL when logging into your bank's website.
4. Enter your bank's username and password.
5. Choose the type of account.
6. Choose how far back you want to download bank transactions.
7. Click Connect.

If you've already added the account to your Chart of Accounts, I suggest following these steps to connect it. If not, use this link to add an account  then continue the steps.

1. Go to the Accounting menu and then select Chart of Accounts.
2. Find the account you want to connect to.
3. Select the View Register drop-down menu under the Action column.
4. Click Connect Bank.
5. Follow the onscreen instructions.

For your visual reference, I've attached a screenshot below.

Please let me know if you are still experiencing any issues! I will be around to help. See you soon. 

Thank you, I appreciate your help. I have tried going into the chart of accounts and changing the account from a credit line to a credit card (which I had to disable bank feeds to do that). When I changed it to a credit card account and then tried to download then info the bank feed wouldn't recognize the account or download to that account because it is still trying to download as a line of credit. 

Thanks for coming back to this thread, LG Business. Let me chime in to help you out with the task of connecting your credit card account to QuickBooks Online.

First, I want to appreciate you for taking steps to address the issue of the credit card account being set up as a line of credit account. To resolve this, I recommend disconnecting the bank from your QuickBooks Online bank feeds. This will prevent transactions from entering your QuickBooks Online company. To do this, follow these steps:

1. On the left navigation panel, head to Transactions.
2. On the Bank Transactions tab, click the account's tile.
3. Then, select Edit account info.
4. Tick the Disconnect this account on save option.
5. Press Save and Close.

After completing this, create a new credit card account in the Chart of Accounts. Here's how to do that:

1. Navigate to the gear icon at the top-right corner of the screen.
2. Select Chart of Accounts under Your company.
3. Click the New button.
4. Fill out the form. Ensure you select the appropriate account types.
5. Press Save and Close.

Then, follow the instructions provided by my colleague earlier to connect this newly created credit card account to bank feeds. Lastly, I recommend reviewing your transactions from the previously connected line of credit account. Be sure to exclude transactions that could lead to duplicates to maintain accurate records.

For more information about the topic, please feel free to check these articles out:

• Make an account inactive on your chart of accounts in QuickBooks Online 
• Add an account to your chart of accounts in QuickBooks Online

For future use, here's a guide on ensuring your QuickBooks accounts correspond to your real-life ones: Reconcile workflow.

Come back to this post if you have any other questions about managing your accounts in QuickBooks, LG Business. The Community will be right here for you.