Adding and Removing VAT: A Plain Guide for Online Calculators
VAT looks simple until it costs you money. A price of €100 plus 20% VAT is €120, but a €120 invoice does not contain €20 VAT if you are removing the tax later. The difference is only a few euros on a small bill, yet on a materials purchase, a quarterly return or a quoted project it multiplies fast.
This guide explains the actual formulas, shows the common subtract-the-percentage error, and walks through margin and markup on the same transaction. Use it alongside the browser-based online calculators on Sitea.biz, or check the sums with a pencil. Either way, the numbers stay on your device: none of the tools here uploads data or asks for a login. Remember, a calculator is not a tax adviser; if your return is complex, speak to an accountant or your local tax authority.
Net, Gross and the VAT Rate#
In VAT language, net means the amount before tax, gross means the amount after tax, and the VAT itself is simply the gap between the two. The rate is usually quoted as a percentage, but the formula needs it as a decimal. Twenty per cent becomes 0.20, thirteen point five per cent becomes 0.135, and twenty-three per cent becomes 0.23. Once you have the decimal, the relationship is: Gross = Net × (1 + rate) and Net = Gross ÷ (1 + rate). These two equations are the only ones you need for ordinary invoices.
An online calculator does this conversion for you, but knowing the decimal form is what catches keyboard slips.
Adding VAT: Multiply by 1 + Rate#
To add VAT, take the net amount and multiply by one plus the decimal rate. For example, with a 20% rate and a net price of €250, the gross is €250 × 1.20 = €300. The VAT portion is €300 − €250 = €50. If the rate were 23%, the multiplier would be 1.23, giving a gross of €307.50 and VAT of €57.50. The formula is the same whether you are quoting a customer, checking a supplier invoice, or adding tax to a shopping basket.
- Write down the net amount.
- Convert the VAT rate to a decimal and add 1.
- Multiply the net amount by that figure.
- Subtract the net amount from the gross to find the VAT.
Always check which rate applies to the specific goods or services; reduced rates are common for food, hospitality and construction.
Removing VAT: Divide by 1 + Rate, Never Subtract#
This is where most mistakes happen. If an invoice shows a gross total of €120 and the VAT rate is 20%, the VAT is not €120 × 0.20 = €24. That would leave a net figure of €96, which is wrong. The correct calculation is €120 ÷ 1.20 = €100 net, so the VAT is €20. The error is only €4 on a €120 invoice, but on a €12,000 vehicle it becomes €400, and on a €120,000 project it becomes €4,000. The rule is simple: the gross amount is 120% of the net, so you divide by 120%, not subtract 20%.
| Method | Net shown | VAT shown | Error on €120 gross |
|---|---|---|---|
| Correct: divide by 1.20 | €100.00 | €20.00 | none |
| Wrong: subtract 20% | €96.00 | €24.00 | €4.00 too much VAT |
The €4 difference is the four-unit error: subtracting the percentage from the gross treats the tax as a share of the gross, but it is a share of the net.
A Quick Reference Table for Common VAT Rates#
The table below fixes the numbers for a €100 net amount at the rates you are most likely to see in the euro area. Use it to sanity-check your own sums before entering them into an online calculator or a spreadsheet. If your invoice is larger, scale the VAT and gross columns proportionally: a €1,000 net sale at 20% is simply ten times the €100 figure.
| VAT rate | Net | Gross | VAT included |
|---|---|---|---|
| 0% | €100.00 | €100.00 | €0.00 |
| 9% | €100.00 | €109.00 | €9.00 |
| 13.5% | €100.00 | €113.50 | €13.50 |
| 20% | €100.00 | €120.00 | €20.00 |
| 23% | €100.00 | €123.00 | €23.00 |
Margin and Markup on the Same Transaction#
Margin and markup both compare profit to a price, but they use different denominators, so the same deal gives two different percentages. Suppose you buy materials for €80 and sell them for €100 net, then charge 23% VAT to make the gross €123. Markup is profit divided by cost: (€100 − €80) ÷ €80 = 25%. Margin is profit divided by selling price: (€100 − €80) ÷ €100 = 20%. If you aim for a 25% margin but price using a 25% markup, your selling price is €106.67 net and your profit is €26.67, not the €25 you planned. Many small businesses discover this only when the bank balance is lower than expected.
| Measure | Formula | Result on €80 cost, €100 net sale |
|---|---|---|
| Markup | (Price − Cost) ÷ Cost | 25% |
| Margin | (Price − Cost) ÷ Price | 20% |
| VAT at 23% | Net × 0.23 | €23.00 |
| Gross charged | Net × 1.23 | €123.00 |
VAT is usually calculated on the net selling price, not on your profit, so do not mix margin calculations with the tax calculation.
What an Online Calculator Can and Cannot Do#
A browser-based calculator is useful for quick checks, quote drafting and training your eye to spot errors. It is not a substitute for a tax professional when rules change, when you are deciding whether to register for VAT, or when you are preparing a statutory return. The calculators on Sitea.biz run entirely in your browser and require no login, but the site is an independent directory of online calculators, not a tax adviser, broker or government body.
- Use a calculator to check an invoice or estimate a quote.
- Use an accountant for VAT registration, repayments and audits.
- Use your tax authority's guidance for rates on specific goods.
- Use a bookkeeper if your records span multiple currencies or jurisdictions.
- Do not rely on a single unexplained number when thousands of euros are at stake.
Nothing here is financial, tax or legal advice; if your affairs are complex, speak to a qualified accountant or tax adviser. Expect to pay €150–€350 per hour for specialist advice, or €500–€2,000 for a full quarterly return, depending on turnover and complexity.
Putting It All Together: A Real Invoice Check#
Imagine you receive an invoice for €1,230 including 23% VAT. To find the net, divide by 1.23: €1,230 ÷ 1.23 = €1,000. The VAT is €230. If you had subtracted 23% of €1,230, you would have claimed €282.90 as VAT and recorded a net cost of €947.10. That €52.90 error would throw off both your expense figure and any VAT reclaim. Always divide by 1 plus the rate; the extra seconds save hours of correction later.
Frequently asked questions
Why do I divide by 1.20 instead of subtracting 20%?
Because VAT is calculated on the net amount, not on the gross. A gross total of €120 at 20% VAT means the net is €100 and the tax is €20. The €120 is 120% of the net, so dividing by 1.20 returns you to 100%. If you subtract 20% of €120, you are treating the tax as 20% of the gross, which gives €96 net and €24 VAT. That €4 error on a small invoice scales to €400 on €12,000 or €4,000 on €120,000. The same logic applies to any rate: divide by 1 plus the rate as a decimal.
What is the difference between margin and markup?
Markup compares profit to cost; margin compares profit to the selling price. If you buy stock for €80 and sell it for €100 net, your profit is €20. Markup is €20 ÷ €80 = 25%. Margin is €20 ÷ €100 = 20%. A business that targets a 25% margin but prices using a 25% markup will undercharge. To hit a 25% margin on an €80 cost, the net selling price must be €106.67, not €100. The numbers are close, but on volume the shortfall becomes real. Always state which measure you are using before you set prices or commissions.
Can I use these calculators for my tax return?
Browser-based online calculators are useful for checking figures and building quotes, but they are not a substitute for a qualified tax adviser or accountant when you file a return. Tax rules change, rates differ between goods and services, and special schemes such as flat-rate VAT or cross-border trading need professional judgement. Sitea.biz is an independent directory of online calculators, not a tax authority, broker or adviser. If your turnover is near the registration threshold, if you are reclaiming VAT, or if your affairs involve more than one country, speak to an accountant. Fees typically range from €150–€350 per hour for advice, or €500–€2,000 for a full quarterly return depending on complexity.
online calculatorshow to add VAThow to remove VATVAT gross to net formulamargin vs markup calculatorreverse VAT calculator
