Difference between revisions of "ReportGeneration"

From E-fileWiki
Jump to navigation Jump to search
Line 1: Line 1:
<small>''Page's last update : 14 September 2023''</small>
<small>''Page's last update : {{REVISIONDAY2}} {{CURRENTMONTHABBREV}} {{REVISIONYEAR}}''</small>


__TOC__
__TOC__


<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>
=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
[[File:Transmision follow up-Login .png|250 px]]
'''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''']]
=E-file launchpad=
Once your are logged in, the e-file launchpad opens.
Click on the '''Report Generation''' icon.


[[File:Report_generation.png]]
[[File:Report_generation.png]]
Line 44: Line 9:
=Select your report type=
=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'''.  
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.
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:BeforeAfterPickSubModule2.png| 300 px]]
[[File:BeforeAfterPickSubModule2.png| 300 px]]




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


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


<span id="hereTrans"></span>


=Form=
= Transmit =
 
[[File:Final U11Form_v2.png|800 px]]
 
<span style="background:yellow"> '''A'''</span> '''New warning''': no auto saving.
 
<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.
 
<span style="background:yellow"> '''D'''</span> '''Icons''' to select Report status.
 
<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.
 
<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>.
 
 
 
<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'''
 
[[File:Number2Sidebar.png|30 px]] 2nd button of the sidebar: General information on the report and the compartment => item number '''2010-2090'''
 
[[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'''
 
:: 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'''
 
= File transmission =
 
Step 1: Once the form is completed, click the '''Transmit''' button.
 
[[File:AfterU11GreenTicks.png|500 px]]
 
'''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).
 
 
 
[[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.
 
 
 
 
Step 3: Fill in the TRANSMISSION SETTINGS and Transmit
 
[[File:REPORT TRANSMISSION transmission.png | border]]
 
 
<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”.
<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>


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




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


 
[[File:REPORT_TRANSMISSION_confirm.png| border]]
[[File:REPORT TRANSMISSION confirm.png | border]]
 


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


<span id="hereConf"></span>
= Configure the keystore=


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


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''']].
= Links to specific forms user manuals =
 
 
 
 
 
== File transmission follow-up ==
 
PLEASE CONSULT OUR WIKIPAGE [[Transmission Monitoring|Transmission Monitoring]]
 
= 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" | <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
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||<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
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||<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
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||<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
||[[ProductCoverage#Credit Institutions|Credit Institutions]]
||<span style="color: #868686"> <small>''2.1.6''</small/> </span>
||<span style="color: #868686"> <small>''20''</small/> </span>
|-
||O4.1
||Yearly financial information
||CSSF
||[[ProductCoverage#Investment_Funds|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
||[[ProductCoverage#Investment_Funds|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
||[[ProductCoverage#Investment_Funds|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
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||<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
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span> 
|-
|S1.6||Monthly statistical balance sheet for non-money market funds (non-MMF)
||BCL
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||<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
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||<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
||[[ProductCoverage#Investment_Funds|Investment Funds]]
||<span style="color: #868686"> <small>''1.1''</small/> </span>
||<span style="color: #868686"> <small>''8''</small/> </span> 
|-
|S2.14
||Quarterly statistical balance
||BCL
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||<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
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||<span style="color: #868686"> <small>''2.1.9''</small/> </span>
||<span style="color: #868686"> <small>''23''</small/> </span>
|-
|TPTTBS
||Security by security reporting
||BCL
||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]]
||<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
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||<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
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||<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
||[[ProductCoverage#Financial_Companies|Financial Companies]]
||<span style="color: #868686"> <small>''2.1.12''</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
||Foreign Account Tax Compliance Act Reporting
||ACD
||[[ProductCoverage#Financial Institutions - Foreign Account Tax Compliance Act (FATCA)|Financial Institutions - Foreign Account Tax Compliance Act (FATCA)]]
||<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
||[[ProductCoverage#Financial Institutions - Common Reporting Standard (CRS)|Financial Institutions - Common Reporting Standard (CRS)]]
||<span style="color: #868686"> <small>''(-) 2.1.22 <br /> (-) 2.3''</small/> </span>
||<span style="color: #868686"> <small>''68''</small/> </span>
 
|}
</div>
 
 
=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 ==
[[AIFMD form|<span style= "display: inline-block;
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]
background-color: #009ACE;
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
width: 8%;  height: auto; 
border: none;  border-style: outset;  border-radius: 10px; 
padding: 0.5%;  margin: 1%;">
AIFMD form</span>]]
[[CRS Manual|<span style= "display: inline-block;
background-color: #009ACE;
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
width: 8%;  height: auto; 
border: none;  border-style: outset;  border-radius: 10px; 
padding: 0.5%;  margin: 1%;">
CRS Manual</span>]]
[[FATCA Manual|<span style= "display: inline-block;
background-color: #009ACE;
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
width: 8%;  height: auto; 
border: none;  border-style: outset;  border-radius: 10px; 
padding: 0.5%;  margin: 1%;">
FATCA Manual</span>]]

Revision as of 13:57, 12 September 2024

Page's last update : 12 Sep 2024

Home page Return homepage

Report generation.png

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

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