IIF FILES

Hey there, @NitaPowell.

There might be an issue with your company file. This the reason why you're getting an error message while importing your lists and transactions to QuickBooks Desktop (QBDT).

Let me share with you some troubleshooting steps on how to fix it. This way, we can make sure you're able to import all of your transactions.

To start, update QuickBooks Desktop to its latest. This will help you fix some minor issues with your company file. Here's how:

1. Go to the Help menu and select Update QuickBooks Desktop.
2. Click the Update Now tab.
3. Select Get Updates to start the download.
4. When the download finishes, restart QuickBooks.
5. When prompted, accept the option to install the new release.

Once done, import yours.IIF files again. If you're still getting the same error, run the Verify and Rebuild tools. The Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds.

Additionally, you can run the QuickBooks Desktop Tool Hub. This will also help you fix common problems and errors in your company file. 

Don't hesitate to tag my name in the comment section below if you need further assistance in importing your transactions. I'm always ready to help. Have a great day.

i have R4_51.  i am told i have the latest version.  Nothing to update.   These error messages started AFTER this update.   i want to go back to 2011.  never had issues......ever.  I should be able to upload jobcost from ADP to QB using the csv FILE - IMPORT TO IFF with NO ISSUES......and it is NOT happening.  ADP shows no errors.  ALSO,  it is code 15100 after EACH ENTRY.

so who at QB knows about this issue.  After combing the internet on QB it looks like this started at the 2019 update....which i went from 2011 to 2021.  

Hello @NitaPowell,

Let me offer help and share how you can get rid of the error message so you import your IIF files successfully.

To start with, the error message you receive is related to how your file is created. Let's update its format base on the following requirements outlined in this article: Export, import, and edit IIF files.

In the same manner, this article will also provide additional resolution in case you're still unable to import your file after reformatting it: Improved IIF Import in QuickBooks 2019 and later.

On top of that, I've also included this reference for a compilation of articles you can use while working with us: Help Articles for QuickBooks Desktop.

If you have any other questions, please let me know in the comments below. I'll be here to lend a hand.

@NitaPowell 

There are some unresolved issues in IIF feature since QBD 2019 released. Consider using an importer tool as the solution.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

Thank you for all the info, but I have tried all of the advice and still won't import my invoices via iif files.  Please do you have any other advice?  I have also talked with QB and he said there used to be a download that could help fix the import issue, but it is no longer available. So his suggestion was for me to manually enter all of my invoices from my mobile invoicing app (that would be hundreds every month).  We do not use QB Online version due to it not having all of the report and usage options our business needs.  We tried and it is a very subpar version of QB.  Thank you for any help.

@plunkettpen 

Have you tried the apps I mentioned in earlier post?

Yes, since 2019, there have been a LOT of issues for us in payroll.  Whenever we attempt to access an employee's master record, QB gives us the "apologize" message and terminates QB.  We were finally able to get QB to acknowledge that this is a known issue.  Of course, they are doing nothing to fix it.  The just have this work around of exporting all employee records, then importing them again, in the hopes that will take care of the problem.  We did that, but found other issues from the export/import process, but we were able to getting QB working again.  

We are now having the SAME ISSUE again.  Arggghh!

I was required by QuickBooks to update to the 2021 version, which I did yesterday and I am having the same issue with importing iif files.  I have been combing through all of the help sites today and you are absolutely correct.  The only way I have found to get my work done is to choose fix it later.  The new Tool Hub is no help so I feel your frustration.

I'm not sure if this will help but I was having a similar issue trying to export iif from QuickBooks Online Payroll to QuickBooks desktop.  I opened the file with errors using Excel and searched for the word Error.  I was able to identify what the errors were with the data and fix them in QBO Payroll and recreate the iif file and successfully import the file.