Skip to main content

InventoryIQ: Everything you need to know

Learn how InventoryIQ tracks your units, landed costs and cost of goods sold by SKU and warehouse, so your books reflect the stock you really have.

Written by Emily Burrows

About

Applies to: InventoryIQ

InventoryIQ, Finaloop's inventory management product, tracks every unit you buy and sell, so your books reflect cost of goods sold (COGS), stock balances and stock values at the SKU level and the warehouse level.

You're reading this either because you've decided that InventoryIQ is the best inventory solution for you (good choice!), or because you want to know more about it. If you're still not sure which inventory method is best for your business, head over to How to choose your COGS tracking method in Finaloop.

You can also watch this short video to introduce you to the benefits and key features of InventoryIQ:

Because there's quite a bit to go through, we've split the article into bite-sized chunks. Take it easy! It's an article you might want to come back to for a refresher. If you're setting up for the first time, follow along with Step-by-step guide to setting up InventoryIQ.


1. Key inventory terms

Before we dive into what's involved in using InventoryIQ, here's a refresher of some key inventory terms.

Inventory statuses: In process, In transit and Received

Inventory items can have one of three statuses, and because purchase orders (POs) can arrive in multiple shipments, each shipment has its own status.

  • In process: Inventory is marked as In process when you add a Production started date to your PO. That's the date the vendor confirmed your order and started to process it. The Balance Sheet lists these items as Inventory in-process.

  • In transit: The vendor has shipped the inventory but you haven't yet received it. The Balance Sheet lists these items as Inventory in-transit.

  • Received: When you mark a shipment as received, the Balance Sheet lists the items as Inventory.

Accurate tracking of the inventory status is a key component of how we track which units were received first and how we calculate your COGS on a first-in, first-out (FIFO) basis.

By default, a PO reaches your books on its Production started date. If you'd rather recognize POs when they ship, choose Shipment date under Recognition date in Inventory → Supply chain → Preferences.


Landed cost: the full cost of each unit

Your landed cost is the full cost of getting a product to your warehouse, including shipping, duties and fees. When you create a PO, you'll add the direct cost of each inventory item. Then you add indirect costs and discounts, as relevant, to get a more accurate picture of the actual costs of your inventory at the unit level.

The landed cost tells you the exact cost of each unit of a given SKU. One of the key benefits of using InventoryIQ is that, despite the constantly fluctuating nature of these costs, we'll automatically track the landed cost for each item.

For each inventory item (SKU), the landed cost is the direct cost of inventory items purchased + indirect costs for those items / number of inventory items.

Here's an example.

  • You purchase 100 units of Product A: $2,000

  • Shipping and other indirect costs for those inventory items: $500

The landed cost per unit is (2,000 + 500) / 100 = $25.

When creating a PO, indirect costs are allocated automatically between the products based on their direct cost, unless you choose to allocate them manually.

  • By default, Auto allocation is on, and Finaloop does the hard work for you. We apportion the indirect costs and generate landed costs per unit automatically.

  • With Auto allocation off, you enter the indirect cost for each product yourself, so you can split it another way, such as by weight or volume.

PO Indirect costs section with a Shipping line and the Auto allocation switch outlined.

Indirect costs include any additional costs incurred to get the inventory to your warehouse that aren't related to the direct costs of the items themselves. Here's the list of indirect cost types:

  • Other inventory costs / general

  • Shipping

  • Vendor fees

  • Duties and tax

  • Custom fees and services

  • Insurance

  • Production costs

  • Pallet costs

  • Shipping surcharge

You can also add a Discount line to a PO, which lowers the landed cost of its units.

To learn more specifics about creating and managing POs in Finaloop, check out Managing your POs in Finaloop, and for more on landed costs, head over to How to calculate your landed cost per unit.


FIFO: first in, first out

FIFO stands for first in, first out. InventoryIQ uses the FIFO method to calculate the value of inventory items on any given date.

When you sell products, Finaloop uses the cost of the items (based on the PO) that have been in that warehouse the longest. When there's no more stock from that PO, Finaloop takes the costs from the next PO received, and so on.

Example:

  • April 1: PO #0001. You receive 10 items to your warehouse. Unit cost = $10.

  • May 12: PO #0026. You receive 20 items to your warehouse. Unit cost = $10.50.

  • May 15: You sell 15 items.

InventoryIQ records this as a stock reduction of 15 items: 10 priced at $10 and 5 priced at $10.50.

As you purchase items, the stock numbers and values in the Balance Sheet increase, and when you sell, they decrease and instead become COGS.


Vendor rolling balance: what you owe before a bill arrives

The Vendor balances tab shows the total amount owed to your inventory vendors. It shows the rolling balance and any unpaid bills.

  • The rolling balance is the amount you owe a vendor for inventory costs when you haven't received an official bill from them. It's calculated from your POs, shipment costs, stock transfer costs and assembly costs, minus inventory bills issued by the vendor and payments (excluding payments for bills).

  • Whether you track the amount owed to your vendors through a rolling balance or through actual bills, the total amount owed to the vendor remains the same until you actually pay the vendor.

Note: If you record an extra payment or bill that isn't related to a PO, you could create a negative rolling balance, which means you're either missing a PO, the numbers on your PO or bill aren't accurate, or you overpaid your vendor. It may also be related to the incorrect categorization of a transaction or bill. To fix one, see Fixing Negative Vendor Balances.


2. Set up and manage warehouses

The first step is to set up warehouses and choose a default warehouse for each sales channel, so we can track stock per warehouse. To add, merge or deactivate warehouses and set channel defaults, see Setting up warehouses and starting inventory in InventoryIQ.


3. Create opening balances for each SKU

Finaloop needs the opening inventory balance for each SKU in each warehouse, including the number of units and the average cost per unit, as of your InventoryIQ start date. For the steps, see Setting up warehouses and starting inventory in InventoryIQ.


4. Create purchase orders (POs)

Now that you've set up warehouses and have opening balances for each SKU, the next piece is to create POs for every inventory purchase in Inventory → Supply chain → Purchase orders.

POs are the cornerstone of how Finaloop calculates COGS and inventory. We use POs to determine the landed cost of each item and the order in which stock comes into each warehouse. When you fulfill a sales order for a customer, we automatically take the landed cost for each unit sold on a FIFO basis to calculate the exact COGS of each order.

For FIFO to work correctly, Finaloop needs historical purchases too, for example POs you created in a previous year but didn't receive until the current year.

To see how to add historical POs, head over to Managing your POs in Finaloop.


5. Manage inventory vendors

In InventoryIQ, you manage the balances you owe to your inventory vendors on the Inventory vendors page: each vendor's rolling balance, its details and historical payments. See Tracking inventory vendor balances in InventoryIQ.


6. Update shipment statuses as orders progress

As orders progress, it's important to update POs when you receive additional information regarding production and shipping.

  1. When you enter the Production started date on the PO, the status moves to In process and we add the inventory to the Balance Sheet.

  2. When you click Add shipment in the PO and enter the warehouse and the shipping date, the PO shipment status moves to In transit.

  3. When you receive the goods, open the shipment in Inventory → Supply chain → Shipments and click Mark as received. This moves the shipment status to Received.

PO status timeline with Placed, Production started, Shipped and Received, and the Production started date outlined.

To see the workflow steps related to status changes, head over to Managing your POs in Finaloop and Managing your Shipments & Receipts.


7. Add stock transfers between warehouses

If you transfer stock between warehouses (or from your warehouse or 3PL to Amazon FBA), you'll need to add these transfers 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 in the receiving warehouse.

Note: Make sure to also include any historical transfers: transfers for inventory that were still in transit on your start date with InventoryIQ.

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

① The Transfers tab, ② the Stock transfer button.


8. Track and manage your inventory

Using InventoryIQ you'll find a wealth of information about each SKU on the Products page, either because we synced it from Shopify or Amazon, or because you added each SKU yourself.

To track stock at the unit level and review inventory data by warehouse, see Reading the InventoryIQ product list and product page.


Add sales quantities for specific sales channels

Finaloop automatically adds COGS for Shopify, Amazon, TikTok Shop and Walmart when the channel's switch is on under Sales channels – report per SKU in Inventory settings, and for any invoices sent through Finaloop. If you use other sales channels, you can add COGS manually, either in a bulk upload or individually in each SKU.

Use Bulk unit edit to easily report dead inventory, product giveaways or product donations across all relevant SKUs too.

Here's how it works. To add COGS to sales channels in bulk:

  1. In Inventory → Products, click Actions → Bulk unit edit.

  2. Select the tab you need: COGS, Dead inventory, Product giveaways or Product donations.

  3. Select the Sales channel from the dropdown.

  4. Select the Update method: Replace replaces the existing records for the selected product in the chosen month, and Add on top adds the value to the total of existing records in the system.

  5. Select the Warehouse that fulfilled the sales from this sales channel from the dropdown.

  6. Update the Units fulfilled and Units restocked for each month, and click Save. We'll report the adjustments in your books on the last day of the month.

Bulk unit edit page with the tabs, Sales channel, Update method and Actions menu outlined.

① The tabs, ② Sales channel, ③ Update method, ④ Actions.

You can also click Actions → Import CSV file and follow the instructions to add the quantities for all of your SKUs in one quick upload, and you can duplicate a row from the right side of the row to add multiple months for each product at once.

To add COGS to sales channels manually for each unit:

  1. In Inventory → Products, click the product, then the COGS tab.

  2. Select a warehouse from the dropdown. You need to pick a single warehouse before you can edit the numbers.

  3. Click Add to COGS and select the type: Sales channel, Dead inventory, Product giveaways, Product donations or Inventory lost. A new box opens for that type.

  4. For a sales channel, select a specific channel or use Multi-channel from the dropdown.

  5. Click the edit button on the box. A side pane opens.

  6. Expand the relevant month and update the quantity of units fulfilled and restocked on the relevant day of each month. Alternatively, you can add the totals for the month on the last day of the month.

  7. Click Save. Finaloop then calculates COGS using FIFO for the specific warehouse you selected.

COGS tab on a product with the warehouse dropdown and Add to COGS menu outlined.

① The warehouse dropdown, ② Add to COGS.

For Shopify and Amazon, if you change quantities that we pull automatically, you can see the original quantity in the tooltip.

It takes a moment or two for the screens to update and show the changes. Go to the Inventory → COGS page to see the COGS per channel, dead inventory, product giveaways and product donations. You can also see the updated unit and cost data on the Products page.


Fix units with missing costs

If you see an alert that reads Units with missing costs at the top of the Products page, some units were depleted when Finaloop had no stock recorded for them. Typically, this is caused by no opening balance for that SKU or an incorrect balance, missing POs or transfers, or an inaccurate quantity or date on a PO or transfer (an inaccurate date can create a time gap which may also result in units with missing costs).

Turn on Show products with missing cost units to see only those products. To identify and fix the missing data, check out Why do I have units with missing costs? and Why do I have units with missing costs in InventoryIQ?.


9. Additional tips to manage InventoryIQ

Move an indirect cost straight to COGS (incidentals)

There are some indirect costs, like packaging paper to ship orders to customers, that aren't strictly indirect inventory costs. If you have indirect costs that you don't think should be reflected on a per unit basis, you can treat them as incidentals. This removes the costs from inventory and moves them to COGS in your P&L. They won't be included in calculating your landed costs per unit.

To reclassify these expenses:

  1. Select the specific transaction you want to reclassify and click Actions.

  2. Select Change accounting treatment.

  3. Select COGS from the dropdown.

  4. Click Save.

Change accounting treatment window with COGS selected and the Save button.

Finished products and Supplies & materials can't be treated as COGS under US tax rules. For those categories, you can change the category in the Transactions page to Other incidental supplies instead. Finaloop also shows a tax warning if you change categories such as shipping, so read it before you save.


Merge products

Merging products allows you to group several products together under one primary product.

This is a great feature if you have identical products from multiple sources, such as Amazon and Shopify, and you want to apply cost updates to both products at once.

To merge products:

  1. In Inventory → Products, click Actions → Merge products.

  2. On the Merge Products page, select two or more products.

  3. Click Make primary on the product you want to keep as the primary product.

  4. Add or remove products as needed, and when you're ready, click Save.

Important: Merging combines COGS and purchase history, but opening balances, recipes and physical counts are kept only from the primary product. Data from the other products is erased when you click Save in the confirmation.

Merge Products page with the Make primary buttons and the Save button outlined.

① Make primary, ② Save.

The products now show on the Products page as one product, and the Merged attribute icon shows on its row.

To find merged products later, click Filters, select Merged under Attributes, then click Apply.

For more information on how to merge products and how they impact your financials, check out Merging multiple products.


Export your purchases

To export a list of your inventory-related bills and transactions from your banks and credit cards to a CSV file, go to Inventory → Inventory vendors → Bills & payments. Select the rows you want, click Actions and select Export.


Manage recipes and assemblies

You can create and manage recipes, also known as a bill of materials, or assemblies using InventoryIQ.

Recipes are often used for brands that manufacture or produce their products from various components or raw materials, or for bundles of multiple products.

Using recipes, you can create on-demand assemblies or you can create manual assemblies on an as-needed basis. To learn more about creating and managing recipes and assemblies in InventoryIQ, see Managing recipes & assemblies.


Manage dropshipping transactions

To learn more about how to manage your dropshipping transactions, check out Managing Dropshipping (InventoryIQ).


Adjust your inventory to match physical counts

Sometimes, when you conduct a physical count of your inventory in your warehouse, you may find some discrepancies between the units you have on-hand and the units you have recorded in Finaloop. No worries: the Physical counts page helps you reconcile your recorded inventory based on your physical stock count.

To learn more about how to record a physical count adjustment in InventoryIQ, check out InventoryIQ: Adding adjustments based on a physical count.


10. Pricing for InventoryIQ

InventoryIQ is available as an add-on to your Finaloop plan, and its price depends on the gross revenue of your business. You can try it free for 14 days.

To learn more about our pricing plans, check out Finaloop plans and pricing.


Related articles


Need help?

If you have any questions, our team is here to help. Reach out to us at [email protected].

Did this answer your question?