Difference between revisions of "ReportGeneration"

From E-fileWiki
Jump to navigation Jump to search
 
(81 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>


= List of all reportings that can be generated manually through our '''XML file generator''' =
__TOC__


==Credit institutions==
=Select your report type=


<div style="text-align: left;">
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.


{| border="1" cellspacing="2" cellpadding="10"
[[File:BeforeAfterPickSubModule2.png| 300 px]]


||'''Report type'''
||'''Details'''
||'''Fundsquare product <br /> catalog reference'''
||'''NCA'''
||'''Circular
||'''e-file User Guide'''
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
||TPTBBL
||Security by security report – Balance sheet data–Luxembourg
||2.1.6
||BCL
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_TpTCreditInstitution_EN.pdf Transmission Manual for Bank SBS reporting (BCL 2014/235)]
||<span style="color: #868686"> <small>''20''</small/> </span>
|-
||TPTBBN
||Security by security report – Balance sheet data – Luxembourg
||2.1.6
||BCL
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_TpTCreditInstitution_EN.pdf Transmission Manual for Bank SBS reporting (BCL 2014/235)]
||<span style="color: #868686"> <small>''20''</small/> </span>
|-
||TPTBHR
||Security by security report – Off-balance sheet data – Resident customers
||2.1.6||BCL
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_TpTCreditInstitution_EN.pdf Transmission Manual for Bank SBS reporting (BCL 2014/235)]
||<span style="color: #868686"> <small>''20''</small/> </span>
|-
||TPTBHN
||Security by security report– <br /> Off-balance sheet data– <br /> Non-resident
||2.1.6||BCL
||[http://www.bcl.lu/fr/reporting_reglementaire/Etablissements_credit/Statistiques-bancaires-et-monetaires/Instructions/index.html BCL Reporting Instructions]
||[https://www.e-file.lu/docs/EN/ManuUtil_EFile_Transmission_TpTCreditInstitution_EN.pdf Transmission Manual for Bank SBS reporting (BCL 2014/235)]
||<span style="color: #868686"> <small>''20''</small/> </span>


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


= Transmit =


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


<div style="text-align: left;">


{| border="1" cellspacing="2" cellpadding="10"


||'''Report type'''
'''Result:''' A pop-up window will confirm the transmission.
||'''Details'''
||'''Fundsquare product <br /> catalog reference'''
||'''NCA'''
||'''Circular
||'''e-file User Guide'''
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
||O4.1
||Yearly financial information
||1.1
||CSSF
||[http://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/iml97_136eng_amended.pdf Circular IML 97/136]
||-
||<span style="color: #868686"> <small>''8''</small/> </span>
|-
||O4.2
||Interventions on the futures and options markets
||1.1
||CSSF
||[http://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/iml97_136eng_amended.pdf Circular IML 97/136]
||-
||<span style="color: #868686"> <small>''8''</small/> </span>
|-
||O1.2
||Monthly financial information for guaranteed funds
||1.1
||CSSF
||[http://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/iml97_136eng_amended.pdf Circular IML 97/136]
||-
||<span style="color: #868686"> <small>''8''</small/> </span> 
|-
||U1.1
||Monthly financial information UCITS and UCI
||1.1
||CSSF
||[https://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/cssf15_627eng.pdf (-) Circular CSSF 15/627] <br /> [http://www.cssf.lu/fileadmin/files/Lois_reglements/Circulaires/Hors_blanchiment_terrorisme/cssf12_540eng.pdf (-) CIRCULAR CSSF 12/540]
||[[U11|U1.1 - Frequently Asked Questions]]
||<span style="color: #868686"> <small>''8''</small/> </span> 
|-
|S1.3
||Monthly statistical balance sheet for money market funds (MMF)
||1.1
||BCL
||[http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/index.html Regulatory Reporting 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>''8''</small/> </span> 
|-
|S1.6||Monthly statistical balance sheet for money market funds (MMF)||1.1||BCL||[http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/index.html Regulatory Reporting 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>''8''</small/> </span> 
|-
|S2.13
||Quarterly statistical balance sheet for non-MMF investment funds
||1.1
||BCL
||[http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/index.html Regulatory Reporting 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>''8''</small/> </span> 
|-
|TPTOBS
||Monthly Security by security reporting for investment funds
||1.1
||BCL
||[http://www.bcl.lu/en/Regulatory-reporting/Fonds_Investissement/index.html Regulatory Reporting 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>''8''</small/> </span> 


|}
[[File:REPORT_TRANSMISSION_confirm.png| border]]


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


==Securitisation Vehicles==
= Links to specific forms user manuals =


<div style="text-align: left;">
[[AIFMD form|<span style= "display: inline-block;
 
background-color: #009ACE;
{| border="1" cellspacing="2" cellpadding="10"
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
|-
width: 8%;  height: auto; 
|'''Report type'''
border: none;  border-style: outset;  border-radius: 10px; 
||'''Details'''
padding: 0.5%;  margin: 1%;">
||'''Fundsquare product <br /> catalog reference'''
AIFMD form</span>]]
||'''NCA'''
[[CRS Manual|<span style= "display: inline-block;
||'''Circular
background-color: #009ACE;
||'''e-file User Guide'''
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
width: 8%;  height: auto; 
|-
border: none;  border-style: outset;  border-radius: 10px; 
|S2.14
padding: 0.5%; margin: 1%;">
||Quarterly statistical balance
CRS Manual</span>]]
||2.1.9
[[FATCA Manual|<span style= "display: inline-block;
||BCL
background-color: #009ACE;
||[http://www.bcl.lu/en/Legal-Framework/documents_national/circulaires_bcl/_circulaires/2014/Circulaire_2014_236/Circular_BCL_2014-236_EN.pdf (-) Circular 2014/236] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Vehicules_de_titrisation/index.html (-) BCL Securitation vehicles]
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
||[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]
width: 8%;  height: auto; 
||<span style="color: #868686"> <small>''23''</small/> </span>
border: none;  border-style: outset; border-radius: 10px; 
|-
padding: 0.5%;  margin: 1%;">
|S2.15||Transactions and write-offs/write-downs on securitised loans||2.1.9||BCL||[http://www.bcl.lu/en/Legal-Framework/documents_national/circulaires_bcl/_circulaires/2014/Circulaire_2014_236/Circular_BCL_2014-236_EN.pdf (-) Circular 2014/236] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Vehicules_de_titrisation/index.html (-) BCL Securitation 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)]
FATCA Manual</span>]]
||<span style="color: #868686"> <small>''23''</small/> </span>
[[CAA Manual|<span style= "display: inline-block;
|-
background-color: #009ACE;
|TPTTBS
color: white; text-align: center; font-family: sans-serif; font-size:0.8vw;
||Security by security reporting
width: 8%;  height: auto; 
||2.1.9
border: none;  border-style: outset;  border-radius: 10px; 
||BCL
padding: 0.5%;  margin: 1%;">
||[http://www.bcl.lu/en/Legal-Framework/documents_national/circulaires_bcl/_circulaires/2014/Circulaire_2014_236/Circular_BCL_2014-236_EN.pdf (-) Circular 2014/236] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Vehicules_de_titrisation/index.html (-) BCL Securitation vehicles]
CAA Manual</span>]]
||[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>''23''</small/> </span>
 
|}
 
 
 
 
==Financial Companies==
 
<div style="text-align: left;">
 
{| border="1" cellspacing="2" cellpadding="10"
 
||'''Report type'''
||'''Details'''
||'''Fundsquare product <br /> catalog reference'''
||'''NCA'''
||'''Circular
||'''e-file User Guide'''
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
||S2.16||Quarterly statistical balance of Financial Companies||2.1.12||BCL||[http://www.bcl.lu/en/Legal-Framework/documents_national/regulations/Annexes-2014_17/20140807_Rglmt_8_Modif_EN_FINAL_CLEANx.pdf (-) Regulation  2014/17] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Societes_financieres/index.html (-) 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>''35''</small/> </span>
|-
||S2.17||Transactions of Financial Companies||2.1.12||BCL||[http://www.bcl.lu/en/Legal-Framework/documents_national/regulations/Annexes-2014_17/20140807_Rglmt_8_Modif_EN_FINAL_CLEANx.pdf (-) Regulation 2014/17] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Societes_financieres/index.html (-) 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>''35''</small/> </span>
|-
||TPTIBS||Monthly security by security reporting of Financial Companies||2.1.12||BCL||[http://www.bcl.lu/en/Legal-Framework/documents_national/regulations/Annexes-2014_17/20140807_Rglmt_8_Modif_EN_FINAL_CLEANx.pdf (-) Regulation  2014/17] <br /> [http://www.bcl.lu/en/Regulatory-reporting/Societes_financieres/index.html (-) 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>''35''</small/> </span>
 
|}
 
 
 
 
==Financial Institutions - Foreign Account Tax Compliance Act (FATCA)==
 
<div style="text-align: left;">
 
{| border="1" cellspacing="2" cellpadding="10"
 
||'''Report type'''
||'''Details'''
||'''Fundsquare product <br /> catalog reference'''
||'''NCA'''
||'''Circular
||'''e-file User Guide'''
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
||FATCA
||Foreign Account Tax Compliance Act Reporting
||(-) 2.1.19 <br /> (-) 2.2
||ACD
||[http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/echa3-sans-tc-2017-01-19.pdf (-) Circulaire ECHA - n° 3 du 19 janvier 2017] <br /> [http://www.impotsdirects.public.lu/fr/echanges_electroniques/FATCA.html (-) ACD-FATCA]
||[[FATCA_Manual|(-) FATCA Manual]] <br /> [[FATCA|(-) FATCA FAQ]]
||<span style="color: #868686"> <small>''60''</small/> </span>
 
|}
 
 
 
 
==Financial Institutions - Common Reporting Standard (CRS)==
 
<div style="text-align: left;">
 
{| border="1" cellspacing="2" cellpadding="10"
 
||'''Report type'''
||'''Details'''
||'''Fundsquare product <br /> catalog reference'''
||'''NCA'''
||'''Circular
||'''e-file User Guide'''
||<span style="color: #868686"> <small>''Internal Technical <br /> Business ID''</small/> </span>
|-
||CRS
||Automatic exchange of financial account information on a global level
||(-) 2.1.22 <br /> (-) 2.3
||ACD
||[http://www.impotsdirects.public.lu/fr/echanges_electroniques/CRS_NCD.html (-) ACD-CRS] <br /> [http://www.impotsdirects.public.lu/fr/archive/newsletter/2017/nl_06022017.html (-) Newsletter 06/02/2017] <br /> [http://www.impotsdirects.public.lu/content/dam/acd/fr/legislation/legi17/ECHA4.pdf (-) ECHA-n°4 06/02/2017]
||'''[[CRS_Manual|(-) Wiki-CRS Manual]]''' <br /> [[CRS|(-) CRS FAQ]]
||<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"