VAT Calculator: Inclusive and Exclusive Prices
VAT calculator, inclusive and exclusive: add VAT or GST to a net price, or remove it from a gross price, at any rate you choose.
Amount including VAT
- Net (excluding VAT)
- $200.00
- VAT
- $40.00
- Gross (including VAT)
- $240.00
- VAT share of the gross amount
- 16.6667%
How to use the VAT Calculator
- Choose Add VAT to go from a net price to a gross price, or Remove VAT to find the net price inside a VAT-inclusive amount.
- Enter the amount.
- Type the VAT or GST rate, or tap one of the quick rates (5, 10, 15 or 20%).
- Read the net amount, the VAT and the gross amount. The VAT share of the gross amount shows what fraction of a VAT-inclusive price is tax.
Formula
VAT = N × r ÷ 100 · G = N × (1 + r ÷ 100) · N = G ÷ (1 + r ÷ 100)
Where:
- N
- Net amount, excluding VAT
- G
- Gross amount, including VAT
- r
- VAT or GST rate in percent (20 for 20%)
- VAT
- The tax amount: G − N
To find the VAT inside a gross amount directly, use VAT = G × r ÷ (100 + r). At 20% that is one sixth of the gross price, not 20% of it.
Worked example
A supplier quotes $200.00 excluding VAT, and the VAT rate is 20%.
- VAT: 200 × 20 ÷ 100 = $40.00.
- Gross: 200 + 40 = $240.00.
- Check by removing VAT: 240 ÷ 1.20 = $200.00, and 240 × 20 ÷ 120 = $40.00 of VAT.
The VAT is $40.00 and the price including VAT is $240.00.
VAT inclusive vs VAT exclusive
Every price in a VAT system can be quoted two ways. A VAT exclusive price is the net amount: the figure before tax, which is what a business keeps. A VAT inclusive price is the gross amount: net plus VAT, which is what the customer pays. Invoices between businesses usually show net, VAT and gross separately, while shop prices in most VAT countries show only the gross figure.
That is why two modes are needed. Add VAT turns an exclusive price into an inclusive one. Remove VAT finds the net price and the tax inside an inclusive amount, the everyday job for expense claims, bookkeeping and comparing quotes. Before you start, decide which kind of price you hold: business price lists are often net, consumer prices usually gross. Adding VAT to a price that already includes it taxes the tax.
How to add VAT to a price
Multiply the net amount by the rate to get the VAT, or by one plus the rate to get the gross amount in a single step. A freelancer invoicing $100 of work at a 5% rate charges 100 × 0.05 = $5.00 of VAT, so the invoice total is 100 × 1.05 = $105.00.
Each rate has one factor that works in both directions: multiply a net price by it to add VAT, divide a gross price by it to remove VAT.
| Rate | Factor | VAT inside a gross price |
|---|---|---|
| 5% | 1.05 | 1/21 (4.76%) |
| 10% | 1.10 | 1/11 (9.09%) |
| 15% | 1.15 | 3/23 (13.04%) |
| 20% | 1.20 | 1/6 (16.67%) |
These four rates match the quick-rate buttons. They are round numbers, not any country's official rate, and decimal rates such as 7.7% or 13.5% can be typed in.
How to remove VAT from a price
Removing VAT is where errors creep in, because the rate was charged on the net price and is therefore a smaller share of the gross price. Divide; do not subtract the percentage. Take a receipt for $1,150.00 that includes VAT at 15%:
- Factor: 1 + 15 ÷ 100 = 1.15.
- Net: 1,150 ÷ 1.15 = $1,000.00.
- VAT: 1,150 − 1,000 = $150.00.
Subtracting 15% of the gross would give $172.50 of VAT, overstating the tax by $22.50 and understating the net price.
Working out VAT backwards from a total
When only the tax is needed, skip the net step and use the VAT fraction, the share of an inclusive price that is tax: rate ÷ (100 + rate). It is the last column of the table above, and the result shows it for any rate you enter. At 20% the VAT is one sixth of the gross amount, so a $600 total holds $100 of VAT and $500 net.
The same method answers how to calculate GST from a total amount. A $550 bill that includes GST at 10% is 550 ÷ 1.1 = $500 before tax, and the GST is $50, one eleventh of the bill.
In a spreadsheet, with the amount in cell A1 and a 20% rate:
=A1*1.2adds VAT to a net amount.=A1/1.2removes VAT from a gross amount.=A1-A1/1.2returns the VAT inside a gross amount.
VAT, GST and sales tax
Value-added tax is charged at each step of the supply chain. Every business adds it to its prices, reclaims what it paid on its own purchases and passes the difference to the tax authority, so the final consumer carries the whole tax. Many countries call the same system goods and services tax, and Canada's harmonized sales tax (HST) combines federal and provincial parts in one rate. The arithmetic is identical, so this page doubles as a GST calculator: enter your GST or HST rate. US-style sales tax differs in being charged once, at the final sale, and added at the register.
Most systems run several rates at once: a standard rate, reduced rates for items such as food, books or medicines, and a zero rate. Check the rate for the specific goods or service, and keep its decimals.
Assumptions and disclaimer
A single percentage rate is applied to a single amount, and figures are rounded only for display. Rounding net, VAT and gross separately can leave a one-cent difference; follow your local rule on rounding per line or per invoice. No country's rates, registration thresholds, reverse-charge rules, exemptions or flat-rate schemes are built in. This is a general estimate for information, not tax advice; for invoices and returns, confirm the rate and rules with your tax authority or an accountant.
Frequently asked questions
How do I add VAT to a price?
Multiply the net price by 1 plus the rate as a decimal. At 20%, multiply by 1.2: $200 becomes $240. At 5%, multiply by 1.05: $100 becomes $105. The VAT itself is the net price × rate ÷ 100, which is $40 and $5 in these two cases.
How do I remove VAT from a price?
Divide the gross price by 1 plus the rate as a decimal. At 15%, a $1,150 VAT-inclusive price is 1,150 ÷ 1.15 = $1,000 net, so the VAT is $150. A common mistake is to subtract 15% of $1,150 ($172.50), which overstates the VAT.
How do I work out VAT backwards from a gross price?
Multiply the gross amount by rate ÷ (100 + rate). At 20% that fraction is 20/120 = 1/6, so a $240 gross price contains $40 of VAT. At 5% the fraction is 1/21. The VAT is not 20% of the gross amount, because the 20% was charged on the net price. The calculator shows this fraction as the VAT share of the gross amount.
How do I calculate GST from a total amount?
Exactly as for VAT: divide the GST-inclusive total by 1 plus the rate to get the amount before GST, then subtract. A $550 total at a 10% rate is 550 ÷ 1.1 = $500 before GST, so the GST is $50, one eleventh of the total. Choose Remove VAT and enter your GST or HST rate; only the name of the tax differs.
What is the difference between VAT and GST?
For this math, none. GST (goods and services tax) is the name used in Canada, Australia, New Zealand, India, Singapore and elsewhere for a value-added tax. Canada's HST combines federal and provincial parts into one rate. All are added to and removed from prices in exactly the same way, so enter your GST or HST rate here.
What is VAT, and how is it different from sales tax?
VAT (value-added tax) is a tax on spending charged at every stage of production and distribution, with businesses reclaiming the VAT they paid on inputs, and consumer prices usually include it. Sales tax, used in most US states, is charged once at the final sale and usually added at the till. For a buyer the math is the same; the Sales Tax Calculator uses US-style wording.
Related calculators
- Sales Tax CalculatorReverse sales tax calculator: split a total into price before tax and tax, or add sales tax to a price, at any rate.
- Profit Margin CalculatorProfit margin & markup calculator: get profit, margin and markup from cost and selling price, or the selling price that hits a target margin.
- Discount CalculatorDouble discount calculator: see the final price and your savings after one or two stacked discounts, or find the percent off between two prices.
- Percentage CalculatorA percentage calculator: of a number, as a share of a total, or back to the whole from a part, with the formula shown.
- Percentage Change CalculatorA percentage change calculator between two numbers: the percent increase or decrease from old to new, or the percentage difference.
- Currency ConverterUse this currency converter with custom rate entry: start from a dated mid-market reference rate or type the rate your bank quotes, across 32 currencies.
Last updated: