To calculate GST backwards from a GST-inclusive price, divide the total price by $1 + \text{GST rate} (e.g., divide by 1.10 1 . 1 0 for a 10 % 1 0 % rate) to find the original amount. To find the specific GST amount, divide the total price by 11 1 1 (for 10 % 1 0 % GST) or use the formula: Total Price − Net Price T o t a l P r i c e − N e t P r i c e .
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.
Formula Behind Financial Sales Tax Reverse Calculator
The formula is: Base Price = Total Price / (1 + (Tax Rate ÷ 100)). Total Price is the tax-inclusive amount; Tax Rate is the applicable percentage. This calculation instantly gives you both the pre-tax price and the actual tax paid.
The Excel sales tax decalculator works by using a formula that takes the following steps:
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.
You can quickly work out the cost of a product excluding GST by dividing the price of the product including GST by 11. This will give you the amount of GST applied to the product. You then multiply that figure by 10 to calculate the value of the product excluding GST.
Example of Reverse GST Calculation
You can use the Cleartax reverse GST calculator to break down a total price into its base price and GST amount. Firstly, divide the GST-inclusive price by (1 + (GST rate/100)) to determine the base price. Lastly, subtract this value from the total price.
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.
Subtracting GST:
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.
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.
Reverse Charge means the liability to pay tax is on the recipient of supply of goods or services instead of the supplier of such goods or services in respect of notified categories of supply. There are two type of reverse charge scenarios provided in law.
Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.
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.
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.
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.
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. That's a lot of manual work for small-business owners to do every time they want o calculate GST—use our calculator instead.
So, if the final price of a good is ₹1000 and GST is charged at 18%, then the base price before GST will be: ₹1000 / (1 + 0.18) = ₹1000 / 1.18 = ₹847.46 (round off) and the total GST charged is ₹152.54.
Shortcut, when sales tax is 6.25% divide the total by 1.0625 to calculate the the list price before tax.
How can I calculate Reverse GST using Excel? In Excel, you can calculate the base price using: =Total Price / (1 + GST Rate/100) . To get the GST amount, subtract the base price from the total price. Create columns for GST rate, total price, base price, and GST amount to automate the process.
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