How Reverse Tax Works: A Step-by-Step Guide
Reverse tax helps you separate a price that already includes tax into two parts:
The original price before tax
The tax included in the final total
For example, suppose a receipt total is 108.00 and includes 8% tax.
Reverse tax calculates:
Price before tax: 100.00
Included tax: 8.00
Final total: 108.00
The calculation works by reversing the multiplier that originally added tax.
For additional formulas, receipt examples, spreadsheet guidance, and troubleshooting steps, read the complete How Reverse Tax Works guide.
What Does Reverse Tax Mean?
A normal tax calculation starts with a price before tax and adds tax to it.
For example:
Price before tax: 100.00
Tax rate: 8%
Tax amount: 8.00
Final total: 108.00
The forward calculation is:
100.00 × 1.08 = 108.00
Reverse tax starts with the final 108.00 total and works backward to recover the original 100.00 price.
The reverse calculation is:
108.00 ÷ 1.08 = 100.00
The included tax is then:
108.00 - 100.00 = 8.00
The Reverse Tax Formula
When the tax rate is entered as a decimal, use:
Price before tax = Tax-inclusive total ÷ (1 + Tax rate)
Then calculate:
Included tax = Tax-inclusive total - Price before tax
When the tax rate is written as a whole percentage, use:
Price before tax = Total ÷ (1 + Rate ÷ 100)
For an 8% rate:
1 + 8 ÷ 100 = 1.08
For a 20% rate:
1 + 20 ÷ 100 = 1.20
The number 1.08 or 1.20 is the tax multiplier.
Why Reverse Tax Uses Division
Tax is added to the original price through multiplication.
Suppose an item costs 200.00 before tax and the rate is 8%.
Tax:
200.00 × 8% = 16.00
Final total:
200.00 + 16.00 = 216.00
The same calculation can be written as:
200.00 × 1.08 = 216.00
Because multiplication created the final total, division reverses it:
216.00 ÷ 1.08 = 200.00
The original price before tax is 200.00.
Why You Should Not Subtract the Tax Percentage
A common mistake is subtracting the listed tax percentage from the final price.
Using the 216.00 total at 8%:
216.00 × (1 - 8%) = 198.72
The correct price before tax is 200.00.
The incorrect calculation removes 8% of 216.00:
216.00 × 8% = 17.28
However, the actual tax was calculated from the original 200.00 base:
200.00 × 8% = 16.00
Subtracting the percentage behaves like applying a discount to the final price.
It does not reverse the tax calculation.
The Correct Reverse Tax Sequence
A reliable reverse tax calculation follows this order.
Step 1: Confirm that the amount includes tax
Look for wording such as:
Tax included
VAT included
GST inclusive
Total including tax
Gross amount
Final tax-inclusive price
Do not reverse tax from a subtotal that already excludes tax.
Step 2: Identify the applicable rate
Find the rate on the receipt, invoice, order record, or another reliable source.
Do not guess the rate from the final total alone.
Step 3: Check what the total contains
Determine whether the amount also includes:
Exempt products
Differently taxed items
Shipping
Service fees
Tips
Discounts
Deposits
Store credits
Previous payments
Separate amounts that do not share the same tax treatment.
Step 4: Divide by the tax multiplier
Use:
Total ÷ (1 + Rate)
Step 5: Find the included tax
Subtract:
Total - Price before tax
Step 6: Rebuild the total
Add the calculated base and tax together.
The result should match the original tax-inclusive amount, allowing for normal rounding.
Worked Example: 216.00 Including 8% Tax
Suppose:
Tax-inclusive total: 216.00
Tax rate: 8%
Convert the rate:
8% = 0.08
Create the multiplier:
1 + 0.08 = 1.08
Find the price before tax:
216.00 ÷ 1.08 = 200.00
Find the included tax:
216.00 - 200.00 = 16.00
Rebuild the total:
200.00 + 16.00 = 216.00
The calculation is internally consistent.
Worked Example: 120.00 Including 20% Tax
Suppose a displayed price of 120.00 includes 20% VAT.
Find the price before VAT:
120.00 ÷ 1.20 = 100.00
Find the included VAT:
120.00 - 100.00 = 20.00
The price contains:
Price before VAT: 100.00
VAT: 20.00
Final price: 120.00
Multiplying 120.00 by 20% would produce 24.00, which is not the tax included in the price.
What If the Tax Amount Is Already Shown?
When the receipt shows the actual tax amount, subtraction is usually enough.
Suppose:
Total: 108.00
Tax shown: 8.00
Calculate:
108.00 - 8.00 = 100.00
The price before tax is 100.00.
Using the shown tax amount can be preferable because it already reflects the seller’s calculation and rounding method.
There is no need to reconstruct a tax amount that is clearly displayed.
What If the Rate Is Known but the Tax Amount Is Not?
Use the reverse tax formula.
Suppose:
Total: 270.00
Rate: 8%
Calculate:
270.00 ÷ 1.08 = 250.00
Included tax:
270.00 - 250.00 = 20.00
Can Reverse Tax Work Without the Rate?
Reverse tax can work without the rate when the actual tax amount is shown.
For example:
Total: 108.00
Tax: 8.00
Price before tax:
108.00 - 8.00 = 100.00
If neither the rate nor the tax amount is known, the original price cannot normally be determined from the final total alone.
A total of 108.00 could result from many different combinations of rates and pre-tax prices.
How Reverse Tax Works With Multiple Rates
A receipt containing several rates should be divided into tax groups.
Suppose:
Group A: 108.00 including 8%
Group B: 120.00 including 20%
Reverse Group A:
108.00 ÷ 1.08 = 100.00
Tax in Group A:
108.00 - 100.00 = 8.00
Reverse Group B:
120.00 ÷ 1.20 = 100.00
Tax in Group B:
120.00 - 100.00 = 20.00
Combined result:
Total before tax: 200.00
Included tax: 28.00
Final total: 228.00
Do not apply one rate to the combined 228.00.
Each group was created using a different tax multiplier.
How Reverse Tax Works With Exempt Items
Suppose a receipt contains:
Taxable amount: 108.00 including 8% tax
Exempt amount: 50.00
Receipt total: 158.00
Reverse only the taxable portion:
108.00 ÷ 1.08 = 100.00
Included tax:
108.00 - 100.00 = 8.00
Receipt breakdown:
| Component | Amount |
|---|---|
| Taxable price before tax | 100.00 |
| Included tax | 8.00 |
| Exempt amount | 50.00 |
| Total | 158.00 |
Dividing the full 158.00 by 1.08 would incorrectly treat the exempt amount as taxable.
How Reverse Tax Works With GST, VAT, HST, and Sales Tax
The basic arithmetic is similar for simple percentage-based taxes:
Tax-inclusive total ÷ (1 + Applicable rate)
However, the tax system and transaction structure may differ.
A total might include:
One sales tax
VAT
GST
HST
Separate federal and provincial taxes
State and local taxes
Stacked taxes
Several product tax categories
Use the rate and formula structure that apply to the actual transaction.
Reverse tax performs arithmetic. It does not determine which rate legally applies.
How Reverse Tax Works in Excel
Suppose:
A2 contains the tax-inclusive total
B2 contains the tax rate as a percentage
Use this formula for the price before tax:
=A2/(1+B2)
Use this formula for the included tax:
=A2-(A2/(1+B2))
Example
| Cell | Value |
|---|---|
| A2 | 216.00 |
| B2 | 8% |
| C2 | =A2/(1+B2) |
| D2 | =A2-C2 |
Results:
C2: 200.00
D2: 16.00
Excel Formula When the Rate Is a Whole Number
If B2 contains 8 rather than 8%, use:
=A2/(1+B2/100)
For included tax:
=A2-(A2/(1+B2/100))
Do not mix these rate formats without adjusting the formula:
88%0.08
The entries 8% and 0.08 represent the same decimal value.
The whole number 8 must be divided by 100.
Add a Rebuilt-Total Check
A useful spreadsheet should include:
Original total
Tax rate
Price before tax
Included tax
Rebuilt total
Variance
The rebuilt total is:
Price before tax + Included tax
The variance is:
Original total - Rebuilt total
A zero variance means the values reconcile exactly.
A one-cent variance may result from rounding.
A larger variance may indicate:
Wrong rate
Wrong source total
Mixed tax groups
Exempt items
Incorrect percentage formatting
Overwritten formulas
Which Number Should You Enter?
Enter the clean tax-inclusive total containing the tax you want to remove.
Depending on the document, this may be:
Final taxable receipt total
Gross invoice amount
Tax-inclusive product price
Tax-inclusive refund amount
One grouped amount from a mixed-rate receipt
Do not automatically enter:
Card payment
Marketplace payout
Bank deposit
Balance after a credit
Amount due after a deposit
Settlement after fees
Total containing an optional tip
These figures may reflect payments and adjustments rather than the taxable sale.
How Reverse Tax Works for Discounts
Suppose:
Original price: 100.00
Discount: 10.00
Taxable price after discount: 90.00
Rate: 8%
Tax:
90.00 × 8% = 7.20
Final total:
90.00 + 7.20 = 97.20
Reverse the final total:
97.20 ÷ 1.08 = 90.00
The calculation recovers the discounted price before tax.
It does not recover the original 100.00 list price because tax was applied to 90.00.
How Reverse Tax Works for Refunds
Suppose a full refund of 108.00 includes the same 8% tax charged on the original purchase.
Estimated pre-tax refund:
108.00 ÷ 1.08 = 100.00
Refunded tax:
108.00 - 100.00 = 8.00
The calculation becomes more complicated when the refund includes:
Restocking fees
Partial quantities
Non-refundable shipping
Store credit
Discount allocation
Manual adjustments
Tax corrections
Use the original receipt and refund record when available.
How Reverse Tax Works for Business Records
A tax-inclusive sale should not always be recorded entirely as sales revenue.
Suppose a business receives 108.00 from a sale including 8% tax.
Reverse tax separates the amount into:
Revenue before tax: 100.00
Tax collected: 8.00
The tax portion may represent an amount collected for a tax authority rather than business revenue.
Businesses should also distinguish between:
Sale total
Customer payment
Processor fee
Marketplace commission
Refund
Chargeback
Bank payout
Reverse tax should normally be applied to the taxable sale, not the net marketplace or payment-processor payout.
Common Reverse Tax Mistakes
Subtracting the percentage
Incorrect:
Total × (1 - Rate)
Correct:
Total ÷ (1 + Rate)
Multiplying the final total by the rate
This calculates tax from the wrong base.
Using an outdated or incorrect rate
The formula can be mathematically correct while the practical result is wrong.
Reversing a subtotal that excludes tax
Reverse tax should begin with a tax-inclusive amount.
Applying one rate to mixed items
Separate differently taxed and exempt items.
Using the payment amount instead of the sale total
Deposits, credits, tips, fees, and processor deductions may alter the payment figure.
Ignoring rounding
Receipt systems may round tax by item, tax group, or order total.
When You Should Not Use Reverse Tax
Do not use reverse tax when:
Tax has not been added yet
The amount is already before tax
The rate is unknown and no tax amount is shown
Several rates are mixed together
Exempt items have not been separated
The amount is a payout after platform fees
The number is only a payment balance
You need to determine whether an item is legally taxable
If the price excludes tax, use forward tax:
Price before tax × (1 + Rate) = Final total
How to Check the Result
Use two checks.
Arithmetic check
Add:
Price before tax + Included tax
The result should match the original total.
Forward-rate check
Multiply:
Price before tax × (1 + Rate)
The result should also match the original total, allowing for rounding.
If the difference is more than a cent, review the input data and transaction structure.
Calculate a Tax-Inclusive Amount
For a clean total that includes tax at one known rate, use the free Reverse Tax Calculator.
Enter the total and applicable rate to calculate:
Price before tax
Included tax
Tax multiplier
Calculation breakdown
For multiple rates or exempt items, separate the tax groups first.
Final Takeaway
Reverse tax works by undoing the multiplication that originally added tax.
The core calculation is:
Price before tax = Tax-inclusive total ÷ (1 + Tax rate)
Then:
Included tax = Tax-inclusive total - Price before tax
The arithmetic is simple, but the inputs must match.
Use a clean tax-inclusive total, the correct rate, and the correct taxable group. Separate exempt items, multiple rates, tips, discounts, fees, and payment adjustments before calculating.
For more examples, spreadsheet checks, refund guidance, and common-error explanations, read the complete How Reverse Tax Works guide.
Comments
Post a Comment