What’s Inside the Stock Transfer Export File?
Questions:
- What information is included in the Stock Transfer export file?
- How is the Stock Transfer export file structured in Excel?
- Why does each warehouse have its own sheet in the export file?
- What do positive and negative values mean in the Total Value column?
Description:
The Stock Transfer Export gives you a clear, easy-to-read Excel file that shows all stock movements between warehouses.
It helps you quickly understand what moved, where it moved, and when—without digging through screens in the system.
Each warehouse gets its own sheet, making it super simple to track incoming and outgoing stock separately.
Solution:
How the Export File Is Structured?
-
Download all stock transfers as an Excel file by following the below link
Steps to Export Stock Transfer Data - How to Export Stock Transfer Data?
-
File format
The export downloads as an Excel (.xlsx) file.
-
Warehouse-wise sheets
-
Each warehouse has its own sheet.
-
Example:
-
Main warehouse
-
Cold Storage Warehouse
-
-
-
What you’ll see in each sheet
-
Date & Time – When the stock was moved. Example : 15.12.2025 14:30:00
-
Description – The note entered during the stock transfer. Example : Regular restock
-
Ingoing Stock – The warehouse that received the items. Example : Cold Storage Warehouse
-
Outgoing Stock – The warehouse that sent the items. Example : Main warehouse
-
Amount – Number of items moved (always shown as a positive number). Example : 50
-
Total Value – Shows the value impact for that warehouse
-
Negative value → Stock moved out. Example : -500.00 (Outgoing)
-
Positive value → Stock moved in. Example : 500.00 (Ingoing)
-
-
Tax Matrix - Which matrix is used for the stock trasnfer.
-
Tips and Tricks:
The most important things to remember!!!
-
Check warehouse sheets separately – Each sheet tells the full story for that warehouse.
-
Don’t panic about negative values – They simply mean stock went out, not that something is wrong.
-
Use Excel filters – Filter by date, description, or amount to find transfers faster.
-
Match descriptions – The description helps you remember why the stock was moved.
-
Great for reports – Perfect for audits, finance checks, and inventory reviews.
Simple, clear, and very handy for keeping stock movements under control 📦📈