Download
UAE VAT calculator
- Add and remove 5% VAT
- VAT return summary
- Late payment penalty estimate
Opens in Excel, Google Sheets and Apple Numbers.
Free tools · UAE tax
UAE VAT calculator: add or remove 5% VAT in AED.
Excello's free UAE VAT calculator adds or removes the standard 5% VAT on any amount in AED, shows the formula behind it and estimates late payment penalties.
It gives estimates for planning. Rates were last checked on 17 September 2026 against the UAE Ministry of Finance and the Federal Tax Authority.
Free. No sign-up. Amounts in AED.
- UAE VAT
- Standard rate 5%
- Registration above AED 375,000
- Late payment 14% a year
- Checked 17 September 2026
UAE VAT calculator online
Try it
Choose whether to add or remove VAT, enter an amount, and the results update as you type. The second panel works as a UAE VAT late payment penalty calculator.
How to calculate VAT in UAE: the formula
The formula
| To do this | Formula | Example |
|---|---|---|
| Add VAT to a net price | VAT = net × 5%; gross = net × 1.05 | AED 1,000 + AED 50 = AED 1,050 |
| Remove VAT from a gross price | Net = gross ÷ 1.05 | AED 1,050 ÷ 1.05 = AED 1,000 |
| Find the VAT inside a gross price | VAT = gross × 5 ÷ 105 | AED 1,050 × 5 ÷ 105 = AED 50 |
| Work out VAT payable | Output VAT on sales − recoverable input VAT on purchases | AED 12,500 − AED 6,000 = AED 6,500 |
UAE VAT calculation in Excel, and a free download
The workbook
| Result | Formula |
|---|---|
| VAT on a net amount in A2 | =A2*5% |
| Gross amount from a net amount | =A2*1.05 |
| Net amount from a gross amount | =A2/1.05 |
| VAT inside a gross amount | =A2-A2/1.05 |
Registration thresholds and late payment penalties
The rules
| Rule | Amount | What it means |
|---|---|---|
| Mandatory registration | Above AED 375,000 | Taxable supplies and imports above this must register |
| Voluntary registration | Above AED 187,500 | Businesses above this may choose to register |
| Late payment | 14% per annum | Charged monthly on unpaid tax, for each month or part of a month |
| Late return | AED 1,000, then AED 2,000 | AED 2,000 applies if it happens again within 24 months |
Example: AED 6,500 of VAT paid two months late gives an estimated penalty of AED 151.67: AED 6,500 × 14% ÷ 12 × 2.
Source: UAE Ministry of Finance, VAT; Federal Tax Authority, Cabinet Decision No. 40 of 2017 as amended by No. 129 of 2025. Last checked 17 September 2026.
VAT figures ready when the return is due
Where Excello fits
Frequently asked questions
How do I calculate 5% VAT in the UAE?
Multiply the net amount by 0.05 to get the VAT, or by 1.05 to get the total including VAT. On AED 1,000, the VAT is AED 50 and the total is AED 1,050.
What is the VAT rate in the UAE?
The standard VAT rate in the UAE is 5%, in place since VAT was introduced on 1 January 2018. Some supplies are zero-rated or exempt, so check how each of your sales is treated.
How do I remove VAT from a price in the UAE?
Divide the price including VAT by 1.05 to find the net amount, then subtract that from the price to find the VAT. AED 1,050 divided by 1.05 is AED 1,000, so the VAT inside it is AED 50.
When must a business register for VAT in the UAE?
Registration is mandatory when taxable supplies and imports exceed AED 375,000, according to the UAE Ministry of Finance. A business can register voluntarily once they exceed AED 187,500.
What is the penalty for late VAT payment in the UAE?
Unpaid VAT attracts a penalty of 14% per annum, charged monthly for each month or part of a month after the due date. The rule applies from 14 April 2026 under Cabinet Decision No. 129 of 2025.
Is this UAE VAT calculator free?
Yes. The calculator and the Excel version are free, with no sign-up. They give estimates for planning; VAT returns and payments are made through the Federal Tax Authority's EmaraTax portal.