Need to get data into Quickbooks

Gregg picture Gregg · Jan 25, 2011 · Viewed 9.2k times · Source

I'm looking for an existing Java (or JVM'able language) library that will create IIF files for import into Quickbooks. Free or Commercial. Anyone know of something?

UPDATE:

After reading a comment on this question, I looked at the IPP and SDK options that Intuit provides and they could not have made this more difficult. So here is what I need to do. I need to take data from my database and export it into some sort of format that I can then import into Quickbooks. This doesn't really even need to be an automatic process as the Quickbooks application/database won't be on the server (linux) that the web applications runs on.

Answer

Keith Palmer Jr. picture Keith Palmer Jr. · Feb 1, 2011

There are a number of free options as well if you're comfy rolling your own (or using Intuit test apps).

If you download the QuickBooks SDK, it includes examples of sending QuickBooks XML documents which instruct QuickBooks to add customers, add transactions, etc. etc. etc. The examples could easily be extended to allow you to copy/paste in an XML document or load an XML document from disk.

You could then build the actual XML files in Java. If you wanted to get really fancy, use JAXB (or an equivalent XSD to Class generator) to generate Java classes from the included .XSD documents, and be able to do things like: InvoiceAdd inv = new InvoiceAdd();

There's documentation about the XML format included in the QuickBooks SDK. You can also find some QuickBooks XML examples on our QuickBooks integration wiki.