VAT Calculator
Add VAT to a net price or remove VAT from a gross price, with a clear tax breakdown and a validated Excel export.
Inputs
Use a period as the decimal separator.
Choose whether the entered amount excludes or includes VAT.
Required. Enter 0 to 1,000,000,000 with up to 2 decimals.
Required. Enter a rate from 0% to 100%.
Results
Calculated live from the current inputs.
Net amount plus VAT.
gross = net × (1 + rate)
Calculation breakdown
| Component | Amount | Share of gross |
|---|---|---|
| Net price | €200.00 | 83.33% |
| VAT | €40.00 | 16.67% |
| Gross price | €240.00 | 100.00% |
How to use this VAT calculator
What this calculator does
This calculator converts between a VAT-exclusive net price and a VAT-inclusive gross price. In Add VAT to net amount mode, it calculates the tax amount and gross price from a net amount. In Remove VAT from gross amount mode, it separates a gross amount into its net price and embedded VAT. It is useful for quotation checks, invoice review, price-list preparation, expense reconciliation, and quick scenario planning. It does not determine whether a transaction is taxable, exempt, zero-rated, subject to a reduced rate, or governed by a special scheme; those questions depend on the applicable jurisdiction and transaction facts. The European Commission's overview of VAT rules for businesses explains why rates and treatment can vary.
When to use it
- Convert a supplier's net quote into the expected VAT-inclusive amount.
- Check how much VAT is included in a receipt or advertised gross price.
- Compare prices under different possible VAT rates before issuing a quote.
- Export a clean calculation record for internal review or bookkeeping support.
How to calculate
- The calculator opens with a ready-to-use demonstration: a €200.00 net amount and a 20.00% VAT rate. Its validated example Excel workbook is available immediately.
- Choose Calculation mode. Select “Add VAT to net amount” when the amount excludes tax, or “Remove VAT from gross amount” when the amount already includes tax.
- Replace Amount with the monetary value to test. Enter digits with an optional period and up to two decimal places; do not use a decimal comma or scientific notation.
- Replace VAT rate with the applicable percentage. The calculator updates the primary result, summary cards, pills, formula, and breakdown table live.
- Select Download Excel to create a current-state .xlsx workbook containing the inputs, outputs, formulas, and checks. Select Reset to clear the demonstration and all calculated content. Reset may disable Excel until a complete valid amount and rate are entered again.
Input guide
Calculation mode is required and accepts one of two choices. “Add VAT to net amount” treats Amount as VAT-exclusive; raising the VAT rate increases both Tax amount and Gross price. “Remove VAT from gross amount” treats Amount as VAT-inclusive; raising the rate increases the tax portion while reducing the net portion for the same gross total. A common mistake is using remove mode for a net quote.
Amount is required, uses euros in this implementation, and accepts values from 0 to 1,000,000,000 with up to two decimal places. A realistic example is 200.00. A zero amount is mathematically valid and produces zero values, while a larger amount changes net, tax, and gross amounts proportionally. Avoid currency symbols inside the field, decimal commas such as 1,5, and grouped values such as 1,000 because this calculator deliberately uses a strict unambiguous format.
VAT rate is required and accepts 0 through 100 with up to four decimal places; 20.00 means 20%, not 0.20%. A 0% rate makes tax zero and leaves net equal to gross. The correct rate depends on the product, service, place of supply, and date. For a concrete jurisdictional example, the UK government publishes its current VAT rates and categories.
Output guide
Gross price is the VAT-inclusive total. Net price is the amount before VAT. Tax amount is the difference between gross and net. The Rate pill repeats the current VAT percentage, and Tax share shows VAT as a percentage of the gross price, which differs from the VAT rate because the VAT rate is normally applied to the net base. In the breakdown table, Component identifies net, VAT, and gross; Amount shows each monetary value; and Share of gross expresses each component relative to the gross total. These are exact arithmetic identities for the supplied values, not a tax-law determination.
Worked example
With the startup values, mode is Add VAT, Amount is €200.00, and VAT rate is 20.00%. Convert the rate to 0.20 and calculate VAT: €200.00 × 0.20 = €40.00. Add that tax to the net amount: €200.00 + €40.00 = €240.00 gross. The net share of gross is 200 ÷ 240 = 83.33%, while the tax share is 40 ÷ 240 = 16.67%. The same figures appear in the first-open results, breakdown table, live summary, and workbook checkpoints.
How the formulas work
Adding VAT uses tax = net × rate and gross = net × (1 + rate). Removing VAT must not simply subtract the rate from the gross price. Instead, it reverses the multiplication: net = gross ÷ (1 + rate), then tax = gross – net. For example, removing 20% VAT from €240 gives €200 net, not €192. The OECD describes VAT as a tax on final consumption that is collected through stages of production and distribution; see its consumption taxes overview.
Common mistakes and interpretation
The most common error is treating a gross amount as if it were net. Another is confusing a VAT rate with VAT's share of the gross total. At a 20% VAT rate, tax is 20% of the net base but 16.67% of the gross total. Rounding can also create small invoice-line differences when tax is calculated per item rather than on an aggregate. This calculator preserves full internal precision and displays monetary values to two decimals. Businesses operating across borders should also review place-of-supply and customer-status rules; the EU's guidance on cross-border VAT provides an authoritative starting point.