Skip to content

QuickBooks IIF Files Import Error Troubleshooting


QuickBooks IIF File Import Error

QuickBooks software was designed by Intuit in order to provide small and medium sized businesses an opportunity to manage their finance and accounting part of business without any hassle and problem free. QuickBooks software accords users with as easy way out from manually recording all financial transactions, filling up forms and performing other accounting tasks. As there is limited manual input, the mistake in calculation and other related areas becomes negligible.

What is Quickbooks IIF file

QuickBooks IIF Files Import issues & Errors

Apart from regular financial work, QuickBooks also performs tasks like filling up forms, filing for tax etc. One such task is importing of information and files. Although the task of importing itself is quite easy and hassle free, it does cause issues at times. TO avoid this issue of importing there are certain points that needs to be kept in mind for successful import process. These points are as follows:
Easiest format for importing is IIF, that is, Intuit Interchange Format.
Ensure that while importing IIF file to utilities, it does not consists of lists, transactions or a combination of both.
It is better that you use default accounts of QuickBooks option in your QuickBooks download report settings.
In case of error, the advantage you garner with QuickBooks is that, while displaying the error message, it also informs which transaction resulted in error.
If you avoid the error message and still continue with import process, you will encounter following cases:

If you continue with the process without resolving the error, then all the transactions except the error one will get imported.
In case you cancel the import process, then the transactions already imported will be successful and the ones after the error will not get imported, resulting in process being stopped in the middle.

Fix IIF File Not Importing Into QuickBooks Desktop Pro,Premier , Enterprise

The above points should be kept in mind while importing for success of the process without causing unnecessary hassle for the user. If you still end up in trouble you should immediately get in touch with the QuickBooks customer support team and inform them of the issue without leaving any detail out. If you encounter delay in getting the required help, you can try other support alternatives like support agencies that provide similar support. One such agency is called QuickBooksSupport , that house Intuit certified ProAdvisors and can be easily reached through toll free number

Related Sources

QuickBooks File Extension

11 thoughts on “QuickBooks IIF Files Import Error Troubleshooting”

  1. I exported an .iiF file from Quickbooks and saved it to my desktop. I would like to open and review it before sending the file to our payroll company however a screen pops up that says “Problem you are trying to open a quickbooks file only quickbooks company files can be opened this way. Suggestions? using Premier Contractor 2018

  2. [ERROR] Missing mandatory field TRNSTYPE in header. [15102], getting this error when trying to import an IIF file from paypal to quickbooks enterrise usning 2020

  3. I was interested in learning about your software to convert an excel into an IIF file for use with QB desktop,I downloaded the free trial and was waiting for a verification code, however did not receive, Currently using QB Pro 2020 and will be upgrading to 2021 in the next month or so., Sorry correction…..using QB Pro 2021 currently , I had to reinstall where my QB is located. It will not allow me to enter this verification code again. May I have another?

  4. I need to make an excel file into an .iif file, I’m having troubleimporting an excel file into quick books desktop, how do I do this using premier plus pro 2021

  5. I am a retired CPA helping my son. I have used QB since 1998 yet seldom ever used IIF files. Now the transfer i get error in the import. I CAN NOT FIND ANY GLOSSARY OF ERRORS, OR HOW TO FIX. Your site brought me to Steps to Fix IIF Line Error and at step 3 without any info of errors or how to fix. I need more info. I spent hours searching with same wall – NO INSTRUCTIONS ON TYPE OF ERROR OR HOW TO FIX. using 2020 Desktop Accountants Ed, I set up new co without any data, only the basic 5 or 6 Accounts created by QB setup. Then created Chart by export from co he is buying. This is simply the Chart of Accounts yet it only imported about 60 of 152 accounts.,NO reason this should be an issue as I understand – it just a chart of acccounts!!!!

  6. I need a simple excel to IIF file converter to import jounal entries into QB 2021, Do you have a file converter that will do what i need and what is the pricing on it?, I want to know whether you actually have something I can use before I give you my info.

  7. I am trying to import our chart of accounts from QB desktop to online. I found the directions online, but I’m not sure how to open the IIF to review before importing.,I think I figured out the chart of accounts, Am I able to import our Customer Message List?

  8. Wells Fargo used to give us an IIF file so we could import it to Quickbooks, now they just give an excel file. Will the QIF to OFX converter do this? I’m at my own computer researching for my supervisor. I continue this thread when I am at the correct computer?

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × 1 =

Disclaimer : MyOnePro assemble the showcase the information of accounting software as accurate as possible , aim to provide user can resolve issue and get technical aspects of downloading, installing , update , upgrade accounting software. Intimating the MyOnePro visitor the information shown here for only information purposes. We have no direct or indirect association with any brand or any accounting software manufacturing company. QuickBooks Desktop and related versions are manufactured, promoted and distributed by Intuit®, Inc which is a USA based company. Other software like G-Suite, Gmail, Fiber owned by Google® USA, Excel, DOC, Word, Windows OS, Windows Server have under the copyright trademark of Microsoft® USA. MyOnePro is a team of certified ProAdvisor helps the user for managing accounting software like QuickBooks Pro, Premier, enterprise, POS, Non Profit, Accountant, Retail, Professional services Etc. All the images and content are under copyright of MyOnePro. The more information you can check the full disclaimer. Also for any dispute you need to first intimate our legal team to get full details, any action against web property and other resources of MyOnePro may be liable to penalties and a million dollar claim. Beware of fraudsters!



MyOnePro Tollfree Number
Toll Free: +1800-983-3079 user