Stock Valuation Methods (FIFO, LIFO, Avg)

Learning Objectives

Day 10 complete karne ke baad student:

  • Stock Valuation ka core meaning aur financial statements par uska impact samjhega.
  • Stock Quantity aur Stock Monetary Value ke beech ka difference identify karega.
  • Inventory valuation methods (FIFO, Average Cost, Last Purchase Rate, Standard Rate) ko practically calculate karega.
  • Closing stock value aur Cost of Goods Sold (COGS) ke relationship ko master karega.
  • Valuation methods badlne par Gross Profit par padne wale impact ko analyze karega.
  • TallyPrime mein stock item valuation methods configure karke reports se verify karega.

Core Concepts: Stock Valuation, COGS & Gross Profit

Advanced inventory management mein unsold closing stock ki monetary worth calculate karna financial reporting ke liye essential hota hai:

  • Stock Valuation: Business ke paas year-end ya period-end par available closing inventory ki monetary value determine karna.
  • Cost of Goods Sold (COGS): Opening Stock + Purchases − Closing Stock. Valuation method change hone se closing stock badalta hai, jisse COGS aur final Gross Profit bhi alter hote hain.

Comparison & Impact Matrix

Valuation Method Cost Flow Assumption Impact on Closing Stock in Inflation Impact on Gross Profit
FIFO (First In, First Out) Oldest costs are charged to COGS first Higher (Valued at latest/recent higher prices) Higher Profit
Average Cost Weighted average of all cost layers Moderate (Blended average valuation) Moderate Profit
Last Purchase Rate Valued at the most recent purchase cost Reflects latest market replacement cost Variable depending on market trend
Standard Rate Predefined constant standard cost Fixed standard baseline Variance-dependent
Golden Valuation Rule:
Stock Quantity batata hai ki kitne units rakhe hain.
Stock Valuation batata hai ki un units ki books mein cost value kitni hai (Selling price par nahi, cost price par value hota hai).

Practice Company Setup & Configuration

Company Profile

  • Company: ABC Electronics | State: Maharashtra | FY: 2026–27 | Inventory: Enabled

Configuring Valuation Method in TallyPrime:

  1. Go to Gateway of Tally → Create / Alter → Stock Item (e.g., Printer).
  2. Under item configuration, locate the Method of Stock Valuation field.
  3. Select desired method: FIFO, At Average Cost, Last Purchase Rate, or Standard Cost.
  4. Press Ctrl + A to save.

Practical Walkthroughs: FIFO vs Average Cost Calculation

Scenario Data for Printer:

  • Opening Stock: 100 Nos @ ₹8,000 = ₹8,00,000
  • Purchase 1 (01-Apr): 50 Nos @ ₹8,500 = ₹4,25,000
  • Purchase 2 (02-Apr): 100 Nos @ ₹9,000 = ₹9,00,000
  • Total Available: 250 Nos | Total Purchase Cost = ₹21,25,000
  • Sales (02-Apr): 120 Nos sold @ ₹10,000 = ₹12,00,000 revenue. Closing Stock = 130 Nos.

Method 1: FIFO Valuation Calculation

    COGS (120 units issued): 100 units from Opening @ ₹8,000 (₹8,00,000) + 20 units from Purchase 1 @ ₹8,500 (₹1,70,000) = ₹9,70,000.
    Closing Stock (130 units left): 30 units from Purchase 1 @ ₹8,500 (₹2,55,000) + 100 units from Purchase 2 @ ₹9,000 (₹9,00,000) = ₹11,55,000.
    Gross Profit: Sales (₹12,00,000) − COGS (₹9,70,000) = ₹2,30,000.

Method 2: Average Cost Valuation Calculation

  • Weighted Average Cost per unit: Total Cost (₹21,25,000) ÷ Total Qty (250) = ₹8,500 / unit.
  • COGS (120 units issued): 120 × ₹8,500 = ₹10,20,000.
  • Closing Stock (130 units left): 130 × ₹8,500 = ₹11,05,000.
  • Gross Profit: Sales (₹12,00,000) − COGS (₹10,20,000) = ₹1,80,000.

Complete Practice Sets

Practice Set (ABC Electronics Valuation Comparison Lab):

Valuation Method Applied Closing Quantity (Nos) Closing Stock Value (₹) Cost of Goods Sold (COGS) (₹) Reported Gross Profit (₹)
FIFO 130 11,55,000 9,70,000 2,30,000
Average Cost 130 11,05,000 10,20,000 1,80,000
Difference 0 (Same Qty) 50,000 (Variance) 50,000 (Variance) 50,000 (Variance)

Verification Reports, Common Mistakes & FAQs

Verification Reports in TallyPrime:

  • Stock Summary: Inspect closing stock valuation totals and per-unit rates. Drill down into item monthly summaries to verify cost layers.
  • Profit & Loss Account: Confirm how inventory valuation adjustments alter Cost of Sales and Net Profit figures.

Common Mistakes:

  • Treating selling prices as inventory acquisition costs when setting up stock item masters.
  • Assuming that changing the valuation method alters physical closing quantities (it only alters monetary valuation).
  • Ignoring opening stock layers while calculating manual FIFO or weighted averages.

Frequently Asked Questions:

  • Q: Stock valuation method change karne se physical stock quantity par kya asar padta hai?
    A: Physical quantity bilkul same rehti hai; sirf inventory ki monetary valuation amount change hoti hai.
  • Q: FIFO aur Average Cost mein kaunsa method behtar hai?
    A: Yeh company ki accounting policy aur industry standards par nirbhar karta hai. Rising price trends mein FIFO higher profit show karta hai.
  • Q: TallyPrime mein valuation method kahan change hota hai?
    A: Stock Item alteration screen mein Method of Stock Valuation option ke through.

Quick Revision & Completion Checklist

Stock Valuation Golden Workflow:
Record Opening Stock & Purchases → Record Sales → Configure Valuation Method in Stock Item Master (FIFO/Average) → Review Stock Summary Valuation → Reconcile P&L Gross Profit

Completion Checklist:

  • Stock valuation concepts and financial statement impact understood
  • FIFO manual calculation and Tally output reconciled
  • Average Cost manual calculation and Tally output reconciled
  • Gross profit variance between valuation methods analyzed
  • Stock Summary and Profit & Loss reports verified