Product Pricing Calculator Free Excel Template for Indian Retailers & Distributors

Q: What is the difference between markup and margin?

Markup is profit measured on your cost; margin is profit measured on your selling price. Buy at 100 and sell at 150 and that is a 50% markup but a 33.3% margin. They describe the same profit from two angles, and mixing them up is the most common reason a shop makes less than expected. This calculator always shows both.

Enter your cost, GST slab and the margin you want. Get the selling price, the GST-inclusive MRP, and profit per unit in seconds. Shows markup and margin together, and plans festival discounts. Updated for the GST 2.0 slabs (0%, 5%, 18%, 40%).

Type cost and target margin, get selling price, GST and MRP automatically
Markup and margin shown side by side, so a 50% markup is never mistaken for a 50% margin
Discount Planner shows the margin left after a sale, plus your break-even discount

No spam. Instant download link to your email.

Petpooja presents

Product Pricing Calculator

For Indian Retailers & Distributors

Sheets · Excel template

GST 2.0 · 2025

What's Inside

Five sheets that price your whole catalogue

Price Calculator (Two Ways)

Panel A sets a price from a target margin: enter cost and margin, get selling price and MRP. Panel B checks the margin on a price you already charge. Type into the cream cells only.

Product Price List (Bulk)

Price up to 40 products in one table. Enter cost, GST slab and target margin per row. Selling price, GST, MRP, markup and profit fill in. Margin turns green, amber or red at a glance.

Discount & Markdown Planner

Pick a product you priced in the list and its MRP, cost and GST fill in automatically. Enter the discount percent to see the margin that survives it, plus your break-even discount, the point where a deeper cut starts losing money.

Markup vs Margin Guide

A conversion table that ends the confusion for good. Buy at ₹100 and sell at ₹150: that is a 50% markup but only a 33.3% margin. Plus directional gross-margin ranges by retail category.

GST 2.0 Slabs Built In

Pick 0%, 5%, 18% or 40% from a dropdown when you price a product; the Discount Planner reuses that rate automatically. The old 12% and 28% slabs are gone after the 22 September 2025 reform, so the calculator only offers the current rates.

Instructions + Indian Formatting

A plain-language guide to how the sheet works, the markup-vs-margin trap, and the MRP rule. All amounts use ₹ with the Indian number format (1,00,000). Nothing is a black box.

Why This Matters

The pricing maths that quietly eats retail profit

You buy a product for ₹350. You want a "50% margin", so you add 50% and sell it for ₹525. You think you made ₹175. You actually made a 33% margin, and once GST comes out of that price, less still.

This is the single most common pricing mistake in Indian retail, from garment shops in Surat to electronics counters in Delhi. Markup and margin are not the same number, and pricing off the wrong one quietly thins the profit on every bill you raise.

GST makes it harder. On a packaged retail product, the MRP printed on the pack is inclusive of tax under the Legal Metrology (Packaged Commodities) Rules, 2011. Your cost is usually GST-exclusive. Compare the two directly and your margin looks healthier than it is, because a slice of that MRP belongs to the government.

Then comes the festival season. A "30% off" banner feels generous, but if you did not check the break-even discount, some of those bills are now selling below cost. On a thin-margin category like groceries or phones, a single aggressive weekend can wipe out a month of profit. Even planned dynamic pricing needs a floor, and that floor is your break-even.

This calculator removes the guesswork. Enter cost, pick the GST slab, set the margin you actually want, and it returns the selling price, the tax-inclusive MRP, the markup, the margin and the profit per unit. It uses the post-22-September-2025 GST 2.0 slabs (5% and 18% as the two main rates, 40% for demerit goods), so you are never pricing on the retired 12% or 28% rates. Not sure of a product's rate? Our GST rate finder and HSN/SAC directory pins down the right slab first.

Sample Preview

What the sheet shows for a ₹350 leather wallet

Cost ₹350 (excl GST), 18% GST slab, target margin 50%. Here is what you get:

Selling price (excl GST): ₹700.00 the price your margin is measured on, before tax is added

GST at 18%: ₹126.00 added on top of the ex-tax price

MRP (incl GST): ₹826.00 the maximum price you can print on the pack, tax included

Markup vs Margin: 100% markup on cost, but a 50% margin on selling price the two numbers for the same profit

Profit per unit: ₹350.00 shown in green, cost fully covered

In the Discount Planner, a 30% festival cut on that ₹826 MRP leaves a 28.6% margin and ₹140 profit. Your break-even discount is 50%, so anything past that sells at a loss.

Key Stats

The GST rules behind every price you set

5% & 18%

The two main GST slabs after the 22 September 2025 GST 2.0 reform, plus a 40% rate for demerit goods. The old 12% and 28% slabs were removed, so pricing on them is now wrong.

Source: CBIC Central Tax (Rate) notifications dated 17-Sep-2025; 56th GST Council

Tax-inclusive MRP

On pre-packaged retail goods, the MRP is the maximum price inclusive of all taxes. You cannot print an MRP and add GST on top of it at the counter.

Source: Legal Metrology (Packaged Commodities) Rules, 2011

₹2,500/piece

Apparel and textiles at or below ₹2,500 per piece attract 5% GST, above it 18%. Footwear uses a separate ₹1,000 per pair line. Both are judged per piece or pair, not per invoice.

Source: CBIC GST 2.0 rate notifications, effective 22-Sep-2025

Common Mistakes

7 Pricing Mistakes Indian Retailers Make

Confusing markup with margin

A 50% markup on cost is only a 33.3% margin on selling price. Pricing off markup while thinking in margin means you are quietly making less than you planned on every single sale. When in doubt, confirm the number with a free profit margin calculator.

Forgetting GST is already inside the MRP

Comparing a GST-exclusive cost with a GST-inclusive MRP inflates your apparent margin. A part of that MRP is tax you collect and pay onward, not profit you keep. A good retail POS system separates the two on every bill automatically.

Discounting past the break-even point

A festival "40% off" can push a thin-margin product below cost. Without checking the break-even discount first, generous banners can turn every sale into a small loss.

Still pricing on the old 12% or 28% GST slabs

After GST 2.0 took effect on 22 September 2025, those slabs no longer exist. Most 12% items moved to 5% and most 28% items to 18%, per the CBIC rate notifications. Old rates mean wrong prices and wrong invoices.

Pricing on purchase cost alone

Freight, packing, and handling are real per-unit costs. Leaving them out of the cost base means your "margin" is smaller than the sheet says, especially on bulky or imported goods.

Printing an MRP that is not tax-inclusive

Under the Legal Metrology (Packaged Commodities) Rules, 2011, the declared MRP must be inclusive of all taxes. Getting this wrong is both a pricing error and a labelling compliance risk.

Using one margin percent for every category

Groceries typically run on 8 to 15% margins, while mobile accessories can carry 40% or more. Applying a single blanket margin over-prices some products and under-prices others, and loses sales either way. Retail POS software that reports margin by category makes these gaps obvious.

Comparison

Setting Prices: Guesswork vs This Calculator

Aspect	Guesswork / Mental Maths	With This Calculator
Markup vs margin	Often mixed up, margin overstated	Both shown side by side for every product
GST handling	Added by memory, sometimes on old slabs	0/5/18/40% dropdown, MRP built tax-inclusive
MRP calculation	Rounded off by hand	Auto: ex-tax price plus the right GST
Discount safety	No idea where losses start	Break-even discount shown per product
Whole catalogue	One product at a time	Up to 40 products priced in one table
Category sense-check	Gut feel	Directional margin ranges by retail category
Time per product	Two to three minutes	A few seconds

Stop leaving margin on the table

Download the free Product Pricing Calculator and price every product with cost, GST and profit in view.

FAQ

Frequently asked questions

What is the difference between markup and margin?

Markup is profit measured on your cost. Margin is profit measured on your selling price. If you buy at ₹100 and sell at ₹150, that is a 50% markup (₹50 on ₹100 cost) but a 33.3% margin (₹50 on ₹150 price). They describe the same profit from two angles, and mixing them up is the most common reason a shop makes less than it expected. This calculator always shows both.

Is MRP inclusive of GST?

Yes. For pre-packaged retail goods, the MRP is the maximum retail price inclusive of all taxes under the Legal Metrology (Packaged Commodities) Rules, 2011. You cannot charge GST on top of the printed MRP at the counter. The calculator's "MRP (incl GST)" column is the tax-inclusive figure you can print, while "selling price excl GST" is the value your margin is calculated on. This applies to pre-packaged retail goods. Loose or unpackaged items and services carry no MRP, so GST is charged on the sale value.

Which GST slab applies to my product?

After the GST 2.0 reform effective 22 September 2025, there are two main slabs, 5% and 18%, plus a 40% rate for demerit goods like tobacco, pan masala and aerated drinks, and a 0% category for exempt essentials. Apparel and textiles are 5% at or below ₹2,500 per piece and 18% above; footwear uses a separate ₹1,000 per pair threshold. The old 12% and 28% slabs were removed. Check your product's HSN code on the official GST portal for the exact rate before you price.

How much discount can I give before losing money?

Up to your break-even discount, which the Discount Planner calculates for each product. It is the point where the discounted selling price, after GST is removed, exactly equals your cost. For the sample ₹826 MRP wallet costing ₹350, the break-even discount is 50%. Discount beyond that and every unit sells below cost, even though the banner still looks attractive. To sanity-check a single offer quickly, our free discount calculator does the same maths online.

How do I price for wholesale or B2B versus retail?

Retail counter prices are usually quoted as a tax-inclusive MRP, so use the "MRP (incl GST)" column. Wholesale and dealer prices are normally quoted excluding GST, with tax shown separately on the invoice, so use the "selling price excl GST" column and let a GST invoice template add tax per the buyer's invoice. The margin percentage stays the same either way, only how you present the price changes.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across retail, restaurants, healthcare, manufacturing, and more. From GST billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.

Price and bill your whole catalogue in one place

Petpooja Invoice keeps every product's GST slab, cost and MRP ready. Scan a barcode, print a tax-inclusive price, and raise a compliant GST bill in seconds. No side spreadsheets.

Book a Free Demo Call: +91-92279 80766