Hello,
Are there ways to synchronize QuickBooks accounting information with Dolibarr? Either a turn key plug-in or another solution such as writing some code or setting up a sync database?
Thank you!
I neglected to mention this is for the local / desktop version of QuickBooks. Not the online version.
I will take one for either the desktop or online version. A way to sync is much needed. Anyone willing to make something we can purchase from Dolistore?
Hi
Synchronise QuickBooks to Dolibarr ?
Synchronize for what ?
Explain your usage please
@+
Hi Philazerty,
Speaking for myself, it would be nice to have a way to get our financial data (transactions, supplier receipts/invoices, etc.) into Quickbooks without needing to do a daily export/import. We need the information to be in Quickbooks for printing checks, running reports that Dolibarr does not, electronically making our sales tax payments, plus we simply make a copy of our QB files for our accountant at tax time. So it is important that the transactions we input into Dolibarr are able to be easily and accurately recorded in QB.
^^^^ Yes, this is similar to the type of functionality we are looking for as well. There are other ERP systems that have built in integration with QB; an automatic sync function.
Here are a few examples of those:
https://www.mydbsync.com/product/accounting-quickbooks-and-quickbooks-online-edition
Quickbooks API allows integration.
https://developer.intuit.com/docs/0200_quickbooks_desktop/0100_essentials/0000_overview
Look at Web Connector for the QB Desktop.
1 Like
Thank you Alexnca. I will take a look!
Hi, I am trying to do the same syn doibarr with quickbooks for our accountant.
Can you please guide us with the setup process.
quickbook webconnector is asking for .qwc file (where to get that)
what kind of setup is required in dolibarr for sync process?
waiting for reply.
Thanks.
nazeer,
A .qwc file is a proprietary extension for Quickbook files. Quickbooks has its own schema as well that is very difficult to map with other databases. I ran some testing with a connector called Consolibyte and i was able to successfully connect QB desktop to an online PHP database, but the database had to also be based on the QB schema (same tables, fields, etc.). Since Dolibarr’s database is not the same schema as Quickbooks, it is more difficult to map. You would need to find a developer to customize this for you.
There seems to be a REST-API:
https://developer.intuit.com/app/developer/qbo/docs/develop/rest-api-features
thanks for reply.
I have checked REST API can’t figure out anything.
I used demo script to create qbc file and got connected using SOAP, but its keep on asking to enter password to complete sync process.
where can I get password ?
the help of quickbooks says the password will be provided by web service server which in this case will be dolibarr.
any insight?
tx.
I didn’t use SOAP before - so I guess it is here:
For the REST API you should login with your user name here, which will be used/addressed later on:
Thanks for quick reply.
Yes I saw that in SOAP and tried to used that as password in Web Connector of Quickbooks but authentication fail error.
You are right I saw REST/API too and found the way for user and password. But the problem is Quickbooks Desktop version only uses web connector to sync and not API.
Hi guys, any update on this issue?
I am new to Dolibarr so I can’t speak to spefics, but it seems the API interface for Dolibarr is based on REST API (I just saw they have the option for a SOAP one). The way QuickBooks desktop SDK works it via a desktop app (Quickbooks Webconnect). This external application implements the QB SDK via a SOAP API (using qbXML format). The external (to the quickbook application), will make very speific SOAP calls to the SOAP webserver listed in the .QWC file.
[QB]<->[QWC]<via SOAP QXML>[webbased sever]
QWC is setup to call out to the web-based server at defined intervals of time, there is no provision for the webserver to reach out an activate QWC. Thus on the webserver a que used to queue up request for QB to handle when QWC eventually ask for them.
There, fortunately, are many tools out there that have been created to implement a SOAP to REST API server, which means there is a possibility with some work to create an interface.
One of the best resources to use is http://consolibyte.com/quickbooks-open-source/ keith gives a good explanation and starting point.
From my perspective there are two ways to accomplish this
- Create a dolibarr module
- Create a sync server running on the same dolibarr platform that accepts SOAP from QWC and interfaces with dolibarr via API.
It seems #2 could be easier to implement than #1.
https://github.com/jsgoupil/quickbooks-sync (uses SOAP and .net)
https://github.com/GPCsolutions/doliwoo (an example Woocoommerce SOAP interface) Could be repurposed into a QB sync but plug seems outdated.
Thanks for reply.
I am still struggling to understand the best solution.
going through links. thanks…
trying to find where to put username and password that QWC is asking to authenticate?
Hi,
I have gone thru the above suggested consolibyte resources.
My confusion is do I have to user those resource to as middle man between dolibarr soap and quickbook webconnector.
Where do I enter user name and password for authentication?
going nowhere with this problem
Any1 tried this?
You can use Consolibyte, you would just need to map the Dolibarr database to the Quickbooks database, which I have been told by developers is very tricky because QB has a lot of sub-tables that need to be taken into account. Are you a developer? Have you tried mapping the tables?
