Katana offers detailed tracking of historical stock movements to analyze discrepancies in inventory levels and average costs. You can access this data directly in Katana or export it for in-depth analysis.
Why it’s useful
Katana tracks detailed historical stock movements so you can:
Investigate discrepancies between Katana stock levels and physical inventory.
Verify or troubleshoot average cost calculations (before and after each movement).
Analyze an item’s stock movement patterns over time.
You can view this information directly in Katana or export it for deeper analysis.
How to view stock movement history
Go to the Stock screen.
Find the item you want to investigate.
Click one of the following columns for that item:
Average cost
Value in stock
In stock
A pop-up window will open, showing the last 365 days of stock movements for that item.
What you’ll see in the stock movement view
Each row includes:
Movement date
Related document (linked to the source document)
Quantity change
Cost or price of the movement
Quantity balance after the movement
Total value in stock after the movement
Average cost after the movement
You can also filter movements by date or any other column in this view.
Exporting stock movement history
In the pop-up view, click Export (under the location) to download a CSV file of the displayed movements.
Note: You can only export historical movements per item — bulk exports are not available.
Result: You’ll have a detailed log of an item’s stock changes, including costs, quantities, and links to related documents, helping you make accurate inventory and financial decisions.
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]