How to calculate a price excluding taxes from a price including all taxes?
Verified 09 June 2023 - Directorate for Legal and Administrative Information (Prime Minister)
In order to obtain a price excluding taxes (VAT) from a price including all taxes (VAT), the following calculation formula shall be applied:
Price excluding VAT = Price inclusive ÷ (1 + VAT rate)
To express the HT price with 2 digits after the decimal point, it must be rounded up to the next cent if the 3e The digit after the comma is equal to or greater than 5. And round it down to the nearest cent if the 3e The digit after the comma is less than 5. For example, the ex-VAT price of €41.669 is rounded to €41.67.
We offer you a simulator to calculate a price including VAT from a price excluding VAT:
Price calculator excluding tax (excluding tax) or all taxes included (including tax)
VAT rate | Calculation for a price including VAT of €50 | Price excluding VAT |
|---|---|---|
20% | 50 ÷ (1 + 20%) | €41.67 |
10% | 50 ÷ (1 + 10%) | €45.45 |
8.5% | 50 ÷ (1 + 8.5%) | €46.08 |
5.5% | 50 ÷ (1 + 5.5%) | €47.39 |
2.10% | 50 ÷ (1 + 2.10%) | €48.97 |