How to take GST off a total amount?

Asked by: Kamron Pfannerstill  |  Last update: June 17, 2026
Score: 5/5 (34 votes)

To take GST off a total amount (reverse calculate), divide the total price by 1 + ( GST rate ÷ 100 ) 1 + ( G S T r a t e ÷ 1 0 0 ) . For a 10 % 1 0 % GST, divide by 1.10 1 . 1 0 . For a 5 % 5 % GST, divide by 1.05 1 . 0 5 . The result is the net price (before GST), and subtracting this from the total gives the GST amount.

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 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 calculate sales tax backwards from total?

To calculate sales tax backwards from a total, divide the total price by (1 + the tax rate as a decimal) to get the pre-tax price, then subtract that pre-tax price from the total to find the actual tax amount. For example, for a $108 total with 8% tax, you'd calculate $108 / 1.08 = $100 (pre-tax), and then $108 - $100 = $8 (tax).
 

How do I subtract GST from a total?

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.

How to Calculate GST in Microsoft Excel | GST Calculator in Excel

32 related questions found

How do I take GST off a total?

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:

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.

How do you work out 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.

How do you calculate tax out of a total?

Sales Tax Calculation Formulas

  1. Sales tax amount = original price × sales tax rate as a decimal.
  2. Sales tax rate as a decimal = sales tax percent / 100.
  3. Total price after tax:
  4. Original price before tax = total price after tax / (1 + sales tax rate as a decimal)
  5. Sales tax amount = total price after tax - price before tax.

Is GST 5% or 7%?

The Canadian Goods and Services Tax (GST) is a federal tax set at 5%, but the total sales tax you pay (5% GST + Provincial Sales Tax/PST) can be higher, like 7% (PST) in BC/Manitoba, or combined into a Harmonized Sales Tax (HST) that varies by province, such as 13% in Ontario or 15% in Atlantic provinces. So, GST is always 5%, but the combined rate depends on the province.

How do you calculate $18 GST from a total?

The different slabs for GST are 5%, 12%, 18% and 28%. GST calculation can be explained by a simple illustration : If a goods or services is sold at Rs. 1,000 and the GST rate applicable is 18%, then the net price calculated will be = 1,000+ (1,000X(18/100)) = 1,000+180 = Rs. 1,180.

What is a reverse charge of GST?

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.

How to check GST amount from total amount?

How does the GST calculator work? The GST Calculator operates based on a straightforward formula: GST Amount = (Selling Price x GST Rate) / 100. Here, the Selling Price is determined by adding the Cost Price and Profit Amount.

How to do reverse calculation?

Finding the Reverse Percentage of a number in 3 easy steps.

Step 1) Get the percentage of the original number. If the percentage is an increase then add it to 100, if it is a decrease then subtract it from 100. Step 3) Find 100% of the original number by multiplying the result from Step 2) by 100.

How to remove GST from total amount in Excel without?

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 withdraw GST amount?

To get your GST refund, you will need to apply for it through the GST portal by submitting a refund application form. The application will be processed and verified by the GST department, and if approved, the refund amount will be credited to your bank account.

How to remove GST from total amount with example?

Example

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

How do you calculate sales tax backwards from a total?

To calculate sales tax backwards from a total, divide the total price by (1 + the tax rate as a decimal) to get the pre-tax price, then subtract that pre-tax price from the total to find the actual tax amount. For example, for a $108 total with 8% tax, you'd calculate $108 / 1.08 = $100 (pre-tax), and then $108 - $100 = $8 (tax).
 

How to remove GST?

How do I subtract GST from a total price? To subtract GST from a GST-inclusive price, divide the total amount by 1.1. If you want a faster method, you can input your figures into our Australian GST calculator, and it will give you the GST-exclusive price instantly.

How to remove GST from a total?

$115 X 3 ÷ 23 = $15 GST

To work out the GST exclusive amount simply subtract the GST from the GST inclusive amount to get the original GST exclusive cost.

How to calculate GST from full amount?

GST is a broad-based tax of 10% on most goods, services and other items sold or consumed in Australia. To work out the cost of an item including GST, multiply the amount exclusive of GST by 1.1. To work out the GST component, divide the GST inclusive cost by 11.

What is the formula to work out VAT backwards?

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. That's the amount excluding VAT taxes (Net amount).

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 do I remove tax from a total?

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.

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.