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

Download UAE VAT Dual Currency Invoice Excel Template

Download UAE VAT Dual Currency Invoice Excel Template

UAE VAT Dual Currency Invoice is used when the invoice is prepared in currency other than UAE Dirham. Furthermore, it is mandatory by law to mention the tax amount in AED with the applied exchange rate.

According to Article (59), Clause 1, Point “k” of Cabinet Decision No 52 of 2017 on Executive Regulations, “The Tax amount payable expressed in AED together with the rate of exchange applied where the currency is converted from a currency other than the UAE dirham.”

UAE VAT Dual Currency Invoice

To download the Executive Regulations from the UAE Ministry of Finance click on the link below:

Cabinet Decision No 52 of 2017 – Executive Regulations

To download the same Executive Regulations from our website click the link below:

Cabinet Decision No 52 of 2017 – Executive Regulations

UAE VAT Dual Currency Invoice

We have created the UAE VAT Dual Currency Invoice template in excel with predefined formulas that will help you to issue the invoice with 2 currencies. One is UAE Dirham and second whichever applicable.

Click here to download UAE VAT Dual Currency Invoice Excel Template.

You can also download other UAE centric templates like UAE VAT Multiple Tax Invoice, Arabic VAT Invoice Template, GCC VAT Invoice Template With Discount, and UAE VAT Payable Calculator.

Let us discuss the contents of the template in detail.

Contents of UAE VAT Dual Currency Invoice Template

This Invoice template consists of 2 worksheets:

  1. UAE VAT Dual Currency Invoice worksheet.
  2. Customer worksheet.

The customer sheet contains customer details of customers like company name, address, contact details, and VAT numbers, etc. The user needs to enter the name only once on the sheet.

UAE VAT Dual Currency Invoice

The customer sheet has been linked to the customer details section of the invoice using data validation and VLOOKUP. Customer information can be fetched on the invoice with the help fo the dropdown list.

The template consists of 6 sections:

  1. Supplier Details
  2. Customer Details
  3. Conversion Details
  4. Sales Details
  5. Invoice Summary
  6. Other Miscellaneous Details

1. Supplier Details (Your Company Details)

As usual, this section consists of your company name, address, logo, TRN number, and Invoice heading.

UAE VAT Dual Currency Invoice

In addition to that, it also contains Invoice number, date of issue, payment due date, and no if days between the issue date and the payment date.

2. Customer Details

The customer details section is pre-programmed using data validation and Vlookup function. Just select the customer name from the dropdown list and it will automatically fetch all customer details.

It consists of customer name, address, VAT number, and contact details.

UAE VAT Dual Currency Invoice

3. Currency Conversion Details

As the invoice is in two different currencies, the acceptable conversion rate should be mentioned in this section against the UAE Dirham.

In this template, we have taken USD as other currency and thus given the conversion rate for the same. If you use any other currency, mention the currency’s alphabetical code and respective conversion rate.

4. Sales Details

This section consists of the following columns to enter the details of the sale made:

Description of Products
Quantity
Unit Price (USD)
Unit Price (AED)
Taxable Value (USD)
Taxable Value (AED)
Percentage of VAT
VAT Amount (USD)
VAT Amount (AED)
Line Total (USD)
Line Total (AED)
Column Totals

UAE VAT Dual Currency Invoice

5. Invoice Summary

Invoice Summary contains the totals of each column of the product details section in both UAD and AED. Additionally, it consists of a discount if applicable.

Enter discount either directly the amount or enter the percentage of discount offered. The system will automatically calculate the discount amount.

Lastly, it consists of the Invoice Amount. The amount is calculated using the below formula:

Invoice Amount (AED) = Taxable Value (AED) + Total VAT Amount (AED) – Discounts (AED)

Invoice Amount (USD) = Taxable Value (USD) + Total VAT Amount (USD) – Discounts (USD)

UAE VAT Dual Currency Invoice

6. Other Miscellaneous Details

Miscellaneous details consist of “Amount in words” for both the currencies; AED and USD, Terms & Conditions along with the space for company seal and authorized signatories.

At the extreme right of the invoice, there is a business greeting.

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. We will be more than happy to assist you.

« Download UAE VAT Multiple Tax Invoice Excel Template
Download Bilingual UAE VAT Invoice Excel Template »

Filed Under: UAE VAT Templates

You are Here: Home / Excel Templates / UAE VAT Templates / Download UAE VAT Dual Currency Invoice Excel Template

About Shabbir Bhimani

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

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
  • 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