Set up QuickBooks Online integration

Set up QuickBooks Online integration


Zuper is integrated with QuickBooks Online to make your accounting and inventory management go hand-in-hand. With this seamless integration.

Insight: This help document is applicable to QuickBooks Online.

With this integration you can:
  1. Sync all your contacts, accounts & inventory from Zuper to QuickBooks.
  2. Upon creating Quote/Invoice in Zuper will be synced with QuickBooks.

Prerequisites

  1. You must have an active account with QuickBooks Online.
  2. You cannot connect multiple QuickBooks organizations to your Zuper account and vice versa.
  3. Ensure that the base currency of both these organizations is the same.
  4. Make sure the Zuper account used for API key generation and for syncing Customers, Products, Estimates and Invoices is not used for any other configuration/Integration/Usage.

Set up QuickBooks Online integration with Zuper

Integrating Zuper with QuickBooks Online is a simple and straightforward process.
  1. Log in to your Zuper account.
  2. Navigate to the App Store on the sidebar.
  3. Choose Accounting & Payments from the side menu.
  4. Select QuickBooks  & Click the Install QuickBooks button.
  5. You will be redirected to QuickBooks Online sign-in page. Enter your credentials to proceed with the integration.
  6. Once you sign in to QuickBooks, if you have multiple organizations, you need to select the organization you want to connect with Inventory.
  7. After selecting an organization, click Connect to complete the integration.

Zuper App Configure

  1. Once you have connected with QuickBooks, you will be redirected to your Zuper account to configure the integration.
  2. Here, you need to configure the settings to sync the Zuper modules with QuickBooks.


  1. To create the Zuper API refer to the article (How do I create an API Key for my Zuper account?).
Note: It is mandatory to enter Zuper API Key for Integration to perform smooth. 

  1. Sync Services & Products (Mandatory) - By selecting the option as "Yes" inventory will be syncing 2 -ways from Zuper - QuickBooks and vice versa. If "No" is selected inventory items won't be synced between Zuper & QuickBooks.
  2. Sync Invoice Status (Mandatory)- Upon selecting the status for the invoice in zuper, we trigger the sync to create a similar invoice in QuickBooks without any duplication. If the status is selected as "All" upon creating the invoice in zuper immediately sync will be triggered and the invoice gets created in QuickBooks.
  3. Identify Customer By (Mandatory) - Upon selecting the below option, at the time of syncing the customer information with QuickBooks, it checks and updates/create the customer. 
    1. First Name
    2. Last Name
    3. First Name & Last Name (Recommended)
  4. Default Tax Agency (In QuickBooks) - Copy Past/Past the "Default tax Agency" from QuickBooks, if available.
  5. Sync Failed Email - Upon sync failed error message will be emailed to the given ID's.
  6. Default Payment UID - To get the "Payment UID". Click "CRTL+Shift+J" and copy/paste the below code,

    var scope = angular.element(angular.element($(".hbox"))[0]).scope();
    _.each(scope.vm.payment_modes, function(p){
    console.log("-----------------------");
    console.log("Payment Provider Name: ", p.payment_mode_name);
    console.log("Payment Provider UID:", p.payment_mode_uid)
    });


  1. Estimate/Invoice ID - Upon Selecting the "Zuper ID / QuickBooks ID", this will be updated in QuickBooks under the field name "Estimate / Invoice No".
  2. Identify Customers in 'Zuper - QuickBooks'
    - Upon selecting the below option, at the time of syncing the invoice/estimate with QuickBooks, it checks and create the invoice for the right customer.

    Zuper
    QuickBooks
    Customer Email
    Customer Email
    Customer Name
    Customer Name
    Billing Email
    Customer Email
    Billing Name
    Customer Display Name
  1. Sync Customers (Mandatory)- Upon selecting the option as "Yes" whenever a new customer is created in zuper will be synced with the QuickBooks customer module automatically. If the option is selected as "No" sync between Zuper & QuickBooks for customer sync will not execute.
  2. Sync Estimate (Mandatory)- Upon selecting the option as "Yes" whenever a new estimate is created in zuper will be synced with the QuickBooks estimate module automatically. If the option is selected as "No" sync between Zuper & QuickBooks for estimate sync will not execute.

QuickBooks Integration Account Configure

  1. Sign In to the QuickBooks Online account and click the below link based on the account signed-the in. Then click the "Switch Now" button.
    1. QuickBooks Live Account - https://app.qbo.intuit.com/app/categorymigration 
    2. QuickBooks Staging Account - https://sandbox.qbo.intuit.com/app/categorymigration 
            
  1.  Go to Accounting -> Chart of Accounts and make the following changes to the below 3 accounts:

       Name: Inventory Asset
      Account Type: Other Current Assets
      Detail Type: Inventory
       Name: Cost of Goods Sold
      Account Type: Cost of Goods Sold
      Detail Type: Supplies & Materials - COGS
       Name: Sales of Product Income
      Account Type: Income
      Detail Type: Sales of Product Income
  1. Go to Taxes and choose whether your tax is Annual, Monthly or Quarterly.

‚Äč



    • Related Articles

    • How to integrate HubSpot ServiceHub and HubSpot Sales with Zuper?

      With Zuper’s first-class integration with HubSpot ServiceHub, and HubSpot Sales Work seamlessly across your sales, services, and support teams to deliver an exceptional customer experience. Using Zuper integration with HubSpot, you can easily create ...
    • How to use RingCentral Integration with Zuper?

      With the RingCentral integration, the end customers sitting in the back office can connect their cloud telephone to answer incoming and outgoing calls and receive and send SMS directly from the Zuper web app.  Note: The RingCentral widget does not ...
    • How to set Default Email Templates?

      Navigation:  Settings -->  Organization Settings --> Job Settings / Quotation and Invoice Settings --> Default Job Card Email Template / Default Quote Email Template / Default Invoice Email Template You can now easily set the default email templates ...
    • How to use HubSpot Sales Integration with Zuper?

      The HubSpot Sales – Zuper integration helps create a job using Zuper against the various deals present in HubSpot.  1. Visit: app.hubspot.com and log in with your credentials. Then, under the "Sales" tab, select the "Deals" option. 2. Select the ...
    • How to set up regional and city taxes?

      Users from the US region can now easily set the tax percentage for the states/provinces. A.     Pre-Setup B.      Quotation Pre-Setup: 1.        Select the “Settings” module from the left panel and tap on the “Quotes & Invoices” under “Configuration ...