11. Inventory Accounting — FIFO, Weighted Avg

Inventory valuation is one of the areas with the highest impact on profit, GST, Income Tax, MIS, working capital, and audit outcomes. Incorrect valuation can distort P&L and create tax exposure.
This guide explains inventory accounting in a clear, practical way using the two most widely used valuation methods: FIFO and Weighted Average.

1. Introduction — Why Inventory Accounting Matters

Inventory is one of the most critical current assets for trading, manufacturing, and distribution businesses.The way inventory is valued impacts:
  • Cost of Goods Sold (COGS)
  • Gross profit
  • Closing stock
  • Income Tax liability
  • GST compliance
  • Working capital analysis
  • Banking limits (CC/OD)
  • Audit results
Incorrect valuation can result in penalties, tax additions, and inaccurate financial reporting.
Key Points:• Inventory valuation directly affects profitability.• FIFO and Weighted Average are globally accepted valuation methods.• Choice of method impacts tax, MIS, and audit presentation.• A consistent method must be followed year after year.

2. Objective

To explain the two main inventory valuation methods — FIFO and Weighted Average — and help SMEs choose and apply the correct method consistently and accurately.

3. Core Concepts — What Is Inventory Accounting?

Inventory accounting determines:
  • How purchases are recorded
  • How COGS is calculated
  • How closing stock is valued
  • How profitability is measured
It ensures that goods consumed or sold are assigned the correct cost.
Inventory Categories:• Raw materials• Work-in-progress• Finished goods• Trading goods

4. FIFO Method — First In, First Out

FIFO assumes that the goods purchased first are sold/consumed first.
How FIFO Works
If you buy:
    Batch 1: 100 units @ ₹10
    Batch 2: 100 units @ ₹12
And you sell 120 units:
COGS =100 × ₹10 (Batch 1)20 × ₹12 (Batch 2)
Closing stock =80 units @ ₹12
Advantages of FIFO
• Simple and logical• Closing stock reflects latest market prices• Accepted by auditors, tax authorities, and regulators• Good for perishable/sequential goods• Higher profit in inflationary periods (lower COGS)
Disadvantages of FIFO
• Higher profit → higher tax in inflationary environment• Stock layers must be tracked accurately• Not ideal if prices fluctuate heavily
When SMEs Should Use FIFO
✔ Businesses with identifiable batches✔ Industries with stable or rising prices✔ Perishable goods (food, chemicals)✔ Manufacturing and trading businesses needing price clarity

5. Weighted Average Cost Method (WAC / Moving Average)

Weighted Average calculates a new average cost per unit each time goods are purchased.
How WAC Works (Moving Average)
Example purchases:
    100 units @ ₹10 → total ₹1,000
    100 units @ ₹12 → total ₹1,200
Weighted average cost per unit =₹2,200 ÷ 200 units = ₹11
If you sell 120 units:COGS = 120 × ₹11 = ₹1,320Closing stock = 80 × ₹11 = ₹880
Advantages of Weighted Average
• Smooths out price fluctuations• Easier for continuous transactions• Good for large volume/identical items• Accepted internationally• Reduces volatility in profit margins
Disadvantages of Weighted Average
• Closing stock does not reflect latest price• Profits may be understated or overstated in rapidly changing markets• Not suitable for items with unique identity or batch tracking
When SMEs Should Use Weighted Average
✔ Commodity-based businesses✔ Steel, chemicals, plastics✔ Large-volume trading businesses✔ Warehouses using pooled storage✔ Businesses with fluctuating purchase prices

6. FIFO vs Weighted Average — Comparison Table

Criteria
FIFO
Weighted Average
Cost used for COGS
Oldest purchases
Average cost
Closing stock value
Latest rates
Averaged rate
Profit impact in inflation
Higher profit
Lower profit
Volatility in margin
Higher
Lower
Ease of implementation
Moderate
Easy
Batch-wise control
Required
Not required
Suitable for
Perishable & batch goods
Commodities & bulk goods

7. CABTA Framework — “The 4 Rules of Correct Inventory Valuation”

Rule 1 — Select the Method Based on Business Nature

Perishable or batch-based → FIFOBulk/commodity → Weighted Average

Rule 2 — Apply the Method Consistently

Inconsistent switching distorts financials and attracts audit objections.

Rule 3 — Reconcile Physical Stock with Book Stock

At least monthly for trading businesses and quarterly for manufacturers.

Rule 4 — Link Inventory Valuation with GST & Income Tax

• GST does not mandate a valuation method but requires documentation.• Income Tax requires consistency and disclosure of method used.• Stock valuation directly impacts taxable income.

8. Case Example — Fixing Incorrect Inventory Valuation

Client: FMCG Trading BusinessIssue: Inconsistent valuation by accountant — sometimes FIFO, sometimes average cost.This caused fluctuating profits and audit remarks.
CABTA Intervention:• Selected FIFO based on product nature• Introduced batch-tracking system• Trained staff on posting rules• Implemented monthly stock reconciliation
Result:• Stable margins• Clean audit remarks• Correct GST & Income Tax reporting

9. Tools & Templates (Application Layer)

• FIFO Calculation Template• Weighted Average Inventory Template• Inventory Valuation Policy Document• Stock Ledger Template• Physical Verification Format• Month-End Inventory Checklist

10. CABTA Insight

“Inventory valuation is not just an accounting exercise — it determines true profitability.”

Next Article