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.
Reverse GST Calculation Example
Example
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.
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 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.
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).
The Excel sales tax decalculator works by using a formula that takes the following steps:
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.
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.
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.
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.
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.
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.
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.
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.
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.
Subtracting GST:
Reverse Charge Mechanism & Calculation
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.
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.
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.
Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.