Loading…

Free once a day · Unlimited for Premium members

VAT Worksheet Generator

The VAT Worksheet Generator works out the 5% UAE VAT you owe or can reclaim for a return period. Enter sales split into standard-rated, zero-rated and exempt, plus purchases that carry VAT, and you get output tax, input tax, the net amount, and the filing and payment deadline. It is a working sheet to prepare your figures, not a replacement for the Federal Tax Authority return.

Before you start

  1. Take the figures from your accounting system for the same period as your VAT return, usually a quarter.
  2. Tick the box if your amounts already include VAT. The tool then takes the VAT out first.
  3. If part of your input VAT is not recoverable, such as certain entertainment costs, enter the share that is blocked.
  4. The due date is the 28th day after the end of the return period. Put the date in your calendar from the result.

Figures for the period

Period
Sales
Purchases

Free members can run this once a day. Premium members have unlimited use.

A trading company for the current quarter

A small trading company in Dubai made AED 640,000 of standard-rated sales and AED 90,000 of zero-rated exports, with no exempt sales. Purchases carrying VAT came to AED 410,000 and 5% of the input VAT is blocked.

What the tool gives back for these figures

You owe AED 12,525 in VAT for the period. Filing and payment are due by 28 Jan 2027.

Output VAT
AED 32,000
Recoverable input VAT
AED 19,475
VAT payable
AED 12,525
Due date
28 Jan 2027

What this is not

It does not file anything and does not know your specific circumstances: partial exemption, reverse charge, imports and designated zones all change the answer. Have your accountant review the return before you submit it through the FTA portal.

Questions people usually ask

What is the UAE VAT rate?

The standard rate is 5%. Some supplies, such as certain exports and international transport, are zero-rated, and some, such as certain residential property and local passenger transport, are exempt.

Who must register for VAT?

Registration is mandatory once taxable supplies pass AED 375,000 in 12 months and voluntary above AED 187,500. Check the Federal Tax Authority’s current guidance, as thresholds can change.

What is the difference between zero-rated and exempt?

Zero-rated sales are taxable at 0%, so you can still reclaim input VAT on related costs. Exempt supplies are outside the charge and generally do not allow input VAT recovery.

When is the return due?

Within 28 days after the end of the tax period. The tool counts this from the date you enter. Check your own registration for the exact period.

Can a negative result be refunded?

When input tax is larger than output tax, you can generally carry the credit forward or ask for a refund. Your accountant can say which is better for your cash flow.

Results rely only on what you enter. Check the figures against the seller's accounts, the lease and the trade licence, and take professional advice before you commit money. This is not a formal valuation, legal or tax advice.

Layla AISell your business free AI valuation✕
Top