Search code examples
sqlreportquickbooksbuilding

Approaches to building reports with Quickbooks 2008+ Data


I am looking to build some reports for Quickbooks data, without using Quickbooks built-in reporting, or through a third party library (like QODBC).

Quickbooks 2008 and newer are built on a SQL backend.. In looking around there seems to be several products and angles to do this from.

Ideally I would like to be able to do direct SQL hits on the database myself, or use something like Crystal Reports.

I wanted to ask here to gather any things to look at closer, and what to potentially avoid to save myself grief.

Thanks in Advance!

Update: It seems Quickbooks encrypts it's sql database so you can't read it directly with a reporting tool.. There are a few products on the market that can help.. more to come.


Solution

  • Your best bet is the QuickBooks SDK, it provides facilities to fetch data and also fetch reporting data directly from QuickBooks, formatted as XML for easy parsing and display however you want to display it.

    You can see the data that's available using the qbXML/QBFC QuickBooks On-Screen reference (the requests you can send to QuickBooks are found in the 'Select Message' drop-down box at the top of the screen).

    The QuickBooks SDK is a free download (registration required) from the Intuit Developer Network

    If you're writing a desktop application, you can look into using QBFC, which is an API that talks to QuickBooks using COM/DCOM.

    If you're using PHP, there's a popular QuickBooks PHP framework on the IDN forums.

    If you're using ASP.NET, here's a QuickBooks ASP .NET framework too.

    If you want direct SQL access, you should look at QODBC (which is an SQL wrapper which translates SQL queries to qbXML SDK requests) or AccessBooks (which uses the SDK to mirror QuickBooks data to an SQL database).