What is the formula for removing GST?

Asked by: Gerry Nikolaus  |  Last update: September 13, 2026
Score: 4.3/5 (18 votes)

To remove GST from a total price, divide the GST-inclusive amount by 1 + ( GST rate ÷ 100 ) 1 + ( G S T r a t e ÷ 1 0 0 ) . The formula for the base (original) price is: Base Price = GST Inclusive Price 1 + ( GST Rate / 100 ) B a s e P r i c e = G S T I n c l u s i v e P r i c e 1 + ( G S T R a t e / 1 0 0 ) . To find the GST amount, subtract the base price from the total price, or multiply the total by GST Rate 100 + GST Rate G S T R a t e 1 0 0 + G S T R a t e .

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 to remove 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.

What's the calculation to remove 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.

What is the Formula for GST extraction?

GST Amount = (Selling Price x GST Rate) / 100. Here, the Selling Price is determined by adding the Cost Price and Profit Amount.

GST Formula in Excel | How to Calculate GST - Australia & India

27 related questions found

How to pull GST out of total?

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.

How to take out output GST?

All you have to do is multiply the total taxable value of your business-related purchases with the GST rate.

What is a reverse GST calculator?

Reverse GST Calculator is a mathematical-based financial tool that determines the bill amount of goods and services, excluding tax. This tool helps in figuring out the pre-tax cost on the basis of the GST-inclusive amount and an applicable GST slab rate.

What's the formula for calculating GST?

To work out the cost including GST, you multiply the amount exclusive of GST by 1.1. You divide a GST inclusive cost by 11 to work out the GST component. A taxable sale must be: for payment of some kind.

How to remove GST from total amount in Excel?

If you need to take GST off a total price, use the formula = Price / (1 + GST rate). For example, if the total price is ₹118, you'd type = 118 / 1.18 to find the original price before GST.

How do I subtract GST in Excel?

Removing GST with Constant Rate from the Total Amount

The price with GST includes both the price and the GST. If the GST rate is 10%, the price we have now is 110% of the original price. That is why we need to divide the price with GST in D2 cell by 110, and then multiply the result by 100 to get the price without GST.

Why do you divide by 1.1 for GST?

For example, if the GST-inclusive price is $110, dividing by 1.1 would give a GST-exclusive price of $100. Accurate subtraction of GST from a price ensures businesses report the correct GST amounts on their tax invoices and Business Activity Statements (BAS).

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 do I remove GST from total amount?

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.

How do you remove 18% GST from a total?

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 is the GST calculator?

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.

How to learn GST step by step?

Beginner's Guide to GST

  1. BASICs OF GST. (Chapter 1) Goods and Service Tax (GST) is applicable in India from 1st July 2017. ...
  2. Registration. (Chapter 2) ...
  3. Composition Scheme. (Chapter 3) ...
  4. Invoicing. (Chapter 4) ...
  5. Input tax Credit. (Chapter 5) ...
  6. Reverse charge mechanism. (Chapter 6) ...
  7. Payment of GST. (Chapter 7) ...
  8. E-way Bill. (Chapter 8)

How to remove 5% GST from total amount?

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.

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.

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 remove GST from a product?

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)

What is the 1% rule of GST?

✔ If monthly taxable turnover > ₹50 lakh (excluding exempt and zero-rated supplies), ✔ Minimum 1% of GST liability must be paid in cash, ✔ The remaining 99% may be paid through ITC. Applicable to registered persons under GST whose monthly taxable supply exceeds ₹50 lakh.

What is the reversal of output tax in GST?

Reversal of ITC means the credit of inputs utilised earlier would now be added to the output tax liability, effectively nullifying the credit claimed earlier. Depending upon when such reversal is done, payment of interest may also be required.