Calculating VAT seems simple until you run into the reverse situation: you have a final price and need to work out how much of that amount is the taxable base and how much is tax. This guide covers the two most common scenarios, both for freelancers and businesses issuing invoices and for anyone who just wants to understand their receipt.
The two scenarios: adding VAT or breaking it out
There are two different operations that are frequently confused:
- Adding VAT to a taxable base: you have the price before tax and want to know the final price.
- Breaking out the VAT from a tax-inclusive amount: you have the final price (what you'll actually charge or pay) and want to know how much is base and how much is VAT.
How to add VAT to a price
If you're starting from the taxable base, the formula is straightforward:
VAT amount = Taxable base × (VAT rate / 100) Final price = Taxable base + VAT amount
For example, with a base of €100 and the standard rate of 21%: the VAT amount is €21 and the final price is €121.
How to strip VAT out of a tax-inclusive amount
This is the calculation that causes the most confusion, because you can't just apply the percentage directly to the total: if you subtract 21% from €121, you don't get €100. The correct formula is:
Taxable base = Final price ÷ (1 + VAT rate / 100) VAT amount = Final price − Taxable base
Following the example above, €121 ÷ 1.21 = €100 of base, and €21 of VAT. The typical mistake is subtracting a flat 21% instead of dividing by 1.21, which gives an incorrect result.
VAT rates currently in force in Spain
| Rate | Percentage | Examples |
|---|---|---|
| Standard | 21% | Most goods and services |
| Reduced | 10% | Hospitality, passenger transport, some food items |
| Super-reduced | 4% | Basic foodstuffs, medicines, books and newspapers |
The applicable rate depends on the specific product or service, not on who is selling it. It's common for the same business to invoice at different VAT rates depending on what it offers.
Common mistakes when calculating VAT
One of the most frequent errors when preparing a quote is mixing "VAT included" and "VAT excluded" prices in the same comparison. If you're comparing two quotes and one shows the price with VAT included while the other doesn't, the comparison isn't valid until you bring both amounts to the same base.
Another common mistake among freelancers who are just starting to invoice is forgetting that the VAT rate isn't negotiable: it's determined by the nature of the product or service, not by the size of the deal or an agreement between the parties.
Calculate your VAT in seconds
If you need to do this calculation regularly, our VAT calculator lets you both add tax to a base amount and break it out of a final price, with all three current rates already built in.