QuickBooks Online bi-directional inventory sync

QuickBooks Online bi-directional inventory sync

Overview

Quickbooks Bi-Directional Inventory Sync allows you to keep all your inventory items and their quantities in sync between Quickbooks Online and Zuper  
 
This allows you to use one system as the system of origin for products while consuming them in transactions on both systems. The quantities will be kept in sync on both systems.

Pre-Requisites

  1. You need to install the QuickBooks integration.
  2. Set the 'Sync Product Masters' configuration to 'Yes'.
  3. Enable categories on QBO for the bidirectional sync to function correctly.
  4. Since QBO allows negative quantities when consumption exceeds the available stock, turn on the 'Allow Negative Stock Balance' setting in Zuper (Organization Settings -> Parts and Service Settings).
  5. Set the 'Choose Module to Track Consumption' setting in Zuper (Organization Settings -> Parts and Service Settings) to Invoice. 
  6. The sync will not function properly if this setting is set to 'Job', 'Quotation' or 'None'.

How to use

Set up QuickBooks Online integration with Zuper

Integrating Zuper with QuickBooks 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 the QuickBooks 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.
You must set the following configurations for the bidirectional sync to function correctly:
  1. Choose Product Master – Select the system where you will create new products, specifying whether products will be added initially in Zuper or QBO. This setting determines how the sync operates, so ensure you create parts only in the selected system.
  2. Default Product Location – Enter the default location for products created when synced from QBO. This is necessary because QBO does not support locations for inventory and non-inventory items.
  3. Product Minimum Quantity – Set the minimum quantity for the product at the default location.
  4. Non-Inventory Product Quantity – Set the default quantity for non-inventory items from QBO to be created in Zuper. This is required since QuickBooks does not support quantities for non-inventory items. 
Once you configure these settings, the bidirectional sync between QBO and Zuper will be established.


Creating a part, product, or service on Zuper syncs with QBO if 'Zuper' is selected as the product master. Similarly, if 'QBO' is chosen as the product master, the sync happens in the reverse direction.

When a part or product is consumed in Zuper, its quantity updates in QBO, and vice versa. This happens regardless of which system is set as the product master, ensuring that item quantities stay in sync between both systems.

Limitations

  1. When an inventory item syncs from QBO, it is always synced as a product, and its location is set to a default location, which can be modified as needed.
  2. When a non-inventory item syncs from QBO, it is always synced as a part, with a default quantity assigned to the configured location, which can be adjusted as needed.
  3. Quantity changes are always synced to the default configured location.
  4. If Zuper is selected as the 'Product Master,' the sync of quantities for invoices created in QBO will not work as expected.

    • Related Articles

    • Zuper <> QuickBooks Desktop bi-directional inventory sync

      Overview Quickbooks Desktop Bi-Directional Inventory sync allows you to keep all your inventory items and their quantities in sync between Quickbooks Desktop and Zuper. The records pushed from Zuper will be reflected in the web connector, and if you ...
    • QuickBooks Online Sync History

      Customers who use the Quickbooks integration to send invoice and quote data from Zuper to Quickbooks sometimes face errors. The Sync history feature allows you to troubleshoot these issues. To help troubleshoot Zuper-QuickBooks Online sync issues, ...
    • Set up the Sync Between Zuper and Quickbooks Desktop

      Zuper Customer – QuickBooks Desktop Prerequisites: If you would like to sync all customers between QBD & Zuper, please choose “Yes” under the “Customer Master Sync” field in the App Configuration page. Selecting this as “No” will only sync the ...
    • Common QuickBooks Online Errors

      The most common QuickBooks online errors are listed out here. We came with the errors along with the resolution for each. If you are not finding any errors listed, kindly reach out to support@zuper.co Unsupported Operation Error | Error Code : 500 ...
    • Zuper <> QuickBooks Desktop sync payments

      The sync will happen between QuickBooks Desktop payments and Zuper payments. This allows you to use one system as the system of origin for payments while update synced on both systems. Prerequisites The payment mode used for the payment in QuickBooks ...