Re: Convert excel to IIF to import Journal Entry Desktop 2018
Good day, @Kim Perico.
I’m here to share some information about converting Excel or CSV files to IIF and importing Journal Entries in QuickBooks Desktop.
The ability to change an Excel or CSV file to IIF is currently not available. However, QuickBooks has lots of 3rd party apps from the Intuit Marketplace for the list of applications that you can use in converting the file.
I also suggest sending feedback to our Developers for the inclusion of this option in future updates. Rest assured, I’ll do the same on my end.
Let me show you how:
1. Go to the Help menu and select Send Feedback Online.
2. Select Product Suggestion.
3. On the QuickBooks Feedback window, fill out onscreen instructions.
4. Click Send Feedback.
In the meantime, you can download a sample IIF for journal entries and manually create your own file and import it in QuickBooks. For more information, please take a look at this article: IIF Overview: import kit, sample files, and headers.
That’s it. Please let me know how it goes by leaving a comment below. I’m always here if you need further assistance. Take care and have a great day!