How to work out VAT: add VAT, remove VAT and worked examples
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
- To add VAT: multiply the net price by 1 + the rate. At 20% that is × 1.2.
- To remove VAT: divide the gross price by 1 + the rate. At 20% that is ÷ 1.2.
- To find just the VAT inside a gross price at 20%: divide by 6. At 5%: divide by 21.
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.