Inventory valuation

The valuation report answers one question: what was your stock worth at the end of a day? Any past day is exact, because the ledgers are append-only and the report replays them.

Ingredients and packaging are valued at weighted average cost: the same figure their own pages show. Made stock is valued at the cost it was booked at: batches at their sealed cost under what your unit cost counts, deliveries of a product you buy ready-made at their landed cost, and opening stock at the cost you gave it. Packaging you used on a product is part of that product’s cost, so it is never counted again in the bulk’s value.

Made stock is listed under its own category: a product under the product category of its format (“Sauces › Hot sauces”), a made component under its recipe’s category, and an unfiled one under No category. Until your workspace has a product category, products are listed under their recipe’s name, and components likewise until it has a recipe category. The CSV writes the path on one line: Sauces / Hot sauces.

What it leaves out, and says so

Stock with no cost behind it, from a delivery, a batch or you, is never guessed at: opening stock entered with a blank cost stays out too. The report counts it as unvalued, keeps it out of the total, and tells you how many items it left there. A priced delivery, a costed batch or opening stock entered with its unit cost gives the item a value, and the next valuation picks it up. Free ingredients are worth zero, and archived items are out of the figures entirely.

The CSV carries one row per item, with quantity, unit value, the valuation basis, and an unvalued flag, so your spreadsheet can slice what the page rolls up.

Packs in the file

A carton is not an item of its own: its jars are in the sauce’s figure, valued there. The CSV lists each product’s packs right under it, with the pack column naming them and how many there are, and no value of their own.

Reading a past date

Pick a date and the report rebuilds the shelf as it stood that evening: every delivery, batch, sale and loss dated on or before it, in the order the ledger recorded them. Nothing is stored in advance, so there is no snapshot to go out of date. A backdated entry changes the past the moment you book it, which is why a month-end figure can move after month end.