Inventory Valuation: Know Your True Stock Cost [2026]

Your stock count can be right and your stock value can still be wrong

Most product businesses know how many units they have. The harder question is what those units are actually worth.

A spreadsheet might say you have 400 lamps in the warehouse. But does it reflect the supplier price from six months ago, the new price you paid last week, the freight bill that arrived after the goods, and the 60 units already shipped? If it does not, your inventory valuation is only a tidy-looking guess.

That matters because stock value touches purchasing decisions, margin reports, insurance conversations, month-end reporting, and the awkward moment when an accountant asks for a number you cannot defend. It is also why inventory valuation should not live in a separate tab that somebody updates when they remember.

VNDLY uses a running average-cost approach, often called AVCO or weighted-average cost, built from goods actually received against purchase orders. It then uses that cost consistently in stock value, reports, and margin calculations. The goal is simple: one number that is grounded in what arrived, not what somebody hoped it would cost.

What inventory valuation really means

Inventory valuation is the cost assigned to the stock you still hold at a particular point in time. It is not the retail price. It is not the total of your supplier quotes. It is the cost basis of the units remaining after receipts, shipments, returns, and adjustments.

For interchangeable inventory, accounting standards commonly use FIFO or weighted average cost formulas. The IFRS overview of IAS 2 also notes that inventory is measured at the lower of cost and net realisable value. That final accounting treatment depends on your jurisdiction and circumstances, so your accountant should set the policy. VNDLY is there to keep the operating data and received costs coherent.

The operational problem is rarely the formula alone. It is the inputs.

If a supplier initially quotes $10 per unit, then invoices $11, and freight adds another $1.20 per unit, a valuation based only on the original quote will understate the stock value and overstate the margin. If your team receives only part of a purchase order, the quantity must be right too. This is why a clean purchase-order receiving workflow is the foundation of trustworthy inventory value.

Why most businesses get it wrong

The usual pattern is understandable. A team starts with a product list, adds a cost column, and updates it after a supplier sends a new price sheet. For a small catalogue with stable costs, that can work for a while.

Then reality intrudes. A shipment arrives in two parts. A freight invoice lands later. One warehouse receives stock while another ships it. Someone overwrites the product cost with a supplier's next quote before the new goods arrive. The stock count may still look plausible, but the value becomes a mixture of old, new, and imagined numbers.

Three mistakes cause most of the damage:

1. Treating quoted prices as received costs. A supplier's price list helps create a purchase order, but the received stock record is what should feed valuation.
2. Ignoring freight and duties. A unit that cost $10 at the factory may cost more by the time it reaches your location. Leaving that out makes margin reporting look healthier than it is.
3. Using a different cost number in every report. If the product page, inventory report, and margin report do not agree, people stop trusting all of them.

This also explains why a strong stocktake matters. A cost formula applied to the wrong on-hand quantity is still wrong. If your physical count and system quantity drift apart, start with the process in our inventory accuracy guide, then bring the corrected quantities back into the same operational record.

How VNDLY calculates a practical inventory value

VNDLY uses weighted-average cost for its operating valuation. When stock is received against a purchase order, VNDLY maintains an average cost for that product variant. When a report needs a cost, it uses that maintained average first.

If an older item does not yet have an average cost, VNDLY falls back to a weighted average calculated from its received purchase-order lines. It includes only lines with a received quantity. If a landed unit cost exists, that is preferred over the basic unit cost for the fallback.

The result is intentionally different from a supplier price list. In VNDLY, purchase price lists help put the right supplier price onto a new purchase order. They are planning inputs. They do not replace the actual cost history of received stock.

Here is the simple version of the calculation:

• 100 units received at $10 each = $1,000 of cost
• 100 units received later at $12 each = $1,200 of cost
• 200 units received in total for $2,200
• weighted-average cost = $11 per unit

If 70 units ship, the system does not pretend the remaining 130 all came from a single invoice. It values the remaining quantity using the running average. That makes the result calmer and more useful when supplier costs move over time.

For the on-hand quantity, VNDLY aggregates all inventory movements up to the end date you select. That matters for a point-in-time valuation. Filtering only the transactions from the current month would not tell you what is still sitting in the warehouse.

Where to see the numbers in VNDLY

Open Reports, then choose Inventory Valuation. The report shows each product and variant with these fields:

• Product, SKU, and Variant
• On Hand quantity at the selected point in time
• Avg Net Cost
• Avg Landed Cost
• Net Value
• Landed Value

This is useful because it gives your team a way to separate two related questions. Net cost shows the received unit cost before the additional landed-cost layer. Landed value helps you see the value after costs such as freight or duty have been allocated to the received units.

You can sort the report by value to find the SKUs tying up the most cash. That is often a better place to start than staring at the full catalogue. A slow-moving product with a tiny quantity is annoying. A slow-moving product with a large landed value is a purchasing decision waiting to happen.

If a product is missing a useful cost, do not paper over it by editing a report export. Check whether the opening stock was entered without cost history, whether the relevant purchase order was received correctly, and whether landed costs were allocated. Then correct the workflow at the source.

A practical workflow for cleaner valuation

You do not need a finance degree to make the operating data much better. Start with a repeatable process.

1. Create purchase price lists for planning

In Price Lists, select New price list. Give it a name, set the Type to Purchase, choose the currency, and save it. Assign the list to the relevant supplier and add the product prices and quantity tiers you have agreed.

This gives purchasing a useful starting point. When a buyer selects that supplier on a new purchase order, VNDLY can use the matching purchase-price tiers to populate the unit cost. If the ordered quantity changes, the selected tier can change too.

For more on keeping those starting prices from quietly going stale, read our guide to supplier price drift and margin loss.

2. Receive stock against the original PO

When goods arrive, receive them against the purchase order rather than adding stock with a disconnected manual adjustment. VNDLY records the received quantity and uses the receipt history for cost resolution.

Partial deliveries are fine. The important thing is to record what actually arrived, when it arrived. That gives your stock count, availability, and cost history the same source of truth.

3. Add landed costs before relying on a margin number

Where freight, duty, or other incoming costs belong to the shipment, allocate them before treating a product-level margin as final. VNDLY can use landed unit cost in its valuation fallback, rather than relying only on the supplier's net price.

This is particularly important for imported goods. A product can look profitable at its factory cost and disappointing once it is actually on your shelf.

4. Review the high-value items, not only the total

A total inventory number is useful for a month-end conversation. The SKU-level view tells you what to do next.

Sort the Inventory Valuation report by Landed Value. Look for products with high value and weak movement, recent supplier-cost changes, or uncertain physical quantities. Pair that review with your sales and planning reports before placing the next order.

If you manage several sites, the same approach works alongside VNDLY's warehouse inventory tools: stock movements and purchase receipts need to be recorded where they happen, not reconstructed at month end.

From the Founder: valuation becomes urgent when cash gets tight

A valuation report will not make a bad buy disappear. It does make the exposure visible early enough to change the next order, discount a slow mover, or ask harder questions of a supplier.

That is the real value of the feature. Not a prettier total. A clearer view of where your cash is sitting.

See the broader VNDLY workflow

Inventory valuation works best when it is connected to the day-to-day work around it: product data, purchase orders, goods receipts, stocktakes, and sales. The VNDLY demo gives a quick overview of the wider system.

Frequently Asked Questions

What is inventory valuation?

Inventory valuation is the cost assigned to the stock you have on hand at a given date. It helps you understand the value of the inventory asset, cost of goods sold, and the cash tied up in products.

Does VNDLY use FIFO or weighted-average cost?

VNDLY uses weighted-average cost, also called AVCO, for its operating inventory valuation. It maintains an average cost from goods received against purchase orders, with a received-PO history fallback for products that do not yet have a maintained average cost.

Do purchase price lists change my inventory valuation?

No. Purchase price lists provide quoted supplier prices for planning and new purchase orders. VNDLY does not use those quotes as the cost basis for inventory valuation. Valuation uses received-cost history and can prefer landed unit cost where available.

Why is my inventory value different from the supplier's latest price list?

The supplier's latest list may describe the price of a future purchase. Your current stock may have been bought across several receipts at different prices, with different freight or duty costs. A weighted-average approach reflects that received history rather than replacing it with a new quote.

Is VNDLY's Inventory Valuation report enough for tax filing?

It is a useful operational report, but tax and statutory reporting requirements differ by country and business. Review the final treatment, including any write-downs or policy choices, with your accountant.