Reverse Sales Tax Calculator
Know the total price including tax? Use this free reverse sales tax calculator to instantly find the pre-tax price and the exact tax amount paid.
How to Calculate Reverse Sales Tax
A reverse sales tax calculation works backwards from a tax-inclusive total to find the original pre-tax price. This is the opposite of the standard sales tax calculator, which starts with the pre-tax price and adds tax. Both tools use complementary formulas — knowing one gives you the other.
Tax Amount = Total − Pre-tax Price
Step-by-Step Example
Total paid: $162.00 | Tax rate: 8%
Step 1: Divisor = 1 + (8 ÷ 100) = 1.08
Step 2: Pre-tax price = $162.00 ÷ 1.08 = $150.00
Step 3: Tax amount = $162.00 − $150.00 = $12.00
Check: $150.00 × 1.08 = $162.00 ✓
The Most Common Mistake
Do not simply subtract the tax percentage from the total. Subtracting 8% from $162 gives $149.04 — which is wrong. The correct pre-tax price is $150.00. The error happens because 8% of $162 ($12.96) is not the same as 8% of $150 ($12). Tax is always calculated on the pre-tax price, so you must divide — not subtract — to reverse it correctly.
Reverse Sales Tax in Excel
Put the total price in A1 and the tax rate (e.g. 8 for 8%) in B1.
Pre-tax price: =A1/(1+B1/100)
Tax amount: =A1-A1/(1+B1/100)
These formulas work identically in Google Sheets. To apply across a column of totals, use =$B$1 as an absolute reference for the tax rate.
Reverse Sales Tax Examples
Click any example to load it into the calculator.
Real-World Scenarios
Expense reporting: Your receipt shows a total of $86.40 for a business lunch in a city with 8% combined sales tax. Your expense form requires the pre-tax subtotal. Using the reverse sales tax calculator: $86.40 ÷ 1.08 = $80.00 pre-tax, with $6.40 in tax. This is the correct figure to enter on your expense claim.
Bookkeeping: A small business received $32,400 in total sales during the month, all subject to 8% sales tax. To record the revenue and tax payable separately: pre-tax revenue = $32,400 ÷ 1.08 = $30,000. Tax collected = $2,400. This needs to be remitted to the state. The sales tax calculator handles the forward version of this calculation for invoicing.
Pricing strategy: A retailer wants the all-inclusive price to be exactly $50.00, including 6.25% Texas state tax. To find the correct pre-tax price to list: $50.00 ÷ 1.0625 = $47.06 pre-tax. At 6.25% tax ($2.94), the total is exactly $50.00. Understanding this also connects to reverse percentage calculations — the same mathematical principle applies.
When to Use a Reverse Sales Tax Calculator
Expense Reports
Most expense policies require the pre-tax subtotal, not the receipt total. Use the reverse sales tax calculator to extract the correct figure from any tax-inclusive receipt quickly.
Bookkeeping & Accounting
Separate tax collected from net revenue in your accounts. When total sales figures include tax, dividing out the tax is essential for accurate profit and loss reporting and for calculating tax liability.
Invoice Verification
Check whether a supplier or platform charged the correct tax amount on an invoice. Enter the total and the applicable rate — if the pre-tax price matches the line item, the tax was calculated correctly.
Round-Total Pricing
Set prices so the customer pays a clean total. Work backwards from the target all-in price to find what pre-tax price you need to list. Particularly useful for retail and hospitality businesses.
Audit & Reconciliation
Reconcile reported sales against tax remitted. If total receipts and the tax rate are known, the pre-tax revenue and tax payable can be derived without needing access to the original pre-tax figures.
Consumer Verification
Verify that the tax shown on a receipt is correct. Divide the total by (1 + rate) and compare to the subtotal on the receipt. Any discrepancy may indicate a pricing error or the wrong tax rate being applied.
Frequently Asked Questions
Related Percentage Calculators
Need a different type of percentage calculation? Try one of our other free tools: