What is the GST calculation formula?

Asked by: Kali McClure  |  Last update: August 19, 2026
Score: 4.3/5 (6 votes)

GST calculation formulas depend on whether the tax is being added to a base price or removed from a total amount. Key formulas include:

How to GST calculation formula?

GST Amount = (Selling Price x GST Rate) / 100. Here, the Selling Price is determined by adding the Cost Price and Profit Amount.

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.

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

GST Formula in Excel | How to Calculate GST - Australia & India

35 related questions found

How to calculate 5% GST from a 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 much is the GST on 20000?

Assume you bought a phone for ₹20,000; the GST levied on the product is 18%. On entering these details on the online calculator, the calculator displays the results as follows: Cost of Good/Service - ₹16,949. Total GST - ₹3,050.

What is a 5% GST?

Canadian goods and services tax (GST) is a 5% value added tax that must be paid on most goods and services in Canada. The rules surrounding the application of GST in Canada cover a range of areas including: Invoice requirements. Foreign currency treatment and rates.

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 I calculate 18 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.)

What is the GST rate today?

The 18% GST rate is now the new standard rate, applying to a wide range of goods and services.

How is VAT calculated?

Total price including VAT - Standard Rate

To work out the total price at the standard rate of VAT (20%), multiply the original price by 1.2. To calculate the reduced VAT rate (5%), multiply the original price by 1.05.

How to calculate percentage?

To calculate a percentage, divide the "part" by the "whole" and then multiply the result by 100; the formula is (Part / Whole) x 100. For example, to find what percentage 20 is of 50, you'd do (20 / 50) x 100, which equals 40%. 

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.

What exactly is GST tax?

The generation-skipping transfer (GST) tax is imposed on transfers to grandchildren and more remote descendants that exceed the exemption limits so transferors cannot avoid transfer taxes on the next generation by "skipping" a generation.

What will be 40% GST?

The key categories of goods and services included under the special 40% GST slab are, Tobacco and related intoxicants as sin goods (e.g., cigarettes, bidis, pan masala, caffeinated drinks) Drinks with high sugar content and caffeinated. Super-luxury and luxury 4-wheelers, 2-wheelers and personal use yacht, aircraft, ...

How much is 10% GST?

GST Formula

Adding 10% to the price is relatively easy (just multiply the amount by 1.1), reverse GST calculations are quite tricky: To figure out how much GST was included in the price you have to divide the price by 11 ($110/11=$10);

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 calculate a 7% tax?

To calculate 7% tax, convert the percentage to a decimal (0.07) and multiply it by the original price to find the tax amount, then add that to the original price for the total cost, or simply multiply the price by 1.07 for the total cost directly. For example, on a $50 item, the tax is $3.50 ($50 x 0.07), making the total $53.50.