FIFO vs weighted average costing: which inventory method fits Indian manufacturing?

The business scenario: how commodity swings created a ₹7.2 lakh tax surprise

Consider a precision plastic injection moulding business, Sigma Polymers, operating in Pune, Maharashtra. The company consumes roughly 30 metric tons of polypropylene (PP) granules per month. Over the past twelve months, global crude oil fluctuations caused virgin PP polymer prices to swing wildly between ₹88 per kg in April, ₹114 per kg in August, and ₹98 per kg in December.

Sigma's accounts team historically used simple manual spreadsheet spreadsheets to value closing stock at the latest invoice price received at year-end (₹112/kg). When their tax audit commenced under Section 44AB of the Income Tax Act, the chartered accountant rejected their inventory schedule immediately. By using the peak latest price rather than a recognized cost formula, Sigma had inflated their closing stock value by ₹7.2 lakh, which in turn artificially inflated their taxable net profit and produced an unexpected ₹1.8 lakh advance tax demand.

Selecting the correct valuation methodology—and enforcing it automatically inside your ERP—is not merely an academic accounting debate; it directly dictates your reported gross margins, your working capital financing limits, and your statutory tax liabilities.

The statutory framework: AS-2, Ind AS 2, and Indian tax law

In India, inventory valuation is governed by strict statutory accounting standards. Whether your business is a private limited manufacturing firm or an SME proprietorship, you must comply with Accounting Standard 2 (AS-2: Valuation of Inventories) or Indian Accounting Standard 2 (Ind AS 2):

• The Lower of Cost and Net Realizable Value (NRV): Inventories must be valued at the lower of historical cost and net realizable value (estimated selling price in the ordinary course of business less completion and selling costs).
• Permitted Cost Formulas: For non-interchangeable items (e.g. specialized capital machinery), specific identification is required. For interchangeable bulk items, the standard explicitly permits only two formulas: FIFO (First-In, First-Out) or Weighted Average Costing.
• LIFO Prohibition: The Last-In, First-Out (LIFO) formula is strictly prohibited by both AS-2 and the Indian Income Tax Department because it permits companies to manipulate taxable income during inflationary cycles.

Mathematical breakdown: FIFO vs Weighted Average in action

To see how these two methods diverge in practice, let us trace a typical month of raw material transactions for a manufacturing plant purchasing industrial resin:

Total available stock was 5,500 kg costing ₹6,20,000. Total production consumption was 4,300 kg, leaving 1,200 kg of closing inventory. Notice how the two methods allocate this value:

In an inflationary environment where raw material prices rise from ₹100 to ₹120, FIFO assigns the cheaper early costs to production issues and leaves the expensive recent costs in closing inventory. This results in a higher balance sheet asset value and higher taxable profit. Weighted Average Costing blends the layers, dampening the spike.

Which method should your business choose?

The choice between FIFO and Weighted Average depends on your industry, physical handling, and raw material volatility:

Choose FIFO if:

• You manufacture food, pharmaceuticals, chemicals, or dairy products where physical stock strictly moves under FEFO (First-Expiry, First-Out) or FIFO to prevent spoilage.
• Your products have distinct batch numbers where material traceability from supplier to finished product must be maintained.
• You want closing stock on your balance sheet to closely reflect current replacement market values for bank working-capital drawing power.

Choose Weighted Average Costing (WAC) if:

• You handle bulk commodities that physically mix together in silos, tanks, or heaps (e.g. grain, cement, sand, vegetable oils, bulk chemicals).
• Your raw material prices fluctuate violently on a daily or weekly basis (e.g. scrap metal, cotton, raw polymers), and you want to prevent wild monthly swings in reported product cost.
• Your factory operators find it difficult or unnecessary to segregate identical raw materials by specific purchase lot.

The catastrophic impact of negative inventory on valuation

One of the most destructive operational issues in ERP systems is negative inventory—issuing goods in the software before the corresponding goods receipt note has been entered. When stock goes below zero in the system, both FIFO and Weighted Average algorithms completely break down:

Step-by-step process: setting up automated valuation in Naffo

1. 01Define valuation method per inventory category

   In organization settings, choose whether standard inventory lines calculate under Moving Weighted Average or FIFO. Batch-tracked items automatically preserve exact lot cost layers.

2. 02Enforce negative inventory blocking

   Activate strict physical stock controls in the stock policy engine. Prevent sales dispatches or production issues from posting if available warehouse location stock is insufficient.

3. 03Capture landed costs in purchase receipts

   Include freight, transit insurance, customs duties, and unloading charges directly into the Goods Receipt Note to establish true landed cost layers under AS-2 guidelines.

4. 04Conduct periodic physical count reconciliations

   Conduct rolling cycle counts or monthly stock verifications. Record variances through reason-coded adjustment vouchers that automatically adjust inventory valuation reserves.

How Naffo maintains real-time valuation integrity

Naffo incorporates an immutable, single-writer Stock Ledger (StockLedger) that records every physical movement with its associated unit cost and balance layer. Unlike systems that calculate valuation as a batch report at month-end, Naffo updates moving average and FIFO cost layers instantaneously upon every transaction.

When raw materials are issued to a manufacturing work order, Naffo automatically consumes the appropriate FIFO lot or applies the current location-specific weighted average rate. The resulting double-entry accounting voucher automatically debits Work-in-Progress and credits Raw Material Inventory, ensuring your financial balance sheet is perpetually synchronized with physical warehouse shelves.