← All guides

How to work out VAT: add VAT, remove VAT and worked examples

· 4 min read

Working out VAT goes in two directions: adding VAT to a net price, and taking VAT out of a price that already includes it. The two use different formulas, and mixing them up is the most common VAT mistake. Below are both formulas, quick shortcuts for the usual rates, spreadsheet formulas and examples you can check by hand.

The easy way to work out VAT

How to add VAT to a price

Multiply the net amount by the VAT rate to get the VAT. The gross price is the net amount plus the VAT, or simply the net amount × (1 + rate).

VAT amount = net × rate / 100
Gross      = net + VAT amount   (or net × 1.2 at 20%)

Example: 150 net, 20% VAT
VAT amount = 150 × 20 / 100 = 30
Gross      = 150 + 30 = 180

How to remove VAT from a price (reverse VAT)

The common mistake is to take 20% of the gross price and subtract it. That is wrong, because the gross price was built as net × 1.2, so 20% of the gross is more than the VAT. The correct way is to divide by 1 + rate.

Net        = gross / (1 + rate / 100)
VAT amount = gross − net

Example: 240 including 20% VAT
Net        = 240 / 1.20 = 200
VAT amount = 240 − 200 = 40

Wrong way: 240 × 20 / 100 = 48, net 192 (incorrect)

VAT fractions: the shortcut for the VAT inside a price

When a price already includes VAT, the VAT part is a fixed fraction of it. The fraction is rate / (100 + rate).

Rate   VAT fraction   VAT in a gross price
20%    20/120 = 1/6    gross ÷ 6
5%     5/105  = 1/21   gross ÷ 21
10%    10/110 = 1/11   gross ÷ 11

Example: 105 including 5% VAT → VAT = 105 ÷ 21 = 5, net = 100

Quick multipliers for common rates

Rate   Add VAT (net → gross)   Remove VAT (gross → net)
20%    × 1.20                 ÷ 1.20
15%    × 1.15                 ÷ 1.15
10%    × 1.10                 ÷ 1.10
5%     × 1.05                 ÷ 1.05

VAT formulas in Excel and Google Sheets

With the net or gross amount in cell A2 and a 20% rate:

VAT on a net amount        =A2*20%
Gross from net             =A2*1.2
Net from gross             =A2/1.2
VAT inside a gross amount  =A2-A2/1.2
Rounded to the penny       =ROUND(A2/1.2, 2)

Output VAT and input VAT

For a VAT-registered business, output VAT is the VAT you charge on your sales, and input VAT is the VAT you pay on business purchases. What you pay to the tax authority for a period is output VAT minus input VAT. If input VAT is larger, you can usually reclaim the difference.

Sales:     10,000 net × 20% = 2,000 output VAT
Purchases:  4,000 net × 20% =   800 input VAT
VAT to pay: 2,000 − 800      = 1,200

Which rate should I use?

VAT rates differ by country and by product or service, and they can change. In the UK, for example, the standard rate is 20%, with a reduced rate of 5% and a zero rate for some goods. If you are not sure which applies, check the current rate with your tax authority or an accountant.

How is rounding done?

Amounts are rounded to the cent, two decimal places. Rounding the VAT of every invoice line separately can differ by a cent from calculating the VAT of the total at once. That is a result of the rounding method, not an error.

For a quick calculation

To type an amount and a rate and see the result instantly, use the VAT calculator. It has add VAT and remove VAT options and shows the net, VAT and gross amounts together. Your numbers never leave your browser.

This article is general information, not tax advice. For official matters consult an accountant.

More guides