Inventory and costing — margin is decided before you sell

A frozen meat importer closed its year with an unexplained stock shortfall of around AED 700,000 and a further half a million dirhams of product that had expired on the shelf. The company was profitable on paper until the count. Two causes, both structural, neither about dishonesty.

They recorded quantity only. No batch number, no expiry date, so the system could not distinguish a carton received in March from one received in September. And picking was whatever was nearest the door, which meant the oldest stock sat at the back of the cold store until it was worthless.

Both are inventory design decisions taken by default rather than on purpose. The warehouse is where purchasing meets sales, and it is where the money actually sits.

The five stages

The inventory life cycle

1. Receiving and inspectionWhat arrived, matched against what the purchase order committed to. Material that fails inspection sits in quarantine and never becomes available stock.
2. Put-awayA location chosen by product type or turnover rate. The payoff is at picking: walking is most of the labour cost in a warehouse.
3. Cycle countingA handful of items every day instead of one accurate day a year. A difference found the week it happened has a cause you can name.
4. ValuationFIFO, average or standard cost. The same transactions report different profit under each, which is why the choice belongs with the auditor before go-live.
5. Picking, packing and dispatchThe system decides not only what to pick but which units — first expired, first out, with batch tracking that gives you a recall path.

Only one of these five is invisible from the warehouse floor, and it is the one that appears on the balance sheet.

1. Receiving and inspection

Not everything that arrives is acceptable. The cycle opens by matching what came against what the purchase order committed to.

Where quality matters — food, pharmaceuticals, anything with a specification — a quality control stage sits between arrival and stock. Material that fails inspection is held in a quarantine location and never becomes available inventory, so it cannot be sold, cannot be picked, and does not inflate the valuation. Companies that skip this step discover the failure at the customer, which costs the goods and the relationship.

2. Put-away

Rather than dropping the pallet wherever there is a gap, the system directs it to a location chosen by product type or turnover rate.

The payoff is at picking, not at storage. Fast-moving items near the dispatch door and slow-movers at the back saves walking, and walking is most of the labour cost in a warehouse. This is also the point where an ERP’s inventory module reaches its ceiling and a dedicated warehouse system starts to earn its keep, a boundary set out in ERP vs CRM vs MRP vs WMS.

3. Cycle counting

The annual shutdown count is obsolete and expensive: the company stops trading, everyone counts badly under time pressure, and the result is one accurate day a year.

Cycle counting replaces it. Each day the system nominates a handful of items to be counted — high-value and fast-moving items more often, dead stock once a year — and a discrepancy is investigated while the cause is still recent. The record stays close to reality all year instead of once in December, and the finance team stops discovering a variance they have no way to explain.

The practical argument for it: a difference found the week it happened has a cause you can name. A difference found eleven months later is written off.

4. Valuation

Stock is not a pile of units. It is a number on the balance sheet, and it appears in the profit and loss account as cost of goods sold.

The decision that produces that number is the costing method. First in, first out charges the oldest cost to each sale. Average cost recalculates a weighted cost with every receipt. Standard cost holds a fixed rate and throws the difference to a variance account.

The same transactions produce different reported profit under each. In a period of rising prices, FIFO charges older, cheaper cost to sales and reports a higher margin than average cost does, on identical purchases and identical sales. Neither is wrong. Choosing without understanding that is how a company is surprised by its own year end.

Pick the method with the auditor in the room, before go-live, and write down why. Changing it afterwards is a disclosure, not a setting.

5. Picking, packing and dispatch

The sales order generates a picking list, and the system decides both what to pick and which specific units.

That second part is what the meat importer was missing. Where expiry matters, the rule is first expired, first out: the system directs the picker to the batch that expires soonest, and the picker cannot silently substitute another. That single control is what converts expiry from an annual write-off into an exception somebody handles.

Batch and serial tracking also gives you the recall path. When a supplier notifies you of a defective batch, the question is which customers received units from it. With batch tracking that is a report. Without it, it is a phone call to every customer you shipped to that month.

Turning the warehouse from a cost centre into a control point

Three levers, in order of return.

Scan rather than type. Barcodes on receiving and picking remove the transcription error, which is the largest single source of stock variance in every operation I have measured. The hardware is cheap relative to one bad count.

Keep the three-party separation. Purchasing requests, the warehouse receives, finance pays. No one of the three can move a number without the other two seeing it. This is the same control that makes the three-way match work, viewed from the warehouse side.

Treat overstock as a symptom. A full warehouse reads as a strong company and is often the opposite: cash converted into goods that are not selling, plus the storage cost of holding them. The number to watch is inventory turns, and the item-level version of it — days of stock on hand — tells you exactly which lines are funding the problem.

Where this sits

Inventory is fed by the procurement cycle and drained by order to cash, and its valuation is the single largest judgement that reaches the ledger and the close. Read the four in that order; the sequence is on the learn ERP page.

When evaluating products, ask for the costing method to be changed in front of you and ask what happens to the historical valuation. The answer separates products that treat costing as configuration from products that treat it as an accounting event. Where each system stops is covered in the systems comparison.