How to exclude GST?

Asked by: Eunice Haley  |  Last update: July 15, 2026
Score: 4.2/5 (29 votes)

To exclude GST (commonly 10% in Australia or 15% in NZ) from a total price, divide the GST-inclusive amount by 1 + ( GST rate as a decimal ) 1 + ( G S T r a t e a s a d e c i m a l ) . For a 10% rate, divide by 1.1 1 . 1 . To find only the GST amount, divide the total price by 11.

How to remove 18% from total amount?

To remove 18% GST from the total amount, divide the total amount by 1.18. For example, if the total amount is ₹11,800, the base price will be 11900/1.18 = ₹10,000.

How to work out excluding GST?

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.

Is there any way to avoid GST?

Claim the GST Refunds

If the SMB is exporting goods or services or providing them to SEZ, or if the SMB has accumulated ITC as a result of the inverted duty structure, the SMB may submit a refund application with the GST Department and claim the refund.

How to exclude GST from total amount 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.

how to calculate gst amount from total amount in excel

19 related questions found

How to remove GST from total 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. Yes, you can use the reverse GST calculator for all GST types—CGST, SGST, and IGST.

How to take GST off a total amount?

How do you remove GST?

  1. First, take the GST-inclusive price and multiply that by 3.
  2. Then, divide the result by 23 and round that number to the nearest two decimal points.
  3. Finally subtract that from the GST-inclusive price:

How to waive GST?

1. Login into GST portal: Navigate to > Services > User Services > My Applications. 2. On Navigating to 'My Applications' page, the taxpayer has to select 'Apply for Waiver Scheme under Section 128A' option under 'Application type' dropdown.

Can I opt out of GST?

The registration granted under GST can be cancelled for specified reasons. The cancellation can either be initiated by the department on their own motion or the registered person can apply for cancellation of their registration. In case of death of registered person, the legal heirs can apply for cancellation.

How can you be exempt from GST?

Customers do not pay GST on goods and services that are GST‑free such as basic food, many medical and health services, some education courses, childcare, certain medical aids, and exports.

What is the formula to take GST out of total amount?

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.

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).

How do you remove VAT from an amount?

To remove Value Added Tax or to make a reverse VAT calculation the formula is the following: Net: (Amount / 120) * 100 Easy! Divide the amount by 100 + VAT% and then multiply by 100.

How do I subtract GST from a total?

Subtracting GST

To work out how much GST is included in a total price, divide the price by 11. If you want the total price before GST was added, divide by 1.1.

What items are exempt from GST?

List of exempted goods under GST in India:

  • Food. ...
  • Raw materials. ...
  • Tools/Instruments. ...
  • Miscellaneous. ...
  • Agricultural services. ...
  • Transportation services.
  • Services provided by the government and diplomatic missionaries.
  • Judicial services.

How to pull tax out of a total?

The Excel sales tax decalculator works by using a formula that takes the following steps:

  1. Step 1: take the total price and divide it by one plus the tax rate.
  2. Step 2: multiply the result from step one by the tax rate to get the dollars of tax.
  3. Step 3: subtract the dollars of tax from step 2 from the total price.

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.

How to discontinue GST?

How can I file for cancellation of GST registration?

  1. Visit the URL: https://www.gst.gov.in.
  2. Login to the GST Portal with your user-ID and password.
  3. Navigate to the Services > Registration > Application for Cancellation of Registration option.
  4. The form - Application for Cancellation of Registration contains three tabs.

Who is exempt from paying GST?

Answer: If turnover of the entity is less than the limit of Rs. 20 lakhs in a financial year, no tax would be payable. The exemption from payment of tax is applicable to services provided to a business entity having a turnover up to Rs. 20 lakh rupees.

What qualifies for GST exemption?

The GST/HST break includes certain qualifying goods, such as:

  • Food.
  • Beverages.
  • Children's clothing and footwear.
  • Children's diapers.
  • Children's car seats.
  • Certain children's toys.
  • Jigsaw puzzles.
  • Video game consoles, controllers, and physical video games.

How to skip GST?

Exports and supplies to SEZs are classified as zero-rated supplies, meaning no GST is charged on them. Yet importantly, the supplier can still claim a refund of unutilised input tax credit—either by exporting under a bond/Letter of Undertaking (LUT) without paying IGST or by paying IGST and claiming the refund later.

Are NRIs exempt from GST in India?

Non-resident Indians have the same rights as Indian citizens when it comes to Goods and Services Tax (GST) exemptions. If a Non-Resident Indian meets the criteria set out in the applicable law, he/she can avail of this benefit.

How much GST is in $100?

Example: If the pre-GST price is $100 and the GST rate is 10%, the GST amount is $100 x 10% = $10. Total price: To find the total price, add the GST amount to the pre-GST price: $100 + $10 = $110.

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.

How is GST different from sales tax?

VAT/GST is levied at each stage of production and distribution, while sales tax is only applied at the final sale to the end consumer. Sales tax tends to be a more regressive tax, as it applies to a broader range of goods and services, regardless of their luxury or necessity.