InventoryIQ can automatically pull inbound shipment data from Amazon and supported 3PL and WMS integrations, including - Shipments, their corresponding Receipts, and Transfers.

This reduces the need to manually create Supply Chain records while keeping inventory movements aligned with the data from your connected integrations.

We’ll walk you through the entire process and what you need to do along the way.

Inbound shipment data sync is available for Amazon and supported 3PL and WMS integrations.

To enable it: Go to Inventory → Supply Chain page → Preferences tab.

When enabling the sync, select the date you want syncing to begin.

Please note: For warehouses without a 3PL/WMS integration, or where auto-sync isn’t enabled, you’ll still need to enter shipments and transfers manually.

When auto-sync is enabled for a warehouse, inbound Shipments and their corresponding Receipts automatically appear in InventoryIQ based on the data from your connected integration.

Unlike manually-added Shipments, auto-synced Shipments will initially appear without being linked to a Purchase Order. These Shipments will appear as Not reconciled until all of the inventory in the Shipment has been linked to the appropriate PO Shipment Group(s).

Important: Received units from an auto-synced Shipment will be reflected as on-hand inventory even if the Shipment hasn’t been linked to a PO. However, until it’s linked, we won’t have the PO costs needed to calculate the units’ complete landed cost.

You can identify where a Shipment or Receipt came from by viewing its Source. You can also filter the Shipments and Receipts pages by Source.

Linking a Shipment connects the inventory synced from your integration to the Purchase Order(s) it relates to. This allows InventoryIQ to assign the appropriate inventory costs to those units.

You can link a synced Shipment from either the Shipment or the Purchase Order.

From the Shipment:

From the PO:

A single auto-synced Shipment can be linked to multiple PO Shipment Groups across various Purchase Orders.

When linking a shipment to an existing PO Shipment Group, InventoryIQ will show whether the selected PO Shipment Group(s) fully match the synced Shipment:

You can link additional PO Shipment Groups as needed. A single synced Shipment can be linked to multiple PO Shipment Groups across various Purchase Orders, and the Shipment will remain Not reconciled until all of its inventory has been reconciled.

A single inbound Shipment may be received by your warehouse in multiple batches.

Your connected integration tells us what was expected in the inbound Shipment and what has been received over time. Each Shipment in InventoryIQ is associated with one Receipt so InventoryIQ creates a separate Shipment for each Receipt.

For example, if Shipment A is received across three Receipts (or batches), you may see:

Each Shipment is automatically linked to its corresponding Receipt and needs to be linked to the appropriate PO Shipment Group(s).

Once the integration indicates that the inbound Shipment is closed, InventoryIQ compares the final quantities received against the expected quantities. Any remaining difference will then be reflected in the final Shipment and Receipt.

You can manually adjust the received quantity on a synced Receipt if needed. If the quantity differs from what was shipped, InventoryIQ will flag the difference for review. If fewer units were received, the missing units are recorded as Inventory Lost. If more units were received, the total inventory cost is redistributed across the units received.

Supply Chain Sync can also automatically identify inventory moving between your own warehouses.

When the Shipped from location provided by your warehouse matches one of your warehouses in InventoryIQ, InventoryIQ automatically creates a Transfer rather than a Shipment and Receipt.

If the Shipped from location isn't recognized as one of your warehouses, the movement will initially appear as a Shipment. You can convert it to a Transfer by clicking + This is a transfer within the Shipment. This will automatically convert the Shipment and its corresponding Receipt into a Transfer, so no additional action is needed for the Receipt.

If a Shipped from location was provided by your integration, you can also create a rule to recognize that location as one of your warehouses going forward.

You can add applicable costs to an auto-synced Shipment and Transfer so they're included in the landed cost of the inventory.

Shipment and Transfer costs are expenses related to transporting inventory into your warehouses, such as inbound freight, duties, customs, insurance, and vendor fees.

Note - For Amazon Transfers, Finaloop creates a default rule that records Amazon shipping and freight-in costs directly as COGS on your P&L rather than adding these costs to the inventory through the Transfer. This avoids the need to manually allocate these costs across individual Amazon Transfers.

If you prefer to add these costs to your inventory's landed cost through the Transfer instead, you can remove the default rule under:

Inventory → Inventory Vendors → Bills & Payments → Purchase Settings

Once the rule is removed, applicable Transfer costs will need to be added to the relevant Amazon Transfers.

You can turn Supply Chain Sync off or change the sync start date from Inventory → Supply Chain → Preferences, as long as the relevant accounting period isn't locked.

If you turn syncing off or move the start date forward: