VAT calculations become much easier when you separate the net price, VAT amount, and gross total. This guide explains how to add VAT to a net price, remove VAT from a VAT-inclusive amount, check an invoice, and build a repeatable worksheet for products and services. Use the formulas with your applicable VAT rate, then verify the result against the rules for the jurisdiction and transaction involved.
Overview
VAT is usually shown in three related figures:
- Net price: the price before VAT.
- VAT amount: the tax applied to the net price.
- Gross price: the total including VAT.
The basic relationship is:
Gross price = Net price + VAT amount
For a VAT rate expressed as a percentage, the VAT amount is calculated from the net price. For example, with a hypothetical 20% rate, a net price of 100 produces VAT of 20 and a gross total of 120.
Use a VAT, discount, and net price calculator when you want a quick estimate, but keep the formulas below available for checking quotes, supplier invoices, spreadsheets, and accounting entries. The rate itself is not universal: it can vary by jurisdiction, product type, customer status, and transaction. Treat the examples in this article as arithmetic demonstrations rather than a list of current regional rates.
How to estimate
Adding VAT to a net price
To calculate VAT from a net amount:
VAT amount = Net price × VAT rate
Convert the percentage to a decimal before multiplying. A rate of 20% becomes 0.20. Then calculate the invoice total:
Gross price = Net price × (1 + VAT rate)
Example: if the net price is 250 and the applicable rate is 20%:
- VAT: 250 × 0.20 = 50
- Gross price: 250 + 50 = 300
Removing VAT from a gross price
When an amount already includes VAT, do not subtract the percentage directly. Instead, divide the gross amount by one plus the VAT rate:
Net price = Gross price ÷ (1 + VAT rate)
To find the VAT included in the gross amount:
VAT amount = Gross price − Net price
Example: a VAT-inclusive total of 300 at a hypothetical 20% rate gives:
- Net price: 300 ÷ 1.20 = 250
- VAT included: 300 − 250 = 50
This is the correct way to calculate VAT from a gross price or remove VAT from a price. Subtracting 20% from 300 would produce 240, which is not the original net amount because the 20% was applied to the net figure, not the gross figure.
Reference table for common illustrative rates
The table below uses a gross amount of 120 to show the method. The rates are examples only; replace them with the rate relevant to your transaction.
| Illustrative rate | Gross amount | Net calculation | Approximate net | VAT included |
|---|---|---|---|---|
| 5% | 120.00 | 120 ÷ 1.05 | 114.29 | 5.71 |
| 10% | 120.00 | 120 ÷ 1.10 | 109.09 | 10.91 |
| 20% | 120.00 | 120 ÷ 1.20 | 100.00 | 20.00 |
| 21% | 120.00 | 120 ÷ 1.21 | 99.17 | 20.83 |
Round the displayed currency values according to your accounting process and local requirements. Keep sufficient precision in the underlying calculation where your software allows it.
Inputs and assumptions
A reliable VAT calculator online or spreadsheet needs more than a price and a percentage. Record these inputs before calculating:
- Starting amount: confirm whether it is net, gross, or unclear.
- VAT rate: enter the rate that applies to the specific transaction, not merely the rate used on your last invoice.
- Currency: use the currency shown on the quote or invoice.
- Quantity: calculate the line total before applying the relevant tax treatment, unless your accounting system handles line-level rounding.
- Discounts: establish whether the discount is applied before VAT. In many invoice workflows, VAT is calculated on the discounted taxable amount, but the applicable treatment should be confirmed for the transaction.
- Rounding method: decide whether rounding occurs per line or on the invoice subtotal, and use the same method consistently.
For an invoice-checking worksheet, create columns for item description, quantity, unit net price, discount, taxable net amount, VAT rate, VAT amount, and gross line total. Add a final row for net subtotal, total VAT, and invoice total. This makes it easier to identify whether an error comes from the unit price, quantity, rate, discount, or rounding.
Also check whether the seller is required to charge VAT and whether the transaction has special treatment. Registration status, cross-border sales, exempt items, reverse-charge arrangements, and reduced or zero rates can change the result. A calculator can verify arithmetic; it cannot determine the legal treatment of a transaction. When the situation is uncertain, confirm it with the relevant tax authority or a qualified adviser.
Worked examples
Example 1: Pricing a service from a net quote
A freelancer quotes a service at a net price of 800. Using an illustrative VAT rate of 20%:
- Net price: 800
- VAT: 800 × 0.20 = 160
- Gross invoice total: 800 + 160 = 960
The quote should state clearly whether 800 is before VAT. This prevents a customer from interpreting the figure as the final amount due.
Example 2: Checking a supplier invoice
A supplier invoice shows a gross total of 1,210 and a stated VAT rate of 21%. To test the figures:
- Net amount: 1,210 ÷ 1.21 = 1,000
- VAT amount: 1,210 − 1,000 = 210
If the invoice instead lists a net amount of 1,000 and VAT of 210, the totals agree before considering any line-level rounding or additional charges.
Example 3: Applying a discount before VAT
A product has a net list price of 500 and receives a 10% discount. The discounted net amount is 450. At an illustrative 20% VAT rate, VAT is 90 and the gross total is 540. The important control is to show the list price, discount, taxable net amount, VAT rate, and final total separately.
For broader pricing decisions, compare the tax calculation with your margin calculation. The profit margin versus markup guide can help keep VAT separate from revenue and profitability measures.
When to recalculate
Revisit your VAT calculation whenever an input changes, rather than relying on an old invoice or spreadsheet cell. Recalculate when:
- the applicable VAT rate or tax treatment changes;
- you sell a new product or service category;
- you begin selling to customers in another jurisdiction;
- your registration status or customer status changes;
- you change prices, discounts, quantities, or billing currency;
- an accounting system changes its rounding or line-item settings;
- you review supplier bills or prepare a VAT return.
As a practical routine, review saved rates and invoice templates at least twice a year, and sooner when an official tax update affects your transactions. Keep the date of the last review beside each rate in your worksheet. Before sending an invoice, perform a final four-step check: confirm whether the amount is net or gross, verify the rate, recompute the VAT independently, and compare the net plus VAT with the stated total. That small process turns a one-off VAT calculator estimate into a repeatable invoice control.