Quick Books API

Posted on 2014-08-18
Last Modified: 2014-08-21
Is there a Quick Books API that can be used to synchronize a QuickBooks database on a Windows Server 2012 OS with a web server based MySQL Database?

We are presently running a Microsof Access set of Macros / Queries where the corresponding QB tables are references as external to the Access database. We synch once nightly using a Windows scheduled task to initiate the process. It's messy & fails under certain conditions.

It would be nice to synchronize "on the fly".

Question by:Richard Korts
    LVL 31

    Accepted Solution

    QuickBooks does have an API, although I haven't personally dived into using it, it is most definitely possible to interact with a QuickBooks database via a programmable API for the purposes of synchronizing or interacting with the data.

    You need to join the Intuit Partner Program, and download and take a look at the QuickBooks Desktop SDK.

    Author Comment

    by:Richard Korts
    I have seen some references on the web to a php / Quickbooks integgration. I am very familiar with php. Does someone know about that? I saw a reference to an example of where a customer is created in a store (on-line), causing that same customer to be created in Quick Books.

    We probably want the opposite; create a new QB customer, synchronize with the web by inserting in our web MySQL database.

    But we need the reverse too; invoices are paid on-line, we would want those to update in QB instantly.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    By Linda Saltz Customized item descriptions from bills DO import into a customer invoice!   This is a wonderful tip for companies that want to use generic items like Hardware, Software, Mileage, Travel in their item list which helps keep the i…
    You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now