If you run a shop in India, most of your prices are GST-inclusive: the MRP on a pack, the rate on your menu board or the round figure you quote a customer already has tax inside it. So when you need to file returns, check a supplier bill or set up an item in your billing software, you have to work backwards. This guide shows exactly how to calculate GST from total amount, with a simple formula, worked rupee examples for every common slab, the CGST and SGST split, and the rounding mistakes that quietly put your books out by a few paise or a few hundred rupees.
Why you need to back-calculate GST at all
GST is charged on the taxable value of a sale. When a customer pays ₹1,180 for an item, that ₹1,180 is not your revenue. Part of it is tax you collected for the government. Your sales register, your GSTR-1 and your profit figures all need the two parts shown separately.
In everyday retail this comes up all the time:
- A supermarket sells packaged goods at MRP, and the MRP already includes GST.
- A restaurant prints menu prices that customers see as the final amount.
- A hardware or textile shop quotes a round figure like ₹2,500 “including tax”.
- You receive a purchase bill that shows only a total, and you want to check the tax portion.
In each case the known number is the total, and the unknowns are the taxable value and the GST inside it.
The formula to calculate GST from total amount
There are only two formulas to remember. Use the GST rate as a plain number, so 18% is written as 18.
GST amount inside a total
GST amount = Total amount × GST rate ÷ (100 + GST rate)
Taxable value (price before GST)
Taxable value = Total amount × 100 ÷ (100 + GST rate)
You can always check your work: taxable value plus GST amount must equal the total you started with.
The most common mistake
Many people take 18% of the total. On a total of ₹2,360 that gives ₹424.80, which is wrong. The correct GST is ₹360, because the 18% was charged on the taxable value of ₹2,000, not on ₹2,360. Taking a percentage of the inclusive total always overstates the tax. If this mistake creeps into a month of sales, your liability and your margins both look wrong.
Worked examples for each GST slab
After the GST Council’s rate rationalisation that took effect on 22 September 2025, most goods and services fall under 5% or 18%, with a 40% rate for a small group of luxury and sin goods. You will still see 12% and 28% on older invoices and when you review past returns, so they are included below. Always confirm the current rate for your item’s HSN or SAC code on the CBIC GST rates page.
| GST rate | Total amount (inclusive) | Taxable value | GST amount | CGST | SGST |
|---|---|---|---|---|---|
| 5% | ₹84.00 | ₹80.00 | ₹4.00 | ₹2.00 | ₹2.00 |
| 12% (older invoices) | ₹1,120.00 | ₹1,000.00 | ₹120.00 | ₹60.00 | ₹60.00 |
| 18% | ₹2,360.00 | ₹2,000.00 | ₹360.00 | ₹180.00 | ₹180.00 |
| 28% (older invoices) | ₹1,280.00 | ₹1,000.00 | ₹280.00 | ₹140.00 | ₹140.00 |
| 40% | ₹1,400.00 | ₹1,000.00 | ₹400.00 | ₹200.00 | ₹200.00 |
Example 1: an 18% item at ₹2,360
GST = 2,360 × 18 ÷ 118 = ₹360. Taxable value = 2,360 × 100 ÷ 118 = ₹2,000. Check: 2,000 + 360 = 2,360.
Example 2: a 5% item at ₹84
GST = 84 × 5 ÷ 105 = ₹4. Taxable value = 84 × 100 ÷ 105 = ₹80. This is the kind of calculation a grocery or kirana counter does hundreds of times a day without noticing.
Example 3: an amount that does not divide neatly
Real prices are rarely as tidy as ₹2,360. Take an 18% item sold at ₹99. Taxable value = 99 × 100 ÷ 118 = 83.898…, which rounds to ₹83.90. GST = 99 − 83.90 = ₹15.10. Notice that we worked out the taxable value first, rounded it, and then took GST as the difference. That way the two parts always add back to exactly ₹99.
Splitting GST into CGST, SGST and IGST
Once you know the GST amount, the split depends on where the sale happens:
- Sale within the same state (for example, a shop in Kochi billing a customer in Kerala): divide the GST equally between CGST and SGST. On ₹360 GST, that is ₹180 CGST and ₹180 SGST.
- Sale to another state (for example, a Kerala wholesaler supplying a retailer in Coimbatore): the whole ₹360 is IGST. Nothing is split.
When the GST amount has an odd paisa, such as ₹15.11, split it carefully so CGST and SGST still add up to the total GST. Good billing software handles this automatically, and your invoice format should show the split clearly. Our guide to GST invoice software for shops explains what a compliant invoice needs to show.
Rounding pitfalls that cause mismatches
Small rounding differences are the most common reason why the GST in your billing software does not match your accountant’s working or your GSTR-1 summary.
Line-level versus invoice-level rounding
Suppose a customer buys three items at ₹99 each, all at 18%.
- Rounding each line: taxable value per item is ₹83.90, so three items give ₹251.70 taxable and ₹45.30 GST.
- Rounding the invoice total: 297 × 100 ÷ 118 = 251.694…, so ₹251.69 taxable and ₹45.31 GST.
The difference is just one paisa on this bill, but across thousands of bills in a month it adds up and becomes hard to explain. Pick one method, use it consistently in your billing system, and make sure your accountant knows which method you use.
Rounding the bill to the nearest rupee
Many shops round the final bill to the nearest rupee. Show that round-off as a separate line on the invoice instead of adjusting the taxable value or the GST, so the tax figures stay accurate.
Discounts on MRP-inclusive prices
If you give a discount on an inclusive price, recalculate GST on the discounted amount, not on the original MRP. For an 18% item with an MRP of ₹590 sold at 10% off, the customer pays ₹531. Taxable value = 531 × 100 ÷ 118 = ₹450, and GST = ₹81. Calculating tax on ₹590 and then subtracting the discount would overstate the GST.
How to calculate GST from total amount in Excel
If you still check figures in a spreadsheet, put the total in column A and the GST rate as a number (5, 18, 40) in column B. Then use:
- GST amount in column C:
=ROUND(A2-D2,2) - Taxable value in column D:
=ROUND(A2*100/(100+B2),2) - CGST and SGST in columns E and F:
=ROUND(C2/2,2)each, adjusting one by a paisa if needed so they add up to C2
Calculating the taxable value first and taking GST as the difference keeps every row balanced. A spreadsheet is fine for spot checks, but it is not a practical way to bill customers at a busy counter.
How billing software back-calculates GST on MRP-inclusive prices
In a billing system you usually set each item up once, with its selling price, whether that price includes tax, and its GST rate. From then on, every bill does the reverse calculation automatically:
- The cashier scans the barcode or picks the item, and the inclusive price comes up.
- The software works out the taxable value and the GST for each line using the item’s rate.
- It splits GST into CGST and SGST, or treats it as IGST for an inter-state sale.
- Discounts are applied before the tax is calculated, and the round-off is shown separately.
- Rate-wise totals flow into your GST reports, so your returns start from the same numbers as your bills.
The step that matters most is item setup. If an item is marked “tax exclusive” when its price actually includes tax, every sale of it will charge GST on top of the MRP. Review your item master whenever rates change, as many shops had to after September 2025.
For a wider look at what to expect from a GST-ready system, read our guide to GST billing software for retail shops in India.
A quick checklist for shop owners
- Use Total × rate ÷ (100 + rate) for GST, never Total × rate%.
- Calculate and round the taxable value first, then take GST as the difference.
- Split intra-state GST equally into CGST and SGST, and treat inter-state GST as IGST.
- Apply discounts before calculating tax.
- Show the bill round-off as its own line.
- Check every item’s GST rate and inclusive or exclusive setting after any rate change.
- If you are registered under the composition scheme, you cannot collect GST from customers, so these calculations apply to your purchases, not your sales bills.
Frequently asked questions
What is the formula to calculate GST from total amount?
GST amount = Total × GST rate ÷ (100 + GST rate). For an 18% item at ₹1,180, that is 1,180 × 18 ÷ 118 = ₹180, and the taxable value is ₹1,000.
How do I find the price before GST?
Divide the total by (1 + rate ÷ 100). At 18%, divide by 1.18. At 5%, divide by 1.05. So ₹525 at 5% has a pre-GST price of ₹500.
Is MRP inclusive of GST?
Yes. MRP on packaged goods is the maximum price including all taxes, so a shop cannot add GST on top of the MRP. Any GST is calculated from inside the MRP using the formula above.
Why is 18% of the total not the GST amount?
Because GST is charged on the taxable value, not on the final total. The total already contains the tax, so taking 18% of it charges tax on tax and gives a figure that is too high.
Can billing software calculate GST from inclusive prices automatically?
Yes. Once each item has the right GST rate and is marked as tax-inclusive, the software works out the taxable value, the GST and the CGST/SGST split on every bill and totals them for your returns.
Let your billing do the maths
Back-calculating GST by hand is easy for one item and error-prone for a full day’s sales. Caddayn Biller handles GST billing with barcode scanning, rate-wise tax on every line and UPI, card and cash payments, on Windows or the web. If you want your counter to get these numbers right on every bill, download Caddayn Biller and try it with your own items.