← Back to calculator

Templates › Business

Add VAT Calculator

When you write a quote or invoice, you start from your net price and add VAT on top. This template links your net price and VAT rate to the VAT amount and the final price your customer pays.

Open this template

1How it is calculated

  1. Calculator A (Price excl. VAT): your net price, for example €100.
  2. Calculator B (VAT rate): the VAT percentage, for example 21% (or 12% or 6%).
  3. Calculator C (VAT amount): A × B% = €21 — the VAT added on top.
  4. Calculator D (Price incl. VAT): A + C = €121 — what your customer pays.

2Use it with your own numbers

Open the template and every calculator is already set up, named and linked. Change any input and all connected results recalculate instantly. Add extra calculators to extend the calculation, or share the finished workspace with one short link.

Open this template

Other templates