Zoho Inventory Valuation: FIFO vs Weighted Average Cost Explained
The valuation method decides what your cost of goods sold and closing stock look like every month. In Zoho Inventory it is chosen per item at creation, so it is worth deciding before you import your catalogue.
Related service: Zoho Inventory Implementation →Every time you sell a unit, your system has to decide what that unit cost you. When purchase prices are stable it barely matters. When they move, because of supplier increases, currency swings or freight, the method you choose changes your reported gross margin, your stock value on the balance sheet and the item-level profitability reports your team relies on.
Zoho Inventory supports two methods: FIFO (First In, First Out) and Weighted Average Costing (WAC), which Zoho describes as a moving average. Here is how they differ, how Zoho applies them, and how we help clients choose.
How the two methods work
FIFO assumes the oldest stock is sold first. Each sale consumes the earliest purchase lots at their actual cost until that lot runs out, then moves to the next lot. Closing stock is therefore valued at your most recent purchase prices.
WAC divides the total value of stock on hand by the total quantity on hand and uses that average for each sale. In Zoho Inventory the average is recalculated whenever new stock arrives at a different cost. One detail from Zoho's documentation matters for low-stock items: when quantity on hand reaches zero, the previous average is discarded and the next purchase sets a fresh WAC.
A worked example
Say you buy 100 units at ₹200, then another 100 units at ₹260 after a supplier price increase. You then sell 120 units at ₹350 each, for revenue of ₹42,000.
| Figure | FIFO | Weighted Average |
|---|---|---|
| Cost per unit used | 100 at ₹200, then 20 at ₹260 | ₹230 average (₹46,000 / 200 units) |
| Cost of goods sold | ₹25,200 | ₹27,600 |
| Gross profit | ₹16,800 | ₹14,400 |
| Closing stock (80 units) | ₹20,800 (at ₹260) | ₹18,400 (at ₹230) |
| Total cost accounted for | ₹46,000 | ₹46,000 |
Neither method creates or loses money. Total cost is the same; the methods only decide how much of it lands in this period's COGS versus closing stock. With rising prices, FIFO shows higher profit now and a higher stock value. WAC smooths the swing and reports a more conservative margin.
How Zoho Inventory applies the method
- The method is stored per item. It is assigned when the item, variant or composite item is created
- You can set an organisation-wide default under Settings, then Items, Default Inventory Valuation Method. Zoho added this in its April and May 2026 updates
- The default is also used when items are imported or created through the API without a valuation method specified
- Item-level profit margin estimates use the item's method, for items with inventory tracking enabled
- Zoho's FIFO option under auto batch assignment is a separate setting: it decides which batch ships first, not how cost is calculated
Changing the method on an item that already has transactions is not a simple toggle, and users on Zoho's community forum report existing items defaulting to FIFO when the setting was introduced. Confirm the current behaviour with Zoho support before you rely on changing it later, and decide before importing your catalogue.
Backdated entries and negative stock
Both methods are sensitive to transaction order. If a purchase bill is entered with an earlier date than a sale already recorded, Zoho recalculates cost for the later transactions, so last month's COGS can move. If you sell before recording the purchase, stock goes negative and the sale is costed once the purchase arrives. Teams that enter bills late should agree a cut-off routine with their accountant, otherwise reports already shared with management will change.
Which method should you choose?
In India, AS 2 and Ind AS 2 permit FIFO or weighted average cost for most inventories, so both are acceptable. Discuss the choice with your chartered accountant and keep it consistent year to year. As a starting point:
- Choose FIFO for perishables, batch or expiry-tracked goods, and businesses where item margins must reflect actual lot costs
- Choose WAC for commodities, raw materials and high-volume items bought repeatedly at fluctuating prices, where smoothing helps pricing decisions
- Use one method consistently unless there is a clear reason; mixed methods make item margin reports harder to compare
- If you import, enable landed cost tracking as well, so freight and duty flow into whichever cost method you use
Where Zoho Books comes in
When Zoho Inventory is connected to Zoho Books, the cost of goods sold and inventory asset values flow into your ledger. That means the method you set in Inventory directly shapes your profit and loss statement and balance sheet. Run the inventory valuation report alongside the Books stock account at each month-end to make sure they agree.
Frequently asked questions
Does Zoho Inventory support FIFO?
Yes. Zoho Inventory supports FIFO and Weighted Average Costing. The method is assigned per item when it is created, and you can set a default for new items under Settings, then Items, Default Inventory Valuation Method.
Can I use different valuation methods for different items?
Yes. Because the method is stored at item level, you can value perishables on FIFO and bulk raw materials on WAC in the same organisation. Agree the policy with your accountant and apply it consistently.
Is LIFO available in Zoho Inventory?
No. Zoho Inventory offers FIFO and Weighted Average Costing. LIFO is not permitted under AS 2 or Ind AS 2 in India, or under IFRS, so most businesses we work with would not use it anyway.
Want a clear quote for your setup?
Tell us your goals and we'll map the fastest, most cost-effective path on Zoho — with a free consultation and no obligation.