About
Applies to: Finaloop Accounting, InventoryIQ
In InventoryIQ, you set up where your stock sits and how much you started with in Inventory settings: your warehouses and default warehouses, and an opening balance for each product in each warehouse.
These settings decide which warehouse each sale comes out of and what your first units cost, so getting them right keeps your cost of goods sold (COGS) and stock value accurate from your start date on. For the full setup in order, see Step-by-step guide to setting up InventoryIQ.
Before you begin
Know your InventoryIQ start date: the first day InventoryIQ tracks your units. Your opening balances are your stock at the start of that day.
Have, for each product (SKU) and warehouse, the quantity on hand and the average cost per unit on your start date.
Subscribe first: the Opening balance tab opens once your account is on a paid plan.
1. Open your inventory settings
Go to Inventory.
At the top right of any inventory page, click Inventory settings.
You'll see three tabs: General, Warehouses and Opening balance.
2. Check your start date and COGS method
The General tab shows your COGS tracking method for each Period, with a Status of Active or Closed books. The first InventoryIQ period starts on your InventoryIQ start date.
We usually recommend starting on January 1, so the whole year uses one method. Starting at the beginning of the current month means less to enter if you have more than 30 purchase orders or transfers since January 1, or a few with hundreds of lines each.
To change your start date or method, reach out to us at [email protected] and we'll make the change for you. To compare methods, see How to choose your COGS tracking method in Finaloop.
Under Inventory sync data, the same tab also controls which sales channels create COGS per SKU (Sales channels – report per SKU) and whether InventoryIQ updates your Shopify on-hand quantities every day at 03:00 AM EST (Push quantities to Shopify). Click Save in the Save changes? bar after any change.
3. Add a warehouse
Warehouses from your connected sales channels and 3PLs are added for you, with a View button. Add any others yourself, such as a 3PL that isn't connected or a storage unit.
In Inventory settings, click Warehouses.
Click Add warehouse.
① Merge/Split, ② Add warehouse, ③ Edit defaults.
Enter a unique Warehouse name and the address details.
Optional: turn on Dropshipping warehouse if your supplier ships orders straight to customers from this location.
Click Save.
The warehouse appears in your list with an Edit button.
4. Set default warehouses
A default warehouse tells InventoryIQ where a sale was fulfilled from when the sales channel doesn't say, for example on Amazon merchant-fulfilled (FBM) orders or Shopify orders with missing fulfillment data. Orders from a channel with no default of its own come from the general default.
In Inventory settings → Warehouses, click Edit defaults.
In Edit default warehouses, choose your general default warehouse on the first row.
Click Add, then pick a Sales channel and its Default warehouse.
Optional: set a Rule start date, or turn on Rule end date if the default only applies for a period.
Click Save.
You'll see Defaults updated successfully!, and the general default carries a Default tag in your list. A dropshipping warehouse can't be a default.
5. Merge or split duplicate warehouses
The same location can appear twice when its data reaches us from more than one source, for example from Shopify and from your 3PL. Merging them keeps each location once, so your stock isn't split across two names.
In Inventory settings → Warehouses, click Merge/Split.
Select the warehouses that are the same location.
Click Make primary on the one to keep. The others become its secondary warehouses.
Click Save.
You'll see Changes saved successfully, and the merged warehouse shows a Primary tag. To split a merged warehouse, open Merge/Split, select it, remove the warehouse you want to separate, and click Save.
Note: A dropshipping warehouse can't be merged with a regular one, and a warehouse with activity in a closed (locked) period can't become a secondary warehouse.
6. Mark a warehouse as inactive
Mark a warehouse inactive when you no longer record sales, fulfillment or stock there. Inactive warehouses leave your filters and menus and move to the Inactive group at the bottom of your list.
Complete or reassign any orders and transfers assigned to the warehouse.
In Inventory settings → Warehouses, click Edit on the warehouse.
Turn on Inactive and click Save.
Your default warehouse can't be inactive, so choose a new default first. If the switch is unavailable and shows This warehouse has activities, reach out and we'll help.
7. Enter your opening balances
In Inventory settings, click Opening balance. Products from your connected channels and warehouses are already listed.
For each product, choose the Warehouse and enter the Quantity and Average cost/unit.
Optional: to record the same product in another warehouse, click the duplicate icon at the end of its row.
① Import CSV, ② Actions, ③ the duplicate icon.
Click Save in the Save changes? bar.
The total at the top, Opening balance as of your start date, updates to your new value.
The Actions menu has the faster options:
Import CSV: download the template (Template with SKUs includes your products), fill in the cost, quantity and warehouse for each SKU, upload it, then review and save.
Bulk edit: select products, then set one Warehouse, Quantity or Average cost/unit for all of them.
Sync from warehouse: pull quantities from a connected 3PL or WMS, when it has data for your start date.
Create product and Export: add a product that isn't synced, or download your balances as a CSV.
Stock that was ordered but still in process or in transit on your start date isn't part of your opening balance. Add it as a historical purchase order instead. See Managing your POs in Finaloop.
Related articles
Need help?
If you're not sure which start date suits you, or two warehouses won't merge, reach out to our Support team through chat or at [email protected], and include the warehouse names or the start date you have in mind.
