There are several ways to view your inventory value in our system.
Current inventory value
To see the inventory value you have in stock today, simply follow these steps:
Click on Statistics
Click on Inventory (in the top right corner)
The inventory value is shown in the first box on the page
Inventory value is calculated as quantity * cost price. Please note that you must have inventory and a cost price on the products in order for the system to calculate a value.
For purposes such as annual accounts, inventory checks, etc., it can be useful to export a list of your inventory.
To generate a daily report of your inventory value:
Navigate to POS
In the top right corner, select Daily Reports
Then, simply click on the date you need the inventory value for and read the line:
“Total inventory value (cost price excl. VAT)”
This way, you can always find the value of your inventory after a day’s sales or on any specific date you need.
If you need a list of all products currently in stock, you must generate it at the exact time you need the list — for example, after the last day of the year, such as December 31.
To export the list:
Go to Statistics
Under “Exports”, you can export a list of the items currently in stock
First, select the Products export
Then, choose Products in stock from the drop-down menu
After that, you can choose the file type you need — the default is XLSX (Excel), which gives you a file you can open in Microsoft Excel.
It is important that you do this immediately after the daily report has been generated on the given day, or before any transactions are made the next day.
In this file, you will see how many units you have in stock for each item, as well as the value of each product line. This can be found under "stockvalue". The total inventory value is listed under "stockvalue" in the "total" row.
Yes, you can — but for stores created after 2022, not all products may appear in the export.
Therefore, it’s important to export an inventory list on the date you need it, for example December 31st, if you need it for your year-end accounting.
