Reverse GST calculation removes the tax component from a gross price to find the original base price. Use the formula: Base Price = Gross Amount / (1 + (GST Rate / 100)). For an 18% rate, divide by 1.18. The tax amount is found by subtracting the base price from the gross amount.
Reverse GST Calculation Example
Example
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.
Identify what percentage of the original amount you now have. If it has been increased by a percentage, add that percentage onto 100% . If it has been decreased by a percentage, subtract that percentage from 100% . Write down the percentage and put it equal to the amount you have been given.
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 do you remove GST? The equation to subtract GST is slightly more complicated: First, take the GST-inclusive price and multiply that by 3. Then, divide the result by 23 and round that number to the nearest two decimal points.
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.
To calculate 20% backwards (find the original amount before a 20% decrease), divide the given final amount by 0.80 (which is 100% - 20%). For a 20% increase, divide the final amount by 1.20 (100% + 20%) to find the original. This method works by finding what percentage the final number represents (80% for a decrease, 120% for an increase) and then dividing to find the 100% base.
Example of reverse charge mechanism under GST
Suppose a GST-registered dealer buys goods worth INR 10,000 from an unregistered supplier. In this case, the dealer has to raise a self-invoice and pay INR 1,200 as GST (calculated at 12% of INR 10,000) under the reverse charge mechanism.
Reverse Sales Tax Calculations:
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.
Answer: Reverse sales ' is the process of determining the pre-' amount from a total price that includes sales '. It is calculated by dividing the total amount by (1 + sales ' rate). For example, if the total amount is $107.50 and the sales ' rate is 7.5%, the pre-' amount is calculated as $107.50 / 1.075 ≈ $100.
Reverse Charge Mechanism (RCM) is a provision under GST where the liability to pay tax is on the buyer of goods or services instead of the seller. This method helps the government cover transactions prone to tax evasion or difficult to monitor.
Types of GST in India
CGST (Central Goods and Services Tax) SGST (State Goods and Services. IGST (Integrated Goods and Services Tax) UTGST (Union Territory Goods and Services Tax)
Barring of GST Return on expiry of three years
The GST network issued another advisory on 7th June 2025, implementing the rule of time-barring of GST return filing beyond three years from the due date. By this update, taxpayers will not be able to file GST returns after three years from the due date of such return.
Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.
Net price = Original cost – GST
For example, if the cost of a product after GST of 18% is Rs. 118, its original cost is 118 – [100/(100 + 18%)}], which equates to Rs. 100.
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.
Excel Formula to Remove the GST amount from a Total
If you have a GST-inclusive total and need to calculate the GST-exclusive amount (i.e., remove GST), divide the Total figure by 1.15.
Reverse Charge Rules for Business-to-Business (B2B) Transactions. When intangible services are supplied by a foreign provider to an Australian business (rather than a consumer), GST may not be charged by the overseas supplier. Instead, the reverse charge mechanism applies.
7 Common Mistakes to Avoid in Calculating GST Backwards