Inclusive of Tax & MRP Billing

Learning Objectives

Is class ke end tak student:

  • MRP ka meaning samjhega.
  • MRP aur Selling Price mein difference samjhega.
  • GST mein MRP ka basic role samjhega.
  • MRP inclusive/exclusive tax situations identify karega.
  • Discount on MRP calculate karega.
  • GST-inclusive price se taxable value calculate karega.
  • TallyPrime mein MRP-based stock item create karega.
  • Sales invoice MRP ke basis par prepare karega.
  • Discount ke baad GST calculate karega.
  • Local aur interstate MRP transactions karega.
  • Purchase at cost vs sale at MRP compare karega.
  • Stock valuation aur profit verify karega.

Core Concepts: MRP vs Selling Price & Formulas

MRP (Maximum Retail Price): Packaged goods ke context mein consumer-facing maximum retail price hoti hai.

Important Rule:
MRP ≠ Actual Selling Price
MRP ko automatically accounting selling price nahi samajhna chahiyBusiness MRP se discount dekar lower price par sell kar sakta hai.

GST-Inclusive Calculation Formulas

Taxable Value = Inclusive Amount × 100 ÷ (100 + GST Rate)

GST Amount = Inclusive Amount − Taxable Value

For 18% GST: Taxable Value = Inclusive Amount × 100 ÷ 118

MRP Transaction Sequence

MRP → Less: Discount → Actual Selling Price → Taxable Value (Back-Calculated) → GST → Invoice Total

Comparative Pricing Scenarios

Scenario 1: MRP ₹1,180 (No Discount, GST-Inclusive @18%)

  • Taxable Value = ₹1,180 × 100 ÷ 118 = ₹1,000
  • GST = ₹180 (Local: CGST ₹90 + SGST ₹90 | Interstate: IGST ₹180)

Scenario 2: MRP ₹1,180 with 10% Discount (GST-Inclusive @18%)

  • MRP: ₹1,180 | Discount (10%): ₹118 | Selling Price: ₹1,062
  • Taxable Value = ₹1,062 × 100 ÷ 118 = ₹900
  • GST = ₹162 (CGST ₹81 + SGST ₹81) | Invoice Total = ₹1,062

Scenario 3: GST Inclusive vs Exclusive Comparison

  • Case A (Inclusive): MRP ₹1,180 → Taxable = ₹1,000 | GST = ₹180 | Total = ₹1,180.
  • Case B (Exclusive): Selling Price ₹1,000 → GST @ 18% Extra = ₹180 | Total Invoice = ₹1,180.

Master Setup & Practice Stock Items

Company mein inventory features ke andar MRP options enable karein (F11 Features → Inventory → Enable MRP features).

Item Name Unit Stock Group MRP (₹) Purchase Cost (₹) GST Rate
Packaged Juice 1L Nos Beverages 118 70 18%
LED Bulb Nos Electronics 236 140 18%
Bluetooth Speaker Nos Electronics 2,360 1,500 18%
Electric Iron Nos Appliances 1,770 1,100 18%
Mixer Grinder Nos Appliances 5,900 4,000 18%

Practical Walkthroughs in TallyPrime

Purchase Entry at Cost (F9: Purchase)

01-Jun: Purchased 100 Nos Packaged Juice @ ₹70 from ABC Distributors.

  • Taxable Purchase Value = 100 × ₹70 = ₹7,000
  • GST @ 18% = ₹1,260 (CGST ₹630 + SGST ₹630) | Invoice Total = ₹8,260

Local Sales at MRP (F8: Sales)

01-Jun: Sold 20 Nos Packaged Juice @ MRP ₹118 (GST-Inclusive, No Discount) to Retail Customer.

  • Gross Invoice Value = 20 × ₹118 = ₹2,360
  • Taxable Value = ₹2,360 × 100 ÷ 118 = ₹2,000
  • CGST (9%) = ₹180 | SGST (9%) = ₹180 | Total = ₹2,360

Local Sales with Discount (F8: Sales)

02-Jun: Sold 5 Nos Bluetooth Speakers @ MRP ₹2,360 with 15% Discount.

  • Gross MRP = 5 × ₹2,360 = ₹11,800 | Discount (15%) = ₹1,770
  • Net Selling Value = ₹10,030 (Inclusive of 18% GST)
  • Taxable Value = ₹10,030 × 100 ÷ 118 = ₹8,500
  • CGST (9%) = ₹765 | SGST (9%) = ₹765 | Invoice Total = ₹10,030

Complete Practice Sets

Part 1: Purchase Transactions at Cost

  1. 01-Jun: 100 Packaged Juice @ ₹70 (ABC Distributors, 18% GST).
  2. 03-Jun: 50 LED Bulbs @ ₹140 (ABC Distributors, 18% GST).
  3. 05-Jun: 20 Bluetooth Speakers @ ₹1,500 (Tech Suppliers, 18% GST).
  4. 07-Jun: 10 Electric Irons @ ₹1,100 (Home Needs, 18% GST).
  5. 01-Jun: 5 Mixer Grinders @ ₹4,000 (Home Needs, 18% GST).

Part 2: Local Sales Entries (Maharashtra Customer)

  1. 01-Jun: 20 Packaged Juice (MRP ₹118, 10% Discount).
  2. 01-Jun: 10 LED Bulbs (MRP ₹236, 5% Discount).
  3. 02-Jun: 5 Bluetooth Speakers (MRP ₹2,360, 15% Discount).
  4. 02-Jun: 3 Electric Irons (MRP ₹1,770, 10% Discount).
  5. 02-Jun: 2 Mixer Grinders (MRP ₹5,900, 20% Discount).

Part 3: Interstate Sales Entries (Gujarat Customer)

Item Name Qty MRP (₹) Discount (%) Tax Type
Packaged Juice 10 118 5% IGST (18%)
LED Bulb 10 236 10% IGST (18%)
Bluetooth Speaker 3 2,360 15% IGST (18%)
Electric Iron 2 1,770 5% IGST (18%)
Mixer Grinder 1 5,900 10% IGST (18%)

Common Mistakes & FAQs

Common Mistakes:

  • Assuming MRP = Selling Price: Forgetting to account for trade or consumer discounts.
  • Adding GST on Inclusive MRP: Adding 18% extra on top of an already GST-inclusive price (e.g., charging ₹118 + 18% instead of back-calculating from ₹118).
  • Calculating Profit from MRP: Profit must always be calculated as Actual Taxable Selling Price − Purchase Cost, not MRP − Cost.

Frequently Asked Questions:

  • Q: GST-inclusive price se taxable value kaise nikalte hain?
    A: Taxable Value = Inclusive Amount × 100 ÷ (100 + GST Rate).
  • Q: MRP transaction mein discount kahan apply hota hai?
    A: Discount pehle MRP par deduct hota hai, phir bachi hui net selling price se taxable value aur GST calculate kiya jata hai.
  • Q: Kya MRP par direct GST add kiya jata hai?
    A: Agar MRP GST-inclusive hai, toh GST back-calculate hota hai; agar price GST-exclusive hai, toh taxable value par GST add kiya jata hai.

Quick Revision & Completion Checklist

Day 6 Golden Workflow:
MRP → Less: Discount → Actual Selling Price → Taxable Value (Back-Calculated) → GST → Invoice Total

Completion Checklist:

  • MRP vs Selling Price concepts mastered
  • GST-inclusive back-calculation formula practiced
  • MRP-enabled stock items created in TallyPrime
  • Purchase entries recorded at cost
  • Local & Interstate Sales invoices recorded with MRP discounts
  • Sales Register, Stock Summary, and GST Tax Analysis verified