Quickooks Sync
Integration with Salesforce

Syncing any program with Salesforce can have some headaches. I’ve dealt with several Quickbooks sync programs for Salesforce and will share my advice and experience.

The first thing I like to consider when someone tells me they want to sync Quickbooks with Salesforce is to first checkout what they are using Quickbooks for. In some cases businesses are using Quickbooks on a pretty basic level to just track payments and invoices, etc. In this case sometimes it makes sense to just add some custom objects and customizations to their Salesforce to replace the functionality of Quickbooks. Sometimes accounting is really simple and just tracking numbers, etc. Salesforce can be pretty good at that.

If you need to sync Quickbooks to Salesforce then you need to know what you need to sync specifically, in what directions, and what edition of Quickbooks you have. In all cases you will need the Salesforce api which means professional edition, force.com edition, or enterprise, or unlimtied. On professional edition you can purchase the api seperatly.

The cheapest solution right now is the new Salesforce app that was developed by Intuit. They actually bought the app from Pervasive. It’s an out of the box solution to sync Quickbooks with Salesforce. It syncs only with standard objects: Accounts, Opportunities, Products, Opportunity Products. It’s not awesome but it does work fine as long as the way its syncing works for your business. You can’t modify it. I’ve done some work arounds before using fields that do sync to indicate other things in Salesforce. That costs $45/month. Their support is actually pretty good right now. Way better than what Pervasive was doing.

The next step up from that is DB Sync. They have a basic edition and enterprise edition. The basic edition will sync with all standard objects: Accounts, opportunities, products, opportunity products. You can even map some custom fields as long as they are on the standard objects. It’s about $900/year. Not too bad. Their support is good, but they are in India and hard to understand the accent sometimes. Their enterprise edition allows you to sync with any custom object. You can do a full custom sync. Their application for customizing is not super user friendly and I would not recommend someone to just try to figure out. You can pay them to customize it for you or pay a consultant like us. The key here is understanding your objectives and business process to make sure that you are setting up data syncs and intergrations in the way you need it. We typically understand that first, then create a mapping document to outline how we need to sync the data from Quickbooks to Salesforce, then setup the mapping. This program costs about $1500/year.

You also need to consider the first time migration of data from Quickbooks. You can use this program to do one time migrations too. This is a different process.

We have heard horror stories from many clients about other quickbooks syncing programs and we also have our own. Unfortunately I would not say there is a simple solution that is awesome for everyone. We are considering to develop our own app for Salesforce to Quickbooks sync.

Syncing any program with Salesforce can have some headaches. I’ve dealt with several Quickbooks sync programs for Salesforce and will share my advice and experience.

The first thing I like to consider when someone tells me they want to sync Quickbooks with Salesforce is to first checkout what they are using Quickbooks for. In some cases businesses are using Quickbooks on a pretty basic level to just track payments and invoices, etc. In this case sometimes it makes sense to just add some custom objects and customizations to their Salesforce to replace the functionality of Quickbooks. Sometimes accounting is really simple and just tracking numbers, etc. Salesforce can be pretty good at that.

If you need to sync Quickbooks to Salesforce then you need to know what you need to sync specifically, in what directions, and what edition of Quickbooks you have. In all cases you will need the Salesforce api which means professional edition, force.com edition, or enterprise, or unlimtied. On professional edition you can purchase the api seperatly.

The cheapest solution right now is the new Salesforce app that was developed by Intuit. They actually bought the app from Pervasive. It’s an out of the box solution to sync Quickbooks with Salesforce. It syncs only with standard objects: Accounts, Opportunities, Products, Opportunity Products. It’s not awesome but it does work fine as long as the way its syncing works for your business. You can’t modify it. I’ve done some work arounds before using fields that do sync to indicate other things in Salesforce. That costs $45/month. Their support is actually pretty good right now. Way better than what Pervasive was doing.

The next step up from that is DB Sync. They have a basic edition and enterprise edition. The basic edition will sync with all standard objects: Accounts, opportunities, products, opportunity products. You can even map some custom fields as long as they are on the standard objects. It’s about $900/year. Not too bad. Their support is good, but they are in India and hard to understand the accent sometimes. Their enterprise edition allows you to sync with any custom object. You can do a full custom sync. Their application for customizing is not super user friendly and I would not recommend someone to just try to figure out. You can pay them to customize it for you or pay a consultant like us. The key here is understanding your objectives and business process to make sure that you are setting up data syncs and intergrations in the way you need it. We typically understand that first, then create a mapping document to outline how we need to sync the data from Quickbooks to Salesforce, then setup the mapping. This program costs about $1500/year.

You also need to consider the first time migration of data from Quickbooks. You can use this program to do one time migrations too. This is a different process.

We have heard horror stories from many clients about other quickbooks syncing programs and we also have our own. Unfortunately I would not say there is a simple solution that is awesome for everyone. We are considering to develop our own app for Salesforce to Quickbooks sync.