Stock Ledger

The Stock Ledger report is ERPNext's canonical movement log. Every Stock Entry, Purchase Receipt, Delivery Note, and OLE consumption posts entries here. If a quantity changed somewhere in ERPNext, the change is in this ledger.

What it shows

Every row is one Stock Ledger Entry — a single posting against an item × warehouse × voucher combination. Columns:

• Posting Date and Posting Time — when the entry posted.
• Voucher Type and Voucher No — the document that caused the posting (Stock Entry, PR, etc.).
• Item — the item that moved.
• Warehouse — the warehouse the entry posted against.
• Qty Change — positive (in) or negative (out).
• Balance — running balance for this item × warehouse after this entry.
• Valuation Rate — the rate at the time of this entry.

By default it's ordered chronologically, with filters across the top for date range, item, warehouse, and voucher.

How to read it for a specific story

The Stock Ledger is what you reach for when you have a specific question. A few patterns:

• "What happened to this fabric in the last week?" Filter by item. Date range = last 7 days. Read top-down. Every movement, attributed.
• "Why is this WIP warehouse showing more stock than it should?" Filter by warehouse. The entries that don't look right are the candidates for investigation.
• "What did this Batch consume?" Filter by item; cross-reference the Voucher No against Stock Entries linked to the Batch.
• "When was the last receipt for this trim?" Filter by item, sort by date descending, look for Voucher Type = Purchase Receipt.

Why every garment factory needs to know this report

Eventually, every factory has the conversation: "ERPNext says we have 500m of fabric but the rack is empty." The Stock Ledger is where you find out what happened. It shows every receipt, every issue, every transfer, every consumption — and the entry that doesn't make sense is the one to investigate.

A clean Stock Ledger is a sign of a healthy operation. A Stock Ledger full of adjustments and corrections is a sign that your team is posting movements late, posting them wrong, or skipping them entirely.

Exporting and analyzing

The Stock Ledger exports to CSV or Excel. Common analyses:

• Movement summary per item. Sum the Qty Changes by item over a month — gives you the gross movement volume.
• Consumption pattern by Batch. Filter to consumption-type Stock Entries; group by the linked Batch.
• Aging. Sort by Posting Date; identify items that haven't moved in months (slow-moving stock candidates).

For the most common questions, the Stock Balance and Production Stock Summary answer faster. Reach for the Stock Ledger when those don't.

What to do next

For the snapshot view of "what's where right now," see Stock Balance.