Adding tax is simple: multiply by the rate and add it on. Taking tax back out of a price that already includes it catches out a surprising number of people, including in spreadsheets used for real invoices.
Adding tax
At a 20% rate, a net price of 100 carries 20 of tax, for a total of 120. The tax is 20% of the price before tax.
The mistake when removing it
Now start from the 120 and try to get back to 100. Taking 20% off 120 gives 96, not 100. That is because the 20% was calculated on 100, the smaller number, and you are now applying it to 120.
The same thing happens with any price. If a receipt says 100 including 20% VAT, the price before tax is not 80.
The right formula
Divide the tax-inclusive price by one plus the tax rate. At 20%, divide by 1.2. At 5%, divide by 1.05. At 8.25%, divide by 1.0825.
Price before tax
100 ÷ (1 + 20%)equals83.33
Tax included
100 − 83.33equals16.67
You can check the answer by adding the tax back: 83.33 × 1.2 is 100, give or take a rounding cent.
A sales tax example
US sales tax is usually added at the till rather than included in the shelf price, but the math is identical. At an 8.25% rate, a $250 purchase carries $20.63 of tax, for $270.63. Going back, $270.63 ÷ 1.0825 returns $250.00.
Where people slip up
- Subtracting the rate instead of dividing, as above.
- Rounding the tax on each line of an invoice and then again on the total, which can leave the two a cent apart.
- Using the wrong rate. Many countries have reduced rates for some goods, and US sales tax can differ by state and city.
The same formula in any country
The rate changes from country to country, but the method never does: divide by one plus the rate. A few standard rates as examples:
- UK VAT at 20%: £1,200 including VAT ÷ 1.20 = £1,000 before VAT.
- Saudi Arabia VAT at 15%: SAR 1,150 ÷ 1.15 = SAR 1,000.
- UAE VAT at 5%: AED 1,050 ÷ 1.05 = AED 1,000.
- Pakistan sales tax at 18%: Rs 11,800 ÷ 1.18 = Rs 10,000.
These are standard rates. Many countries charge reduced or zero rates on some goods and services, so check which rate applies to what you are selling before you rely on the result.
How much of the total is tax?
Sometimes you only need the tax part, for example to fill in a return from a pile of tax-inclusive receipts. The tax share of a tax-inclusive total is the rate divided by one plus the rate:
- At 5%, tax is 4.76% of the total.
- At 15%, tax is 13.04% of the total.
- At 18%, tax is 15.25% of the total.
- At 20%, tax is 16.67% of the total, exactly one sixth.
Why the invoice and the total can disagree by a cent
Rounding is where careful people still get caught. Take three items priced at 9.99 each, including 20% VAT, for a total of 29.97.
- Working line by line: 9.99 ÷ 1.2 = 8.325, which rounds to 8.33. Three lines give 24.99 net and 4.98 of VAT.
- Working on the total: 29.97 ÷ 1.2 = 24.975, which rounds to 24.98 net and 4.99 of VAT.
Both are reasonable, and they differ by one cent. Neither is wrong, but you should pick one method and use it consistently on every invoice. Tax authorities generally accept either as long as you are consistent, but check the rules where you are registered. Accounting software usually makes the choice for you, so if you mix a spreadsheet with software, expect the occasional one-cent gap.
Discounts: does the order matter?
For percentage discounts, no. A 10% discount on a 100 net price followed by 20% VAT gives 108. Adding VAT first and then taking 10% off 120 also gives 108, because the two multiplications can happen in either order.
For fixed-amount discounts, the order matters a lot. Taking 10 off before VAT gives (100 − 10) × 1.2 = 108. Taking 10 off the VAT-inclusive price gives 120 − 10 = 110. When you offer a customer "10 off", say whether it comes off before or after tax, and make sure your invoice does the same thing.
Tip: Keep a quick check handy: the tax share of a tax-inclusive price is rate ÷ (1 + rate). At 20% that is 1/6, or 16.67%, of the total.
Questions people ask
- What share of a VAT-inclusive price is VAT at 15%?
- About 13.04%, calculated as 0.15 ÷ 1.15.
- How do I remove VAT from a price?
- Divide the VAT-inclusive price by one plus the rate. At 20%, divide by 1.2: 100 becomes 83.33.
- Why can't I just subtract 20% to remove VAT?
- The VAT was calculated on the smaller net price. Taking 20% off 120 gives 96, not the original 100.
- What share of a VAT-inclusive price is VAT?
- Rate ÷ (1 + rate). At 20% that is one sixth, or 16.67%, of the total.
- Does it matter if a discount is applied before or after VAT?
- Not for percentage discounts, which give the same result either way. For fixed-amount discounts it does: 10 off before 20% VAT gives 108, but 10 off after VAT gives 110.
- How do I remove 18% sales tax from a price?
- Divide by 1.18. For example, Rs 11,800 including 18% tax is Rs 10,000 before tax, with Rs 1,800 of tax.