Difference between revisions of "FATCA Manual"

From E-fileWiki
Jump to navigation Jump to search
(47 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="text-align: right; direction: ltr; margin-left: 1em;">[[Welcome_to_e-file_and_Fundsquare_FAQ|Home page ]][[File:Home.png|Return homepage|link=Welcome_to_e-file_and_Fundsquare_FAQ]] </div>
 
<div style="text-align: right; direction: ltr; margin-left: 1em;">[[Manuel FATCA|Français]] [[File:french.jpg|Accéder à la partie française|link=Manuel_FATCA]]</div>


=Introduction=
=Introduction=


The Luxembourg Tax Authoritiy (Administration des contributions directes ([http://www.impotsdirects.public.lu/fr/echanges_electroniques.html ACD])) published on 19 January 2017 an updated version of the circular [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA3] defining the new format that takes into account the Internal Revenue Services (IRS) FATCA XSD 2.0. Luxembourg Financial Institutions will have to use this new schema, as it will be the only one accepted as from now.   
The Luxembourg Tax Authority ('''Administration des contributions directes''' ([http://www.impotsdirects.public.lu/fr/echanges_electroniques.html ACD])) published on 19 January 2017 an updated version of the circular [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA3] defining the new format that takes into account the Internal Revenue Services (IRS) FATCA XSD 2.0. Luxembourg Financial Institutions will have to use this new schema, as it will be the only one accepted as from now.   




Line 13: Line 12:
==Environment==
==Environment==


*Select your environment:
Step 1: Select your environment


Production environment : '''https://www.e-file.lu/e-file/'''
Production environment : '''https://www.e-file.lu/e-file/'''


Homologation environment (Test) : '''https://homologation.e-file.lu/e-file/'''
Homologation environment (Test) : '''https://homologation.e-file.lu/e-file/'''




==Login==
==Login==


*Enter your e-file login credentials (user name and password) and click the Access button.
Step 1: Enter your e-file login credentials (user name and password) and click the Access button


[[File:Identification.jpg]]
[[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.
'''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 FATCA form==
==Access FATCA form==


*Click on the Report Generation icon:
Step 1: Click on the Report Generation icon
[[File:Fatca ReportGen.jpg]]
[[File:Fatca ReportGen.jpg]]




*Select Formulaire FATCA
 
 
 
 
Step 2: Select Formulaire FATCA
[[File:Select Form Fatca.jpg]]<br/>
[[File:Select Form Fatca.jpg]]<br/>


Line 42: Line 51:


[[File:Open form.jpg]]
[[File:Open form.jpg]]




Line 52: Line 63:


[[File:Contact tab.jpg]]
[[File:Contact tab.jpg]]




Line 58: Line 72:
[[File:AEOI REF.jpg]]
[[File:AEOI REF.jpg]]


*'''AEOI reference''': free text to be provided by the Depositor.
*This field has to be completed by a Globally Unique Identifier (GUID) that can be choosen freely in accordance with certain rules described in [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017, page 13].
*Specifications of the free text: maximum length 100 characters, only capital characters, number 0-9, must be unique, etc.; Cf. details [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA3, page 13].
 
*Our FATCA form respects all these specifications by default. Please note that the XSD of the ACD does not check these specifications on our Sending Service and your reporting might be rejected by the ACD.
*Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc.  
 
*The ACD  recommends not to use personal data such as the name or account number, but rather a sequential number.
 
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017, page 13].
 
 




====Information on Depositor====
 
 
====Information on depositor====


[[File:Info Dep.jpg]]
[[File:Info Dep.jpg]]


*'''Depositor name''' (pre-filled): The '''Depositor''' is an entity (legal or natural person) that is in charge of filing the FATCA reporting to the ACD (e.g. Service provider).
*'''Depositor name''' (pre-filled): The '''Depositor''' is an entity (legal or natural person) that is in charge of filing the FATCA reporting to the ACD (e.g. Service provider). Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017, page 6].


*'''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.  
*'''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'''
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'''


-by mail: aeoi@co.etat.lu
-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]
-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 available in the FACTA form.'''
'''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 FATCA form
 
Consult our [[FATCA|Onboarding/Update process FATCA/CRS]] for more detailed information.
 
Send mail to: [mailto:OnboardingFatcaCRS@fundsquare.net OnboardingFatcaCRS@fundsquare.net]
 
 
 
 




Line 89: Line 120:
[[File:RepPERSON.jpg]]
[[File:RepPERSON.jpg]]


*'''Name of the reporting financial institute''': Select the entity in the drop-down list for which the reporting is done.
*'''Name of the reporting financial institution''': Select the entity in the drop-down list for which the reporting is done.
*'''Reporting person''' (pre-filled once the RFI has been selected)
*'''Reporting person''' (pre-filled once the RFI has been selected)
*'''Identification number''' (pre-filled with the Luxembourgish '''Matricule''' Number once the RFI has been selected)
*'''Identification number''' (pre-filled with the Luxembourgish '''Matricule''' Number once the RFI has been selected)
*'''Entity Identification number extension''' (pre-filled with the value "M00000000"): "M00000000" is the default value if you have no extention code to communicate.  
*'''Entity Identification number extension''' (pre-filled with the value "M00000000"): "M00000000" is the default value if you have no extention code to communicate.  


'''IMPORTANT''': If a sub-entity has to file a FATCA reporting and does not have a Luxembourgish '''Matricule''' Number, it must enter the parent Luxembourgish '''Matricule''' Number in the first field and an additional identifier in the second field. For example, sub-funds  have to enter the Luxembourgish '''Matricule''' Number of the umbrella fund in the '''Identification Number''' field and enter the sub-fund number in the '''Entity Identification number extension''' field.
 
'''IMPORTANT''': If a sub-entity has to file a FATCA reporting and does not have a Luxembourgish '''Matricule''' Number, it must enter the parent Luxembourgish '''Matricule''' Number in the first field and an additional identifier in the second field. For example, sub-funds  have to enter the Luxembourgish '''Matricule''' Number of the umbrella fund in the '''Identification Number''' field and enter the sub-fund number in the '''Entity Identification number extension''' field. Cf. details [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017, page 9].
 
If the RFI has no Luxembourgish '''Matricule''' Number the instructions published on the ACD website have to be followed (Cf.: [http://www.impotsdirects.public.lu/fr/profil/organigramme/direction/division_echange_renseignements_retenue_interets.html Contact_Division échange de renseignements et retenue d’impôt sur les intérêts]).
If the RFI has no Luxembourgish '''Matricule''' Number the instructions published on the ACD website have to be followed (Cf.: [http://www.impotsdirects.public.lu/fr/profil/organigramme/direction/division_echange_renseignements_retenue_interets.html Contact_Division échange de renseignements et retenue d’impôt sur les intérêts]).




'''IMPORTANT: all selectable and pre-filled data have to be communicated to Fundsquare in order to be available in the FACTA form.'''
'''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 FATCA form
 
Consult our [[FATCA|Onboarding/Update process FATCA/CRS]] for more detailed information.
 
Send mail to: [mailto:OnboardingFatcaCRS@fundsquare.net OnboardingFatcaCRS@fundsquare.net]
 
 
 
 




====Information on declarer====
====Information on declarer====


The declarer is a Financial Institution that is repsonsible for the reporting. The Declarer can be either the FI subject to the reporting obligation or an entity such as the management company or a trustee handling the reports for the FI. The Luxembourg tax authority needs the contact details of a reachable person from the Back Office who has detailed knowledge regarding the content of the report. Please note, questions regarding the format of the report should be dealt with by the Depositor.
The declarer may be the Financial institution that is subject to the FATCA reporting obligation or an entity, e.g. a management company, managing the reporting from a business point of view.  
 
The ACD needs contact details of a person who would be able to answer business questions regarding the report.
 
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-annexe1-description-des-champs-2017-01-19.pdf Annexe 1 ECHA - n° 3 of 19 January 2017, page 50]).


[[File:Declarer.jpg]]
[[File:Declarer.jpg]]
===Zero Reporting===
The ACD requires one reporting each year from each Luxembourg Reporting Financial Institution registered with the IRS.
Luxembourg Reporting Financial Institutions that have no Reportable Accounts to report for a year, must inform the ACD by sending a Zero Reporting to the ACD.
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017, page 21].




== Export - import files - save work in progress  ==
== 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.


[[File:Export.jpg]]
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.


1. Click this button to export the final report in XML format. The file will be saved on your harddrive and is available for sending to the Regulator. This button will only be available if the green Icon [[File:GreenIcon.png]] appears in every section of the completed report.


2. This button allows you to upload an existing XML report from your network or harddrive 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 report, the Transmission button will become available.




Line 125: Line 190:




=== Setup of the e-file v2 encryption module v2 ===
=== Setup of the e-file v2 Transmission Module ===


  1. If green ticks [[File:GreenIcon.png]] appear in every section (Contact, Header, Reporting FI and Reporting group) of the completed report, click the [[File:Transmission.png | border]] button
  Step 1: The form is completed [[File:GreenIcon.png]]. Click the [[File:Transmission.png | border]] button.


'''Result:''' the EfileCrypto.jnlp file is generated.
'''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 '''Encryption Module'''.
'''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.
 
Java version 1.7.55 is a prerequisite for the installation of the e-file v2 Transmission Module.
 


'''Note''': the '''Encryption 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.


Java version 1.7.55 is a prerequisite for the installation of the e-file v2 encryption module.




  2. Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg]]
 
  Step 2: Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg | 250 px]]


'''Result:''' the window below opens
'''Result:''' the window below opens
[[File:JavaEfileWindow.png |border]]
 
Step 3: Click the [[File:RunButton.png | border]] button


[[File:JavaEfileWindow.png | border]]
[[File:JavaEfileWindow.png | border]]
 


3. Click the [[File:RunButton.png | border]] button


'''Result:''' the Encryption Module is launched
'''Result:''' the Transmission Module is launched


[[File:EncryptionConfig.png |border]]
[[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/''' .
'''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/''' .




  4. The encryption module has to be configured when it is used for the first time (or after each Java update).
 
 
 
 
  Step 4: 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/>
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:EncryptionConfig.png |border]]
[[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.


Once the key has been imported, the access to the keystore is memorized by the application and does not have to be reconfigured in the future.
If you need to end the process, right click on the icon in the taskbar and select “Close Transmission Module” :


In order to be more user friendly and to speed up the sending process, the encryption 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 encryption module” :
[[File:2Tmet.png |250 px]]


[[File:EncryptionTaskbar.png |border]]




5. Click the [[File:Transmission.png | border]] button in the Report Generator screen.
Result: as the installation and configuration of the encryption module are done, the General Tab of the Encryption Module will open directly.


[[File:EncrypMod General.png | border]]


Note: the file name is automatically generated and compliant to the ACD file naming convention.


Step 5: Return to the FATCA Form (Report Generator) screen
- Click the [[File:Transmission.png | border]] button
- Enter a "title of file sent"
- Enter the keystore password


6. Enter a "title of file sent" (this name can later be used for search queries) and the keystore password. The [[File:SendButton.png | border]] button is now available and the report can be sent. A pop-up window will confirm the transmission.


'''Result''': as the configuration of the Transmission Module is finished, the General Tab of the Transmission Module will be displayed directly.


= Naming convention =
[[File:Icon22.png | 500px]]


'''Report :''' <br/>
'''Note''':
FATCA_DateTime_Channel_MatriculeReporter_GIIN_ProdTest.xml <br/>


'''Feedback from ACD :''' <br/>
-the file name is automatically generated and compliant to the ACD file naming convention.
FATCA_ DateTime_Channel_MatriculeReporter_GIIN_ProdTest_Status.xml<br/>
 
-the [[File:SendButton.png | border]] button is now available and the report can be sent. A pop-up window will confirm the transmission.
 
 
'''SHOULD YOU ENCOUNTER PROBLEMS PLEASE CONSULT OUR WIKIPAGE [[Transmission Module#Solving the most common problems|SOLVING THE MOST COMMON PROBLEMS OF THE TRANSMISSION MODULE]] OR CONTACT OUR [[How to contact us|'''Client Support & Operations Desk''']].
 
 
 
 
 
 
== File 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.
 
FATCA .xml files have to be dropped into the '''FATCA''' subfolder:
 
[[File:FolderFatca.bmp |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]]
 
 
 
 
 
 
== FATCA file naming convention ==
 
The following naming convention has to be applied for the files:
 
'''XML file :'''
'''FATCA_${DateTime}_${Type}_${FiscalYear}_${Channel}_${MatriculeDepositor}_${GIIN}_${ProdTest}.xml'''
 
'''Feedback from ACD :'''
'''FATCA_${DateTime}_${Type}_${FiscalYear}_${Channel}_${MatriculeDepositor}_${GIIN}_${ProdTest}_${Status}.xml'''


{|border="1" cellspacing="2" cellpadding="10"
{|border="1" cellspacing="2" cellpadding="10"
Line 193: Line 327:
|-
|-
| DateTime
| DateTime
| Creation date and time
| Creation date and time of the XML file
| Number(14)
| Number(14)
| AAAAMMJJhhmmss
| YYYYMMDDhhmmss
|-
| Type
| F0: ZeroReport or new contact data without FATCA data
 
F1: FATCA1–New data
 
F2: FATCA2–Correction–Data corrected upon request of the IRS
 
F3: FATCA3–Void–Cancellation of data
 
F4: FATCA4–Amendment–Data corrected at any time
 
| Char(1)Number(1)
| F0
 
F1
 
F2
 
F3
 
F4
 
|-
| FiscalYear
| Fiscal year
| Number(4)
| YYYY
|-
|-
| Channel
| Channel
| Communication channel  
| Communication channel  
| Char(1)
| Char(1)
| B (Bourse)
| B = Bourse
|-
|-
| MatriculeReporter
| MatriculeReporter
Line 222: Line 384:
| Char(3)
| Char(3)
| ''Technical Feedback''
| ''Technical Feedback''
ACK = File technically received by ACD <br/>
 
NAK = Error encountered during the file reception <br/>
ACK = File received by ACD
''Business Feedback'' <br/>
 
VAL = Validated and imported by ACD <br/>
NAK = File rejected by ACD
WAR = Validated and imported by ACD but with small issues that raised a warning <br/>
 
ERR = Error in file, rejected by ACD <br />
''Business Feedback''
 
VAL = Validated and imported by ACD
 
WAR = Validated and imported by ACD but with small issues that raised a warning
 
ERR = File rejected
 
|}
|}


Examples <br/>
'''Examples''':
 
'''XML file''':
 
'''FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml'''


'''Report :''' <br/>
'''FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T.xml'''
'''FATCA_20150731115912_B_11231231230_LBITA8.00002.SP.442_T.xml'''<br/>


FATCA report created the 31/07/2015 via Bourse’s channel, with CCSS code 11231231230 GIIIN code LBITA8.00002.SP.442, in the test environment. <br/>


'''Feedback from ACD :''' <br/>
'''Feedback from ACD :'''
'''FATCA_20150731115912_B_11231231230_LBITA8.00002.SP.442_T_ack.xml''' <br/>
FATCA report created the 31/07/2015 via Bourse’s channel, with CCSS code 11231231230 GIIIN code LBITA8.00002.SP.442, in the test environment and has been received by ACD. <br/>


'''FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P_ack.xml'''


'''FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T_ack.xml'''




= Automatic Sending with the Sending Service =
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017; page 19-20]
In order to send reports with the Sending Service, the following components have to be installed on
your desktop:
*'''Java version 1.6.0.14 or higher'''
*'''Sending service version 3.3.6 or higher'''


== Access to the Sending Service ==


The Sending Service is accessible with the file explorer and visible as a folder including subfolders :


[[File:FolderFatca.bmp |border]]


The standard file structure includes a  «FATCA» subfolder  (by default, a subfolder for each type of
reporting is included).


== Sending frequency ==
During the setup of the sending service, the sending frequency can be individually set for each subfolder by your e-file administrator within the setup file. The default sending frequency is every 30 minutes but it can be tailored according to your needs.


== Report transmission ==
== Report transmission ==
In order to send a report with the Sending Service, the exported .xml report has to be copied into the
…/ServiceDeposant/ReportingDiffusion/FATCA subfolder.


== Files created by the Sending Service ==
In order to send a report with the Sending Service, the exported .xml report has to be copied into the '''…/ServiceDeposant/ReportingDiffusion/FATCA subfolder'''.
 
Ensure that the '''FATCA file naming convention''' is applied (Cf. [[#FATCA file naming convention|FATCA file naming convention]]).
 
 
 
 
 
 
== 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
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/>
has been used for the sending. Three type of files are generated: <br/>


*'''.trt''' file : indicates the start of the transmission <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
In order to be able to send the original file, the Sending Service transforms the latter into a .trt file and
adds a timestamp. Eg «OriginalName.xml» is transformed into OriginalName.xml.timestamp.trt: <br/>
adds a timestamp. E.g. «OriginalName.xml» is transformed into OriginalName.xml.timestamp.trt:


FATCA_20150731115912_B_11231231230_LBITA8.00002.SP.442_T.xml becomes <br/>
FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml becomes
FATCA_20150731115912_B_11231231230_LBITA8.00002.SP.442_T.xml_20150731122616366.trt <br/>


*'''.acq''' file : the transmission has been successfully completed <br/>
FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml_20150731122616366.trt
Example of a successful transmission :<br/>
Before the transmission : <br/>
[[File:FatcaFileXml.png | border]]
After the transmission:  <br/>
[[File:FatcaFileAcq.png | border]]
*'''.err''' file : indicates that an error has occurred during the sending <br/>
The error file contains technical messages designed to help find the root cause of the error, eg naming errors.  


*'''.acq''' file : the transmission has been successfully completed


= Transmission follow up =
*'''.err''' file : indicates that an error has occurred during the sending


== Get the feedbacks ==
The error file contains technical messages indicating the root cause of the error, e.g. file name errors.  
=== Manual access===
First connect on [https://www.e-file.lu/e-file https://www.e-file.lu/e-file] with your credentials.
<br/>
Select the "'''Document management'''" module as follow : <br/>
[[File:iconModules.png|border]]
<br/>
Select "'''Transmission follow up'''" tab : <br/>
[[File:transmissionFU.png|border]]


The search can be defined between 2 dates and will display all the reports sent during that period.<br/>
Each report has a status to have a quick overview of your sendings.<br/>
<br/>
* "'''Transmitted'''" means that the report is currently dispatched to the ACD.<br/>
* "'''Feedback Received'''" means that at least one feedback has been received. It also means that the ACD was able to read your report.<br/>
* "'''To validate'''" means that the report needs to be validated by the declarant on E-file V2. This is a really specific case.<br/>
<br/>
[[File:resultSearch.png|border]]


To see the reports and its feedback, click on the blue icon on the right.<br/>


[[File:listFiles.png|border]]


The files are displayed with a type:<br/>
<br/>
* '''FATCA''' = Original report<br/>
* '''FDBTEC''' = Technical feedback<br/>
* '''FDBBUS''' = Business feedback<br/>
<br/>
To read one of these files, click on the green icon on the right.<br/>
As the document is encrypted it will launch our encryption module V2.<br/>
<br/>
[[File:moduleDL2.png|border]]
<br/>
Finally the '''keystore password''' is requested to either save the file or directly open it.


=== Access from Sending Service===
ACD's feedbacks can be found in the sub-folder "Replies" from the following path .../ServiceDeposant/ReportindDiffusion/FATCA/Replies/.<br/>
Each feedback has a specifical status (see [[#Naming_convention]] : Status) which can be seen in the file name (ex : ack).<br/>
[[File:FeedbackSendingService.png|border]]
The "Replies" folder is created upon feedback receipt. Please check the Sending Service's configuration whether it cannot be found. In the configuration file, the variable corresponding to "Configuration of connection for feedback" and the the one corresponding to "Configuration of connection for authority acknowledgement" should be set to "up".


=FATCA FAQ=
== File transmission follow-up ==


==How to modify an existing report ?==
=== Transmission status ===
In order to modify an existing report the Report Generator's form has to be completed with the new information. The type of modification to apply is set up in the "'''Reporting FI'''" section in "'''Document Specification'''" and in "'''Reporting Group'''" section in "'''Account Report'''" when clicking [[File:AddAccount.png]].<br/>
The different types are the following :<br/>


*'''FATCA1''' : Initial sending. The file contains only new information
ACD's feedback files are available in the sub-folder "Replies":  '''.../ServiceDeposant/ReportingDiffusion/FATCA/Replies/'''.
*'''FATCA2''' : Asked modifications. The file contains only corrections asked by american's authorities (IRS)
 
*'''FATCA3''' : Cancellations. The file contains only cancellations concerning previously changed information
Each feedback has a specific status which is available in the file name: ACK, NAK, VAL, WAR, ERR (Cf. [[#FATCA file naming convention|Status feedback ACD]]).
*'''FATCA4''' : Modifications. The file contains only corrections concerning the previously changed information on declarer's initiative
 
'''Feedback from ACD :'''
 
'''FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P_ack.xml'''
 
'''FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T_ack.xml'''
 
The "Replies" folder is created upon feedback receipt. Please check the Sending Service's configuration if the "Replies" folder is not available. In the configuration file (properties file), the variable corresponding to "Configuration of connection for feedback" and the one corresponding to "Configuration of connection for authority acknowledgement" should be set to "up".
 
 
 
 
 
 
=How to correct, void or amend validated reports=
 
In order to correct, void or amend reports through the FATCA Form (Report Generator), the type of modification (FATCA2, FATCA3, FATCA4) has to be selected in the "'''Reporting FI'''" tab,  section "'''Document Specification'''" and in the "'''Reporting Group'''" tab, section "'''Account Report'''" and then "'''Document specification"'''.
 
The different types are the following ones :
 
*'''FATCA1''' : [[Initial sending]]. The file contains only new information.
 
*'''FATCA2''' : [[Correction]]. A report should be corrected in response to an error notification from IRS.
 
*'''FATCA3''' : [[Void]]. A report may be voided at any time after you become aware of inaccurate information. All data element fields in the voided record must have the same values equal to the original record being voided. Do not void a report in response to an error notification.
 
*'''FATCA4''' : [[Amend]]. A report may be amended at any time. An amended report updates an existing report from a previously filed report. All data element fields in the amended report must have the amended values for the relevant account report. Do not amend a report in response to a report error notification, instead file a corrected report with DocTypeIndic FATCA2.


To chose the report to modify, its reference has to be entered in the '''document reference ID to correct''' and '''message reference ID to correct'''.<br/>
To chose the report to modify, its reference has to be entered in the '''document reference ID to correct''' and '''message reference ID to correct'''.<br/>
[[File:RefDoc.png|border]]
[[File:RefDoc.png|border]]
==Why the GIINs do not appear on the form ?==
To register your GIINs the contact form of our Client Service has to be fill up.<br/>
After the registration of your GIINs you will receive a confirmation mail within few days, if you haven't received the email yet please contact [mailto:fatca_onboarding@fundsquare.net fatca_onboarding@fundsquare.net].<br/>


==Error message : The process takes too much time. Please restart the encryption module.==
[[File:ErrorTransmission.png|border]]<br/>
The error message occurs when the encryption module is not started in time.<br/>
Please check that the pop-up are enable for the site https://www.e-file.lu.<br/>
When clicking the "Transmission" button the file '''EfileCrypto.jnlp''' should be downloaded in order to launch the encryption module. You have to open this file with '''Java Web Start Launcher''' to run the module.<br/>


==Message : Waiting files to transmit...==
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-annexe2-mecanisme-corrections-2017-01-19.pdf Annex 2 to ECHA - n° 3 of 19 January 2017]
[[File:WaitingFile.png|border]]<br/>
 
<br/>
Cf. [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf ECHA - n° 3 of 19 January 2017; page 22-24]
This error might occur when there is a connection problem between your '''proxy''' and the '''encryption module V2'''.<br/>
 
<br/>
Close the encryption module : <br/>
[[File:EncryptionTaskbar.png |border]]<br/>
<br/>
Open the Java console (See [http://www.e-file.lu/wiki/index.php/Encryption_Module#Show_the_console_in_case_of_other_Java_issue  http://www.e-file.lu/wiki/index.php/Encryption_Module#Show_the_console_in_case_of_other_Java_issue]) and check the logs.<br/>
If an '''error 407''' appears, it means that the encryption module is not able to authenticate on your proxy.<br/>
As a consequence all communications with E-file are blocked.<br/>
<br/>
In that case the solutions to resolve this problem are the following :<br/>
*Add the group "'''NoAuthenticated exception group'''" to your proxy for '''www.e-file.lu'''
*By-pass the proxy for the communication with '''www.e-file.lu'''


For more information please call the Helpdesk.
[[Category: FAQ e-file]]

Revision as of 21:04, 30 April 2018


Introduction

The Luxembourg Tax Authority (Administration des contributions directes (ACD)) published on 19 January 2017 an updated version of the circular ECHA3 defining the new format that takes into account the Internal Revenue Services (IRS) FATCA XSD 2.0. Luxembourg Financial Institutions will have to use this new schema, as it will be the only one accepted as from now.


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

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 FATCA form

Step 1: Click on the Report Generation icon

Fatca ReportGen.jpg




Step 2: Select Formulaire FATCA

Select Form Fatca.jpg


Result: the FATCA form opens

Open form.jpg



Complete FATCA form

Contact tab

This is the Luxembourgish part of the FATCA report added by ACD.

Contact tab.jpg



AEOI reference

AEOI REF.jpg

  • Specification examples: only capital characters (A-Z), number 0-9, must be unique, etc.
  • The ACD recommends not to use personal data such as the name or account number, but rather a sequential number.

Cf. ECHA - n° 3 of 19 January 2017, page 13.




Information on depositor

Info Dep.jpg

  • Depositor name (pre-filled): The Depositor is an entity (legal or natural person) that is in charge of filing the FATCA reporting to the ACD (e.g. Service provider). Cf. ECHA - n° 3 of 19 January 2017, page 6.
  • 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

-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 FATCA form
Consult our Onboarding/Update process FATCA/CRS for more detailed information.
Send mail to: OnboardingFatcaCRS@fundsquare.net




Reporting person

The Reporting Person is the Reporting Financial Institution (RFI). This element is used by the ACD for tracking purposes (i.e. in case of Zero Reporting).

It is the same entity as in the "Reporting FI" tab.

RepPERSON.jpg

  • Name of the reporting financial institution: Select the entity in the drop-down list for which the reporting is done.
  • Reporting person (pre-filled once the RFI has been selected)
  • Identification number (pre-filled with the Luxembourgish Matricule Number once the RFI has been selected)
  • Entity Identification number extension (pre-filled with the value "M00000000"): "M00000000" is the default value if you have no extention code to communicate.


IMPORTANT: If a sub-entity has to file a FATCA reporting and does not have a Luxembourgish Matricule Number, it must enter the parent Luxembourgish Matricule Number in the first field and an additional identifier in the second field. For example, sub-funds have to enter the Luxembourgish Matricule Number of the umbrella fund in the Identification Number field and enter the sub-fund number in the Entity Identification number extension field. Cf. details ECHA - n° 3 of 19 January 2017, page 9.

If the RFI has no Luxembourgish Matricule Number the instructions published on the ACD website have to be followed (Cf.: Contact_Division échange de renseignements et 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 FATCA form
Consult our Onboarding/Update process FATCA/CRS for more detailed information.
Send mail to: OnboardingFatcaCRS@fundsquare.net




Information on declarer

The declarer may be the Financial institution that is subject to the FATCA reporting obligation or an entity, e.g. a management company, managing the reporting from a business point of view.

The ACD needs contact details of a person who would be able to answer business questions regarding the report.

Cf. Annexe 1 ECHA - n° 3 of 19 January 2017, page 50).

Declarer.jpg




Zero Reporting

The ACD requires one reporting each year from each Luxembourg Reporting Financial Institution registered with the IRS.

Luxembourg Reporting Financial Institutions that have no Reportable Accounts to report for a year, must inform the ACD by sending a Zero Reporting to the ACD.

Cf. ECHA - n° 3 of 19 January 2017, page 21.




Export - import files - save work in progress

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 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 GreenIcon.png appear in every section of the completed form, the Transmission button will become available.




File transmission

Setup of the e-file v2 Transmission Module

Step 1: The form is completed GreenIcon.png. Click the Transmission.png 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.

Java version 1.7.55 is a prerequisite for the installation of the e-file v2 Transmission Module.




Step 2: Click the Open button of the EfileCrypto.jnlp file Jplg.jpg

Result: the window below opens

JavaEfileWindow.png




Step 3: Click the RunButton.png button

JavaEfileWindow.png


Result: the Transmission Module is launched

2tmm.png

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 4: 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 BrowseButton.png button and the key (locally or on a server) will have to be imported with the ImportButton.png button :

2tmm.png

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” :

2Tmet.png




Step 5: Return to the FATCA Form (Report Generator) screen 
- Click the Transmission.png 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.

Icon22.png

Note:

-the file name is automatically generated and compliant to the ACD file naming convention.

-the SendButton.png button is now available and the report can be sent. A pop-up window will confirm the transmission.


SHOULD YOU ENCOUNTER PROBLEMS PLEASE CONSULT OUR WIKIPAGE SOLVING THE MOST COMMON PROBLEMS OF THE TRANSMISSION MODULE OR CONTACT OUR Client Support & Operations Desk.




File 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.

FATCA .xml files have to be dropped into the FATCA subfolder:

Error creating thumbnail: Image type not supported


  • Should you need further information on the Sending Service, please click the links below:

Sending Service Installation Procedure

Sending Service Update Procedure

Wiki-Sending Service




FATCA file naming convention

The following naming convention has to be applied for the files:

XML file :
FATCA_${DateTime}_${Type}_${FiscalYear}_${Channel}_${MatriculeDepositor}_${GIIN}_${ProdTest}.xml
Feedback from ACD :
FATCA_${DateTime}_${Type}_${FiscalYear}_${Channel}_${MatriculeDepositor}_${GIIN}_${ProdTest}_${Status}.xml
Code Definition Structure Values
DateTime Creation date and time of the XML file Number(14) YYYYMMDDhhmmss
Type F0: ZeroReport or new contact data without FATCA data

F1: FATCA1–New data

F2: FATCA2–Correction–Data corrected upon request of the IRS

F3: FATCA3–Void–Cancellation of data

F4: FATCA4–Amendment–Data corrected at any time

Char(1)Number(1) F0

F1

F2

F3

F4

FiscalYear Fiscal year Number(4) YYYY
Channel Communication channel Char(1) B = Bourse
MatriculeReporter Social Security Identification Number Number(11) - Number(13) Code CCSS
GIIN GIIN (Global Intermediary Identification Number ) of the declarer Char(6).Char(5).Char(2).Number(3) Code GIIN XXXXXX.XXXXX.XX.XXX
ProdTest Environment type Char(1) P = Production

T = Test

Status Response status Char(3) Technical Feedback

ACK = File received by ACD

NAK = File rejected by ACD

Business Feedback

VAL = Validated and imported by ACD

WAR = Validated and imported by ACD but with small issues that raised a warning

ERR = File rejected

Examples:

XML file:

FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml

FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T.xml


Feedback from ACD :

FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P_ack.xml

FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T_ack.xml


Cf. ECHA - n° 3 of 19 January 2017; page 19-20




Report transmission

In order to send a report with the Sending Service, the exported .xml report has to be copied into the …/ServiceDeposant/ReportingDiffusion/FATCA subfolder.

Ensure that the FATCA file naming convention is applied (Cf. FATCA file naming convention).




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:

FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml becomes

FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P.xml_20150731122616366.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

ACD's feedback files are available in the sub-folder "Replies": .../ServiceDeposant/ReportingDiffusion/FATCA/Replies/.

Each feedback has a specific status which is available in the file name: ACK, NAK, VAL, WAR, ERR (Cf. Status feedback ACD).

Feedback from ACD :

FATCA_20150520080022_F0_2016_B_1970010112345_006M8M.00000.LE.442_P_ack.xml

FATCA_20150520080023_F1_2016_B_19700202123_ZZLRV4.99999.SL.442_T_ack.xml

The "Replies" folder is created upon feedback receipt. Please check the Sending Service's configuration if the "Replies" folder is not available. In the configuration file (properties file), the variable corresponding to "Configuration of connection for feedback" and the one corresponding to "Configuration of connection for authority acknowledgement" should be set to "up".




How to correct, void or amend validated reports

In order to correct, void or amend reports through the FATCA Form (Report Generator), the type of modification (FATCA2, FATCA3, FATCA4) has to be selected in the "Reporting FI" tab, section "Document Specification" and in the "Reporting Group" tab, section "Account Report" and then "Document specification".

The different types are the following ones :

  • FATCA2 : Correction. A report should be corrected in response to an error notification from IRS.
  • FATCA3 : Void. A report may be voided at any time after you become aware of inaccurate information. All data element fields in the voided record must have the same values equal to the original record being voided. Do not void a report in response to an error notification.
  • FATCA4 : Amend. A report may be amended at any time. An amended report updates an existing report from a previously filed report. All data element fields in the amended report must have the amended values for the relevant account report. Do not amend a report in response to a report error notification, instead file a corrected report with DocTypeIndic FATCA2.

To chose the report to modify, its reference has to be entered in the document reference ID to correct and message reference ID to correct.
RefDoc.png


Cf. Annex 2 to ECHA - n° 3 of 19 January 2017

Cf. ECHA - n° 3 of 19 January 2017; page 22-24