Difference between revisions of "ReportGeneration"

From E-fileWiki
Jump to navigation Jump to search
(44 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;">[[Welcome_to_e-file_and_Fundsquare_FAQ|Home page ]][[File:Home.png|Return homepage|link=Welcome_to_e-file_and_Fundsquare_FAQ]]</div>


=Report generation=


Our Report Generator allows you to create your reports manually.


=Introduction=


==How to access the Report Generator==
Our Report Generator generates your XML reporting using the data from your form you completed before.




===Environment===


Step 1: Select your environment


Production environment : '''https://www.e-file.lu/e-file/'''
=Select Test or Production environment=


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


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






===Login===


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


[[File:Identification.jpg]]
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.
[[File:Transmision follow up-Login .png|250 px]]


[[E-file Administration|=>e-file Administration]]
'''IMPORTANT:''' If you do not have an e-file user account, you might contact your '''e-file administrator''' of your company.


[[E-file Administration|=>for more detailed information please click the link '''e-file Administration''']]


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




Step 2: Select the report type
[[File:Generating a report.png | 500 px]]




Step 3: The form opens
=E-file launchpad=


Once your are logged in, the e-file launchpad opens.


Step 4: Complete the form
Click on the '''Report Generation''' icon.


[[File:Launchpad.png|700px]]


== Export - import files - save work in progress  ==
=Select your report type=


Please be informed that the '''PICK A SUB-MODULE''' functionality did not change in the new e-file version.


[[File:Export.jpg]]
Once you have clicked on the '''Report Generation''' icon, the  window '''OPEN A SUB-MODULE''' pops-up. Click on '''PICK A SUB-MODULE'''.  


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.
A drop-down list opens from which you have to select your reporting type. In our example we will select the '''U1.1''' report.  


2. This button allows you to upload an existing XML report from your network or hard drive into the report generator.
Then, click on the '''LAUNCH REPORT''' button. The U1.1 form opens.


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.
[[File:BeforeAfterPickSubModule2.png| 300 px]]


4.If green ticks [[File:GreenIcon.png]] appear in every section of the completed form, the Transmission button will become available.








== File transmission ==
=Form=


[[File:Final U11Form.png|800 px]]


1. The form is completed [[File:GreenIcon.png]]. Click the [[File:Transmission.png | border]] button.
<span style="background:yellow"> '''A'''</span> '''New warning''': no auto saving.


'''Result:''' the EfileCrypto.jnlp file is generated.
<span style="background:yellow"> '''B'''</span> '''Vertical navigation bar''': pages open vertically. Buttons remain red if data are missing/wrong.


'''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'''.
<span style="background:yellow"> '''C'''</span> '''Calendar''' to pick the reference date.


'''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.
<span style="background:yellow"> '''D'''</span> '''Icons''' to select Report status.


Java version 1.7.55 is a prerequisite for the installation of the e-file v2 encryption module.
<span style="background:yellow"> '''E'''</span> Click on '''NEXT STEP / PREVIOUS STEP''' to switch to the next/previous page or click on one of the sidebar navigation buttons.  


<span style="background:yellow"> '''F'''</span> '''Select an existing report''' button: This button allows you to upload an existing '''XML''' report from your network or hard-drive into the report generator.


<span style="background:yellow"> '''G'''</span> '''Save locally''' button: <u>Work in progress</u> on a report has to be saved with this button. '''Work in progress''' means that the report is not finalized, because important data are missing. 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. If you save locally a <u>final report</u>, meaning that all relevant data are available inside the report, it will carry the '''correct naming convention''' for submission to the Regulator.


<span style="background:yellow"> '''H'''</span> '''Transmit''' button: If the four buttons of the sidebar are green, the '''Transmission button''' will become available and the report can be transmitted to the regulator.


2. Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg]]
<span style="background:yellow"> '''I'''</span> '''EXCEL''' button: Press this button to export an uncompleted or finalized report in EXCEL format. This file serves for your internal purpose only, however it <u>cannot be imported</u>.


'''Result:''' the window below opens


[[File:JavaEfileWindow.png | border]]
 


<u>IMPORTANT INFORMATION on where you can find  the '''item numbers''' of [https://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/cssf15_627eng.pdf CIRCULAR CSSF 15/627 U1.1 reporting] in the different sections of the form</u>:


[[File:Number1Sidebar.png|30 px]] 1st button of the sidebar: General information on the report and the sender => item number '''1010-1050'''


3. Click the [[File:RunButton.png | border]] button
[[File:Number2Sidebar.png|30 px]] 2nd button of the sidebar: General information on the report and the compartment => item number '''2010-2090'''


[[File:JavaEfileWindow.png | border]]
[[File:Number3Sidebar.png|30 px]] 3rd button of the sidebar: General information on the compartment => item number '''3010-3050'''


:: Section 1 <span style="color: #868686"> <small>''(sub-section of section 3)''</small/> </span> General information on the unit/share class => item number '''4010-4100'''


'''Result:''' the Encryption Module is launched
:: Section 2 <span style="color: #868686"> <small>''(sub-section of section 3)''</small/> </span> Financial information on the unit/share class for the reference month => item number '''5010-5090'''


[[File:Config.jpg |500 px]]
[[File:Number4Sidebar.png|30 px]] 4th button of the sidebar. Information on the investment income and expenses of the reference month in the fund’s currency => '''6010-6100'''


'''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/''' .
= File transmission =


Step 1: The form is completed. Click the '''Transmit''' button.


[[File:AfterU11GreenTicks.png|500 px]]


'''Result:''' the EfileCrypto.jnlp file will be generated.


4. The encryption module has to be configured when it is used for the first time (or after each Java update).
'''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'''.
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:Config.jpg |500 px]]


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 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:EncryptionTaskbar.png |border]]
Step 2: Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg | 250 px]]


'''Result:''' the window below opens


[[File:JavaEfileWindow.png | border]]
 




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




'''Result''': as the configuration of the encryption module is finished, the General Tab of the Encryption Module will be displayed directly.  
Step 3: Click the [[File:RunButton.png | border]] button


[[File:FATCA send.jpg |500 px]]
[[File:JavaEfileWindow.png | border]]


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


-the file name is automatically generated and compliant to the ACD file naming convention.
[[File:2tmm.png | 500px]]


-the [[File:SendButton.png | border]] button is now available and the report can be sent. A pop-up window will confirm the transmission.
'''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/''' .




==Error messages==




===Message: The process takes too much time...===


[[File:ErrorTransmission.png|border]]
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 error message occurs when the encryption module is not started in time.
[[File:2tmm.png | 500px]]


- Please ensure that pop-ups are enabled for https://www.e-file.lu.
Once the key has been imported, the access to the keystore is memorized by the application.


- When clicking the "Transmission" button the file '''EfileCrypto.jnlp''' has to be downloaded in order to launch the encryption module. You have to open this file with '''Java Web Start Launcher''' to run the module.
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.


- Please ensure that your e-file workstation is correctly configured[[Encryption Module#Installation of the e-file v2 workstation| => Installation of a new e-file v2 workstation]]
If you need to end the process, click 🔼 icon in the taskbar, right click the e-file icon and select “Close Transmission Module” :


[[File:2Tmet.png |250 px]]






===Message : Waiting files to transmit...===
[[File:WaitingFile.png|border]]


This error might occur when there is a connection problem between your '''proxy''' and the '''encryption module V2'''.


Close the encryption module :
Step 5: Return to the form screen of the Report Generator
- Click the [[File:Transmission.png | border]] button
- Enter a "title of file sent"
- Enter the keystore password


[[File:EncryptionTaskbar.png |border]]


Open the Java console (Cf. [[Encryption_Module|Encryption Module_6.8 Show the console in case of other Java issue]]) and check the logs.
'''Result''': as the configuration of the Transmission module is finished, the General Tab of the Transmission Module will be displayed directly.  


If an '''error 407''' appears, it means that the encryption module is not able to authenticate on your proxy.
[[File:Icon22.png | 500px]]


As a consequence all communications with E-file are blocked.
'''Note''':


In that case the solutions to resolve this problem are the following :
-the file name is automatically generated and compliant to the supervisory authoritie´s file naming convention.


*Add the group "'''NoAuthenticated exception group'''" to your proxy for '''www.e-file.lu'''
-the [[File:SendButton.png | border]] button is now available and the report can be sent. A pop-up window will confirm the transmission.
*By-pass the proxy for the communication with '''www.e-file.lu'''


For more information please call the Helpdesk.


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 ==


=== Transmission status ===
Step 1: Click the Document management icon
[[File:DocMmgt icon.png|650 px]]
'''IMPORTANT:''' if the Document management icon is not available on your screen, you might contact your '''e-file administrator''' of your company, who will add the reporting module to your e-file account.
'''IMPORTANT:'''
The transmission follow-up of the below mentioned reportings is not yet available in e-file v2 (https://www.e-file.lu/e-file/).
The transmission follow-up of these reportings can only be done in e-file v1 (https://www.e-file.lu).
Credit institutions : TPTBBL, TPTBBN, TPTBHR, TPTBHR, TPTBHN
Securitisation Vehicles : S2.14, S2.15, TPTTBS
Financial Companies: S2.16, S2.17, TPTIBS
'''Result:''' the Transmission follow-up screen of the Document management opens
[[File:A.jpg]]
Step 2: Select the Transmission period (From...To) and click the Search button
[[File:2_From_To.jpg]]
'''Result:''' The XML files and their transmission status are displayed.
[[File:Final follow up.jpg]]
* "'''Transmitted'''" means that the report has been sent to the ACD.
* "'''Feedback Received'''" means that at least one feedback has been received. It also means that the ACD was able to read your report.
* "'''To validate'''" means that the report needs to be validated by the declarant on E-file V2. This is a really specific case.
=== View submitted reports and feedback files ===
Step 1: click on the blue Plus icon [[File:Plus icon.png]] at the right end of the row
[[File:Right corner.jpg]]
'''Result:''' a pop-up window opens displaying the Detail of sending
[[File:listFiles.png|border]]
Example:
* '''FATCA''' = Original report
* '''FDBTEC''' = Technical feedback
* '''FDBBUS''' = Business feedback






== File transmission follow-up ==


Step 2: Click the View button [[File:Loupe.png]] at the right end of the row
PLEASE CONSULT OUR WIKIPAGE [[Transmission follow-up|TRANSMISSION FOLLOW UP]]
 
[[File:listFiles.png|border]]
 
 
'''Result:''' the EfileCrypto.jnlp file is generated
 
'''IMPORTANT:''' This file has to be '''downloaded''' locally on your computer and must be '''opened''' to launch the encryption module
 
 
 
 
Step 3: Click the Open button of the EfileCrypto.jnlp file
 
[[File:Jplg.jpg]]
 
 
'''Result:''' a Java window opens
 
[[File:JavaEfileWindow.png | border]]
 
 
 
 
Step 4 : Click the [[File:RunButton.png | border]] button
 
[[File:JavaEfileWindow.png | border]]
 
 
'''Result:''' the Encryption Module is launched
 
[[File:E.jpg]]
 
 
 
 
Step 5: Select the General tab of the Encryption module, enter your keystore password and click the download button
 
[[File:E.jpg]]
 
 
'''Result:''' the file will be downloaded.




Line 302: Line 191:
! scope="col" | '''NCA'''
! scope="col" | '''NCA'''
! scope="col" | '''Reporting population'''
! scope="col" | '''Reporting population'''
! scope="col" | '''e-file User Guide'''
! scope="col" | <small>''Fundsquare product <br /> catalog reference''</small/>
! scope="col" | <small>''Fundsquare product <br /> catalog reference''</small/>
|<span style="color: #868686"> <small>''Internal <br /> Technical <br /> Business ID''</small/> </span>
|<span style="color: #868686"> <small>''Internal <br /> Technical <br /> Business ID''</small/> </span>
Line 309: Line 197:
||Security by security report – Balance sheet data–Luxembourg
||Security by security report – Balance sheet data–Luxembourg
||BCL
||BCL
||Credit institutions
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
Line 317: Line 204:
||Security by security report – Balance sheet data – Luxembourg
||Security by security report – Balance sheet data – Luxembourg
||BCL
||BCL
||Credit institutions
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
Line 325: Line 211:
||Security by security report – Off-balance sheet data – Resident customers
||Security by security report – Off-balance sheet data – Resident customers
||BCL
||BCL
||Credit institutions
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
Line 333: Line 218:
||Security by security report – Off-balance sheet data – Non-resident
||Security by security report – Off-balance sheet data – Non-resident
||BCL
||BCL
||Credit institutions
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
Line 341: Line 225:
||Yearly financial information
||Yearly financial information
||CSSF
||CSSF
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>  
Line 349: Line 232:
||Interventions on the futures and options markets
||Interventions on the futures and options markets
||CSSF
||CSSF
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>  
Line 357: Line 239:
||Monthly financial information for guaranteed funds
||Monthly financial information for guaranteed funds
||CSSF
||CSSF
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
Line 365: Line 246:
||Monthly financial information UCITS and UCI
||Monthly financial information UCITS and UCI
||CSSF
||CSSF
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||[[U11|U1.1 - Frequently Asked Questions]]
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
Line 373: Line 253:
||Monthly statistical balance sheet for money market funds (MMF)
||Monthly statistical balance sheet for money market funds (MMF)
||BCL
||BCL
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_InvestmentFundReporting_EN.pdf Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)]
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
|-
|-
|S1.6||Monthly statistical balance sheet for money market funds (MMF)
|S1.6||Monthly statistical balance sheet for non-money market funds (non-MMF)
||BCL
||BCL
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_InvestmentFundReporting_EN.pdf Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)]
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
Line 388: Line 266:
||Quarterly statistical balance sheet for non-MMF investment funds
||Quarterly statistical balance sheet for non-MMF investment funds
||BCL
||BCL
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_InvestmentFundReporting_EN.pdf Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)]
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
Line 396: Line 273:
||Monthly Security by security reporting for investment funds
||Monthly Security by security reporting for investment funds
||BCL
||BCL
||Investment Funds
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_InvestmentFundReporting_EN.pdf Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)]
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''1.1''</small/> </span>  
||<span style="color: #868686"> <small>''8''</small/> </span>   
||<span style="color: #868686"> <small>''8''</small/> </span>   
Line 404: Line 280:
||Quarterly statistical balance
||Quarterly statistical balance
||BCL
||BCL
||Securitisation Vehicles
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_Securitisation%20vehicles_EN.pdf TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236]
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
Line 411: Line 286:
|S2.15||Transactions and write-offs/write-downs on securitised loans
|S2.15||Transactions and write-offs/write-downs on securitised loans
||BCL
||BCL
||Securitisation Vehicles
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_Securitisation%20vehicles_EN.pdf TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236)]
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
Line 419: Line 293:
||Security by security reporting
||Security by security reporting
||BCL
||BCL
||Securitisation Vehicles
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_Securitisation%20vehicles_EN.pdf TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236]
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
Line 427: Line 300:
||Quarterly statistical balance of Financial Companies
||Quarterly statistical balance of Financial Companies
||BCL
||BCL
||Financial Companies
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_SocietesFinancieres_EN.pdf Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)]
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
Line 435: Line 307:
||Transactions of Financial Companies
||Transactions of Financial Companies
||BCL
||BCL
||Financial Companies
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_SocietesFinancieres_EN.pdf Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)]
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
Line 443: Line 314:
||Monthly security by security reporting of Financial Companies
||Monthly security by security reporting of Financial Companies
||BCL
||BCL
||Financial Companies
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_SocietesFinancieres_EN.pdf Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)]
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''2.1.12''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
||<span style="color: #868686"> <small>''35''</small/> </span>
|-
||S0218-L
||Quarterly statistical balance sheet of insurance corporations – Luxembourg entity
||BCL
||[[ProductCoverage#Insurance_Corporations|Insurance Corporations]]
||<span style="color: #868686"> <small>''2.1.21''</small/> </span>
||<span style="color: #868686"> <small>''63''</small/> </span>
|-
||S0219-L
||Information on valuation effects on the balance sheet of insurance corporations
||BCL
||[[ProductCoverage#Insurance_Corporations|Insurance Corporations]]
||<span style="color: #868686"> <small>''2.1.21''</small/> </span>
||<span style="color: #868686"> <small>''63''</small/> </span>
|-
||S0403-L
||Annual Premiums, claims and commissions of insurance corporations – Luxembourg entity
||BCL
||[[ProductCoverage#Insurance_Corporations|Insurance Corporations]]
||<span style="color: #868686"> <small>''2.1.21''</small/> </span>
||<span style="color: #868686"> <small>''63''</small/> </span>
|-
||TPTASS
||Monthly Security by security reporting of insurance corporations
||BCL
||[[ProductCoverage#Insurance_Corporations|Insurance Corporations]]
||<span style="color: #868686"> <small>''2.1.21''</small/> </span>
||<span style="color: #868686"> <small>''63''</small/> </span>
|-
|-
||FATCA
||FATCA
||Foreign Account Tax Compliance Act Reporting
||Foreign Account Tax Compliance Act Reporting
||ACD
||ACD
||Financial Institutions
||[[ProductCoverage#Financial Institutions - Foreign Account Tax Compliance Act (FATCA)|Financial Institutions - Foreign Account Tax Compliance Act (FATCA)]]
||[[FATCA_Manual|(-) FATCA - User Guide]] <br /> [[FATCA|(-) FATCA - Onboarding & FAQ]]
||<span style="color: #868686"> <small>''(-) 2.1.19 <br /> (-) 2.2''</small/> </span>
||<span style="color: #868686"> <small>''(-) 2.1.19 <br /> (-) 2.2''</small/> </span>
||<span style="color: #868686"> <small>''60''</small/> </span>
||<span style="color: #868686"> <small>''60''</small/> </span>
Line 459: Line 356:
||Automatic exchange of financial account information on a global level
||Automatic exchange of financial account information on a global level
||ACD
||ACD
||Financial Institutions
||[[ProductCoverage#Financial Institutions - Common Reporting Standard (CRS)|Financial Institutions - Common Reporting Standard (CRS)]]
||[[CRS_Manual|(-) CRS - User Guide]] <br /> [[CRS|(-) CRS - Onboarding & FAQ]]
||<span style="color: #868686"> <small>''(-) 2.1.22 <br /> (-) 2.3''</small/> </span>
||<span style="color: #868686"> <small>''(-) 2.1.22 <br /> (-) 2.3''</small/> </span>
||<span style="color: #868686"> <small>''68''</small/> </span>
||<span style="color: #868686"> <small>''68''</small/> </span>
Line 467: Line 363:
</div>
</div>


[[Category: FAQ e-file]]
 
=Set your download directory=
 
You can set your default download directory
The set-up depends of your Web browser.
 
 
== Google Chrome ==
 
[[File:Chrome Option.jpg| left]]
 
First step, open the ''settings'' option :
 
''In Chrome > the 3 points > settings ''
 
 
<br><br>
<br style="clear:both;" />
 
 
[[File:Chrome Download.jpg| left]]
Write '''download''' in the search bar<br>
 
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
Then two possibilities
* Choose a '''default directory''' (A)
* Choose '''to be asked each time where save the file''' before downloading (B)
 
 
<br style="clear:both;" />
 
 
 
== Internet Explorer ==
 
[[File:IE_Download.jpg| left]]
 
First step, open the ''View Download'' option :
 
''In Internet Explorer > Tools button > View downloads ''
 
<br><br>
<br style="clear:both;" />
 
 
[[File:IE_Download_Options.jpg| left]]
In the View Downloads dialog box, select '''Options''' in the lower-left<br>
 
Then browse to the desire '''Download location''' and validate the folder
 
 
 
<br style="clear:both;" />

Revision as of 10:44, 9 March 2021

Home page Return homepage


Introduction

Our Report Generator generates your XML reporting using the data from your form you completed before.



Select Test or Production environment

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

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



E-file login

Enter your e-file login credentials (user name and password) and click the Access button

Transmision follow up-Login .png

IMPORTANT: If you do not have an e-file user account, you might contact your e-file administrator of your company.

=>for more detailed information please click the link e-file Administration



E-file launchpad

Once your are logged in, the e-file launchpad opens.

Click on the Report Generation icon.

Launchpad.png

Select your report type

Please be informed that the PICK A SUB-MODULE functionality did not change in the new e-file version.

Once you have clicked on the Report Generation icon, the window OPEN A SUB-MODULE pops-up. Click on PICK A SUB-MODULE.

A drop-down list opens from which you have to select your reporting type. In our example we will select the U1.1 report.

Then, click on the LAUNCH REPORT button. The U1.1 form opens.

BeforeAfterPickSubModule2.png



Form

Final U11Form.png

A New warning: no auto saving.

B Vertical navigation bar: pages open vertically. Buttons remain red if data are missing/wrong.

C Calendar to pick the reference date.

D Icons to select Report status.

E Click on NEXT STEP / PREVIOUS STEP to switch to the next/previous page or click on one of the sidebar navigation buttons.

F Select an existing report button: This button allows you to upload an existing XML report from your network or hard-drive into the report generator.

G Save locally button: Work in progress on a report has to be saved with this button. Work in progress means that the report is not finalized, because important data are missing. 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. If you save locally a final report, meaning that all relevant data are available inside the report, it will carry the correct naming convention for submission to the Regulator.

H Transmit button: If the four buttons of the sidebar are green, the Transmission button will become available and the report can be transmitted to the regulator.

I EXCEL button: Press this button to export an uncompleted or finalized report in EXCEL format. This file serves for your internal purpose only, however it cannot be imported.


IMPORTANT INFORMATION on where you can find the item numbers of CIRCULAR CSSF 15/627 U1.1 reporting in the different sections of the form:

Number1Sidebar.png 1st button of the sidebar: General information on the report and the sender => item number 1010-1050

Number2Sidebar.png 2nd button of the sidebar: General information on the report and the compartment => item number 2010-2090

Number3Sidebar.png 3rd button of the sidebar: General information on the compartment => item number 3010-3050

Section 1 (sub-section of section 3) General information on the unit/share class => item number 4010-4100
Section 2 (sub-section of section 3) Financial information on the unit/share class for the reference month => item number 5010-5090

Number4Sidebar.png 4th button of the sidebar. Information on the investment income and expenses of the reference month in the fund’s currency => 6010-6100

File transmission

Step 1: The form is completed. Click the Transmit button.

AfterU11GreenTicks.png

Result: the EfileCrypto.jnlp file will be 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.



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, click 🔼 icon in the taskbar, right click the e-file icon and select “Close Transmission Module” :

2Tmet.png



Step 5: Return to the form screen of the Report Generator
- 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 supervisory authoritie´s 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



List of all reportings that can be created manually with our Report generator

Report type Details NCA Reporting population Fundsquare product
catalog reference
Internal
Technical
Business ID
TPTBBL Security by security report – Balance sheet data–Luxembourg BCL Credit Institutions 2.1.6 20
TPTBBN Security by security report – Balance sheet data – Luxembourg BCL Credit Institutions 2.1.6 20
TPTBHR Security by security report – Off-balance sheet data – Resident customers BCL Credit Institutions 2.1.6 20
TPTBHN Security by security report – Off-balance sheet data – Non-resident BCL Credit Institutions 2.1.6 20
O4.1 Yearly financial information CSSF Investment Funds 1.1 8
O4.2 Interventions on the futures and options markets CSSF Investment Funds 1.1 8
O1.2 Monthly financial information for guaranteed funds CSSF Investment Funds 1.1 8
U1.1 Monthly financial information UCITS and UCI CSSF Investment Funds 1.1 8
S1.3 Monthly statistical balance sheet for money market funds (MMF) BCL Investment Funds 1.1 8
S1.6 Monthly statistical balance sheet for non-money market funds (non-MMF) BCL Investment Funds 1.1 8
S2.13 Quarterly statistical balance sheet for non-MMF investment funds BCL Investment Funds 1.1 8
TPTOBS Monthly Security by security reporting for investment funds BCL Investment Funds 1.1 8
S2.14 Quarterly statistical balance BCL Securitisation Vehicles 2.1.9 23
S2.15 Transactions and write-offs/write-downs on securitised loans BCL Securitisation Vehicles 2.1.9 23
TPTTBS Security by security reporting BCL Securitisation Vehicles 2.1.9 23
S2.16 Quarterly statistical balance of Financial Companies BCL Financial Companies 2.1.12 35
S2.17 Transactions of Financial Companies BCL Financial Companies 2.1.12 35
TPTIBS Monthly security by security reporting of Financial Companies BCL Financial Companies 2.1.12 35
S0218-L Quarterly statistical balance sheet of insurance corporations – Luxembourg entity BCL Insurance Corporations 2.1.21 63
S0219-L Information on valuation effects on the balance sheet of insurance corporations BCL Insurance Corporations 2.1.21 63
S0403-L Annual Premiums, claims and commissions of insurance corporations – Luxembourg entity BCL Insurance Corporations 2.1.21 63
TPTASS Monthly Security by security reporting of insurance corporations BCL Insurance Corporations 2.1.21 63
FATCA Foreign Account Tax Compliance Act Reporting ACD Financial Institutions - Foreign Account Tax Compliance Act (FATCA) (-) 2.1.19
(-) 2.2
60
CRS Automatic exchange of financial account information on a global level ACD Financial Institutions - Common Reporting Standard (CRS) (-) 2.1.22
(-) 2.3
68


Set your download directory

You can set your default download directory The set-up depends of your Web browser.


Google Chrome

Chrome Option.jpg

First step, open the settings option :

In Chrome > the 3 points > settings






Chrome Download.jpg

Write download in the search bar



































Then two possibilities

  • Choose a default directory (A)
  • Choose to be asked each time where save the file before downloading (B)




Internet Explorer

IE Download.jpg

First step, open the View Download option :

In Internet Explorer > Tools button > View downloads





IE Download Options.jpg

In the View Downloads dialog box, select Options in the lower-left

Then browse to the desire Download location and validate the folder