Difference between revisions of "ReportGeneration"
(71 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> | ||
= List of all reportings that can be | |||
=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]] | |||
=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. | |||
[[File:BeforeAfterPickSubModule2.png| 300 px]] | |||
=Form= | |||
[[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”. | |||
<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. | |||
[[File:REPORT TRANSMISSION confirm.png | border]] | |||
'''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 [[Transmission Module#Solving the most common problems|SOLVING THE MOST COMMON PROBLEMS OF THE TRANSMISSION MODULE]] OR CONTACT OUR [[How to contact us|'''Client Support & Operations Desk''']]. | |||
== File transmission follow-up == | |||
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;"> | <div style="text-align: left;"> | ||
Line 7: | Line 155: | ||
{| border="1" cellspacing="2" cellpadding="10" | {| 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 | ||TPTBBL | ||
||Security by security report – Balance sheet data–Luxembourg | ||Security by security report – Balance sheet data–Luxembourg | ||
||BCL | ||BCL | ||
||Credit | ||[[ProductCoverage#Credit Institutions|Credit Institutions]] | ||
| | |||
||<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 26: | Line 172: | ||
||Security by security report – Balance sheet data – Luxembourg | ||Security by security report – Balance sheet data – Luxembourg | ||
||BCL | ||BCL | ||
||Credit | ||[[ProductCoverage#Credit Institutions|Credit Institutions]] | ||
| | |||
||<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 34: | 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 | ||[[ProductCoverage#Credit Institutions|Credit Institutions]] | ||
| | |||
||<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 42: | 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 | ||[[ProductCoverage#Credit Institutions|Credit Institutions]] | ||
| | |||
||<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 50: | 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 58: | 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 66: | 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 74: | Line 214: | ||
||Monthly financial information UCITS and UCI | ||Monthly financial information UCITS and UCI | ||
||CSSF | ||CSSF | ||
||[[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 82: | 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]] | ||
||<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]] | ||
||<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 97: | 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]] | ||
||<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 105: | 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]] | ||
||<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 113: | Line 248: | ||
||Quarterly statistical balance | ||Quarterly statistical balance | ||
||BCL | ||BCL | ||
||Securitisation Vehicles | ||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]] | ||
||<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 120: | 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]] | ||
||<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 128: | Line 261: | ||
||Security by security reporting | ||Security by security reporting | ||
||BCL | ||BCL | ||
||Securitisation Vehicles | ||[[ProductCoverage#Securitisation_Vehicles|Securitisation Vehicles]] | ||
||<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 136: | Line 268: | ||
||Quarterly statistical balance of Financial Companies | ||Quarterly statistical balance of Financial Companies | ||
||BCL | ||BCL | ||
|| | ||[[ProductCoverage#Financial_Companies|Financial Companies]] | ||
| | |||
||<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 144: | Line 275: | ||
||Transactions of Financial Companies | ||Transactions of Financial Companies | ||
||BCL | ||BCL | ||
|| | ||[[ProductCoverage#Financial_Companies|Financial Companies]] | ||
| | |||
||<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 152: | Line 282: | ||
||Monthly security by security reporting of Financial Companies | ||Monthly security by security reporting of Financial Companies | ||
||BCL | ||BCL | ||
|| | ||[[ProductCoverage#Financial_Companies|Financial Companies]] | ||
| | |||
||<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 - Foreign Account Tax Compliance Act (FATCA) | ||[[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>''(-) 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 168: | 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 - Common Reporting Standard (CRS) | ||[[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>''(-) 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 176: | Line 331: | ||
</div> | </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 == | |||
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
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
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.
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.
Form
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:
1st button of the sidebar: General information on the report and the sender => item number 1010-1050
2nd button of the sidebar: General information on the report and the compartment => item number 2010-2090
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
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.
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).
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
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.
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
First step, open the settings option :
In Chrome > the 3 points > settings
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)