Multi-Product VAT Calculator

Add multiple products and calculate VAT amounts, totals before VAT, and totals after VAT automatically as you type.

Product Name Amount (£) VAT Rate (%) Mode VAT Amount Price Before VAT Price After VAT Action

Scroll to the right for more columns →

Total Products

0

Total VAT Amount

£0.00

Total After VAT

£0.00
Use “Add VAT” when the amount is before VAT. Use “Remove VAT” when the amount already includes VAT and you want the pre-VAT amount.
Exported CSV includes: product name, amount, VAT rate, mode, VAT amount, price before VAT, and price after VAT.

What is VAT?

VAT stands for Value Added Tax. It is a consumption tax added to goods and services in many countries. Businesses often need to calculate VAT to set prices correctly, issue invoices, and understand how much tax is included in a sale.

How to calculate VAT

There are two common VAT calculations:

Add VAT: Price After VAT = Price Before VAT × (1 + VAT Rate)

Remove VAT: Price Before VAT = Price After VAT ÷ (1 + VAT Rate)

Once you know the price before VAT and after VAT, the VAT amount is simply the difference between those two values.

Example of a VAT calculation

If a product costs £100 before VAT and the VAT rate is 20%, the final price after VAT is £120. The VAT amount is £20. If you already have a total of £120 including VAT, removing 20% VAT gives a pre-VAT price of £100.

Why VAT calculation matters for businesses

VAT affects selling prices, invoices, profit reporting, and customer transparency. Small businesses, eCommerce sellers, freelancers, and retailers often need to add VAT to prices or remove VAT from totals to understand the true underlying amount.

Use this multi-product VAT calculator

This calculator lets you enter multiple products with different VAT rates and calculation modes. It automatically works out the VAT amount, the pre-VAT price, and the final price after VAT for each row. You can also export the full table to CSV.

Need help with other calculations? Try our Break-even calculator, Profit calculator, Pricing calculator, Margin calculator, and Discount calculator.