ReportGeneration

From E-fileWiki
Revision as of 21:17, 30 April 2018 by User (talk | contribs)
Jump to navigation Jump to search
Home page Return homepage


Introduction

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

Identification.jpg

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 3: Click on the Report Generation icon

Fatca ReportGen.jpg




Step 4: Select the report type

Generating a report.png




Step 5: Complete the form

CompleteForm.png


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

Export.jpg

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

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




File transmission

Step 1: The form is completed GreenIcon.png. Click the Transmission.png 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 Transmission Module.




Step 2: Click the Open button of the EfileCrypto.jnlp file Jplg.jpg

Result: the window below opens

JavaEfileWindow.png




Step 3: Click the RunButton.png button

JavaEfileWindow.png Result: the Transmission Module is launched

2tmm.png

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

2tmm.png

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

2Tmet.png



Step 5: Return to the form screen of the Report Generator
- Click the Transmission.png 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.

Icon22.png

Note:

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

-the SendButton.png 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 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
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 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
(-) 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