The Inventory Valuation report is a snapshot of what you own — total cost basis and retail value — split by item type. Use for accountant-facing reporting (cost of inventory on the balance sheet), insurance valuations, and as a cross-check against your aging.
What “active” means
The same Include filter as Inventory Aging:
- In-stock + on-memo (default) — anything with quantity in stock OR quantity on memo
- In-stock only — only physically present
Items marked Returned or Scrapped are excluded entirely.
Summary view
One row per item type:
- Jewelry — finished pieces from the inventory table. Carry quantity = QOH (+ QtyOnMemo if included). Cost / Retail are per-unit × carry.
- Watches — same shape as Jewelry, separate table.
- Diamonds — diamonds from the stones table (StoneType = ‘Diamond’). Cost and Retail are lot totals (no qty multiply).
- Colored Stones — non-diamond, non-pearl stones.
- Pearls — stones with Category = ‘Pearls’. Quantity matched by NoStones (count) instead of CtWeight.
Each row shows Items (lot count), Cost, Retail, and Markup % = (Retail − Cost) ÷ Cost. A bird’s-eye view of your blanket margin per category.
Drill-down
Click any item type label in Summary → Detail filtered to that type. Removable Type pill in Detail; click × to see all types together.
Detail view
One row per stock item:
- Stock ID (clickable, links to the right inventory page by type)
- Type — only shown when not drilled in (since the filter shows just one type)
- Description, Store
- Qty — for J/W: carrying quantity (QOH + on-memo if included). For Diamonds / Colored Stones: carat weight. For Pearls: stone count.
- On Memo — separately surfaced so you can spot items currently with customers
- Cost, Retail
Sorted highest-retail-first so the most-valuable items rise to the top — useful for spot-checks and write-down decisions.
Markup % caveats
The summary’s Markup % is (sum(Retail) − sum(Cost)) ÷ sum(Cost) across the type. A few items priced poorly can pull the average — check Detail when a category looks off.
Markup % is list-based — it tells you what the markup should yield at full retail. The Pricing Realization report tells you what you actually realize after discounts.
Tips
- Year-end balance sheet — export the Summary as Excel, the Cost column is what your accountant wants for cost of inventory. Sum across types for a single number.
- Insurance — for replacement-cost coverage, use Cost. For ACV (actual cash value), use Retail with appropriate adjustments.
- Health check — pair with Inventory Aging. If 30% of your Cost is in items aged 365+, you have working capital tied up in dead inventory.
- Per-store — when a store filter is set, Cost / Retail / Markup are scoped to that store. Useful for multi-location reconciliation.
- In-stock vs in-stock + memo — the toggle changes what carries through to all calculations. For balance sheet purposes you typically want both (you still own memo’d items). For “what can the salesperson see when they walk in?” use in-stock only.