Before going into the details of importing the IIF file in QuickBooks Online, we should first understand what the IIF file format is? So, IIF file is a text file that is used by QuickBooks software for import and export of lists and transactions.
Now if you are looking for the process steps of importing IIF files directly into QuickBooks Online, let me clear this up, that currently, it is not possible. But there are ways around it which you can use to get your data from QuickBooks desktop to Online through IIF files. So, let us look into those ways in the below section.
Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Online. Utilize import, export, and delete services of Dancing Numbers software.
Alternative for Importing IIF Files Directly to QuickBooks Online
There is an alternative to this, which is you can convert your IIF file into excel or CSV format and then import the data into QuickBooks Online. You can also use third-party software for this purpose.
Conversion of IIF file into excel or CSV format
Step 1. First of all, open the IIF file into an excel sheet.
Step 2. Now right click on the name of the sheet and change the extension from the .iif to .xlsx or CSV extension.
Step 3. Now click on the Yes button when prompted and the file will be converted to excel or CSV format.
Once your IIF file is converted to excel or CSV format, you can refer to the below steps to import the data in QuickBooks Online.
Step 1. First, click on settings >Import data > bank data.
Step 2. Now click the Browse button and choose the excel or CSV format file you wish to import and then click open and then Next.
Step 3. Now select the QuickBooks account, map the fields of the file with QuickBooks fields and click on Next.
Step 4. Review the imported data and click on Next and then Yes to complete the process.
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.