How do you calculate reverse sales tax from a total?

To calculate reverse sales tax, divide the tax-inclusive gross total by (1 + tax rate in decimal form). Formula: Pre-Tax Base = Gross Total / (1 + Tax Rate). For example, on a $108.25 receipt with 8.25% sales tax, divide 108.25 by 1.0825 to get $100.00 net price and $8.25 tax.

Why can I not just subtract the sales tax percentage from the total?

Subtracting the tax percentage from a gross total applies the percentage to a larger tax-inclusive base, understating your true revenue. On a $108.25 receipt with 8.25% tax, subtracting 8.25% yields $99.32 instead of the true $100.00 pre-tax price, causing a $0.68 accounting discrepancy.

How do I back out sales tax in Excel or Google Sheets?

If cell A2 holds the gross receipt total and B2 holds the sales tax rate as a percentage (e.g., 8.25%), use =A2/(1+B2) to extract the pre-tax revenue and =A2-(A2/(1+B2)) to extract the sales tax collected.

Does this reverse tax calculator work for Canadian GST/HST and UK VAT?

Yes. Whether you are extracting 5% GST, 13% Ontario HST, 14.975% Quebec GST+QST, US state/local sales tax, or 20% UK/EU VAT, the inverse divisor formula Total / (1 + Tax Rate) produces exact accounting splits.

Tool #27 • Tax & Bookkeeping Suite

Reverse Sales Tax Calculator & Receipt Extractor

Back out sales tax, HST, GST, or VAT from any tax-inclusive receipt total in milliseconds. Extract exact pre-tax revenue, verify inverse divisors, and process bulk receipts with zero server latency.

Quick Rates:

⚙ Receipt & Tax Parameters

● Instant Client-Side

Tax-Inclusive Gross Total Paid Final receipt amount

Combined Sales Tax / VAT Rate Divisor: ÷ 1.0825

Currency Symbol

Decimal Precision

📊 Extracted Tax Breakdown

Single Receipt

Pre-Tax Net Price

$100.00

True Net Revenue

Sales Tax Extracted

$8.25

Inverse Divisor

÷ 1.0825

1 + (Rate / 100)

Gross Total Input

$108.25

Net + Tax = 100% Match

⚠ Subtraction Trap Avoided: Subtracting 8.25% directly from $108.25 gives $99.32 — a -$0.68 bookkeeping error. Always divide by 1.0825.

Pre-Tax Base Formula $108.25 / 1.0825

Excel / Google Sheets Formula =108.25/(1+0.0825)

Effective Tax Rate Weight 7.6212% of Total

Interactive Reverse Sales Tax Divisor Cheat Sheet

Click any row below to load that tax rate into the calculator immediately.

Click Row to Apply

Tax Rate (%)	Reverse Divisor	$100.00 Gross → Net Base	Extracted Tax Portion	Common Region / Tax Type
5.00%	÷ 1.0500	$95.24	$4.76	Canada Federal GST / Wisconsin
6.00%	÷ 1.0600	$94.34	$5.66	Florida, Pennsylvania, Michigan, Georgia
7.00%	÷ 1.0700	$93.46	$6.54	Indiana, New Jersey (6.625%), Mississippi
8.00%	÷ 1.0800	$92.59	$7.41	Standard US Combined Metro Rate
8.25%	÷ 1.0825	$92.38	$7.62	Texas Max Combined, California Cities
8.875%	÷ 1.08875	$91.85	$8.15	New York City Combined Sales Tax
10.00%	÷ 1.1000	$90.91	$9.09	Chicago, Seattle, Los Angeles Metro
13.00%	÷ 1.1300	CA$88.50	CA$11.50	Ontario Harmonized Sales Tax (HST)
15.00%	÷ 1.1500	CA$86.96	CA$13.04	Atlantic Canada HST (NS, NB, NL, PE)
20.00%	÷ 1.2000	£83.33	£16.67	United Kingdom & EU Standard VAT

How Reverse Sales Tax Works: Mathematical Formula & Bookkeeping Rules

Whether you run a retail point-of-sale counter that includes tax in shelf prices, reconcile merchant payouts from Stripe or Square, or log cash expenses into QuickBooks and Xero, separating tax collected from net revenue requires division—not subtraction.

Pre-Tax Base Price = Gross Total ÷ (1 + Sales Tax Rate)
Sales Tax Amount = Gross Total − Pre-Tax Base Price

Why Subtracting the Tax Rate Causes Audit Errors

When sales tax is originally added to a $100.00 item at 8.25%, the buyer pays $108.25. That $8.25 tax was calculated as 8.25% of $100.00, not 8.25% of $108.25. Multiplying $108.25 by 8.25% mistakenly takes tax on top of the tax itself ($8.93), leaving you with $99.32 instead of $100.00. Over thousands of transactions, this mistake artificially lowers reported net income and creates sales tax filing mismatches.

Explore Related Tax & Accounting Tools

→ Complete Reverse Sales Tax Guide & Audit Pitfalls → US Sales Tax Calculator (50 States + ZIP Code) → Canada GST / HST / PST Calculator → UK & EU Reverse VAT Calculator

Engineered & Audited by Syed Abdullah Shah

Head of Technical SEO & Financial Utilities at SBS Digitals. Mathematically verified for US State Dept of Revenue, CRA GST/HST, and HMRC VAT ledger reconciliation.