VAT isn't revenue
When a customer pays a price that includes VAT, part of that money was never yours. You collect it and pass it on. Leave it in, and your margin looks several points better than it really is, which is how prices end up set too low.
price before VAT = price with VAT ÷ (1 + VAT rate)
margin = (price before VAT − cost) ÷ price before VAT × 100
Example
A shop in Poland sells a lamp for 123 zł including 23% VAT. The lamp cost 60 zł before VAT, which the shop reclaims.
The price before VAT is 123 ÷ 1.23 = 100 zł. VAT is 23 zł. Profit is 100 − 60 = 40 zł, so the real margin is 40%. Counting the whole 123 zł as revenue would suggest a 51% margin, eleven points that don't exist.
Common standard rates
| Country | Standard VAT | Divide shelf price by |
|---|---|---|
| Germany | 19% | 1.19 |
| United Kingdom | 20% | 1.20 |
| France | 20% | 1.20 |
| Spain | 21% | 1.21 |
| Netherlands | 21% | 1.21 |
| Italy | 22% | 1.22 |
| Poland | 23% | 1.23 |
Rates change from time to time and reduced rates apply to some products, so confirm the rate for what you sell.
Prices without VAT
If you sell to businesses and quote prices before VAT, switch the second box to "excludes VAT". The margin works the same way; the calculator just adds VAT on top to show what the customer pays.