cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
LorrenaR
Level 1

Save a excel file as an iif

How do I save an excel file as an iif file?  I am able to save as a txt file and import into quickbooks, however if there are errors QB does not make me aware of the errors and instead imports the the journal entry by creating multiple gl accounts.  I would like to use the IIF import correctly, but do not know how to save my file so that is is in the right format.

2 Comments 2
MadelynC
Moderator

Save a excel file as an iif

I’m here to share information on how you can save the file and imports them successfully to QuickBook, @LorrenaR.

 

In order to make it easier to transfer the data to and from different platforms, you’ll need to convert them first in their supported formats.

 

You’ll want to convert your Excel file to IIF first. You can find a third-party application or visit our Desktop Apps website to look for a file converter tool.

 

You can also download a sample IIF and manually create your own file and import it into QuickBooks. For more information, please take a look at these resources:

 

 

Don’t hesitate to respond on this thread if you have additional questions or concerns with the import process. I'm here anytime to help. Always take care!

Fiat Lux - ASIA
Level 15
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us