The Inventory On Hand report shows the value of the stock on hand in your Inventory. It uses the average price of the item, multiplied by the quantity on hand at the end of the selected period to derive the estimated value of the goods held by the outlet/location at the end date of the date range.
In Reports, select Inventory on hand.
When you load the page, a report will be automatically generated with the following settings, but feel free to change any of these and click Show report.
Location: The first outlet (alphabetically) linked to user account.
Inventory lists: All are selected.
Period: The previous month.
The report displays the Total cost on hand at the top of the table (you may need to scroll the table horizontally), followed by the list of items.
Note that items that have never been included in stock counts will not appear in this report.
Items not mapped to the POS will also not show data in the Sales column.
To download the results as an Excel file, click Export.