Archive for November, 2017

SQL Server 2017 went on general release a couple of weeks ago. This brings a whole host of benefits

Microsoft SQL Server 2017 features the much-anticipated SQL Graph, which provides new graph database capabilities for representing complex many-to-many relationships. Social media platforms like Facebook and LinkedIn use graph databases extensively, and in the era of big data, use cases are emerging across many industries.

Businesses can explore these relationships to reveal valuable information – from changes in the types of structures to the query abilities being requested of you and your teams. Whether it’s identifying similarities in customers behind trends in purchasing behavior, or mapping patterns in credit card usage to determine credit limits or risk indicators of defaulting on repayments, the introduction of graph capabilities to SQL Server makes the processes more streamlined.

Perhaps the most touted feature of the new version is that it will be available to be installed on Linux; an entirely inconceivable premise 10 years ago, which just goes to show how far Microsoft have changed in their approach to supporting non-Windows platforms as standard.

The announcement earlier this year that Power BI would be included as part of SSRS in was welcome. Previously, each tool was well suited for a specific reporting purpose – SSRS was great for designing reports that require a lot of visual tailoring and widely common formats for exporting, whereas Power BI is more geared towards real-time, dashboard views that marry together disparate data sources in a straightforward way. By being able to leverage SSRS to fully utilise Power BI reports, the application suddenly becomes a lot more versatile and the potential for combining together functionality becomes a lot more recognisable. So, for example, having the ability to drill down to an SSRS report from a Power BI report would be an excellent way of providing reporting capabilities that satisfy end-user consumption in 2 different, but wildly applicable, scenarios

The updated SSMS client for SQL Server 2017 has been given refreshed icons that bring the application more in line with how Visual Studio and other Microsoft products are looking these days

Get the reach and local presence you need with Microsoft’s global datacenters – https://azure.microsoft.com/en-us/regions/ Azure is generally available in 36 regions around the world, with plans announced for 6 additional regions.

Go beyond the limits of your on-premises datacenter using the scalable, reliable infrastructure that powers the Microsoft Cloud.

Transform your business and reduce maintenance costs with an energy-efficient infrastructure spanning more than 100 highly secure facilities worldwide, linked by one of the largest networks on earth.

The engine that powers Microsoft’s cloud services, the is designed to support smart growth, high reliability, operational excellence, cost-effectiveness, environmental sustainability, and a trustworthy online experience for customers and partners worldwide.

The infrastructure is comprised of a large global portfolio of more than 100 datacenters and 1 million servers, content distribution networks, edge computing nodes, and fiber optic networks.

The portfolio is built and managed by a team of subject matter experts working 24x7x365 to support services for more than 1 billion customers and 20 million businesses in over 90 countries worldwide

Those are 2014 figures and the Microsoft cloud has expanded greatly since then for example the acquisition of Linked in and the launch of Dynamics 365.

To help you comply with national, regional, and industry-specific requirements governing the collection and use of individuals’ data, Microsoft offers the most comprehensive set of compliance offerings of any cloud service provider. Microsoft business cloud services operate with a cloud control framework, which aligns controls with multiple regulatory standards (https://www.microsoft.com/en-us/trustcenter/guidance/risk-assessment#Audit-reports)

To the many of you who have asked for registration and not had a response, please accept our apologies. The overwhelming success of the site means we get typically 50 new registrants a day and it has been administratively difficult to keep up so with approval and review or comments from over 10000 subscribers. So much against the trend we have dropped the social media links and options to comment.

This will give us more time to add content and will also help with performance o the site.

The UAE Ministry of Finance announced the Executive Regulation for the Federal Decree-Law No. (8) of 2017 on Value Added Tax at a Cabinet meeting on 7 November 2017, headed by His Highness Sheikh Mohammed bin Rashid Al Maktoum, Vice President and Prime Minister of the UAE, Ruler of Dubai.

The Regulation defines VAT as the 5% tax imposed on the import and supply of goods and services at each stage of production and distribution, including:
- what is a deemed supply, with the exception of specific supplies subject to the zero rate
– what is exempted as specified in the Decree-Law.

Before reviewing the individual titles of the registration this is summary of the salient points:

VAT Registrations
It is important to note that the draft VAT executive regulations state that businesses are required to register in accordance with the timelines previously announced by the Federal Tax Authority. As a consequence, if taxpayers have not registered within these timelines, it may potentially result in late registration penalties which are AED 20,000.

The UAE’s Federal Tax Authority is urging companies subject to the value-added tax to register before December 4 to avoid paying the tax from their own pockets.

The Federal Tax Authority (FTA) requires by law 20 working days to access and process their applications, said Khalid Al Bustani at a media briefing in Dubai. Companies submitting applications after that date are not guaranteed to get their formalities completed, will not be able to charge 5 per cent VAT to their customers and may have to pay the tax from their pocket until their registrations are finished, according to FTA officials at the briefing.

– Businesses providing taxable supplies may apply for a voluntary VAT registration if their sales exceed AED 187,500 per annum
- Businesses providing exclusively zero-rated supplies may apply for an exemption from the obligation to VAT register
- The mandatory VAT registration threshold is AED 375,000 sales per annum
- A registration application must be submitted within 30 days of being obliged to register
- Tax Groups may be formed for multiple, related parties businesses to register under one number – one taxable party, the ‘representatives’, takes on the responsibility to prepare and submit the consolidated return
- De-registrations are permitted on the cessation of the taxable supplies, or on the tax authorities decision

Tax point
VAT becomes due on the earlier of:
-The invoice date
- The delivery of the goods or performance of the service
- The payment date

Place of supply rules
- For real estate, a supply is deemed to take place in UAE where the services is directly connected with UAE real estate
– Domestic transport services are deemed to be supplied from the place where the transport commences
- For goods transported to another GCC State which has implemented VAT (‘implementing state), the place of supply is the destination provided adequate proof of transportation can be obtained

Zero rating
The following goods and services shall be zero-rated for VAT purposes (note: all foods will be standard rated):
- Goods physically exported to other VAT registered businesses outside of the UAE or other implementing state provided commercial evidence of the transport is retained by the vendor
- when supplied to a customer that does not have a establishment in UAE and is outside of the country at the time of supply. The exception is real estate in UAE.
- Supply of international transportation services for passengers and goods
- The supply or import of precious metals
- New residential property supplies
- Education services if supplied by an accredited government body
- Healthcare services provided by a body linked to the state
- Approved pharmaceuticals

Exempt supplies

The following services will be exempted from VAT:
- Financial services related to dealing in money (e.g. FX, debt securities, loans, bank accounts, derivatives or similar, issuing shares and life insurance)
- Other financial services attracting a fee or commission are liable to VAT
- Residential buildings with a lease longer than 6 months
- Bare land
- Local passenger transport

VAT Free Designated Zones

Special geographical areas within the UAE, but outside of the UAE VAT regime. These are created upon a decision by the Cabinet. They have security measures and customs controls to monitor the movement of goods. The transfer of goods or provision of services within the Zones will not be subject to VAT – similar to the bonded warehouse concept.
Import VAT becomes payable when any goods leave the Zone.

Non-recoverable VAT

The following VAT is not recoverable against VAT on taxable supplies:
- Entertainment for non-employees
- Personal use vehicles and other goods for employees
- Employee-use goods not directly associated with the provision of taxable supplies

VAT invoices
VAT invoices must include the following details:
- Name and address of supplier
- VAT Number
- Unique VAT invoice number
- Date of invoice, and date of supply if different
- Description of the goods/services provided
- Unit prices, quantity or volumes of the supplies
- Any discount offered
- VAT calculation and gross amount due in AED (any rate of exchange used)

Simplified invoices may be issued to non-tax payers or when the consideration is below AED 10,000.

Electronic invoices may be issued if the vendor has secure storage facilities, and the authenticity of the invoice can be guaranteed

VAT reporting
The standard VAT reporting period is 3 months
VAT returns must be received by the 28th of the month following the reporting period.

Transitional rules
- Goods or services provided before the implementation of VAT will be treated as having been provided on the implementation date
- A payment for the services prior to the implementation date will be disregarded for determining the time of supply after the implementation date
- The value prior to VAT implementation of any goods or services will be treated as exclusive of VAT

The Value Added Tax (VAT) to be launched on January 1 in UAE will bring many changes in the price structure of the goods and services in the country. While some basic things like school fees will be exempt from tax, many other essential items such as: water, food, and jewelry may be included in the VAT.

The VAT in UAE will be levied at a fixed rate of 5 per cent on all applicable items.

The tax will also be levied from the tourists visiting the country, however, the tax paid by tourists in the UAE will be refunded back to them at the airport.

Goods/services we understand to be exempt from VAT
The following items/services will be VAT exempt:
◾Medical fees
◾Air travel
◾Medicines
◾Basic and preventive surgery
◾Exam fees
◾Local transport
◾Residential rents
◾Public school books

The VAT will also be applicable to the free zone companies making supplies outside the zone. This might increase pre-financing cost for such companies.

Draft Regulation Titles:

The first title of the Regulation includes the definitions of terms used.

The second title deals with supply, which includes:
- articles regulating the supply of goods and services,
- supplies that consist of more than one component
- the exceptions related to deemed supplies.

The third title of the document tackles the subject of registration, such as:
– mandatory and voluntary registration,
– related parties,
– conditions to be met to register tax groups
– appointing a representative member,
– deregistration,
– exception from registration,
– registration on law coming into effect
– obligations to be met before deregistration.

The fourth title looks into rules relating to supply, including:
– articles on the date of supply,
– place of supply for goods,
– place of supply of services for real estate,
– transport services,
– telecommunications and electronic services,
– intra-GCC supplies,
– the market value,
– prices to be inclusive of: tax, discounts, subsidies and vouchers.

The fifth title discusses profit margins, and also explains how to calculate VAT based on profit margins,

The seventh title clarifies provisions relating to products and services exempt from value added tax, namely:
- the supply of certain financial services as specified in the Executive Regulation,
- the supply of residential (non-zero-rated) buildings either by sale orby lease,
- the supply of bare land,
- the supply of local passenger transport.

The eighth title addresses accounting for tax on:
- specific supplies and includes articles relating to supplies with more than one component,
– general provisions in relation to import of goods
– applying a reverse charge on goods and services,
– moving goods to implementing states
– imports by non-registered persons.

The fifteenth title 15 goes into recovery of excess tax in article (65).

The sixteenth title 16 tackles recovery in other cases and includes:
- article (66) on new housing for nationals,
- article (67) on business visitors,
- article (68) on tourists
- article (69) on foreign governments.

The draft text of the Executive Regulation for Federal Decree-Law No. (8) of 2017 on Value Added Tax, is to be published on the UAE Ministry of Finance’s website www.mof.gov.ae – https://www.mof.gov.ae/en/budget/pages/vatquestions.aspx
and the Federal Tax Authority’s website www.tax.gov.ae​​

https://www.tax.gov.ae/pdf/VAT-Decree-Law-No-8-of-2017.pdf

Some comments:
The Executive Regulation is clear that prices must be expressed inclusive of VAT unless something is being supplied for export or where the customer is registered for VAT i.e. for B2C retail sales

This will prevent preventing businesses from misleading consumers by adding 5 per cent to the price at the till, but it s gives rise to complexity where businesses are supplying to a combination of consumers, non-registered businesses and registered businesses, and where they make both domestic and international supplies.

There is reference to “Designated Zones” being treated as outside the UAE in the Decree-Law, but the Executive Regulation makes it clear these must be “a specific fenced geographic area [which] has security measures and customs controls in place to monitor entry and exit of individuals and movements of goods to and from the area”. It simply wasn’t permissible under the GCC Framework Agreement, or the design of VAT generally, to treat the Dubai International Financial Centre differently from anywhere else in the UAE.

Banks, will need to work through Article (42) of the Executive Regulation to determine which of their supplies are exempt and which are standard rated. For example, supplies cannot be exempt if they are “conducted in return for an explicit fee, discount, commission, and rebate or similar”.
Furthermore, in relation to Islamic finance products, the drafting is currently unclear on whether each separate part of a product will need to be certified as Sharia compliant, or whether only a product generally has to have been certified.

Challenges remain for certain sectors. Healthcare services, which are generally zero rated, are defined as a supply “that is generally accepted in the medical professions as being necessary for the treatment of the recipient of the supply including preventive treatment”. That’s not just a question for a tax lawyer. That’s a question for a doctor.

The UAE Executive Regulation now takes a more considered approach than the simpler but ultimately unsatisfactory approach taken in the Saudi legislation with regard to existing contracts. Under the Executive Regulation, when a contract is silent on VAT, the consideration will be treated as exclusive of VAT, and the recipient will be required to pay VAT in addition if, broadly speaking,
(i) the recipient of the supply is registered for VAT;
(ii) the recipient of the supply has the right to recover the VAT charged in full, or in part.

It is still unclear regarding VAT on supplies to government entities – for example, whether an entity is in fact a government entity, whether a government entity is required to be registered, and whether it has the right to recover VAT?

Synergy is a well established, solution provider across the Middle East region.
Synergy has a strong presence in several key verticals; Manufacturing, Construction, Hospitality Insurance, Financial Services, Government. Media, Oil and Gas, Distribution.
Synergy is particularly well known as a Gold Partner of both Infor Sunsystems, and Microsoft Dynamics Ax and for its implementation expertise and exceptional support. It is based centrally in Dubai in the Karama district since it was registered in 1991, and occupies a 7,000 sq ft office with around 80 full time employees.