How to Calculate VAT for Mixed-Rate Supplies — Step-by-Step Guide

Most VAT arithmetic is simple until an invoice contains items at different rates. Then two things go wrong: people apply one rate to the whole total, or they subtract the percentage from a gross figure. Both produce wrong numbers, and both are common enough that finance teams routinely check for them.

The two directions

Adding VAT to a net figure:

Gross = Net × (1 + rate)

1,000 at 15 percent → 1,000 × 1.15 = 1,150

Removing VAT from a gross figure:

Net = Gross ÷ (1 + rate)

1,150 at 15 percent → 1,150 ÷ 1.15 = 1,000

The error that catches everyone: subtracting 15 percent from 1,150 gives 977.50, not 1,000. Subtraction is not the inverse of a percentage increase, because the 15 percent was calculated on the smaller number.

The gap widens with the rate. At 5 percent the error is modest; at 15 percent it is material; at 20 percent — Morocco's TVA — subtracting rather than dividing understates the net by a noticeable margin on every line.

Mixed-rate invoices

When an invoice contains items at different rates, each line must be calculated on its own base. There is no valid single rate for the invoice.

A supplier in Jordan invoicing standard-rated services and zero-rated exported goods:

Applying 16 percent to the full 10,000 would give 1,600 — overcharging the client by 960 and misstating your return. Applying an average rate would be wrong in a different direction.

Group by rate in the totals section. Finance teams and auditors expect to see the taxable base for each rate stated separately, because that is how the return is completed.

The VAT calculator handles both directions and avoids the subtraction error.

Zero-rated versus exempt

These look identical on an invoice — both show no tax — but they are fundamentally different, and confusing them produces incorrect returns.

The input-recovery difference is the one with financial consequences. If you make zero-rated supplies — exports, typically — you can generally still recover the VAT you paid on your own costs. If your supplies are exempt, you usually cannot, which means that input VAT becomes a real cost that has to be priced in.

A business with a meaningful proportion of exempt income needs partial exemption calculations, and that is genuinely a job for an accountant.

Rounding

Rounding errors compound across long invoices and produce totals that will not reconcile against the client's own calculation.

• Calculate tax per line, then sum — rather than summing the net and applying tax to the total. The two methods can differ by a small amount, and per-line is the conventional expectation.
• Match your currency's decimal places. Two for SAR, AED, EGP. Three for the Kuwaiti, Bahraini, Jordanian, Omani and Tunisian dinars, which subdivide into 1,000.
• Do not round intermediate values. Round once at the end of each line.

Three-decimal currencies deserve care. A rounding difference in the third decimal looks trivial but produces reconciliation queries on high-value invoices, and those queries delay payment.

Discounts and mixed rates together

Apply the discount before calculating tax, and apply it proportionally across the rates.

A 10 percent discount on the Jordan example:

Applying the discount after tax, or applying it entirely to one line, changes the tax due and misstates your return.

Multi-currency invoices

Where the invoice is priced in a foreign currency, most GCC jurisdictions require the tax amount to be shown in local currency as well, converted at a prescribed rate — typically the central bank rate on the supply date.

State the rate used and its date on the invoice. It prevents disputes and it is what an auditor will look for.

Common mistakes

1. Subtracting the percentage to remove tax. Divide by 1 plus the rate. 2. Applying one rate across a mixed invoice. Each line on its own base. 3. Confusing zero-rated with exempt. Different input-recovery treatment. 4. Two decimals on three-decimal currencies. Produces reconciliation gaps. 5. Applying discounts after tax. Misstates the tax due. 6. Not showing the taxable base per rate. Auditors and finance teams expect it. 7. Omitting the local-currency tax amount on foreign-currency invoices.

Frequently asked questions

How do I find the net from a gross amount? Divide by 1 plus the rate. At 15 percent, divide by 1.15. Never subtract the percentage.

Can one invoice carry several rates? Yes, and it is common. Calculate each line separately and show the taxable base for each rate in the totals.

What if I charged the wrong rate? Issue a credit note against the original invoice and raise a corrected one. Do not edit and resend under the same number.

Does a discount reduce the tax? Yes — tax is calculated on the discounted value, so apply the discount first.

Which currencies use three decimals? The Kuwaiti, Bahraini, Jordanian, Omani, Tunisian, Libyan and Iraqi dinars among others. Check before formatting invoices for a new market.

Practical next step

Check one recent multi-line invoice: was tax calculated per line, was the base shown separately for each rate, and were decimals correct for the currency? Those three checks catch nearly every VAT presentation error.

The VAT calculator handles both directions and mixed rates, and the invoice generator applies per-line rates and formats decimals correctly for the currency you select.

More from Xuvilo

Try our free tools: invoice generator, quotation generator, receipt generator, and 18 business calculators. For more guides, head back to the Xuvilo Blog.