Dear All,
Here we go with the latest updates of Quickbooks connector.
Feedback and queries from community will be appreciated.
Regards,
Kanhaiya Kale
2 Likes
Thanks for the updates. Is the code on github?
When your done this integration, would you guys consider doing another campaign for a ERPNext <-> Xero connector? I have been wanting to write one myself, but have not had the time. If you were to run another crowd funding campaign for Xero, I would certainly make a contribution.
Any other interest?
@ebjorsell yes, code is on github. You can check out and share your feedback if any.
Once this QB connector is accomplished, we can take up Xero Connector campaign. We can discuss the scope once we release this QB Connector. Thanks for showing interest.
2 Likes
Hi Guys,
How’s the quickbook connector coming along? 
Jev
You can track the progress at the official repository: GitHub - indictranstech/erpnext_quickbooks
2 Likes
Has anybody tested this with v7?
@vjFaLk @rmehta Is this project still going? I have checked the github and found that the last commit had been 2 months ago and there is also a pull request. Is the reason that is has not been finished from a lack of funding?
@fblauer I saw that it was updated 3 days ago by @arpitjain06. [small fixes regarding syncing] · indictranstech/erpnext_quickbooks@badc662 · GitHub
Hope that helps I am waiting for the release aswell
This still ongoing? My Company will not move to ERPNext unless this is in place.
Hoping its going well.
@DCTM2015 I can tell you that it is almost 100% working. I agree without this i have a lot of clients that wont move to the system even though ERPNext accounting module is really good. My hope is that it will be adopted by the ERPNext team.
1 Like
Officially adopting the integration would be a huge win for erpnext. Syncing to online bank accounts seems like the most attractive feature of this, bringing everything into erpnext on our end.
If it wasn’t properly maintained, it could turn a lot of people off
1 Like
I agree it would be a massive win for ERPNext. For all of the business i support they wont use anything other than quickbooks. I think it is like that in most places. People trust accountants and accountant trust quickbooks.
2 Likes
Hi All,
QuickBook connector is working fine, we are recently going through a production testing with one instance.First sync and subsequent data sync up is working fine. I suggest you should try that first replicating your QuickBook data to Sandbox and integrate with ERPNext sandbox as your dry run and then move to production (just on precautionary note). However, QuickBook to ERPNext (one way) sync will not hamper your QuickBook production data over trial.
Feel free to record the issues if any you face with required pre-cautions from Error while connecting to Quickbooks
This is ready for Fresh ERPNext setup with old or new QuickBook account as of now. This works for only one company from ERPNext to one QuickBook account as of now.
References–
QuickBook – QB
ERPNext – EN
QuickBook data in ERPNext – QBinEN
There are certain areas where this need fixes or precautions,
- Currently Chart of Accounts from QB gets replicated to EN Chart of Accounts as part of sync hence you will see duplicate account heads. Post first master sync you should have a look at chart of accounts and fix up well with the help of your accountant, so as Chart of Accounts on both end should look similar and preferably QuickBook structure to be followed. There will be no way back once you move ahead with this unfixed Chart of Accounts.
- As part of above exercise you should remove the EN account heads (value should be 0) and keep QBinEN account head only. There will be dependency of EN account heads in respective company page and it should be replaced with QBinEN account head before removing those EN heads. (Anyways throws error otherwise on removal)
- Once above exercise is over we should have chart of accounts in both application should be identical and you are ready to receive the data from QB to EN.
- Tax Master (and all account master rather) should be maintained in QB only so as both way sync from QB to EN should work smoothly. Currently, master sync from EN to QB is an open issue due to limitations from QB API.
Further Fixes in development,
- Provide a comparison of chart of account heads from both application as part of first sync so as should be easier to fix the chart of accounts in ERPNext with this lookup. But rest all will be manual work to cleanup.
- Provision to move EN account head with amount with identified account head of QBinEN. So, as we are provisioning to clean respective EN account head first making it zero. This is still a challenge to resolve with proper solution.
- QB doesn’t provide tax master link with chart of account head through API. Tax booking for sync up data doesn’t work properly as we stand clueless to book tax. Currently this has handled through consolidated tax head booking. Further we have tax master in QuickBook integration settings with mapper between Tax from QB and respective account head in EN. So, this works only with first (as consolidated) entry, we will make it functional with complete mapper in place.
- Many more small suggestions and fixes.
Hope to see more feedback to make it more useful.
–
Gupteshwar
Indictrans.
2 Likes
Glad to hear its almost there. Thanks everyone for your efforts. I’m looking forward to working with this system.
Hi Gupteshwar,
I participated in a benchmark program that pulled QB data into excel (via the general ledger report) where we had ~45 CoAs to reconcile into a common CoA. We did this by programming with some ‘mapping’ code in Excel that read all the accounts in the ledger and then combined them into the common CoA for the benchmark. It took a bit of work (and communication with the customers) to get the mappings right the first time, but they generally stayed true year-to-year.
- IMHO, you are on the right track with mapping functionality.
- How are you storing the mappings so that they are repeatable? Consider CSV, because there will be folks who are fluent in spreadsheets but get lost with python linked lists. (People like me). This also allows versioning and alternative presentations. Franchisees particularly like to be able to map from a specific CoA to a common or benchmark CoA.
- I don’t like QuickBooks at all but everybody in my industry uses it. Changing habits is harder than changing minds.
Keep up the good work and best of luck with your project!
-T
2 Likes