How to calculate GST only?

Asked by: Prof. Ned Cremin  |  Last update: August 9, 2026
Score: 4.1/5 (63 votes)

To calculate just the GST amount from a total price (GST inclusive), use the formula: GST Amount = Total Price ÷ (100 + GST Rate) x GST Rate. If you have the price before GST (exclusive), the formula is simpler: GST Amount = Price (exclusive) x GST Rate / 100, then add that to the original price to get the total.

What is the formula for calculating GST?

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 do you calculate the GST exclusive amount?

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

How do I calculate GST?

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 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 Calculate GST in Microsoft Excel | GST Calculator in Excel

40 related questions found

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

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 they calculate GST?

Assuming $50.00 as the expense, multiply by 0.05 and divide by 1.05 to determine the GST, which is $2.38. (GST = $50/105 X . 05.) When invoicing for a service that is GST applicable, Accounting will include the GST in the total amount to be billed.

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 calculate GST on full invoice amount?

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 GST exclusive amount in Excel?

Let's start by calculating the GST component of a GST-exclusive amount. To do this, multiply the value that excludes GST by 15% or 0.15. To find the total, including GST, add the two values together. In the example below, cell B6 is multiplied by 0.15, the decimal form of 15%.

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.

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 do you calculate GST tax?

Federal estate tax exemption by year

The taxable estate is calculated as the value of the gross estate — the total, fair market value of all its assets — minus certain deductions, like the value of mortgages, debts, and any assets that go to a surviving spouse or qualified charity.

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 to calculate GST using Quick Method?

To calculate the amount of GST/HST to remit, multiply the revenue from your supplies (including the GST/HST) for the reporting period by the quick method remittance rate, or rates, that apply to your situation.

How is 18% GST calculated?

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.

Is GST 5 or 7 percent?

The tax is a 5% tax imposed on the supply of goods and services that are purchased in Canada, except certain items that are either "exempt" or "zero-rated": For tax-free — i.e., "zero-rated" — sales, GST is charged by suppliers at a rate of 0% so effectively there is no GST collected.

Is GST 12% to 18% notification?

2022, Works contract services provided to Central and State Government, or Local Authorities, which were earlier eligible for concessional rate of 12% GST,would attract GST at the rate of 18% in view of amendment carried out in notification No. 11/2017- Central Tax (Rate) vide notification No.

How do I 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.

Why do you divide by 1.2 for VAT?

Net price = Gross price ÷ (1 + VAT rate)

In the UK, the standard VAT rate is 20%, so you'd divide by 1.2. For example, say something costs £120 including VAT. To find the price excluding VAT: £120 ÷ 1.2 = £100 (which means £20 is the VAT).

How to reverse calculate GST with example?

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 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 meant by GST return with example?

GST Return is a document filed by GST-registered businesses containing details of sales, purchases, input tax credit, and taxes payable/paid. Filing is mandatory for all GST taxpayers. Returns must be filed on the GST portal monthly, quarterly, or annually, depending on the taxpayer's classification.