Skip to main content

Step-by-step guide to setting up InventoryIQ

Set up InventoryIQ from your start date through warehouses, opening balances, purchase orders and transfers, so your unit-level cost of goods sold is right from day one.

Written by Emily Burrows

About

Applies to: InventoryIQ

Setting up InventoryIQ, Finaloop's inventory management product, means giving Finaloop your start date, warehouses, opening balances, purchase orders (POs) and transfers, so it can calculate your cost of goods sold (COGS) unit by unit from then on.

New to InventoryIQ? This step-by-step guide (along with our team of experts!) will hold your hand throughout the initial onboarding to make sure you have everything you need.

While the initial setup of InventoryIQ requires some manual work, it pays off by streamlining your inventory management and making the process seamless moving forward.

When you first open Inventory, a guided setup walks you through the start date, warehouses, dropshipping, products, opening balances and recipes. The first sections of this guide follow that same order. And if you have any questions at all, feel free to check out Finaloop academy on the Contact us page for video tutorials and guides.


1. Check your start date

Your InventoryIQ start date is the date we begin tracking your inventory in Finaloop. You'll see it on the Your InventoryIQ start date screen of the guided setup. You can start on January 1 so you have a full year using one method, or you can start at the beginning of any month, so there's less initial input to get everything started.

If any of the following items apply, we recommend starting from the beginning of this month instead of from the beginning of the year to make your setup more efficient:

  • A significant number of POs from the start of the year until now (more than 30).

  • Only a few POs from the start of the year, but each PO has hundreds of line items.

  • A significant number of transfers between warehouses from the start of the year until now (more than 30).

  • Only a few transfers between warehouses from the start of the year until now, but each transfer has hundreds of line items.

To change your start date, click Contact us on that screen or reach out to us at [email protected] and we'll adjust this for you!

Important: Any change in the way you determine the quantities, cost or valuations between your opening and closing inventory balance in a tax year requires a statement attached to your tax return explaining the method change. See Form 1125-A, question 9f, for a C corporation, S corporation, or partnership or LLC with 2 or more owners. See Schedule C, Part III, question 34, for sole proprietorships or single-member LLCs.


2. Watch the Getting Started video

We created a quick video on Getting Started with InventoryIQ to introduce you to your new inventory process and system. Be sure to watch it for a full run-through of the setup process.


3. Set up your default warehouses

We'll automatically sync your warehouse data from your connected sales channels, but you'll need to add any additional warehouses. The guided setup walks you through merging any duplicates, adding missing warehouses and setting your defaults. Set a general default warehouse and a default warehouse for each sales channel. For instance, you can set an Amazon FBA warehouse as the default for Amazon sales.

This step ensures we know where your sales are being fulfilled from if we don't otherwise sync the data, for example on FBM orders or when Shopify has missing fulfillment data.

After setup, you can change your warehouses anytime: click Inventory settings at the top right of any inventory page, then Warehouses. To learn more about how to do this, check out InventoryIQ: Everything you need to know.

Edit default warehouses drawer with a general default and a default warehouse for the Amazon sales channel.

4. Set up dropshipping (if relevant)

If you use dropshipping for any of your sales, the guided setup asks about it and walks you through the details. Check out Managing Dropshipping (InventoryIQ) for more. If you don't dropship, you can skip this step.


5. Review and merge products

Review your product list. If you sell the same product (for example, the same SKU) on both Shopify and Amazon, merge them now. The Review your products step of the guided setup uses Merge Recommendations to help you find and merge duplicates, and you can enable Auto-merge so new ones are handled automatically.

After setup, you'll find this in Inventory → Products under Actions → Merge products.

Make sure to merge products before creating any recipes: when products are merged, recipes, opening balances and physical counts are kept only from the primary product. Need help merging products? Find instructions in Merging multiple products.


6. Add additional inventory items (if relevant)

If you have inventory that isn't synced from your connected sales channels (such as raw materials or items sold only on other channels), you'll need to add it manually:

In Inventory → Products, click Actions and select Add product.

These will be created as inactive products since they aren't actively being sold. You can still see these on the Products page: click Filters, select Inactive under Attributes, then click Apply.

Products Filters drawer with the Inactive attribute selected and the Apply button.

7. Add opening balances

For each product, including any newly added ones, enter the opening balance in each warehouse as of the beginning of your InventoryIQ start date. The guided setup shows this as Set up your opening balance.

After setup, click Inventory settings at the top right of any inventory page, then Opening balance. You can get the detailed instructions in InventoryIQ: Everything you need to know.

Opening balance tab with product rows, Import CSV button and Actions, showing quantities and average cost per unit.

To add opening balances for any inventory in process or in transit at the start date of InventoryIQ, you can add historical POs with the relevant status on the start date. You'll find how under Add purchase orders (POs), later in this guide.


8. Add recipes and assemblies

Next, create recipes (or bill of materials) and assemblies for your products. This step is essential for brands that assemble or manufacture their own products from various raw materials, or for brands that sell bundled products as well.

The guided setup ends here with the You're all set! screen. Click Let's go! and the full Inventory menu appears, with your checklist for ongoing tracking on Inventory overview.

Check out Managing recipes & assemblies to learn how to create and manage them in InventoryIQ.


9. Add purchase orders (POs)

Next, in Inventory → Supply chain → Purchase orders, add POs for each item purchased, whether it's raw materials or finished goods. Don't forget to include indirect costs like shipping or taxes!

Note: Make sure to also include any historical POs: POs for inventory ordered before your start date with InventoryIQ but not yet received on your start date, since these items won't otherwise be included in your opening balance.

If you've added a historical PO and you've already paid for part or all of it before the start date, add a historical payment as well. In Inventory → Inventory vendors → Vendor balances, click the vendor, then click Add adjustment → Historical payment, enter the Amount and click Save.

We walk you through the whole process of creating and managing your POs, including historical POs, in Managing your POs in Finaloop. If you have a lot of POs to add, you can also bring them in with Importing purchase orders from a CSV or Excel file.


10. Add stock transfers between warehouses

If you transfer stock between warehouses (or from your warehouse or 3PL to Amazon FBA), add these transfer orders as well:

  1. Go to Inventory → Supply chain → Transfers and click Stock transfer.

  2. Include any additional indirect costs (for example, shipping) under Allocated costs (optional). These increase the real-time landed costs we track for each of the units. Landed cost is the full cost of getting a product to your warehouse, including shipping, duties and fees.

Remember to include any historical transfers too: transfers for inventory that were still in transit on your start date with InventoryIQ.

Transfers tab in Supply chain with the Stock transfer button outlined.

11. Update sales quantities (specific channels only)

Whenever a sale is made through Shopify or any channels connected to Shopify, through Amazon, TikTok Shop or Walmart, or through wholesale invoices sent from Finaloop, we'll sync the quantities sold automatically and use the default warehouse for that sales channel to accurately and automatically record your COGS.

If you're actively selling outside of those channels, such as eBay or Etsy, we'll need you to update the quantities fulfilled and restocked from those channels each month, for each SKU.

Head over to InventoryIQ: Everything you need to know and read the part on adding sales quantities for specific sales channels.


12. Review vendor balances and units with missing costs

You're ready for the final check!

If any balances aren't aligned, we'll notify you through a mission (a task in My missions where we ask you for information we need) letting you know you have negative vendor balances or units with missing costs. This is a validation technique we use to raise any red flags that you may have forgotten to input some information, like adding a PO or updating a shipping status.

You can also check this yourself by following these steps.

Check for negative vendor balances

First check your vendor balances for any negative balances:

  1. Go to Inventory → Inventory vendors → Vendor balances.

  2. Look for a switch at the top that reads inventory vendors have negative balance, and turn it on to see only those vendors.

Vendor balances tab with the negative balance switch turned on and a vendor with a negative rolling balance.

If a vendor shows a negative Rolling balance, it means some information is inaccurate or missing, such as a missing PO. Head over to Fixing Negative Vendor Balances to fix this.


Check for units with missing costs

Next check your Products page for any units with missing costs.

  1. Go to Inventory → Products.

  2. Look for the Units with missing costs alert at the top of the page, and turn on Show products with missing cost units to see only those products.

A product can show a positive number of on-hand units and still have units with missing costs: at some point you fulfilled or transferred units from a warehouse where Finaloop had no stock recorded. This means some data is missing, such as a missing PO, opening balance or recipe. Head over to Why do I have units with missing costs? to identify the issue.

Products page with the Units with missing costs alert and its Show products with missing cost units switch outlined.

If you don't see a negative balance switch or a missing costs alert, your numbers are in good shape.


13. You did it! Keeping InventoryIQ running after setup

You are all set up and good to go!

After your initial setup, to keep things running like a well-oiled machine, just use Finaloop to create your POs, update the shipping status and track stock transfers (the same things you are already doing anyway, I hope).

There is one more ongoing step: if you're selling on sales channels that don't sync automatically, you'll need to update the units fulfilled from each warehouse on a monthly basis, as described under Update sales quantities, earlier in this guide.


Related articles


Need help?

If you have any questions, our team is here to help you get everything set up, so feel free to reach out to Support at [email protected].

Did this answer your question?