United Arab Emirates: Templates and Extensions

 

Other countries

United Arab Emirates: Templates Business

Multi currency-accounting template for enterprise in United Arab Emirates with VAT (account numbers)

Multi currency-accounting template for enterprise in United Arab Emirates with VAT (account numbers)
Description

Information specific for United Arab Emirates:

Accounting template features

The template has been setup in order to let you manage a company in United Arab Emirates:

Balance Sheet and Profit & Loss

The Accounts table contains all accounts and groups, structured for balance sheet (BS) and the profit & loss statement (PL).

  • Customize the accounting plan to exactly your needs by changing description, add or remove accounts and groups. 
  • Select the View Basic and enter the opening balance available in the column “Opening”.

The following image shows the Account table, Balances view.

  • The column “Balance AED” is updated automatically when you change the opening amount or you enter transactions in the Transactions table”.

 

Balance sheet

The balance sheet shows your assets and your liabilities. Banana Accounting includes accounts that are usually utilized by SMEs. Nevertheless, you can customize the accounts. Be careful not to modify the accounts related to the VAT reporting. Those are essential to correctly generate the VAT report needed to fill out the online VAT return form in Saudi Arabia.

Profit & loss statement

The profit & loss statement shows the revenues and the expenses incurred by the company. Banana Accounting included accounts usually used by SMEs. Nevertheless, you can customize the accounts when needed.

Clients/suppliers register

After the P&L statement, there is a section where you can assign accounts to specific customers and suppliers. You will use these accounts to register transactions directly related to specific customers or suppliers. Banana also offers the possibility to print invoices from these transactions.

All the accounts in the clients/suppliers register are regrouped under two accounts present in the assets and liabilities.

Double-entry accounting

You will notice that liability and revenue accounts are shown in negative and in red color. This is due to the fact that Banana Accounting fully leans on the concept of double-entry accounting. The principle of “debit and credit” present in the double entry accounting is usually represented in two separate columns. When it appears in a single column, as it happens in the accounts table, it is shown in red and in negative to better distinguish debit accounts from credit accounts.

 

domenico
File URL
https://github.com/BananaAccounting/International/raw/master/UnitedArabEmirates/templates/UAE-Multicurrency-VAT.ac2
ac2 language
UAE (United Arab Emirates) Double-Entry Accounting with vat/sales tax and foreign currencies Business
ac2 publisher

VAT Report Extension for United Arab Emirates

VAT Report Extension for United Arab Emirates

New VAT reporting for small business in UAE

Businesses in the United Arab Emirates (UAE) will have to pay VAT on their sales.

A VAT tax is an indirect tax imposed on most of the goods and services commercialized by a business. After collecting the tax, businesses will transfer it to the government. In the UAE, the tax authority in charge is the Federal Tax Authority (FTA).

Every business will have to periodically calculate and report the VAT to the FTA by filling the official online form with all the necessary figures.

As you can see from the following image, the report is similar to the online VAT form. With all calculated amounts you only need to enter in the form.

 

Documentation for

The VAT Report for UAE require an accounting file that is correctly setup with accounts and VAT code.
See the following pages for more information:

Open source collaboration

The solution has been developed with an open source concept:

  • In 2018 a user of Banana Accounting in UAE has asked us if we could implement an automatic VAT reporting.
  • He made available the accounting plan he was using.
  • He gave us the link to the tax authority web site with all the information regarding the VAT process.
  • Together with our specialist we have worked out the VAT table, with all the necessary VAT codes customized for UAE.
  • Banana.ch  developers has programmed a report for VAT reporting, that is similar to the filling form.

Updates

We do not have personal on UAE. If there are changes in the tax requirements or forms we kindly invite anyone to inform us.

For any questions or suggestions, please contact us at: contact form.

 

 

 

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/International/master/UnitedArabEmirates/vat2018/uae.vatreport.2018.js
URL Development
https://github.com/BananaAccounting/International/tree/master/UnitedArabEmirates/vat2018
Short Description
It prepares a report that is similar to the UAE online VAT return , so you can easily fill it.
Country
UAE (United Arab Emirates)
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.uae.app.vatreport.2018
Title for application - displayed in "manage apps"
VAT Report for United Arab Emirates

VAT Table for United Arab Emirates

The Vat Table in Banana accounting contains the VAT codes that are setup accordingly the need for UAE, with all the cases you need in order to correctly calculate and report the VAT.

  • The VAT Code is the code you will enter in the Transactions table. The program will automatically calculate the VAT and register on the specified account. 
  • The column “Gr 1” indicate in with box of the form the amount should be totalized.  It is used by the Extension to appropriately sum amounts.
    If you add a new VAT Code you should also specify the form code.
  • VAT percentage is 5% or 0%.
    In case new percentages are introduced by the fiscal authorities, a new VAT percentage needs to be modified in the VAT table.

 

VAT due UAE

VAT code that are used for revenues. There are VAT Code for each Emirate.

  • Sales at 5%: These vat codes include all goods and services subjected at the standard rate of 5%. The FTA requires to separate the sales.
  • Tax refunds provided to tourists: this VAT code should be used only by retailers which provide the tax refunds to tourists.
  • Reverse charge: this VAT code is used to record entries related to reverse charge mechanisms.
  • Sales zero rated: all goods and services sold in the UAE which are subject to a rate of 0%.
  • Exempt sales: all goods and services sold in or outside Saudi Arabia which are exempt from the VAT.
  • Import of goods: all goods imported in the UAE and declared at customs.
  • Sales out of scope: a VAT code for sales outside the scope of the VAT agreement.
  • Sales to other GCC implementing states: GCC implementing states are not subject to the VAT agreement.

All the adjustments are registered with the same VAT code used for the transactions that needs an adjustment.

VAT recoverable UAE

  •    Purchases at 5% standard rate: VAT code for all the purchases subject to the standard rate of 5%.
  •    Purchases with reverse charge: VAT codes to recover any VAT paid as output VAT under the reverse charge mechanism.
  •    Purchases zero rated: All goods and services purchased which are subject to a 0% rate.
  •    Purchases exempt: All goods and services purchased which are exempted from the VAT.
  •    Purchases out of scope: a VAT code for purchases outside the scope of the VAT agreement.

All the adjustments are registered with the same VAT code used for the transactions that needs an adjustment.

VAT Transactions for UAE

The Transactions table contains all the transactions carried out by a business.

After having adjusted the accounts, you can start to input the transactions in the software.

In order to insert the transactions correctly, it is essential to know all the different VAT codes for the UAE.

Ttransaction Table Unite Arab Emirates

You can find detailed information about the double-entry accounting and about transactions. From the transaction is possible to generate invoices automatically.

Further down the page, you will find specific examples regarding the UAE on how to enter VAT transactions.

Due Transactions VAT Due

All the examples shown are based on the UAE template.

The “Doc” column is used to identify the transactions for the examples.

Transactions VAT Due UAE

Sales

This category includes goods and services sold at the standard rate of 5%. The FTA requires a different VAT code depending on which location the sales happens.

  • DOC 10 - This is an example for a simple transaction where the company sell panel woods to a customer in Abu Dhabi. The VAT code used is the “OSR1”, it corresponds to a standard rate sale in Abu Dhabi.

Credit note

A credit note is normally issued to correct a mistake. It is usually sent by a seller to a buyer (e.g. the invoice amount was overstated and, therefore, the buyer reduces its amount).

  • DOC 101 - This transaction represents a credit note. It is directly related to the DOC 10 transaction.

Reverse charge

The reverse charge is a mechanism which is sometimes used in VAT reporting. Importing services is one of the main causes for utilizing the reverse charge mechanism. In fact, the VAT arising from importing goods can be collected at the border. For services, it is impossible to collect the VAT at the border. Therefore, the reverse charge mechanism must be used because it is necessary to register the related VAT due.

  • DOC 30 - This is a transaction where the reverse charge mechanism must be utilized. In this case, the company bought a service and paid it with the bank account. Since the VAT on a service cannot be collected at the border, the company must use the reverse charge to account for both the VAT recoverable and due. As you can see, the journal entries cancel each other, there is not an actual impact on the company. Nevertheless, the tax authority can keep track of the VAT reporting.
  • DOC 70 – This transaction shows an example of reverse charge for goods imported. The FTA requires a different VAT code for these kinds of transactions.

Zero-rated sales

Zero-rated goods and services are taxable but at a 0% rate. This regulation exists to allow companies selling 0% supplies to deduct the recoverable VAT and, therefore, get a refund.

  • DOC 40 - This transaction involves a zero-rated sale. There are certain products which have a 0% VAT rate. In this case, the product sold is classified as zero-rated.

Exempted sales

Exempted goods and services are not subjected to VAT. When you sell exempt supplies, you do not collect the VAT. A company selling only exempt supplies cannot register for VAT.

  • DOC 60 - In this case, the product sold is exempted from the VAT. The main difference from a 0% VAT rate is that with exempted good it is not possible to obtain a VAT refund.

VAT recoverable transactions

All the examples shown are based on the UAE template.

The “Doc” column is used to identify the transactions for the examples.

Transactions VAT recoverable UAE

Purchases

This category includes goods and services purchased at the standard rate of 5%.

  • DOC 80 - This transaction represents a standard rate purchase.

Purchase Zero rated

Zero rated goods and services are taxable but at a 0% rate. This regulation exists to allow companies selling 0% supplies to deduct the recoverable VAT and, therefore, get a refund.

  • DOC 90 - This is an example of zero rated purchases. In this case, the product purchased by the company belongs to a 0% rate VAT category.

Purchases Exempt

Exempted goods and services are not subjected to VAT. When you buy exempt supplies, you cannot claim a deduction.

  • DOC 100 - This transaction represents an exempt purchase. The product purchased is exempted according to the VAT regulations.

Adjustments

All the adjustments made to a transaction must be recorded with the same VAT code used in the transaction that needs an adjustment.

If the adjustment is negative, the “-“ sign must be used when inserting the VAT code.

Transactions VAT Adjustements UAE

 

 

 

Create UAE VAT report with Banana

Create UAE VAT report with Banana

Collecting all the necessary VAT information

To fill the online form, you need to calculate the VAT and collect all the information regarding issued and received invoices, VAT imposable and VAT amounts for the different required categories.

By using a specific tool, like Banana Accounting Software (lifetime license costs approximately US$ 135, VAT excluded) the process of collecting and calculating VAT is simplified.

The following image shows that the VAT report prepared by Banana Accounting is the same as the official VAT form. Therefore, all you need to do is to copy the data from the Banana report to the online form.

Further down the page you can find directions on how small businesses can prepare for the VAT and generate the VAT report with Banana Accounting.

Documentation VAT UAE

Here you can find all the documentation needed to successfully implement the VAT reporting.

  1. FTA website.
  2. VAT E-Learing .
  3. VAT Legislation
  4. VAT user guides.
     

Installing Banana Accounting

Preparing the VAT report with our accounting software is much easier.

Banana Accounting offers a free trial that allows the recording of up to 70 transactions. To register more transactions, it is necessary to buy the license key. The price is highly competitive as our software is used in many countries and has a large number of users.

Banana Accounting 9 is a universal accounting software which focuses on small businesses. It has an intuitive interface, which is similar to Excel. You will quickly learn how to use it and it will be easy to correct mistakes.
The first step to install the software, is to download it from our website. Here, you will find all the necesary information to successfully install Banana Accounting.

VAT reporting in 3 easy steps

The list below is what you need to do to keep track of the VAT.

  1. Choose the template that is appropriate for you.
  2. Adapt the accounting plan to your needs.
  3. Enter the transactions with the appropriate VAT Code.

When all the necessary information has been entered, you can print the VAT report and all other necessary information.

Choose an accounting template

To start a new accounting for UAE follow these steps:

  1. Click on “create new…”
  2. Select “other countries”
  3. Enter “UAE” in the search box.

After selecting the template, it is possible to start a new accounting with our software.

Introduction to Banana Accounting

Here, you will find all the necessary information on how to start a double-entry accounting with an online template.

After, you will find specific instructions on how to use the Banana Accounting software with a Saudi Arabia template. All the instructions are based on a cash accounting template.

Setting the “file and accounting properties” of the template

This page will open the first time you choose a template, see file and accounting properties.

  • Complete the information of the company.
  • Complete the Address tab.
  • Under VAT number enter your Company Identification Number

Accounts table

In the Accounts table you setup the balance sheet and the profit and loss statement. The template contains a standard set of accounts that you can modify based on your needs.

The opening AED column must be filled with the opening balance of your company at the beginning of the reporting period. The Balance SAR column will show the current balance of a given account. Credit opening amounts need to be entered in negative. Positive and negative amounts should equal zero.

See the Table accounts for additional information on how to enter opening balances, add accounts or groups.

VAT codes table

This table is essential for the VAT reporting. It contains all the necessary codes to successfully calculate the VAT due and the VAT recoverable. Here, you can find detailed information about VAT codes for UAE.

Transactions table

This is the table where all the transactions must be recorded. To successfully generate a VAT report, it is important that each transaction has VAT code associated to it.

The template contains examples of typical transactions that show how to deal with different situations that could arise in VAT reporting.

Here, you can find detailed information about the specific transactions for UAE.

  • Date: the date is used by the program to attribute the transaction to a certain time frame. The date should be within the limits of the accounting period defined in the Basic data of the accounting.
  • Doc: the number of the voucher which serves as a base for the accounting transaction. When entering transactions, it is advisable to indicate a progressive number on the document, so that the accounting document can be easily traced from the transaction.
  • Invoice: it is possible to insert a number to classify the transactions. This way it is possible to automatically generate an invoice for each transaction.
  • Description: the text of the transaction. The autocomplete feature proposes the text of an already entered transaction, or one that has been entered in the previous year when the appropriate option was activated.
  • Debit A/C: the account that will be charged.
  • Credit A/C: the account that will be credited.
  • Amount AED: the amount that will be entered unto the debit- and credit account.
  • VAT code: for each transaction with VAT you need to enter one of the VAT codes from the VAT codes table.
  • Amount type: this is a code that indicates how the software considers the transaction amount:
  1. 0 (or empty cell) with VAT/sales tax, the transaction amount is VAT included
  2. 1 = without VAT/Sales tax, the transaction amount is VAT excluded
  3. 2 = VAT amount, the transaction amount is considered the VAT amount at 100%.
  4. It is not modifiable.
  • %VAT: the program automatically enters the VAT percentage associated with the VAT code you entered.
  • Non Ded %: this indicates the non-deductible %:
  1. When you enter or change the VAT Code, the program uses the Non Ded. % associated to this VAT Code in the VAT Codes table.
  2. You can manually edit the value.
  • VAT Acc AED: this is the VAT amount registered in the VAT account. It is calculated by the program according to the Transaction amount, the Amount type and the non-deductible percentage.

For more detailed information about the Transactions table visit this link.

Install the BananaApp “UAE VAT Report”

The first time you need to create a VAT report, you have to install the Banana Apps for UAEVAT report.
Follow this procedure :

  1. Click on "Apps" and select "Manage Apps".
  2. Search for UAE and click on "install".

Generating a VAT report to submit the VAT return

The FTA established when a company must submit a VAT return. Companies with annual sales below AED 150m must submit it quarterly. Otherwise, it must be submitted monthly.

Before generating the automatic VAT report that will be used to fill in the VAT return form, it is essential to check the accounting.

To check it, go to Account 1 and select "check accounting".

after checking the accounting, you are ready to generate the VAT report.

  1. Click on the "Apps" Menu
  2. Click on “UAE: VAT return 2018 (beta)”

This is the result that you will obtain, you will only need to copy the data onto the online form.

Open source collaboration

The solution has been developed with an open source concept. We welcome suggestions and feedbacks, see our web page on github/UAE.

For any questions or suggestions, please contact us at: contact form.

We are looking for collaborators for Arabic translations and creation of invoicing forms.

Other accounting functionalities

Banana Accounting offers several functionalities other than the VAT accounting. Here, you can explore all the functionalities that the software offers.

New features include in Banana Accounting 9 include:

  • Invoice management - Automatic generation of invoices,
  • Working hours spreadsheet,
  • Prints with logo,
  • and a lot more!

Check here to discover all the new features.

cathie