Reverse Sales Tax Calculator: Find Tax From a Total
Use a reverse sales tax calculation to find the pre-tax price and tax from a total. Formula, worked examples for sales tax and VAT, rounding and common errors.
Quick answer: To calculate sales tax from a total, divide the total by 1 plus the tax rate as a decimal. That gives the pre-tax price. Subtract it from the total to get the tax. Example: a $541.25 total at 8.25% tax is $541.25 ÷ 1.0825 = $500.00 before tax, so the sales tax is $41.25. The same method works for VAT and GST.
A reverse sales tax calculation is what you need when someone hands you a single "all-in" figure: a client who agreed a total budget, a receipt that only shows the grand total, or a price you quoted including tax. This guide shows the formula, worked examples for US sales tax, UK VAT and other rates, how to handle rounding and the mistakes that overstate tax. If you want the answer without the arithmetic, our sales tax calculator has an inclusive mode that backs the tax out for you, and you can put the result straight onto an invoice in the free invoice generator.
Important: This article is general information, not tax advice. Tax rates, what is taxable and how tax must be shown on invoices vary by country, state and locality, and they change. Confirm the correct rate and rules with your tax authority or a qualified adviser.
The reverse sales tax formula
When tax is added to a price, the total is:
Total = Pre-tax price × (1 + rate)
Rearranging gives the two formulas you need:
- Pre-tax price = Total ÷ (1 + rate)
- Tax amount = Total − Pre-tax price, or Total × rate ÷ (1 + rate)
Write the rate as a decimal: 8.25% is 0.0825, 20% is 0.20, 5% is 0.05.
How to calculate sales tax from a total: step by step
- Find the correct rate. In the US this is usually a combined rate: state plus county, city and any special district. Use the rate for the place where the sale is sourced.
- Convert it to a decimal and add 1. 8.25% becomes 1.0825.
- Divide the total by that number. $541.25 ÷ 1.0825 = $500.00.
- Subtract to find the tax. $541.25 − $500.00 = $41.25.
- Check it forwards. $500.00 × 8.25% = $41.25, and $500.00 + $41.25 = $541.25. If the forward check matches, you are done.
The sales tax calculator does steps 2 to 5 automatically: choose inclusive mode, enter the total and the rate, and it shows net, tax and gross.
Reverse sales tax examples at common rates
| Total (tax included) | Rate | Divide by | Pre-tax price | Tax |
|---|---|---|---|---|
| $541.25 | 8.25% | 1.0825 | $500.00 | $41.25 |
| $1,085.00 | 8.5% (6% state + 1% county + 1.5% city) | 1.085 | $1,000.00 | $85.00 |
| $212.00 | 6% | 1.06 | $200.00 | $12.00 |
| £1,440.00 | 20% VAT | 1.20 | £1,200.00 | £240.00 |
| £210.00 | 5% VAT | 1.05 | £200.00 | £10.00 |
| AED 2,625.00 | 5% VAT | 1.05 | AED 2,500.00 | AED 125.00 |
| Rs 59,000 | 18% sales tax | 1.18 | Rs 50,000 | Rs 9,000 |
The combined-rate row in the table is illustrative; look up the actual combined rate for your location, because US local rates differ even between neighboring towns. Our guide to sales tax on invoices in the US explains sourcing and how to show the rate.
VAT-inclusive back-calculation and the VAT fraction
Outside the US, prices to consumers are often quoted including VAT or GST, so backing out tax is an everyday job. The method is identical: divide the gross price by 1 plus the rate. Many accountants also use the VAT fraction, which gives the tax directly:
VAT fraction = rate ÷ (1 + rate)
| Rate | VAT fraction | Example gross | VAT | Net |
|---|---|---|---|---|
| 20% | 1/6 | £1,440.00 | £240.00 | £1,200.00 |
| 5% | 1/21 | AED 2,625.00 | AED 125.00 | AED 2,500.00 |
| 15% | 3/23 | R 1,150.00 | R 150.00 | R 1,000.00 |
| 10% | 1/11 | $1,100.00 | $100.00 | $1,000.00 |
So at the UK standard rate, VAT is one-sixth of a VAT-inclusive price, not 20% of it. HMRC publishes the current rates on its VAT rates page. For what a valid VAT invoice must show once you have the net and VAT figures, see our VAT invoice guide; UAE businesses should also read the UAE tax invoice requirements.
Worked example: turning an all-in budget into an invoice
A client in a city with an 8.25% combined sales tax rate agrees to pay "$3,247.50 all in" for taxable goods: 30 branded items. You need to invoice with tax shown separately.
- Pre-tax subtotal: $3,247.50 ÷ 1.0825 = $3,000.00.
- Unit price: $3,000.00 ÷ 30 = $100.00.
- Sales tax: $3,000.00 × 8.25% = $247.50.
- Total: $3,000.00 + $247.50 = $3,247.50. It matches the agreed figure.
| Description | Qty | Unit price | Amount |
|---|---|---|---|
| Branded tote bags, printed two sides | 30 | $100.00 | $3,000.00 |
| Subtotal | $3,000.00 | ||
| Sales tax 8.25% | $247.50 | ||
| Total due | $3,247.50 | ||
If the client's budget had included an untaxed delivery charge, you would need to remove that first, because tax applies only to the taxable part. Whether delivery is taxable depends on the state. The US invoice generator lets you add a tax rate and shows subtotal, tax and total on separate lines.
Rounding: why reverse calculations can be a cent off
Tax on the original sale is rounded to the cent, so dividing back sometimes produces an awkward fraction. Take a $49.99 total at 7%:
- $49.99 ÷ 1.07 = $46.7196..., which rounds to $46.72.
- Tax: $46.72 × 7% = $3.2704, which rounds to $3.27.
- Check: $46.72 + $3.27 = $49.99. It ties out.
When the check is one cent off, adjust the tax line (not the price) by a cent so the invoice total matches what was agreed, and keep the method consistent. Some tax authorities set their own rounding rules, for example per line or per invoice, so follow local guidance if it exists.
Common reverse sales tax mistakes
| Shortcut | Result on $541.25 at 8.25% | Correct | Error |
|---|---|---|---|
| Total × rate | Tax $44.65 | $41.25 | Tax overstated by $3.40 |
| Total × (1 − rate) | Pre-tax $496.60 | $500.00 | Price understated by $3.40 |
| Total ÷ (1 + rate) | Pre-tax $500.00 | $500.00 | None |
Other errors to watch for:
- Using the state rate only when local taxes also apply. The pre-tax price comes out too high and the tax too low.
- Applying one rate to a mixed basket. If some items are exempt or taxed at a reduced rate, split the total by item first.
- Backing out tax from amounts that were never taxed, such as tips, deposits or exempt services.
- Calculating profit on the gross figure. Tax you collect is not revenue. Our guide to markup vs margin shows why margin must be calculated on the pre-tax price.
When you need a reverse sales tax calculation
- Bookkeeping from receipts. Many receipts show only the total. To record the expense and any recoverable tax, you need the split. Our bookkeeping basics guide covers how to record it.
- Tax-inclusive quotes. If you quoted a consumer an inclusive price, your invoice still needs the net and tax amounts in many systems.
- Marketplace and point-of-sale reports that show gross takings.
- Checking a supplier's invoice where the tax line looks wrong.
- Fixed-budget work, where a client says "we have $X including tax".
Before quoting tax-inclusive prices, check local rules. In the UK, prices shown to consumers generally have to include VAT, while US prices are usually shown before sales tax and some states have specific rules on advertising tax-included prices.
Worked example: a receipt with taxable and exempt items
Reverse calculations go wrong most often on mixed receipts. Say a receipt totals $164.20 and includes $40.00 of items that are exempt in that state, with the rest taxed at 8%.
- Take out the exempt items first: $164.20 − $40.00 = $124.20 of taxable goods including tax.
- Back the tax out of the taxable part only: $124.20 ÷ 1.08 = $115.00.
- Tax: $124.20 − $115.00 = $9.20. Check: $115.00 × 8% = $9.20.
- Totals: $40.00 exempt + $115.00 taxable + $9.20 tax = $164.20.
Dividing the whole $164.20 by 1.08 would give $152.04 and a tax figure of $12.16, overstating tax by $2.96. If you are reclaiming input tax on business purchases, as VAT-registered businesses can, overstating it is a compliance problem, not just a rounding issue.
Reverse sales tax in a spreadsheet
If the total is in cell A2 and the rate (as a decimal) in B2:
- Pre-tax:
=ROUND(A2/(1+B2),2) - Tax:
=A2-C2(where C2 holds the pre-tax figure) - Check:
=ROUND(C2*B2,2)should equal the tax cell, or be within a cent.
For a full invoice layout with formulas, see how to make an invoice in Excel.
Next step
Take your most recent tax-inclusive receipt or quote and run it through the sales tax calculator in inclusive mode. Check the result forwards, then enter the net price and rate in the invoice generator with the corporate template so subtotal, tax and total show on separate lines.
Frequently asked questions
How do I calculate sales tax from the total amount?
Divide the total by one plus the tax rate to get the pre-tax price, then subtract that from the total to get the tax. For a $541.25 total at 8.25%, $541.25 ÷ 1.0825 = $500.00, so the tax is $41.25.
Why can't I just multiply the total by the tax rate?
Because the tax rate applies to the pre-tax price, not the total. Multiplying a tax-inclusive total by the rate overstates the tax. On a $541.25 total at 8.25%, that shortcut gives $44.65 instead of the correct $41.25.
What is the VAT fraction?
The VAT fraction is a shortcut for extracting VAT from a VAT-inclusive price. At a 20% rate the fraction is 1/6, and at 5% it is 1/21. Multiply the gross amount by the fraction to get the VAT.
How do I reverse calculate tax when several rates apply?
Add the state, county, city and any district rates together to get the combined rate, then divide the total by one plus the combined rate. This only works when every rate applies to the same base; if some items are taxed differently, split the total by item first.
Why does my reverse calculation come out a cent off?
Tax is usually rounded to the nearest cent on the original sale, so dividing the rounded total back can produce a fraction of a cent. Round the pre-tax amount to the cent, recalculate the tax from it, and check that the two add back to the original total. Adjust the tax by a cent if needed.
How do I find the tax rate if I know the total and the pre-tax price?
Divide the total by the pre-tax price, subtract 1 and multiply by 100. For example, a $540.00 total on a $500.00 pre-tax price gives 540 ÷ 500 = 1.08, so the rate is 8%. Expect small differences caused by rounding to the cent, and confirm the official rate with your tax authority before you use it on your own invoices.
How do I work out GST from a GST-inclusive price in Australia?
Divide the GST-inclusive price by 11. At Australia's 10% GST rate the GST fraction is 1/11, so a $1,100 price includes $100 of GST and $1,000 before GST. This works only when the whole amount is taxable; take GST-free items out first. The ATO publishes the rules for working out GST and for what a tax invoice must show.
How do I reverse calculate tax when a discount was applied before tax?
Use the same formula; the result is simply the discounted pre-tax price. Tax is normally charged on the price after a seller's discount, so dividing the total by 1 plus the rate gives the net amount after the discount. If you also need the original list price, divide that net figure by 1 minus the discount rate. Manufacturer coupons and rebates can be taxed differently by state, so check local rules.
Can I reclaim the tax I back out of a receipt?
It depends on the tax system. VAT and GST registered businesses can usually reclaim input tax on business purchases if they hold a valid tax invoice, so backing out the exact figure matters. US sales tax works differently: a business buyer generally cannot reclaim it and records it as part of the cost, unless it was charged in error or a resale or exemption certificate applied. Check with your tax authority.
How do I add tax to a pre-tax price?
Multiply the pre-tax price by 1 plus the tax rate as a decimal. A $500.00 price at 8.25% becomes $500.00 × 1.0825 = $541.25, of which $41.25 is tax. This is the forward version of the reverse calculation and how most invoices are built: list net amounts, add tax on its own line, then show the total. Our free invoice generator calculates the tax line for you when you enter a rate.
Invoice Creator Editorial Team
Guides on invoicing, cash flow and small-business finance from Invoice Creator, operated by Next Software Development Company. Content is reviewed for accuracy against the fields our own invoice generator produces.
Try the invoice generator