Reverse Sales Tax Calculator Excel Formula & Price Before Tax

If you already know the total price including sales tax, you can work backward to find the original price before tax.

The calculation is called reverse sales tax or backing out sales tax.

The basic formula is:

Price Before Tax = Total Price ÷ (1 + Sales Tax Rate)

For example, if a customer paid $108.25 and the sales tax rate was 8.25%:

$108.25 ÷ 1.0825 = $100.00

The original price was $100.00, and the sales tax included in the total was $8.25.

You can also do this calculation quickly in Excel or Google Sheets, which makes it useful for receipts, invoices, bookkeeping, expense reports, and large lists of transactions.

This guide explains the reverse sales tax formula, the Excel formulas you can copy, how to handle percentages correctly, and the situations where a simple reverse calculation may not be enough.

What Is Reverse Sales Tax?

Reverse sales tax means starting with a tax-inclusive total and working backward to determine the amount before tax.

Normally, sales tax works like this:

Price Before Tax × Sales Tax Rate = Sales Tax

Then:

Price Before Tax + Sales Tax = Total Price

Reverse sales tax simply runs that process in the opposite direction.

If you know the final total and the applicable sales tax rate, you can recover the original taxable price.

This is particularly useful when a receipt only gives you a tax-inclusive amount or when you’re importing transaction totals into an Excel spreadsheet.

Price Before Tax Formula

The standard price before tax formula is:

Price Before Tax = Total Price ÷ (1 + Sales Tax Rate)

The tax rate must be expressed as a decimal.

For example:

• 5% = 0.05
• 6% = 0.06
• 7.5% = 0.075
• 8.25% = 0.0825
• 9.5% = 0.095

So, if the total is $108.25 and the rate is 8.25%:

Price Before Tax = $108.25 ÷ (1 + 0.0825)

Price Before Tax = $108.25 ÷ 1.0825

Price Before Tax = $100.00

Then calculate the tax:

$108.25 − $100.00 = $8.25

The result is:

Calculation	Amount
Total including tax	$108.25
Price before tax	$100.00
Sales tax	$8.25
Tax rate	8.25%

The numbers also pass the forward calculation:

$100 × 8.25% = $8.25

$100 + $8.25 = $108.25

That is the basic reverse sales tax calculation.

Why Can’t You Simply Subtract the Tax Rate?

This is the mistake that causes most reverse sales tax calculations to go wrong.

Suppose the total is $108 and the sales tax rate is 8%.

You might think:

$108 − 8% = $99.36

But that is not the original price.

The correct calculation is:

$108 ÷ 1.08 = $100

Why?

Because the 8% sales tax was calculated from the $100 pre-tax price, not from the final $108.

The original calculation was:

$100 × 8% = $8 tax

Then:

$100 + $8 = $108 total

If you calculate 8% of $108, you get $8.64. That’s a different number because the tax is not originally calculated on the tax-inclusive total.

So remember:

Adding tax: multiply by 1 + tax rate

Removing tax: divide by 1 + tax rate

The difference is small on a cheap coffee, but it can become significant across hundreds or thousands of transactions.

Reverse Sales Tax Excel Formula

Excel makes the calculation straightforward.

Suppose your spreadsheet looks like this:

Cell	Information	Example
A2	Total including tax	$108.25
B2	Sales tax rate	8.25%
C2	Price before tax	Formula
D2	Tax amount	Formula

If B2 contains 8.25%, enter this formula in C2:

=A2/(1+B2)

Excel should return:

$100.00

Microsoft’s Excel documentation explains that percentages are stored as decimal values in calculations, so a cell containing 8.25% represents 0.0825 internally. Microsoft also documents the use of division to recover an original amount when a known amount represents a percentage of that original.

Excel formula for sales tax amount

Once you have the pre-tax amount in C2, you can calculate the tax with:

=A2-C2

For the example:

$108.25 − $100.00 = $8.25

You now have both parts of the transaction.

Excel Formula If the Tax Rate Is Entered as 8.25

There is an important Excel detail here.

If B2 contains:

8.25%

use:

=A2/(1+B2)

But if B2 contains the number:

8.25

Excel does not automatically treat that number as 8.25%.

In that situation, use:

=A2/(1+B2/100)

So:

=108.25/(1+8.25/100)

returns:

100

This distinction matters when you’re importing data from another spreadsheet or accounting system.

Microsoft explains that Excel handles percentages as decimal values for calculations. Formatting a value as a percentage and entering a number that represents a percentage are not always the same thing, so it is worth checking how your rate column stores its values.

Excel Formula to Calculate Tax Directly

You don’t have to create a separate pre-tax column if you only need the tax amount.

Use:

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

Where:

• A2 = total including tax
• B2 = tax rate stored as a percentage

For $108.25 at 8.25%, the result is:

$8.25

You can also write the formula mathematically as:

Tax Included = Total × [Tax Rate ÷ (1 + Tax Rate)]

Both approaches produce the same result.

For a spreadsheet that other people need to understand, however, the two-step method is often easier to audit:

1. Calculate the price before tax.
2. Subtract it from the total.

That makes the worksheet easier to read six months later when nobody remembers why cell D47 contains a mysterious formula.

Excel Formula With Rounding

Currency calculations normally need to be displayed to two decimal places.

You can use Excel’s ROUND function:

=ROUND(A2/(1+B2),2)

This rounds the calculated pre-tax amount to two decimal places.

Microsoft documents ROUND(number, num_digits) for rounding a value to a specified number of decimal places.

For the tax amount, you could use:

=ROUND(A2-C2,2)

Or calculate and round it directly:

=ROUND(A2-(A2/(1+B2)),2)

One important rounding warning

Don’t assume that every retailer calculates tax exactly the same way you reconstructed it in Excel.

A real receipt may calculate tax at the item level, line level, or according to the jurisdiction’s applicable rules. Rounding can therefore produce a difference of a few cents between a reconstructed calculation and the actual receipt.

For bookkeeping or reconciliation, use the actual tax shown on the source document whenever it is available.

Reverse Sales Tax Example in Excel

Suppose you have these transactions:

Total	Tax Rate	Price Before Tax	Tax
$107.00	7%	$100.00	$7.00
$108.25	8.25%	$100.00	$8.25
$212.00	6%	$200.00	$12.00
$330.00	10%	$300.00	$30.00

If the total is in column A and the rate is in column B, your formulas can be copied down the spreadsheet.

Price before tax:

=ROUND(A2/(1+B2),2)

Tax amount:

=ROUND(A2-C2,2)

This is much faster than manually calculating every receipt.

What If You Have Hundreds of Transactions?

This is where Excel becomes particularly useful.

You can create a simple reverse sales tax worksheet with columns for:

• Transaction date
• Invoice number
• Total including tax
• Sales tax rate
• Price before tax
• Tax amount
• Customer or vendor
• Notes

Then place the reverse sales tax formula in the first row and fill it down.

If all transactions use the same rate, you can store the rate in one cell and reference it from every row.

For example, suppose:

• A2 = total
• B2 = pre-tax price
• F1 = tax rate

You could use:

=ROUND(A2/(1+$F$1),2)

The $ signs keep Excel pointing to the same tax-rate cell when you copy the formula down.

That can be useful when you’re analyzing a batch of transactions from the same jurisdiction.

How to Calculate the Sales Tax Rate From the Total and Pre-Tax Price

Sometimes you have the opposite problem.

You know:

• The original price
• The final price

But you don’t know the tax rate.

In that case:

Sales Tax = Total − Price Before Tax

Then:

Sales Tax Rate = Sales Tax ÷ Price Before Tax

For example:

• Pre-tax price = $100
• Total = $108.25
• Tax = $8.25

Then:

$8.25 ÷ $100 = 0.0825

Convert that to a percentage:

8.25%

In Excel, if A2 contains the pre-tax price and B2 contains the total:

=(B2-A2)/A2

Format the result as a percentage.

Microsoft’s documentation likewise describes percentage calculations as dividing the relevant amount by the base amount.

Why the Correct U.S. Sales Tax Rate Matters

The reverse sales tax formula itself is simple.

The difficult part can be determining which rate applies.

U.S. sales tax is not one nationwide rate. State and local governments can impose different rates, and the combined rate can vary by location.

The Tax Foundation’s 2026 data shows that 45 states levy a state-level sales tax, while 38 states allow local sales taxes. Its July 2026 data also shows meaningful differences between state rates and combined state-and-local rates.

For example, the Tax Foundation’s July 2026 table lists a 6.25% state rate for Texas alongside an average local rate of 1.95%, while Louisiana has a 5% state rate and a much higher average local rate. These are examples of why using a state’s headline rate may not be enough for a particular transaction.

The rate you use in your Excel formula should match the transaction you’re analyzing.

Don’t Confuse State Rate With Combined Rate

Suppose a transaction has a combined sales tax rate of 8.25%.

If you accidentally enter only a 6% state rate into Excel, your reverse calculation will not produce the correct pre-tax amount.

For example:

$108.25 ÷ 1.0825 = $100

But:

$108.25 ÷ 1.06 ≈ $102.12

That’s a difference of more than $2 on a $108.25 transaction.

The spreadsheet isn’t wrong.

The input is wrong.

This is why rate verification matters just as much as the formula.

When Reverse Sales Tax Does Not Work With One Simple Formula

The standard formula assumes that the total represents a taxable amount subject to one applicable percentage rate.

Real-world transactions can be messier.

A receipt may contain:

• Taxable items
• Exempt items
• Items subject to different rates
• Separate fees
• Discounts
• Multiple tax components
• Special taxes or charges

If different items have different tax treatment, dividing the entire receipt by one rate can give you the wrong answer.

In that situation, you may need the individual line items and the applicable tax treatment for each one.

This matters particularly for business bookkeeping because a mathematically neat spreadsheet is not automatically a correct tax record.

Reverse Sales Tax vs. Regular Sales Tax

It helps to see both formulas side by side.

Regular sales tax

When you know the pre-tax price:

Sales Tax = Price Before Tax × Tax Rate

Total = Price Before Tax × (1 + Tax Rate)

Reverse sales tax

When you know the tax-inclusive total:

Price Before Tax = Total ÷ (1 + Tax Rate)

Sales Tax = Total − Price Before Tax

The two processes are inverses.

If your reverse calculation is correct, you should be able to use the pre-tax amount to recreate the original total.

Reverse Sales Tax Formula Cheat Sheet

Here are the formulas worth saving.

Price before tax

Total ÷ (1 + Tax Rate)

Sales tax included

Total − Price Before Tax

Tax amount directly

Total × [Tax Rate ÷ (1 + Tax Rate)]

Tax rate

(Total − Price Before Tax) ÷ Price Before Tax

Excel: rate stored as percentage

=A2/(1+B2)

Excel: rate stored as a whole number

=A2/(1+B2/100)

Excel: rounded price before tax

=ROUND(A2/(1+B2),2)

Excel: tax amount

=A2-C2

Excel: direct tax amount

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

Frequently Asked Questions

What is the Excel formula for reverse sales tax?

If A2 contains the total including tax and B2 contains the tax rate as a percentage, use:

=A2/(1+B2)

For example, $108.25 at 8.25% produces $100 before tax.

What is the formula for price before tax?

The formula is:

Price Before Tax = Total ÷ (1 + Tax Rate)

The tax rate must be converted to a decimal if you are doing the calculation manually.

How do I remove 8.25% sales tax from a total in Excel?

If the total is in A2 and the cell B2 contains 8.25%, use:

=A2/(1+B2)

For a $108.25 total, the result is $100.

Can I subtract 8.25% from the total?

No. If the total already includes an 8.25% tax calculated on the pre-tax price, subtracting 8.25% of the final total does not reverse the original calculation.

Divide by 1.0825 instead.

How do I calculate tax included in a total?

First calculate the pre-tax price:

Total ÷ (1 + Tax Rate)

Then subtract the pre-tax price from the total.

Should I round the reverse sales tax result?

For currency presentation, rounding to two decimal places is usually appropriate. Excel’s ROUND function can do this directly. However, when reconciling an actual receipt, compare your result with the receipt’s stated tax because transaction-level rounding can affect the final cents.

Does this formula work for every U.S. sales tax transaction?

No.

It works cleanly when the total is subject to one applicable percentage rate. Transactions containing different tax rates, exempt items, special charges, or other tax treatments may require a more detailed calculation.

Final Takeaway

The reverse sales tax formula is much simpler than it first appears.

If you know the final price and the applicable tax rate:

Price Before Tax = Total ÷ (1 + Tax Rate)

In Excel, if the total is in A2 and the tax rate is in B2:

=A2/(1+B2)

If you want the result rounded to cents:

=ROUND(A2/(1+B2),2)

Then subtract the pre-tax amount from the total to find the sales tax.

The formula is reliable, but the tax rate you enter matters. U.S. sales tax rates can vary between states and local jurisdictions, and the Tax Foundation’s 2026 data illustrates how different state and combined rates can be.

For Excel users, the best workflow is therefore simple:

Get the correct transaction rate → enter the tax-inclusive total → divide by 1 + the rate → round appropriately → verify the result against the receipt.

That gives you a practical way to turn a tax-inclusive total back into the price before tax without doing the same arithmetic by hand over and over again.