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

Download UAE VAT Payable Calculator Excel Template

Download UAE VAT Payable Calculator Excel Template

UAE VAT Payable Calculator provides you with the exact payable amount of VAT to Federal Tax Authority (FTA).

When you make sales you collect VAT. Credit Notes and Debit Notes issued against invoices are then adjusted while calculating VAT payable.

You are entitled to recoverable VAT input on purchases used for taxable supply. This recoverable VAT input reduces your tax liability.

In addition to that, as per the UAE VAT Law, you have to pay VAT under reverse charge under some conditions.

You can download the pdf copy of Federal Decree-Law No. (8) of 2017 on Value Added Tax from the link below:

Federal Decree-Law No. (8) of 2017 on Value Added Tax

Considering all the above points we have created an excel template for UAE VAT Payable Calculator.

UAE VAT Payable Calculator

You need to enter the just the taxable amount and it will automatically calculate the VAT amount as well as the exact payable amount to FTA>

Click here to download UAE VAT Payable Calculator Excel Template.

You can also download other UAE centric Accounting Templates like UAE Invoice Template, UAE Invoice Template in Arabic, UAE VAT Debit Note and UAE VAT Credit Note etc.

Let us discuss the creation of this template in detail.

Contents of UAE VAT Payable Calculator

The UAE VAT Payable Calculator consists of 3 sections:

  1. Header Section
  2. Calculation Section
  3. VAT Payment Section

1. Header Section

The header section consists of your company name, company logo, month, year and VAT registration number.

UAE VAT Payable Calculator

2.Calculation Section

Calculation section consists of 3 columns. Description, Taxable value and 5% VAT amount.

A user needs to enter amounts against each description and it will automatically calculate the applicable 5% VAT amount.

Balance Brought Forward: If there is any previous balance of VAT payable or recoverable VAT input it should be mentioned here.

VAT payable will be a positive amount and recoverable VAT input will be a negative amount.

Sales: Enter the taxable amount remaining after discounts if applicable in this cell. You can use our UAE VAT Sales Register Excel Template to maintain your sales.

Debit Notes: If any debit notes are issued during the month then you will have to mention the total taxable amount of all the debit notes in this cell.

Debit notes increase your liability as it increases your taxable value.

UAE VAT Payable Calculator

Reverse Charge Payable: IF you have imported any goods or reverse charge is applicable as per law then you have to enter the total taxable value of reverse charge in this cell.

You can use our UAE VAT Purchase Register Excel Template to maintain your purchases.

Recoverable VAT Input: According to UAE VAT law, a registered business is entitled to claim VAT paid on purchases used for taxable supply.

Hence, you will have to enter the total taxable value of such purchases in this cell.

Credit Notes: If any credit notes are issued during the month you will have to enter the total taxable value of all credit notes in this cell.

Credit notes decrease your liability as it reduces your taxable value.

UAE VAT Payable To FTA: Taking into consideration the UAE VAT Law, the  UAE VAT payable to FTA is calculated.

Formula Applied:

Sales + Debit Notes + Reverse Charge Payable – Recoverable VAT Input on Purchase – Credit Notes

3. VAT Payment Section

VAT Paid: If UAE VAT payable amount a positive amount then you need to pay that amount to FTA.

UAE VAT Payable Calculator

Balance Carry Forward: Sometimes it happens that your recoverable ITC is greater than the amount payable. In such cases, UAE VAT Payable to FTA will be a negative amount.

Such excess amount can be adjusted in preceding tax periods and thus you can carry forward that amount.

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.

« Download UAE VAT Sales Register Excel Template
Download VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE »

Filed Under: UAE VAT Templates

You are Here: Home / Excel Templates / UAE VAT Templates / Download UAE VAT Payable Calculator Excel Template

About Shabbir Bhimani

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

Comments

  1. GOLDEN LINK CONT & GEN.MAINT.L.L.C says

    December 25, 2017 at 5:00 am

    Very Interesting. Expecting notification of updates

    Reply
  2. GOLDEN LINK CONT & GEN.MAINT.L.L.C says

    December 25, 2017 at 5:00 am

    Very Interesting.

    Reply
    • Fahim Lashkaria says

      December 25, 2017 at 8:21 am

      Thanks

      Reply
  3. Masood Ahmed Syed says

    December 25, 2017 at 2:54 pm

    We are a manufacturing company in RAK. and our office in Sharjah,
    Can we claim Input VAT on our Expenses for our company like
    Repairs and Maintenance of our Company Vehicles,
    Fuel used by our Company Vehicles.
    Electricity and Water Bills for our Office
    Office Refreshments purchases for our Staff, etc

    Reply
    • Fahim Lashkaria says

      December 26, 2017 at 7:42 am

      According to Article 55 of Executive Regulation for VAT law Point number 5:

      To determine the Input Tax that could be recoverable, the Taxable Person shall apportion Input Tax as follows:

      a. Input Tax on supplies that wholly relate to supplies as specified in Clause (1) of Article (54) of the Decree-Law made by the Taxable Person shall be recoverable in full.

      b. Input Tax that does not relate to supplies as specified in Clause (1) of Article (54) of the Decree-Law made by the Taxable Person shall not be recoverable unless provisions allow otherwise.

      c. Input Tax that partly relates to supplies as specified in Clause (1) of Article (54) of the Decree-Law and partly not, shall be apportioned in accordance with Clause (6) of this Article and only that part that relates to supplies as specified in Clause (1) of Article (54) of the Decree-Law shall be recoverable.

      Furthermore, input tax cannot be deducted if it is incurred for certain expenses, such as entertainment expenses.

      Reply
  4. RICKY ALEX says

    May 9, 2018 at 4:20 pm

    Very good!!!

    Reply
    • Fahim Lashkaria says

      May 11, 2018 at 10:08 am

      Thanks, dear.

      Reply

Leave a Reply Cancel reply

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

UAE VAT Templates

  • UAE VAT Tax Invoice Excel Template As Per The Federal Law 8 of 2017 on VAT
  • UAE Invoice Template With VAT in Excel – Arabic
  • UAE VAT Credit Note Excel Template
  • UAE VAT Debit Note Excel Template
  • UAE VAT Inventory Management Excel Template
  • UAE VAT Purchase Register Excel Template
  • UAE VAT Sales Register Excel Template
  • UAE VAT Payable Calculator Excel Template
  • VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • VAT Credit Note Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Payable Calculator For All 6 GCC Countries
  • Arabic VAT Invoice Template for Bahrain, Kuwait, Oman, Qatar, Saudi Arabia and UAE
  • GCC VAT Invoice Template With Discount
  • UAE VAT Progress Billing Invoice Excel Template
  • UAE VAT Multiple Tax Invoice Excel Template
  • UAE VAT Dual Currency Invoice Excel Template
  • Bilingual UAE VAT Invoice Excel Template
  • Bilingual Saudi VAT Invoice Excel Template
  • Saudi VAT Payable Calculator Excel Template
  • UAE VAT Invoice Format for Rent A Car Business In Excel

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
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. 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