How to do a reverse GST calculation?

Editorial team Published on

Reverse GST calculation removes the tax component from a gross price to find the original base price. Use the formula: Base Price = Gross Amount / (1 + (GST Rate / 100)). For an 18% rate, divide by 1.18. The tax amount is found by subtracting the base price from the gross amount.

How to do reverse calculation of GST?

Reverse GST Calculation Example

  1. Gross Amount: Rs.1,300.
  2. GST Rate: 12%
  3. Divisor: 1.12 (since 1 + 0.12)
  4. Base Amount: Rs.1,160.71 (Rs.1,300 / 1.12)
  5. Total GST Amount (Integrated tax/IGST): Rs.139.29 (Rs.1,300 - Rs.1,160.71)

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.

What is the formula for reverse GST calculation 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 do you do a reverse calculation?

Identify what percentage of the original amount you now have. If it has been increased by a percentage, add that percentage onto 100% . If it has been decreased by a percentage, subtract that percentage from 100% . Write down the percentage and put it equal to the amount you have been given.

EN | How to Calculate Reverse tax calculation | Inclusive tax | Exclusive tax #msexcel #exceltips

29 related questions found

How do you calculate GST backwards?

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.

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.

Is 18% GST completely removed?

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.

How to calculate 20% backwards?

To calculate 20% backwards (find the original amount before a 20% decrease), divide the given final amount by 0.80 (which is 100% - 20%). For a 20% increase, divide the final amount by 1.20 (100% + 20%) to find the original. This method works by finding what percentage the final number represents (80% for a decrease, 120% for an increase) and then dividing to find the 100% base.

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.

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 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 tax calculation?

Answer: Reverse sales ' is the process of determining the pre-' amount from a total price that includes sales '. It is calculated by dividing the total amount by (1 + sales ' rate). For example, if the total amount is $107.50 and the sales ' rate is 7.5%, the pre-' amount is calculated as $107.50 / 1.075 ≈ $100.

Why is reverse GST needed?

Reverse Charge Mechanism (RCM) is a provision under GST where the liability to pay tax is on the buyer of goods or services instead of the seller. This method helps the government cover transactions prone to tax evasion or difficult to monitor.

What are the 4 types of GST?

Types of GST in India

CGST (Central Goods and Services Tax) SGST (State Goods and Services. IGST (Integrated Goods and Services Tax) UTGST (Union Territory Goods and Services Tax)

What is the new rule of GST in July 2025?

Barring of GST Return on expiry of three years

The GST network issued another advisory on 7th June 2025, implementing the rule of time-barring of GST return filing beyond three years from the due date. By this update, taxpayers will not be able to file GST returns after three years from the due date of such return.

What is 50000 including GST 18%?

Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.

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.

What does +GST mean on a quote?

Goods and Services Tax (GST)

GST is an additional 10% tax which applies to goods and services. GST is ordinarily included in invoices. However, you may be unsure as to whether your business also needs to provide it on quotes.

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.

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.

What are common reverse GST calculation mistakes?

7 Common Mistakes to Avoid in Calculating GST Backwards

  • Manual Input Error. ...
  • Incorrect ITC Claims. ...
  • Not Filing Nil Returns. ...
  • GST Payment Under an Incorrect Head. ...
  • Inaccurate RCM Categorisation and Filing. ...
  • Not Reconciling GSTR-1 with GSTR-3B. ...
  • Accurate Tax Slab Calculation.