The inventory valuation report

The inventory valuation report shows what your stock was worth on a particular date. It rebuilds the position from your movement history, so you can run it for today, last month's end or any date in the past, and get the same answer every time, as long as the movement history and the inventory method stay the same. It is included in every plan.

Run the report

1. Open Reports from the top navigation bar.
2. Select Inventory Valuation.
3. Choose a date in the Inventory value on panel. Today is under Now. Under Forecast, what your stock will be worth, you can pick In 30 days, In 60 days, In 90 days, the end of next month or the end of next quarter; each shows its date underneath. For any other date, past or future, use the Other date picker.
4. Narrow the result with the Warehouse, Category and Supplier filters if needed. Leave them on All to value everything.
5. Set Include Zero Qty or Include Inactive to Yes if you want products with no stock, or products that are inactive, hidden from inventory or deleted, to appear in the list. Both start at No.
6. Switch between the Products, By Supplier and By Category tabs to see the same value grouped three ways.

Reports appears in the top navigation only if your account has the reports permission. That permission opens the report but does not give access to the money in it. Without the View Inventory Value permission, every amount shows as a dash; quantities and dates still show. An owner always has that permission.

Products included in the value

Every product that holds stock on the chosen date is valued, whatever its status today. Inactive, hidden from inventory and deleted products count because their stock still exists.

Include Inactive only decides whether those products are listed. When it is No, they are hidden from the list but still counted in Total Value. A line under the total says how much of it they hold. A product whose balance on that date is zero or below is hidden unless Include Zero Qty is set to Yes.

If your account is restricted to particular departments, the report only values products in those departments. Two people can run the same report on the same date and see different totals for this reason.

How quantity and value are calculated

The report treats the chosen date as the end of that day, so it includes everything recorded on the date itself. Every movement counts towards the quantity, whatever its reason: deliveries against purchase orders, initial stock, stock-outs, transfers, assembly in and out, defective units, found inventory and manual adjustments. Nothing is excluded, so the quantity matches the stock position on that date.

Value is built from cost layers rather than a single current price. A layer is created when stock arrives with a cost attached: a delivered purchase order line, an initial stock entry that carries a unit cost, or a finished item produced by an assembly. Stock leaving the business—stock-outs, transfers out, assembly consumption, defective units and negative adjustments—draws down those layers.

If more stock is recorded as leaving than you hold, the units short are costed when stock next arrives, at what that stock cost. Until then, the product shows no quantity and no value.

Value adjustments

A value adjustment, such as a write-down or write-up, applies to the units it was made on. The affected quantity is taken from the stock on hand at the adjustment date in the order your costing method consumes stock: oldest first under FIFO, newest first under LIFO, or spread across the average under Average Cost.

The adjustment leaves with those units as they are consumed, so the report applies only the part still on hand on the chosen date. When you record an adjustment, its quantity cannot be more than you held on that date. A write-up can only reverse earlier write-downs on those units; it can never take them above what they cost.

If a product's quantity across the whole organisation is zero or below on the chosen date, its value is reported as zero and any write-down or write-up recorded against it is not applied.

Costing methods

Your organisation's costing method determines which layer is drawn down first. The report shows the method it used as a badge on the As of Date summary card.

FIFO (First In, First Out) treats the oldest stock as leaving first, so what remains is valued at your most recent purchase prices.

Each time stock leaves, LIFO (Last In, First Out) treats the newest stock on hand at that moment as leaving first, so what remains is valued at your older purchase prices. A delivery that arrives later is never counted as having left in an earlier sale.

Average Cost uses a moving average. Each delivery is blended into the average cost of the stock you hold, and stock leaves at the average of that moment. A price rise or fall is spread across the holding instead of showing up in one batch. Stock that has already left does not weigh on later averages.

To see or change the method, open Settings and choose Organization. Inventory Method is in the Main Settings block. It applies to the whole organisation, not to a single report or product. If it has never been set, the report falls back to FIFO.

Only the organisation owner can change Inventory Method. For everyone else, the field is visible but not editable.

Stock without a cost

Found inventory does not behave this way. It undoes the most recent stock-outs before it, so the found units come back at the cost those stock-outs took them out at.

The report divides a product's total value by its total quantity to get an average unit cost, so stock with no cost also drags that average down. If a total looks too low, check for stock without a cost first rather than assuming the report is wrong.

Purchase, assembly and warehouse costs

Costs are converted into your organisation's default currency using the conversion rate stored on each purchase order. They include the landed cost worked out for that line. Where a supplier claim has set a cost override on a line, the report uses that override as the complete unit cost.

Whether shipping entered on a purchase order forms part of landed cost depends on Include PO Shipping in Inventory Valuation, on the same Organization settings page. Changing it only affects purchase orders created or modified afterwards, so older orders keep the landed costs they already have.

For products built by assembly, each assembly is costed as of the day it was completed, using what its components cost on that day. Only assemblies completed on or before the chosen date are included. A past-date figure for an assembled product therefore does not change when you assemble more of it later.

Past values and forecasts

A past date is marked Past value: what your stock was worth on that day, from the movements recorded up to it.

A date after today is a forecast. The panel shows Today's value plus Arrivals from open orders minus Expected consumption, giving the Expected value on your date and the difference from today. The table adds Today, + Arrivals, − Consumption, Projected and Δ vs today columns.

Arrivals are the undelivered part of purchase order lines on approved orders whose expected delivery date falls between today and your chosen date. They are counted for the whole organisation even when you have filtered by Warehouse.

Consumption is each product's recorded monthly usage spread over the days ahead. The confidence marker on each row reflects how many months of usage history are behind that figure. Today's value uses your costing method, but the projected change uses an average-cost approximation whatever the method, as the note under the panel says.

Export the report