The valuation price is chosen in a clear order of priority:
- The most frequent unit price on your invoices, in the six months ending with the stocktake month
- If two prices are equally frequent, the more recent of the two
- If the item was not bought in those six months, the last purchase price
Why the most frequent price rather than an average: for most of a site's items the supplier's price stays the same all six months, so the most frequent price is the one you actually pay. A one-off promotion or a line with a misread quantity does not move it, whereas it would move an average. Lines whose quantity was not read reliably do not count at all. The weighted average price for the same period is listed alongside in the export, for comparison.
An item with none of the above stays marked “No price” and is shown separately. We do not value it at 0.00 — a zero looks like a correct number and is not one.