Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download United Arab Emirates Invoice Template. Double-click the downloaded file to extract all files.
  2. Open the template "unitedarabemirates-billing-form.xlsx" or "unitedarabemirates-billing-form-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

United Arab Emirates Invoice Template

United Arab Emirates Invoice Template (c5073)

c5073 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open unitedarabemirates-billing-form-uis.xlsx.

United Arab Emirates Invoice Template (UIS Edition)

United Arab Emirates Invoice Template - UIS edition

Download United Arab Emirates Invoice Template (c5073)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

279 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.78 MBDownload

Detail

Converting paper-based invoice flows to electronic channels is an efficient way to cut costs and enhance supply chain integration. Use this template, United Arab Emirates Invoice Template, or United Arab Emirates Billing Form, as a starting point of design of your own invoicing form for your UAE-based business.

Note that this invoicing format is in English, as InvoicingTemplate.com offer this template as a sample invoice that help you simplify the design of your own invoice template. To replace the text labels on the form with the labels in your favorite language, such as Arabic, simply unprotect the Invoice worksheet and then type in your own text labels to replace the existing ones.

The protection of the "Invoice" worksheet in United Arab Emirates Invoice Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in United Arab Emirates Invoice Template.

The layout of this Excel template United Arab Emirates Invoice Template is created in a way so that it meets the following requirements.

  • Supplier Information (Your Information)
    • Supplier Name
    • Supplier Address
    • Supplier's VAT registration number
    • Supplier's telephone number, contact person and email address
    • Bank information
  • Customer Information (Client Information)
    • Customer name
    • Customer address
    • Customer's telephone number, contact person and email address
    • Shipping address
  • The word INVOICE or CREDIT (In case of credit note)
  • Invoice number (must be unique, which could be generated automatically when Uniform Invoice Software is installed).
  • Invoice date (please specify the format used - it is in dd/mm/yyyy format by default)
  • Currency, must be the same currency as stated in the Purchase Order
  • Specification of goods and services delivered
  • Tax amount. If multiple taxes (VAT/WHT) are applicable
  • The tax rate for every net amount should be specified
  • Total payable amount
  • For credit notes, invoice number being credited must be stated (one credit note per invoice)

This template, like the default sales invoice template shipped with Uniform Invoice Software installer program, has two taxes set by default, namely VAT and WHT, with the rates set to 5% and 6% as the place holders.

If you use the Uniform Invoice Software version of United Arab Emirates Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Looking for template design inspiration? Our templates, including United Arab Emirates Invoice Template, are all in Microsoft Excel format, and are all created based on the default invoicing template packed with UIS, which is our invoicing software that could turn a simple Excel invoice / receipt template, such as United Arab Emirates Invoice Template, into a complete invoicing program, with features like tracking customers, products, bills and payments. We at InvoicingTemplate.com offer United Arab Emirates Invoice Template to you for free and believe that even if you cannot adapt it for creating invoices directly, it surely could give you some design inspirations.

Although it is easy to create the layout and format of United Arab Emirates Invoice Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, United Arab Emirates Invoice Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of United Arab Emirates Invoice Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

To change the currency symbol of United Arab Emirates Invoice Template, first make sure you've unprotected United Arab Emirates Invoice Template spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on United Arab Emirates Invoice Template, you push CTRL key on keyboard and click each cell on United Arab Emirates Invoice Template one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

Like other form designs here on InvoicingTemplate.com, United Arab Emirates Billing Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5073
NameUnited Arab Emirates Invoice Template
CategorySales Invoice Template
Release DateWednesday, August 26, 2015
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$47
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates