To reverse calculate GST and find the original price (before tax), divide the total inclusive amount by 1 + ( GST Rate 100 ) 1 + ( G S T R a t e 1 0 0 ) .
Example
Subtracting GST:
To calculate how much GST is included in a price, just divide by 11. To calculate how much the price was before GST, just divide by 1.1. That's a lot of manual work for small-business owners to do every time they want o calculate GST—use our calculator instead.
So the pre-tax subtotal was $60. The GST is the difference between this and the aftertax total: $63 - $60 = $3. You can see that to find the total before GST all you need to do is divide by 1.05.
Using Excel to Reverse Calculate GST
Here's how to do it: Use the Formula: To reverse calculate GST, the formula is =Total Price / (1 + GST rate). For example, if the total price is ₹118 with an 18% GST, the person would type =118 / 1.18' in Excel to find the original price of ₹100.
Formula to Calculate Reverse GST with Example
Base Price is equal to 100 / (100 + Value of an applicable GST Rate) * GST Inclusive Amount. After obtaining the base price, you can deduct it from the GST-inclusive amount to determine the Reverse GST amount.
You can use the Cleartax reverse GST calculator to break down a total price into its base price and GST amount. Firstly, divide the GST-inclusive price by (1 + (GST rate/100)) to determine the base price. Lastly, subtract this value from the total price.
How do you remove GST? The equation to subtract GST is slightly more complicated: First, take the GST-inclusive price and multiply that by 3. Then, divide the result by 23 and round that number to the nearest two decimal points.
Reverse Charge means the liability to pay tax is on the recipient of supply of goods or services instead of the supplier of such goods or services in respect of notified categories of supply.
The reversal is calculated using the following formula. Example: If the buyer claimed ₹50,000 as ITC on a purchase, and the supplier failed to pay GST for 2 months out of 12 months, the ITC reversal would be calculated proportionately. As a result, the buyer must reverse ₹8,333 of the claimed ITC.
Subtracting GST:
Net price = Original cost – GST
For example, if the cost of a product after GST of 18% is Rs. 118, its original cost is 118 – [100/(100 + 18%)}], which equates to Rs. 100.
Understanding GST Rate Reduction
Starting September 22, 2025, the GST Council reduced the number of tax slabs from four to two main rates: 5% merit rate for essential and priority items and 18% standard rate for most other goods and services. There is also a special 40% rate for luxury and sin goods.
Excel Formula to Remove the GST amount from a Total
If you have a GST-inclusive total and need to calculate the GST-exclusive amount (i.e., remove GST), divide the Total figure by 1.15.
5% of 2000 is 100.
To take 20% off a price, convert 20% to a decimal (0.20), multiply the original price by 0.20 to find the discount amount, and then subtract that discount from the original price to get your final price; alternatively, multiply the original price by 0.80 (100% - 20%) to directly find the final cost.
The value of a taxable supply is the consideration payable for the supply (before GST is added). For example, if the value of the supply is $100, the GST payable is 10 percent of $100, being $10. The price GST inclusive of the supply is $110. To work out the GST paid, you can divide by 11.
If you only have G.S.T, which is 7%, then you would calculate the price after taxes by multiplying by 1.07. So a $200 item would cost 1.07 x $200 = $214 after G.S.T. To calculate how much G.S.T. was paid on a $214 item, simply reverse the calculation by dividing by 1.07, as $214/1.07=$200.
A GST calculator is a tool that helps in calculating the Goods and Services Tax (GST) for various products and services. The GST is a consumption tax levied on the value added to goods and services at each stage of production and distribution.
Our reverse GST calculator uses the formula: Base Amount = Inclusive Amount ÷ (1 + GST Rate/100) to determine the original price from GST-inclusive amounts.
You can quickly work out the cost of a product excluding GST by dividing the price of the product including GST by 11. This will give you the amount of GST applied to the product. You then multiply that figure by 10 to calculate the value of the product excluding GST.
Any amount payable under reverse charge shall be paid by debiting the electronic cash ledger. In other words, reverse charge liability cannot be discharged by using input tax credit. However, after discharging reverse charge liability, credit of the same can be taken by the recipient, if he is otherwise eligible.