Convert worksheet data into IIF files for import into QuickBooks. The tool is an Excel add in and after installation is available from the menus within Excel.
The Pro version includes all the features of the IIF Transaction Creator with the addition of several special Pro-only features including the Profile Manager, mapping features, and other options and settings to streamline your export to IIF process.
To use the IIF Transaction Creator Pro, arrange your data in row/column layouts on a spreadsheet. Several layout options are supported including a simple single-row layout and a more complex multi-row layout that resembles a QuickBooks Journal report. Template examples can be accessed from the IIF Transaction Creator Pro ‘s menu.
In addition to the features of the standard IIF Transaction Creator, the Pro version includes the Profile Manager, mapping features, and other unique options and settings.
Each profile saves your worksheet layout settings, all of the IIF Creator’s other settings and options, and also each company’s integration data (if you work with multiple companies.)
Common uses for Profiles include working with different companies (with different integrated company data) or with different worksheet styles. Different data can be in single or multi row styles or when the source worksheet data has different field names or other properties that require different settings.
Most QuickBooks transaction types are supported for import. Using the IIF Transaction Creator, you can import these types of transactions:
Download the IIF Transaction Creator Pro for a free trial before you purchase. You can use the fully-working trial to export up to 100 financial transactions to IIF files for import into QuickBooks (e.g. 100 checks or 100 invoices, or a mix of transactions.) This is the only trial limitation. Later when you purchase use your product key to unlock the trial you’ve already installed.
The IIF Transaction Creator Pro includes examples for the various supported transactions. You can access these from the Examples menu once the tool is installed. You can use these examples for all of the transaction types listed above. Examples can even be pulled directly from your QB file for review in Excel, so you can see how your accounting and other field values should look in Excel.
We’ve also provided a few extras in the form of templates that you can use on their own or with the IIF Transaction Creator Pro. See the template workbooks page for useful extended templates. Use these for additional ideas / different ways to use the IIF Transaction Creator Pro. These specialized templates include an expense report, invoice, journal entry template, a depreciation calculator, and a loan payment calculator. These templates augment but do not replace the example temples you can access from the menu in Excel once the tool is installed.
11.23: Resolve issue introduced in 11.22 that resulted in a run time error when attempting to add an Annual product key.
11.22: Better handling for sales tax when new tax items are used on the Excel worksheet or when incorrect accounting is used.
11.15: Fix issue where new parsed address fields that use custom column titles were not found during export.
11.11: Handle case where Excel worksheet is corrupted and Excel indicates there is only one row of used data. Handle case where account numbers (which are really text) change when stored as numbers during integration.
11.08: New example layout guiding message. Fix issue related to picking a layout style where wrong style was used to create the IIF file. Fix auto-calc issue for amounts and price each fields when in single row mode.
11.06: Rework message that prompts user to choose a layout style. Remove the option to auto-detect the layout style due to usability and code complexity issues.
11.04: Revamp address handling and column/field mapping. Now, choose between block address rows or individual address fields like Street, City, State, and ZIP. Also, now you can “map” your worksheet column names for all address fields, giving you more control.
11.01: Improve handling for default transaction types when none are provided in preferences or on the worksheet being processed.
10.99: Ensure the Integration dialog appears before exporting to an IIF file.
10.97: Improve double-quote handling for text fields.
10.96: Improve handling of billable status field for line details on the Items tab on purchase transactions.
10.94: Change logic for “auto-integrate” option so that the standard export dialog appears after the integration.
10.93: For better list matching, now retain double-quotes for text and list fields instead of replacing with two single quotes.
10.91: Resolve OLE error caused by attempting to open the documentation when it’s already open.
10.89: Better handling of integration data when QB user doesn’t have sufficient rights to pull lists properly.
10.88: Changes to installer and key handling code in the About dialog.
10.84b: Update to installer to better detect QuickBooks installations.
10.84: Significant performance improvements while integrating with QuickBooks – especially for larger files.
10.81: Improve code that saves and gets the user-specified temp file location.
10.79: Add Paste button to key entry dialog for convenience. Rework messaging when keys are entered incorrectly or for the wrong product.
10.78: 1) Add option to set the temp folder used when pulling data from QuickBooks in order to handle the case where the user does not have rights to their own temp folder. 2) Add warning at startup if creating the custom Ribbon tab is not possible because user does not have rights to the customization file. 3) Add smarter transaction type defaults to be used when no type or an invalid type is specified.
10.77: When using the insert account feature, the selected account is actually copied to the worksheet.
10.76: Update list integration code to handle cases where tabs are included within data fields.
10.75: Changes to support info added to IIF files, to logic regarding when to auto-pop the integration dialog, and to capture the QB file information when pulling example transactions and integrating lists.
10.74: When inserting names, items, and classes, and the record can be interpreted as a date (e.g. “April 2020”), prevent Excel from converting it to a date. Updates to the connection dialog with better advice for IIF file integration.
10.73: Now correctly handle group sales tax items when “auto-adding” sales tax to sales forms.
10.72: Fix issue where Jobs were not included on Purchase Orders. Minor updates to connection dialog tips.
10.71: Add “Insert” section to menu for older versions of Excel (to insert Accounts, Items, Names, Classes from QuickBooks as well as and Data Fields on your worksheet.) When typing in the insert dialogs, now auto-match text within a record when no item starts with the text entered.
10.66: Improvements for single-row examples & changes to advise on connection dialogs.
10.65: Update code that creates new items to use the correct account column for various layout cases.
10.63: Improve layout of the examples dialog window. Improve error checking & related messaging for missing required fields.
10.62: Allow up to 20 digits for A/P transaction document number (11 for other types of transactions.)
10.61: Add option to Options & Settings dialog for current session right click insert menus for all Excel versions. Set and correctly display good through date in About dialog for certain upgrade paths.
10.58: Update the text file import date handling for cases where your text file date formats don’t agree with your or computer’s date format.
10.57: Include Cost of Goods Sold in the list of account types that can be marked billable on purchase transactions.
10.56b: Installer update related to integration issues specific to 32-bit computers.
10.56: Clean up behavior when defining multi-amount transactions.
10.55: Change the way check worksheet error-checking results are copied. Better messaging when entering a key for the wrong product.
10.53b: Installer update related to integration issues.
10.53: Resolve QuickBooks integration issues with recent QB patch releases.
10.52: Detect recent QB releases while integrating to avoid QB crash. Put up message to use IIF file method to integrate when using this release.
10.49: Reorder ribbon buttons to put examples in the help section.
10.47: Change so that when the new transaction column title is the same as the values on transactions the first transaction will be included in the IIF file.
10.46: Enable default transaction types based on transaction totals for the single-row multi-amounts layout. Prevent unneeded names from being added in the single-row multi-amounts layout
10.45: Update for setting reimbursable status on purchase transactions for QB 2019.
10.43: Update to integration error handling – pass back original error message & update suggested actions.
10.42: Remove code that truncates document numbers – originally added for QB 2019.
10.38: Better handling of transaction cleared status values, better default account values (and new settings for default income and expense accounts), as well as smarter default accounts for new inventory items.
10.37: Fixed issue where Annual product keys were sometimes not displayed.
10.33: Dialog window changes to link customers to QB 2019 import recommendations. Tweaks to the file format.
10.32: Fix error with insert list record feature that caused an error if there were no integrated lists.
10.31: Changes for QB 2019 (more!) including new help links.
10.29: Additional changes for QB 2019. Date fix for some international locations.
10.28: Changes to purchase transaction handling so that item and non item rows will appear on the correct tabs in QuickBooks.
10.27: Fix issue with mapping dialog that caused lists of records to match to be empty.
10.26: Changes to accommodate QuickBooks 2019 and Enterprise 19.0
10.24: Updated example templates to address more common questions and display additional columns. Revised notes.
10.23: Changes to the column mapping dialog to help prevent invalid Account and Amount field selections. Updated documentation.
10.22: Reorganize custom Menu and Ribbon and update documentation.
10.19: Changes to About & Purchase dialog to handle more than one product key. Fix for Excel 2016 to resolve issue where app would not load properly.
10.18: When adding a Job to an existing customer, copy various contact information from the customer.
10.17: Now when mapping the Account column to nothing, the default name “Account” is not used. This helps when the “Account” column on a worksheet is used for a customer or vendor account and not a GL account.
10.16: For the single row multi-amount layout format: Now when no other account is found the amount column name is correctly used for the transaction detail row.
10.15: Now capture name addresses when specified for detail transaction rows. Also, when adding a job to an existing customer, use the customer address if no job address is specified on the worksheet.
10.14: Changes to the way integrated group items are stored in the list cache to handle larger groups.
10.07: Set newer 64-bit connection method as the default method. Also some minor bug fixes