How to reverse calculate GST in Excel?

Editorial team Published on

To reverse calculate GST in Excel, divide the total inclusive amount by ( 1 + GST Rate Percentage ) ( 1 + G S T R a t e P e r c e n t a g e ) to find the base price (e.g., Total / 1.18 for 18% GST). The GST amount is then calculated as the Total Amount minus the Base Price.

How to do reverse calculation of GST?

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)

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 the formula for removing GST in Excel?

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.

How do you calculate 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.

GSTR-2B Reco: 10 Min में सीखें Excel का Secret Tip (No Paid Software Needed)

24 related questions found

How do you reverse GST in Excel?

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.

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 to calculate sales tax backwards from total excel?

The Excel sales tax decalculator works by using a formula that takes the following steps:

  1. Step 1: take the total price and divide it by one plus the tax rate.
  2. Step 2: multiply the result from step one by the tax rate to get the dollars of tax.
  3. Step 3: subtract the dollars of tax from step 2 from the total price.

What is the formula for removing GST?

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.

How do you calculate reverse tax?

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.

Is 18% GST completely removed?

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.

What is the formula to take GST out of total amount?

If you only have G.S.T, which is 7%, then you would calculate the price after taxes by multiplying by 1.07. So a $200 item would cost 1.07 x $200 = $214 after G.S.T. To calculate how much G.S.T. was paid on a $214 item, simply reverse the calculation by dividing by 1.07, as $214/1.07=$200.

How do you remove 18% GST from a total?

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.

How to do reverse charge in GST?

Any amount payable under reverse charge shall be paid by debiting the electronic cash ledger. In other words, reverse charge liability cannot be discharged by using input tax credit. However, after discharging reverse charge liability, credit of the same can be taken by the recipient, if he is otherwise eligible.

What is the formula for calculating GST in Excel?

Excel for GST Calculation

Calculating GST in Excel can be straightforward. Here's a basic approach: Base Price = “GST-inclusive price” * 100 / (100 + GST rate) GST Amount = MRP - Base Price.

What is a reverse GST calculator?

Reverse GST Calculator is a mathematical-based financial tool that determines the bill amount of goods and services, excluding tax. This tool helps in figuring out the pre-tax cost on the basis of the GST-inclusive amount and an applicable GST slab rate.

How do I remove GST from a price in Excel?

Removing GST with Constant Rate from the Total Amount

The price with GST includes both the price and the GST. If the GST rate is 10%, the price we have now is 110% of the original price. That is why we need to divide the price with GST in D2 cell by 110, and then multiply the result by 100 to get the price without GST.

How do I remove GST from a total?

Subtracting GST:

  1. To calculate how much GST is included in a price, just divide by 11.
  2. To calculate how much the price was before GST, just divide by 1.1.

How to make a reverse calculation of GST?

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.

What is the formula for backing out GST in Excel?

How do you reverse calculate GST in Excel? To reverse calculate, use the formula =Total Price/(1 + GST rate). For 18%, it's =Total Price/1.18.

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.

Do you divide GST by 10 or 11?

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.

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.