UAE VAT return for Odoo
inteslar - Commited to innovation, www.inteslar.com
This APP allows you to file UAE taxes according to the TRA rules and regulations in the UAE, it adds a lot of new functionalities related to filing taxes with the government in a user friendly way, the app will pass automatic journal entries, register payment with the bank and also allows adjustments.
Complete tax filing without any manual intervention.
New tax file form built from scratch.
Form looks exactly like TRA form 201
Configure input, output taxes
Tax refund for credit / debit notes.
Work with Reverse charges for both goods and services.
import shipments with reverse charges
Added fields on invoice and vendor bills.
Tax adjustments form
Taxes for zero rated and exempted goods
Configure taxes as per below:
TRN field added on customer and supplier masters:
The newly designed customer invoice includes all the fields necessary to file VAT.
The form will automatically filter taxes according to the sale location, select sale location first then select taxes from the drop down list as per below. The sale location filed is important for tax filing as we will see later
The vendor bill was redesigned to be aligned with the TRA requirements:
Applicable taxes will automatically show along with the VAT tax accounts
Using the vat return menu item, you can file a new tax return
Clicking on the Vat return will open this new form that shows all the VAT filings that were done during various periods, it also shows the status of these filings (New, Validated, Paid, Rollover)
The new VAT file form:
Click on compute tax to get all amounts:
Click on any of the tax lines to see corresponding records:
Click on the Reverse Charge tab to see all reverse charges:
If you need to adjust any of the taxes configured, you can use our tax adjustment form that was designed to adjust any tax (sales or purchase):
When the form is validated, journal entries are automatically posted for you under Account details tab:
After validation, you can go ahead and pay the government the net amount::
If the net amount is negative, the system will ask you if you would like to receive a refund from the government or whether you would like to roll over the credit to the next filing period. :
Filling Data on the TRA website:
Our module was designed to be user friendly and allow the user to easily file data on the tax authority website, the original TRA form 201 looks like this:
On the form click on print UAE Vat return:
The report will look exactly like the TRA form (201):
Copy and paste the amounts from our report directly to the TRA form, it’s that easy! Another report looks like this:
Click on the Export report to get the excel sheet format:
To get taxes balance, fill in the details:
Click on any record to drill down to the journal entries level:
Another detailed report that allows you to compare data across multiple periods:
Pivot table view:
Under VAT in UAE, on certain notified supplies, the recipient or the buyer of goods or services is responsible to pay the tax to the Government, which is known as the reverse charge mechanism. In UAE VAT, the following supplies are under reverse charge:
Imports of concerned goods or concerned services for business purposes
Taxable supply of any crude or refined oil, unprocessed or processed natural gas, or any hydrocarbons for resale or to produce and distribute any form of energy by registered supplier to registered buyer in the State of UAE
Supply of goods or services by a supplier who does not have a place of residence in the state to a taxable person who has a place of residence in the State of UAE
As shown in the above image, the recipient needs to declare only the net value the value of reverse charge supplies and applicable VAT amount. The value and the output VAT of the following type of reverse charge supplies should be included in the box no 3 ‘supplies subject to the reverse charge provisions’:
Services received from foreign suppliers which are subject to the standard rate of VAT
Services received from foreign suppliers which are subject to the zero rate of VAT
Goods received which are subject to the reverse charge provisions and have not been declared to UAE customs (For example, import through an import declaration)
Local supplies subject to the reverse charge provisions (For example, specific supplies within the oil and gas industry)
Please note, imports of goods into the UAE which are subject to the reverse charge provisions have been declared to UAE customs and therefore should be reported in Box 6 of the VAT Form 201:
Reverse Charge example:
If you have used services from a supplier outside UAE and these services were subject to reverse charges, open a new vendor bill and fill in the details as follows:
The reverse charge tick box must be ticked, do not select any taxes from the drop down list. Click on the reverse charge click button that was enabled, this will pop up new form :
Fill in the details above and the reverse charge will be automatically calculated. :
Reverse charge entry:
Now validate the form journal Entry automatically created
Let us explore the case where you might have imported some goods from outside UAE that fall under reverse charge, create a new vendor bill and fill in the form as per below:
Validate the bill and make the payment:
When your goods arrive to the port / airport, click on Bill of Entry to create a new bill of entry:
fill in the details of the bill of entry as follows:
Click on compute reverse charges to automatically calculate all applicable RC taxes:
Note: the system is flexible enough to allow a declared amount that is different from the total amount mentioned on the bill.
Click on the post journal entries button to automatically post entries for both customs and reverse charges.
Click on the account details to see the journal entries that were created for you:
Tax journal entry:
Customs journal entry:
Click on register payment to pay the customs charges:
Payment journal entries:
On the vendor bill, you can now see a new tab showing your new bill of entry for this import shipment:
Go back to the vendor bill and click Bill of Entry to see the same record:
You can see the effects of reverse charges during tax filing:
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
- The author can leave a single reply to each comment.
- This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
- If you want to start a discussion with the author or have a question related to your purchase, please use the support page.