I just shortened them... took the 4 digit code off end.. removed “online’ and stuff like that. Basically ged rid of as much as I can and still know what it’s for
Worked like a charm. One would think this would be a rather simple fix for the Intuit team. I'll continue sending in bug reports till they get sick of me I guess. Maybe we should all invoice them for our extra effort and time with editing the ofx files?
Cheers & thanks again for the help!
6 months and I'm still doing all my entries by hand. Really thinking about moving to another program in the next few weeks. If users can find solutions it should be an easy fix for trained technical support.
This error occurs when QuickBooks does not receive a proper response from user’s Financial Institution. Unsupported characters found in the .QBO file could be the main cause of this error.
To fix this, let’s reclassify the Formatting of .QBO file. Here’s how:
Though if the issue continues, it’d be best to reach out to your bank to investigate this further.
Thanks for your patience. Visit us again if you have other questions.
As stated previously there are other files from this institution that work perfectly fine. Is this character known to only appear in the chequing/savings file data from RBC and not the credit card data from RBC?
This is ridiculous that this hasn't been fixed yet. You guys have left your customers hanging in the balance with a half working product since October of last year. How is it that 2 national institutions haven't got this figured out and implemented yet?
My guide on editing the file still works for input... but who wants to have to go through all that editing when we've paid for software and paid our banking dues??
Hello Trevvy. I want to assure you that we have heard and continue to hear your concerns about the OL-222 error with RBC and QuickBooks Desktop. I'm glad that my colleague was able to share a temporary solution while our engineers continue toward a more permanent fix. I know this may not be an ideal solution, especially if you have many bank transactions to upload. Your time is important and we love being able to offer the ease of the bank feed option, which is why resolving this error is one of our priorities.
I understand that this issue should be fixed as soon as possible. I know it's time-consuming to enter things manually and we do value your time.
What you can do for now is follow my colleague's suggestion while our Engineering Team is working on getting this resolved. If you haven't called in yet, I'd suggest reaching out to our QuickBooks support so they can add your account to the list of affected users. This way, they can email you with the latest update about this investigation.
Additionally, I'll keep an eye out for the progress and provide them as soon as they're made available to me. Please bear with us.
Let me know if you have other questions. I can help you further if needed.
How much do you value your customers time? Perhaps enough to reimburse us for it? When I spend time on anything to do with work I usually bill it to my clients. Are you expecting us to have our clients pay for this extra time we have to spend on editing downloaded files that your software is supposed to handle??? I don't think so. Give us a contact and a billing address so we can invoice you for our time.
Hi ML Painting,
I know how it feels when you've used up too much time waiting.
Right now, our engineers are still working with RBC for the fix.
If you haven't already, I recommend contacting our Customer Care Team so you'll be listed in our list of affected users.
If there's anything else you need assistance with, please don't hesitate to comment below.
It should be a simple as someone writing macro to shorten the line. Then put it up on your site for an upload fix / then download import. If someone who knows nothing about your file structure can manually go in and edit THE ONE LINE that is causing the issue to get it to work.... Two teams of professionals from two MASSIVE institutions should have been able to figure this out by now. There's something else happening here that isn't being disclosed.
What are the chances of getting a refund for my Quickbooks 2019 Pro?
Hello again, Trevvy. I know we've spent a lot of time on this subject and I'm still relaying customer concerns, including yours, about how long this is taking with my team. Refunds are not typically offered for this kind of situation as it's one part of the product that has an error. You're welcome to give our phone support team a call to discuss this in greater detail. Pro support is available 24 hours a day at 1-877-772-9158.
LauraAB, why would you tell us to call support, after stating that you have relayed our "concerns". Why would I have to click through your support site at this point? Why is it on us to contact RBC? We pay Intuit for this software, we should not have to fix your problems! I too want a refund or something in line of a credit. I sure as hell am not going to invest more time into making phone calls, or clicking through your support section etc etc. A main component of our complaint is its costing us time, and your suggestion is to invest more time? If anything I'll be contacting services such as the BBB and our Provincial Consumer Complaint department. I can't get over after using your products for pretty much as long as Quickbooks and Intuit's tax software have existed, the absence of a fix for a simple problem!
I’d totally feel the same way if I were in your position, ML Painting.
Our engineers have come up with this workaround as they continue working to fix the issue:
Note: You’ll need to modify the file if it comes with a huge amount of information. You can use MS Word to open the .qbo file then use the Find and Replace All feature.
I’ll also make sure to keep an eye on this issue and will keep you posted once there are updates.
Please continue to bear with us until we fully fix the issue.
I upgraded from QB2016 to QB2019 as the online service for 2016 was being discontinued.
Although same problem download problems as I was having with QB2016 I am having with QB2019. Disappointed to see that QB and RBC have known about this for a while but have not fixed it. So each time I need to go and edit my .qbo file every time I download one.
Hey QB and RBC... Get this fixed ASAP! I'm definitely not recommending either RBC or QB to anyone at the moment.
Congratulations on upgrading! It's important to us that our customers are using the most up to date software program available.
We're still working with RBC to make sure we establish a connection ASAP. I know it's taking longer than usual and I appreciate you holding on tight. If you need assistance with anything related to QB, feel free to reach out. I'll be here to help.
Yes we have been doing that. Perhaps if Intuit would just fix quickbooks to accept "names" over 25 characters, and quit blaming RBC we would all be better off! Yes?
Accepting more than 25 characters would be a good solution, ML Painting.
I can assure you that our engineers are working to fix this. We’ll surely mention everyone in this thread once we receive updates.
Please continue to bear with us until we completely fix the issue. Thanks for your patience
The function now works. No more OL-222 error. Glad I heard about it from RBC before the manufacturer of the product... Seriously disappointing Intuit.
If you are going to try it out... I suggest that you do a time based import and DO NOT select since last transaction. It imported everything from the start of my bank account till now.
Oh well. Guess beggars can't be choosers.