LAST UPADTE: 11/18/2020 – Note: For QuickBooks Desktop (Pro, Premier, Enterprise) 2007 and newer only. Currently, this macro only works on Microsoft Excel for Windows only (Mac version of Excel has issues with the Macro)
Purchase Hector’s Journal Entry Macro to IIF** for $25
Give me a day to e-mail it after payment received please
To buy the template for $25, click on Buy Now:
- Click on the link coming from “SendOwl, to download the kit
- There are several templates/macros on the kit, use the one that makes most sense for you based on your needs
- Run the excel template, paste your data in there and generate the IIF file.
- It is recommended that you do a backup, before importing any IIF files
- To import the IIF file, follow these instructions
- It is IMPERATIVE that you make sure the account name matching QuickBooks 100% (character by character) otherwise the IIF will create a a new bank account for every non-matching and mess up your chart of accounts; also the journal entries might import as check or deposit if the first line ends up being a new bank account. It is also crucial to make sure that the total debits match the credits, otherwise you ma get file corruption
- If you enter a Bank Account as the first line if the journal entry, QB might import this as a Check or Deposit, so avoid using a bank account on the first line
- You must import the IIF using the “Import it for me. I’ll fix it Later” option on the bottom of the Import IIF Window
- If you use the Customer:Job option to import a transaction linked to a customer, these will automatically check the BILLABLE checkbox. It is not possible to avoid this, if you are annoyed by the billable checkbox, you will need to live with this issue
- If you are going to have more than one journal entry transaction in the macro, make sure to separate/group them using the same REF number for all related ones
- If you use a class or customer:job on the first line of the journal entry and leave other lines blank, QB tends to fill in the blanks with the info in the first line, so choose the blank as the first line if this is what you are trying to do.
**Intuit does not support IIF files, use at your own risk!