JE Import

Import Journal Entries from Excel into QuickBooks


Import Journal Entries into QuickBooks Desktop directly from Excel.  Easily create your Journal Entries in Excel using formulas or copy and paste from other systems and when you are ready, just click "Post Journal Entry" and within seconds your Journal Entry is posted to QuickBooks. 

This tool posts a single Journal Entry at a time to QuickBooks from Excel. If you are interested in posting multiple Journal Entries in a single push check out JE Import Pro.

This solution was developed as we needed to post a very large (hundreds of lines) unique Journal Entry every other week for payroll.  We worked through options with IIF imports which worked, but the process was just too complicated - we wanted something much more simple.  Enter the QuickBooks Software Development Kit (SDK).  Using this tool we added some programming onto an Excel Spreadsheet, giving us these benefits:​

  • Copy and Paste from other systems (email, spreadsheets, etc)

  • Build Journal Entries using Excel formulas

  • Save Journal Entry Spreadsheets to be reused as needed

  • Post very large Journal Entries to QuickBooks in seconds with the click of a button

This customization was built to meet the needs of most QuickBooks desktop users, but if you have a unique need, contact us​ and let's talk about a custom solution!

A Trial version of this Excel Customization is available with limited Journal Entry rows to test functionality.

Follow this link to download!


  • QuickBooks Desktop for Windows version 2010 or later

  • Microsoft Excel 2013 or later

Frequently asked questions

Does this tool work in a hosted environment?

Every hosted environment is managed according to their own business model and as security and up-time are generally high on their list of priorities, they will likely require any software to be certified before they will allow it to be installed. A trial version is available for testing if needed ( ). That said, all of our Excel Customizations will work in a hosted environment that meets the minimum system requirements, just make sure the tool is installed and running in the hosted environment and not the local desktop.

When trying to connect to QuickBooks, why do I receive a "COM" error indicating "Class not registered"?

The default version of the tool requires the 32-bit version of Excel. In most versions of Excel you can check your specific version by selecting "File", "Account", then select "About Excel". If you have the 64-bit version of Excel, please see the question below on "What is the status of a 64-bit version".

Why is a 32-bit version of Excel required?

The interface provided by Intuit to communicate with QuickBooks is a 32-bit program. This also requires that all software that uses this interface is also 32-bit. However, we've been working on a solution for 64-bit versions of Excel. Make sure to check out the "What is the status of a 64-bit version" question below!

What if I need to upload many Journal Entries at the same time?

The JE Entry Tool is desiged to upload a single journal entry at a time which is perfect for most uses; however, if you need a tool that can upload multiple journal entries in a single push, consider the "Pro" version of the tool. More information on that tool can be found here:

What is the status of a 64-bit version?

We are excited to announce that as of October 2021, an early release version of the JEImport tool that works with 64-bit versions of Excel is now available! If you have purchased the 32-bit version and would like a copy of the 64-bit version, please contact us at