Skip to main content

Inventory valuation

Inventory valuation shows what the stock on hand is worth, by branch and by category. You can see it for right now, or for the end of any past day.

Open it from Inventory → Inventory valuation. You need a role that can see product costs: owner, administrator, accountant, or inventory, purchasing or store manager.

What the value means​

Each product's value is its quantity on hand × its average cost in effect at that moment.

  • The quantity is the one the kardex shows for the same moment. Select View kardex on any product to see every movement behind it.
  • A past date uses the cost that was in effect then, never today's. If the average cost has risen since September 30, your September 30 valuation does not change.
  • Each branch is valued at the end of the chosen day in its own time zone.

Why a value can be "Unknown"​

A value is never shown as Q0.00 when it is not known. A product's value is Unknown when it has stock but no cost was recorded by that date, or the recorded average was 0. The product appears under Exceptions → No valid cost.

Fix it by recording a purchase or a cost for the product. The value appears from that moment on.

Incomplete totals​

A total marked Incomplete leaves some products out and says how many. Two kinds of lines are left out:

  • products with an unknown value;
  • products with negative stock. Their line shows a negative value, but it is never added to a total.

A complete total adds every product under it.

Exceptions​

The Exceptions tab lists the products whose figures need a look, the most serious first:

  • Negative stock: more left the branch than the records say came in.
  • No valid cost: see above.
  • Unclassified movements: a movement whose direction could not be determined.
  • Stock differs from history (today only): the stock on the Inventory screen differs from what the movements add up to. Fix it on Inventory → Stock reconciliation.
  • Inactive product with stock: a deactivated product that still holds stock. It is still valued.
  • Variant history not available: stock of a product with variants from before variants were tracked. It is shown on a separate product-level line.

Stock in transit​

When a transfer is approved, the stock leaves the origin branch. Until it is received, it belongs to neither branch, so it appears under In transit, valued at the cost when it left. It counts in the combined total.

Month-end copies​

On the Month ends tab, an owner, administrator or accountant can capture a branch's valuation for a month that has ended. The copy is frozen and can never be changed.

If something dated in that month is recorded later (for example, a stock reconciliation with an earlier date), the copy says Inputs changed since capture and shows the difference next to the frozen figures. The frozen figures stay as captured.

An owner or administrator can correct a copy, with a reason. This creates a new copy that replaces it, and both stay readable.

Export​

Choose CSV or Excel to download the valuation or a month-end copy, with the same lines, totals and exceptions as the screen. Unknown values are left empty, never 0. Very large exports (over 200,000 lines) are refused: narrow them by branch or category.