VAT201 RETURNWORKSHEET 5% Excel
Home / Templates / VAT201 return worksheet
Free · no sign-upChecked 20 Nov 2026Tax

VAT201 worksheet, box by box

Prepare the return in a sheet first, then type the numbers into EmaraTax. Boxes 8, 11, 12, 13 and 14 calculate themselves.

Built for VAT201box by boxEmirate splitBox 1a to 1g
Short answer

The VAT201 return has output boxes 1a to 1g (standard-rated sales by emirate), 2 (tourist refunds), 3 (reverse charge), 4 (zero-rated), 5 (exempt), 6 and 7 (imports), totalled in box 8; input boxes 9 (standard-rated expenses) and 10 (reverse charge inputs), totalled in box 11; then 12 total tax due, 13 recoverable tax and 14 payable tax. File and pay by the 28th day after the end of the tax period (VAT Executive Regulation Article 64).

01What goes on it

What does the law require, and what is just good practice?

Every line is marked. "Law" means a UAE law, decree or regulation says it, with the article. "Practice" means it is common and sensible, but no rule requires it.

ItemStatusWhere it comes from
Return and payment by the 28th day after the period endsLawER Art. 64; FTA filing page (next working day if it falls on a weekend or holiday, per FTA guide)
Standard tax period is 3 calendar months, dates set by the FTALawER Art. 62
Input VAT only with a valid tax invoice and not blockedLawER Art. 53 and 59
Reverse charge VAT shown in box 3 and claimed in box 10 where recoverableLawDecree-Law Art. 48; FTA return guide
Sales split by the emirate of the establishment making themPracticeHow the FTA form is laid out; confirm with the FTA user guide
Late return AED 1,000 (AED 2,000 if repeated within 24 months); late payment 14% a year, monthlyLawCD 40/2017 as amended by CD 129/2025, from 14 Apr 2026
Law stated in legislationPractice common, not required
02Preview and how to fill it

See it filled in, then make it yours

Switch between the worked example and the blank version you download. Example figures are illustrative.

VAT201 worksheetJul-Sep 2026
CompanyDune Studio LLC (example)
TRN100XXXXXXXXXXXX
Due date28 Oct 2026
BoxDescriptionAmount (AED)VAT (AED)
1bStandard rated supplies in Dubai420,000.0021,000.00
3Supplies subject to reverse charge12,000.00600.00
4Zero rated supplies35,000.00 
5Exempt supplies0.00 
8Totals (outputs)467,000.0021,600.00
9Standard rated expenses180,000.009,000.00
10Supplies subject to reverse charge (inputs)12,000.00600.00
11Totals (inputs)192,000.009,600.00
12Total value of due tax 21,600.00
13Total value of recoverable tax 9,600.00
14Payable tax for the period 12,000.00

Example figures. Box 3 here is Google Ads and other services bought from abroad: VAT you charge yourself in box 3 and, if the cost is for taxable sales, claim back in box 10.

Example company and figures are made up. Replace every grey hint with your own details.

01

Get your period dates from EmaraTax

The FTA sets your quarter ends, often staggered (for example February, May, August, November).

02

Sales by emirate

Put standard-rated sales in the box for the emirate of the branch that made them.

03

Reverse charge both sides

Imported services (software subscriptions, ads) go in box 3 as output and box 10 as input.

04

Inputs only with tax invoices

Box 9 is standard-rated expenses you hold valid tax invoices for, less blocked items like client entertainment.

05

Check box 14 against the bank

Pay the box 14 amount by the 28th using the GIBAN on EmaraTax.

03Common mistakes

What we see go wrong

Small slips that cost VAT, fines or an argument with a customer or employee.

!Claiming input VAT in box 9 for receipts that are not tax invoices.
!Forgetting reverse charge on foreign software and ads. It usually nets to zero, but missing it is still an incorrect return.
!Putting a branch's sales under the head office emirate.
!Declaring VAT when the cash comes in rather than on the invoice date. VAT follows the date of supply.

Or let the numbers fill themselves.

fylng reads your UAE bank exports and receipts, sorts every line under UAE rules and builds the VAT201 and a corporate tax estimate. Free to start. You still file on EmaraTax.

See how it works
FAQVAT201 return worksheet

Questions people ask

When is the VAT201 return due?+

By the 28th day after the end of the tax period, together with payment. Most businesses file quarterly.

What goes in box 3 of the VAT return?+

Supplies on which you account for VAT under reverse charge, such as services bought from suppliers outside the UAE. The same VAT usually goes in box 10 as recoverable input tax.

What is the penalty for filing VAT late?+

Since 14 April 2026: AED 1,000 for the first late return and AED 2,000 for a repeat within 24 months, plus 14% a year on late payment, charged monthly.

Can I file the VAT201 from this Excel?+

No. VAT returns are filed on EmaraTax. This worksheet prepares the numbers so you can type them in and keep a record of how you got them.

Does fylng do this?+

Yes: fylng builds the VAT201 box by box and by emirate from your bank statements and receipts, and flags input VAT missing a tax invoice. You still file on EmaraTax.

Sources

Facts checked 20 Nov 2026. Official sources first; press and Big-4 summaries are marked. English texts of UAE laws are translations; the Arabic text prevails. This template is not legal or tax advice: rules change, so confirm with the FTA, MoHRE or your authority.

  1. VAT Executive Regulation, Cabinet Decision 52 of 2017 and amendments (FTA): Art. 53 blocked input tax, 59 tax invoice particulars, 60 credit notes, 61 rounding, 64 return deadline
  2. Federal Decree-Law No. 8 of 2017 on VAT and its amendments (FTA): Art. 25 date of supply, 48 reverse charge, 65 and 67 tax invoices, 69 currency, 70 credit notes
  3. FTA: Filing VAT returns and making payments
  4. Cabinet Decision 40 of 2017 on administrative penalties, as amended by Cabinet Decision 129 of 2025 (MoF consolidated text): in force 14 Apr 2026
  5. u.ae: Filing a VAT return: quarterly vs monthly periods

Upload statements,
receive a filed return.

ارفع كشوفك، واستلم أرقام إقرارك جاهزة.

Start free
دقةأمانشفافيةوفق أنظمة دولة الإمارات

fylng is UAE accounting software by DueDoor for VAT, corporate tax and bookkeeping, built for businesses in Abu Dhabi, Dubai, Sharjah, Ajman, Umm Al Quwain, Ras Al Khaimah and Fujairah. Privacy · Terms · llms.txt