FIFO vs Weighted Average Stock Valuation: Impact on Gross Profit, COGS & Tax
By BillAmico Accounting Specialist Desk | | 9 min read
How you value your unsold inventory directly determines your reported Cost of Goods Sold (COGS), gross margin, closing stock value on the Balance Sheet, and final Income Tax liability.
1. First-In-First-Out (FIFO) Costing Method
FIFO assumes that the oldest inventory lots purchased are sold first. Consequently, the cost of goods sold reflects older purchase prices, while remaining closing stock is valued at recent purchase rates.
In times of rising prices (inflation), FIFO results in lower COGS, higher reported gross profit, and a higher valuation of closing stock on the Balance Sheet.
FIFO is natural and recommended for perishable items, food products, FMCG goods, and pharmaceuticals where physical rotation matches accounting flow.
2. Weighted Average Cost (WAC) Method
Weighted Average divides the total cost of all units in stock by the total quantity available to arrive at a uniform average cost per unit.
Whenever a new purchase arrives at a different rate, the average cost is recalculated: New Average Cost = (Existing Stock Value + Inward Purchase Value) / Total Quantity.
This method smoothens out sudden market price volatility and is favored in wholesale commodity trading, hardware, and chemicals.
info: Statutory Standards: Both FIFO and Weighted Average are recognized under Indian Accounting Standard 2 (Ind AS 2) and Tax Accounting Standards for inventory valuation.
3. Concrete Financial Comparison Example
Suppose you buy 100 units of an item at ₹50 in January, and 100 units at ₹60 in February. In March, you sell 120 units at ₹80.
Under FIFO: COGS = (100 * ₹50) + (20 * ₹60) = ₹5,000 + ₹1,200 = ₹6,200. Revenue = 120 * ₹80 = ₹9,600. Gross Profit = ₹3,400. Remaining 80 units valued at ₹60 = ₹4,800.
Under Weighted Average: Average cost = (₹5,000 + ₹6,000) / 200 = ₹55 per unit. COGS = 120 * ₹55 = ₹6,600. Gross Profit = ₹3,000. Remaining 80 units valued at ₹55 = ₹4,400.
4. Software-Level Costing Engine
Quality accounting software allows selecting between FIFO and Weighted Average costing methods in settings, automatically maintaining item lot ledgers and recalculating margin percentages on every sale.
Related guides
- Stock Transfer Between Godowns and Branches Under GST: Schedule I, Distinct Persons, Challans and E-Way Bills
- Batch Number and Expiry Date: How to Record Them on Purchase and Sale, and What the Law Expects
- Serial Number and IMEI Tracking for Mobile and Electronics Shops: Purchase Scan, Sale Scan, Warranty and Returns