When you buy the same item at different prices over time, which cost do you use when you sell one? That choice — your inventory costing method — quietly changes your reported profit and the value of your stock. The two most common methods are FIFO and weighted average. Here's how each works and which to pick.
FIFO (first in, first out)
FIFO assumes the oldest stock is sold first. So your cost of goods sold uses the earliest prices, and the stock left on hand is valued at the most recent prices. It mirrors how most physical stock actually moves, especially perishable or dated goods.
Weighted average
Weighted average blends every purchase into a single average cost per unit, recalculated each time you buy. Every item sold uses that blended cost. It's simple, smooths out price swings, and suits items that are interchangeable.
A simple example
Say you buy 10 units at Rs 100, then 10 more at Rs 120, and sell 10. Under FIFO, those 10 sold cost Rs 100 each (cost of goods sold = Rs 1,000) and your remaining 10 are valued at Rs 120. Under weighted average, the blended cost is Rs 110, so the 10 sold cost Rs 1,100 and the remaining 10 are valued at Rs 110. Same purchases — different profit and different closing stock value.
How each affects your numbers
- When prices are rising, FIFO gives lower cost of goods sold and higher reported profit (and a higher-valued closing stock).
- Weighted average smooths the effect, so profit doesn't swing as much with price changes.
- Because profit differs, the method can affect your tax position too.
Which should you use?
- FIFO suits perishable or dated stock, and when you want stock valued close to current cost.
- Weighted average suits bulk, interchangeable items, and businesses that want simplicity and stable margins.
- Whatever you choose, stay consistent — switching methods often distorts comparisons.
- Check that your method is accepted for tax reporting in your jurisdiction.
How AmalERP handles it
AmalERP values inventory using weighted-average costing, recalculated automatically on every purchase — so your stock value and profit stay accurate in real time without any manual working. You can see it live in the inventory balances report, alongside quantities in, out and on hand.