Common Mistakes When Calculating VAT

Practical warnings about gross/net mix-ups and rounding mistakes.

Summary

The most common mistake is confusing whether you need to add VAT on top of an amount or extract it from within one. Removing VAT from a VAT-inclusive amount is a different calculation than adding VAT to a VAT-exclusive one.

Step by step

Determine whether your amount already includes VAT or not.
Choose the right operation (adding or extracting).
Enter the correct rate (e.g. 20%, 10%).
Round the result to at most two decimal places.

Why it matters

A small method error in a VAT calculation looks harmless on a single invoice. Repeat it across a monthly sales sheet with hundreds of rows, a quote, or a spreadsheet you send to your accountant, and you end up with gaps between your records and your tax return that are hard to explain. If the price you quoted a customer was based on the wrong math, you either eat the difference or have to go back and correct the price.

VAT in Turkey is called KDV, and invoices there commonly state whether a price is KDV dahil (included) or KDV hariç (excluded).

Common mistakes

Multiplying a VAT-inclusive amount by the rate to find the tax. For a 1,200 total at 20%, the tax is not 240. The correct split is 1,200 / 1.20 = 1,000 net and 200 VAT.
Subtracting the percentage to get back to net. Taking 20% off 1,200 gives 960, not the original 1,000.
Rounding each line separately and then adding them up, versus adding first and rounding once. On a long invoice the two approaches can differ by a few cents.
Applying a discount after VAT. The discount comes off the net amount, and VAT is calculated on what remains.
Using one rate for every line. Different goods and services can fall under different rates.
Dividing a percentage-formatted spreadsheet cell by 100 again. A cell showing 20% already holds 0.20.

An example

A supplier sends a quote that just says "Total: 3,600" with no mention of VAT. If you assume it excludes VAT and add 20%, you budget 4,320. If the supplier actually meant VAT included, your real cost is 3,600, of which 600 is VAT and 3,000 is net. That 720 gap is enough to skew a budget approval or a comparison between suppliers. The fastest fix is to ask the supplier in writing which one they meant before you calculate anything.

A quick self-check

After every calculation, run it backwards. Add the rate to the net figure you found. If you land exactly on the original VAT-inclusive amount, you are fine. If you don't, either the method was wrong or something got rounded too early.

When to ask a professional

Withholding VAT, exempt sales, exports, or any line where you are unsure of the correct rate are worth checking with an accountant before you rely on a calculator. For current rates and rules, check the official tax authority sources (in Turkey, the Revenue Administration, GİB).