ReportGeneration

Home page

Report generation

Our Report Generator allows you to create your reports manually.

How to access the Report Generator

Environment

Step 1: Select your environment

Production environment : https://www.e-file.lu/e-file/

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

Login

Step 1: 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.

=>e-file Administration

Step 1: Click on the Report Generation icon

Step 2: Select the report type

Step 3: The form opens

Step 4: Complete the form

Export - import files - save work in progress

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 appears in every section of the completed form.

2. This button allows you to upload an existing XML report from your network or hard drive into the report generator.

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.

4.If green ticks appear in every section of the completed form, the Transmission button will become available.

File transmission

1. The form is completed . Click the  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 

Result: the window below opens

3. Click the  button

Result: the Transmission Module is launched

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 button and the key (locally or on a server) will have to be imported with the button :

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

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 encryption module is finished, the General Tab of the Transmission Module will be displayed directly.

Note:

-the file name is automatically generated and compliant to the supervisory authoritie´s file naming convention.

-the 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 SOLVING THE MOST COMMON PROBLEMS OF THE TRANSMISSION MODULE OR CONTACT OUR HELPDESK

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	e-file User Guide	Fundsquare product catalog reference	Internal Technical Business ID
TPTBBL	Security by security report – Balance sheet data–Luxembourg	BCL	Credit institutions	BCL Reporting Instructions	2.1.6	20
TPTBBN	Security by security report – Balance sheet data – Luxembourg	BCL	Credit institutions	BCL Reporting Instructions	2.1.6	20
TPTBHR	Security by security report – Off-balance sheet data – Resident customers	BCL	Credit institutions	BCL Reporting Instructions	2.1.6	20
TPTBHN	Security by security report – Off-balance sheet data – Non-resident	BCL	Credit institutions	BCL Reporting Instructions	2.1.6	20
O4.1	Yearly financial information	CSSF	[[ProductCoverage#Investment_Funds|Investment Funds]	-	1.1	8
O4.2	Interventions on the futures and options markets	CSSF	[[ProductCoverage#Investment_Funds|Investment Funds]	-	1.1	8
O1.2	Monthly financial information for guaranteed funds	CSSF	[[ProductCoverage#Investment_Funds|Investment Funds]	-	1.1	8
U1.1	Monthly financial information UCITS and UCI	CSSF	[[ProductCoverage#Investment_Funds|Investment Funds]	U1.1 - Frequently Asked Questions	1.1	8
S1.3	Monthly statistical balance sheet for money market funds (MMF)	BCL	[[ProductCoverage#Investment_Funds|Investment Funds]	Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)	1.1	8
S1.6	Monthly statistical balance sheet for money market funds (MMF)	BCL	[[ProductCoverage#Investment_Funds|Investment Funds]	Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)	1.1	8
S2.13	Quarterly statistical balance sheet for non-MMF investment funds	BCL	[[ProductCoverage#Investment_Funds|Investment Funds]	Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)	1.1	8
TPTOBS	Monthly Security by security reporting for investment funds	BCL	[[ProductCoverage#Investment_Funds|Investment Funds]	Transmission Manual for Investment Fund reporting (BCL 2014/234 and CSSF 14/588)	1.1	8
S2.14	Quarterly statistical balance	BCL	Securitisation Vehicles	TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236	2.1.9	23
S2.15	Transactions and write-offs/write-downs on securitised loans	BCL	Securitisation Vehicles	TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236)	2.1.9	23
TPTTBS	Security by security reporting	BCL	Securitisation Vehicles	TRANSMISSION MANUAL FOR SECURITISATION VEHICLES REPORTING ACCORDING TO BCL 2014/236	2.1.9	23
S2.16	Quarterly statistical balance of Financial Companies	BCL	Financial Companies	Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)	2.1.12	35
S2.17	Transactions of Financial Companies	BCL	Financial Companies	Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)	2.1.12	35
TPTIBS	Monthly security by security reporting of Financial Companies	BCL	Financial Companies	Transmission Manual for Financial Companies (BCL 2011/8 and 2014/17)	2.1.12	35
S0218-L	Quarterly statistical balance sheet of insurance corporations – Luxembourg entity	BCL	Insurance Corporations		(-) Circular 2015/239 Reporting instructions	2.1.21	63
S0219-L	Information on valuation effects on the balance sheet of insurance corporations	BCL	Insurance Corporations		(-) Circular 2015/239 Reporting instructions	2.1.21	63
S0403-L	Annual Premiums, claims and commissions of insurance corporations – Luxembourg entity	BCL	Insurance Corporations		(-) Circular 2015/239 Reporting instructions	2.1.21	63
TPTASS	Monthly Security by security reporting of insurance corporations	BCL	Insurance Corporations		(-) Circular 2015/239 Reporting instructions	2.1.21	63
FATCA	Foreign Account Tax Compliance Act Reporting	ACD	Financial Institutions - Foreign Account Tax Compliance Act (FATCA)	(-) FATCA - User Guide (-) FATCA - Onboarding & FAQ	(-) 2.1.19 (-) 2.2	60
CRS	Automatic exchange of financial account information on a global level	ACD	Financial Institutions - Common Reporting Standard (CRS)	(-) CRS - User Guide (-) CRS - Onboarding & FAQ	(-) 2.1.22 (-) 2.3	68