Price Levels Aur Price Lists (Wholesale/Retail)

Learning Objectives

Day 6 complete karne ke baad student:

  • Price Level aur Price List ka core business purpose samjhega.
  • Customer categories (Retail, Wholesale, Dealer) ke according pricing levels define karega.
  • Quantity-wise pricing slabs aur Effective Dates configure karega.
  • Sales invoices mein automatic price level selection aur rate application master karega.
  • Stock Valuation ka concept aur cost price vs selling price ka difference samjhega.
  • FIFO (First In, First Out) aur Average Cost valuation methods calculate karega.
  • Stock Summary se inventory values verify aur reconcile kareगा.

Core Concepts: Price Levels, Price Lists & Stock Valuation

Advanced inventory aur sales management mein different customer segments ke liye flexible pricing maintain karne aur inventory ki monetary worth calculate karne ke liye key modules use hote hain:

  • Price Level: Customer categories (Retail, Wholesale, Dealer) ke basis par pricing tier define karna.
  • Price List: Item-wise, quantity slab-wise rates aur effective date structure maintain karna.
  • Stock Valuation: Unsold physical inventory ki monetary value calculate karna using specific cost methods (FIFO, Average Cost, etc.).

Comparison Matrix

Particular Price Level Price List Stock Valuation
Primary Focus Customer classification tier Quantity slab rates & dates Monetary inventory worth
Application Assigned to Customer Master Linked to Stock Items & Levels Applied across Stock Summaries
Key Parameter Type of buyer (Retail/Dealer) Quantity bought & Time period Inward purchase cost layers
Golden Inventory Rule:
Price Level = Kisko kis category ka rate dena hai?
Price List = Kitni quantity par kya rate lagega?
Stock Valuation = Unsold inventory ki actual cost value kya hai?

Company Setup & Price Level Configuration

Company Profile

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

Enabling Price Levels in TallyPrime:

  1. Press F11 (Features) on the Gateway of Tally.
  2. Set Maintain Inventory to Yes.
  3. Set Use Multiple Price Levels to Yes.
  4. Define Price Level names: Retail, Wholesale, Dealer.
  5. Poori screen accept karne ke liye press karein Ctrl + A (Save) settings.

Defining Price Lists & Quantity Slabs

Path: Gateway of Tally → Inventory Info / Price List → Stock Group / Item

Printer Price Matrix Example:

Quantity Slab Retail Level Rate (₹) Wholesale Level Rate (₹) Dealer Level Rate (₹)
1 to 4 / 9 Qty 10,000 9,500 9,200
5 to 9 / 10 to 49 Qty 9,800 9,200 8,900
50+ Qty 9,500 8,900 8,500

Practical Walkthroughs: Automated Pricing & Valuation

Part A: Automated Sales Pricing via Customer Mapping

  • Retail Sale: Sold 2 Printers to Retail Customer (Assigned Price Level: Retail) → Quantity 2 falls in slab (1–4) → Rate applied automatically = ₹10,000 → Total Value = ₹20,000.
  • Wholesale Sale: Sold 20 Printers to Wholesale Customer (Assigned Price Level: Wholesale) → Quantity 20 falls in slab (10–49) → Rate applied automatically = ₹9,200 → Total Value = ₹1,84,000.
  • Dealer Sale: Sold 60 Printers to ABC Dealer (Assigned Price Level: Dealer) → Quantity 60 falls in slab (50+) → Rate applied automatically = ₹8,500 → Total Value = ₹5,10,000.

Part B: Stock Valuation (FIFO vs Average Cost)

Purchase Layers for Printer:

  • Batch 1: 100 Nos @ ₹8,000 = ₹8,00,000
  • Batch 2: 50 Nos @ ₹8,500 = ₹4,25,000
  • Batch 3: 100 Nos @ ₹9,000 = ₹9,00,000
  • Total Stock: 250 Nos | Total Purchase Value = ₹21,25,000
  • Simple Average Cost: ₹21,25,000 ÷ 250 = ₹8,500 / unit.
  • FIFO Valuation (After issuing 120 Units): 100 units cleared from Batch 1 (@ ₹8,000) + 20 units cleared from Batch 2 (@ ₹8,500). Remaining Closing Stock = 30 Nos @ ₹8,500 + 100 Nos @ ₹9,000 = ₹11,55,000.

Complete Practice Sets

Practice Set (ABC Electronics Price List & Sales Lab):

Customer Name Assigned Price Level Order Quantity Applicable Slab Rate (₹) Total Invoice Value (₹)
Retail Customer Retail 3 Nos 10,000 30,000
Retail Customer Retail 15 Nos 9,800 1,47,000
Wholesale Customer Wholesale 5 Nos 9,500 47,500
Wholesale Customer Wholesale 60 Nos 8,900 5,34,000
ABC Dealer Dealer 25 Nos 8,900 2,22,500
ABC Dealer Dealer 75 Nos 8,500 6,37,500

Verification Reports, Common Mistakes & FAQs

Verification Reports in TallyPrime:

  • Stock Summary: Verify closing inventory quantities and valuation totals based on FIFO or Average Cost settings.
  • Sales Register: Reconcile applied rates against configured price level slabs during invoice entry.

Common Mistakes:

  • Confusing Price Levels (customer categories) with Price Lists (quantity rate tables).
  • Failing to link Customer Ledgers to their respective Price Levels, forcing manual rate entries.
  • Assuming that selling price equals stock valuation cost.
  • Overlooking Effective Dates when updating seasonal price list revisions.

Frequently Asked Questions:

  • Q: Price Level aur Price List mein kya antar hai?
    A: Price Level customer ki category define karta hai (Retail/Wholesale), jabki Price List us category ke andar quantity-wise rates ka table hoti hai.
  • Q: Qty badhne par rate automatically change kaise hota hai?
    A: Price List mein quantity slabs (e.g., 1–10, 11–50) configure karne par sales invoice mein quantity enter hote hi system appropriate slab rate pick kar leta hai.
  • Q: FIFO method ka inventory valuation par kya asar padta hai?
    A: FIFO (First In, First Out) kehte hain ki jo stock pehle purchase hua tha, woh pehle sale hua, jisse remaining closing stock latest purchase prices par value hota hai.

Quick Revision & Completion Checklist

Price & Valuation Golden Workflow:
Create Price Levels → Define Price Lists with Quantity Slabs → Link Price Level to Customer Ledger → Record Sales Voucher (Auto-Rate Pick) → Reconcile Stock Valuation (FIFO/Average)

Completion Checklist:

  • Price Levels (Retail, Wholesale, Dealer) configured in F11/Inventory features
  • Price Lists with multi-tier quantity slabs setup
  • Customer ledgers mapped to respective pricing tiers
  • Sales invoices recorded, confirming automatic rate application
  • Purchase cost layers and stock valuation methods (FIFO / Average Cost) reconciled