So frustrating!

Hello @Rose-A,

I would recommend you add the IIF Import details to Solution 3 in this article.  Specifically, you need to use the "Import it for me. I'll fix it later" option.

Having accurate info for Solution 3 would have helped Intuit customers resolve this issue.

urghhhh....my excel program is expired. It appears I can't open this in google sheets either :(

While it's a bit more cumbersome you can use a text editor such as notepad to edit the file. Just use caution when editing & backup your company file before importing in case anything goes wrong.

Hello @Paying Customer,

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

We love to see members supporting one another! Have a great day.

I decided to just enter all transactions manually and not use my Discover card anymore!
It saved me time at this point. Maybe I'll get a new one. @Paying Customer Thanks for figuring all this out though, my time with customer support was useless...so, bravo to you!

This solution is now not working - with the workaround the lightning bolts are still there because QB ignores the IIF upload since the newest QB update makes it so that the "list or transaction is not supported by the IIF import process". Doesn't matter if you click to ignore errors because it will just ignore the N lines on importing. 

Welcome to the QuickBooks Community. I can see how essential to import entries into QuickBooks Desktop using IIF. Also, you've done all the possible steps to help fix your concern. With this, I'll ensure you'll be routed to the right support team to assist you further with this matter so you can get back on business.

I suggest contacting our QuickBooks Support Team, they have the tools to pull up your account which is needed in investigating the cause of the issue.

1. Press F1 to open the Help window.
2. From the search icon, type Contact Support.
3. Click Contact us at the bottom part.
4. Give a brief description of your issue about importing transactions and click the Search button.
5. You'll be routed with How to connect with a QuickBooks expert and you choose which one is best for you.

Lastly, you may refer to this article to see various OL and OLSU Bank Feeds errors and how to fix them: Fix OL and OLSU Bank Feeds errors in QuickBooks Desktop.

Please know that you're always welcome to comment below if you have other concerns or follow-up inquiries about uploading transactions in QuickBooks. I'm just around to help and take care always.

You need to choose the "Import it for me. I'll fix it later" option when importing your iif file.

When you say you edited your IFF to include only the HDR and QB ONLINE, did you edit it to just take a screenshot so all info was on the same page for us to see or was it an actual step you took in this process to fixing all this?  

I don't want to assume it was an actual step and cause myself more headache if it wasn't.

Thank you for posting your solution.

@figuringitout1, I did delete all the other lines from my IIF to be imported but you don't need to.  I knew changes to the other lines were not required so I remove them to prevent any unforeseen issues.

@thissoftwareistheworstI replied to you but the reply did not fall under your post.  You need to choose the "Import it for me. I'll fix it later" option when importing your iif file.  There's a screenshot in the solution as well as a couple of posts down from yours.

followed your steps and it worked...thank you!!

THANK YOU! After searching all over to try to fix a Capital One connection I was directed to this page. The disconnection of the QB account is befuddling, but it worked. Thanks again!

Thank you for posting this brilliant solution to this QB problem,   I was literally on the  phone with "support" who literally had ZERO clue what was going on.    While i was on my forth "2 minute" HOLD .... I found this solution and was able to use it to resolve this issue.    VERY frustrating.  .... but VERY thankful for the time that you took to post this resolution,  Thanks so much.    G

Thanks so much!  I've been fighting this exact same issue for a few months.

Thank you!  I've been struggling with this for months and your solution finally worked for me.

Good day, Manticore.

It's good to hear that your concerns were resolved.

You can always post anytime if you have concerns. Keep safe!