VAT calculator: add it, remove it, or find it
Try:
Start typing or click an example
All lines
Start typing or click an example
Set the rate once, vat: 20%, then calculate in plain words: 100 000 + vat adds the tax, 120 000 without vat removes it, and 20% included in 120 000 shows the tax itself.
100 000 + vat gives the gross price.20% included in 120 000.120 000 without vat gives the net price.The rate is an ordinary named line. Write vat: 19% and the whole sheet is recalculated. You can keep several rates under different names.
Rates differ by country and change over time: for example 20% in the United Kingdom, 19% in Germany, 5% in the United Arab Emirates and 16% in Kazakhstan from 2026. Check the current rate for your country and product, and type it into the vat: line.
| You type | You get |
|---|---|
| 120 000 | |
| 100 000 | |
| 20 000 | |
| 20 000 | |
| 112 000 | |
| 100 000 |
Write 20% included in 120 000 and the calculator shows 20 000, the tax itself. For the price without tax, write 120 000 without vat.
List the items line by line, Paper: 25 * 2.45, Toner: 4 * 18.90, then sum = subtotal and sum + vat. The Invoice template in the Templates menu is already laid out this way.
The rate that applies in your country for that product. The rate is just a line on the sheet, so change it and everything updates.