Hi, friends GST is now start in INDIA. Now I’m describing how to calculate Product Amount and GST price from MRP Rate through our programing languages.
The basic calculation is Amount Excluding GST = (100*MRP (With GST))/ (100+GST (%))
For Example MRP Rate = 105 (N.B. MRP is include with GST)
That price has included GST 5%.
Amount Excluding GST = (100 * 105) / (100 + 5)
That will give Amount Excluding GST = 100 Rs.
GST Amount = MRP RATE – Amount Excluding GST
GST Amount = (105 – 100)
GST Amount = 5 Rs.
Now I’ve written a simple SQL Query to fetch these amount. This code is help you to use in other languages like .Net, Java, etc.
DECLARE @MRP AS NUMERIC(19,2) = 100
DECLARE @GST AS NUMERIC(19,2) = 5
SELECT Amount = (100*@MRP)/(100+@GST)
SELECT GST = @MRP - (100*@MRP)/(100+@GST)
-------------------------------------------------------------------------------------------------------------------
Result : Amount = 95.238095238095238
GST = 4.761904761904762
-------------------------------------------------------------------------------------------------------------------
If there is any other better option,
Thank You,
Arka Gupta.
