Reading and interpreting the Inventory Movement report
Understand movement patterns, identify slow and fast movers, and spot seasonal trends.
What the Inventory Movement report shows
The Inventory Movement report is a summary of all stock activity in a period. Unlike the Stock Ledger (which shows every single transaction), the Movement report aggregates quantities by item, showing totals for inbound, outbound, and transfers.
Key columns explained
Item Name: The product being tracked.
Total Received: The total quantity of units purchased and added to inventory during the period.
Total Sold: The total quantity sold or removed through sales transactions.
Total Transferred: The total quantity moved to other warehouses (if applicable).
Net Change: The overall change in the item's inventory (Received − Sold − Transferred Out). Positive means you gained stock; negative means you used more than you received.
Quantity on Hand (end of period): The balance of the item at the end of your selected date range.
How to use it for business decisions
Identify fast-moving items: Items with high "Total Sold" are your bestsellers. Ensure adequate stock, negotiate better pricing with suppliers, and prioritize shelf space or warehouse real estate for these products.
Spot slow-moving inventory: Items with low Total Sold relative to Quantity on Hand may be overstocked. Consider discounting, bundling with faster movers, or removing them from the catalog.
Plan for seasonal demand: Run the Movement report for the same period in the previous year. If July always shows a spike in water bottles, prepare your Q3 budget and reorder schedule accordingly.
Evaluate supply chain performance: If Total Received is much higher than Total Sold in a period, you may have overbought. If Total Sold exceeds Total Received, you may have drawn down safety stock or faced a shortage.
Common patterns
Steady positive movement: Item is selling consistently and stock is replenishing on schedule. Business is normal.
Large net negative change: You've sold significantly more than you received. Either demand exceeded forecasts, or supplies were delayed. Check your reorder point.
Multiple transfers: If the same item appears in "Total Transferred" multiple times, your organization is redistributing it between warehouses. This is normal but adds complexity—be sure your reorder logic accounts for inter-warehouse stock.
Zero or near-zero movement: Item hasn't moved in the period. Likely dead stock or a new item not yet promoted. Investigate or consider discontinuing.
Where to use it
Go to Reports → Inventory → Inventory Movement Open in Usystems to generate the report for any date range and warehouse.
Was this helpful?