FLCMonit

What is the FundLifeCycle Monitoring all about?

Fundsquare S.A. is launching a new monitoring tool for the acquisition and management of fund raw data & reporting into meaningful and useful information for operational efficiency analysis purposes.


The tool provides KPIs on

Fund Launch & closing

• Statistics on number of funds in each step of the launch & closing workflow

Fund Commercialization

• Statistics on the number of reports to Home and Host authorities for a given time range

User Guide

Access to the application

• Connect to e-file (https://www.e-file.lu/e-file/)

• In the launchpad, click on « FundLifeCycle - Monitoring »

Should the module FundLifeCycle - Monitoring be greyed out, please contact your local e-file Administrator to add your user to this module.

With Internet Explorer, if the FundLifeCycle opens in a new window (and not in a new tab), you will not be able to benefit from all the functionalities. In order to change your parameters to open a new page in a new tab:

1. Click the Tools button of Internet Explorer, and then click Internet Options.
2. In the General tab, click on the Tabs button.
3. Under When a pop-up is encountered, choose Always open pop-ups in a new tab.

General Options

In each screen, the following options are available :

• Undo

Everytime that an action is done on a page (apply a filter, include or exclude items, …), it is possible to undo the action with that button.

• Redo

Used to re-do an action (Only available after a “Undo” was done).

• Revert

This button permits to undo all actions done so far on the page, and to revert to the initial view.

• Refresh/Pause

Those buttons are not applicable for FundLifeCycle.

• Download

PDF: Downloads one or several views depending on the options selected. The pdf generated will only illustrate the default view and may not contain all information (if a slider is necessary in the view).

Crosstab: Downloads a file openable with excel (only possible after a specific table has been selected).

Warning: the file is not created as a .xls file, your computer may not recognize it. The file contains the gross data, which may be hard to interpret. No layouting is available. The functionality is simply available in the software solution Fundsquare has chosen to deploy the FundLifeCycle.

Data: Lists the data without having to download them. It is however possible to download them in a text format.

Warning: the file is not created as a .txt file, your computer may not recognize it. The file contains the gross data, which may be hard to interpret. No layouting is available. The functionality is simply available in the software solution Fundsquare has chosen to deploy the FundLifeCycle.

Image: Downloads the current view as a .png picture.

For most of the views, a Dashboard report exists in your Dashboard module. Those reports are more suitable as download.

General Information

The “Dashboard” synthetises the information about the funds of the Management Company to which you provide services.
The screen is divided in 5 different sections:

• Funds universe

This view represents the number of active funds/sub-funds/share classes for which you are Fund Administrator which are known by Fundsquare.

• E-file filing

This view represents the number of regulatory reports sent to each of the National Competent Authorities during the last 12 months.

• NAV Transmitted

This view represents the number of NAV loaded for each day in the last 3 months. By flying over with the mouse, it is possible to see the exact number for each day.

• Documents loaded in library

This view represents the number of documents loaded onto your efile library for the funds you are servicing as Fund Administrator. It is possible to select only the document loaded by the Fund Administrator itself or all documents regardless of the document providers.

NB: The documents associated to the entities are not yet listed (eg. FATCA for an entity).

• Management Companies

This view lists all the funds for which you are Fund Administrator and their management companies. It is possible to select one or several management companies. All the 4 other parts will be updated accordingly.

NAV’s transmitted to Fundsquare

General Information

The “NAV’s transmitted to Fundsquare” view represents the number of NAV’s transmitted to Fundsquare for each fund every day.

Information Types

Different kinds of information are displayed:

• The number of NAV’s received for the fund (in green in the example below).
• The number of excuses received for the fund (in orange in the example below), see definition below.
• The number of missing NAV’s (in red in the example below), those are NAV not received (yet) but for which no excuses were indicated.
• The opening of new shares (blue triangle).
• The closing of shares (red triangle).
  

It is also possible to filter on a specific management company.

Definition of an excuse

An excuse is a concept created by Fundsquare to indicate in advance that no NAV is expected for a share class for a day or for a longer period. The most common reasons why no NAV are expected are the following:

• The market in which the main investments of the share class are done is closed for a bank holiday,
• The share is a dormant share (i.e. the share has been fully redeemed but remains open and can be reactivated in the future),
• The share is waiting for initial subscription,
• The share is in process of liquidation,
• There has been a suspension of the NAV calculation.

NAV’s transmitted to Fundsquare - Details

General Information

The “NAV’s transmitted to Fundsquare - Details” view represents the number of NAV’s received by Fundsquare for each share class every day. This is a detailed view of “NAV’s transmitted to Fundsquare”.

Apply filters

The following filters can be applied :

• Fund Name

Useful when dealing with a large number of funds to quickly select a subset of them.

• CSSF Fund Code

This code is given to a fund by the CSSF upon registration of the fund at the CSSF.

• Sub-fund Name

Usually used after the Fund Name is selected, to make a quick subfilter.

• Frequency

Useful to distinguish the expected delivery frequency. By default, “daily” funds are selected.

• ISIN

Useful to quickly search a specific share class.

• NAV Date / Reception date

the NAV Date is the value date of the NAV, the reception date corresponds to the date and the timestamp on which the NAV was transmitted to Fundsquare.

• All / Last Month

With this option it is possible to either select the NAV received during the past month (31 days-to-date) or during the past 3 months-to-date.

• Line Type

There are three types of line:

• Received (at least one NAV was received),
• Excuse (an excuse was set for that day meaning that Fundsquare is not expecting any NAV for this day),
• Missing (no NAV received yet).

Status

Six different types of entry exist :

• Before launch date (left empty triangle)

this entry means that the NAV was received before the share class was launched (this is a data quality issue).

NB: If this entry is an excuse (orange), this is most probably an excuse indicating “Waiting for initial subscription”. If this entry is missing (red), it means that there are excuses or prices missing between the constitution date and the date when the first NAV was received.

• First (left filled triangle)

this entry means that it is the first NAV received for the share class (same date as the launching date of the share class).

• Single (square)

this entry means that one NAV was expected that day (standard situation)

• Multi (star)

this entry means that several NAV’s were received that day. If the NAV date is selected, it means that several NAV’s were received for the same value date. If the reception date is selected, it could also mean that the NAV of different days were received on the same day.

• Last (right filled triangle)

this entry means that it is the last NAV received for the share class (same date as the end date of the share class).

• After closing date (right empty triangle)

this entry means that the NAV was received after the share class was closed (this could most likely be a data quality issue or a case of liquidation).

It is possible to filter on a specific entry type by clicking on the status in the legend (top right corner) and clicking on “keep only”.