VAT · United Arab Emirates
VAT formula (5%)
The exact formulas and ready-to-use factors for 5% UAE VAT, including a spreadsheet snippet.
- ÷ 1.05
- × 0.0476
- Excel
The calculator
Net · VAT · GrossFormulas
- Remove VAT: Net = Gross ÷ 1.05
- VAT amount: VAT = Gross − Net = Gross × 0.0476
- Add VAT: Gross = Net × 1.05
Factors
| To get | From | Multiply by |
|---|---|---|
| Net | Gross | 0.9524 |
| VAT | Gross | 0.0476 |
| Gross | Net | 1.05 |
| VAT | Net | 0.0500 |
In a spreadsheet
If the gross amount is in cell A1:
- Net:
=A1/1.05 - VAT:
=A1-A1/1.05 - Gross from net in
A1:=A1*1.05
FAQ
Frequently asked questions
What is the formula to remove VAT?
Net = Gross ÷ (1 + rate). At 5%: Net = Gross ÷ 1.05. VAT = Gross − Net.
What is the VAT fraction for 5%?
The VAT contained in a gross amount is Gross × 0.05 ÷ 1.05 ≈ Gross × 0.0476.