How to calculate a price excluding taxes from a price including all taxes?

Verified 09 June 2023 - Legal and Administrative Information Directorate (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)

Tableau - Example of how to calculate the HT price using the following calculation formula

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.50%

50 ÷ (1 + 5.50%)

€47.39

2.10%

50 ÷ (1 + 2.10%)

€48.97