Difference between revisions of "ReportGeneration"

From E-fileWiki
Jump to navigation Jump to search
 
(67 intermediate revisions by 2 users 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.


=Select Test or Production environment=


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


Step 1: Select your environment
Homologation environment (Test) : '''https://homologation.e-file.lu'''


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


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




=E-file login=


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


===Login===
[[File:Transmision follow up-Login .png|250 px]]


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, you might contact your '''e-file administrator''' of your company.


[[File:Identification.jpg]]
[[E-file Administration|=>for more detailed information please click the link '''e-file Administration''']]


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


[[E-file Administration|=>E-file Administration]]




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


=E-file launchpad=


Step 2: Select the report type
Once your are logged in, the e-file launchpad opens.
[[File:Generating a report.png]]


Click on the '''Report Generation''' icon.


Step 3: The form opens
[[File:Report_generation.png]]


=Select your report type=


Step 4: Complete the form
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'''.


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


[[File:Export.jpg]]
[[File:BeforeAfterPickSubModule2.png| 300 px]]


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.


=Form=


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


<span style="background:yellow"> '''A'''</span> '''New warning''': no auto saving.


== File transmission ==
<span style="background:yellow"> '''B'''</span> '''Vertical navigation bar''': pages open vertically. Buttons remain red if data are missing/wrong.


<span style="background:yellow"> '''C'''</span> '''Calendar''' to pick the reference date.


=== Setup of the e-file v2 encryption module v2 ===
<span style="background:yellow"> '''D'''</span> '''Icons''' to select Report status.


1. The form is completed [[File:GreenIcon.png]]. Click the [[File:Transmission.png | border]] button.
<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.


'''Result:''' the EfileCrypto.jnlp file is generated.
<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.  


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


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


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




<u>IMPORTANT INFORMATION on where you can find  the '''item numbers''' of [https://www.cssf.lu/en/Document/circular-cssf-15-627 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'''


2. Click the Open button of the EfileCrypto.jnlp file [[File:Jplg.jpg]]
[[File:Number2Sidebar.png|30 px]] 2nd button of the sidebar: General information on the report and the compartment => item number '''2010-2090'''


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


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


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


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


[[File:JavaEfileWindow.png | border]]
Step 1: Once the form is completed, click the '''Transmit''' button.


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


'''Result:''' the Encryption Module is launched
'''Result:''' The REPORT TRANSMISSION window opens.


[[File:Config.jpg |border]]


'''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 2: Configure the REPORT TRANSMISSION when it is used for the first time (or after each certificate update).


4. The encryption 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:Config.jpg |border]]
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]]




[[File:REPORT TRANSMISSION configure.png | border]]
 
<span style="background:yellow"> '''a)'''</span> Under the sub-menu <span style="color: #8fbc8f">'''Configuration'''</span>, the path to the keystore should be selected using the button BROWSE FILES or via Drag&Drop.


<span style="background:yellow"> '''b)'''</span> Make sure to select “Save keystore settings” so that the file is memorized by the application.


5. Return to the form 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.


[[File:FATCA send.jpg]]
Step 3: Fill in the TRANSMISSION SETTINGS and Transmit


'''Note''':
[[File:REPORT TRANSMISSION transmission.png | border]]


-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.
<span style="background:yellow"> '''a)'''</span> Activate the <span style="color: #8fbc8f">'''Transmission'''</span> sub-menu.


<span style="background:yellow"> '''b)'''</span> Enter a “Title of the sending”.


===Error messages===
<span style="background:yellow"> '''c)'''</span> Enter the Keystore password.


<span style="background:yellow"> '''d)'''</span> Click “TRANSMIT” to submit your report.


====Message: The process takes too much time. Please restart the encryption module.====


[[File:ErrorTransmission.png|border]]
'''Result:''' A pop-up window will confirm the transmission.


The error message occurs when the encryption module is not started in time.


Please check that the pop-up are enable for the site https://www.e-file.lu.
[[File:REPORT TRANSMISSION confirm.png | border]]


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.


'''Note:''' The file name is automatically generated and compliant to the supervisory authority's file naming convention.


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


If an '''error 407''' appears, it means that the encryption module is not able to authenticate on your proxy.
As a consequence all communications with E-file are blocked.
In that case the solutions to resolve this problem are the following :
*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.




== File transmission follow-up ==
== File transmission follow-up ==


=== Transmission status ===
PLEASE CONSULT OUR WIKIPAGE [[Transmission Monitoring|Transmission Monitoring]]
 
Step 1: Click the Document management icon
 
[[File:DocMmgt icon.png]]
 
'''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 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
 
 
 
 
Step 2: Click the View button [[File:Loupe.png]] at the right end of the row
 
[[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.
 
 
'''IMPORTANT:''' if the encryption module takes too much time to be opened or if the file EfileCrpyto has not been executed, the following message will pop up and you will have to click one more time on the View button.
 
[[File:N.jpg]]
 
 
'''IMPORTANT:''' If it is the first time you are using the encryption module, you may be asked for the '''keystore location''' in the Configuration tab.
 
The '''keystore file''' (file with the extension '''.ks''') contains your '''Luxtrust certificate''' and is protected with a '''password'''. If you do not have the keystore or its password, please contact your '''e-file administrator'''.
 
 
 
 
 
 
 
 


= List of all reportings that can be created manually with our '''Report generator''' =
= List of all reportings that can be created manually with our '''Report generator''' =
Line 310: Line 155:
{| border="1" cellspacing="2" cellpadding="10"
{| border="1" cellspacing="2" cellpadding="10"


||'''Report type'''
! scope="col" | '''Report type'''
||'''Details'''
! scope="col" | '''Details'''
||'''NCA'''
! scope="col" | '''NCA'''
||'''Reporting population'''
! scope="col" | '''Reporting population'''
||'''e-file User Guide'''
! scope="col" | <small>''Fundsquare product <br /> catalog reference''</small/>
||<span style="color: #868686"> <small>''Fundsquare product <br /> catalog reference''</small/> </span>
|<span style="color: #868686"> <small>''Internal <br /> Technical <br /> Business ID''</small/> </span>
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
|-
||TPTBBL
||TPTBBL
||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 329: Line 172:
||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 337: Line 179:
||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 345: Line 186:
||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 353: Line 193:
||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 361: Line 200:
||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 369: Line 207:
||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 377: Line 214:
||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 385: Line 221:
||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 400: Line 234:
||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 408: Line 241:
||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 416: Line 248:
||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 423: Line 254:
|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 431: Line 261:
||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 439: Line 268:
||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 447: Line 275:
||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 455: Line 282:
||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 471: Line 324:
||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 479: Line 331:
</div>
</div>


[[Category: FAQ e-file]]
 
=Set your download directory=
 
You can set your default download directory.</br>
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;" />
 
 
 
== Edge ==
See: [https://support.microsoft.com/en-us/microsoft-edge/change-the-downloads-folder-location-in-microsoft-edge-4049e93b-0ef6-e44f-aca0-7d5f37a39294 Change download location on Edge by Microsoft]

Latest revision as of 12:08, 14 September 2023

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.

Report generation.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 v2.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.

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: Once the form is completed, click the Transmit button.

AfterU11GreenTicks.png

Result: The REPORT TRANSMISSION window opens. 



Step 2: Configure the REPORT TRANSMISSION when it is used for the first time (or after each certificate update).


REPORT TRANSMISSION configure.png

a) Under the sub-menu Configuration, the path to the keystore should be selected using the button BROWSE FILES or via Drag&Drop.

b) Make sure to select “Save keystore settings” so that the file is memorized by the application. 



Step 3: Fill in the TRANSMISSION SETTINGS and Transmit

REPORT TRANSMISSION transmission.png


a) Activate the Transmission sub-menu.

b) Enter a “Title of the sending”.

c) Enter the Keystore password.

d) Click “TRANSMIT” to submit your report.


Result: A pop-up window will confirm the transmission.


REPORT TRANSMISSION confirm.png


Note: The file name is automatically generated and compliant to the supervisory authority's file naming convention.


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 Monitoring

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)




Edge

See: Change download location on Edge by Microsoft

Retrieved from "http://www.e-file.lu/wiki/index.php?title=ReportGeneration&oldid=6808"