What the Stock on the Shelf Actually Cost
An item that is valued at its buying price is valued at a number somebody typed once. Since 14 October every receipt moves the item’s cost to what the stock on the shelf actually cost you, the receipt’s journal posts at that same figure, and a sale keeps the cost it was made at.
In one paragraph
Stock is now valued at a true moving average. Each receipt blends its own cost into what you already hold, a purchase order in dollars is converted at the rate recorded on the order, and the inventory journal posts the same figure the valuation report shows. If your margins looked too good after a price rise, this is the change that stops them.
Ask most small businesses what their stock is worth and they will read you a number off a report. Ask what that number is made of and the honest answer is usually: the quantity on hand, multiplied by whatever price was on the item when it was created. That price is a fact about one day, typically the first purchase. Everything since — the supplier who put prices up in March, the shipment that came in dollars, the bulk discount in June — never reached it.
Why “valued at buying price” lies
A buying price is a field on the item. It is useful as a default on a purchase order and a guide for whoever is ordering. As a valuation it has one property that makes it dangerous: it does not move when your costs do. Your shelf fills with stock bought at three different prices and the report values all of it at the first.
The error is invisible because nothing on any screen is wrong. The quantity is right. The price is the price you typed. The multiplication is correct. What is wrong is the assumption that the price you typed is still what the goods cost, and no report questions that.
The quantity is right, the price is the one you typed, the multiplication is correct — and the value is still wrong.
Three receipts, one item
Take a solar lantern sold by a Nairobi electrical shop at KES 1,800. The item was created with a buying price of KES 1,200, because that is what the first local supplier charged. Here is what happens over a quarter.
| Event | Quantity | Unit cost (KES) | On hand after | Average after (KES) |
|---|---|---|---|---|
| Receipt from a local supplier, cost typed on the check-in | +100 | 1,200.00 | 100 | 1,200.00 |
| Sales at the till | −60 | 1,200.00 | 40 | 1,200.00 |
| Import PO at USD 10.00, order rate 129.50 | +200 | 1,295.00 | 240 | 1,279.17 |
| Sales at the till | −140 | 1,279.17 | 100 | 1,279.17 |
| Tax-inclusive PO at KES 1,334 incl. 16% VAT | +60 | 1,150.00 | 160 | 1,230.73 |
Two lines deserve a second look. The import was ordered at USD 10.00 a unit and the purchase order recorded a rate of 129.50 to the shilling, so the receipt came in at KES 1,295.00 — converted at the rate on the order, not whatever the rate happened to be on the day the boxes arrived. And the third supplier quotes VAT-inclusive: KES 1,334 a unit includes 16% VAT, which you reclaim, so the cost of the goods is KES 1,150.00. The receipt strips the tax before it blends.
The import receipt, blended
The blend happens before the stock lands, because the old average applies to what was on the shelf before the receipt, not after it. With nothing on hand, a receipt simply sets the cost.
At the end of the quarter there are 160 lanterns on the shelf. Valued at the buying price they are worth KES 192,000.00. Valued at what they actually cost — 100 at the blended average plus 60 from the last receipt — they are worth KES 196,916.67. That is a KES 4,916.67 difference on one product line, and it runs in whichever direction your prices moved.
Where a receipt’s cost comes from
-
A cost typed on the check-in line
Optional, in your workspace currency. When the storekeeper knows what this delivery cost, it wins.
-
The purchase order line
For a check-in against a PO: the line price, net of tax when the order is tax-inclusive, converted at the rate recorded on the order — or today’s rate if the order recorded none.
-
A count gain
Stock found at a count comes in at the current average. Finding a box you already owned should not change what the others cost.
-
Everything else
The current average, or the buying price when the item has never had one.
Whichever rule applied, the cost and its source are stored on the receipt line, so a figure on a valuation report can be traced back to the delivery that set it and the reason it was that number.
The journal now agrees with the report
Before this change there were two figures for the same delivery. The valuation report used one; the receipt’s journal — debit Inventory, credit the payable or the receiving clearing account — posted the buying price. For the import above that journal would have said KES 240,000.00 while the supplier’s bill said KES 259,000.00, and the KES 19,000.00 between them sat in clearing waiting for someone to explain it.
The receipt now posts at the cost it was blended at, so inventory on the balance sheet and inventory on the valuation report are the same number arrived at the same way. The valuation, dead stock, turnover and ABC reports all read the moving average and say so at the top: Costing: Moving average, in KES.
What landed cost adds
A dollar price is not what an import costs you. Freight, clearing, duty and the agent’s fee all land on the same shipment. When you allocate those on a PO receipt, they go onto that receipt’s batches, and the item’s average is recomputed from what is on hand: batched stock at its full landed unit cost, unbatched stock at the moving average. What landed cost is covers the allocation itself, and the landed costs feature shows where it sits on the receipt.
One quieter fix rides along. When stock ran out, the average used to snap back to the buying price, so the next returned unit was valued at a price nobody had paid in months. The last average now stands until the next receipt replaces it.
What it means for your margins
At KES 1,800 a lantern, the first 60 sold at a cost of KES 1,200.00 — a margin of KES 600.00, a third of the price. The next 140 sold at KES 1,279.17, a margin of KES 520.83, or 28.9%. On the old basis every one of those 200 sales would have reported the KES 600 margin, and the shop would have discovered the difference only when the bank balance failed to match the profit.
Every POS sale line now also keeps the unit cost it was sold at. A receipt next month that moves the average does not rewrite last month’s margin, and a return reverses exactly the cost the sale posted rather than today’s. Lines from before 14 October fall back to the current cost, because that is the only cost they ever had. For the choice between this method and first-in-first-out, see FIFO vs weighted average.
What AWRA OpsHub does today
- A true moving average on every stocked, owned item, blended from supplier check-ins, PO receipts, count gains and POS returns before the stock lands.
- Receipt cost from a typed unit cost, else the PO line net of tax and converted at the order’s recorded rate, else the current average — stored on the line with its source.
- Receipt journals that post at the blended receipt cost rather than the item’s buying price.
- Valuation, dead stock, turnover and ABC reports on the moving average, labelled with the method and currency.
- Landed costs allocated to batches on a PO receipt, with the average recomputed from batched and unbatched stock together.
- The unit cost at the moment of sale stored on every POS sale line and used for margin reports and returns.
More we can add to your workspace
- First-in-first-out costing as a per-workspace choice, for businesses that prefer layer-by-layer cost.
- Landed cost blended straight into the moving average for items you keep without batches.
- A revaluation run that re-states historic sales after a late supplier credit or price correction.
- The sold-at unit cost carried on invoice and sales-order lines the way it now is on POS lines.
Where we point you to a specialist
- Which costing method your statutory accounts use is a decision for you and your auditor. We record cost consistently under the method the system applies and say which it is on every report.
- Exchange rates are the ones you record on the order or the rate service supplies. Choosing the rate your accounts should use for a foreign purchase is an accounting policy, and it stays yours.
Anything above that you need, we can build for you
Everything listed above as something we can add describes what ships in the standard product today — it is a starting point, not a limit on what AWRA OpsHub can do for your organisation. Kenya's eTIMS integration and its maintained payroll engine are both in the product because clients needed them and commissioned them; neither appeared by itself, and the same door is open for whatever you just read about. One qualification so this is worth what it claims: a small number of things on this blog we deliberately leave to a specialist rather than build — a statutory ledger we will not sign our name to, a rule that would decide a tax question for you, a clinical or member-funds record that belongs in a regulated system — and where that is true the post says so in those words. Everything else is a scope, a timeline and a price.
The operational work, which is what most commissions actually are
An extra approval stage in a chain that does not match the standard one, a custom field set on employees or assets that only your sector needs, an expiry that has to block an order rather than send an email, a report your board asks for in a shape nothing produces, or a scanner or weighbridge feeding the goods-in door. These are the commissions we are asked for most often and the smallest ones we quote — and unlike a revenue-authority pipeline, none of them waits on a regulator.
The module-shaped additions, which are the ones readers ask for most often
A price list with real discount authority, a customer-facing quotation that expires, a bill of materials or recipe costing, a staff advance that is issued, acquitted and chased, a member or unit ledger, a matching rule that holds a payment. Each of these is a build rather than a setting, and each has been quoted before — a bigger piece of work than a custom field, with a written spec and a date instead of a roadmap slide.
The report, document or pack nothing currently produces
The board pack in the shape your board actually asks for, a donor or funder layout, an invoice or receipt template carrying what your regulator or your customer expects, a dataset the report builder cannot reach yet. Usually the fastest thing on this list to deliver, because the data is already in the system.
Systems, rails and hardware you already run
The accounting package, CRM, online store, core banking or custom database you intend to keep — connected through our API so a fact is entered once and appears everywhere it is needed. Plus the physical edge: a scanner, a scale, a weighbridge or a till peripheral feeding the door it belongs to.
How it works: you describe the requirement, we return a written scope, timeline and cost, and once agreed it is built into your environment and maintained as part of the product. Nothing here waits on a regulator or a published specification, which is why operational builds are the ones we quote fastest. Tell us the requirement that would otherwise rule us out — that is a better first conversation than a demo.
Tell us what your operation needsFour questions that test any stock valuation
What does a receipt at a new price do to the value of stock already on hand?
A good answer sounds like
It blends, by quantity, into one average.
What it tells you
If nothing changes, the report is multiplying by a typed price.
At what rate is a dollar purchase order valued when it arrives?
A good answer sounds like
The rate on the order, or a stated rule.
What it tells you
An unstated rate is a valuation that moves with the day you happened to receive.
Does the receipt journal post the same figure the valuation report shows?
A good answer sounds like
Yes, the same cost, and here is where it came from.
What it tells you
Two figures for one delivery end up in a clearing account nobody owns.
If costs rise next month, does last month’s margin change?
A good answer sounds like
No — each sale keeps the cost it was made at.
What it tells you
A margin report that rewrites history cannot be compared month to month.
See your stock at what it cost
Open the valuation report after your next receipt and check the costing line at the top. If you would like to walk through your own receipts and what the change does to your margins, talk to us.
Inventory managementFrequently asked questions
What is moving-average inventory costing?
Every time stock is received, its cost is blended with the cost of what is already on hand, weighted by quantity. The result is one average cost per item that reflects every price you have paid for the stock currently on the shelf.
How is a purchase order in US dollars costed when the goods arrive?
The PO line price is converted to your workspace currency at the exchange rate recorded on the purchase order. If the order recorded no rate, today’s rate is used. A tax-inclusive line is reduced to its net price first.
Does a stock count change my average cost?
A count gain comes in at the current average, so finding stock you already owned does not move the cost of the rest.
Will my old sales margins change after a new receipt?
No. Each POS sale line stores the unit cost at the moment of sale, so later receipts do not rewrite it. Sale lines from before 14 October 2026 fall back to the current cost because they never stored one.
Does the inventory journal match the valuation report now?
Yes. The receipt journal debits Inventory at the same cost the receipt was blended at, instead of the item’s buying price.
