What's new in IIF Transaction Creator 11.95
Jan 29, 2024
- Changes to work around Malwarebytes uppity false positives.
New in IIF Transaction Creator 11.93 (Dec 22, 2023)
- Changes to the Layout & Define Columns window to avoid unwanted messaging related to account columns when changing layout styles.
New in IIF Transaction Creator 11.89 (Sep 15, 2023)
- Layout changes to the About & Purchase window. Re-signed the add-in.
New in IIF Transaction Creator 11.84 (Jun 20, 2023)
- Fixes to name matching so that names and name account numbers that number with leading or trailing zeros will match more reliably.
- Properly recognize customer taxability settings when integrating lists using an IIF file.
New in IIF Transaction Creator 11.83 (Jun 20, 2023)
- Check the server for updates only once per day. Fixes to the auto-calculate sales tax feature so it won’t miss the last transaction on the worksheet. Add support for auto-calculating sales tax for the single-row transaction layout style. Add Support button to the About & Purchase window. Slight layout changes on the About & Purchase window.
New in IIF Transaction Creator 11.81 (Jun 8, 2023)
- Improve the “check for updates” button on the Ribbon which will now tell you when there is a new update. Improvements to support-related information added to IIF files.
New in IIF Transaction Creator 11.79 (Feb 14, 2023)
- Fix a compile error introduced in 11.78!
New in IIF Transaction Creator 11.77 (Nov 27, 2022)
- When using the multi-amounts layout style, now use the worksheet memo for each line item first, and then use the item’s memo only if the worksheet memo is empty.
New in IIF Transaction Creator 11.76 (Oct 24, 2022)
- Handle a case where an invalid Terms record was causing the tool to hang when trying to calculate the due date.
New in IIF Transaction Creator 11.74 (Sep 22, 2022)
- 20x performance improvement when reading integrated names before using the Check Worksheet or Export to IIF features. Consistently preserve list field values that look like numbers but really are not, like 00123 or 1000.0000, which previously might have been saved as numbers like 123 or 1000, losing their formatting.
New in IIF Transaction Creator 11.73 (Sep 6, 2022)
- Now use the item purchase memo/description for purchase transactions if no description is provided on the transaction worksheet. Resolve “compile error in bMod” and related errors introduced in 11.69 by removing a reference to a component that doesn’t exist on some computers.
New in IIF Transaction Creator 11.72 (Aug 29, 2022)
- Resolve issue introduced in 11.69 that caused a “Microsoft Forms” error on some computers. Improve performance when integrating via an IIF lists file using the new partial integration option where the names list is very large.
New in IIF Transaction Creator 11.69 (Aug 18, 2022)
- Now when selecting an IIF file for integration, default to the previous file’s folder and name. Also, when new items are found in Excel on transactions on purchases (like checks or bills) add the account and the item price to the cost side of the item instead of the sales side. Use the default income account on the sales side.
New in IIF Transaction Creator 11.68 (Aug 17, 2022)
- When integrating lists, can now blend the Direct Connect and IIF Lists File methods, which will help with QuickBooks 2022 which will not integrate the items list. When integrating via an IIF file, can now choose an option to only update the lists that are in the IIF file! Integration complete window reworked and now includes status for the Terms list. When integrating via an IIF file, better handling for Assembly items. Update main documentation and the List Integration help file available from the Integration window.
New in IIF Transaction Creator 11.67 (Jul 8, 2022)
- To better handle non-sales transactions, don’t automatically select a sales tax item to use when the sales tax account is used and no sales tax item is specified.
New in IIF Transaction Creator 11.66 (Jul 7, 2022)
- Better handling for name list record fields that contain values that look like numbers but are actually text, including name and address fields as well as custom fields and terms.
New in IIF Transaction Creator 11.65 (Jun 7, 2022)
- Fix a compile error related to changes in 11.64, managing the output file locations when import a DAT settings file.
New in IIF Transaction Creator 11.64 (Jun 1, 2022)
- Handle special characters when passing information to prefill the support request form.
- Improve handling of key date fields when pulling transaction data from QuickBooks.
- Detect the computer’s system date format and use it for display in the About & Purchase dialog.
- When importing settings, manage output file locations if the saved location does not exist on the current computer. In this case, default to the Documents folder.
- Handle product keys that include embedded quotation marks (which is rare).
New in IIF Transaction Creator 11.63 (Apr 20, 2022)
- Fix a case that caused Excel to hang when attempting to integrate lists. This happened rarely, on computers where trying to read the windows registry resulted in a system error. Also, now display the error.
New in IIF Transaction Creator 11.62 (Apr 8, 2022)
- Now add the fully-qualified class name when specifying only the sub-class name on a worksheet.
- Handle the import of very large settings .dat files.
- Add some special handling for particular settings.
New in IIF Transaction Creator 11.61 (Mar 8, 2022)
- Refinements to changes made in 11.59. Update the single-row multi-amounts layout style example to include the Taxable column and related help text. Changes to values written for sales tax rows so that the auto-add and auto-calculate sales tax features write the same field values as when tax lines are included on the worksheet. Change so when adding older product keys on a new installation the Good Through date is set (instead of displaying “‘———-“).
New in IIF Transaction Creator 11.59 (Feb 6, 2022)
- Add check for updates button to the IIF Creator’s custom Ribbon tab for newer Excel versions and to its custom menu for older Excel versions.
New in IIF Transaction Creator 11.58 (Feb 1, 2022)
- Updates to the support request window and to error messaging around adding product keys. Add icon to Ribbon to check for product updates.
New in IIF Transaction Creator 11.57 (Jan 12, 2022)
- When calculating due dates used on AR and AP transactions, handle case where terms based on the day of the month have the day set to 0 in QuickBooks, which notably isn’t a day of the month.
New in IIF Transaction Creator 11.56 (Dec 14, 2021)
- Improve QuickBooks version detection and connection from 32-bit and 64-bit Excel when connecting to both 32-bit and 64-bit QuickBooks versions.
New in IIF Transaction Creator 11.55 (Dec 9, 2021)
- Changes to avoid then error message “Unexpected error; quitting” from a QuickBooks 2022 component that’s only partially installed.
New in IIF Transaction Creator 11.54b (Nov 28, 2021)
New in IIF Transaction Creator 11.54 (Nov 26, 2021)
- Improvements to logic when auto-setting the transaction type when no type is specified or an invalid type is specified.
- Updated messaging when the QuickBooks version can’t be detected before integrating.
- Updated messaging when the connection to QuickBooks fails, offering new suggestions.
- Don’t use an account or a rate when creating or using Subtotal type items.
New in IIF Transaction Creator 11.53 (Nov 7, 2021)
- Improve code that detects the running version of QuickBooks before connecting to integrate lists.
New in IIF Transaction Creator 11.52 (Nov 4, 2021)
- Enhancements for QuickBooks 2022 support.
New in IIF Transaction Creator 11.51 (Oct 21, 2021)
- Add support for QuickBooks 2022 and Enterprise 22.0.
New in IIF Transaction Creator 11.47 (Aug 29, 2021)
- Rework calculation of due date for purchases and sales that use terms. Improve handling for date driven terms.
New in IIF Transaction Creator 11.45 (May 14, 2021)
- New option to ignore the QuickBooks document number field length limits and import up to 20 characters, which are visible in reports but not on most transaction forms. Add messaging to status-bar when checking for a broken QuickBooks connection – useful when it takes a few seconds.
New in IIF Transaction Creator 11.44 (May 4, 2021)
- New feature to try to detect and repair a broken QuickBooks connection with no need to re-run the installer.
New in IIF Transaction Creator 11.41 (Mar 29, 2021)
- Force the selection of the New Transaction column if it’s mapped to another name.
- Fix related issue that caused the column values to be ignored when accounts were set in preferences and not listed on the worksheet in columns.
- Fix code so the DataLayoutHelp.doc is opened from the buttons that call for it.
- Update text on ‘missing columns’ dialog window that can appear when checking data and exporting to an IIF file.
New in IIF Transaction Creator 11.39 (Mar 13, 2021)
- Now only recognize and use columns that contain accounts where the columns are appropriate for the selected layout style. Reword prompt that asks if the last IIF file was successfully imported.
New in IIF Transaction Creator 11.38 (Mar 8, 2021)
- Lots of updates based on customer suggestions related to Sales Tax:
- The IIF Creator will now automatically calculate sales tax and add it to transactions using each customer’s default tax item (previously it would add the tax but not calculate it.).
- Automatic tax calculation now uses both the customer’s and item’s taxable status when calculating the sales tax. If you overwrite the tax rate for a tax group, all the items within it are pro-rated to match.
- Add new “TransTaxable” column, related to sales tax.
- Updated examples to show use of the new TransTaxable column.
- Update Sales Tax section in documentation to match changes.
New in IIF Transaction Creator 11.37 (Mar 6, 2021)
- Revise the AutoTax feature and add document it. Document the “AutoCalc amount” feature, which lets you enter a “?” in amount fields for transaction rows and then the amount will be automatically calculated. Fix an unreported integration issue with group items and sales tax groups where their details would be lost and not automatically added to the IIF file.
New in IIF Transaction Creator 11.36 (Mar 5, 2021)
- No longer put up a notification when there are extra columns on the worksheet, as that caused confusion and extra columns are just fine. Fix Payment transaction example worksheet so the Amount is the correct sign. Correct the name for the Transaction Account column when pulling transactions from QuickBooks as examples. Similarly, fix detail row only example fields that were being cleared incorrectly. Now, when pulling transactions from QuickBooks as examples, enter any date range desired instead of just the last 5 days.
New in IIF Transaction Creator 11.35 (Feb 26, 2021)
- Make sure account numbers, which are not really numbers, are treated like text.
New in IIF Transaction Creator 11.33 (Dec 11, 2020)
- Fix an issue handling integrated lists where records include multi-row text fields.
New in IIF Transaction Creator 11.31 (Nov 24, 2020)
- When an in-product link to our site can’t be opened for some reason, now display a message with the link that can be pasted directly into a browser.
- When checking the worksheet, no longer look for new Items on transaction total rows – since they (correctly) won’t actually be included in the IIF file. For example, the Bank account row of a Check cannot accept an item, nor can the Accounts Receivable row of an Invoice.
- For new name records, now format address fields that contain double-quote characters so the double-quotes can be imported.
- When using the single row multiple amounts layout style, now define up to 100 Detail Rows, up from 10, using the Configure Amounts window’s pick lists.
- When using the single row multiple amounts layout style, now automatically push sales tax rows to the end of each transaction in the IIF file. Now the order of the Detail Row definitions for sales tax no longer matters.
- Significant refresh for most dialog windows to aid in usability.
- Add tool-tip text to many fields in the Layout & Define Columns dialog window.
- Update default field names to match newer versions of QuickBooks. Older versions of the names still work.
- New option, now the default, to use a more reliable method to process temporary files returned from QuickBooks when integrating lists – in order to handle unusual text characters in the files.
- Refresh all help files with cleaner language, streamlined formatting, updated screenshots, and more thorough coverage of settings and preferences.
New in IIF Transaction Creator 11.29 (Nov 12, 2020)
- Add option to skip hidden rows when exporting to IIF! Default to parsed address option when no option has been set.
- Updated support information written to IIF file. When pulling example transactions from your company file, now match the example address to the selected address type option (parsed or block addresses).
- Fix issue where new names were counted multiple times when error checking the worksheet when the names list is very large.
New in IIF Transaction Creator 11.27 (Oct 22, 2020)
- Make sure older annual keys work properly with newer primary keys. Better alert messages when subscription is due or overdue. Add warning to delete key message to explain that it’s unusual to delete keys. Reorganize the IIF file export form for clarity.
New in IIF Transaction Creator 11.26 (Oct 16, 2020)
- Better handling for new names and the default customer name for sales when AP, AR, and the special sales tax accounts are used.
New in IIF Transaction Creator 11.25 (Sep 28, 2020)
- Sales Tax related change: Now use the account from the sales tax item and then if not found use the special sales tax account QB creates, instead of the other way around.
- Handle key entry case where the space between the first and last name is omitted.
New in IIF Transaction Creator 11.24 (Sep 27, 2020)
- Resolve issue for sales tax for QB Canada where the tax rows were written to the IIF file without an account.
New in IIF Transaction Creator 11.23 (Sep 27, 2020)
- Resolve issue introduced in 11.22 that resulted in a run time error when attempting to add an Annual product key.
New in IIF Transaction Creator 11.22 (Sep 5, 2020)
- Better handling for sales tax when new tax items are used on the Excel worksheet or when incorrect accounting is used.
New in IIF Transaction Creator 11.15 (Aug 11, 2020)
- Fix issue where new parsed address fields that use custom column titles were not found during export.
New in IIF Transaction Creator 11.11 (Jul 20, 2020)
- 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.
New in IIF Transaction Creator 11.06 (Jul 1, 2020)
- 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.
New in IIF Transaction Creator 11.04 (Jun 22, 2020)
- 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.
New in IIF Transaction Creator 11.01 (May 18, 2020)
- Improve handling for default transaction types when none are provided in preferences or on the worksheet being processed.
New in IIF Transaction Creator 10.99 (May 16, 2020)
- Ensure the Integration dialog appears before exporting to an IIF file.
New in IIF Transaction Creator 10.97 (Apr 22, 2020)
- Improve double-quote handling for text fields.
New in IIF Transaction Creator 10.96 (Apr 22, 2020)
- Improve handling of billable status field for line details on the Items tab on purchase transactions.
New in IIF Transaction Creator 10.93 (Feb 27, 2020)
- For better list matching, now retain double-quotes for text and list fields instead of replacing with two single quotes.
New in IIF Transaction Creator 10.91 (Feb 27, 2020)
- Resolve OLE error caused by attempting to open the documentation when it’s already open.
New in IIF Transaction Creator 10.89 (Feb 27, 2020)
- Better handling of integration data when QB user doesn’t have sufficient rights to pull lists properly.
New in IIF Transaction Creator 10.81 (Dec 23, 2019)
- Improve code that saves and gets the user-specified temp file location.
New in IIF Transaction Creator 10.79 (Dec 23, 2019)
- Add Paste button to key entry dialog for convenience. Rework messaging when keys are entered incorrectly or for the wrong product.
New in IIF Transaction Creator 10.77 (Dec 12, 2019)
- When using the insert account feature, the selected account is actually copied to the worksheet.
New in IIF Transaction Creator 10.76 (Dec 12, 2019)
- Update list integration code to handle cases where tabs are included within data fields.
New in IIF Transaction Creator 10.75 (Dec 5, 2019)
- 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.
New in IIF Transaction Creator 10.74 (Nov 27, 2019)
- 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.
New in IIF Transaction Creator 10.73 (Nov 27, 2019)
- Now correctly handle group sales tax items when “auto-adding” sales tax to sales forms.
New in IIF Transaction Creator 10.72 (Nov 13, 2019)
- Fix issue where Jobs were not included on Purchase Orders. Minor updates to connection dialog tips.
New in IIF Transaction Creator 10.71 (Nov 6, 2019)
- 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.
New in IIF Transaction Creator 10.66 (Oct 4, 2019)
- Improvements for single-row examples & changes to advise on connection dialogs.
New in IIF Transaction Creator 10.65 (Sep 22, 2019)
- Update code that creates new items to use the correct account column for various layout cases.
New in IIF Transaction Creator 10.63 (Sep 2, 2019)
- Improve layout of the examples dialog window. Improve error checking & related messaging for missing required fields.
New in IIF Transaction Creator 10.62 (Aug 13, 2019)
- Allow up to 20 digits for A/P transaction document number (11 for other types of transactions.)
New in IIF Transaction Creator 10.61 (Aug 6, 2019)
- 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.
New in IIF Transaction Creator 10.59 (Aug 6, 2019)
- 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.
New in IIF Transaction Creator 10.58 (Aug 3, 2019)
- 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.
New in IIF Transaction Creator 10.57 (Jul 27, 2019)
- Include Cost of Goods Sole in the list or account types that can be marked billable on purchase transactions.
New in IIF Transaction Creator 10.56 (Jul 17, 2019)
- Clean up behavior when defining multi-amount transactions.
New in IIF Transaction Creator 10.55 (Jul 10, 2019)
- Change the way check worksheet results are copied. Better messaging when entering a key for the wrong product.
New in IIF Transaction Creator 10.52 (Jun 25, 2019)
- Detect QB 2017 R14 when integrating to avoid QB crash. Put up message to use IIF file method to integrate when using this release.
New in IIF Transaction Creator 10.49 (May 9, 2019)
- Reorder ribbon buttons to put examples in the help section.
New in IIF Transaction Creator 10.47 (Apr 15, 2019)
- 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.
New in IIF Transaction Creator 10.46 (Apr 6, 2019)
- 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
New in IIF Transaction Creator 10.43 (Mar 16, 2019)
- Update to integration error handling – pass back original error message & update suggested actions.
New in IIF Transaction Creator 10.42 (Feb 28, 2019)
- Remove code that truncates document numbers – originally added for QB 2019.
New in IIF Transaction Creator 10.38 (Dec 29, 2018)
- 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.
New in IIF Transaction Creator 10.37 (Dec 10, 2018)
- Fixed issue where Annual product keys were sometimes not displayed.
New in IIF Transaction Creator 10.33 (Nov 15, 2018)
- Dialog window changes to link customers to QB 2019 import recommendations. Tweaks to the file format.
New in IIF Transaction Creator 10.32 (Nov 8, 2018)
- Fix error with insert list record feature that caused an error if there were no integrated lists.
New in IIF Transaction Creator 10.29 (Oct 19, 2018)
- Additional changes for QB 2019. Date fix for some international locations.
New in IIF Transaction Creator 10.28 (Oct 12, 2018)
- Changes to purchase transaction handling so that item and non item rows will appear on the correct tabs in QuickBooks.
New in IIF Transaction Creator 10.27 (Oct 4, 2018)
- Fix issue with mapping dialog that caused lists of records to match to be empty.
New in IIF Transaction Creator 10.26 (Sep 24, 2018)
- Changes to accommodate QuickBooks 2019 and Enterprise 19.0
New in IIF Transaction Creator 10.24 (Aug 26, 2018)
- Updated example templates to address more common questions and display additional columns. Revised notes.
New in IIF Transaction Creator 10.23 (Aug 26, 2018)
- Changes to the column mapping dialog to help prevent invalid Account and Amount field selections. Updated documentation.
New in IIF Transaction Creator 10.22 (Aug 24, 2018)
- Significant changes to the custom menu and Ribbon, and also updated the documentation to match.