Accounting
ERP
Inventory Management
Stock Ledger: What It Shows and How to Use It to Track Inventory Movements
Last updated: October 10, 2026 · Independent guide · We do not sell rankings or coverage.
A stock ledger is the item-by-item record of every inventory movement: receipts, issues, transfers and adjustments, each shown with the quantity, the cost and the running balance of units and value after the movement. In inventory accounting it is the subsidiary ledger behind the inventory account in your general ledger, so the total of all item balances should equal that account. In a corporate law context the same term means the register of shareholders, which this page does not cover.
What a stock ledger is
A stock ledger holds one line per inventory transaction for each item, usually split by location or warehouse. Each line records the posting date, the source document, the quantity in or out, the unit cost under your costing method, and the resulting balance in units and dollars.
Four movement types appear in almost every stock ledger:
- Receipts: purchase receipts, customer returns and production output that increase stock.
- Issues: sales shipments, consumption into production and returns to vendors that decrease stock.
- Transfers: moves between locations, which reduce one location and increase another without changing the company total.
- Adjustments: count corrections, damage, shrinkage and revaluations, which change quantity, value or both.
Because the ledger carries value as well as quantity, it ties directly to the balance sheet. The sum of the running values for all items on a given date should equal the inventory control account in the general ledger on that date.
Example: a stock ledger for one item
The table below is an illustration, not real company data. It shows one item (WID-100) at one warehouse for October, valued at moving average cost.
| Date and document | Movement (quantity × unit cost) | Running quantity | Running value |
|---|---|---|---|
| Oct 1, opening balance | 200 × $5.00 | 200 | $1,000.00 |
| Oct 3, purchase receipt PO-4471 | +300 × $5.50 = +$1,650.00 | 500 | $2,650.00 |
| Oct 8, sales shipment SO-9012 | −250 × $5.30 = −$1,325.00 | 250 | $1,325.00 |
| Oct 12, transfer TR-118 to Store 2 | −50 × $5.30 = −$265.00 | 200 | $1,060.00 |
| Oct 20, cycle count adjustment | −4 × $5.30 = −$21.20 | 196 | $1,038.80 |
The receipt raises the average cost to $5.30 ($2,650 ÷ 500 units), and every later issue leaves at that cost. The shipment feeds cost of goods sold, the transfer moves $265.00 to Store 2’s ledger, and the count adjustment posts $21.20 to a shrinkage account. At month end, $1,038.80 is this item’s contribution to the inventory account balance.
How the stock ledger is used in practice and in software
Inventory controllers use the stock ledger to trace a wrong on-hand quantity back to the last good count. Accountants use it to support the inventory balance at close and to explain cost of goods sold.
Reconciling to the general ledger. Microsoft documents that Dynamics 365 Business Central stores quantity changes in item ledger entries and value changes in value entries, then posts those values to the general ledger through the Post Inventory Cost to G/L batch job unless Automatic Cost Posting is turned on. Its Inventory – G/L Reconciliation page compares value entries with G/L entries and shows the difference by account (Microsoft Learn, March 17, 2026; Microsoft Learn, August 29, 2024).
Where to find it in common ERPs.
- Business Central: the Item Ledger Entries list is the stock ledger, with entry types such as Purchase, Sale, Transfer, Positive Adjmt. and Negative Adjmt. The Inventory Valuation report shows the quantities and values of increases and decreases in inventory over a selected period (Microsoft Learn, no date shown; Microsoft Learn, August 29, 2024). If you are weighing Business Central against NetSuite more broadly, see our NetSuite vs Business Central comparison.
- SAP S/4HANA: SAP Learning lists MB51 (Display Material Document List) for individual goods movements and MB5B (Stocks for Posting Date) for opening and closing quantity and value with total receipts and issues for a period (SAP Learning, no date shown).
- NetSuite: the Inventory Activity Detail report (Reports > Inventory/Items > Inventory Activity Detail) shows quantity per transaction for each item, and the Inventory Valuation Detail report (Reports > Inventory/Items > Inventory Valuation > Detail) lists the transactions that affect inventory value (Oracle NetSuite Help, no date shown; Oracle NetSuite Help, no date shown).
The retail stock ledger is different. Retailers often keep the ledger at department or class level rather than by item, and carry inventory at retail selling price as well as cost. Oracle Retail Merchandising describes its stock ledger as recording the financial results of buying, selling, price changes and transfers, rolled up to subclass and location by day, week or month, under either the retail or the cost method (Oracle Retail Finance User Guide, January 8, 2020). Under the retail inventory method, ending inventory at retail is converted to cost with a cost complement, the ratio of beginning inventory plus purchases at cost to the same items at retail adjusted for permanent markups and markdowns, computed separately for departments or classes with different gross profit percentages (26 CFR 1.471-8, eCFR current through October 7, 2026). That is why markdowns appear as ledger lines in retail but not in a distributor’s item ledger.
Related terms
- Cycle counting: the counts whose differences post as adjustment lines in the stock ledger.
- Standard cost vs actual cost: the costing choice that decides the unit cost on each ledger line.
- General ledger automation: how the GL side of the reconciliation is being automated.
How we researched this
We read the pages that rank for “stock ledger” and found most define the shareholder register rather than inventory. We then used vendor documentation from Microsoft, SAP and Oracle and the Treasury regulation on the retail method, checked on October 10, 2026. The worked example is our own illustration.
Related guides
- Perpetual vs Periodic Inventory: Journal Entries Compared
- Inventory Reconciliation: Count, Records and GL Tie-Out
- Stock Transfer Orders: Process, In-Transit and ERP Setup
Frequently asked questions
Is a stock ledger the same as an inventory valuation report?
Not quite. A stock ledger lists every movement with a running balance, while a valuation report summarizes quantity and value at a date or over a period. Most ERPs build the valuation report from the same ledger entries, so the two should agree.
What is the difference between a stock ledger and a stock card?
A stock card, or bin card, traditionally records quantities only for one item at one storage location. A stock ledger adds cost and running value, which is what lets it reconcile to the general ledger inventory account.
Why doesn’t my stock ledger total match the GL inventory account?
Common causes are manual journal entries posted directly to the inventory account, cost adjustments that have not been posted yet, and receipts valued at expected cost before the vendor invoice arrives. In Business Central, the Inventory – G/L Reconciliation page shows the difference by account so you can drill into it.
Sources
- Microsoft Learn, Design details: Inventory posting, March 17, 2026.
- Microsoft Learn, Reconcile inventory costs with the general ledger, August 29, 2024.
- Microsoft Learn, Enum “Item Ledger Entry Type”, no date shown.
- SAP Learning, Using classic stock lists and document lists, no date shown.
- Oracle NetSuite Help, Inventory Activity Detail Report, no date shown.
- Oracle NetSuite Help, Inventory Valuation Detail Report, no date shown.
- Oracle Retail Merchandising Finance User Guide, Stock Ledger Overview, January 8, 2020.
- eCFR, 26 CFR 1.471-8, Inventories of retail merchants, current through October 7, 2026.
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
