Minimalistic EU VAT Configuration in Dynamics AX

by Eugen Glasow

In my first 2 months of operation as an independent consultant I have got it all: an intra-community import from Sweden, export of services to Switzerland and Germany, import of services from Slovakia and the Czech Republic, domestic supplies – enough cases to test and refine my tax setup. Let me introduce my 3rd iteration of the EU VAT setup in Dynamics AX.

Before we begin with the setup let me explain some background facts and assumptions:

  • Any export of goods or services in or outside of the European Community is tax-free, but reported
  • An export of services is special: in accordance with Directive 2008/8/EC adopted by the EU Council any service rendered for customers abroad is subject to reverse charge
  • In the case of an intra-community (IC) delivery, goods and services are presented separately on the EU Sales List
  • On the contrary, goods and services delivered in the home country are reported together and should not be distinguished
  • Intra-community deliveries are reported separately from the foreign trade with the so-called 3rd countries (i.e. countries which are not the 28 members of the EU, e.g. Norway or Switzerland). IC trade appear of the EU Sales list, while 3rd country trade does not, but it is reported to the INTRASTAT instead.
  • Most of the countries apply a full rate and several reduced rates. The reduced rates are there mostly for the basic consumer services and goods. They normally do not affect enterprises, until the employees start reporting travel expenses.
  • A semi-reduced “hotel” rate stands out in Austria, but also in Switzerland and France
  • It is good to have a valid tax code, a valid “intersection” in every business case whenever it is reported on the tax declaration or not; hence the below codes TF and NR
  • From the system point of view, there is a difference between a “zero rate” and “no rate”. A tax code with a 0,00 rate still logs the tax base for reporting, as long as a record in the tax Values table exists.
  • From the fiscal standpoint, there is a difference between a “zero” an “no” rate too. For example, in the UK public transportation is taxable at 0% which is considered a tax rate of its own. In France, 0% is applied to newspapers.
  • Those 0%- and reduced-% goods and services are of domestic, consumer nature and they are rarely imported by manufacturing or professional service businesses. Only a grocery would have separate tax codes for an IC acquisition of Polish potatoes (self-assessed 10%) or French wines (self-assessed 13%).
Tax code Name Rate AT Example
vatF Domestic VAT, full 20% Sales or purchase of regular goods and services, e.g. office equipment, IT, car expenses
vatH Reduced “hotel” rate 13% This reduced rate applies to accommodation, but not restaurant bills
vatR Domestic VAT, reduced 10% Public transportation, taxi, and basic foodstuffs, including restaurant bills with non-alcoholic beverages, books and newspapers
TF Tax free
Out of scope
0% Exempt international air and sea transportation, or services delivered by “non-genuine” tax exempt suppliers such as insurances, postal services (de-at: “unechte Steuerbefreiung“). The base on purchases may still be reported to the authorities.
NR Not recoverable On a travel abroad, services consumed by the employee are taxable per se, and within the European Community the tax may even be recovered, but very few companies do so. The code is not reported to the authorities.
euF IC export
IC acquisition
0%
20%
Delivery of goods to another country of the European Community is tax free, but the value of the goods is reported to the tax authority.
On a regular import of goods from another member of the European Community the full domestic tax is levied; the tax is self-assessed with a zero effective tax load (what you pay is what you get recovered). This is achieved with the Use tax (en-us) i.e. Import VAT / purchase VAT (en-gb) setting in the VAT group.
euS IC services export
IC services import
0%
20%
Delivery of services in another country of the European Community is tax free but reported.
The buyer, however, must obey the reverse charge principle. The setup for the reverse charge and the zero tax impact is similar to the above IC goods acquisition.
3rdF Export 3rd county
Import 3rd country
0%
~20%
The export of goods is tax free in most of the countries, but the value has to be reported.
Tangible goods imported into the EU from a 3rd country is subject to an import tax, whose base is hard to calculate because it includes the portion of insurance and freight up until the border. Normally the import tax is calculated and paid by the customs broker; in the exotic import tax self-assessment mode (de-at: “Einfuhrumsatzsteuer geschuldet”) this 3rdF tax code may be used to post the tax.
3rdS Services export 3rd
Services import 3rd
0%
20%
If the place of supply of services is outside of the EC, the export is tax-free but still have to be reported (as taxable elsewhere under the reverse charge regime).
The procurement of services outside of the EC is subject to a self-assessed reverse charge.

In every business case in Dynamics AX the tax code is deducted by the system from an intersection of the customer/supplier VAT group and the product Item VAT group. Aside of the basic “F”, “S”, “TF” item VAT groups I recommend “H”, “Food” and “PubT” for travel expense reporting. The reason to separate the latter 2 groups is my reverence to companies recovering foreign taxes: tax rates for these categories vary across Europe.

Tax codes to be marked Exempt in the VAT group configuration are stroke through in the table below, and those marked as a Use tax are in italic:

Customer of supplier VAT group Item VAT group “F” (full) Item VAT group “S“ (services) Item VAT group “TF“ (tax free) Item VAT group “H” (hotel) Item VAT group “Food“ Item VAT group “PubT“ (public transp.)
Suppliers
AP-DOM vatF vatF TF vatH vatR vatR
AP-EU euF euS TF      
AP-3RD 3rdF 3rdS TF      
AP-NR NR NR NR NR NR NR
Customers
AR-DOM vatF vatF TF vatH vatR vatR
AR-EU euF euS TF      
AR-3RD 3rdF 3rdS TF      

This blog will be followed by Part 2 – selection of the VAT reporting codes for the Austrian VAT declaration.

3 responses to “Minimalistic EU VAT Configuration in Dynamics AX”

  1. Eugen Glasow says:

    Dear Zvika,
    1) First of all, tangible import from a 3rd country is not subject to a reverse charge, but an import tax (of a variable rate).
    2) The group AP-NR was introduced for an utterly formal reason: If you keep the tax parameter Check VAT groups active (which is a good practice) you formally need a valid tax code on every Customer/Item group combination. On a business trip from the UK to – let’s say – Hungary you may theoretically recover VAT, but hardly any company does it. The group AP-NR is then used in the Travel and Expense module to reflect this practice, while staying compliant to the “Check VAT groups” setting.
    3) I can reassure you that the “Use tax” is the right approach in most of the European countries. The feature you are referring to is a part of the UK localization and only available in legal entities with a primary address in the UK. After the Brexit in a year from now this is going to change anyway 🙂

  2. Zvika R says:

    Another question I have – your AP-NR group which I understand to mean “import from outside the European community” does not seem to be set up to perform reverse charge on purchases? Is that correct?
    I thought all EU countries are required now to record reverse charge on purchases from outside the community.

  3. Zvika R says:

    Your approach to reverse charge (using “use tax” configuration) is interesting.
    It seems a correct way, while at the same time Microsoft themselves recommend a different approach (by using 2 VAT codes for the +% and -% amounts):
    https://technet.microsoft.com/en-us/library/gg231022.aspx
    Did you consider the Microsoft approach? what was the reason not to use it?

Leave a Reply

Your email address will not be published. Required fields are marked *