Contribute to the Quickbooks Connector

@kanhaiya I did read the post and we have done that. It imported maybe 50 invoices out of 700 and stopped we couldnt get it to work after that. The main reason I was asking though was to see when the app would be published on the quickbooks store.

@woakes070048 What error you are getting while trying this solution ? Shall we help you in that.

Before getting into production, we are doing all possible iterations with current use case of our customer. Once we resolve all bugs and issues then we will work on pushing it to Quickbooks store.

@kanhaiya that was one of the problems we were not geting any errors it just stopped syncing and would not start again

Quickbook shifted from OAuth1 to OAuth2 after july 2017. And changes are not made in connector. :frowning_face:

Have you tried connecting and is there any issue?

yes there is issue because in your setting you are using consumer key and secret. but in new settings there are client ID and Client secret.
I developed odoo-quickbooks connector that I had to change when quickbooks changed their settings
please find screenshots attached

@nauman_sharif but things are still working for ERPNext v7 (app was launched for this version) and QuickBooks (India/Singapore) at our end (which we have tested). You probably overlooking/comparing with your experience of Odoo, I am not sure how fair that would be unless you try it.

In that case you may wait till Feb mid. very tentative for next release update. We are working on the upgrade currently.

@gupteshwar I have installed your app and trying to make it work for last three days. You are right that app is working fine on your end but it works with quickbooks old apps(oAuth1) that where created before july 2017. Quickbooks now does not allow to create apps with oAuth1 as they launch oAuth2 support.
Can you please create a new app on quickbooks and try testng connector with that.
Thanks for response :slight_smile:

bghtrbb added the OAuth2 connector here. I’m wondering if you guys can merge it and the develop branch to master (I made a pull request from his master to your develop). This will really influence us to move to ERPNext.

The Indictrans QBO codebase is being moved into the core by the Frappe team with an NET release of next month. Both sides of which were sponsored in part by Parsimony.

The following is an opinion:
The biggest shift in a change from QB to ERPNext is about Items. QB is beautified checkbook, ERPNext is a whole lot more than that, but contains a very powerful Stock Ledger (which is in ERPNext more of a driver of the accounting functions than QB, where Items are an afterthought). Bottom line, if you need to keep track of “things”, QB is inadequate. Also erpnext.com hosting is cheaper (~3:1) and their support is better. What don’t you get? US localizations, maybe. Integration with Paychex? Hard pass.

Why haven’t you the switch already? </sarcasm>

3 Likes

First of all, Thanks!
Second of all, the main reason we haven’t moved yet is primarily because it takes time to move to a new system, and train the employees, second reason is because the non-profit module isn’t complete and as we are a non-profit this is critical (I have been working on adding the necessary parts but I’ve hit some roadblocks), third is simply because QB is a more standard accounting tool and if we need to bring in a contractor, teaching them a new system is quite impractical.

Yes, this true of any conversion in accounting systems, which is why they tend to happen something like every other decade or with a change in ownership. But at this point we’re hijacking this thread. If you want specific help with a QBO migration, start another thread and tag me.

Is this connector/migrator live?

It’s ready in V11 which is a developer release not for production use as yet.

But you’re welcome to test it :grin:

I do not think it’s released even in v11. The QuickBooks connector is still under active development. I have not heard or read about any progress on the QBO/Tally connector announced in the Oct-18 conference.

Maybe @adityahase could give us an update on the latest status.

There is a “Quickbooks Migrator” in v11 and it is tagged as “under development” when the DocType loads on the screen.

1 Like

Where can one go to see if there is any movement on this project?

There would be many potential newcomers to ERPNext if there was a working connector to QB online. I would like to try to follow along on the progress.

BKM

@adityahase is actively working on this project of building a QuickBooks Connector. We recently tested it (2 weeks back) with our live data in QuickBooks. The connector is being built only as a Migration tool for the first time adopter of ERPNext and it has only one way sync from QBO >> ERPNext.

From our testing, we found some issue still existed and we reported those to Aditya and looking forward to hearing more updates from him soon.

1 Like

Ahh… ok. So, this project is intended to allow new users to switch from Quickbooks to ERPNext as their financial accounting tool.

Is there a plan to allow a one way sync from EPRNext to Quickbooks Online?

The reason I ask is there are many many small businesses that have been with QuickBooks Online for a long time and their paid 3rd party accountants (the firms that do their taxes for them) only accept QuickBooks data.

This means they want things like Sales Invoices and Purchase Orders to transfer over to QuickBooks instead of the other direction.

Quickbooks currently has the best method of allowing a 3rd party accountant to balance the books and do taxes at the end of the year. They have a special “Accountant” feature that moves a backup of all QBO data to a file the accountant can manipulate in order to get the year end data finished. When the accountant is finished he send back his modified version of the data and it is restored to the customers QB database so they can continue into their new year.

Newer versions of QBO give the accountant a direct login to the account ad bypasses this function. However, ERPNext is not designed from a workflow perspective to allow for this kind of work (at least not yet). More importantly, there is not enough ERPNext clients in the wild yet to generate the interest in 3rd party accountants to learn the current system because QB make a special accountant version that does all the hard work for them. ERPNext does not have that either.

So the drive for most small businesses is to adopt only such software systems that allow them to continue to use QB as their accounting package because they do not want to try to find an accountant that knows how to use ERPNext.

Honestly, it appears you took on the most difficult path for your project. ERPNext is a constantly moving target and I believe there are fewer people wanting to follow in your chosen direction. Most would prefer the opposite. Even if QB is horrible, terrible and nasty, it is what their accountants require and they will go to almost any length to avoid having to find a new accountant (including passing on ERPNext in favor of a lesser quality package).

BKM

:slight_smile: it is not me.
It is some passionate people like yourself in the USA sponsored building a two-way connector with QBO. So, that Accountant in the USA are happy with their job and businesses (SMB) can leverage other aspects of ERPNext -like robust Inventory module, Workflow, etc…

However, the project of building two-way sync integration did not fly much, it had several bugs (this is what is being told to me), after that the second attempt is to build a migration tool from QBO to ERPNext.

So, what you are asking is the Ideal thing to have and there are few financial supporters are there, but I believe no passionate developer exists in the community to take up that challenging task.

1 Like