How to Find the Tax Amount Included in a Total Price

A receipt, invoice, or advertised price may show only the final amount after tax. When the total already includes tax, you cannot calculate the included tax by multiplying the total directly by the tax rate.

Instead, you must separate the final amount into:

  • The original price before tax

  • The tax included in the price

For example, a total of 110.00 that includes 10% tax contains 10.00 in tax, not 11.00.

This guide explains two ways to calculate the tax amount from a tax-inclusive total, including worked examples, spreadsheet formulas, and situations where the basic calculation should not be applied to the entire amount.

For additional examples and troubleshooting guidance, read the complete guide to finding the tax amount from a total.

What You Need Before Calculating

To calculate the included tax, you normally need:

  • The total amount including tax

  • The tax rate applied to the amount

You should also confirm that:

  • The starting amount genuinely includes tax

  • One rate applies to the entire amount

  • The total does not combine taxable and exempt items

  • Tips, fees, deposits, and credits have been classified correctly

  • The rate is appropriate for the transaction

If the rate is unknown and the before-tax price is also unknown, the included tax generally cannot be determined from the total alone.

Method 1: Find the Price Before Tax First

The most transparent method uses two steps.

Step 1: Calculate the price before tax

Use:

Price before tax = Total ÷ (1 + tax rate)

The tax rate must be written as a decimal.

Examples:

  • 5% becomes 0.05

  • 8% becomes 0.08

  • 10% becomes 0.10

  • 20% becomes 0.20

Step 2: Subtract the price before tax

Use:

Included tax = Total - Price before tax

This method is useful because it shows both parts of the final amount.

Example: Find 10% Tax Included in 110.00

Suppose:

  • Tax-inclusive total: 110.00

  • Tax rate: 10%

Find the tax multiplier

1 + 0.10 = 1.10

Find the price before tax

110.00 ÷ 1.10 = 100.00

Find the included tax

110.00 - 100.00 = 10.00

The result is:

  • Price before tax: 100.00

  • Included tax: 10.00

  • Tax-inclusive total: 110.00

You can verify the calculation:

100.00 × 10% = 10.00

100.00 + 10.00 = 110.00

Why 10% of 110 Is Not the Included Tax

Multiplying the final total by 10% gives:

110.00 × 10% = 11.00

That result is too high.

The 10% rate was originally applied to the 100.00 price before tax, not to the final 110.00 amount.

Calculating 10% of 110.00 effectively applies tax to an amount that already contains tax.

The included tax is therefore 10.00, not 11.00.

Method 2: Calculate the Included Tax Directly

You can calculate the tax amount without displaying the price before tax first.

Use:

Included tax = Total × (rate ÷ (1 + rate))

When the rate is written as a whole percentage, use:

Included tax = Total × (rate ÷ (100 + rate))

For a 10% rate:

110.00 × (10 ÷ 110) = 10.00

The direct method and two-step method produce the same result.

When to use the two-step method

Use the two-step method when you need:

  • The price before tax

  • The included tax

  • A clear audit trail

  • A formula that is easy to explain

When to use the direct method

Use the direct method when:

  • You need only the tax amount

  • You already understand the tax-share formula

  • You are building a compact spreadsheet or application

Example: Find 8% Sales Tax Included in 216.00

Suppose:

  • Total after tax: 216.00

  • Tax rate: 8%

Two-step method

Find the price before tax:

216.00 ÷ 1.08 = 200.00

Find the included tax:

216.00 - 200.00 = 16.00

Direct method

216.00 × (8 ÷ 108) = 16.00

The result is:

  • Price before tax: 200.00

  • Included sales tax: 16.00

  • Final total: 216.00

Example: Find 20% VAT Included in 120.00

Suppose a price of 120.00 includes 20% VAT.

Find the price before VAT:

120.00 ÷ 1.20 = 100.00

Find the VAT amount:

120.00 - 100.00 = 20.00

The result is:

  • Price before VAT: 100.00

  • VAT included: 20.00

  • VAT-inclusive total: 120.00

You can also use the direct formula:

120.00 × (20 ÷ 120) = 20.00

At a 20% rate, the included tax represents one sixth of the final total:

20 ÷ 120 = 1 ÷ 6

Therefore:

120.00 ÷ 6 = 20.00

Example: Find 5% Tax Included in 105.00

Suppose:

  • Tax-inclusive total: 105.00

  • Tax rate: 5%

Find the original price:

105.00 ÷ 1.05 = 100.00

Find the included tax:

105.00 - 100.00 = 5.00

The result is:

  • Price before tax: 100.00

  • Included tax: 5.00

  • Final total: 105.00

Included Tax at Different Rates

The same total contains different tax amounts depending on the applicable rate.

For a total of 120.00:

Tax ratePrice before taxIncluded tax
0%120.000.00
5%114.295.71
8%111.118.89
10%109.0910.91
13%106.1913.81
20%100.0020.00

This is why the rate must be known before the included tax can be calculated reliably.

A total of 120.00 does not contain one fixed tax amount. The result depends on the rate and tax treatment.

Tax Rate Versus Tax Share of the Final Total

The listed tax rate is applied to the price before tax.

The tax share of the final total measures how much of the gross amount consists of tax.

For a 10% tax rate:

  • Before-tax price: 100.00

  • Tax: 10.00

  • Final total: 110.00

The tax rate is 10% of the pre-tax price.

However, the tax represents:

10.00 ÷ 110.00 = 9.09%

of the final total.

Therefore:

  • Applied tax rate: 10%

  • Tax share of final total: approximately 9.09%

These percentages are different because they use different bases.

Can You Find the Tax Amount Without Knowing the Rate?

You may be able to calculate the tax without the rate when another value is known.

Total and price before tax are known

Suppose:

  • Total: 108.00

  • Price before tax: 100.00

Calculate:

108.00 - 100.00 = 8.00

The tax amount is 8.00.

Total only is known

If the only known value is 108.00, the tax amount cannot be identified reliably.

The total could have been created using:

  • A 5% rate and one original price

  • An 8% rate and another original price

  • A 10% rate and a different original price

  • Multiple tax rates

  • Taxable and exempt items

  • Additional fees

The total alone does not reveal which explanation is correct.

What If the Receipt Shows the Tax Amount?

When the receipt already displays the actual tax amount, use the displayed value.

For example:

  • Total: 108.00

  • Shown tax: 8.00

Find the price before tax:

108.00 - 8.00 = 100.00

This may be preferable to reconstructing the tax from the rate because the receipt may have used:

  • Item-level calculations

  • Line-level rounding

  • Several taxable products

  • More decimal places than the displayed amounts

The displayed tax preserves the source system’s result.

What If the Total Contains an Exempt Item?

Do not reverse the complete total when part of it is exempt.

Suppose:

  • Taxable amount including 8% tax: 108.00

  • Exempt item: 50.00

  • Complete receipt total: 158.00

Reverse only the taxable portion:

108.00 ÷ 1.08 = 100.00

Included tax:

108.00 - 100.00 = 8.00

The receipt consists of:

ComponentAmount
Taxable price before tax100.00
Included tax8.00
Exempt item50.00
Receipt total158.00

The complete receipt contains 8.00 in tax.

Reversing 158.00 at 8% would incorrectly treat the exempt product as taxable.

What If Several Tax Rates Apply?

Separate the amount into tax groups before calculating.

Suppose:

  • Group A: 108.00 including 8%

  • Group B: 120.00 including 20%

Group A

108.00 ÷ 1.08 = 100.00

Included tax:

108.00 - 100.00 = 8.00

Group B

120.00 ÷ 1.20 = 100.00

Included tax:

120.00 - 100.00 = 20.00

Combined result

  • Total before tax: 200.00

  • Total included tax: 28.00

  • Tax-inclusive total: 228.00

Do not choose one rate and apply it to the combined 228.00.

Each group contains a different tax share.

Tips, Delivery Fees, and Service Charges

A final payment amount may contain more than taxable products.

Possible additional amounts include:

  • Optional tips

  • Mandatory service charges

  • Shipping

  • Delivery fees

  • Handling charges

  • Deposits

  • Gift cards

  • Store credits

  • Partial payments

Before calculating, determine whether each amount:

  • Is taxable

  • Uses the same rate

  • Should be separated

  • Represents a payment rather than a product

  • Has already been included in the taxable base

For example, a store credit may reduce the amount paid without reducing the original taxable selling price.

Do not automatically reverse tax from the remaining balance.

How Discounts Affect the Included Tax

A discount may reduce the taxable base before tax is calculated.

Suppose:

  • Original price: 100.00

  • Discount: 10.00

  • Discounted taxable price: 90.00

  • Tax rate: 8%

Tax:

90.00 × 8% = 7.20

Final total:

90.00 + 7.20 = 97.20

The included tax is 7.20.

If you use the original 100.00 amount instead of the discounted taxable price, the result will not match the transaction.

Identify whether the displayed total is before or after the discount and whether the discount reduced the taxable amount.

Why the Result May Differ by One Cent

Reverse-tax calculations often produce several decimal places.

Suppose a total of 100.00 includes 7% tax:

100.00 ÷ 1.07 = 93.457943...

Rounded price before tax:

93.46

Included tax:

100.00 - 93.46 = 6.54

A receipt may calculate tax separately for several items and round every line before adding them.

A calculator may reverse the complete total once.

Those methods can differ by one cent because of the order in which rounding occurs.

For reconciliation work, compare:

  • Item-level tax

  • Receipt-level tax

  • Displayed tax

  • Decimal precision

  • Rounding method

Excel and Google Sheets Formulas

Suppose:

  • A2 contains the tax-inclusive total

  • B2 contains the tax rate as a percentage

Price before tax

=A2/(1+B2)

Included tax using two steps

If the price before tax is in C2:

=A2-C2

Included tax directly

=A2*(B2/(1+B2))

Example

CellValue
A2110.00
B210%
C2=A2/(1+B2)
D2=A2-C2

Results:

  • C2: 100.00

  • D2: 10.00

Formula When the Rate Is Entered as a Whole Number

If B2 contains 10 instead of 10%, use:

=A2/(1+B2/100)

For the included tax:

=A2-(A2/(1+B2/100))

Or use the direct formula:

=A2*(B2/(100+B2))

Do not mix whole-number rates and percentage-formatted rates in the same spreadsheet column.

Spreadsheet Formula to Avoid

Do not use:

=A2*B2

when A2 contains the tax-inclusive total.

For a total of 110.00 and rate of 10%, this returns:

11.00

The included tax is only 10.00.

The incorrect formula calculates 10% of the gross total rather than extracting the tax that was applied to the smaller pre-tax base.

How to Check the Result

After calculating, confirm that:

Price before tax + Included tax = Original total

For example:

100.00 + 10.00 = 110.00

You can also apply the rate forward:

100.00 × 10% = 10.00

If the result does not reconcile, check:

  • Whether the total includes tax

  • Whether the rate is correct

  • Whether exempt items are included

  • Whether several rates apply

  • Whether fees or tips are present

  • Whether the receipt uses line-level rounding

  • Whether percentage cells are formatted correctly

Which Method Should You Use?

Information availableRecommended method
Total and rateReverse-tax formula
Total and price before taxSubtract the price from the total
Total and shown taxUse the shown tax
Several ratesSeparate each rate group
Taxable and exempt itemsReverse only the taxable group
Total but no rateFind more transaction information
Payment balance after creditsLocate the original transaction total

Calculate Your Own Tax-Inclusive Total

For a clean amount that includes tax at one known rate, use the free Reverse Tax Calculator.

Enter the total and tax rate to calculate:

  • The price before tax

  • The tax included in the total

  • The tax multiplier

  • The reconstructed total

For mixed-rate or partly exempt receipts, separate each tax group before entering the amounts.

Final Takeaway

To find the tax amount included in a total:

  1. Confirm that the amount includes tax.

  2. Identify the applicable rate.

  3. Divide the total by one plus the rate.

  4. Subtract the resulting price before tax from the total.

  5. Check that the two amounts rebuild the original total.

You can also calculate the tax directly by multiplying the total by the rate divided by one plus the rate.

Do not multiply the tax-inclusive total directly by the listed tax rate.

For additional formulas, examples, and receipt scenarios, read the complete Find Tax Amount From Total guide.

Comments

Post a Comment

Popular posts from this blog

Reverse Tax Formula Explained: How to Calculate Tax Backwards

When a price already includes tax, you cannot usually find the original price by subtracting the tax percentage from the final total. Instead, you must reverse the multiplier that created the tax-inclusive price. The basic reverse tax formula is: Price before tax = Tax-inclusive total ÷ (1 + Tax rate ÷ 100) After calculating the price before tax, find the included tax with: Included tax = Tax-inclusive total - Price before tax For example, if a final price of 120.00 includes 20% tax: 120.00 ÷ 1.20 = 100.00 The original price is 100.00, and the included tax is: 120.00 - 100.00 = 20.00 This guide explains how the reverse tax formula works, how to enter rates correctly, which formula to use for different goals, and when a simple calculation is not enough. For the complete formula reference and related calculation resources, read the main Reverse Tax Formula guide . What Is the Reverse Tax Formula? The reverse tax formula separates a final tax-inclusive amount into: Price before tax Tax in...
Read more

What Is Reverse Tax? Meaning, Formula, and Simple Examples

Reverse tax is the process of working backward from a final price that already includes tax. Instead of starting with a price before tax and adding sales tax, VAT, GST, or another percentage-based tax, you start with the tax-inclusive total and separate it into: The original price before tax The tax included in the total For example, suppose a receipt total is 108.00 and includes 8% tax. Reverse tax shows that: Price before tax: 100.00 Included tax: 8.00 Final tax-inclusive total: 108.00 The final amount may appear to be one number, but it contains both the seller’s original price and the tax added to that price. For a more complete definition, terminology guide, and explanation of related concepts, read the detailed What Is Reverse Tax? resource. Reverse Tax Meaning in Plain English In plain English, reverse tax means removing the tax portion mathematically from a price that already includes tax. It does not mean that the tax was cancelled, refunded, or legally reversed. It simply an...
Read more

How to Reverse Tax in Excel Without Getting the Formula Wrong

When a receipt, invoice, or sales report gives you only the total price including tax, you may need to calculate the original price before tax. Excel can do this automatically, but the formula must reverse the tax calculation correctly. Simply subtracting the tax percentage from the total produces an inaccurate result. This guide explains how to create a simple reverse-tax spreadsheet that calculates: The price before tax The included tax amount A rebuilt total Any difference caused by rounding or incorrect data What Is the Reverse Tax Formula in Excel? Suppose: Cell A2 contains the total including tax Cell B2 contains the tax rate The formula for calculating the price before tax is: =A2/(1+B2) For example, suppose the tax-inclusive total is $108 and the tax rate is 8%. Enter: A2: 108 B2: 8% Then enter this formula in C2: =A2/(1+B2) Excel returns: 100 Therefore: Price before tax: $100 Tax included: $8 Total: $108 The calculation works because an 8% tax turns $100 into $108 by multiplyi...
Read more