Accounting template
VAT Calculator Template
Convert between prices with and without VAT in one sheet. Change the rate once and every row updates.
Opening a template uses no credits.
What's inside
| Row | A | B | C |
|---|---|---|---|
| 1 | VAT rate | 0.25 | |
| 2 | Net price | VAT | Gross price |
| 3 | 1,000 | =A3*$B$1 | =A3+B3 |
| 4 | 2,400 | =A4*$B$1 | =A4+B4 |
| 5 | Gross to net | ||
| 6 | 1,250 | =A6/(1+$B$1) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B3 =A3*$B$1
VAT is the net price times the rate.
C6 =A6/(1+$B$1)
Removes VAT from a gross price.
Make it yours by asking
Try a request like this in Tabstra:
"Create a VAT calculator that adds VAT to net prices and removes VAT from gross prices using one VAT rate"