Business Tax

VAT calculator

Net amount (excluding VAT)
VAT rate
%
Direction
Gross (including VAT) 120
100 × (1 + 20%)
VAT 20
Net 100
Rate applied 20 %
Divide to remove · multiply to add
CountryStandardReducedVAT fraction
Netherlands21%9%21/121
Belgium21%6% / 12%21/121
Germany19%7%19/119
France20%5.5% / 10%1/6
United Kingdom20%5%1/6
Ireland23%9% / 13.5%23/123
Spain21%10%21/121
Italy22%5% / 10%22/122

Rates change and reduced rates depend on what is being sold. Check the current rate with the tax authority for the country in question.

To add VAT, multiply the net by one plus the rate: 100 at 20% becomes 120. To remove it, divide the gross by the same figure, so 240 ÷ 1.2 gives 200 net and 40 VAT. Subtracting 20% from the gross gives 192 and is wrong by eight. The rate is a field: 21% for the Netherlands, 23% for Ireland, 19% for Germany.

How to calculate VAT

1 Pick the job: adding VAT, removing it, reading the tax out of a total, setting a display price, or finding the net behind one.
2 Enter the amount and the rate that applies to what is being sold.
3 Read the net, the VAT and the gross together.
4 Use the VAT fraction if you want to do it in your head next time: 1/6 at 20%, 21/121 at 21%.

The reason subtraction fails in the gross-to-net direction is that the percentage was applied to the smaller number. Twenty per cent of 200 is 40, but 20% of 240 is 48, so subtracting removes tax on the tax. The VAT fraction sidesteps the arithmetic entirely: multiply the gross by the fraction and you have the tax directly, and at the UK 20% rate it simplifies to a memorable 1/6, which is why British bookkeepers divide receipts by six in their heads. At 21% it is 21/121 and at 19% 19/119, neither of which anybody does in their head. Which rate to apply depends on what is being sold and where the customer is, not on where you are: digital services to consumers in another EU country carry that country rate, which is what the One Stop Shop scheme exists to administer, while cross-border business-to-business sales are usually reverse-charged so no VAT is added at all. On the pricing side, consumer law across the EU and UK requires the inclusive figure to be the prominent one, and rounding to a nice inclusive price quietly moves the net: at 20%, choosing 59.95 rather than 59.90 lifts the net from 49.92 to 49.96, trivial per unit but enough to put a price list and an accounting figure out of step. The discipline that matters most is using ex-VAT figures on both sides of any margin calculation — comparing a VAT-inclusive selling price against an ex-VAT cost inflates the apparent margin by the whole rate.

What people use it for

  • Producing an invoice with the right VAT line
  • Checking a supplier invoice adds up
  • Working out the VAT contained in an expense receipt
  • Extracting VAT from a till receipt
  • Setting retail prices for a consumer shop
  • Preparing a price list for a webshop
  • Converting a shelf price to an ex-VAT cost
  • Working out true revenue from till takings
  • Preparing a VAT return
  • Comparing a consumer price with a trade quote
  • Recording an expense claim with the VAT split out
  • Turning a trade price list into retail tickets
  • Checking a gross quote against a budget that was set net
  • Putting a competitor price on a like-for-like basis

Questions

Multiply the net by one plus the rate. At 20%, multiply by 1.2, so 100 becomes 120; at 21%, multiply by 1.21.

European Commission: VAT rates applied in the EU
Was this tool any good?
Internal signal only · I use it to find the tools worth rebuilding