Salesforce Litify and QuickBooks Desktop
Introduction
DBSync for Litify and QuickBooks Desktop Integration is an easy to use application. It integrates Litify Customers, and Transaction with QuickBooks Desktop Customer, Vendor, Account, Bill, Purchase and Deposit. DBSync provides integration with pre-built field-to-field mapping along with flexibility for more complex and dynamic mapping capability. DBSync's automatic online update enables its customers to enjoy all the product updates and features that come with every new release.
Data Flow
Data flow integration between Salesforce Litify and QuickBooks Desktop Integration is shown in the table below.
Salesforce Litify | QuickBooks Desktop |
Litify Transaction Party | Vendor/ Customer |
Matter Number
| Job |
Transaction Bank Account/ GL Account | Account |
Litify Transaction | Purchase, Bill, Deposit, Credit Card |
Litify Group Transaction | Purchase, Bill, Deposit, Credit Card |
Transaction CheckNumber, Status | Expense Payment |
DBSync Profile and Application Setup
Go to www.mydbsync.com & register for Free Trial. Ensure that Source and Target Adapters are Litify and QuickBooks Desktop respectively.
Login to DBSync Cloud Workflow
Click on 'Login' and choose 'Cloud Workflow' as shown in the image below:
Provide your 'User Name' and 'Password' setup during signup and click 'Login'.
You will be redirected to DBSync Cloud Workflow Home Screen as shown below
Click on Salesforce Connector and choose 'Login to Salesforce'
You will get a pop-up to confirm your Salesforce - Username and Password. Enter Credentials, accept T&C and click 'Login' as shown below:
Click on QuickBooks Desktop Connector and download the QuickBooks Web Connector. Ensure you copy the file path from QuickBooks Desktop and provide the details in 'QuickBooks File' location. You can also choose the version as shown in the image below.
Step1: Download QuickBooks WebConnector to run this task
QuickBooks File: To know the path, open the QuickBooks app and press the function F2 (or Fn+F2) key from your keyboard. File path is mentioned in the 'File Information' section.
QuickBooks Version: Choose the version as 2014 and more
Select the number of retry counts. Usually 2.
Save the setup
Step2: Select the task to download QuickBooks WebConnector
Project Name: It will be the default current project
Task Name: Choose which task to be automated.
Click on download as admin mode and single user, and double click the .qwc file.
Make sure your QuickBooks Desktop file is opened
Select the option 'Yes, always; allow access even if QuickBooks is not running'. Then, select 'Admin' click on continue.
DBSync integration process will be added to your Quickbooks Web-Connector. Once the process is added to the web-connector, add the DBSync account password in the Password section of the Web-Connector. Then press ENTER and click on "yes".
You are now ready to run the integration using pre-built forms.
OR you can establish a connection with your application during the template import process. The initial step of the Setup Wizard involves linking to your applications.
Process to Run the Integration
To utilize the pre-built template DBSync Salesforce Litify and QuickBooks Desktop follow the below steps:
First Step you need to Select the Integration Template
In the Template Library, look for the integration template specifically designed for Salesforce Litify and QuickBooks Desktop.
Select the template and import it into your workspace.
Enter a name for the integration project:
After importing the template, you'll be presented with a setup form containing four simple steps.
Setup Process
On the "Connection Setup" tab.
In this step we should Connect to our Salesforce application to grant access to our Salesforce Litify data and also establish a connection to QuickBooks Desktop for accounting data access.
Setup Variables
Here, you should define values for variables based on your company's specific use case.
For example, you can select values for Salesforce Litify transaction creation variables, and transaction types (Purchase, Bill, Deposit) for data mapping between Salesforce Litify and QuickBooks Desktop.
Click 'Next' to 'Run' to complete the Integration.
You will be redirected to the 'Task Screen'.
Click 'Configure' to access various workflows pre-built for the integration.
Pre-built Template and Workflows
The template downloaded from the library contains various workflows which can be enabled to run the integration between Salesforce Litify and QuickBooks Desktop.
Make sure you ENABLE the required workflows before you run the integration.
Last updated
