Inventory valuation report

See the total value of your stock on hand, broken down by item and location.

Updated June 21, 20261 min read

The inventory valuation report shows what your stock on hand is worth at a chosen point in time, using each item’s recorded cost.

Run the report

  1. Go to Reports → Inventory valuation.
  2. Pick the as-of date — the report values stock as it stood at that moment.
  3. Optionally filter by location, category, or item.
  4. Click Run to generate the figures.

What the columns mean

Column Meaning
Quantity on hand Units physically held as of the chosen date
Unit cost The item’s cost basis (average or last cost)
Total value Quantity on hand × unit cost

The report total is the sum of every line — this is the number that ties to your balance sheet inventory asset.

Valuation uses on-hand stock only. Reserved and incoming quantities are not counted, because they are either already owned (reserved) or not yet received (incoming).

Run the report for each warehouse separately when you need a per-location asset figure for accounting.

Next steps

Export the data to reconcile against your accounting system, or save the filtered view for monthly close.

Was this article helpful?

Related articles

Still need help?

Ask Filo, our built-in AI assistant, for an instant answer — or get in touch with our team and we'll take it from there.