Import transactions from Excel into QuickBooks
The IIF Transaction Creator Pro helps you import transactions from Excel worksheets into QuickBooks.
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.
- Import most transaction types into QuickBooks based on your Excel worksheet data (e.g. Checks, Deposits, Invoices, Bills, General Journals, and so on.)
- Include just one or up to thousands of transactions in your IIF files at a time.
- Built in worksheet error checking for better results.
- Automatic name and account conflict resolution for easy import into QuickBooks, for both existing and new list records.
- Automatic sales tax calculation for sales transactions.
- Integrates with your company to create a custom IIF file designed just for your company for a smooth and reliable import.
special Pro-Only Features
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.
– The Profile Manager lets you switch between saved profiles in order to work with different company files or data layouts. Profiles have these properties:
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.
– Mapping helps you customize the IIF Creator Pro to match your data – New!
- Map Names used in Excel to the correct names in QuickBooks. E.g. “Target #123” to “Target” or “Fees” to “Wells Fargo”. This feature includes wildcards for partial matches. It is similar to the Alias tool in QuickBooks’ bank feed/online banking feature.
- Map Transaction Types used in Excel to supported types. E.g. “Debit” to Check, “EFT” to Deposit, or “Statement” to Bill.
– Additional settings help you streamline your export process. These setting include:
- Automatic list integration with QuickBooks as you export. Helps prevent import errors and saves steps.
- Automatic error checking as you export.
- Automatically remove older IIF files from your export folder as you create a new IIF file, which avoids confusion when picking a file to import into QuickBooks.
- Notification when transactions are out of balance. Out of balance transactions are fixed automatically, but some customers want to know.
- Notification when new names, items, or accounts are added to the IIF file, in case that is not expected.
- Class mapping supported in the Multi-Amounts dialog wizard.
Supported Transaction types
Most transaction types are supported for import. You can convert these transaction types from your Excel worksheet to an IIF file for import:
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.
Free Examples & Templates
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.
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