The Inventory Items tab serves as your central hub for creating, monitoring, and managing your inventory list in Manager.io. Through this module, you can efficiently track your inventory levels, costs, and quantities, ensuring optimal stock control.
To create a new inventory item:
See Inventory Item — Edit for detailed instructions.
If you have existing inventory quantities when creating new items, you can enter their starting balances under Settings → Starting Balances. For further reference, see Starting Balances — Inventory Items.
By default, inventory items created in the Inventory Items tab use preset accounts:
The main Inventory Items screen displays various key columns. You may customize visible columns using the Edit columns option at the bottom of the screen. Refer to Edit columns for guidance.
| Column Name | Description |
|---|---|
| Item code | The assigned code of the inventory item. |
| Item name | The name you entered for the item. |
| Valuation method | Shows the valuation method used for this inventory item, relevant when recalculating inventory costs. |
| Control account | The control account the item is assigned to. Default is Inventory on hand. Custom control accounts are optional. |
| Division | Indicates the division associated with an inventory item. Relevant if divisional accounting is used. |
| Description | Displays the defined description of the inventory item. |
| Qty owned | The quantity acquired but not yet sold or written off. Clickable to view contributing transactions. Delivery Notes and Goods Receipts do not affect this quantity since they aren't general ledger transactions. See Inventory Items — Qty owned. |
| Qty to deliver | Tracks sold items awaiting delivery (if Delivery Notes are enabled). Sales Invoices increase this, whereas Delivery Notes and Credit Notes decrease it. |
| Qty to receive | If Goods Receipts are enabled, tracks purchased items waiting to be received. Purchase Invoices increase, while Delivery Notes and Debit Notes decrease this figure. |
| Qty on hand | Reflects actual physical quantity on hand if managing shipments and receipts via Delivery Notes and Goods Receipts. Goods Receipts increase whereas Delivery Notes decrease it. Sales/Purchase Invoices, Debit Notes, and Credit Notes have no effect here unless acting as receipts/deliveries directly. |
| Qty reserved | Related to Sales Orders (if enabled). Sales Orders increase this number, and Delivery Notes linked to Sales Orders decrease it. |
| Qty available | Physical quantity immediately available to sell, calculated as (Qty on hand – Qty to deliver – Qty reserved). |
| Qty on order | Tracks items ordered via Purchase Orders but not yet received/invoiced—a future committed stock count. |
| Qty to be available | Predictive inventory figure: (Qty available + Qty to receive [if positive] + Qty on order). |
| Qty desired | Specified reorder point for inventory, edited directly on inventory item details. |
| Qty to order | Indicates quantities needing ordering if (Qty desired) exceeds (Qty to be available). Ordering from suppliers raises the Qty to be available, reducing this quantity ideally to zero. |
| Average cost | Calculates average cost per inventory item as (Total cost ÷ Qty owned). |
| Total cost | Aggregate total cost of all owned inventory items. Clicking shows the transactions contributing to this total. |
To recalculate your inventory unit costs, use the Recalculate button at the top of your inventory list. Refer to Inventory Cost Correction for detailed guidance.
Manager.io includes an Advanced Queries feature enabling you to organize your inventory efficiently according to your business needs. This allows filtering, sorting, and grouping your inventory items directly within the Inventory Items tab.
For instance, if you want a simplified view showing only Qty on hand, an advanced query might be structured as follows:
This is flexible – you may substitute Qty on hand with:
Utilizing these features and columns effectively will empower you to tightly manage inventory quantities, streamline reordering, enhance customer service by ensuring product availability, and maintain accurate financial records within Manager.io.