VAT Calculator
Add or remove VAT from a price and calculate the net amount, VAT amount, and VAT-inclusive total.
Editorial and Accuracy Standards
What Is VAT?
VAT (Value Added Tax) is a consumption tax applied to goods and services in jurisdictions that use VAT. A VAT-exclusive price does not include VAT, while a VAT-inclusive price already includes the tax.
This calculator can add VAT to a net price or remove VAT from a VAT-inclusive total.
VAT-Inclusive vs VAT-Exclusive
| Term | Meaning |
|---|---|
| VAT-Exclusive / Net | Price before VAT |
| VAT Amount | Tax component calculated using the applicable rate |
| VAT-Inclusive / Gross | Price after VAT has been included |
Example (Add VAT)
Net = $100
VAT Rate = 20%
VAT = $20
Gross = $120
Reverse (Remove VAT)
Gross = $120
VAT Rate = 20%
Net = $100
VAT = $20
VAT Calculation Formulas
Add VAT
VAT Amount = Net Amount × VAT Rate / 100Gross Amount = Net Amount + VAT AmountRemove VAT
Net Amount = Gross Amount / (1 + VAT Rate / 100)VAT Amount = Gross Amount - Net AmountVAT From a VAT-Inclusive Total
VAT Amount = Gross Amount × VAT Rate / (100 + VAT Rate)The denominator is 100 + VAT Rate when extracting VAT from a VAT-inclusive price because the gross price already includes both the original 100% (the net amount) and the additional VAT percentage. You are working backwards from a total that represents (100 + VAT)% of the original price.
How to Add VAT to a Price
Example:
Net Price = $100
VAT Rate = 20%
VAT:
$100 × 20 / 100 = $20
Gross:
$100 + $20 = $120
Final:
Net = $100 | VAT = $20 | Gross = $120
How to Remove VAT From a Price
Example:
Gross Price = $120
VAT Rate = 20%
Net:
$120 / 1.20 = $100
VAT:
$120 - $100 = $20
Final:
Net = $100 | VAT = $20 | Gross = $120
How to Calculate VAT From a VAT-Inclusive Price
Formula:
VAT = Gross × VAT Rate / (100 + VAT Rate)Example:
Gross = $120
VAT Rate = 20%
VAT = $120 × 20 / 120
= $20
Example calculations using a 20% VAT rate.
Note: 20% is used as an example rate. VAT rates vary by jurisdiction and transaction.
| Net Amount | VAT | Gross Amount |
|---|---|---|
| $50 | $10 | $60 |
| $100 | $20 | $120 |
| $200 | $40 | $240 |
| $500 | $100 | $600 |
| $1,000 | $200 | $1,200 |
VAT vs GST
VAT and GST are consumption-tax systems, but the terminology and rules depend on the jurisdiction.
India's GST system subsumed State VAT for many goods and services. Users calculating Indian GST should use the GST Calculator rather than assuming the VAT calculator represents Indian GST rules.
Real-World Use Cases
Retail Invoicing
Check net price, VAT amount, and customer-facing gross price.
Accounting and Bookkeeping
Verify the relationship between net, VAT, and gross amounts.
Pricing
Calculate a VAT-inclusive selling price from a VAT-exclusive amount.
Invoice Checking
Reverse-calculate the VAT component from a VAT-inclusive invoice total.
Common VAT Mistakes
Mistake 1 — Applying the VAT rate directly to a VAT-inclusive price
Wrong: $120 × 20% = $24
Correct: $120 × 20 / 120 = $20
Mistake 2 — Confusing net and gross amounts
Applying the formula for net to a gross amount will result in incorrect tax reporting.
Mistake 3 — Using the wrong VAT rate
Rates can change and often depend on the specific type of goods or services.
Mistake 4 — Assuming every country has the same VAT rate
VAT rates vary widely between jurisdictions.
Mistake 5 — Confusing VAT with GST
Though conceptually similar, the specific rules, thresholds, and terminology are distinct.
Mistake 6 — Rounding too early
Wait until the final result to round to two decimal places to avoid compounding errors.
How to Calculate VAT in Excel
Assuming B2 contains 20% formatted as a percentage.
Adding VAT
For Net Amount in A2:
=A2*B2=A2*(1+B2)Removing VAT
For Gross Amount in A2:
=A2/(1+B2)=A2-(A2/(1+B2))Disclaimer: VAT rules, rates, exemptions, and registration requirements vary by jurisdiction and can change. This calculator provides mathematical calculations based on the rate you enter and is not tax or legal advice. Check the applicable tax authority guidance for your transaction.
Frequently Asked Questions
How do I add 20% VAT to a price?↓
Multiply the net price by 0.20 to find the VAT amount, then add it to the net price. Alternatively, multiply the net price by 1.20 to find the gross amount instantly.
How do I figure out 20% VAT from a total?↓
To extract a 20% VAT from a gross total, divide the total by 1.20 to find the net amount. Subtract the net amount from the gross total to find the exact VAT amount.
What is the formula for adding VAT?↓
The formula is: Net Amount + (Net Amount × (VAT Rate / 100)) = Gross Amount. Alternatively: Net Amount × (1 + (VAT Rate / 100)).
How to extract VAT from a gross amount?↓
Divide the gross amount by (1 + (VAT Rate / 100)) to find the net amount. The difference between the gross and net amount is the VAT.
What does VAT-exclusive mean?↓
VAT-exclusive means the price does not include Value Added Tax. It is the net price before any tax is added.
What is the difference between VAT and GST?↓
VAT (Value Added Tax) and GST (Goods and Services Tax) are both consumption taxes applied at each stage of the supply chain. The terminology and specific rules depend on the jurisdiction, but they operate on similar economic principles.
Can a VAT rate be 0%?↓
Yes. Many jurisdictions have a 0% rate (zero-rated) for essential items like certain foods, children's clothing, or exports, meaning no VAT is charged, but businesses can still reclaim input VAT.
Is VAT applied to all goods and services?↓
No. Some goods and services are exempt from VAT, such as certain financial services, healthcare, and education, depending on local tax laws.
How do I calculate VAT backwards?↓
To calculate VAT backwards from a gross amount, use the formula: VAT = Gross × VAT Rate / (100 + VAT Rate).
Why do I divide by 1.2 to remove 20% VAT?↓
Because a VAT-inclusive price represents 120% (100% net + 20% VAT) of the original price. Dividing by 1.2 (which is 120/100) scales the amount back down to the original 100% net price.
What happens if I make a mistake calculating VAT?↓
Mistakes can lead to overcharging customers, underpaying tax authorities, or claiming incorrect deductions. This may result in penalties, interest charges, or compliance audits.
How is VAT calculated in Excel?↓
To add 20% VAT in Excel, multiply the net amount cell by 1.2 (e.g., =A2*1.2). To remove 20% VAT from a gross amount, divide by 1.2 (e.g., =A2/1.2).
Is it legal to charge VAT if not registered?↓
No. It is generally illegal to charge VAT or issue VAT invoices if your business is not officially registered for VAT with the tax authority.
How do I find the net amount before VAT?↓
Divide the gross (VAT-inclusive) amount by (1 + (VAT Rate / 100)). For example, for a 20% rate, divide the gross amount by 1.20.
More Tax Calculators
GST Calculator
Calculate Goods and Services Tax inclusive and exclusive amounts.
Sales Tax Calculator
Calculate Sales Tax inclusive and exclusive amounts.
Profit Margin
Calculate profit margin based on cost and revenue.
Markup Calculator
Calculate markup percentage from cost and selling price.
What is X% of Y?
Calculate a specific percentage of a number.
Percentage Increase
Calculate the percentage increase between two numbers.
Calculation Methodology
How it works
The calculator takes the Amount and Tax Rate, validates them, and computes the tax value using standard percentage arithmetic or reverse taxation formulas depending on the mode.
Precision & Rounding
Calculations utilize IEEE 754 double-precision floating-point arithmetic for exact currency computation.
Assumptions
- Inputs are positive valid numbers.
- The tax rate is entered as a percentage without the % symbol.
Limitations & Edge Cases
- Extremely large amounts may reach standard computational limits.
Glossary of Terms
VAT Exclusive
A price that does not yet include the Value Added Tax.
VAT Inclusive
A final price where the Value Added Tax is already incorporated into the total.
Input Tax
The VAT added to the price you pay for goods or services for your business.
Output Tax
The VAT you calculate and charge on your own sales of goods and services.
References & Sources
- Value Added Tax (VAT) Concept & Status- International Monetary Fund (IMF) (2025)