Inventory valuation report
See the total value of your stock on hand, broken down by item and location.
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
- Go to Reports → Inventory valuation.
- Pick the as-of date — the report values stock as it stood at that moment.
- Optionally filter by location, category, or item.
- 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.
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.