Steps
- Go to Finance โ Opening balances โ + Opening stock only: name it, set the cut-off, choose the equity account credited (usually *Opening balances (equity)*, or the ownerโs capital) and tick Create items that are not in Navigate yet if you have no item list.
- Download the template and fill one row per item and warehouse: SKU, description, warehouse code, quantity, unit cost (batch number, expiry, serials when the item needs them; category, unit and selling price for a new item).
- Upload it: each row is checked - unknown warehouses, missing costs, serial counts, batches.
- Post: the stock goes into the warehouses at that cost (each itemโs cost starts there) and one opening journal: Dr inventory (by item group and warehouse) / Cr the equity account.
Good to know
- Posted once; a reversal needs a second person. For a full migration (trial balance, customers, suppliers, bank, assets) use + New migration instead.