Showing results for 
Search instead for 
Did you mean: 
Active Member

How to create and import journal entries?

I need to enter journal entries into QB from an excel file how do I create an import?

QuickBooks Team

Re: How to create and import journal entries?

Hi there, @MCruz.


Thank you for choosing QuickBooks Desktop as your accounting tool. I can help you create and/or import the journal entries.


Currently, entering journal entries into QuickBooks from an Excel file is unavailable. You'll have to convert the Excel file to Intuit Interchange Format (.IIF) file.


There are plenty of applications that you can use in converting the file to .IIF. I suggest visiting the Intuit Marketplace to look for compatible applications in meeting QuickBooks import requirement.


If you don't want to use any application, you have to manually enter the journal entry transactions by clicking the Company menu and choosing Make General Journal Entries.



That should get you on the right track, @MCruz.


Let me know if there's anything else you need. I'm still here to offer more assistance. Have a good one.

Established Community Backer ***

Re: How to create and import journal entries?

You can convert your transactions in Excel to an IIF file for import using our BRC IIF Transaction Creator