How to calculate GST from a total amount?

Asked by: Beatrice Gibson  |  Last update: July 8, 2026
Score: 4.6/5 (2 votes)

To calculate the Goods and Services Tax (GST) from a total amount (inclusive of tax), divide the total amount by (1 + GST rate) to find the base amount, then subtract the base from the total. The formula is: GST Amount = Total Amount − [ Total Amount ÷ ( 1 + GST Rate in Decimal ) ] G S T A m o u n t = T o t a l A m o u n t − [ T o t a l A m o u n t ÷ ( 1 + G S T R a t e i n D e c i m a l ) ] .

How do you calculate GST on a total amount?

For example, if a product or service costs Rs. 100 and the GST levied on that is 18%, the GST amount will be 100 x 18% = Rs. 18. The net amount you'd have to pay would be Rs. 118.

How do you reverse GST from total?

To determine the Reverse GST value, you need to calculate the amount of Base Price or the amount exclusive of GST. This can be done by using the formula given below. Once you have the base price, you can further calculate the Reverse GST amount by subtracting it from the GST-inclusive amount.

How do you calculate GST from a total?

If you have a GST-inclusive sales price and wish to calculate the 15% GST component of the total price, you can either divide it by 1.15 or follow this formula: Multiply the total sales price by 3. Divide the result by 23.

How to calculate 10% GST from total?

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.

how to calculate gst amount from total amount in excel

34 related questions found

What is the formula used in GST calculation?

What is the formula of GST? The formula for calculating GST is to multiply the net price (exclusive of GST) by 1.1 or divide the price including GST by 11 to determine the GST component.

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.

Why do you divide by 11 to get GST?

GST (Goods and Services Tax) is a 10% tax applied to most goods and services sold in Australia. Think of it as the government's slice of the pie—exactly one-eleventh (1/11th) of the total price including GST.

How do you calculate 5% GST from total amount?

First method. Let's say before GST, your subtotal is x dollars. Then the total is this amount (x) PLUS the gst amount (5% of x). So the Total = x + 5%(x) = 1x + 0.05x = 1.05x, because 5% means 0.05.

How do I figure out my GST?

The normal method for GST is subtracting the amount you paid on purchases (aka ITCs) from what you collected on your sales. This is the amount you must remit to CRA or if you paid more GST on your purchases than you collected on sales, CRA will send you a refund.

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

What is the GST of $1000?

Adding GST to Price

To calculate the amount of GST to add to a price, multiply the price by 0.1 (10% in Australia, $1000✕0.1=$100). Then, to calculate the price inclusive of GST, multiply the original price by 1.1 ($1000✕1.1=$1100).

How to make a reverse calculation of GST?

Reverse Charge Mechanism & Calculation

  1. Formula: Base Amount = Inclusive Amount ÷ (1 + GST Rate/100)
  2. RCM: Recipient pays GST instead of supplier.
  3. Split: For intra-state: CGST + SGST | For inter-state: IGST. Our reverse GST calculator automatically handles RCM compliance calculations.

How do you calculate reverse tax?

Formula Behind Financial Sales Tax Reverse Calculator

The formula is: Base Price = Total Price / (1 + (Tax Rate ÷ 100)). Total Price is the tax-inclusive amount; Tax Rate is the applicable percentage. This calculation instantly gives you both the pre-tax price and the actual tax paid.

How to separate GST from total value?

Calculating GST from the Amount Including GST

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

What are common GST mistakes to avoid?

  • Not registering for GST at the right time, or not deregistering when the business ceases. ...
  • Not putting money aside for GST. ...
  • Reporting purchases of capital items with the wrong tax code. ...
  • Claiming GST on all expenses. ...
  • GST on leasing and hire purchase. ...
  • GST on buying second-hand goods. ...
  • Claiming GST on private expenses.

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.

Is a GST calculator free to use?

With the free GST calculator, you can calculate the tax amount in three simple steps. The tool provides you with three fields that have to be filled, and it calculates GST automatically based on what you fill in. Enter the price of the goods or services in the Amount field.

Why do you divide GST by 11?

The value of a taxable supply is the consideration payable for the supply (before GST is added). For example, if the value of the supply is $100, the GST payable is 10 percent of $100, being $10. The price GST inclusive of the supply is $110. To work out the GST paid, you can divide by 11.

How to calculate 18% GST on 20,000?

Example:

  1. • GST Amount = (₹20,000 x 18) / 100 = ₹3,600.
  2. • Total Price = ₹20,000 + ₹3,600 = ₹23,600.
  3. GST Amount = (Original Price × GST%) / 100.
  4. Net Price = Original Price + GST Amount.
  5. GST Amount = Original Price − (Original Price × (100 / (100 + GST%)))
  6. Net Price = Original Price − GST Amount.
  7. Original Price: ₹15,000.

What is the formula to calculate GST in Excel?

Apply the GST Formula Use a formula like = B2 - B2 / 1.15 for a 15% tax rate to calculate the GST amount. Adjust as needed for different tax rates. (This approach works similarly for other tax rates—just replace 1.15 with 1 + (GST Rate/100). For example, if the GST rate is 18%, use 1.18 instead.)

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.

How to reverse sales tax 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).
 

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.