How to calculate reverse GST formula?

Asked by: Benny Dicki  |  Last update: June 8, 2026
Score: 4.9/5 (71 votes)

Reverse GST is calculated to find the original price before tax from a GST-inclusive amount. Use the formula: Base Price = Gross Amount / (1 + GST Rate/100). For example, on a ₹1,180 item at 18% GST: ₹1,180 / 1.18 = ₹1,000 base price, with a GST amount of ₹180.

What is the formula for reverse GST calculation?

Determine the Divisor: Convert the GST rate into decimal form and add 1. Example: For 18%, the divisor is 1 + 0.18 = 1.18. Calculate the Base (GST Exclusive) Amount: Divide the gross amount by the divisor Base Amount = Gross Amount ÷ (1 + GST Rate/100)

How to backwards calculate GST?

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.

How do I remove 18% GST from my total amount?

Example

  1. GST Amount = ₹1,180 - (₹1,180 / (1 + (18/100))) = ₹180.
  2. Amount Excluding GST = ₹1,180 - ₹180 = ₹1,000.

Is a reverse GST calculator accurate?

Calculating reverse GST is important because it allows you to determine the GST-exclusive price from a GST-inclusive amount and arrive at an accurate tax amount.

GST REVERSE CALCULATION IN MS Excel

39 related questions found

What is the formula for removing GST?

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.

How do you calculate reverse tax?

Reverse Sales Tax Calculations:

  1. Price before Tax = Total Price with Tax - Sales Tax.
  2. Sales Tax Rate = Sales Tax Percent / 100.
  3. Price before Tax = Total Price with Tax / (1 + Sales Tax Rate)
  4. Sales Tax = Price before Tax x Sales Tax Rate.

What is reverse charge in GST with example?

Example of reverse charge mechanism under GST

Suppose a GST-registered dealer buys goods worth INR 10,000 from an unregistered supplier. In this case, the dealer has to raise a self-invoice and pay INR 1,200 as GST (calculated at 12% of INR 10,000) under the reverse charge mechanism.

What is GST reversal with an example?

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.

How to reverse calculate GST in Excel?

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.

How to calculate GST backward?

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.

When to reverse charge GST?

Reverse Charge Rules for Business-to-Business (B2B) Transactions. When intangible services are supplied by a foreign provider to an Australian business (rather than a consumer), GST may not be charged by the overseas supplier. Instead, the reverse charge mechanism applies.

How to calculate reverse GST with example?

Example of Reverse GST Calculation

  1. Total Amount: ₹1,000.
  2. GST Rate: 18%
  3. Divisor: 1.18 (since 1 + 0.18)
  4. Base Amount: ₹847.46 (₹1,000 / 1.18)
  5. GST Amount: ₹152.54 (₹1,000 - ₹847.46)

How is reverse charge calculated?

2. How is RCM calculated? RCM is calculated based on the applicable GST rates using the formula: (Value of Goods/Services) x (Applicable GST Rate). You can also make use of the GST calculator online to get the GST rate of the product or services.

What is rcm in simple words?

RCM stands for Reverse Charge Mechanism. It is a rule in the GST (Goods and Services Tax) system where the buyer, not the seller, pays the tax to the government. Usually, sellers collect tax and give it to the government, but under RCM, this process is reversed.

How to find reverse charge in GST?

Reverse Charge Mechanism under GST is a mechanism under which the usual cycle of tax payment is reversed. Under Reverse Charge, the recipient pays to the supplier an amount exclusive of GST, the recipient then pays the GST directly to the Government. RCM is a complex concept that works in select scenarios only.

How to reverse 20% tax?

Subtracting VAT from a Price

  1. If you know the VAT rate, divide the gross amount by (1 + VAT Rate).
  2. Formula: Net Amount = Gross Amount / (1 + VAT Rate).
  3. Example: If the gross amount is £120 and the VAT rate is 20%, then Net Amount = £120 / 1.20 = £100.

How to remove 18% GST from total amount?

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.

How to take away GST from price?

Subtracting GST:

  1. To calculate how much GST is included in a price, just divide by 11.
  2. To calculate how much the price was before GST, just divide by 1.1.

What is the formula for removing GST in Excel?

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.