Inventory reports
Data Explorer
This table presents a summary of sales performance across different locations. It includes key metrics such as sales including tax, sales excluding tax, sales cost, and sales units. Additionally, it provides end-of-period (EOP) cost and quantity for inventory management. In general, the table offers insight into the financial performance and inventory status of each location within the specified period.
Product Group performance
This section shows a table that represents an overview of the sales performance across the various product groups. It lists the average cost of inventory, sales excluding tax, sales cost and sales profit for each of the various product groups, along with the key inventory metrics such as Days Sales of Inventory (DSI), inventory turn, and Gross Margin Return on Investment (GMROI).
The table helps in assessing the profitability and efficiency of each product group within the specified period
Brand performance
This report presents an overview of the sales performance across the various product brands. It lists the average cost of inventory, sales excluding tax, sales cost and sales profit for each of the various brands, along with the key inventory metrics such as Days Sales of Inventory (DSI), inventory turn, and Gross Margin Return on Investment (GMROI).
The report helps in assessing the profitability of each of the product brands within the specified period.
Supplier performance
This report presents an overview of the sales performance across the various vendors/suppliers. It lists the average cost of inventory, sales excluding tax, sales cost and sales profit for each of the various suppliers, along with the key inventory metrics such as Days Sales of Inventory (DSI), inventory turn, and Gross Margin Return on Investment (GMROI). The report helps assess the profitability of each of the suppliers within the specified period.
Product profitability
This report provides a detailed breakdown of the financial performance of various products. It shows each product's sales excluding tax, sales profit, average stock, and key financial metrics such as Gross Margin Return on Investment (GMROI), Days Sales of Inventory (DSI), inventory turn, and profitability grade. A profitability of grade A indicates a strong financial performance of the specific product while profitability grade C shows a weak performance, profitability grade B indicates an average performance.
The report is essential in assessing which products are driving profitability and which ones may need further attention.
Matrix report
The "Matrix Report" is a pivot table that summarises the stock quantities of different product variants across various locations for the selected period. It gives a breakdown of the total amount of stock that is available for each product and its variants in each location. A good example is if the product has more than one option/variant for example; a wrist watch that comes in silver and gold colours or a pair of shoes that comes in more than one size.
First Column (Product Name): Lists the names of products.
Second Column (Location Names): Indicates the locations where these products are stocked.
Remaining Columns: Represent different product variants or options with their respective stock quantities at each location.
This table is useful for analysing inventory distribution and availability of specific product variants across multiple locations, helping in decision-making for stock management and reordering processes.