The Inventory Overview serves as a statistical view of inventory value and all operations that took place in the stocks during the selected period. It helps monitor consumption, inventory counts, stock transfers, and discrepancies between stocks and POS sales.
It is necessary to turn on English subtitles in the video.
All data in the overview is displayed in purchase prices and is primarily intended for inventory management control, not for tracking revenue.
How to display the inventory overview
- In the Reports section, select Stocks report.
- In the top left corner, select the stocks you want to track.
- In the top right corner, select the period.
- You can switch between VAT included / VAT excluded views.
Most commonly, the overview is used for a calendar month or year, for example when checking inventory counts or consumption.
Main data in the overview
This section of the overview explains why the inventory value changed between the beginning and the end of the selected period.
Each item represents all operations that occurred in the stocks during the period – sales, stock receipts, inventory counts, write-offs, or transfers between stocks.
If you want to understand changes in inventory value or identify discrepancies, this is where you will find a detailed breakdown.
⬇️ Show examples of individual items
Total inventory value at the beginning of the period
This is the sum of the values of all inventory items at the beginning of the selected period and shows the total monetary value of the stocks at that time.
Example:
|
Total inventory value at the end of the period
This is the sum of the values of all inventory items at the end of the period and shows the stocks value after all changes.
Example:
|
Total value of stock receipts
This is the sum of all stock receipts during the selected period and shows how much money was spent on purchasing goods into the stocks.
Example:
|
Inventory count balance
This is the sum of value differences identified during inventory counts and represents surpluses or shortages in the stocks.
Example:
|
Total write-offs
This is the sum of all write-offs in the stocks and shows the value of items removed from stock due to damage, expiration, or breakage.
Example:
|
Total stock transfers
This represents the value of all transfers between stocks and shows how transferred items increased or decreased the value of a specific stocks.
Example:
|
Total production
This represents the value of produced inventory items and shows the value of new items created through production from existing stock items.
Example:
|
Total sales
This is the sum of the values of all sales and shows the value of goods sold from the stocks during the selected period.
Example:
|
Detailed breakdown by ingredients
At the bottom of the overview, you will find a breakdown by individual inventory items.
Each ingredient can be tracked:
- by value (€)
- or by units (pieces, liters, kilograms)
The overview can be filtered and exported to .csv (Excel).
The Inventory Overview helps you quickly identify discrepancies and understand how the stocks is actually being used. It also helps you efficiently track stock movements, optimize inventory management, and reduce losses.