What is the Formula for Calculating GST? In 2025

Learn What is the Formula for Calculating GST in India in 2025 with simple steps, ratio methods, and Excel tips. Master reverse GST calculations and FAQs for seamless tax compliance.

What is the Formula for Calculating GST?

GST (Goods and Services Tax) is a unified indirect tax system in India that replaced multiple cascading taxes. Understanding how to calculate GST is essential for businesses, students, and taxpayers. This article simplifies GST formulas, explains the ratio method, reverse calculations, and even Excel tips for hassle-free tax computation.

Whether you’re a small business owner or a student preparing for exams, this guide will help you master GST calculations with practical examples. Let’s dive in!

What is the GST Ratio Method?

The GST ratio method is a simplified way to calculate GST when the total amount (including GST) is known. It uses predefined ratios based on GST rates to split the total amount into the original price and GST.

For example:

• If the GST rate is 5%, the ratio of GST to the total amount is 1:21.
• For 12% GST, the ratio is 3:28.
• For 18% GST, it’s 9:59.
• For 28% GST, the ratio is 7:32.

This method is handy for quick mental calculations, especially in retail or small businesses.

How Do You Calculate GST Formula?

The basic GST formula depends on whether you’re calculating GST on the original amount or from the total amount.

Formula 1: Calculating GST on the Original Price

If you know the original price (before GST), use this formula:
GST Amount = Original Price × (GST Rate / 100)
Total Price = Original Price + GST Amount

Example:
Original Price = ₹1,000
GST Rate = 18%
GST Amount = ₹1,000 × 0.18 = ₹180
Total Price = ₹1,000 + ₹180 = ₹1,180

Formula 2: Calculating GST from the Total Price

If the total price (including GST) is known, use:
Original Price = Total Price / (1 + GST Rate / 100)
GST Amount = Total Price – Original Price

Example:
Total Price = ₹1,180
GST Rate = 18%
Original Price = ₹1,180 / 1.18 = ₹1,000
GST Amount = ₹1,180 – ₹1,000 = ₹180

How to Find GST Formula

Let’s break down GST calculation into simple steps:

1. Identify the GST Rate: Check if the product falls under 5%, 12%, 18%, or 28% GST.
nnnn
2. Choose the Right Formula: Use Formula 1 if the original price is known or Formula 2 if the total price is known.
nnnn
3. Apply the Formula: Plug in the numbers and calculate.

Pro Tip: Use a GST calculator app or Excel to avoid manual errors.

Why Do You Divide by 11 to Find GST?

This question often confuses people. Dividing by 11 is a shortcut for calculating GST when the rate is 10%. Here’s why:

If the GST rate is 10%, the total price becomes 110% of the original price. To find the GST amount:
GST = Total Price × (10 / 110) = Total Price / 11

Example:
Total Price = ₹1,100
GST = ₹1,100 / 11 = ₹100

This method works only for a 10% GST rate. For other rates, use the formulas explained earlier.

Why Do You Divide by 1.1 for GST?

Dividing by 1.1 is another way to reverse-calculate GST for a 10% rate. Here’s how:

Original Price = Total Price / 1.1

Example:
Total Price = ₹1,100
Original Price = ₹1,100 / 1.1 = ₹1,000

This formula adjusts the total price to exclude the 10% GST.

How to Reverse Calculate GST

Reverse GST calculation helps find the original price or GST amount when only the total price is known.

Steps for Reverse Calculation:

1. Note the Total Price: E.g., ₹2,360.
2. Identify the GST Rate: Assume 18%.
3. Use Formula 2:
   Original Price = ₹2,360 / 1.18 = ₹2,000
   GST Amount = ₹2,360 – ₹2,000 = ₹360

This method is crucial for businesses filing returns or reconciling invoices.

How to Do Reverse Calculation in Practical Scenarios

Imagine you bought a smartphone for ₹23,600 (including 18% GST). To find the original price:

1. Total Price: ₹23,600
2. GST Rate: 18%
3. Original Price: ₹23,600 / 1.18 = ₹20,000
4. GST Paid: ₹23,600 – ₹20,000 = ₹3,600

This helps track expenses or claim input tax credits.

How to Calculate GST Without Amount

If you don’t have the original or total amount, you can still estimate GST using ratios or percentages.

Example:

• GST Rate = 12%
• Ratio of GST to Original Price = 12:100
• Ratio of GST to Total Price = 12:112

Use these ratios to split amounts proportionally.

How to Calculate GST Without Total in Excel

Excel simplifies GST calculations. Here’s a step-by-step method:

1. Enter Original Price in Cell A1: E.g., ₹5,000.
2. Enter GST Rate in Cell B1: E.g., 18%.
3. Calculate GST Amount in Cell C1: =A1*B1
4. Calculate Total Price in Cell D1: =A1+C1

For reverse calculation (total price known):

1. Enter Total Price in Cell A2: E.g., ₹5,900.
2. Original Price Formula in Cell B2: =A2/(1+18%)
3. GST Amount in Cell C2: =A2-B2

GST Calculation Table for Quick Reference

Conclusion

Mastering GST calculations is a valuable skill for businesses, professionals, and even everyday taxpayers in India. Whether you’re determining the GST amount from the original price, using the ratio method for quick estimates, or reverse-calculating GST from the total, these formulas simplify compliance and financial planning.

Understanding why we divide by 11 or 1.1 for specific GST rates, leveraging Excel for automated calculations, and applying reverse GST techniques can save time and reduce errors. With the examples, tables, and step-by-step guides provided in this article, you’re now equipped to handle GST calculations confidently.

Remember, GST rates and regulations may evolve, so always cross-check the latest updates from official sources like the GST portal. For more practical guides, explore our articles on GST State Codes List and Latest GST Rate Changes 2025.

Stay informed, stay compliant, and let numbers work for you!

FAQs