Our Report Generator generates your XML reporting using the data you entered when you completed manually the e-form.
How to access the Report Generator
Step 1: Select your environment
Production environment : https://www.e-file.lu/e-file/
Homologation environment (Test) : https://homologation.e-file.lu/e-file/
Step 2: 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 or if you do not remember your password, you might contact your e-file administrator of your company.
Step 3: Click on the Report Generation icon
Step 4: Select the report type
Step 5: Complete the form
When all ticks are green, you can transmit the report to the regulator by clicking the Transmission button.
Export - import files - save work in progress
1. Export in XML format: Click this button to export the final report in XML format. The file will be saved on your hard drive and can be uploaded for later filing to the regulator. This button will only be available if the green tick appears in every section of the completed form.
2. Select a report: This button allows you to upload an existing XML report from your network or hard drive into the report generator.
3. Export draft: 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.
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 Transmission Module.
Result: the window below opens
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).
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 Transmission module will then run as a back ground process on your desktop.
If you need to end the process, click 🔼 icon in the taskbar, right click the e-file icon and select “Close Transmission Module” :
Step 5: Return to the form screen of the Report Generator - Click the button - Enter a "title of file sent" - Enter the keystore password
Result: as the configuration of the Transmission module is finished, the General Tab of the Transmission Module will be displayed directly.
-the file name is automatically generated and compliant to the supervisory authoritie´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 FOLLOW UP
List of all reportings that can be created manually with our Report generator
|Report type||Details||NCA||Reporting population|| Fundsquare product
| Internal |
|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 money market funds (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
|CRS||Automatic exchange of financial account information on a global level||ACD||Financial Institutions - Common Reporting Standard (CRS)|| (-) 2.1.22