How to Calculate VAT / GST in Excel (Add & Reverse)
Two everyday tax jobs: adding VAT to a net price, and backing it out of a tax-inclusive total (reverse VAT). Both are a quick formula — until you're doing them across a column and need Net, Tax, and Gross side by side.
Last updated: September 2026
| Amount | Net | Tax | Gross | |
|---|---|---|---|---|
| 100 (net, +5%) | → | 100 | 5 | 105 |
| 105 (gross, −5%) | → | 100 | 5 | 105 |
Method 1 — the formulas
- Add tax: gross
=A2*1.05, tax=A2*0.05(5%). - Reverse VAT: net
=A2/1.05, tax=A2-A2/1.05. - Fine for one column, but you end up with three helper columns and the rate hard-coded in each.
Method 2 — the 1-click way (Tellsheet)
VAT / GST Split
Point it at the amount column, choose whether each figure is net (add the tax) or gross (back it out — reverse VAT), and set the rate — 5% for the GCC, 20% UK, 15% KSA, anything. It writes clean Net, Tax, and Gross columns beside the source, reads currency-formatted text, and rounds to your decimals. Fully offline. Pairs with Batch Calculate and Currency Converter.
Frequently asked questions
How do I add VAT to a price?
=A2*1.05 for the gross, or VAT / GST Split "Add" mode for a whole column.
How do I do reverse VAT?
=A2/1.05 for the net, or the tool's "Extract" mode.
Which rates does it support?
Any — 5% GCC, 20% UK, 15% KSA, and so on.
Does it read "$1,000.00"?
Yes — currency-formatted text is parsed automatically.
Related Excel guides
VAT and reverse VAT in one click
VAT / GST Split writes Net, Tax, and Gross across your whole column — offline.
Get Tellsheet free See pricing