Stock value and capital tied up report

See how many units are in stock now, how much capital they tie up and their value at list price, by branch and category, with the number not yet priced.

Who can do this:

Owner, Store Admin, Manager, Supervisor-Approver, Inventory staff, Accountant, Auditor, Viewer (role defaults; the owner can change them)

The Stock value report sums up how many units the store has in stock right now, how much capital they hold, and what they would bring in at their list prices, by branch and category. It shows data as of the moment you open it; there is no period to choose.

What each column means

• Branch and Category: one row per product category in each branch, such as phones, tablets or laptops.

• units: items the store still owns, including those awaiting inspection, in repair, reserved or being transferred between branches.

• Capital tied up: the total cost of those items, including repairs and other recorded costs, shown only to people with View cost and profit.

• Value at list price: the sum of list prices. Items without a list price are not counted.

• Not priced: how many items have no list price yet.

• Average age (days): average age, counted from the date received.

The headline figures show Units in stock, Total capital tied up, Value at list price and Not priced for the whole store, or for the branch you picked.

How to read the figures

• If Value at list price is very close to Capital tied up, your list prices leave little profit, or many items have no price yet.

• If a category has a high average age, open Stock age and aged stock reports to see which items are stuck.

• Value at list price is the price the store set itself, not a price you are sure to get. The real price can be lower after haggling or markdowns.

Open it from the overview page

On the Overview page, the Capital tied up in stock card leads to this report. The alert about capital concentrated in one model leads here too. See Capital concentrated in one model: risk and actions.