⬟ What Inventory Valuation Methods Are and What AS 2 Requires :
Inventory valuation is the process of assigning a cost to inventory held by a business. For a manufacturing MSME, this includes raw materials, work-in-progress, and finished goods. Under AS 2 (Valuation of Inventories), inventories must be valued at the lower of cost and net realisable value (NRV). NRV is the estimated selling price less costs of completion and selling. Cost of inventory includes the purchase price, non-refundable duties and taxes, inward freight, and other directly attributable costs. Trade discounts and recoverable GST input tax credit are excluded. AS 2 permits two cost flow assumptions when identical items are purchased at different prices. FIFO (First In, First Out): assumes oldest inventory is consumed first. Cost of goods sold reflects the earliest purchases; closing stock reflects the most recent purchases. Weighted Average Cost: calculates a blended average cost per unit across all purchases, applying that average to both cost of goods sold and closing inventory. In Tally, this is the moving weighted average, updated after each purchase. LIFO (Last In, First Out) is not permitted under AS 2 or Ind AS 2.
A small MSME plastic components manufacturer in Pune, Maharashtra buys polypropylene resin in three batches: Batch 1: 1,000 kg at Rs. 85/kg = Rs. 85,000 Batch 2: 1,000 kg at Rs. 92/kg = Rs. 92,000 Batch 3: 1,000 kg at Rs. 96/kg = Rs. 96,000 Total: 3,000 kg, total cost Rs. 273,000. During the quarter, 2,200 kg is consumed. Under FIFO: cost of goods consumed = Rs. 85,000 + Rs. 92,000 + (200 kg x Rs. 96) = Rs. 196,200. Closing stock = 800 kg at Rs. 96/kg = Rs. 76,800. Under Weighted Average: average cost = Rs. 273,000 / 3,000 = Rs. 91/kg. Cost consumed = 2,200 x Rs. 91 = Rs. 200,200. Closing stock = 800 x Rs. 91 = Rs. 72,800. FIFO produces lower cost of goods consumed and higher closing stock when prices are rising, meaning higher gross profit in a rising price environment.
⬟ Why the Inventory Valuation Method Choice Has Real Financial Consequences :
Choosing and consistently applying the correct method produces three specific benefits. The first is accurate gross margin measurement. An MSME using FIFO in a rising price environment reports a higher gross margin than an equivalent MSME using weighted average, not because it is more efficient but because FIFO matches older, lower costs against current selling prices. Understanding this allows the owner to distinguish a real margin improvement from a valuation method effect. The second is correct balance sheet inventory valuation. Closing stock is used by banks to calculate drawing power against working capital limits (typically 75-80% of stock value). The value must be defensible: if actual NRV is below FIFO cost, the lower NRV must be used. AS 2 compliance ensures the inventory is neither over-valued (which inflates drawing power) nor under-valued (which reduces available working capital). The third is consistency across periods. AS 2 requires the same cost formula to be applied consistently for the same class of inventory from period to period. Switching between methods shifts reported profits without any change in underlying business performance and is a compliance failure.
A small MSME steel fabricator in Ludhiana, Punjab in a period of rising steel prices was using the weighted average method. The CA noted that FIFO would produce a higher closing stock value and lower cost of goods sold in a rising price environment, increasing reported gross profit. But the CA also noted this would reverse when prices fell, with the expensive FIFO closing stock flowing through to cost of goods sold. The owner retained weighted average for its simpler implementation in Tally and more stable margins across periods. A medium MSME pharmaceutical manufacturer in Hyderabad, Telangana applied FIFO for active pharmaceutical ingredients (which have expiry dates and physically must be consumed in the order received) and weighted average for packaging materials (which are interchangeable with no expiry constraint). This mixed approach is permitted under AS 2 for different inventory classes with different natures, provided each class is consistently valued using the same method.
For small and medium manufacturing MSME owners, the inventory valuation method choice affects the gross margin, closing stock balance sheet value, working capital drawing power, and income tax liability. For CAs preparing manufacturing MSME accounts, confirming the method and applying it consistently is a core task. For banks assessing working capital limits, the closing stock figure used to calculate drawing power must reflect a defensible valuation at the lower of cost and NRV. An overstated closing stock inflates drawing power without improving the actual security position.
⬟ How Inventory Valuation Is Currently Handled in MSME Manufacturing Accounts :
Most manufacturing MSMEs use weighted average by default since it is the standard Tally configuration, often without a deliberate decision. A significant number of small MSMEs value closing stock at a single uniform rate, such as the most recent purchase price or a standard cost set at the start of the year, without formally adopting either method. This does not comply with AS 2 and can produce valuations that depart materially from the correct cost. Under-valuing closing stock to reduce reported profit and tax liability is a known practice in some segments. This is both a compliance failure and a practical risk: it reduces the working capital limit drawing power and may attract income tax scrutiny when the undervaluation reverses in a subsequent year.
⬟ How Inventory Accounting Is Evolving for Manufacturing MSMEs :
ERP and accounting software integration is improving inventory valuation reliability in manufacturing MSMEs. Tally Prime's batch tracking features allow stock movements to be recorded against specific purchase batches, supporting accurate FIFO or weighted average calculation without manual adjustment. GST e-way bill and invoice matching requirements create indirect discipline on inventory tracking: goods movements must be documented, which creates a paper trail supporting accurate valuation. The growth of invoice discounting platforms and MSME listing initiatives is creating additional pressure for manufacturing MSMEs to maintain credible, auditable inventory records.
⬟ How FIFO and Weighted Average Work Differently When Prices Change :
In a rising price environment (each successive purchase costs more): FIFO uses older, cheaper inventory first for cost of goods sold. Closing stock retains the most recent, higher-priced purchases. Result: lower COGS, higher gross profit, higher closing stock. Weighted average blends all purchase prices. COGS and closing stock both reflect the blended rate. Result: COGS and closing stock sit between the FIFO cost and current purchase price. In a falling price environment (each successive purchase costs less): FIFO uses older, more expensive inventory first. Result: higher COGS, lower gross profit, lower closing stock. Weighted average again blends all prices, dampening the effect. In a stable price environment, both methods produce the same result. The key implication: FIFO amplifies the effect of price changes on reported profit. Weighted average dampens fluctuations and produces a more stable margin over time.
● Step-by-Step Process
Identify the inventory categories held by the business: raw materials, work-in-progress, finished goods, packing materials, consumables. For each category, decide whether FIFO or weighted average fits the physical nature (does it have an expiry date?) and price volatility of purchases. Confirm the method currently in use in Tally. In Tally Prime, check the Costing Method field for each stock item under Inventory Info. Confirm this matches the method stated in the accounting policies note. At the year end, value closing stock at the lower of cost and NRV. For each significant item, compare the carrying cost to the expected selling price less selling costs. Write down any item where NRV is below cost and document the calculation. Reconcile the physical stock count to the Tally stock balance. Any unreconciled difference must be investigated before the accounts are finalised. Confirm the inventory valuation policy in the accounting policies note matches the method actually applied in Tally and in the stock valuation workings.
● Tools & Resources
Tally Prime supports both weighted average (moving average) and FIFO costing at the stock item level. To set the method: go to Inventory Info, select Stock Items, create or alter the stock item, and set the Costing Method field to Average Cost or FIFO. Different methods can be set for different stock item categories. ICAI's AS 2 guidance is at icai.org. A simple Excel template tracking opening balance, purchases, issues, and closing balance by item code is sufficient for physical stock reconciliation in most manufacturing MSMEs.
● Common Mistakes
Valuing closing stock at a single uniform rate set at the start of the year without updating for actual purchase prices is the most common error. A standard cost set in April may differ significantly from actual purchase costs by March, producing a closing stock value that overstates or understates inventory on the balance sheet. Not writing down inventory to NRV when market selling prices fall below the carrying cost is the second mistake. AS 2 requires inventory to be valued at the lower of cost and NRV. Carrying inventory at cost when NRV is lower overstates the balance sheet and understates cost of goods sold for the period. Changing the inventory valuation method between years without disclosing the change and its effect on profit is the third mistake. Switching between FIFO and weighted average across years without disclosure shifts reported profits without any change in business performance and is a compliance failure under AS 2.
● Challenges and Limitations
FIFO is operationally demanding in a manual or partially automated environment. It requires tracking which physical batch each consumed unit came from, straightforward for large batches but complex for businesses with frequent small purchases at varying prices. Weighted average is simpler to implement, which is why it is the default in most MSME accounting software. For manufacturing businesses with significant work-in-progress, WIP cost must include raw material cost, direct labour, and absorbed manufacturing overhead. Calculating WIP cost is more complex than raw material cost, and errors in WIP valuation can have a larger effect on reported profit. Simplifying WIP valuation using standard costs introduces assumptions that require annual review.
● Examples & Scenarios
A small MSME biscuit manufacturer in Nashik, Maharashtra uses wheat flour, sugar, and packaging materials as primary inputs. Wheat flour and sugar prices fluctuate monthly. The CA implemented FIFO for wheat flour and sugar because they are perishable and physically consumed in the order received. For the financial year, wheat flour prices ranged from Rs. 28/kg to Rs. 38/kg. The FIFO closing stock reflected the most recent March purchases at Rs. 36/kg. Under weighted average it would have been Rs. 32/kg (the blended annual average). The FIFO closing stock was Rs. 4.8 lakh higher, directly increasing the working capital limit drawing power by approximately Rs. 3.6 lakh. A medium MSME auto components manufacturer in Rajkot, Gujarat bought steel in large periodic lots for components manufactured to customer specifications. All steel of the same grade was physically interchangeable. The CA used weighted average: FIFO would have required tracking batch identity through the production process, which was not practical given the workflow. Weighted average produced a stable, defensible cost per kilogram the auditor could verify directly from the Tally stock ledger and purchase invoices.
● Best Practices
State the inventory valuation method explicitly in the accounting policies note for each inventory category. Specify which method (FIFO or weighted average) applies to raw materials, WIP, finished goods, and other categories separately. Conduct a physical stock count at the year end and reconcile to the Tally stock balance before the accounts are finalised. No valuation method produces reliable results if the stock records do not reflect actual stock on hand. Review closing stock for NRV impairment annually. For each major inventory category, compare closing cost to the expected selling price less selling costs. Write down and document any items where NRV is below cost, and retain the calculation as an audit working paper.
⬟ Disclaimer :
This content is intended for informational and educational purposes only and does not constitute professional accounting, tax, or regulatory advice. Inventory valuation requirements described are based on AS 2 as notified under the Companies (Accounting Standards) Rules 2021. For specific inventory valuation questions, including complex manufacturing WIP valuation and NRV assessments, MSME owners should consult a qualified chartered accountant.
