What is the best way to integrate an inventory control solution and QuickBooks Online?

Turn off inventory tracking in QBO and sync sales to QuickBooks

Why having two solutions is a bad idea

Since another tool does inventory control, there is no need to have QuickBooks perform the same calculations. To get the same numbers in QuickBooks, you must perform these steps:

  1. Import a spreadsheet of products into QuickBooks.
  2. Ensure the QuickBooks item name and website SKU match.
  3. For each item, add an initial inventory value and initial stock. For example, you have $10 widgets you bought at $10 each. Your inventory is 10 with a value of $100.
  4. Sync POs from the inventory solution to QuickBooks.
  5. Sell product in QuickBooks by sales receipt or invoice.

We recommend disabling inventory in QuickBooks and syncing a summary sale.

Turn off inventory tracking

To turn off inventory tracking, follow these steps:

  1. Log into QuickBooks.
  2. Click the gear box on the top right.
  3. Click account and settings.
  4. Click sales.
  5. Under products and services, disable track inventory quantity on hand.

Journal Entry

Talk to your inventory control solution about obtaining the value of inventory and COGS for a period. Create a journal entry in QuickBooks:

  1. In QuickBooks, click new > journal entry.
  2. Create an entry that credits your inventory asset and debits your COGS:

Sync Summary Sale

Connex can merge multiple orders into a single sale. This ensures QuickBooks has a few hundred orders per year and a handful of customers, which will equal the selling channel. Connex can group them by selling channel:

  1. Log into Connex.
  2. Click settings.
  3. Under orders to QuickBooks, select summary sales receipt.
  4. Scroll down to summary sale.
  5. Select selling channel as the group. If you use Linnworks, enter selling channel and currency code.