Skip to content

Stock

FIFO vs weighted average: which stock valuation to use?

FIFO values stock as if the oldest units are sold first, so closing stock carries the latest purchase prices; weighted average blends all purchases into one rate per unit. When prices are rising, FIFO shows a lower cost of goods sold and a higher profit and closing stock. Both are allowed under AS 2 and Ind AS 2; LIFO is not.

Same purchases, two answers

A shop buys 100 units at ₹40, then 100 more at ₹50, and sells 120 units at ₹60 each, for sales of ₹7,200.

₹400 gap
Cost, profit and closing stock under FIFO and weighted average
 FIFOWeighted average
Rate used for the 120 units sold100 at ₹40, then 20 at ₹50₹45 each
Cost of goods sold₹5,000₹5,400
Gross profit on ₹7,200 of sales₹2,200₹1,800
Closing stock of 80 units₹4,000, at ₹50₹3,600, at ₹45

How FIFO and weighted average differ

Neither method changes how many units you have. They change what each unit is worth in the books, and so the profit.

2 methods
FIFO compared with weighted average
 FIFOWeighted average
The ideaOldest units leave firstEvery unit costs the average of all purchases
When prices riseLower cost, higher profit and closing stockCost and profit sit between old and new prices
Work involvedEach purchase is a separate layer to trackOne rate per item, recomputed as stock comes in
SuitsLots bought at changing prices: cloth rolls, oil tins, wire coilsIdentical bulk items: rice, cement, screws
Allowed in IndiaYes, under AS 2, Ind AS 2 and ICDS IIYes, under AS 2, Ind AS 2 and ICDS II

Weighted average comes in two forms

The example above has every purchase before every sale, so both forms agree. When a sale falls between two purchases, they do not.

Moving average
  • Periodic weighted average

    One rate for the whole period: (opening value + purchases) ÷ (opening units + units bought). Simple, but the rate is only known at period end.

  • Moving average

    The rate is recomputed after every receipt. Sell 60 units before the second purchase and they cost ₹40 each; the rest are costed at the new blend.

  • Batch-wise cost

    Each lot keeps its own cost. The usual answer for medicines and packaged food, where every batch has its own expiry date anyway.

  • Pick one and keep it

    AS 2 expects the same cost formula to be used consistently. A change needs a reason and is disclosed in the accounts.

How Dhaaga values stock

The valuation method is chosen for each item, because a shop that sells loose grain and branded medicines rarely wants one method for both.

4 methods
  • Chosen per item

    FIFO, moving average, a standard rate, or batch-wise cost. An item with no method set is valued by FIFO.

  • Issues costed from layers

    Under FIFO each receipt is a layer, and a sale or issue is costed from the oldest layers first.

  • Freight added later

    A landed cost voucher entered after the goods have arrived re-costs the issues already taken from that receipt.

  • Value on the item list

    The item list shows each item's stock value worked out under that item's own method, never a shop-wide one.

Questions people ask first.

6

No. AS 2 and Ind AS 2 allow FIFO, weighted average and, for goods that are not interchangeable, specific identification. LIFO is not permitted.

When purchase prices are rising, FIFO shows more profit, because the older and cheaper units are charged to sales. When prices are falling, weighted average shows more.

No. GST is charged on the sale value on the invoice. The method changes only the cost and the profit in your books.

It changes closing stock and so the profit, which is what income tax is charged on. Income-tax rules for inventory (ICDS II) also allow FIFO or weighted average.

Only for a good reason, such as a more appropriate presentation, and the change and its effect must be disclosed. Switching every year to manage profit is not acceptable.

Batch-wise cost or FIFO, because each lot has its own expiry and is sold in expiry order. Weighted average suits items that never expire and are all alike.

The fastest honest test

Put one real day through it.

Not a sandbox with sample data — your own bills, your own items, your own customers. By evening you will know whether this runs your business.

A full business day flowing through Dhaaga from opening tasks to balanced books