VAT CALCULATOR

Add or remove VAT in a few keystrokes with our handy online VAT calculator. Just type the price inclusive or exclusive of VAT and click the button.
Remove VATAdd VAT
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
This is some text inside of a div block.
Back to calculation
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

How to work out VAT

Only 3 easy steps to calculate VAT online
step 1

Check the "VAT rate" (it’s pre-set to the UK standard rate of 20%)

step 2

Enter the amount – net or gross price. Check full VAT rates list below

step 3

Click "Remove VAT" or "Add VAT" depending on what you want

What is VAT and how much is it?

VAT (value added tax) is charged on most goods and services provided by VAT-registered businesses in the UK. It’s collected on behalf of HMRC by businesses that are VAT registered. These same business can also claim VAT back on relevant purchases. See a more detailed description of VAT on Wikipedia.

standard rate

The standard rate of VAT in the UK is currently 20 per cent and this is the rate charged on most purchases.

reduced rate

Reduced rate is applied to some health, energy, heating, and protective products and services.

zero rate

Zero rate is applied to a range of products and services to do with health,  publishing and kids’ clothing.

VAT rates in other countries

Here you will find a list of European countries and their VAT rates

Country

Standard rate

Reduce rate

United Kingdom

United Kingdom

20 %

5%

Germany

Germany

19%

7%

France

France

20%

10%, 5.5%, 2.1%

Italy

Italy

22%

10%, 5%, 4%

Spain

Spain

21%

10%, 4%

Ireland

Ireland

23%

13.5%, 9%, 4.8%

How to calculate VAT in math or Excel

Following these simple steps can help you to calculate VAT backwards or forwards.
add vat calculation

Adding VAT formula

If you want to add VAT to the price, you just need to divide the price by 100 and then multiply by (100 + VAT rate). That's all, you got the price including VAT - Gross price.

revers vat calculation

Removing VAT formula

If you want to subtract VAT from the price, you need to divide the price by (100 + VAT rate) and then multiply by 100.  Now you know the price excluding VAT - Net price.

how to calculate VAT in excel
excel

VAT calculation in Excel

If you need to calculate VAT for several products at once, it is easier to use Excel. I created a template – download it, it's free.

Download template
Antony Kidless
Antony Kidless
facebooktwitter