EasyBiz Technical Newsletter – July 2014 edition

By Ruaan de Swardt

With technology being what it is, there are always challenges that present themselves in the life of the average QuickBooks user. In this edition we’ll be looking at third party integration with QuickBooks. So, if you’re a developer, ‘listen up’.

Third Party integration with QuickBooks

There are many ways to integrate a third party app with QuickBooks. You’ll be happy to know you don’t have to be a programmer to integrate with QuickBooks either… well at least not for 2 out of the 3 method’s we’re discussing in this edition.

1. Intuit Market Place

The developers of QuickBooks spend a great deal of time testing third party applications. Included in their approved catalogue are products useful for integration – applicable to this month’s article.

2. IIF

Intuit Interchange Format (.IIF) files are ASCII text, CSV files that QuickBooks uses to import/export lists and to import transactions. The .IIF import and export utilities are on the QuickBooks File menu.

Importing and exporting .IIF files created by QuickBooks are fairly easy to do as QuickBooks formats the file for you. However, creating .iif files from scratch or adapting data from another programme is technically complex and may be difficult if you don’t have experience of formatting delimited text files. In that situation it may be faster and easier to enter the information directly into QuickBooks unless you have very large amounts of data to import.

If the Intuit Market Place and IIF option were dead-ends, you’ll need to sign up with the Intuit Partner Platform (previously known as Intuit Developer Network). You’ll need to have a sound understanding of the following: