How to Calculate Net Realizable Value for Inventory, Channel by Channel
Net realizable value is what you expect to sell an item for, minus what it will cost to sell it. If that’s below what the item cost you, the difference is a write-down at year end. The formula fits on one line:
NRV = expected selling price − costs to complete and sell
For finished goods you resell, there’s nothing to complete, so it’s the selling price minus the costs to sell. (Under US GAAP this applies to stock costed by FIFO or average cost. LIFO and retail-method inventory still use the older lower of cost or market test.)
The formula isn’t where people get stuck. The inputs are. “Expected selling price” sounds like one number, and for a seller with an online store, a marketplace listing and a few wholesale accounts, it’s three, and none of them is the price on the product page.
Which selling price
Take 300 units of a product that cost $16.00 each and isn’t selling the way it used to. The numbers below are illustrative, but the shape is the one most multichannel sellers have:
| Where the units will go | Units | Price | Costs to sell per unit | Net per unit |
|---|---|---|---|---|
| Your own store | 100 | $24.00 | $5.50 (payment fee, packing, postage) | $18.50 |
| Marketplace | 150 | $19.00 | $7.35 (15% commission, $4.50 fulfillment) | $11.65 |
| Liquidator, already offered | 50 | $6.00 | $0.40 (freight share) | $5.60 |
The net figure for the whole 300 is (100 × $18.50 + 150 × $11.65 + 50 × $5.60) ÷ 300 = $12.925 a unit. Against a cost of $16.00, that’s a write-down of $922.50.
If you’d used the price on your own store, you’d have concluded there’s nothing to write down. If you’d used the liquidator’s price, you’d have written off most of it. Neither is the expected selling price. The honest number comes from where the units will actually go, and that’s a sales question before it’s an accounting one. Ask whoever runs the channels how the remaining stock will be sold, and write their answer down next to the number.
When some units are already committed, like the 50 the liquidator has agreed to take, it’s reasonable to value those at the liquidator’s price and the rest at the blend of where they’ll go. It matters most when the commitment is firm and the plan for the rest isn’t.
Which costs to sell
Count the costs that come with each sale: marketplace commission, payment processing, fulfillment fees, packing and postage you pay, and any removal or disposal fee to get the stock out of a 3PL or a marketplace warehouse. Leave out the costs you’d pay anyway, like rent, salaries and software. IAS 2 describes NRV in terms of the costs necessary to make the sale, not your overhead.
Fees are the input most people underestimate, because they think in list prices. A $19.00 marketplace sale with a 15% commission and $4.50 of fulfillment is $11.65 to you before you’ve paid for the product.
When there’s no price at all
Some stock has no market. A distributor I spoke with put it simply about one line: “selling it is not even a matter of price.” There was “no demand.” The expected selling price there is what a liquidator, an auction or scrap will pay, which may be close to nothing.
At my other company we stopped estimating this for old returns. They go to auction, mostly on eBay, and the auction price is the number. It’s a better answer than anything we’d have worked out at a desk, and it’s evidence nobody has to argue with.
Item by item, and evidence after the date
Under IFRS, work it out item by item, or by groups of similar items, so a product that’s worth more than it cost can’t cover one that’s worth less. US GAAP also allows applying the test to a major category or to total inventory when that most clearly reflects income, but item by item is the most common practice, and it’s the one that won’t hide a dead product behind a profitable range.
Events after year end count when they tell you about the year-end position. If you sold 40 of the units in the first week of January for less than you assumed, and nothing changed in between, that sale is better evidence than your December estimate. Update the number.
And it’s reassessed every year. Under IFRS and Canada’s ASPE, if the value recovers, part or all of the write-down comes back. Under US GAAP, once the year closes, the written-down cost stays (a write-down taken in an earlier quarter can recover within the same year). The year-end guide has the details.
How SKU.io works it out
SKU.io’s write-down works out NRV per product from a price source you choose (the product’s default selling price, a price list, the average price you actually got over a period you choose, or prices you enter or upload), minus your costs to sell as a percentage plus an amount per unit. Layers that cost less than their NRV are skipped. The price, the costs and the result are saved on each line, so the evidence goes with the write-down. For a blended channel price like the one above, upload it per product. The steps are in write down inventory at year end.
If you sell on one channel at under about $1M a year, a spreadsheet with these columns and a journal will do. If you sell the same products in three places, book a demo and bring the list of what didn’t sell this year.
The rest of the year end, from finding the stock to approvals and disclosure, is in inventory write-downs at year end.