Skip to content
CalculTVA.be

How to calculate an invoice with multiple VAT rates

When an invoice contains several VAT rates, calculate each net amount with its own percentage before adding the results together. Applying one rate to the full net total loses the breakdown between transactions. This guide explains how to organise unit prices, quantities and rates by line, then reconcile the net amount, tax and gross total. It also shows why rounding or a copied figure can create a difference. The calculation checks the arithmetic, while the appropriate tax treatment of each line must be established separately.

Prepare the lines and their net bases

Identify the net amount and applicable rate for every line. Multiply a unit price by the quantity first. When a document includes a line-specific discount, use its discounted base for your check. Keep lines separate until their VAT has been calculated. The examples assume the rates have already been correctly identified; they do not decide which tax category applies to particular goods or services.

Calculate each line before adding the results

Multiply each line’s base by its percentage and round its VAT to the nearest cent, following this website’s calculator. Add the bases for the net total and the already rounded taxes for total VAT. Gross is the sum of those totals. You can then group the results by rate to check them. Calculating and rounding only on combined bases may produce a different amount, so always compare the convention used by the document being checked.

€100 at 21% produces €21 VAT; €50 at 12% produces €6; €80 at 6% produces €4.80. Net total: €230. VAT: €31.80. Gross total: €261.80.

Why averaging the percentages is unreliable

The simple average of 21%, 12% and 6% is 13%. Applying 13% to the example’s €230 base produces €29.90 of tax, which is incorrect. The bases have different weights. Dividing 31.80 by 230 gives a weighted average for this particular example only. That ratio does not replace the individual rates or the breakdown supporting the document.

Review discounts, rounding and reverse calculations

A discount applying to one line should stay attached to that line. For an overall reduction, establish how it is allocated between the bases before recalculating VAT. Also compare rounding methods if your total differs from the figure produced by another application.

When starting with gross amounts, recover each base separately using the divisor for that rate. A grand total alone is insufficient to reconstruct a mixed-rate invoice. An exported or printed calculation is an arithmetic summary; it does not certify that all invoicing requirements have been met.

Questions about invoices with multiple VAT rates

A few useful pointers before you calculate.

Can I just apply 21% to the entire net total?

That would change the tax if some bases carry another rate. Keep the breakdown and calculate each group using its applicable percentage.

Can a gross total reveal every original invoice line?

No. Different allocations between rates can produce the same total. You need the amounts or subtotals associated with each percentage.

What is the total for amounts at 21%, 12% and 6%?

For €100 at 21%, €50 at 12% and €80 at 6%, the tax amounts are €21, €6 and €4.80. The totals are €230 net, €31.80 in VAT and €261.80 gross. Each rate is assumed to apply to its corresponding line.

Does the quantity multiply the taxable amount too?

Yes. Two items at €25 net each create a €50 taxable amount. At 21%, the tax is €10.50 and the line total is €60.50. In the table on the homepage, enter the net unit price and the corresponding whole-number quantity.

How do I calculate a discount across different rates?

If a 10% discount applies to €100 at 21% and €50 at 6%, the taxable amounts become €90 and €45. VAT is €18.90 + €2.70 = €21.60, giving €156.60 gross. First establish how the discount should be allocated.

Can I enter a gross price in the net price column?

No. Convert each price using its own rate first. For example, €121 gross at 21% equals €100 net, while €106 gross at 6% also equals €100 net. Together, they give €200 net and €227 gross.

How do I combine a line without VAT and taxed lines?

Keep it separate and establish its treatment first. For €200 at 0% and €100 at 21%, the totals are €300 net, €21 in tax and €321 gross. Selecting 0% numerically does not identify the arrangement applicable to the first line.

How many lines and which quantities does the table support?

The table on the homepage supports up to 100 lines, with whole-number quantities from 1 to 10,000. Net unit prices must be positive or zero, with up to two decimal places. The table does not support fractional quantities.

Can I enter negative lines for a credit note?

The table does not support negative unit prices. Use the simple calculator for a signed amount at a known rate, or calculate each rate group separately. A negative simulation does not produce a compliant credit note.

Is the CSV export an electronic invoice?

No. It saves the simulation’s lines and results; it does not create a structured electronic invoice or send anything to a customer. Issuing an invoice requires suitable invoicing software and the details applicable to the transaction.

Less doubt. More clarity.

Practical guides to understand a quote, check a price or prepare your calculations.