How to calculate taxable amount from total amount?

Asked by: Karl Herman II  |  Last update: September 24, 2026
Score: 5/5 (36 votes)

To calculate the taxable amount (pre-tax price) from a total amount, divide the total by 1 + tax rate 1 + t a x r a t e (e.g., divide by 1.08 1 . 0 8 for 8 % 8 % ). The tax amount is then found by subtracting this pre-tax price from the total. This formula, Total 1 + Tax Rate T o t a l 1 + T a x R a t e , removes the tax from the gross sum.

How to calculate taxable value from total value?

About Finology GST Calculator

  1. WHAT IS GST. ...
  2. HOW TO CALCULATE GST? ...
  3. For this purpose, let us take an Example: ...
  4. Outward Supply: Mr. ...
  5. Reverse Calculation of GST from Invoice Value. ...
  6. [100 X (Tax Rate/ 100+Tax Rate)]
  7. i.e., GST= [100 x (18/118)] = Rs. ...
  8. Taxable Value i.e., value exclusive of GST = Rs.100 - Rs.15.254 =Rs.84.745.

How to calculate the taxable amount?

How to calculate taxable income – Step by Step

  1. Add all sources of income.
  2. Add standard deduction.
  3. Deduct professional tax.
  4. Factor in HRA and LTA.
  5. Subtract all applicable deductions.

How to determine the taxable amount?

Your taxable income is your gross income minus deductions you're eligible for. It's used to determine your tax bracket and marginal tax rate, so it's important to know this amount as you file your income tax return.

How to compute taxable amount?

Taxable income (Gross income – Allowable deductions) x Tax rate – Tax withheld = Income tax due

  1. Compute your annual gross salary first. ...
  2. Get the total annual employee contributions (they fall under allowable deductions). ...
  3. Subtract total annual contributions from the annual salary.

How to Calculate GST in Microsoft Excel | GST Calculator in Excel

28 related questions found

What is the formula for calculating the taxable income?

To calculate taxable income, start with your Gross Income, subtract "above-the-line" adjustments (like retirement contributions) to get your Adjusted Gross Income (AGI), and then subtract either the Standard Deduction or Itemized Deductions (whichever is greater) from your AGI; the result is your taxable income, which is the amount subject to tax.

How to remove GST from total 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. Yes, you can use the reverse GST calculator for all GST types—CGST, SGST, and IGST.

What is the formula for taxable amount in Excel?

So here let us first see the income tax amount for rates up to 6 lakhs. Here, you can apply the =B3*5/100 formula in the cell B5. Here, B3 is the cell reference containing the value for which you want to calculate 5%. The formula multiplies that value by 5/100, which is equivalent to 5%, to get the result.

How do you calculate tax reverse?

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.

How to calculate 5% GST from a total amount?

First method. Let's say before GST, your subtotal is x dollars. Then the total is this amount (x) PLUS the gst amount (5% of x). So the Total = x + 5%(x) = 1x + 0.05x = 1.05x, because 5% means 0.05.

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 to calculate 10% GST from total amount?

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.

How do you calculate tax out of a total?

Sales Tax Calculation Formulas

  1. Sales tax amount = original price × sales tax rate as a decimal.
  2. Sales tax rate as a decimal = sales tax percent / 100.
  3. Total price after tax:
  4. Original price before tax = total price after tax / (1 + sales tax rate as a decimal)
  5. Sales tax amount = total price after tax - price before tax.

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.

How to backwards calculate GST?

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.

How to extract tax amount from total?

Reverse Sales Tax Calculations:

  1. Price before Tax = Total Price with Tax - Sales Tax.
  2. Sales Tax Rate = Sales Tax Percent / 100.
  3. Price before Tax = Total Price with Tax / (1 + Sales Tax Rate)
  4. Sales Tax = Price before Tax x Sales Tax Rate.

How to remove GST from a total?

How do you remove GST?

  1. First, take the GST-inclusive price and multiply that by 3.
  2. Then, divide the result by 23 and round that number to the nearest two decimal points.
  3. Finally subtract that from the GST-inclusive price:

How much federal tax should I pay if I make $60,000?

Basics of Progressive Income Tax Rates

For example, a single filer with $60,000 in taxable income in tax year 2023 falls into the 22 percent bracket but does not pay tax of $13,200 (22 percent of $60,000).