SkuVault to QuickBooks Desktop

Introduction

DBSync for SkuVault & QuickBooks Desktop Integration is an easy to use application. It integrates SkuVault Customer, Products, Sales, Supplier, and Purchase Orders with QuickBooks Desktop Customer, Item inventory, Invoice, Sales Receipt, Estimate, Vendor, Purchase Order, and Item Receipt. DBSync provides integration with pre-built field-to-field mapping along with flexibility for more complex and dynamic mapping capability. DBSync's automatic Desktop update enables its customers to enjoy all the product updates and features that come with every new release.

Data Flow

Data flow integration between SkuVault & QuickBooks Desktop is shown in the table below.

SkuVault	QuickBooks Desktop
Customer	Customer
Product	Item Inventory
Sales	Invoice, Sales Receipt & Estimate
Supplier	Vendor
Purchase Order	Purchase Order, Item Receipt

DBSync Profile and Application Setup

• Go to www.mydbsync.com & register for Free Trial. Ensure that Source and Target Adapters are SkuVault 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 the Apps icon from the left navigation toolbar to add desired applications
• Click on SkuVault Connector and choose 'Login to SkuVault'

• You need to enter Credentials(Username, Password, Base Url), and click ‘Save Connection’ and then you can ‘Test Connection’, 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 Create an Integration

To utilize the pre-built template DBSync SkuVault and QuickBooks Desktop follow the below steps:

First Step you need to Select the Integration Template

1. In the Template Library, look for the integration template specifically designed for SkuVault and QuickBooks Desktop.

2. Select the template and import it into your workspace.

3. Enter a name for the integration project:

4. After importing the template, you'll be presented with a setup form containing three simple steps.

Setup Process

1. On the "Connection Setup" tab.

In this step we should Connect to our application to grant access to our SkuVault data and also establish a connection to QuickBooks Desktop for accounting data access.

1. Setup Variables

2. 1. Here, you should define values for variables based on your company's specific use case.

   2. For example, you can select Yes/No for SkuVault Sales or Purchase Order creation variables, and transaction types (Invoice, SalesReceipt, Estimate) for data mapping between SkuVault and QuickBooks Desktop.

1. Click 'Next' to 'Run' to complete the Integration.

You will be redirected to the 'Task Screen'.

1. Click 'Configure' to access various workflows pre-built for the integration.

2. Or Run the integration from ‘Run’.

Pre-built Template and Workflows

The template downloaded from the library contains various workflows which can be enabled to run the integration between SkuVault and QuickBooks Desktop.

Make sure you ENABLE the required workflows before you run the integration.

Enable the Initial Setup and Run the integration to enable QuickBooks Accounts set up as displayed in the image. Also note, the following accounts are created in QuickBooks Desktop post Initial Setup Integration:

1. Income Account

2. Expense Account

3. Assets Account

Ensure you TURN OFF the check box to 'Enable Flow' for the Initial Set up (After first Run) before you run the workflow to integrate SkuVault Purchase Orders or Sales to QuickBooks Desktop using the other two workflows. The first successful run is considered for the integration.

Make sure you ENABLE the required workflows before you run the integration.

Enable the Initial Setup if you want to Create All Products From Skuvault into QuickBooks Desktop. Historical products refer to products that were recorded in your Skuvault account but need to be transferred or migrated to QuickBooks Desktop for historical reference and continuity of data. Historical products are those that were part of previous records, transactions, or inventory but are not currently active or in use.