The stock ledger, defined
A stock ledger is the immutable, movement-by-movement record of inventory: one entry for every goods receipt, material issue, return, transfer leg and adjustment, each carrying the item, the store or location affected, the opening balance before the movement, the transaction quantity, the movement type, the reference to the causing document, and the rate — marked with a plus or minus effect. Read in sequence, the entries reproduce the running balance; read individually, each one explains a single change. It is the layer of an inventory system that turns "we have 138" into "here is exactly how we came to have 138." The system around it is described in the pillar guide, what is inventory management software.
Anatomy of a ledger entry
Every entry answers six questions about one movement. In Fast Inventory's ledger, they map to fields like this:
| Question | Ledger field | Why it matters |
|---|---|---|
| What moved, and where? | Item and store / location | Ledgers are read per item, per store — the unit of reconciliation |
| From what starting point? | Opening balance | Each entry anchors to the balance before it, so the chain is checkable |
| How much? | Transaction quantity | The size of the change — the arithmetic of the running balance |
| What kind of movement? | Transaction type | Receipt, issue, return, transfer or adjustment — the "why" category |
| Caused by which document? | Transaction reference | Links the entry to its GRN, issue slip, transfer or adjustment |
| At what value, which way? | Rate, and plus/minus effect | Supports valuation, and makes direction explicit rather than implied |
Notice what the entry does not contain: any editable "current balance" field. The balance is a consequence of the entries, maintained by the movement engine at posting time — which is exactly what makes the ledger trustworthy as evidence.
Why immutability is the whole point
The defining property of a real stock ledger is that nothing in it is ever updated or deleted. Corrections are new entries; a cancelled movement is reversed by a cancellation transaction posting the exact opposite delta of the original. Both the mistake and the fix remain on the record, each with its reference and direction.
This is not pedantry — it is what separates evidence from notes:
- Silent rewrites become impossible. No one — careless or otherwise — can make yesterday's stock story different today without leaving a trail.
- Discrepancies stay diagnosable. When the count disagrees with the book, the investigation has a bounded search space: the entries since the last agreement.
- Accountability is built in. Every correction is a posting with a document behind it — so "who changed this and why" always has an answer.
The same commit-point rule governs the other side of the coin: a physical count never writes to stock directly. It records variance, and a separate adjustment — with its own ledger entry — reconciles it. That separation is walked through in the inventory management process.
Stock ledger vs stock report
The two are often confused because both come out of the reporting menu. The distinction is simple:
| Stock report | Stock ledger | |
|---|---|---|
| Answers | What do we have now? | How did it get that way? |
| Shape | One line per item/location — the current balance | One line per movement — opening, in, out, running balance |
| Changes | Every time stock moves | Never — entries only accumulate |
| Used for | Availability, reorder, valuation snapshots | Reconciliation, audit, investigation, movement history |
In a well-built system the two always reconcile, because the balance in the report is maintained only by the movements in the ledger — they are two views of one truth, not two records to keep aligned. How each movement type feeds both views is covered in how inventory software tracks stock movements.
Want to read a real ledger?
In a 30-minute demo we post a receipt, an issue and an adjustment on your items — then open the stock ledger report and walk the entries with you.
A worked example
An illustrative week for one item — "Bearing 6204" in the main store. (Numbers invented for the example.)
Multiply this by every item and every store and the value compounds: the ledger is not a report you run occasionally, it is the substrate every other figure stands on.
What the ledger makes possible
- Reconciliation. Book-vs-physical differences are traced through the entries since the last count, instead of being written off unexplained — the flow behind stock taking & reconciliation.
- Valuation. Because entries carry rates, on-hand stock can be valued and the valuation defended entry by entry — part of the reports and analytics layer.
- Audit and compliance. Statutory and customer audits become guided walks: figure → ledger entries → referenced documents.
- Traceability. With lot-level movements recorded, batch genealogy for recalls rides on the same trail — see lot, batch & expiry (FEFO).
- Analysis. Movement history is the raw material for fast/slow/non-moving analysis and ABC classification — the difference between opinion and evidence about what to stock.
What a good ledger implementation looks like
If you are evaluating inventory software, the ledger is one of the fastest quality tells. Ask to see it, and check:
- Every movement type writes an entry — receipts, issues, returns, both transfer legs, reservations released, adjustments and scrap alike.
- Entries carry opening balance, quantity, type, reference and rate — not just a bare quantity delta.
- Corrections appear as reversing entries, and the running balance in the ledger report always reconciles to the stock report.
- The count flow records variance and reconciles by adjustment — never by writing the counted figure over the balance.
A system that passes those checks earns trust in everything else it reports — which is why the ledger sits at the centre of the case made in the benefits of inventory management software, and why perpetual, movement-level record-keeping beats count-and-hope, as explained in perpetual vs periodic inventory.
Frequently asked questions
What is a stock ledger?
A stock ledger is the immutable, movement-by-movement record of inventory: one entry for every receipt, issue, return, transfer leg and adjustment, each carrying the item, store, opening balance, transaction quantity, movement type, reference document and rate, marked as a plus or minus effect. Read in sequence, the entries reproduce the running balance — so any stock figure can be explained by walking its ledger history.
What does each stock ledger entry record?
An entry records the item and the store or location affected; the opening balance before the movement; the transaction quantity; the movement type (receipt, issue, return, transfer, adjustment); the reference — which document caused it; the rate, which supports valuation; and the direction of effect, plus or minus. Together these answer what moved, where, when, why, at what value and with what result.
Why is the stock ledger immutable?
Because a history that can be edited is not evidence. In an immutable ledger nothing is updated or deleted: corrections are new entries, and cancellations post the exact opposite delta of the original. Both the mistake and the fix stay visible with their documents. That is what lets an auditor, a customer or your own team rely on the trail — and what makes silent stock rewrites impossible.
What is the difference between a stock ledger and a stock report?
A stock report shows the current balance — how much of each item is on hand now, by location. The stock ledger shows the history — every movement that produced that balance, in order, with opening, in, out and running balance. The report answers what you have; the ledger answers how it got that way. In a well-built system the two always reconcile, because the balance is maintained only by the movements the ledger records.
How does the stock ledger help in an audit or reconciliation?
Reconciliation and audit are both walks through the ledger. For any disputed figure you filter the item and store, take the opening balance, and follow each entry — receipt, issue, transfer, adjustment — to the closing figure, opening the referenced document wherever a question arises. Count variances point to the window between counts; valuation queries follow the rates on each entry. Without a ledger, the same questions end in shrugs.