For any company that sells through distributors, the hardest number to trust is how much stock a distributor actually holds — and what happened to the stock that already left the warehouse. Primary sales, from the company to the distributor, sit on the company's own invoices and are easy to see. But the moment goods enter the distributor's godown, visibility usually collapses into month-end spreadsheets and phone calls.
A distributor stock ledger closes that gap. It records every inward and outward movement so that opening, sales and closing stock can be derived for any distributor, over any period — and audited when the numbers look wrong. This guide walks through what the ledger is, why it matters to the company (not just the distributor), and how adjustments and audits keep it honest.
What a distributor stock ledger is
A stock ledger is a perpetual, append-only record of every movement of stock at the distributor. Each row is one event — goods received, goods sold, goods returned, goods damaged, or a manual correction — with a quantity, a direction, and a link to the document that caused it. Crucially, the current stock is never typed in by hand; it is derived by running the ledger forward. The ledger is the source of truth, and the on-hand figure is simply its latest total.
- Inwards: goods received from the company against a primary invoice or goods-receipt note.
- Outwards: goods invoiced onward to retailers — the distributor's secondary sales.
- Returns, damage & expiry: stock that comes back or can no longer be sold.
- Adjustments: deliberate, reason-coded corrections when reality and the system diverge.
The alternative — storing only a single "current stock" number and overwriting it — always drifts, because there is no history to reconcile against. A ledger keeps the story, not just the ending.
Opening, sales & closing — the stock statement
Once movements live in a ledger, a stock statement for any period falls out automatically. It is the inventory equivalent of a bank statement:
Opening is simply the closing balance of the previous period. Purchases and sales are the inward and outward totals. Returns and adjustments capture everything else. Because each figure is a sum of real ledger rows, the statement balances by construction — and any figure can be opened to see the exact documents behind it. That drill-down is what turns a monthly stock argument between company and distributor into a two-minute reconciliation.
Why companies must track it
Tracking the distributor stock ledger is not book-keeping for its own sake. It answers questions about your own market that primary invoices alone never can — and each answer protects revenue.
Distributor contribution — beyond your sales team's push
Some secondary sales happen because your field force booked the order; others happen because the distributor's own team moved the stock. Read the outward ledger against your field-order capture and the two separate cleanly: you can see which distributors genuinely build the market on their own pull, and which only bill what your reps hand them. That distinction should drive how you invest in each territory.
Sales-order fulfilment
A booked order only creates value when it is delivered. Comparing outward ledger movements against booked secondary orders exposes the fill-rate gap — orders taken but not served because the stock was not there, had expired, or had already been diverted. Persistent short-fulfilment is lost primary sales hiding inside a healthy-looking order book.
Cross-market seepage & stock diversion
When a distributor's outward sales land with retailers outside their assigned territory — or feed straight into another distributor's area — it distorts scheme costs, breaks price discipline, and starves the neighbouring distributor. Read outward ledger movements together with customer geography and this seepage surfaces on its own, instead of hiding inside a strong-looking sales total.
Accurate primary-order suggestions
The next primary order a company places on a distributor should be driven by what the distributor actually holds and how fast it sells — not by a flat target or a gut feel. A live closing-stock figure, read against secondary-sales velocity, is exactly the input a replenishment recommendation needs: enough to keep fast movers in stock, without loading slow SKUs the distributor will later return or divert. Without a trustworthy ledger, every primary-order suggestion is a guess.
Beyond these, the same ledger underpins shrinkage control and scheme-ROI accuracy — but the reasons above are the ones that most often go unmeasured, precisely because they live on the distributor's side of the invoice.
Stock adjustments & reason codes
Reality and the system will diverge — stock is billed outside the system, a delivery is booked but never made, a carton is damaged, a batch expires. The discipline is not to prevent every correction, but to make each one a controlled entry with a reason and an approval, rather than a silent overwrite in a spreadsheet. Common reason codes include:
- Billed outside the system: a sale happened off-book; stock is short and must be brought down with a trail.
- Not delivered to the customer: an invoiced order came back; stock returns to hand.
- Damage & expiry: stock that can no longer be sold, written down against evidence.
- Theft / shrinkage, receipt error, found stock, write-off: the rest of the everyday corrections.
Reason codes are what turn "stock just disappeared" into a measurable, categorised story. Once every correction is classified, a manager can see whether a distributor's losses are damage, diversion, or process error — and act on the actual cause.
Stock audits — counts & variance
A ledger stays trustworthy only if it is periodically checked against the physical shelf. Leading distribution companies run two cadences together:
- Cycle counts: a rotating sample of SKUs counted weekly or monthly, weighted toward fast movers, so high-velocity stock is verified more often.
- Full physical counts: the whole godown, typically each quarter — more often for perishable or high-value goods.
Good practice is a blind count — the person counting cannot see the system quantity, which removes the temptation to simply confirm it. The count produces a variance report, system versus counted, per SKU. As a rule of thumb, variance under half a percent per cycle for fast movers is healthy; consistently above two percent points to a process leak worth investigating. Two classic catches: supplier short-shipments that were billed as full, and double-counted receipts that quietly inflated the system. Confirmed findings then post back into the ledger as reason-coded true-up adjustments, so the correction is itself auditable.
How SalesDiary approaches it
SalesDiary is built around secondary sales and distribution management. Because primary inwards, secondary invoices, returns and damages are captured as they happen in the field, the distributor stock ledger builds itself from real transactions rather than from month-end data entry. That same transaction spine is what makes period stock statements, reason-coded adjustments and periodic audits practical to run across an entire distributor network — and what lets a company read distributor contribution, order fulfilment and cross-market seepage from one consistent record.
If you manage stock across distributors or van-sales warehouses, talk to our team about putting a governed stock ledger under your network.
Frequently asked questions
What is the difference between primary and secondary sales?
Primary sales are made by the manufacturer or supplier to a distributor; secondary sales are made by that distributor onward to retailers. In the ledger, primary sales are the inward movements and secondary sales are the outward movements.
How do you calculate a distributor's closing stock?
Closing = opening + purchases − sales + returns, adjusted for damage, expiry and other corrections. With a perpetual ledger, closing stock is derived automatically for any period rather than counted by hand.
What is a stock adjustment reason code?
A code that classifies why a correction was made — billed outside the system, not delivered, damage, expiry, theft, found stock and so on — so unexplained loss becomes a measurable, categorised story managers can act on.
How often should distributor stock be audited?
Combine rotating cycle counts (a sample of SKUs weekly or monthly, weighted to fast movers) with a full physical count each quarter — more often for perishable or high-value goods. Variance above about two percent usually signals a process leak.
What is cross-market seepage?
Also called stock diversion — when a distributor sells to retailers outside their assigned territory or into another distributor's area. It distorts scheme costs and price discipline; reading outward ledger movements against customer geography surfaces it.