• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Understanding UAE VAT Return Format

Understanding UAE VAT Return Format

UAE VAT Return Format has been published to FTA site. You can find it in the menu under partners, below Tax Accounting Software Vendors in Requirements.

UAE VAT Return Format

UAE VAT Return Format is on page 48 under Appendix 8 – VAT Return Format. The VAT Return Format start from page 48  and ends at page 57.

To simplify the document and avoid confusion we have cut the pdf from page 48 to page 57.

To download only the VAT Return from our server click the link below:

UAE VAT Return Format.

The work done here by FTA is really appreciable. The document is very precise and self-explanatory. It gives the description of each field to be filled in detail.

The VAT returns are required to be filed electronically on FTA portal. As prescribed by FTA, the acceptable format will be either in excel (.xlsx) and .xml format.

Reference:

UAE VAT Return Format

If the registrant is using the software that is approved by FTA, return filing will be available in the software.

UAE VAT Return will consist of the consolidated details of total supplies. These Supplies include both purchase and sales, VAT collected on supplies, recoverable input VAT paid on purchases, and the total tax due.

Article 64 of the Executive Regulations has prescribed the mandatory details to be given on a VAT return. See image below for reference:

UAE VAT Return Format

Summary of Details to be filled in UAE VAT Return Format

Details of Registrant

Giving your TRN number in the VAT return is mandatory. TRN is provided by the FTA when you register for VAT. Name and address details are also to be mentioned in VAT Returns.

An accounting software which complies with UAE VAT Return Format will auto-populate them for you.

VAT Return Period

VAT Return period consists of 3 details to be furnished, that is VAT return period, Tax Year and VAT Return Reference number.

VAT on Sales and all Other Outputs

Here you will enter details of sales made during the tax period. Standard supplies related to each emirate has to be mentioned differently.

Thus, it is clear that the registrant needs to maintain the records accordingly to avoid last minute delays.

In addition to the above, supplies related to reverse charge, zero-rated supplies, supplies to registered customers in other GCC implementing states, exempt supplies. import VAT accounted through UAE customs etc are to be furnished.

It is clear from the UAE VAT Format by FTA that zero-rated supplies, exempt supplies and the supplies made to registered customers in other GCC implementing state doesn’t attract VAT.

View the screenshot below for reference:

UAE VAT Return Format

Lastly, the totals of both the column are given below referred as A1 and A2.

VAT on Expenses and all other Inputs

VAT related to expenses (that are used for taxable supply) and all other kinds of inputs are reported in this section.

 

This includes Standard rated expenses, supplies subject to reverse charge and amendments if any. At the end, the totals of both the column are given below and referred as A3 and A4.

Net VAT Due

The Net amount of VAT due is calculated as below:

  1. The total value of due tax for the period referred here as A5, where A5 = A1 + A2.
  2. The total value of recoverable tax for the period referred here as A6, where A6 = A3 + A4.
  3. Net VAT due(or reclaimed) for the period referred here as A7, where A7 = A5 – A6.
  4. If the amount of output is less than the input amount, then the registrant is eligible for a refund. Thus, if the registrant willing to claim he should provide yes in this column.

UAE VAT Return Format

In case the registrant doesn’t take the refund the balance VAt will be adjusted in preceding tax periods.

Additional Details

The above details will be applicable to all the VAT registrants. Apart from the above-mentioned details, the return format also consists of other additional details as listed below:

  • Profit Margin Scheme applicability.
  • Imported Goods transferred to other GCC implementing states.
  • VAT paid on personal imports via Agents.
  • Transportation of own goods to other GCC states.
  • Recoverable VAT paid in other GCC implementing states.
  • Tax Refunds for Tourists Scheme.

Declaration

At the end, the registrant signs a declaration with following details:

  1. Online Username (English)
  2. Online Username (Arabic)
  3. Declarant name (English)
  4. Declarant name (Arabic)
  5. Emirates Identity Card number
  6. Passport number (if no Emirates ID available)
  7. Declarant mobile country code
  8. Declarant mobile number
  9. e-mail address
  10. Submission Date

Disclaimer: The explanations provided here are for educational purpose and does not give any legal binding against the law. Authenticate references from the Law have been provided for the understanding. 

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

Filed Under: UAE VAT

You are Here: Home / Reader's Question / Understanding UAE VAT Return Format

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Comments

  1. Nayeem Khan says

    April 4, 2018 at 9:28 am

    Dear Sir,

    Thank you very much – your site have lots of information and easy to understand about GCC VAT and other related details .

    Reply
    • Fahim Lashkaria says

      April 5, 2018 at 10:36 am

      Thanks, dear. Happy to know you liked it. Share it with your friends and colleagues.

      Reply
  2. Naveed says

    May 9, 2018 at 9:24 am

    Mr. Fahim

    I have a question. Sales of 2017 returned in 2018.Then customer is asking new items in that returned, so our invoice must have the tax or not? We need to issue a credit note of 2017 but also we need to make new invoice of new items so this invoices tax should be included or not?

    Reply
    • Fahim Lashkaria says

      May 11, 2018 at 10:16 am

      The returning of good for 2017 can be settled by credit note. New items issued will be with VAT applicability and thus new invoice with vat will be issued.

      Reply
  3. Himani Agarwal says

    June 11, 2018 at 4:49 pm

    Is there any way to download the filed return from FTA site?

    Reply
    • Fahim Lashkaria says

      June 12, 2018 at 11:03 am

      No. Not that I know of. Will inquire and update.

      Reply
      • YUNUSKHAN says

        July 11, 2020 at 8:09 pm

        YES, YOU CAN DOWNLOAD AFTER LOGIN.
        1. DOWNLOAD – 3RD OPTION
        2. GO TO RETURN – VAT & EXCISE TAX – 3RD OPTION
        3. REFUND REQUEST EXCEL – SELECT LAST OPTION

        HOPE, DONE YOUR QUESTION

        Reply
        • Fahim Lashkaria says

          July 13, 2020 at 2:44 pm

          Thanks, Yunus Khan for your input

          Reply
  4. Jamsheed says

    July 8, 2018 at 2:39 pm

    sir ,we issued a TAX CREDIT NOTE in current tax period against the sales of previous tax period . so how we can adjust the amount while doing the current tax return. shall we need to show the amount in VAT Adjustment column??

    Reply
    • Fahim Lashkaria says

      July 9, 2018 at 2:04 am

      Yes, it will be reported in VAT Adjustments under Standard Rate

      Reply
  5. Tejveer Singh says

    August 24, 2018 at 7:10 am

    We have made mistake in VAT return, We have shown VAT payable and VAT receivable figure in Sales and Purchase column instead of showing Sales and Purchase amount .?

    1. Now can we file voluntary disclosure.
    2. Or should be adjust in next VAT return.
    3. VAT penalty will be applicable.

    Please suggest.

    Reply
    • Fahim Lashkaria says

      August 24, 2018 at 10:37 am

      Voluntary disclosure to be filed to avoid any kind of penalty.

      Reply
  6. Ashish says

    February 18, 2019 at 10:25 am

    We are planning to construct a new plant which will take almost 1 year. We will not have any Sales/Supplies till the First return period.

    We have made various expenses prior to tax registration period (not much prior just 6 months), will we be able to claim the VAT for the expenses made prior to the vat return period with first vat return.

    If Yes, How we will show in return?

    Reply
    • Fahim Lashkaria says

      February 22, 2019 at 7:31 am

      Yes, the UAE VAT laws allow the recovery of input tax paid on goods, services and imported goods prior to the date of VAT registration. This will be allowed, only if the goods and services were used to make supplies that give the right to input tax recovery upon tax registration. This implies that the purchases/expenses on which VAT was paid before registration were used in making taxable supplies after registration.

      The recovery of Input VAT will be in accordance with the general provisions of input TAX recovery and more importantly, the recovery should be done in the VAT Return submitted for the first Tax Period following Tax Registration.

      However, the UAE VAT also stipulates certain exceptional scenarios in which VAT paid before registration cannot be recovered. The following are the instances:

      1. Goods and Services purchased for the purpose of making non-taxable Supplies. This implies that you can recover VAT, only if it is used for making taxable supplies including zero-rated supplies.
      2.Input Tax related to the part of the Capital Assets that depreciated before the date of Tax Registration. This implies that If part of the asset is depreciated then Input tax cannot be recovered on such assets to the extent such assets are depreciated. For example, if you purchase a fixed asset with an expected life of 10 years and when you register for VAT the asset has only 3 years of use left. In this case, you can reclaim only 30% of the VAT you originally paid.
      3. Input VAT on service received more than 5 years prior to the date of tax registration will not be allowed to be reclaimed. This restriction is applicable only for services and not applicable for goods.
      4.If such goods were moved to another GCC country before tax registration.
      Except for the instances listed above, in all other cases, you will be eligible to recover VAT paid before registration, if it is used for making the taxable supply.

      Source: http://www.tallysolutions.com/mena

      Reply
  7. YUNUSKHAN says

    July 11, 2020 at 7:34 pm

    DEAR SIR,
    I WANT TO KNOW MY COMPANY HAS PAID VAT ON IMPORT IN 2018 WHEN VAT LAW IS NEWLY STARTED, (THAT TIME OUR TRN# NOT LINKED WITH CUSTOMS DEPARTMENT) THAT;S WHY WE HAD PAID VAT ON IMPORT.
    NOW MY QUESTION IS CAN WE CLAIM REFUND FOR THIS PAID VAT NOW (APRIL-20 TO JUNE-20 VAT PERIOD)?

    Reply
    • Fahim Lashkaria says

      July 13, 2020 at 2:43 pm

      If you have directly paid the VAT in your company name then you can claim through voluntary disclosure.

      Reply
  8. Ahsan says

    January 26, 2021 at 2:44 pm

    Sir,we are a trading company locate at Dubai Aviation Free zone.we don’t have any related company in uae mainland nor outside the UAE.
    Kindly confirm do we have to file with Electronic Substance Report(ECR) or not.

    Pls also confirm the details of ECR.

    Thanks
    Ahsan

    Reply
    • Fahim Lashkaria says

      January 27, 2021 at 2:45 pm

      Hi Ahsan,

      According to my knowledge:
      The Regulations apply to financial years commencing on or from 1 January 2019. Entities that are within the scope of the Regulations are required to submit an annual Notification form to their Regulatory Authority, and complete and submit to the same Regulatory Authority an Economic Substance Report within 12 months from the end of their financial year (e.g. 31 December 2020 for entities with a financial year ending 31 December 2019). An entity is not required to meet the Economic Substance Test and file an Economic Substance Report for any financial period in which it has not earned income from a Relevant Activity or if it meets the conditions for being exempt. A Notification form will need to be submitted regardless. Failure to comply with the Regulations can result in penalties, spontaneous exchange of information with the Foreign Competent Authority (as defined in Article 1 of the Regulations), as well as other administrative sanctions such as the suspension, revocation, or non-renewal of the entity’s trade license or permit.

      Hence It is not required by you. For more information, you can check here: https://www.mof.gov.ae/en/StrategicPartnerships/Pages/ESR.aspx

      Reply
      • Ahsan says

        January 27, 2021 at 4:29 pm

        Sir,
        can you elaborate the relevant activities….because most of people doesn’t know about this and confused.
        Thanks
        Ahsan

        Reply
      • Fahim Lashkaria says

        February 1, 2021 at 12:29 pm

        Hope this will clear your remaining doubts:

        https://www.difc.ae/business/operating/economic-substance-regulations/#:~:text=The%20Relevant%20Activities%20under%20the,Investment%20Fund%20Management%20Businesses

        Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT