It is always important to know how many products are in stock. Not only because you need to know how much of a depleted product you need to order, but also to understand the total value of your stock. This article will provide clear instructions to determine what the value of your stock is.
Before you start
The value of your stock can only be determined if the “cost price” and “list price” have been entered (in Extra > Products > Products > open a product by clicking it):
Step-by-step instructions
-
- Go to Extra > Stock > Stock List.
- At the top, click the button Export Stock Count Excel (XLSX).
- Once opened in Excel, you will see a list of your products. Scroll to the right to see their value.
- Click Enable editing at the top.
- Select all the products in column N (“value list price”) or column O (“value cost price”).
This is box title- List price = the price from your wholesalers’ price list (catalogue price).
- Cost price = the value of the List price minus the purchase discount you might have agreed upon; it is the price you actually paid your wholesaler.
- Hold your left mouse button until all products are selected, they all should appear in grey except the first one you selected.
- Once you have selected all your products in column N or O, open the menu option Formulas at the top and click on AutoSum.
- The value of the stock appears underneath the last amount in the column.
More about this
Where can I view the stock mutations?
From Extra > Stock > Stock List you can click 
to go to the Stock List History page for this product. This page will show when there was a change in the stock quantity of this product, which batch it refers to, who made change, what the reason was for the change, and whether the product was incoming or outgoing.
The rolling total should match the number in the “in stock” field in your Stock List.
Related articles
- In focus: Stock management
- How do I setup my stock for products with batch numbers?
- How do I setup my stock for products without batch numbers?
- How do I correct a discrepancy in my stock?
- How do I book in wastage?
- How do I determine the value of my stock? (old workflow)
- How do I perform a stock count at the end of a book year? (new workflow)