Two Records That Rarely Agree
A bin card and a stores ledger are two records of the same material, kept by different people for different reasons, and that is exactly why they diverge.
The bin card sits at the storage location and is written up by the storekeeper as material physically moves in or out; it records quantity only. The stores ledger sits with the accounts staff, is written up from documents such as goods received notes and material requisitions, and records quantity and value. Because one follows the goods and the other follows the paperwork, they agree only when nothing has moved between their postings.
At the rack
Bin cardKept by the storekeeper, in quantity only, and posted at the moment material is received into or issued from the bin. Anyone standing at the bin can read what should be there.
In the accounts office
Stores ledgerKept by accounts staff, in quantity and value, and posted from receipts and requisitions, sometimes days after the movement. It carries materials into the books.
On the floor
Physical stockThe third reference. Where the two records differ it can agree with only one of them, which is how a reconciliation shows which record is being kept properly.
A gap that persists therefore means one of the two is not being kept up at the time things happen. The physical stock can agree with only one of them, so reconciling against a count identifies which record actually describes the floor.
What Each Record Is For
The two records serve different readers, which is why they were never designed to agree automatically.
The bin card is the storekeeper's running total. Its purpose is immediate and local: it tells the person at the bin what should be there, which makes it the record most directly comparable with the physical stock. It carries no values because the storekeeper has no use for them, and in many stores it also shows the reorder level, so the same card signals when to replenish.
The stores ledger is the accounting record. It carries receipts, issues and the running balance in quantity and value for each item, priced under the business's cost formula, and it feeds the inventory figure in the books. It has to be supported by paperwork, which is both its strength and the reason it lags behind the floor.
The differences at a glance
The points most often asked about, side by side, and what follows from them.
Bin card
- Kept at the bin by the storekeeper
- Quantity only
- Posted as material moves
Stores ledger
- Kept by the accounts staff
- Quantity and value
- Posted from documents
What follows
- The card shows what should be on the rack now
- The ledger shows what the books carry
- They agree only if both capture every movement
Where the Two Diverge
Divergence is normal rather than exceptional, and its causes are predictable enough to list before any reconciliation begins.
- Timing of posting. Material moves at the bin at once and reaches the ledger when the paperwork does, so at any moment the two describe positions separated by however long that takes.
A timing gap clears on its own - Issues recorded at one end only. An urgent issue made on a verbal instruction may be written on the bin card and never produce a requisition; the reverse happens where a requisition is raised for material that was never taken.
A discipline gap never clears - Different units of measure. A bin counted in pieces against a ledger kept in kilograms, or in metres against rolls, diverges permanently unless the conversion is documented and applied at both ends.
The most tedious gap to unpick - Returns to store. Unused material put back on the rack and never credited in the ledger leaves the bin card higher than the books.
Common in workshops and maintenance stores
Only the first of these corrects itself. The other three repeat every period until the procedure behind them changes, which is why a lasting gap is a finding about the process, not about the count.
Reconciling Them
Reconciling the whole stores catalogue is rarely worth the effort, so the exercise starts with selection.
Items are chosen by value and by movement: higher-value lines because that is where the money is, fast-moving lines because that is where posting discipline is most tested. A sample built this way shows whether the process works, which is the real question, instead of producing a complete list of differences nobody will act on. How such samples are built is covered in the guide to stock audit sampling methods.
- Agree the opening balance of each selected item in both records at a date both accept.
- List every receipt, issue and return for a defined period from the bin card, and separately from the ledger.
- Match the two lists movement by movement, marking each entry that appears in one record only.
- Count the item at the end of the period, with movements held or recorded separately while it is counted.
- Explain each unmatched entry from the documents, and note which record the count supports.
Tracing transactions is the method; comparing closing balances is not. A difference of a given quantity says nothing, while the transaction that caused it says everything. The physical count is the third reference that settles the argument: without it, a reconciliation can show only that the two records differ, not which one is wrong.
Evidence the Reconciliation Produces
Reconciling the two records against a count gives one of three outcomes for each item, and each points at a different place.
- All three agree. The bin was written up as material moved, the documents reached accounts and the count confirms both. A sample of agreeing items is what makes the disagreements readable, because it shows the process works somewhere.
- The two records agree with each other but not with the count. Both are wrong in the same way, which points outside the recording process: an issue made with no record at all, material moved between bins, or loss.
- The count agrees with one record only. The failure lies in the flow of documents between store and accounts, and the record that disagrees shows which way it runs.
The difference that still has no explanation after all three tests is the one that matters, because it means material moved and nothing in the business captured it at either end. That is where an investigation starts.
Making the Records Agree and Stay Agreeing
Posting discipline at the bin is where this is won or lost.
The bin card has to be written up as material physically moves, by the person moving it. Any arrangement where issues are jotted on a slip and posted later will drift, because the slip is the thing that goes missing. Urgent issues on a verbal instruction are the specific failure: the material goes, production continues and nothing is written anywhere. A rule that nothing leaves the store unless the card is marked, applied without exceptions including for senior staff, is what holds it.
Reconcile monthly, not annually. A month's divergence can be traced to the documents that caused it; a year's cannot, and by then neither record can be corrected with confidence. Where a store has moved to a system posted in real time at the bin, the bin card becomes redundant and the same reconciliation runs between the system and the count.
Where the two records have drifted beyond reconciliation, an independent count resets the position. In engineering and machine-tool stores, where thousands of low-value parts sit beside a few costly components, an engineering stock audit establishes which record describes the floor and gives both a clean starting point.
