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:
<small>''Page's last update : {{REVISIONDAY2}} {{CURRENTMONTHABBREV}} {{REVISIONYEAR}}''</small>
<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=
__TOC__


Our Report Generator allows you to create your reports manually.
=Select your report type=


Once you have clicked on the '''Report Generation''' icon, the  window '''OPEN A SUB-MODULE''' pops-up.
* Click on '''PICK A SUB-MODULE'''.
* Select your reporting type.
* Click on the '''LAUNCH REPORT''' button. The form opens.


==How to access the Report Generator==
[[File:BeforeAfterPickSubModule2.png| 300 px]]




===Environment===
<span id="hereFill"></span>
=Fill the form=


Step 1: Select your environment
<imagemap>
File:ReportGeneration.png|900px|alt=clickable image : form description| titre
rect 746 25 717 0 [[#hereFill|This button allows you to upload an existing XML report from your network or hard-drive into the form.]]
rect 839 29 819 5 [[#hereFill|Save the report on your disk. If the report is not finished, it will be called DRAFT_filename.xml and cannot be sent to the regulator, it can be imported again for later use. If it is finished it will carry the correct naming convention for submission to the Regulator.]]
rect 885 5 910 26 [[#hereFill|If all the buttons of the vertical navigation bar are green, the Transmit button will become available and the report can be transmitted to the regulator.]]
rect 950 5 970 25 [[#hereFill|Press this button to export a report in EXCEL format. This file is for your internal use only, but it cannot be imported again. ]]
rect 30 299 5 77 [[#hereFill|Vertical navigation bar: pages open vertically. Buttons remain red if data are missing/wrong.]]
rect 227 214 264 244 [[#hereFill|Calendar to pick the reference date.]]
rect 108 269 432 377 [[#hereFill|Icons to select Report status.]]
rect 107 432 297 444 [[#hereFill|If something is wrong, an error message occurs]]
rect 162 566 103 545 [[#hereFill|Add more lines for this section]]
rect 83 55 554 80 [[#hereFill|warning: no auto saving]]
desc none
</imagemap>
Once the form is completed, click the '''Transmit''' button.


Production environment : '''https://www.e-file.lu/e-file/'''
<span id="hereTrans"></span>


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


<imagemap>
File:ReportGeneration_transmission.png|500px|alt=clickable image : form description| titre
rect 38 113 173 168 [[#hereTrans|You enter in the transmission part.]]
rect 395 306 219 116 [[#Configure the keystore|If a warning is displayed, click to configure your keystore.]]
rect 42 1095 189 1161 [[#hereTrans|The Transmit button is available when all is as expected. ]]
circle 230 771 108 [[#hereTrans|Fill the fields, mandatories have a red star.]]
circle 347 464 66 [[#hereTrans|Here are displayed the recipients of your reports.]]
desc none
</imagemap>






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


Step 1: Enter your e-file login credentials (user name and password) and click the Access button
[[File:REPORT_TRANSMISSION_confirm.png| border]]


[[File:Identification.jpg]]
'''Note:''' The file name is automatically generated and compliant to the supervisory authority's file naming convention.


'''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.
<span id="hereConf"></span>
= Configure the keystore=


[[E-file Administration|=>e-file Administration]]
<imagemap>
File:ReportGeneration_keystore.png|500px|alt=clickable image : form description| titre
rect 25  111  166  163 [[#Transmit| Once done  click 'Transmission' to go back to the transmission part.]]
rect 27  439  861  689 [[#hereConf| Add a .ks file either by drag-and-drop or by the 'Browse Files' button.]]
rect 31  734  348  827 [[#hereConf| Tick the box to keep your changes.]]
desc none
</imagemap>


= Links to specific forms user manuals =


Step 1: Click on the Report Generation icon
[[AIFMD form|<span style= "display: inline-block;
[[File:Fatca ReportGen.jpg]]
  background-color: #009ACE;
 
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
 
width: 8%; height: auto;  
  Step 2: Select the report type
  border: none;  border-style: outset; border-radius: 10px; 
[[File:Generating a report.png | 500 px]]
padding: 0.5%; margin: 1%;">
 
AIFMD form</span>]]
 
[[CRS Manual|<span style= "display: inline-block;
Step 3: The form opens
background-color: #009ACE;
 
  color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
 
width: 8%; height: auto;  
Step 4: Complete the form
  border: none; border-style: outset; border-radius: 10px;  
 
  padding: 0.5%; margin: 1%;">
 
CRS Manual</span>]]
== Export - import files - save work in progress  ==
[[FATCA Manual|<span style= "display: inline-block;
 
background-color: #009ACE;
 
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
[[File:Export.jpg]]
width: 8%;  height: auto; 
 
border: none;  border-style: outset; border-radius: 10px; 
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.
  padding: 0.5%;  margin: 1%;">
 
FATCA Manual</span>]]
2. This button allows you to upload an existing XML report from your network or hard drive into the report generator.
[[CAA Manual|<span style= "display: inline-block;
 
background-color: #009ACE;
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.
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
 
width: 8%;  height: auto; 
4.If green ticks [[File:GreenIcon.png]] appear in every section of the completed form, the Transmission button will become available.
border: none;  border-style: outset;  border-radius: 10px; 
 
padding: 0.5%;  margin: 1%;">
 
CAA Manual</span>]]
 
 
== File transmission ==
 
 
  1. The form is completed [[File:GreenIcon.png]]. Click the [[File:Transmission.png | border]] button.
 
'''Result:''' the EfileCrypto.jnlp file is generated.
 
'''IMPORTANT:''' this file has to be '''downloaded''' (if you use the application for the first time) locally on your computer and must be '''opened''' to launch the '''Encryption 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 | 250 px]]
 
'''Result:''' the window below opens
 
[[File:JavaEfileWindow.png | border]]
 
 
 
 
  3. Click the [[File:RunButton.png | border]] button
 
[[File:JavaEfileWindow.png | border]]
'''Result:''' the Transmission Module is launched
 
[[File:2tmm.png | 500px]]
 
'''Important:''' It is possible that the pop-up blocker does not allow .jnlp files to be downloaded. Please ask your IT deparment to allow pop-ups from '''https://www.e-file.lu/''' .
 
 
 
 
 
 
  Step 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/>
 
[[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 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 Transmission Module” :
 
[[File:2Tmet.png |250 px]]
 
 
 
 
 
 
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 Transmission Module will be displayed directly.
 
[[File:Icon22.png | 500px]]
 
'''Note''':
 
-the file name is automatically generated and compliant to the supervisory authoritie´s 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.
 
 
'''SHOULD YOU ENCOUNTER PROBLEMS PLEASE CONSULT OUR WIKIPAGE [[Encryption Module#Solving the most common problems|SOLVING THE MOST COMMON PROBLEMS OF THE TRANSMISSION MODULE]] OR CONTACT OUR [[How_to_contact_us#Technical_support|HELPDESK]]
 
 
==Error messages==
 
 
===Message: The process takes too much time...===
 
[[File:ErrorTransmission.png|border]]
 
The error message occurs when the encryption module is not started in time.
 
- Please ensure that pop-ups are enabled for https://www.e-file.lu.
 
- 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.
 
- 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]]
 
 
 
 
===Message : Waiting files to transmit...===
 
[[File:Icon17.png| 600 px]]
 
This message might occur when there is a connection problem between your '''proxy''' and the '''encryption module V2'''.
 
Close the encryption module :
 
[[File:2Tmet.png |250 px]]
 
[[Encryption_Module#Show the console in case of other Java issue|Activate the Java Console]], try to resend your files 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 ==
 
=== 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
 
 
 
 
  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.
 
 
 
 
 
= List of all reportings that can be created manually with our '''Report generator''' =
 
<div style="text-align: left;">
 
{| border="1" cellspacing="2" cellpadding="10"
 
! scope="col" | '''Report type'''
! scope="col" | '''Details'''
! scope="col" | '''NCA'''
! scope="col" | '''Reporting population'''
! scope="col" | '''e-file User Guide'''
! scope="col" | <small>''Fundsquare product <br /> catalog reference''</small/>
|<span style="color: #868686"> <small>''Internal <br /> Technical <br /> Business ID''</small/> </span>
|-
||TPTBBL
||Security by security report – Balance sheet data–Luxembourg
||BCL
||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>''20''</small/> </span>
|-
||TPTBBN
||Security by security report – Balance sheet data – Luxembourg
||BCL
||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>''20''</small/> </span>
|-
||TPTBHR
||Security by security report – Off-balance sheet data – Resident customers
||BCL
||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>''20''</small/> </span>
|-
||TPTBHN
||Security by security report – Off-balance sheet data – Non-resident
||BCL
||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>''20''</small/> </span>
|-
||O4.1
||Yearly financial information
||CSSF
||Investment Funds
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span>
|-
||O4.2
||Interventions on the futures and options markets
||CSSF
||Investment Funds
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span>
|-
||O1.2
||Monthly financial information for guaranteed funds
||CSSF
||Investment Funds
||-
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span>  
|-
||U1.1
||Monthly financial information UCITS and UCI
||CSSF
||Investment Funds
||[[U11|U1.1 - Frequently Asked Questions]]
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span>  
|-
|S1.3
||Monthly statistical balance sheet for money market funds (MMF)
||BCL
||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>''8''</small/> </span> 
|-
|S1.6||Monthly statistical balance sheet for money market funds (MMF)
||BCL
||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>''8''</small/> </span> 
|-
|S2.13
||Quarterly statistical balance sheet for non-MMF investment funds
||BCL
||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>''8''</small/> </span> 
|-
|TPTOBS
||Monthly Security by security reporting for investment funds
||BCL
||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>''8''</small/> </span> 
|-
|S2.14
||Quarterly statistical balance
||BCL
||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>''23''</small/> </span>
|-
|S2.15||Transactions and write-offs/write-downs on securitised loans
||BCL
||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>''23''</small/> </span>
|-
|TPTTBS
||Security by security reporting
||BCL
||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>''23''</small/> </span>
|-
||S2.16
||Quarterly statistical balance of Financial Companies
||BCL
||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>''35''</small/> </span>
|-
||S2.17
||Transactions of Financial Companies
||BCL
||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>''35''</small/> </span>
|-
||TPTIBS
||Monthly security by security reporting of Financial Companies
||BCL
||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>''35''</small/> </span>
|-
||FATCA
||Foreign Account Tax Compliance Act Reporting
||ACD
||Financial Institutions
||[[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>''60''</small/> </span>
|-
||CRS
||Automatic exchange of financial account information on a global level
||ACD
||Financial Institutions
||[[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>''68''</small/> </span>
 
|}
</div>
 
[[Category: FAQ e-file]]

Latest revision as of 15:50, 19 September 2024

Page's last update : 19 Nov 2024

Home page Return homepage

Select your report type

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

  • Click on PICK A SUB-MODULE.
  • Select your reporting type.
  • Click on the LAUNCH REPORT button. The form opens.

BeforeAfterPickSubModule2.png


Fill the form

This button allows you to upload an existing XML report from your network or hard-drive into the form.Save the report on your disk. If the report is not finished, it will be called DRAFT_filename.xml and cannot be sent to the regulator, it can be imported again for later use. If it is finished it will carry the correct naming convention for submission to the Regulator.If all the buttons of the vertical navigation bar are green, the Transmit button will become available and the report can be transmitted to the regulator.Press this button to export a report in EXCEL format. This file is for your internal use only, but it cannot be imported again.Vertical navigation bar: pages open vertically. Buttons remain red if data are missing/wrong.Calendar to pick the reference date.Icons to select Report status.If something is wrong, an error message occursAdd more lines for this sectionwarning: no auto savingclickable image : form description

Once the form is completed, click the Transmit button.

Transmit

You enter in the transmission part.If a warning is displayed, click to configure your keystore.The Transmit button is available when all is as expected.Fill the fields, mandatories have a red star.Here are displayed the recipients of your reports.clickable image : form description


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.

Configure the keystore

Once done click 'Transmission' to go back to the transmission part.Add a .ks file either by drag-and-drop or by the 'Browse Files' button.Tick the box to keep your changes.clickable image : form description

Links to specific forms user manuals

AIFMD form CRS Manual FATCA Manual CAA Manual

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