Cool Tool for GL Interface imports to QuickBooks

One of my clients is going to start using the GL Interface to import into QuickBooks. In testing how it works, their accountant was not happy with the fact that QuickBooks doesn’t provide any kind of error checking or even error logging when importing IIF files.

In doing a search of what QuickBooks utilities are out there in the world, I came across one that is both cheap and useful and thought it might be of interest to others in the iMIS world:

http://www.aaatex.com/QuickBooks_IIF_Importer.htm

I have tested their trial version and we’ll be doing a second round of testing with the full version prior to going live with this tool, but here’s what I found so far:

• You don’t have to do anything to the file that comes from iMIS. You just browse to it with this tool and hit the Import button.
• You can set up the utility so that it renames the import file after you’ve imported it, so it makes it much easier to avoid duplicate imports.
• The import is actually using QuickBook’s new import method so if there is a problem in the import file, you get warnings and the ability to abort before bringing in the data, as well as an error log for both successful and failed imports. I faked an import of an unbalanced transaction and the attempt to import failed.
•  It's only $199 for the Basic version, which is sufficient for importing Journal entries.