Reports
Valuation
Value your on-hand inventory as of a chosen date, at purchase cost and at landed cost.
Updated 2026-09-03
The Inventory Valuation report values the stock you're holding — units on hand, priced at cost — as of a date you choose. It's the report to run for month-end close or a snapshot of tied-up inventory value.
What it shows
One row per batch with a positive balance as of the As Of Date, with columns Product Name, SKU, Batch Code, Expiry Date, Units On Hand, Purchase Unit Cost, Landed Unit Cost, Value (Purchase), Value (Landed), Currency, Costed, and Batch ID. Batches with zero or negative balance on that date are left out entirely — they hold nothing to value.
Below the batch rows, a coverage footer shows how many of the listed batches were costed, and how many uncosted units are excluded from the total.
How value is calculated
For each batch, Value (Purchase) is units on hand multiplied by the batch's purchase unit cost, and Value (Landed) is units on hand multiplied by its landed unit cost (purchase cost plus the per-unit share of freight, duty, and other landed charges). Both use the batch's weighted-average cost as of the report date — a batch received in more than one lot at different prices is valued at the blend of those receipts, not the most recent one.
Running the same report for a past As Of Date recomputes the cost and balance as they stood on that date, using only receipts and cost lines dated on or before it — later activity has no effect on a historical valuation.
Batches without a cost
A batch with no purchase cost recorded is uncosted: its Purchase Unit Cost, Landed Unit Cost, Value (Purchase), and Value (Landed) cells are left blank, its Costed column reads no, and its units are added to the Uncosted units count in the footer instead of being valued at zero. This keeps an uncosted batch from silently understating your total — a blank total is a prompt to go add the missing cost, not a hidden zero.