Inventory Valuation Methods (FIFO, LIFO, Weighted Average) in ERP

Ask two accountants in the same Indian SMB what the closing stock is worth, and if the answer is "let me check the sheet," the business already has a problem. For most manufacturers and traders, inventory is the single largest number on the balance sheet — often bigger than cash, receivables or fixed assets — yet it is frequently the least trusted figure in the books. The reason is rarely that nobody counted the stock. It is that the price at which each item is carried was decided inconsistently, item by item, month by month, by whoever happened to be updating the workbook.

That price is the whole game. The same 3,000 kilograms of brass in the godown can be worth noticeably different rupee amounts depending on which purchase rate you attach to it — and that single choice ripples straight into cost of goods sold, gross margin, reported profit, taxable income and the stock statement your banker reads before renewing a cash-credit limit. Get the method right and applied consistently, and the number defends itself. Get it ad hoc, and every audit and margin discussion turns into an argument.

This is exactly the kind of rule-bound, high-volume, high-stakes work an ERP is built to absorb. When valuation is computed from the same goods-receipt and issue documents that already run the stores, the method is applied the same way to every transaction, closing stock at any date becomes a report rather than a reconstruction, and the inventory figure in the books always agrees with the stock on the floor. This article walks through the three methods every Indian business should understand — FIFO, LIFO and Weighted Average — why one is off the table under Indian standards, how the choice changes your numbers in rupees, and how inventory and accounting stay in lock-step inside an ERP.

Why Inventory Valuation Trips Up Manual Systems

Inventory valuation is hard not because any single formula is complex — the arithmetic is school-level — but because it must be applied correctly to a very high volume of movements, each caught at the moment it happens, and rolled up into a figure that has to be internally consistent across the whole business. Every goods receipt changes the average cost. Every issue or sale has to be costed at the right rate. Every branch, item and batch has its own running valuation. Miss the consistency anywhere and the closing stock number quietly drifts from reality.

In a spreadsheet world this breaks predictably. One clerk values a fast-moving item at the latest purchase rate, another at last year's standard cost, a third at whatever the supplier quoted last week. Prices of metals, polymers and chemicals move sharply, so the "cost" attached to identical stock swings with the mood of whoever entered it. At month-end, book and physical stock refuse to reconcile, and the gap is plugged with an adjustment nobody can explain. By the time the auditor asks "which method, applied consistently?", the honest answer is "several, and no" — exactly what turns a routine audit into a long one.

The Three Methods, Explained for an Indian SMB

Valuation feels intimidating because textbooks list several "cost formulas", but a manufacturing or trading business really only needs to understand three ideas — and in practice, apply one of two. The distinction matters most when input prices are moving, which, for anyone buying metals, plastics, yarn or chemicals, is essentially always.

FIFO — First In, First Out

FIFO assumes the oldest stock is used or sold first, so cost of goods sold is drawn from the earliest purchase prices while closing stock is valued at the most recent. In a rising-price environment — the norm for most raw materials — FIFO produces a lower cost of goods sold, a higher reported profit and a higher closing stock value, because the newest, dearest purchases are the ones left in stock. It also mirrors how most stores actually operate: you genuinely want to consume the oldest material first to avoid ageing, rust or expiry. FIFO is fully permitted in India and is the natural choice where batch or expiry discipline matters.

Weighted Average Cost

Weighted Average blends every unit of stock into a single rate — total value on hand divided by total quantity on hand — recalculated on each receipt and applied to both what is issued and what remains. It smooths price volatility, so a single expensive purchase does not spike your costing, and it is simpler to run at scale because you carry one rate per item rather than a stack of dated layers. In practice it is implemented as a moving (perpetual) weighted average that updates on every receipt, which is what most Indian SMBs on an ERP end up using. It is fully permitted and is the pragmatic default for high-volume, fungible stock like fasteners, granules or standard sections.

LIFO — Last In, First Out (and why it is off the table in India)

LIFO assumes the newest stock moves first, so cost of goods sold reflects the latest prices and closing stock sits at old, often stale, prices. It is worth understanding because it appears in textbooks and some legacy overseas systems — but here is the accuracy point every Indian finance team must internalise: LIFO is not permitted for inventory valuation in India. Both AS-2 (Valuation of Inventories) and Ind AS 2 allow only FIFO or Weighted Average as cost formulas; LIFO was withdrawn, mirroring the international position under IAS 2. A business preparing statutory statements in India simply cannot value inventory on LIFO. A properly configured ERP should therefore not even offer it for statutory books — and ApicalERP defaults to a moving Weighted Average or FIFO precisely so the method in the system is always one the auditor will accept.

The Capabilities That Make Valuation Effortless

The difference between a valuation headache and a non-event comes down to a handful of system capabilities — each removing a specific manual step where inconsistency creeps in: the wrong rate on an issue, the untracked freight, the branch that values stock differently, the slow-moving item still at full cost.

How the Method Actually Changes Your Numbers

Abstract definitions rarely land; rupees do. Take a single fast-moving raw material — brass rod — and one costing period, and watch how the method alone reshuffles cost of goods sold, profit and closing stock. Suppose the stock movements for the period are:

• Opening stock: 2,000 kg at ₹700/kg = ₹14,00,000
• Purchase 1: 3,000 kg at ₹760/kg = ₹22,80,000
• Purchase 2: 5,000 kg at ₹820/kg = ₹41,00,000
• Total available: 10,000 kg valued at ₹77,80,000
• Consumed / sold in the period: 7,000 kg  •  Closing stock: 3,000 kg

Prices are clearly rising — ₹700, then ₹760, then ₹820. Now split that ₹77,80,000 between what was consumed and what remains, under each method.

Under FIFO, the 7,000 kg consumed is drawn from the oldest layers first: 2,000 kg at ₹700 (₹14,00,000) + 3,000 kg at ₹760 (₹22,80,000) + 2,000 kg at ₹820 (₹16,40,000) = ₹53,20,000 cost of goods sold. The 3,000 kg left is the newest stock, valued at ₹820 = ₹24,60,000 closing stock.

Under Weighted Average, the average rate is ₹77,80,000 ÷ 10,000 = ₹778/kg. Consumption of 7,000 kg costs 7,000 × ₹778 = ₹54,46,000 cost of goods sold, and the 3,000 kg closing stock is valued at 3,000 × ₹778 = ₹23,34,000.

Under LIFO — shown only to complete the picture, since it is not permitted in India — the newest stock would be consumed first, pushing cost of goods sold to roughly ₹55,00,000 and leaving closing stock at the oldest rates near ₹22,80,000.

Look at what just happened. Same physical stock, same purchases, same 7,000 kg used — yet the method alone moved cost of goods sold by ₹1,26,000 between FIFO and Weighted Average (₹53,20,000 versus ₹54,46,000), and moved closing stock by exactly the same ₹1,26,000 the other way (₹24,60,000 versus ₹23,34,000). In a rising market, FIFO reports the lower cost, higher profit and fatter balance-sheet stock; Weighted Average sits calmly in between. Multiply that across dozens of materials and twelve months, and "which method, applied how consistently" becomes a real swing in reported profit, taxable income and the stock value your bank lends against. Over the whole life of the stock the total cost charged is identical — the method only decides which period bears which cost — but timing is exactly what profit and tax are measured on.

The Indian SMB Valuation Pain Points to Plan Around

The ways inventory valuation goes wrong are remarkably consistent from one business to the next. Naming each one turns an audit-time surprise into a routine the system simply handles.

"Every branch valued the same item differently"

The classic multi-location case. The Rajkot godown values a component at the latest purchase rate, the Ahmedabad depot at an old standard cost, and a transfer between them books phantom profit out of nothing. Consolidated stock becomes meaningless because it adds up figures on different bases. The fix is structural: one method, enforced across every location, so transfers move at cost and group closing stock is a true sum.

"Freight and landed cost never made it into valuation"

Material is booked at the supplier's invoice rate while the freight, loading and handling that genuinely cost money to bring it in land in a separate expense head. Stock is then carried below its real cost, gross margin looks better than it is, and the numbers stop telling a clean story. Apportioning landed cost into the item at receipt keeps valuation honest and margin real.

"We switched methods midstream and could not explain it"

Consistency is the heart of AS-2 and Ind AS 2. When the costing basis quietly changes — a new person, a new spreadsheet, a new year with a different habit — period-to-period comparison breaks and the auditor has every reason to question the profit. A system that locks the method as policy, treating any change as a controlled, disclosed event, removes the most common valuation audit query.

"Slow-moving stock sat at full cost for years"

Obsolete dies, superseded components and dead stock keep sitting at original cost because nobody wants to book the write-down. Inventory — and therefore profit — is overstated, and the day reality is recognised, it lands as one ugly hit. Carrying stock at the lower of cost and net realisable value, with ageing analysis flagging candidates, spreads that discipline into the normal course rather than a year-end shock.

"Book stock and physical stock never reconciled"

When valuation lives outside the transaction system, the value in the books drifts from the stock on the floor, and the month-end gap gets plugged with an adjustment no one can trace. A perpetual ledger that costs every movement in real time keeps book and physical stock in step, so a count becomes a verification rather than a reconciliation nightmare — the same discipline good warehouse management depends on.

Benefits of Running Valuation Inside the ERP

Choosing a Method: A Decision Guide

Since India rules LIFO out, the real decision is FIFO versus Weighted Average — and for most SMBs it is less agonising than it sounds. A few practical questions settle it:

• Does physical flow or expiry matter? If material must be consumed oldest-first — because it ages, rusts, expires or is batch-controlled — FIFO both values and disciplines the stock the way you already run it. Where items are fungible — granules, fasteners, standard sections — physical order is irrelevant and Weighted Average is simpler and just as valid.
• How volatile are your input prices? When metal or commodity prices whipsaw, Weighted Average smooths the costing so a single expensive lot does not distort a month's margin; if you want the balance sheet to reflect the most recent replacement cost, FIFO carries closing stock at the latest prices.
• How high is your transaction volume? At very high volumes a moving Weighted Average is lighter to run — one rate per item rather than a stack of dated FIFO layers to track and unwind. Either way, once it is in the ERP the arithmetic is automatic.
• Above all, consistency. Whichever you choose, apply it period after period — the explicit requirement of AS-2 and Ind AS 2, and the thing auditors probe first. Change it only for a genuine reason, as a controlled, disclosed event — never let it drift silently between people or years.

Valuation Best Practices for Indian SMBs

The businesses that never argue about their stock value follow the same handful of disciplines — deciding the method once, capturing true cost, and letting the system apply it the same way to every movement.

1. Fix the method as policy, not habit

• Choose FIFO or moving Weighted Average deliberately, document it, and configure it in the system so the choice is enforced rather than left to whoever enters a voucher
• Keep LIFO out of the statutory books entirely — it is not acceptable under AS-2 or Ind AS 2, and offering it only invites a compliance problem

2. Capture true landed cost at receipt

• Apportion freight, loading, handling and other direct charges into the item's cost as it enters stock, so valuation reflects what the material actually cost to bring in
• Reflect rate revisions, debit notes and discounts in the running valuation so the average or FIFO layer stays accurate

3. Run a perpetual, item-wise ledger

• Cost every issue, transfer and sale at the method's live rate so cost of goods sold is built continuously, not estimated at month-end
• Keep valuation per item and per location so multi-branch stock consolidates on a single, comparable basis

4. Apply lower-of-cost-or-NRV routinely

• Use ageing and slow-moving reports to identify stock whose net realisable value has fallen below cost, and write it down in the normal course rather than as a discretionary year-end adjustment, so profit is never quietly overstated

5. Reconcile and keep the trail audit-ready

• Run periodic physical and cycle counts against book stock so differences are caught while small, and tie closing stock back to the trial balance every period so the balance-sheet figure is verified, not assumed
• Link every valuation to its source receipt, issue or write-down and preserve the method history, so an auditor's or banker's question is answered from the system and comparability can always be demonstrated

Real-World Success Story

Frequently Asked Questions

What are the main inventory valuation methods?

The three classic methods are FIFO (First In, First Out), LIFO (Last In, First Out) and Weighted Average Cost. FIFO assumes the oldest stock is consumed first, so cost of goods sold reflects the earliest prices and closing stock the most recent. LIFO assumes the newest stock moves first — the reverse. Weighted Average blends every purchase into one rate applied to both consumption and closing stock. In an ERP the choice is set once and applied consistently to every issue, sale and closing-stock valuation, so the books, the profit and the balance sheet all tie back to the same costing logic.

Is LIFO allowed in India?

No. LIFO is not permitted for inventory valuation in India. Both AS-2 (Valuation of Inventories) under the older standards and Ind AS 2 under the converged standards allow only FIFO or Weighted Average as cost formulas; LIFO was withdrawn, mirroring the international position under IAS 2. An Indian company preparing statutory financial statements must value inventory using FIFO or Weighted Average. A well-configured ERP simply should not offer LIFO as a live option for statutory books — ApicalERP defaults to a moving Weighted Average or FIFO.

How does the valuation method affect profit and tax?

The method decides how the total cost of goods available for sale is split between what was consumed (cost of goods sold, which reduces profit) and what remains (closing stock, on the balance sheet). When input prices rise, FIFO charges older, cheaper costs to consumption — lower cost of goods sold, higher profit, higher closing stock — while Weighted Average smooths and lands in between. Because profit feeds taxable income, the method influences the tax outcome in a given period, though over the full life of the stock the total cost charged is the same; the difference is timing. The key requirement in India is consistency: the same method, every period.

Does the inventory valuation method affect GST?

GST is charged on the transaction value of a supply — the actual selling price — not on the accounting cost at which stock is carried, so the method does not directly change the GST you charge on a sale or the input tax credit on a purchase. Where valuation matters for indirect tax is the accuracy of the stock records that support GST positions: reconciling physical with book stock, valuing branch transfers, handling returns and write-offs, and supporting the stock statements banks and auditors expect. A clean, consistently valued stock ledger makes those reconciliations straightforward, even though the valuation rate itself is not what GST is levied on.

How does ApicalERP handle inventory valuation?

ApicalERP maintains a perpetual, item-wise stock ledger in which every receipt updates the valuation and every issue or sale is costed by the chosen method in real time — most commonly a moving Weighted Average, with FIFO available where preferred. Because valuation is computed from the same goods-receipt and issue documents that run the stores and the accounts, the stock value in inventory always agrees with the inventory figure in the books, cost of goods sold flows straight into profitability, and closing stock at any date is a report rather than a month-end exercise. The method is configured once, applied consistently across every location and item, with a full audit trail to source.

Conclusion

Inventory valuation is not conceptually hard — the arithmetic of FIFO and Weighted Average is school-level. What makes it the least-trusted number in many Indian SMBs is that it must be applied consistently across a huge volume of movements, and in a spreadsheet world it never is. The same stock ends up carried at several prices by several people, freight vanishes from cost, dead stock lingers at full value, and the largest figure on the balance sheet becomes the one everyone quietly argues about at audit and at the bank.

The lifecycle — choose the method, capture true landed cost, keep a perpetual valuation, cost every issue, value closing stock any day, apply net realisable value, then reconcile to the books — is not complicated, but every skipped step has a cost: distorted margin, overstated profit, a restated write-down, a long audit. Doing each step in the system that already records the receipt and the issue turns valuation into a by-product of running the stores well — and keeps you on the right side of Indian standards, with FIFO or Weighted Average applied consistently and LIFO off the table where it belongs. Alongside disciplined warehouse management and clean financial accounting, a consistent valuation basis is what makes stock a number you can defend. ApicalERP values every item on one method — landed cost in, live cost of goods sold out, NRV discipline built in, and closing stock that ties to the rupee. See the full ApicalERP feature set and the manufacturing solution, then bring us your stock register — we will show you what it looks like when the value of your inventory stops being a matter of opinion.