How To Back Out Sales Tax from a Total: Step-by-Step Formula

You just got a receipt — or an invoice — and all you can see is the final total with tax already included. Now you need to know the original price before tax was added. This is called "backing out" the sales tax, and it's easier than it sounds.

In this guide, you'll learn the exact reverse sales tax formula, see real-world examples, and find out the fastest way to do this calculation — whether you're a shopper checking a receipt, a business owner reconciling books, or an accountant separating revenue from tax.

1. What Does "Backing Out" Sales Tax Mean?

When a store charges you sales tax, it adds a percentage to your original price. The total you pay — called the tax-inclusive price or gross price — is what appears on your receipt.

"Backing out" means working in reverse: starting from that tax-inclusive total and calculating what the price was before tax was applied.

This is different from simply subtracting a percentage from the total — a common mistake we'll cover later.

2. The Reverse Sales Tax Formula

The formula to back out sales tax from a total is:

Why divide instead of subtract? Because the tax was calculated on the original price — not on the total. So you can't just subtract a percentage from the total. You need to divide by the "tax factor" to undo the multiplication that was applied at the register.

Breaking Down the Formula

• Final Price — the total you paid (tax already included)
• Tax Rate — your sales tax percentage (e.g., 8.25%)
• 1 + Tax Rate ÷ 100 — the "tax factor" (e.g., 1.0825 for 8.25%)
• Original Price — the pre-tax price you're solving for

3. Step-by-Step Example

Let's walk through a real example. Scenario: You paid $54.12 in Texas (8.25% combined tax rate).

1. Find Your Final Price: $54.12
2. Find Your Tax Rate: 8.25% (shown on receipt, or look up your city's combined rate)
3. Calculate the Tax Factor: 1 + (8.25 ÷ 100) = 1.0825
4. Divide: $54.12 ÷ 1.0825 = $50.00
5. Find the Tax Amount: $54.12 − $50.00 = $4.12

Verification: $50.00 × 1.0825 = $54.12. ✓ Correct!

4. Common Scenarios Where You Need This

For Shoppers

• Verifying you were charged the correct tax rate on a receipt
• Splitting a shared bill and figuring out each person's pre-tax share
• Calculating tip on the pre-tax amount at a restaurant (saves money)
• Expense reports that require pre-tax amounts

For Business Owners

• Reconciling daily sales totals when your POS only shows gross amounts
• Separating product revenue from collected tax for your sales tax return
• Shopify and Amazon payouts that bundle tax into gross totals
• Issuing correct refunds when a return needs to back out the tax

For Accountants & Bookkeepers

• Cleaning up tax-inclusive expense lines in general ledgers
• Audit samples where only receipts with totals are available
• Multi-rate receipts where different items carried different tax rates

5. The Bookkeeping Workflow

Small businesses rarely get clean data. A contractor buys supplies at Home Depot with tax on the receipt, expensing the full amount in one line. Come tax season, the bookkeeper needs cost of goods at pre-tax values and sales tax paid as its own category — or the deduction story gets muddy.

Standard workflow: (1) capture receipt image, (2) read total and identify combined rate from receipt or card metadata, (3) reverse-calculate base and tax, (4) enter two lines in QuickBooks / Xero / Wave, (5) attach receipt. Repeat at scale with batch tools or our remover calculator.

6. State Sales Tax Rates Quick Reference (2026)

The tax rate you use matters. Always use the combined rate (state + county + city) shown on your actual receipt. The table below shows common state base rates as a starting point:

Note: Alaska has no state tax but local taxes apply. Oregon, Montana, Delaware, and New Hampshire have no sales tax at all.

7. Backing Out Tax in Excel

If you need to back out tax from a large list of receipts, Excel is your best friend. Here's the formula:

Where A2 = Final price (tax-included) and B2 = Tax rate as a decimal (e.g., 0.0825 for 8.25%)

Pro tip: Format Column B as a percentage (%) so you can type 8.25 instead of 0.0825, then adjust the formula to =A2/(1+B2/100).

8. Tools That Help At Scale

Solo operators can use spreadsheets with the formula =Total/(1+Rate). Growing teams add receipt OCR apps — but OCR still needs the rate. Train staff to photograph the full receipt, not just the total line, so the tax rate is visible.

Our browser calculator needs no login; numbers stay local. For recurring vendors in one jurisdiction, save the rate as a spreadsheet constant.

9. Common Mistakes to Avoid

10. Audit Trail Best Practices

IRS and state auditors care about substantiation, not fancy software. Keep: date, vendor, total paid, rate used, computed pre-tax, computed tax, and receipt image. If rate was estimated, note why (e.g., "standard Cook County 10.25% — receipt faded").

Resellers with resale certificates should not pay tax on inventory — but when they do by mistake, reverse math documents the overpayment to chase refunds from vendors.

Related: What is reverse sales tax? · Calculator

11. Industry-Specific Notes

Construction: Materials bought at retail with tax may be embedded in job costing — reverse split clarifies true material vs tax for certified payroll reports.

Restaurants: Tips are separate; tax applies to taxable sales only. Use pre-tip subtotal when the receipt separates it.

E-commerce resale: Platform 1099-K shows gross payouts; your COGS receipts need pre-tax bases for Schedule C margin analysis.

12. Month-End Close Checklist

• Export card transactions
• Match receipts or infer rate by vendor location
• Reverse-calculate or read tax lines
• Post to GL accounts
• Reconcile Sales Tax Payable if you collect tax as a seller

13. Scaling without Losing Accuracy

At 50 receipts a week, spreadsheet columns beat one-off calculator visits. At 500, integrate OCR plus human rate verification. At 5,000, rules by vendor ZIP plus exception queue for missing tax lines. The formula never changes — only the routing of work.

Outsource bookkeeping partners should document rate sources in English, not "system calculated." Auditors accept reverse worksheets; they resist black-box labels.

Automate forward checks: pre-tax × (1 + rate) must equal total within a cent. Flag rows that fail before posting.