Inventory Ledger
Path · Inventory > Inventory > Inventory Ledger
A screen that aggregates and shows the inventory ledger (receipts, shipments, adjustments, etc.) by SKU over a period.
💡 Key Features
✅ Shows the inventory flow opening → inbound → outbound → closing aggregated by SKU and stock condition.
✅ Even for the same SKU, Normal and Damaged stock conditions are aggregated as separate rows.
✅ The queried ledger can be exported to an Excel file.
💡 What's the difference between Inventory Ledger and Inventory History?
Inventory Ledger — period-based summary (opening/inbound/outbound/closing totals), mainly used for closing reports.
Inventory History — detailed per-SKU, per-event tracking (when/what/how much changed), mainly used to trace inventory.
📦 Inventory Ledger
Column | Description | Direction |
|---|---|---|
Opening | Stock quantity at the start of the period | — |
Inbound | Regular PO-based received quantity | + |
Return Inbound | Restocked quantity such as customer returns | + |
Adjustment Inbound | Quantity increased by inventory adjustment | + |
Outbound | Quantity shipped for sales/fulfillment requests | - |
Adjustment Outbound | Quantity decreased by inventory adjustment | - |
Transfer-out | Disposal, samples, external transfers | - |
Closing | Stock quantity at the end of the period | — |
💡 Closing stock formula : Closing = Opening + Inbound + Return Inbound + Adjustment Inbound − Outbound − Adjustment Outbound − Transfer-out
🔍 Search · Sort · Export
Area | Options |
|---|---|
🔍 Search input | SKU · Barcode · product name |
☰ Search filters | EAN · UPC · ASIN · brand · stock condition · WMS · warehouse · store |
↕️ Sort | Click any column for ascending/descending |
💡 Export : the Export button at the top right downloads the current ledger to Excel.
⚠️ All ledger data is read-only and cannot be edited on this screen.
⚠️ If no period is set, the default (this month) applies.