Inventory Valuation: FIFO, Weighted Average, and Specific Identification — Same Stock, Different Book Value

Start with the arithmetic. The same stock sits on the same pallets, nobody touches a thing, and you change the inventory valuation method — the book value moves by 400 dollars. That is not a system bug, and nobody miscounted. What changes is which costs get assigned where, not the goods themselves.

Picture a 3PL warehouse in Ontario, California, sending a client its month-end inventory report. The client's goods arrived in three batches, each batch bought at a higher price than the last. The warehouse tracked every batch cleanly, quantities exact to the unit. Then the client's finance team called: this month-end inventory value is higher than the number they calculated themselves. The warehouse had not added a single unit, and finance had not botched a formula. The gap was the valuation method. Same stock, two methods, two numbers.

Now picture an e-commerce seller of small home goods, buying at prices that climb batch after batch. Peak season moves a chunk of stock, and switching the valuation method moves the reported gross margin with it. The goods are the same, the selling price is the same. All that changed is which batch's cost gets charged against the sale first.

Both scenes point to the same fact: valuation does not decide how much stock you hold. It decides how much cost each sold unit carries away, and how much value the unsold stock still carries on the books.

How Inventory Valuation Works: Three Methods, One Set of Numbers

Here is what each method actually does. FIFO, first in first out: the earliest batches are charged to cost first, and ending inventory is left holding the cost of the later batches. Weighted average: add up all inbound costs, divide by total quantity, and apply that one average unit price to both shipments and ending stock. Specific identification, the batch method: every batch keeps its own cost. Ship from a batch, and that batch's cost moves to cost of goods sold. Whatever batches remain at period end are what sits on the books.

Let me run all three on the same stock with one worked example. The figures below are illustrative data, used to demonstrate the calculation.

One item, three inbound batches: Batch A, 100 units at 10 dollars, 1,000 dollars total. Batch B, 100 units at 12 dollars, 1,200 dollars total. Batch C, 100 units at 14 dollars, 1,400 dollars total. Available: 300 units, 3,600 dollars. Shipped out during the period: 180 units. Ending stock: 120 units.

Every column adds back to 3,600 dollars, not a cent more or less. The only difference is how that total gets split between cost of goods sold and ending inventory. FIFO leaves ending inventory at 1,640 dollars; specific identification leaves it at 1,240 dollars — a 400-dollar gap. Cost of goods sold shows the same 400-dollar gap, in the opposite direction.

That table is the whole secret. The goods never moved, the quantities never changed, and the book value moved 400 dollars.

Why Inventory Valuation Moves Profit Without Moving a Single Pallet

Higher cost of goods sold means lower gross margin; higher ending inventory means higher book assets. The valuation method slides money between those two numbers, so reported profit moves while not one pallet moves in the warehouse. That is the counterintuitive part: most people think profit comes only from selling, but when purchase prices move, the valuation method rewrites profit too.

When purchase prices are rising, FIFO charges the cheaper early costs first, so cost of goods sold comes out low and ending inventory is priced at the expensive later costs, so it comes out high. Weighted average smooths the climb, landing both numbers in the middle. Specific identification depends on which batch actually shipped: ship the expensive batch, and cost of goods sold jumps.

When prices are falling, the conclusions flip. FIFO charges the expensive early costs first, cost of goods sold comes out high, ending inventory is priced at the cheaper later costs. The direction changes; the mechanism does not. The method decides how cost is split between "sold" and "still on hand."

Is that money wasted? Depends on the situation. If the warehouse's lot records are a mess, specific identification is not even on the table — finance may want batch-level costing, but the warehouse cannot show how much shipped from each batch, so the fallback is weighted average. Flip it around: if the lot records are immaculate and the company still runs everything through one blended average, it is throwing away the value of precise costing. No method is right or wrong in the abstract. What goes wrong is records that cannot support the method, or a method that does not fit the business.

Another common trap: confusing physical FIFO with accounting FIFO. Shipping oldest stock first, or FEFO for expiry-sensitive goods, is physical management — it prevents obsolescence and write-offs. FIFO on the books is cost allocation. The two do not have to match. The warehouse can physically ship a newer batch while the books still charge out the oldest cost first. Tying the two together is the root of many month-end arguments.

Choosing the Method Is Finance's Call — the Warehouse Owns the Lot Records

Which valuation method to use is a decision for finance and the company's tax advisers, not something the warehouse can settle on its own. What is permitted varies by jurisdiction, company type, and audit requirements — follow the applicable accounting standards and your tax adviser's advice. The warehouse cannot sign off on that choice. What it can sign off on is something else: whether its records are accurate.

Accurate records give finance a choice. Inaccurate records make every method produce the wrong answer. The warehouse owes three things: the quantity and cost source for every inbound batch, the quantity shipped from every batch, and the closing quantity of every batch. Unit costs come from purchasing and finance; the warehouse does not invent prices. Its job is quantities and batch identity: which batch shipped, how much, which batch remains, how much is left.

Here is the leverage point. Before every month-end close, reconcile three numbers: the per-batch closing quantity in the system, the per-batch quantity from the physical count, and the per-batch quantity on finance's books. When all three agree, valuation means something. When they do not, do not argue about methods yet — find where the quantity gap sits, in which batch and which step. Did receiving mix two batches? Did picking pull the wrong batch? Did a return go back to stock without its batch recorded? Recovering the quantity gap is worth far more than switching methods.

"Better-fitting" in that table is business logic only, not accounting advice. The final choice follows the applicable accounting standards and your tax adviser's advice.

So at the next month-end close, do not start by asking "which method should we use?" Start with the arithmetic: take the table above, plug in your own inbound prices and shipped quantity, and work out ending inventory and cost of goods sold under all three methods. The spread between the two numbers is the upper bound of what the valuation method does to your reports. If the spread is too small to argue about, put the energy back into quantity accuracy. If it is big enough to change a decision, hand the table to finance and let them decide under the applicable accounting standards and tax advice. The warehouse has exactly one job here: make every batch's quantity and identity stand up to inspection. Get that right, and no calculation will ever be money wasted.

By Lao Zhou, Logistics Cost Analyst