How to Calculate VAT

VAT questions arrive in two costumes that look similar and are not. A freelancer types “add 23% to €100” and wants the invoice total. A shopper looks at a €123 shelf price and wants to know how much of it is tax. Using the first method on the second problem is the classic VAT mistake, and it quietly overstates the tax.

This guide covers the arithmetic. It is not tax advice, and it is not a filing tool. Rates, place-of-supply rules, and exemptions belong to the official guidance in the country where the supply is taxed. When you only need the arithmetic, the VAT calculator adds tax or extracts it and shows net, VAT, and gross together.

Net, VAT, and gross

Three words are enough, if you keep them glued to the right number.

• Net (exclusive, ex-VAT) is the price before tax.
• VAT is the tax amount itself.
• Gross (inclusive, inc-VAT) is what the buyer pays: net plus VAT.

They always satisfy one check: net + VAT = gross. If your three numbers fail that, round-off aside, the method was wrong.

Countries publish more than one rate. Portugal’s mainland headlines are often 23% standard, 13% intermediate, and 6% reduced, with different rates in the Azores and Madeira. Spain, France, Germany, and the UK each have their own standard and reduced bands. A preset button is a shortcut to a rate you still have to match to the goods or service. The math does not know whether a pastry and a laptop share a rate.

Adding VAT to a net price

When the price in front of you does not yet include tax:

VAT = net × (rate / 100)

Gross = net × (1 + rate / 100)

Or, equivalently, gross = net + VAT.

€100 net at 23%. VAT = 100 × 0.23 = €23. Gross = €123. You can also do 100 × 1.23 = 123 in one step.

€80 net at 20% (a common UK-style standard rate in examples). VAT = €16. Gross = €96.

€49.99 net at 6%. VAT = 49.99 × 0.06 = €3.00 to the nearest cent if you round half-up on the third decimal in the usual commercial way (2.9994 rounds to 3.00). Gross ≈ €52.99. Cent rounding is where two “correct” invoices differ by one cent; agree a rounding rule and use it on every line.

A restaurant bill that says “prices exclude VAT” needs the add method. A restaurant bill that already says “VAT included” needs the extract method below. The words on the menu decide the formula, not the size of the percent.

Extracting VAT from a gross price

When the price already includes tax, you are not multiplying the gross by the rate. You are splitting a number that already contains the tax.

Net = gross / (1 + rate / 100)

VAT = gross − net

The VAT fraction of the gross price is rate / (100 + rate). At 23%, that is 23/123 ≈ 0.18699, or about 18.70% of the gross amount — not 23%.

€123 gross at 23%. Net = 123 / 1.23 = €100. VAT = €23. The check holds.

€123 gross, incorrectly multiplied by 23%. 123 × 0.23 = €28.29, and 123 − 28.29 = €94.71. That pair does not rebuild a 23% add-on (94.71 × 1.23 ≈ 116.49, not 123). The error is about €5 too much tax. On a €10,000 invoice the same mistake is hundreds.

The wrong column is always larger. Inclusive-price tax is a slice of a bigger pie, so the slice’s percentage of the pie is smaller than the nominal rate.

Worked shop-floor examples

A Portuguese mainland invoice, standard rate. You quote a service at €1,500 before tax. Gross = 1,500 × 1.23 = €1,845. VAT = €345. If the client is a business that can recover VAT, the €345 may be a cash-flow item rather than a cost. If the client is a private person, €1,845 is the price that matters. The calculator does not know which client you have. You do.

A reduced-rate grocery line. €12.00 including 6% VAT. Net = 12 / 1.06 ≈ €11.32. VAT ≈ €0.68. Taking 6% of €12 (€0.72) overstates the tax by about four cents. Harmless on one yogurt, sloppy on a month of stock.

A discount, then VAT. A €200 net fee with 10% off, then 23% VAT. Discount first: 200 × 0.90 = €180 net. Then VAT: 180 × 0.23 = €41.40. Gross = €221.40. Doing VAT first and the discount second (200 × 1.23 = 246, then 10% off = €221.40) happens to match if the discount is a percent of the whole gross. A fixed €20 discount does not commute the same way. Decide whether the discount applies to the net or the gross, write it down, and only then calculate. Stacked percent discounts have their own traps, covered in how discounts work and stacked discounts.

Several lines, one rate, and the rounding cent

Invoices are rarely one number. Suppose three net lines at 23%: €10.10, €10.10, and €10.10.

• VAT per line at 2 decimals: 10.10 × 0.23 = 2.323 → €2.32. Three lines: €6.96.
• VAT on the sum: 30.30 × 0.23 = 6.969 → €6.97.

One cent appears or disappears depending on whether you round per line or on the total. Tax authorities and accounting software pick a rule. A teaching calculator that rounds the final VAT to the cent is fine for a single price and the wrong tool for reproducing a 40-line invoice to the cent. If you are checking a bill, compare the net, the rate, and the gross, and allow a cent of rounding before you assume the shop made a conceptual mistake.

What a percentage calculator will not decide

Cross-border sales, the reverse-charge mechanism, exemptions for medical or financial services, margin schemes for second-hand goods, and distance-selling thresholds are legal classifications. Typing a rate into a box does not establish that the rate applies.

Two situations where people still want the arithmetic after the classification is done:

• Checking a receipt that already shows a rate, to see whether the included tax matches.
• Building a quote from a net day-rate you actually control.

If you do not know the rate, stop. A wrong rate with perfect arithmetic is still a wrong invoice. Official finance-ministry or tax-agency pages are the source for the rate list; a preset in a calculator is only a memory aid.

Sales tax versus VAT compares the US-style add-on habit with VAT-inclusive shelf prices. The algebra of “add a percent” is shared. The question “which number is the customer looking at?” is not.

Mistakes worth naming

Multiplying a gross price by the rate and calling the result VAT. Use the extract formula instead.

Adding the rate twice. Some people compute VAT and then also multiply the net by (1 + rate), and add those together. That charges the tax twice. Pick one path.

Using “percent of” on the wrong base. What is 23% of 123 is a legitimate question with answer €28.29. It is just not “how much VAT is inside 123.”

Forgetting that discounts change the base. Percent-off and VAT compose by multiplication of factors, not by adding the percentages into one blob.

Treating island and mainland rates as interchangeable because a button said “Portugal.”

When to use the VAT calculator

Use it when you already know the rate and you know whether your starting number is net or gross. Add mode for quotes and ex-VAT price lists. Extract mode for shelf prices, receipts, and “how much was the tax?” questions.

Use it to show a client both numbers, because arguments about VAT are often arguments about which number someone thought was the price.

Do not use it to choose a rate, to decide if a sale is exempt, or to prepare a return. When the result will be printed on an invoice, let accounting software that implements your rounding rule have the last word, and use the calculator as the independent check of the method.