OpenSync 3.0

OpenSync 3.0

3.57 out of 5
(14 customer reviews)


OpenSync is a server-based QuickBooks integration designed to perform a QuickBooks sync to and from an external database including Microsoft Access, MS SQL Server, MySQL, Microsoft Azure, or Oracle.  This provides a platform for building highly scalable applications that integrate with QuickBooks.  Applications for this replication engine include web site integration, custom report generation and publishing, time tracking applications, and Microsoft SharePoint integration.

Click here for a brief video demonstration.

Click here for downloadable help documentation.

Download OpenSync version 2.x here

If you want to get a feel for the database that OpenSync creates and maintains for you, click here to download a populated sample database (in Microsoft Access .MDB format).

Contact us regarding embedded licensing programs in order to bundle OpenSync with your application.

Login or register to download a 30-day free trial of OpenSync

  • New to 3.0: The configuration program now preserves the state of the tree view.
  • New to 3.0: The location of all configuration data has been changed to more accessible location for all users
  • New to 3.0: Database schema has been modified to support fully typed columns and primary keys
  • Full QuickBooks 2021 Support and below
  • Bi-directional QuickBooks Synchronization with the full version
  • Synchronize with MS Access, Microsoft SQLServer, MySQL, and Oracle databases (OpenSync's database)
  • Sync multiple QuickBooks files to individual databases created by OpeSync
  • Automated background operation after you manualy start OpenSync's scheduler service
  • Robust diagnostics and support services
  • Easy to use wizard interface for configuration
  • Integrated database browser
  • An effortless QODBC alternative
  • Import transactions into QuickBooks with ease
  • Now with Microsoft Azure support!   |   See details

Clear selection
SKU: n/a. Category: .

Product Description

Bi-directional QuickBooks Sync Made Easy

With the OpenSync QuickBooks sync solution, you can avoid the overhead of learning the QuickBooks API and use standard database tools to read and update QuickBooks data. Performance bottlenecks inherent in the QuickBooks QODBC driver and the QuickBooks Web Connector are eliminated since the sync technology enables you to run your application against a true database server. Forget about import and export tools, OpenSync provides near real time database synchronization with QuickBooks.

It also provides the ability to perform a QuickBooks sync with multiple company files with multiple external Access, SQL Server, MySQL, Oracle, and now Microsoft Azure databases. Changes made in QuickBooks are automatically synchronized to the external database and changes marked in the database are automatically synchronized back to QuickBooks.

OpenSync defines three fundamental concepts to support its operation. These are company files, databases, and tasks. Company files are QuickBooks company files and these must be configured within OpenSync. Databases are either Access, SQL Server, MySQL, Oracle, or Microsoft Azure databases loaded with the OpenSync schema. A task is the fundamental unit of work. Each task defines a company file, a database, an operation, and scheduling information. OpenSync’s sync operation is defined by the configured tasks.

QuickBooks sync tasks can be run either interactively through the OpenSync configuration program or in the background by the OpenSync background processing service. The OpenSync service can be configured to run even without having to log on to the machine and can be controlled through the configuration program.

Release Notes

Click here for a brief video demonstration.

If you want to get a feel for the database that OpenSync creates and maintains for you, click here to download a populated sample database (in Microsoft Access .MDB format).

Note: If you’re having issues syncing data back to QuickBooks, make sure the STATUS column of your parent record is set to ADD or UPDATE.

Additional Information


OpenSync 3.0 License, OpenSync 2.0 to 3.0 Upgrade


Click here to go to the full FAQ page.

99.5% of the time it’s because you didn’t set the STATUS column to ADD or UPDATE. The former is for creating new records in QuickBooks the latter for modifying existing.
Yes, by configuring the OpenSync service to run at system startup there is no need to have a user logged onto the server.
Yes, OpenSync support the Canadian, UK, and Australian versions of QuickBooks.
Yes. OpenSync only requires an ODBC connection to the database server.
This indicates that you do not have the ODBC driver for your database server installed.
Yes, as long as you can establish an ODBC connection to the database server OpenSync will work with it.
Absolutely. A help doc is packaged with the application however you can also view an updated PDF of it here
Absolutely. OpenSync is not a service. It is a standalone application that you install on any PC with a QuickBooks installation and let it sync away.
Nope. You can install OpenSync on any PC with a QuickBooks installation. It doesn’t require any advanced technical know-how beyond the ability to log into a SQL database server – assuming you’re not using MS Access.

In short, it will create a database in any of the supported formats, flush with every field and tables the API currently provides access to, and then export any and all data you specify to it. Then, on an interval you designate, it will synchronize with QuickBooks to ensure all data is current. In the event that you add or modify data in the database, that information in QuickBooks will be created or updated respectively. It’s just that simple.

3.57 out of 5

14 reviews for OpenSync 3.0

Add Review  If you leave a review we will send you a 5% off coupon. We love feedback.

  1. joseph4
    1 out of 5


    ALERT – I just spoke with the developer whose number is listed in the contact tab. This company has gone out of business.. do not buy!
    Working on getting refunded now.

  2. joseph4
    4 out of 5


    The tool is easier to use than similar products. Installation and configuration was quick and simple. It would be nice if it would work around the QB limitation of requiring third party apps to authorize through a local QB installation. I’ve run into a couple of bugs and the transfer of data is fairly slow (presumably because how it needs to extract the data from quickbooks), but it seems to work so far.

  3. ashok
    5 out of 5

    (verified owner):

    Works very well for my purposes. Been using 2.x for a long time, and needed 3.x to support latest DB version.

  4. Mark
    1 out of 5

    (verified owner):

    The good: It syncs data to mysql
    The bad: Lots of bugs, not that much insight into what it’s actually doing in quickbooks.. unable to trace/debug why we cannot delete invoices or other operations.
    More bad: We paid for premium support and the support has been very slow. Basic bugs have not been fixed in several years. This is the last month we’ll be using opensync and we’re moving to QODBC.

  5. jk.peralta
    4 out of 5


    BTH yes thats the only problem you need to create a button to do that, but this opensync really helps us to make an improvement to quickbooks.

  6. LessPaperCo
    1 out of 5

    (verified owner):

    We have had a lot of problems with OpenSync and, unfortunately, their customer service is some of the worst customer service I have ever experienced in my entire life. We’re paying hundreds of dollars for this software and we were purchasing it at least once a month for our clients and yet they can’t seem to fix “simple” bugs for us. It’s hard to get any kind of response from them. They’re about to lose us clients because we have a few clients who cannot stand these bugs anymore and are threatening to cancel service with us. If/when this happens we’ll be charging back our credit card to get our money back for the purchases since we bought defective software that OpenSync obviously doesn’t care about fixing.

  7. maryellen.currie
    1 out of 5

    (verified owner):

    We purchased OpenSync 3.0 after using the 2.0 version. We upgraded to 3.0 because the software supported the line item sequence number field which is stored in QuickBooks. This feature is also touted on the Synergration company website. It suddenly stopped working. When I posted a question about this on the forum I was told that OpenSync didn’t support this field. I got this answer after purchasing a premium support subscription. Very frustrated.

  8. kevin9
    5 out of 5

    (verified owner):

    Product works perfectly. Easy to use.

  9. gurtejsingh
    4 out of 5

    (verified owner):

    Great product.. only problem I faced to make filled for sync with qb

  10. jeff.clements
    5 out of 5

    (verified owner):

    Great product. Easy to configure. Exported to a SQL database for reporting. My only complaint is that it can be very difficult determining which fields are used to relate the tables.

  11. lars
    4 out of 5

    (verified owner):

    Does what it needs to. Would be four stars if transactions synced billable status without a repopulation.

  12. K Readle
    5 out of 5


    What a great tool. Solved our issues and was easy to setup.

  13. edgar
    5 out of 5


    amazing wish i found this earlier

  14. BTH
    5 out of 5

    (verified owner):

    OpenSync works great for us. We tried other ODBC tools and found they were very slow for a large QB data file

Add a review