VAT formula: net

Short intro: VAT formulas are few: add VAT, remove VAT, calculate the tax amount. The trick is using the right direction, a heroic challenge for spreadsheets everywhere.

Formula

• VAT = Net amount × Rate / 100
• Gross = Net amount × (1 + Rate / 100)
• Net = Gross / (1 + Rate / 100)
• Removed VAT = Gross - Net

From net amount to VAT-inclusive total

Starting from net, multiply by the VAT factor. At 22%, the factor is 1.22. At 10%, the factor is 1.10.

From VAT-inclusive total to net amount

Starting from gross, divide by the VAT factor. This is reverse VAT calculation: you do not subtract the percentage from gross.

Rounding rules in practice

Round to cents and keep line totals consistent with invoice totals. Many-line invoices can differ by a few cents depending on whether VAT is calculated per line or on the total.

Practical numerical examples

• €200.00 net at 22% → VAT €44.00 → gross €244.00.
• €244.00 gross at 22% → net €200.00 → VAT €44.00.
• €80.00 net at 10% → VAT €8.00 → gross €88.00.

FAQ

What is the most common VAT formula?

To add VAT: net × VAT factor. For 22%, net × 1.22.

How do I calculate the rate from net and gross?

Rate = (gross / net - 1) × 100.

Is VAT calculation different from IVA?

The math is the same. Language, country, rates and practical cases change.

Recommended internal links

• Reverse VAT calculator
• VAT 22% calculator
• VAT invoice calculation
• Italy VAT rates
• UK VAT calculator

Careful tax disclaimer

VAT rates and treatments can change, and exceptions may apply. Before using a calculation on an invoice or return, check the current rate, country and transaction type from updated sources.