Stock on Hand, Movements and Stock Value

Know how much stock you have, why, and what it is worth.

On-hand is always the live sum of the signed stock ledger, so nobody keeps a stock number by hand and it cannot drift.

The storekeeper checks availability and traces movements back to their documents; a manager reads stock value and cost of sales. Both read the same ledger that the goods documents write.

Use the documented operating model as a starting point, then adapt fields, approvals, reports, or connected areas when your process differs.

Before you start

Put the right records and roles in place.

Nothing special: the reports read whatever the ledger holds. A new company shows zeros until goods documents are posted or opening balances are entered as direct stock movements.

Documented sequence

Three questions, one ledger.

Each stage identifies the action, handoff, or record change that moves the work forward.

01
Check how much — Storekeeper
Open Stock on Hand for one row per product and store, or Stock on Hand by Product for the total across stores. Both are computed from the ledger when you open them, so they are always exact.
02
Trace why — Storekeeper
Stock Movements lists every movement with its date, store, direction, signed quantity, price and cost. Each posted line links to the receipt, issue, transfer, return or adjustment that wrote it.
03
Read what it is worth — Manager
Product Costs shows each product's quantity, moving-average cost and value, recalculated on every movement. Stock Value and Monthly Cost Of Sales turn that into value per product and cost per month.

Connected work

Carry the record into the next decision.

Related features and workflows reuse the same business records instead of asking teams to rebuild the context.

InventoryThe goods documents that write the ledger, the product-cost rules and the full list of inventory reports.Move and count stockTransfers, returns, adjustments and stocktakes — the documents behind most ledger lines.Fulfil a sales orderHow posting a goods issue takes stock out of a store and feeds Monthly Cost Of Sales.Replenish stock with a purchase orderHow a posted goods receipt brings stock in at its acquisition price and moves the average cost.

Current scope

The moving-average cost is kept company-wide, not per store, so a product is valued at the same average cost in every store.

A starting point, not a fixed package

Start from the stock you already hold.

Stores come from the Stores register, and opening balances are entered as direct stock movements carrying their unit cost. Additional reports, dashboard figures or other stock views can be scoped as a Custom adaptation.

Try BusinessIntents

Decision-stage answers

Check stock on hand FAQs

How do we load opening balances?

Enter a direct stock movement with a positive quantity and the unit cost in its price; that cost becomes the product's starting cost. Until then, or until goods documents post, a new company shows zeros.

Can the on-hand figure disagree with the movements?

No. There is no on-hand table: Stock on Hand is computed from the ledger each time it is read, per product and store, so it always matches the movements.

Do transfers or returns count as cost of sales?

No. Monthly Cost Of Sales counts goods issues only. A store-to-store transfer is also net zero on the average-cost pool, so internal moves never shift the average.

Can anyone edit a product's average cost?

No. Product Costs rows are bookkeeping the system maintains and recalculates on every movement. When a product's stock runs out, the last known cost is kept.

Review the real workflow

Trace one product's stock in BusinessIntents.

Use a real record or transaction to compare the documented flow with the way your team works today.

Try BusinessIntents Read the detailed guide