After an inventory, you require reliable and transparent data about which warehouses and storage locations were part of the inventory, which stocks were counted in each case, and which stock deviations resulted from the count.
Xentral provides you with two different tools for transparent evaluation and follow-up of the inventory, which are described in this article. Both the Mobile Inventory Report and the Delta Report can be used easily and conveniently without manual preparatory work or prior settings, so that you always have an overview of the counted stocks and possible deviations.
-
Mobile Inventory Report: As an inventory manager, you can track the progress of the count per storage location here during the inventory process. After the count has been completed, you can download the counting lists here, which document the inventory runs and their results in detail.
-
Delta Report: The so-called Delta Report is available in the Reports module after the inventory process has been completed and lists the inventory discrepancies found during the inventory.
In the Warehouse > Mobile Inventory Reports menu, you will find an overview of all current and past inventory runs that have been performed with the Mobile Inventory App.
Tip
You can use the filters FROM, UNTIL, and Key Date to either filter specifically by inventory runs that have taken place during the period you set, or to determine stock numbers for a specific closing date. See chapter Determining inventory for a key date for details on how to use these filters to determine inventory levels for a specific closing date.
If you want to track information about specific inventory runs in the Stock > Mobile Inventory Reports menu, you do not need to set separate filters.
After opening the menu in Xentral, click the arrow icon to the left of the desired warehouse. This will show you the detailed view of the inventory runs in that warehouse.
In the Status column, you can see its exact status during and after an inventory run.The following table gives you an overview of the available statuses and their meaning.
|
Status |
Meaning |
|---|---|
|
|
There are still storage locations within the run for which no count was made. |
|
|
The inventory team (consisting of counter and controller) has completed the count and submitted the required signatures for confirmation in the Mobile Inventory App. The transfer of the counted stocks to Xentral is imminent. |
|
|
The inventory team (consisting of counter and controller) has started counting. |
|
|
The inventory run data and the counted stocks were completely transferred to and processed in Xentral and the counted stocks were recorded as new stocks of the counted storage locations. |
The following additional information is available in the detailed view:
-
Name: The name of the inventory run assigned when the run was created in the Mobile Inventory App.
-
Counter: The name of the employee selected as the counter for the run.
-
Controller: The name of the employee selected as the controller for the run.
-
Started runs: This time stamp shows when the count was started in the warehouse.
-
Completed runs: This timestamp indicates when the count was completed in the warehouse.
Note
In this column, there is only one time stamp if all storage locations have been counted for the run and there are therefore no more open (= uncounted) storage locations.
-
Open shelves: Number of storage shelves for which counting has not yet been performed.
-
Counted shelves: Number of shelves for which a count has already been carried out.
If required, you can download a separate counting list for each individual inventory run. You can choose whether you want to download the file in CSV or PDF format. To do this, click on the CSV icon or the PDF icon in the Counting list column on the very right side of the detailed view of the inventory run.
Here is an example inventory counting list in PDF format:
In the vast majority of industries, an inventory must be carried out at the end of the year, or more precisely on a fixed date each year, with a determination of all existing stocks as of December 31 of the year being customary.
Especially if your warehouse has a very large area and numerous products need to be counted, you won't be running inventory on a single day with just one inventory run. Instead, multiple inventory runs will be performed with the Mobile Inventory App in a set inventory period until all storage locations have been recorded and counted. In the Mobile Inventory Reports module, you can use special filters to determine inventory at a cut-off date of your choice. Xentral will then automatically calculate inventory for the cut-off date from the combination of all counting results for the period you set and the interim write-offs as part of your daily business.
Example 1. Practical example of annual or key date inventory
-
From 16 to 23 December 2025, the annual inventory was carried out in several runs
-
You need the inventory for the December 31 key date for the financial statements
-
First, open the Stock > Mobile Inventory Reports menu.
-
Then set the filter FROM to 16.12.2025 and the filter UNTIL to 23.12.2025.
-
As key date, select December 31, 2025.
-
Click on Apply filters.
-
The table will be reloaded and you can now generate the Key date report in PDF or CSV format in the corresponding column on the right and then download it.
As part of the inventory process, it may happen that the stocks counted differ from those stored in Xentral. In practice, there are two different types of stock deviations:
-
Actual stock is larger than target stock: The inventory count results in more products in the storage location than stored in your Xentral.
-
Actual stock is larger than target stock: During inventory, fewer products are counted in the storage location than stored in your Xentral.
The so-called Delta Report lists all inventory changes that have been made during inventory with the Mobile Inventory App, which you can then summarize in the Delta Report.
Take a look at the following example to understand what this means:
Example 2. Practical example for the Delta Report
-
According to inventory data, there were 20 pieces of a specific product in Xentral at the storage location H1L1R1 before the inventory.
-
As part of the inventory, 18 product copies were found in storage location XentralH1L1R1 and this number was recorded with the Mobile Inventory App.
-
The inventory is completed in the app and the stock in Xentral is thus also adjusted to 18 pieces for the storage location H1L1R1.
-
In this case, the Delta Report will output an inventory change of -2 for this product in this storage location.
Note
Have multiple counts been made consecutively for the same storage location? In this case, the Delta Report always refers to the most recent result, i.e. the latest count recorded with the app before the Delta Report is created.
Proceed as follows to create and download the Delta Report in Xentral.
-
Open the Reporting > Reports (New) menu.
The report overview opens.
-
In the Your reports tab, click on the [6] Stammdatenpflege und Unterstützung operativer Prozesse section.
A list of available reports is opened.
-
Click on Delta Report.
-
In the From date and To date fields, enter your desired period of inventory discrepancies recorded by the app.
-
Select the desired export format for the Delta Report above.
-
Click on Run request in the upper right corner.
Xentral generates the Delta Report in the background. Once completed, you will find the report in the Exports tab, where you can download it.