Reporting

Stock Valuation

The Stock Valuation report shows what your stock on hand is currently worth, costed from what you actually paid rather than a guess.

Pro feature. Stock Valuation is included on Pro and Pro Sync plans. Accounts on other plans see an upgrade prompt instead of the report, and trial accounts get full access while the trial is active.

How value is calculated

Each SKU is valued using the best available cost information, in this order:

Basis	When it's used
FIFO	The SKU has purchase order receipt history. Stock is valued oldest-cost-first: as units sell or are adjusted out, TrueSKU consumes the oldest received cost first, so the report reflects what was actually paid for the units still on hand.
FIFO + manual	Some stock is covered by receipt history and some isn't (for example, stock that existed before a purchase option was linked). The receipted portion is valued FIFO; the rest falls back to the SKU's manual unit cost, if one is set.
Manual cost	The SKU has no purchase order receipt history at all, but has a manual unit cost set. All on-hand stock is valued at that cost.
Unknown	No receipt history and no manual unit cost. This stock is shown separately and excluded from the total value rather than guessed at.

Purchase order receiving and FIFO

Every time you receive stock against a purchase order line, TrueSKU records a cost layer: a quantity received at a specific cost, at a specific time. If you buy the same SKU from two suppliers at different prices, or the same supplier changes their price between orders, each receipt keeps its own cost. The valuation report always consumes the oldest available layer first, so the reported cost moves through your actual purchase history rather than jumping straight to the latest price.

SKUs without a purchase option

Not every SKU is linked to a supplier item, so not every SKU has purchase order history to draw a cost from. For those, you can set a manual unit cost directly on the SKU, and the report will use it. Once a SKU is linked to a supplier item, its manual unit cost can no longer be edited by hand — from that point on, cost comes from what you actually paid on purchase orders, so the two numbers can't drift apart from each other.

A manual unit cost can go stale. If a manual cost was set before a SKU had a purchase option, and stock from that period is still on hand, the report may fall back to that older figure for the uncosted portion. Keeping manual costs reasonably current matters most for SKUs that rarely get purchase order receipts.

Bundles (kits)

Bundle SKUs are made up of other SKUs, and each of those component SKUs already carries its own valuation. To avoid double-counting, bundle SKUs are left out of the report's total stock value. They still appear in the report table with a computed value (component costs × quantity required) shown for reference, so you can see what a bundle is worth without it inflating the overall total.

Why this matters

A "no data" or unknown-cost warning on the report is a signal, not a bug: it means TrueSKU genuinely doesn't have a reliable cost for some of your stock yet, either because it predates this feature, was adjusted in outside of a purchase order, or has never had a manual cost set. Setting manual costs on affected SKUs, or letting new purchase order receipts build up real history, brings that stock into the valued total over time.