Difference between revisions of "Test3"
(Created page with "test3") |
|||
Line 1: | Line 1: | ||
=Introduction= | |||
The Luxembourg Tax Authority ('''Administration des contributions directes''' ([http://www.impotsdirects.public.lu/fr/echanges_electroniques.html ACD])) published on 6 February 2017 the [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 Circular]. This Circular describes the format and procedures of the Common Reporting Standard (CRS) that Luxembourg Reporting Financial Institutions (RFI) will have to follow according to the CRS Luxembourg law, 24 December 2015. | |||
=Manual filing through e-file v2= | |||
==Environment== | |||
Step 1: Select your environment | |||
Production environment : '''https://www.e-file.lu/e-file/''' | |||
Homologation environment (Test) : '''https://homologation.e-file.lu/e-file/''' | |||
==Login== | |||
Step 1: Enter your e-file login credentials (user name and password) and click the Access button | |||
[[File:Identification.jpg]] | |||
'''IMPORTANT:''' If you do not have an e-file user account or if you do not remember your password, you might contact your '''e-file administrator''' of your company. | |||
==Access CRS form== | |||
Step 1: Click on the Report Generation icon | |||
[[File:Fatca ReportGen.jpg | 500 px]] | |||
Step 2: Select Formulaire CRS | |||
[[File:Formulaire CRS.jpg | 500 px]] | |||
Step 3: Select CRS Reporting | |||
[[File:Select CRS.jpg | 300 px]] | |||
'''Result:''' the CRS form opens | |||
[[File:CRS_01.png | border | 1000 px]] | |||
==Complete CRS form== | |||
===Contact tab=== | |||
====AEOI reference==== | |||
[[File:CRS AEOI REF.jpg]] | |||
-This field has to be completed with a unique identifier. | |||
-The ACD recommends to use a "timestamp", a digital counter or a "GUID" (Globally Unique Identifier). | |||
-Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc. | |||
-The ACD asks not to include confidential data in the identifying elements. | |||
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 21-22]. | |||
====Information on depositor==== | |||
[[File:CRS Dep matricule.jpg]] | |||
<u>'''Depositor name'''</u> (pre-filled) <br /> The Depositor is an entity (legal or natural person) that is in charge of filing the CRS reporting to the ACD (e.g. Service provider). The depositor and the declarer may be the same entity. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf, ECHA - n° 4 of 6 February 2017, page 10]. | |||
<u>'''Personal Identification Number'''</u> (pre-filled) <br /> The Depositor needs a Personal Identification Number (Luxembourgish '''Matricule''' Number also known as CCSS code) to be able to file the report. | |||
If the Depositor does not have a Luxembourgish '''Matricule''' Number, he has to contact the '''Bureau de la retenue d'impôt sur les intérêts''' to obtain one (Form 914F). | |||
-by mail: [mailto:aeoi@co.etat.lu aeoi@co.etat.lu] | |||
-by phone: [http://www.impotsdirects.public.lu/fr/profil/organigramme/liste_telephone_service.html#srii Phone book_Bureau de la retenue d'impôt sur les intérêts] | |||
'''IMPORTANT''': all '''pre-filled''' data have to be communicated to Fundsquare in order to be integrated in Fundsquare's database and to be available in the CRS form | |||
=> Consult our [https://www.e-file.lu/wiki/index.php/CRS_Onboarding CRS Onboarding process] for more detailed information. | |||
=> Send mail to: [mailto:OnboardingFatcaCRS@fundsquare.net OnboardingFatcaCRS@fundsquare.net] | |||
====Information on declarer==== | |||
The declarer may be the RFI or an entity, e.g. a management company, '''managing the reporting from a business point of view'''. | |||
[[File:CRS Declarer Z.jpg]] | |||
<u>'''Declarer name'''</u> <br /> The ACD needs contact details of '''a person who would be able to answer business questions regarding the report'''. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 10] | |||
<u>'''Declarer identification number'''</u> <br /> Social Security Identification Number (Matricule, code CCSS) of the declarer. | |||
====Reporting person==== | |||
The Reporting Person is the Reporting Financial Institution (RFI) that is subject to the CRS Reporting. | |||
[[File:CRS RFI.jpg]] | |||
<u>'''Name of the Reporting Financial Institution'''</u> <br /> Select the entity in the drop-down list for which the reporting has to be done. | |||
<u>'''Name'''</u> <br /> Name of the RFI ('''pre-filled''' once the RFI has been selected) | |||
<u>'''Entity Identification number'''</u> <br /> The '''Identification number''' is the Luxembourgish '''Matricule''' number of the RFI ('''pre-filled''' once the RFI has been selected) | |||
<u>'''Entity Identification number extension'''</u> <br /> The extension of the Luxembourgish '''Matricule''' number ('''pre-filled''' once the RFI has been selected). Example of an UCI that reports on UCI level: '''M'''00000000 (The Reporting FI Identifier will be 12345678912'''M'''00000000) | |||
If a '''sub-entity''' wants to submit a CRS reporting to the ACD and does not have a personnel number, it puts the parent entity's number in the '''Entity Identification number''' field and an additional identifier in the '''Entity Identification number extension''' field. Example: a sub-fund that wants to report directly, can enter the umbrella number (= tax identification number available on the subscription-tax returns) in the '''Entity Identification number''' field and the sub-fund number (CSSF code of the sub-fund) in the '''Entity Identification number extension''' field. Exemple: '''F'''00000002 (The Reporting FI Identifier will be 12345678912'''F'''00000002) | |||
IMPORTANT: instructions published on the [https://impotsdirects.public.lu/fr/echanges_electroniques/CRS_NCD.html ACD website] should be followed in the event that the Luxembourg Financial Institution has no Luxembourgish matricule. | |||
<u>'''Reporting FI Identifier'''</u> <br /> It is the concatenation of the '''Identification Number''' and '''Identification Number Extension''' ('''pre-filled''' once the RFI has been selected). | |||
'''IMPORTANT''': all '''pre-filled''' data have to be communicated to Fundsquare in order to be integrated in Fundsquare's database and to be available in the CRS form | |||
=> Consult our [https://www.e-file.lu/wiki/index.php/CRS_Onboarding CRS Onboarding process] for more detailed information. | |||
=> Send mail to: [mailto:OnboardingFatcaCRS@fundsquare.net OnboardingFatcaCRS@fundsquare.net] | |||
===Header tab=== | |||
Information in the header tab identifies the Competent Authority that is sending the message, as well as the Competent Authority receiving the message. It specifies when the message was created and the nature of the report. | |||
[[File:Header tab.jpg]] | |||
<u>'''Transmitting country'''</u> <br /> Must always be LU. This data element identifies the jurisdiction of the Competent Authority transmitting the message, which is the Competent Authority that has received the initial CRS message. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 28]. | |||
<u>'''Receiving country'''</u> <br /> Must always always be LU. This data element identifies the jurisdiction of the Competent Authority receiving the message, which is the Competent Authority that has sent the initial CRS message. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 28]. | |||
<u>'''Warning'''</u> <br /> This optional data element is a free text field allowing input of specific cautionary instructions about use of the CRS Status Message. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 30]. | |||
<u>'''Contact'''</u> <br /> This optional data element is a free text field allowing input of specific contact information for the sender of the message (i.e. the Competent Authority sending the CRS Status Message). <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 30]. | |||
<u>'''Message reference ID'''</u> <br /> This field has to be completed with a unique identifier. <br /> The ACD recommends to use a "timestamp", a digital counter or a "GUID" (Globally Unique Identifier). <br /> Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc. <br /> The ACD asks not to include confidential data in the identifying elements. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 21-22 and page 28]. | |||
<u>'''Declaration type'''</u> <br /> CRS701: The message contains new information <br /> CRS702: The message contains corrections / cancellations for data previously reported <br /> CRS703: The message informs that there are no data to declare by Luxembourg Reporting Financial Institution for the fiscal year indicated. | |||
<u>'''Reporting period'''</u> <br /> It is the tax year to which the message relates. For example, if reporting information for the accounts or payments made in clendar year 2016, you have to select 2016. | |||
===Reporting group tab=== | |||
====Reporting FI==== | |||
The Reporting Financial Institution (RFI) is the entity that is subject to the CRS Reporting. | |||
[[File:CRS Reporting group.jpg]] | |||
<u>'''Residence country'''</u> <br /> The country or countries of tax residence of the Luxembourg RFI. The "Residence country" element corresponds to the country or countries of tax residence of the Luxembourg RFI. There must be at least one element which has the value "LU". In addition, the value of the "Residence country" element must be equal to the value of the "TransmittingCountry" element, otherwise the file is rejected with error code 60013. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 34]. | |||
<u>'''IN'''</u> <br /> The tax identification number(s) of the RFI. At least the Luxembourg Personal Identification Number (Matricule) of the Luxembourg RFI must be present. | |||
<u>'''Organization name'''</u> <br /> The name of the RFI | |||
<u>'''Address'''</u> <br /> The address of the RFI | |||
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 31]. | |||
<u>'''Document type'''</u> <br /> This element specifies the type of data to be transmitted <br /> OECD0: Resend data <br /> OECD1: New data <br /> OECD2: Corrected data <br /> OECD3: Deletion of data <br /> '''Important:'''The file is rejected in case of Document type = OECD3 and if all account reports related to this Reporting FI have not previously been deleted. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 32]. | |||
<u>'''Document reference ID'''</u> <br /> | |||
[[#AEOI reference|Cf. chapter 2.4.1.1 AEOI reference]] | |||
<u>'''Document reference ID to correct'''</u> <br /> This element is a reference to the unique identifier of the data that is to be corrected / deleted and its value must be known by the ACD because it had been previously transmitted via a new data message. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 33]. | |||
====Account Report==== | |||
The Account Report can only be omitted if the Reporting FI is being corrected (OECD2) / deleted (OECD3) or, in the case of domestic reporting, if there is nil reporting (CRS703). If the Reporting FI indicates new data or resent data, then the Account Report must be provided. | |||
<u>'''Document type'''</u> <br /> OECD0: Resent data. This value is not authorized in the context of account reports <br />OECD1: New data <br />OECD2: Corrected data <br />OECD3: Deletion of data | |||
<u>'''Document Reference Id'''</u> <br /> [[#AEOI reference|Cf. chapter 2.4.1.1 AEOI reference]] <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 39]. | |||
<u>'''Document Reference ID to correct'''</u> <br /> This ID references the Document Reference ID of the element to be corrected (OECD2) or deleted (OECD3). It must always refer to the latest reference of this Account Report (Document Reference ID) that was sent. <br /> Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 40]. | |||
Organisation | |||
<u>'''Account Number type'''</u> <br /> | |||
OECD601: IBAN - International Bank Account Number <br />OECD602: OBAN - Other Bank Account number <br />OECD603: ISIN - International Securities Identification Number <br />OECD604: OSIN _ Other Securities Identification Number <br />OECD605: Other | |||
<u>'''Account holder type'''</u> <br /> If the account holder is an organisation, select the account holder type: <br />CRS101 = Passive Non-Financial Entity with - one or more controlling person that is a Reportable Person <br />CRS102 = CRS Reportable Person <br />CRS103 = Passive Non-Financial Entiy that is a CRS Reportable Person | |||
====Type of message==== | |||
<u>'''New data message'''</u> <br /> A new data message is a message declaring data that is not yet known by the ACD. It is characterized by the value "CRS701" and by the value "OECD1" | |||
[[File:New Data Message.PNG]] | |||
<u>'''Correction message'''</u> <br /> A correction message is a message that corrects or cancels data already known by the ACD. It is characterized by the value "CRS702" and the value "OECD2" or "OECD3". | |||
[[File:Correction Message.PNG]] | |||
===Zero Reporting=== | |||
A "ZeroReporting" message is a message stating that the Luxembourg Reporting Financial Institution has no data to report for the relevant tax year. | |||
Unlike FATCA, the ACD has decided that filing a "zero reporting" is not mandatory. | |||
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 17] | |||
Step 1: Select Zero Report | |||
[[File:CRS zero report.jpg]] | |||
Step 2: Complete the Contact tab | |||
[[File:CRS 01.jpg]] | |||
Cf. Chapter 2.4.1 Contact tab | |||
Step 3: Complete the Header tab | |||
[[File:CRS 02.jpg]] | |||
The declaration type '''CRS703: The message advises thers is no data to report''' is selected by default. | |||
Step 4: Complete the Reporting tab | |||
[[File:CRS 03.jpg]] | |||
'''Important''': | |||
-The RFI should not declare any Account Report in a Zero Report. | |||
-The Zero Reporting has to be filed to the ACD. It will not be communicated to a particular JSD ("Juridiction soumise à déclaration"). | |||
-The Zero Reporting will be rejected if the Luxembourg Financial Institution has already transmitted data via a new data message but this data has not been canceled via a correction message. | |||
All declared data must be canceled before sending a Zero Reporting. Otherwise, the error "80009" is returned. | |||
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf ECHA - n° 4 of 6 February 2017, page 17] | |||
== Export - import files - save work in progress == | |||
[[File:Export.jpg]] | |||
1. Click this button to export the final report in XML format. The file will be saved on your hard drive and is available for sending to the Regulator. This button will only be available if the green tick [[File:GreenIcon.png]] appears in every section of the completed form. | |||
2. This button allows you to upload an existing XML report from your network or hard drive into the report generator. | |||
3. Work in progress on a report has to be saved with this button. The exported .xml file will be called DRAFT_filename.xml and cannot be uploaded for filing. It can be imported onto the tool for later use. Only final reports will carry the correct naming convention for submission to the Regulator. | |||
4.If green ticks [[File:GreenIcon.png]] appear in every section of the completed form, the Transmission button will become available. | |||
== File transmission == | |||
=== Setup of the Transmission Module e-file v2 === | |||
Step 1. Complete the form [[File:GreenIcon.png]]. | |||
Result: all ticks become green | |||
[[File:CRS transmission.jpg]] | |||
Step 2: Click the [[File:Transmission.png | border]] button. | |||
'''Result:''' the EfileCrypto.jnlp file is generated. | |||
'''IMPORTANT:''' this file has to be '''downloaded''' (if you use the application for the first time) locally on your computer and must be '''opened''' to launch the '''Transmission Module'''. | |||
'''Note''': the '''Transmission Module''' is a Java application. For security reasons, this module aims at encrypting documents before they are sent to authorithies. It is also used to decrypt documents and feedbacks. | |||
See [[Transmission_Module#System_requirements|prerequisites]] for the installation of the Transmission Module e-file v2. | |||
Step 3. Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg]] | |||
'''Result:''' the window below opens | |||
[[File:JavaEfileWindow.png | border]] | |||
Step 4. Click the [[File:RunButton.png | border]] button | |||
[[File:JavaEfileWindow.png | border]] | |||
'''Result:''' the Transmission Module is launched | |||
[[File:2tmm.png | 500px]] | |||
'''Important:''' It is possible that the pop-up blocker does not allow .jnlp files to be downloaded. Please ask your IT deparment to allow pop-ups from '''https://www.e-file.lu/''' . | |||
Step 5: The Transmission Module has to be configured when it is used for the first time (or after each Java update). | |||
The path to the keystore has to be selected with the [[File:BrowseButton.png | border]] button and the key (locally or on a server) will have to be imported with the [[File:ImportButton.png |border]] button : <br/> | |||
[[File:2tmm.png | 500px]] | |||
Once the key has been imported, the access to the keystore is memorized by the application. | |||
In order to be more user friendly and to speed up the sending process, the Transmission Module will then run as a back ground process on your desktop. | |||
If you need to end the process, right click on the icon in the taskbar and select “Close Transmission Module” : | |||
[[File:2Tmet.png |250 px]] | |||
Step 6. Return to the CRS Form (Report Generator) screen | |||
- Click the [[File:Transmission.png | border]] button | |||
- Enter a "title of file sent" | |||
- Enter the keystore password | |||
'''Result''': as the configuration of the Transmission Module is finished, the General Tab of the Transmission Module will be displayed directly. | |||
[[File:Icon22.png | 500px]] | |||
'''Note''': | |||
-the file name is automatically generated and compliant to the ACD file naming convention. | |||
-the [[File:SendButton.png | border]] button is now available and the report can be sent. A pop-up window will confirm the transmission. | |||
== Transmission follow up == | |||
PLEASE CONSULT OUR WIKIPAGE [[Transmission follow-up|'''TRANSMISSION FOLLOW-UP''']] | |||
= Automatic filing through the Sending Service = | |||
The Sending Service is Fundsquare's solution for automatically sending reports and documents to the authorities. | |||
With a suitable network mapping, users can then simply copy the file to be sent in the appropriate directory. | |||
The file is then automatically encrypted and sent. | |||
CRS.xml files have to be dropped into the '''CRS''' subfolder: | |||
[[File:CRS SD.jpg|border]] | |||
*Should you need further information on the Sending Service, please click the links below: | |||
[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Installation_SD_EN.pdf Sending Service Installation Procedure] | |||
[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Maj_SD_EN.pdf Sending Service Update Procedure] | |||
[[Sending_Service|Wiki-Sending Service]] | |||
[[Category : FAQ e-file]] | |||
== CRS file naming convention == | |||
The following naming convention has to be applied for the files: | |||
XML file : | |||
CRS<SEP>DateHeure<SEP>MessageTypeIndic<SEP>AnnéeFiscale<SEP>Canal<SEP>MatriculeDuDéposant<SEP>MatriculeDuRFI<SEP>Environnement.xml | |||
{|border="1" cellspacing="2" cellpadding="10" | |||
|- | |||
! Code | |||
! Definition | |||
! Structure | |||
! Values | |||
|- | |||
| <SEP> | |||
| Separator of the different variables of the file. The separator chosen is the underscore: _. | |||
| Char(1) | |||
| underscore: _. | |||
|- | |||
| DateHeure | |||
| Creation date and time of the XML file | |||
| Number(14) | |||
| YYYYMMDDhhmmss | |||
|- | |||
| MessageTypeIndic | |||
| CRS701: The message contains new information | |||
CRS702: The message contains corrections for previously sent information | |||
CRS703: The message advises there is no data to report | |||
| Char(3)Number(3) | |||
| CRS701 | |||
CRS702 | |||
CRS703 | |||
|- | |||
| AnnéeFiscale | |||
| Fiscal year | |||
| Number(4) | |||
| YYYY | |||
|- | |||
| Canal | |||
| Communication channel | |||
| Char(1) | |||
| B = Bourse | |||
|- | |||
| MatriculeDuDéposant | |||
| Social Security Identification Number (Matricule, code CCSS) | |||
| Number(11) | |||
| 0-9 | |||
|- | |||
| MatriculeDuRFI | |||
| Concatenation of <ReportingPerson> / <IdentificationNumber> and <ReportingPerson> / <IdentificationNumberExtension> | |||
| Number(11), char(1), number(8) | |||
| 12345678901M00000000 | |||
|- | |||
| Environnement | |||
| Environment type | |||
| Char(1) | |||
| P = Production | |||
T = Test | |||
Example: | |||
CRS_20170615114523_CRS701_2016_B_19751234567_01234567890M00000000_P.xml | |||
VAL = Validated and imported by ACD | |||
ERR = File rejected | |||
|} | |||
== Report transmission == | |||
== File processing status generated by the Sending Service == | |||
During and at the end of the sending, the Sending Service generates various files in the subfolder that | |||
has been used for the sending. Three type of files are generated: <br/> | |||
*'''.trt''' file : indicates the start of the transmission | |||
In order to be able to send the original file, the Sending Service transforms the latter into a .trt file and | |||
adds a timestamp. E.g. «OriginalName.xml» is transformed into OriginalName.xml.timestamp.trt: | |||
.xml becomes | |||
.trt | |||
*'''.acq''' file : the transmission has been successfully completed | |||
*'''.err''' file : indicates that an error has occurred during the sending | |||
The error file contains technical messages indicating the root cause of the error, e.g. file name errors. | |||
== File transmission follow-up == | |||
=== Transmission status === | |||
[[Category: FAQ e-file]] |
Revision as of 07:21, 20 December 2019
Introduction
The Luxembourg Tax Authority (Administration des contributions directes (ACD)) published on 6 February 2017 the ECHA - n° 4 Circular. This Circular describes the format and procedures of the Common Reporting Standard (CRS) that Luxembourg Reporting Financial Institutions (RFI) will have to follow according to the CRS Luxembourg law, 24 December 2015.
Manual filing through e-file v2
Environment
Step 1: Select your environment
Production environment : https://www.e-file.lu/e-file/
Homologation environment (Test) : https://homologation.e-file.lu/e-file/
Login
Step 1: Enter your e-file login credentials (user name and password) and click the Access button
IMPORTANT: If you do not have an e-file user account or if you do not remember your password, you might contact your e-file administrator of your company.
Access CRS form
Step 1: Click on the Report Generation icon
Step 2: Select Formulaire CRS
Step 3: Select CRS Reporting
Result: the CRS form opens
Complete CRS form
Contact tab
AEOI reference
-This field has to be completed with a unique identifier.
-The ACD recommends to use a "timestamp", a digital counter or a "GUID" (Globally Unique Identifier).
-Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc.
-The ACD asks not to include confidential data in the identifying elements.
Cf. ECHA - n° 4 of 6 February 2017, page 21-22.
Information on depositor
Depositor name (pre-filled)
The Depositor is an entity (legal or natural person) that is in charge of filing the CRS reporting to the ACD (e.g. Service provider). The depositor and the declarer may be the same entity.
Cf. ECHA - n° 4 of 6 February 2017, page 10.
Personal Identification Number (pre-filled)
The Depositor needs a Personal Identification Number (Luxembourgish Matricule Number also known as CCSS code) to be able to file the report.
If the Depositor does not have a Luxembourgish Matricule Number, he has to contact the Bureau de la retenue d'impôt sur les intérêts to obtain one (Form 914F).
-by mail: aeoi@co.etat.lu
-by phone: Phone book_Bureau de la retenue d'impôt sur les intérêts
IMPORTANT: all pre-filled data have to be communicated to Fundsquare in order to be integrated in Fundsquare's database and to be available in the CRS form
=> Consult our CRS Onboarding process for more detailed information.
=> Send mail to: OnboardingFatcaCRS@fundsquare.net
Information on declarer
The declarer may be the RFI or an entity, e.g. a management company, managing the reporting from a business point of view.
Declarer name
The ACD needs contact details of a person who would be able to answer business questions regarding the report.
Cf. ECHA - n° 4 of 6 February 2017, page 10
Declarer identification number
Social Security Identification Number (Matricule, code CCSS) of the declarer.
Reporting person
The Reporting Person is the Reporting Financial Institution (RFI) that is subject to the CRS Reporting.
Name of the Reporting Financial Institution
Select the entity in the drop-down list for which the reporting has to be done.
Name
Name of the RFI (pre-filled once the RFI has been selected)
Entity Identification number
The Identification number is the Luxembourgish Matricule number of the RFI (pre-filled once the RFI has been selected)
Entity Identification number extension
The extension of the Luxembourgish Matricule number (pre-filled once the RFI has been selected). Example of an UCI that reports on UCI level: M00000000 (The Reporting FI Identifier will be 12345678912M00000000)
If a sub-entity wants to submit a CRS reporting to the ACD and does not have a personnel number, it puts the parent entity's number in the Entity Identification number field and an additional identifier in the Entity Identification number extension field. Example: a sub-fund that wants to report directly, can enter the umbrella number (= tax identification number available on the subscription-tax returns) in the Entity Identification number field and the sub-fund number (CSSF code of the sub-fund) in the Entity Identification number extension field. Exemple: F00000002 (The Reporting FI Identifier will be 12345678912F00000002)
IMPORTANT: instructions published on the ACD website should be followed in the event that the Luxembourg Financial Institution has no Luxembourgish matricule.
Reporting FI Identifier
It is the concatenation of the Identification Number and Identification Number Extension (pre-filled once the RFI has been selected).
IMPORTANT: all pre-filled data have to be communicated to Fundsquare in order to be integrated in Fundsquare's database and to be available in the CRS form
=> Consult our CRS Onboarding process for more detailed information.
=> Send mail to: OnboardingFatcaCRS@fundsquare.net
Header tab
Information in the header tab identifies the Competent Authority that is sending the message, as well as the Competent Authority receiving the message. It specifies when the message was created and the nature of the report.
Transmitting country
Must always be LU. This data element identifies the jurisdiction of the Competent Authority transmitting the message, which is the Competent Authority that has received the initial CRS message.
Cf. ECHA - n° 4 of 6 February 2017, page 28.
Receiving country
Must always always be LU. This data element identifies the jurisdiction of the Competent Authority receiving the message, which is the Competent Authority that has sent the initial CRS message.
Cf. ECHA - n° 4 of 6 February 2017, page 28.
Warning
This optional data element is a free text field allowing input of specific cautionary instructions about use of the CRS Status Message.
Cf. ECHA - n° 4 of 6 February 2017, page 30.
Contact
This optional data element is a free text field allowing input of specific contact information for the sender of the message (i.e. the Competent Authority sending the CRS Status Message).
Cf. ECHA - n° 4 of 6 February 2017, page 30.
Message reference ID
This field has to be completed with a unique identifier.
The ACD recommends to use a "timestamp", a digital counter or a "GUID" (Globally Unique Identifier).
Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc.
The ACD asks not to include confidential data in the identifying elements.
Cf. ECHA - n° 4 of 6 February 2017, page 21-22 and page 28.
Declaration type
CRS701: The message contains new information
CRS702: The message contains corrections / cancellations for data previously reported
CRS703: The message informs that there are no data to declare by Luxembourg Reporting Financial Institution for the fiscal year indicated.
Reporting period
It is the tax year to which the message relates. For example, if reporting information for the accounts or payments made in clendar year 2016, you have to select 2016.
Reporting group tab
Reporting FI
The Reporting Financial Institution (RFI) is the entity that is subject to the CRS Reporting.
Residence country
The country or countries of tax residence of the Luxembourg RFI. The "Residence country" element corresponds to the country or countries of tax residence of the Luxembourg RFI. There must be at least one element which has the value "LU". In addition, the value of the "Residence country" element must be equal to the value of the "TransmittingCountry" element, otherwise the file is rejected with error code 60013.
Cf. ECHA - n° 4 of 6 February 2017, page 34.
IN
The tax identification number(s) of the RFI. At least the Luxembourg Personal Identification Number (Matricule) of the Luxembourg RFI must be present.
Organization name
The name of the RFI
Address
The address of the RFI
Cf. ECHA - n° 4 of 6 February 2017, page 31.
Document type
This element specifies the type of data to be transmitted
OECD0: Resend data
OECD1: New data
OECD2: Corrected data
OECD3: Deletion of data
Important:The file is rejected in case of Document type = OECD3 and if all account reports related to this Reporting FI have not previously been deleted.
Cf. ECHA - n° 4 of 6 February 2017, page 32.
Document reference ID
Cf. chapter 2.4.1.1 AEOI reference
Document reference ID to correct
This element is a reference to the unique identifier of the data that is to be corrected / deleted and its value must be known by the ACD because it had been previously transmitted via a new data message.
Cf. ECHA - n° 4 of 6 February 2017, page 33.
Account Report
The Account Report can only be omitted if the Reporting FI is being corrected (OECD2) / deleted (OECD3) or, in the case of domestic reporting, if there is nil reporting (CRS703). If the Reporting FI indicates new data or resent data, then the Account Report must be provided.
Document type
OECD0: Resent data. This value is not authorized in the context of account reports
OECD1: New data
OECD2: Corrected data
OECD3: Deletion of data
Document Reference Id
Cf. chapter 2.4.1.1 AEOI reference
Cf. ECHA - n° 4 of 6 February 2017, page 39.
Document Reference ID to correct
This ID references the Document Reference ID of the element to be corrected (OECD2) or deleted (OECD3). It must always refer to the latest reference of this Account Report (Document Reference ID) that was sent.
Cf. ECHA - n° 4 of 6 February 2017, page 40.
Organisation
Account Number type
OECD601: IBAN - International Bank Account Number
OECD602: OBAN - Other Bank Account number
OECD603: ISIN - International Securities Identification Number
OECD604: OSIN _ Other Securities Identification Number
OECD605: Other
Account holder type
If the account holder is an organisation, select the account holder type:
CRS101 = Passive Non-Financial Entity with - one or more controlling person that is a Reportable Person
CRS102 = CRS Reportable Person
CRS103 = Passive Non-Financial Entiy that is a CRS Reportable Person
Type of message
New data message
A new data message is a message declaring data that is not yet known by the ACD. It is characterized by the value "CRS701" and by the value "OECD1"
Correction message
A correction message is a message that corrects or cancels data already known by the ACD. It is characterized by the value "CRS702" and the value "OECD2" or "OECD3".
Zero Reporting
A "ZeroReporting" message is a message stating that the Luxembourg Reporting Financial Institution has no data to report for the relevant tax year.
Unlike FATCA, the ACD has decided that filing a "zero reporting" is not mandatory.
Cf. ECHA - n° 4 of 6 February 2017, page 17
Step 1: Select Zero Report
Step 2: Complete the Contact tab
Cf. Chapter 2.4.1 Contact tab
Step 3: Complete the Header tab
The declaration type CRS703: The message advises thers is no data to report is selected by default.
Step 4: Complete the Reporting tab
Important:
-The RFI should not declare any Account Report in a Zero Report.
-The Zero Reporting has to be filed to the ACD. It will not be communicated to a particular JSD ("Juridiction soumise à déclaration").
-The Zero Reporting will be rejected if the Luxembourg Financial Institution has already transmitted data via a new data message but this data has not been canceled via a correction message. All declared data must be canceled before sending a Zero Reporting. Otherwise, the error "80009" is returned.
Cf. ECHA - n° 4 of 6 February 2017, page 17
Export - import files - save work in progress
1. Click this button to export the final report in XML format. The file will be saved on your hard drive and is available for sending to the Regulator. This button will only be available if the green tick appears in every section of the completed form.
2. This button allows you to upload an existing XML report from your network or hard drive into the report generator.
3. Work in progress on a report has to be saved with this button. The exported .xml file will be called DRAFT_filename.xml and cannot be uploaded for filing. It can be imported onto the tool for later use. Only final reports will carry the correct naming convention for submission to the Regulator.
4.If green ticks appear in every section of the completed form, the Transmission button will become available.
File transmission
Setup of the Transmission Module e-file v2
Step 1. Complete the form .
Result: all ticks become green
Step 2: Click the button.
Result: the EfileCrypto.jnlp file is generated.
IMPORTANT: this file has to be downloaded (if you use the application for the first time) locally on your computer and must be opened to launch the Transmission Module.
Note: the Transmission Module is a Java application. For security reasons, this module aims at encrypting documents before they are sent to authorithies. It is also used to decrypt documents and feedbacks.
See prerequisites for the installation of the Transmission Module e-file v2.
Step 3. Click the Open button of the EfileCrypto.jnlp file
Result: the window below opens
Step 4. Click the button
Result: the Transmission Module is launched
Important: It is possible that the pop-up blocker does not allow .jnlp files to be downloaded. Please ask your IT deparment to allow pop-ups from https://www.e-file.lu/ .
Step 5: The Transmission Module has to be configured when it is used for the first time (or after each Java update).
The path to the keystore has to be selected with the button and the key (locally or on a server) will have to be imported with the button :
Once the key has been imported, the access to the keystore is memorized by the application.
In order to be more user friendly and to speed up the sending process, the Transmission Module will then run as a back ground process on your desktop.
If you need to end the process, right click on the icon in the taskbar and select “Close Transmission Module” :
Step 6. Return to the CRS Form (Report Generator) screen - Click the button - Enter a "title of file sent" - Enter the keystore password
Result: as the configuration of the Transmission Module is finished, the General Tab of the Transmission Module will be displayed directly.
Note:
-the file name is automatically generated and compliant to the ACD file naming convention.
-the button is now available and the report can be sent. A pop-up window will confirm the transmission.
Transmission follow up
PLEASE CONSULT OUR WIKIPAGE TRANSMISSION FOLLOW-UP
Automatic filing through the Sending Service
The Sending Service is Fundsquare's solution for automatically sending reports and documents to the authorities.
With a suitable network mapping, users can then simply copy the file to be sent in the appropriate directory.
The file is then automatically encrypted and sent.
CRS.xml files have to be dropped into the CRS subfolder:
- Should you need further information on the Sending Service, please click the links below:
Sending Service Installation Procedure
Sending Service Update Procedure
CRS file naming convention
The following naming convention has to be applied for the files:
XML file : CRS<SEP>DateHeure<SEP>MessageTypeIndic<SEP>AnnéeFiscale<SEP>Canal<SEP>MatriculeDuDéposant<SEP>MatriculeDuRFI<SEP>Environnement.xml
Code | Definition | Structure | Values |
---|---|---|---|
<SEP> | Separator of the different variables of the file. The separator chosen is the underscore: _. | Char(1) | underscore: _. |
DateHeure | Creation date and time of the XML file | Number(14) | YYYYMMDDhhmmss |
MessageTypeIndic | CRS701: The message contains new information
CRS702: The message contains corrections for previously sent information CRS703: The message advises there is no data to report
|
Char(3)Number(3) | CRS701
CRS702 CRS703 |
AnnéeFiscale | Fiscal year | Number(4) | YYYY |
Canal | Communication channel | Char(1) | B = Bourse |
MatriculeDuDéposant | Social Security Identification Number (Matricule, code CCSS) | Number(11) | 0-9 |
MatriculeDuRFI | Concatenation of <ReportingPerson> / <IdentificationNumber> and <ReportingPerson> / <IdentificationNumberExtension> | Number(11), char(1), number(8) | 12345678901M00000000 |
Environnement | Environment type | Char(1) | P = Production
T = Test
CRS_20170615114523_CRS701_2016_B_19751234567_01234567890M00000000_P.xml
VAL = Validated and imported by ACD ERR = File rejected |
Report transmission
File processing status generated by the Sending Service
During and at the end of the sending, the Sending Service generates various files in the subfolder that
has been used for the sending. Three type of files are generated:
- .trt file : indicates the start of the transmission
In order to be able to send the original file, the Sending Service transforms the latter into a .trt file and adds a timestamp. E.g. «OriginalName.xml» is transformed into OriginalName.xml.timestamp.trt:
.xml becomes
.trt
- .acq file : the transmission has been successfully completed
- .err file : indicates that an error has occurred during the sending
The error file contains technical messages indicating the root cause of the error, e.g. file name errors.