Inventory Changes Report
IN THIS ARTICLE:
INTRODUCTION
Go to Inventory > Reporting (Under Cycle Count). You will be taken to the Inventory Changes Report page.
In the Inventory Changes Report page, you will see three different tabs:
- Products
- Inventory Transactions
- Indicators
For each tab, you must select a time frame and click on Load Table for OpenBoxes to generate data to display.
Products (Cycle Count History)
This Report shows Cycle Counts performed within the designated period by products.
This report gives you a summary of the Cycle Counts performed with the following important data:
- Product Name
- Category
- Tag
- Product Catalogue
ABC Class: ABC classification is a method of categorizing items into three groups: A, B, and C based on their consumption.
Group A items are high-consumption items that should be counted 4 times a year.
Group B items should be counted 2 times a year.
Group C items should be counted once a year.
- Last Counted: When the product was last counted
- Number of Counts: The number of counts performed for the product during the time period
- Number of Adjustments: The number of adjustments resulting from the number of counts that were performed during the designated period, i.e., how many Cycle Counts resulted in an inventory discrepancy
- Total of Adjustments: The sum of all positive and negative adjustments that resulted from the cycle counts performed during the designated period.
- Adjustments Value: The value of the total of adjustments.
- Months of Stock Change: How the adjustment affected the months of stock the product will be in inventory based on existing demand.
- Currently in Stock: The current quantity on hand.
- Value in Stock: The value of the quantity on hand.
Review an Example
In the example above, you can see the Cycle Count data for product 19390.
- It was last counted on August 12, 2025.
- In the selected period, this product was counted twice.
- From the two Cycle Counts, one cycle count resulted in adjustments.
- The one adjustment resulted in an increase of 72 in inventory.
- The value of the adjustment is $82.56.
The Cycle Count shown above presents in the stock history as follows:
Inventory Transactions Report
Use the Inventory Transactions Report to view inventory transactions by products recorded via RECORD STOCK (RS), INVENTORY IMPORT (II), CYCLE COUNT (CC), AND INVENTORY ADJUSTMENTS (IA, via the Adjust Stock Feature).
You can see the following data in this report:
- Alignment: (More/Less/Equal) This column displays if the inventory transaction resulted in an increase, decrease, or change to the product's inventory.
- Product
- Type: The type of inventory transaction performed on the product: Inventory Adjustment (IA, via Adjust Stock), Cycle Count (CC), Record Stock (RS), and Inventory Import (II).
- Recorded: Who recorded the transaction and when.
- Transactionid
- Qty Before: The Quantity on Hand before the transaction was recorded
- Qty After: The Quantity on Hand after the transaction was recorded
- Difference: The difference in inventory before and after the transaction was recorded.
- Root Causes: Only applies to Cycle Count transactions. Displays comments entered during the Resolution phase of cycle count.
- Comments
Inventory Accuracy Dashboard
This Dashboard provides summarized Cycle Count data. Use this to view Cycle Count summaries for your desired period.
Product Inventories
This indicator displays the number of products counted at least once during the selected period.
Inventory Accuracy
This indicator displays the percentage of Cycle Counts that resulted in equal counts (the physical count matched OpenBoxes quantity). This represents the share of inventory for which OpenBoxes inventory accurately matched the physical inventory.
Inventory Shrinkage
This indicator presents the number of products for which the overall inventory adjustment for the selected period is negative; meaning if the total of all adjustments recorded is negative during the given period, that product is accounted for Inventory Shrinkage. The financial inventory shrinkage is the equivalent of the inventory decrease for these products in USD.