How to calculate total amount including GST?

Asked by: Mr. Maurice Abbott  |  Last update: October 20, 2026
Score: 4.5/5 (23 votes)

To calculate the total amount including GST, multiply the original cost by ( 1 + GST Rate 100 ) ( 1 + G S T R a t e 1 0 0 ) . Alternatively, add the calculated GST amount ( Original Cost × GST Rate 100 ) ( O r i g i n a l C o s t × G S T R a t e 1 0 0 ) to the original cost. For example, if the cost is ₹ 1 , 000 1 , 0 0 0 and GST is 18%, the total is 1000 × 1.18 = ₹ 1 , 180 1 0 0 0 × 1 . 1 8 = 1 , 1 8 0 .

What is the formula for total amount including GST?

GST Amount = (Selling Price x GST Rate) / 100. Here, the Selling Price is determined by adding the Cost Price and Profit Amount. The calculator factors in the Selling Price, representing the total value of goods or services subject to GST, and the GST rate, which fluctuates based on the nature of the goods or services.

How do you calculate total including 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 calculate GST reverse?

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 to find total bill amount including GST?

For adding GST, the following formula is used. 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 to Calculate Taxable Amount from TAX Amount and TAX Rate in Excel

38 related questions found

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.

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

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 much is the GST on $1000?

Therefore, the GST amount of $1000 is $100. which means for every $1000 spent, an additional $100 is paid as GST in Australia.

How to calculate total including tax?

Calculating the sales tax applied to a purchase is a matter of simply multiplying the tax rate by the purchase price using the equation sales tax = purchase price x sales tax rate. Adding the sales tax to the original purchase price gives the total price paid with tax.

Why do we divide by 11 for GST?

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

Is there a simple formula for GST calculation?

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 add GST to a total?

To add GST to a product or service, you divide the original price by 100, then multiply that number by 15. You then add that number to the original price.

How do you calculate GST in Excel with example?

Enter Relevant Data Input GST-inclusive prices (e.g., INR 115) in the respective column. 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.

How to calculate GST on total amount?

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.

How to calculate sales tax backwards from total excel?

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.

What is the formula for reverse GST?

Formula to Calculate Reverse GST with Example

Base Price is equal to 100 / (100 + Value of an applicable GST Rate) * GST Inclusive Amount. After obtaining the base price, you can deduct it from the GST-inclusive amount to determine the Reverse GST amount.

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.

What is the formula for reverse sales tax?

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 calculate VAT on a calculator?

Adding VAT using a calculator is pretty straight forward, you first need to work out the “VAT fraction”. You do this by taking your VAT rate, divide by 100 then add 1. An example of this using a 20% VAT rate would be 20/100 = 0.2 + 1 = VAT fraction OF 1.2.

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.