CODEWITHSUNDEEP
ruby-on-railsquickbooks
Carter
Carter

Reputation: 2870

How should I import data into QuickBooks from my Rails application?

I'm working on a Rails project that needs to be able to import/export (mostly import) invoice data to/from QuickBooks. In Googling, the QuickBooks SDK and Web Connector come up often. However, both seem to only be for the Windows desktop versions. This QuickBooks instance is on a Mac.

The import can either be via an API or, if possible, a file could be generated from within the web app that could later be imported manually.

Currently, QuickBooks 2009 is what's being used. However, assume we can use nearly any version of QuickBooks. Online or desktop (Mac).

What would the best route be to get invoice data to/from the Rails application to QuickBooks?

Upvotes: 0

Views: 678

Answers (1)

Keith Palmer Jr.
Keith Palmer Jr.

Reputation: 27962

Unfortunately, QuickBooks for Mac does not support any real method of integration. It's definitely the "black sheep" of the Intuit family.

The closest you can get is IIF file imports/exports.

There is detailed information on this (deprecated, and very limited) file format over here:

You would be so, so, sooo much better off moving off of QuickBooks for Mac through, as the APIs for both QuickBooks for Windows (Web Connector/SDK/COM) and QuickBooks Online (REST v3 APIs) are much, much better than IIF imports/exports.

Upvotes: 1

Related Questions