Difference between revisions of "FLCOversight"

From E-fileWiki
Jump to navigation Jump to search
(Created page with "= 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 me...")
 
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
= What is the FundLifeCycle Monitoring all about? =
= 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 purpose of  Fund Life Cycle Oversight is to give all Management Companies a view of all the activities done on their funds by themselves and/or by their providers.
<br>
<br>
[[File:100.PNG]]<br>
Management Companies will have views on :
<br>
*Registration/Distribution matrix,
The tool provides KPIs on  
*NAV’s loaded,
;Fund Launch & closing
*Regulatory Reports
*Statistics on number of funds in each step of the launch & closing workflow
*Their Library,
;Fund Commercialization
*The different Disseminations,
*Statistics on the number of reports to Home and Host authorities for a given time range
*And finally on the Order Management Services
<br><br>
This document provides “a Useful Tip”, on some views, which will lead you to different reports available on the Dashboard Module on your e-file light application.<br>
[[File:10_.png]]<br>
If you do not have this module, please contact either your provider or your Fundsquare Client Service Manager.
<br><br>
<br><br>


= User Guide =
= User Guide =
== Access to the application ==
== Access to the application ==
* Connect to e-file (https://www.e-file.lu/e-file/)
* Connect to e-file (https://www.e-file.lu/e-file/)
[[File:200.PNG]]<br><br>
[[File:20_.png]]<br><br>
* In the launchpad, click on « FundLifeCycle - Monitoring »
* In the launchpad, click on « FundLifeCycle - Oversight»
[[File:201.PNG]]<br>
[[File:21_.png]]<br>
Should the module FundLifeCycle - Monitoring be greyed out, please contact your local e-file Administrator to add your user to this module.<br><br>
If you do not see this module, please contact your Relationship Manager or your Client Service Manager. If the module is in grey, please contact your administrator who will give you the right to access it.<br>
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:  
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:  
#Click the '''Tools''' button of '''Internet Explorer''', and then click '''Internet Options'''.
#Click the '''Tools''' button of '''Internet Explorer''', and then click '''Internet Options'''.<br>[[File:22_.png]]
#In the '''General''' tab, click on the '''Tabs''' button.
#In the '''General''' tab, click on the '''Tabs''' button.<br>[[File:23_.png]]
#Under '''When a pop-up is encountered''', choose '''Always open pop-ups in a new tab'''.
#Under '''When a pop-up is encountered''', choose '''Always open pop-ups in a new tab'''.<br>[[File:24_.png]]


== General Options ==
== General Options ==
 
In each screen, the following options are available:<br>
In each screen, the following options are available :
[[File:30_.png]]<br>
 
*; Undo
*; 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.
::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.
Line 43: Line 47:
:::<u>Warning:</u> 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.
:::<u>Warning:</u> 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.<br><br>
::''Image:'' Downloads the current view as a .png picture.<br><br>
For most of the views, a Dashboard report exists in your Dashboard module. Those reports are more suitable as download.
A Dashboard report exists for most of the views in your Dashboard module. Those reports are easy to interpret.


== Dashboard ==
=== General Information ===
The “Dashboard” is the entrance screen showing the following five main parts of your activities :<br>
*;Funds universe :
::This view represents the number of active funds/sub-funds/share classes you are working on.
*;E-file filing :
::This view represents the number of all documents sent to each of the authorities in the last 12 months.
*;Your top distribution countries :
::This view lists the countries with the highest distribution of your funds. The list contains the top 10 (if there are 10 or more countries where your funds are distributed).
*;Documents loaded in library :
::This view represents the number of documents loaded in Fundsquare library for the corresponding funds.
*;Providers :
::This view lists all your providers who are using Fundsquare services and the number of corresponding funds they act on. The different roles the provider has are indicated :
::*'''Reporter''' : Entity which can publish NAV’s and sends Reportings (O, U, S and TPT)
::*'''Transfer Agent – Fundsquare routing hub''': Entity which uses Fundsquare order routing system.
::*'''All other workflows''' (FATCA sending, KIID update, …) : Entity that can create and transmit the corresponding documents for the funds of the management company (possible also for ALL the funds where the management company is also library owner)<br>
[[File:40_.png]]
= You @ Fundsquare =


== General Information ==
== General Information ==


The “Dashboard” synthetises the information about the funds of the Management Company to which you provide services. <br>
The view “You @ Fundsquare” shows your contractual situation, in other words : the subscribed services.<br>
The screen is divided in 5 different sections:
[[File:50_.png]]<br>
*;Funds universe
The details of the services can be found in our “Product catalog” pdf document available on :
::This view represents the number of active funds/sub-funds/share classes for which you are Fund Administrator  which are known by Fundsquare.  
www.fundsquare.net under menu “Services”, section “Presentation”.
*;E-file filing
<br><br>
::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.
::<u>NB:</u> 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.
[[File:300.PNG]]


= NAV’s transmitted to Fundsquare =
= Registration/Distribution Heatmap=


== General Information ==
== General information ==
The “NAV’s transmitted to Fundsquare” view represents the number of NAV’s transmitted to Fundsquare for each fund every day.<br>
The “Registration/Distribution” heatmap gives a quick global oversight of your shares in different possible status (to register, registered, distributed, …)  and their quantity.<br>
[[File:400.PNG]]
[[File:60_.png]]<br>
In the example above, we can see that the funds of the ManCo are mostly distributed in Western Europe but also a few other countries (Peru, Chile, South Korea, …).<br>
 
==Interact with the map==


== Information Types ==
By moving the mouse over the top left corner, you have different options available to interact with the map:<br><br>
Different kinds of information are displayed:  
[[File:61_.png]]<br><br>
*The number of NAV’s received for the fund (in green in the example below).
Magnifying glass : To search a country or any part of the world (Asia, Europe, Luxembourg, …)<br>
*The number of excuses received for the fund (in orange in the example below), see definition below.
+ and - : To zoom in/out.<br>
*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.
Home (house): To return to the initial view<br>
*The opening of new shares (blue triangle).
<br>
*The closing of shares (red triangle).<br>
[[File:62_.png]]<br><br>
[[File:401.PNG]]<br>
Zoom / Selection options:<br>
It is also possible to filter on a specific management company.<br>
*Zoom on a rectangle area
*Select countries in a rectangle
*Select countries in a circle
*Select countries with a free pattern<br>
It is possible to navigate on the map by holding a click and navigate with the mouse.
<br>
==Apply filters==


== Definition of an excuse ==
The following filters can be applied : <br>
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:
*'''Fund Name''' : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.<br>
*The market in which the main investments of the share class are done is closed for a bank holiday,
Example : you want to select only SIF funds and all your specialized funds contain the word “SIF”.<br>
*The share is a dormant share (i.e. the share has been fully redeemed but remains open and can be reactivated in the future),
*'''Status''' : 5 status about the registration and 3 status about the distribution exist. Each fund has a registration status and a distribution status. By default, the distribution view is visible.<br>
*The share is waiting for initial subscription,
<br>
*The share is in process of liquidation,
[[File:63_.png]]<br><br>
*There has been a suspension of the NAV calculation.
In the example above, we can see that the ManCo stopped a lot of distribution of shares in Greece.<br><br>
'''NB''' : If several statuses are selected, the view will sum up the number of entries. For example, if the “registered” and “distributed” statuses are selected, all the share classes that have both status will be counted twice.<br><br>
'''Useful tip''' : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report  2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix<br><br>


= NAV’s transmitted to Fundsquare - Details =
=Fund distribution by country=


== General Information ==
==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”.<br>
[[File:402.PNG]]


== Apply filters ==
The view “Fund distribution by country” illustrates how many share classes are distributed by fund by country.<br>
The following filters can be applied :
<br>
*;Fund Name
[[File:70_.png]]<br><br>
::Useful when dealing with a large number of funds to quickly select a subset of them.
This view can help the ManCo to realize where some funds / share classes are distributed (or not distributed). For example, the fund 8831 seems to be distributed in most countries in Europe, and we saw in the “Registration/Distribution Trend” view that Liechtenstein was one of the ManCo’s hot country. The ManCo can therefore wonder if they shouldn’t also distribute the shares of the fund 8831 in Liechtenstein.<br><br>
*;CSSF Fund Code
'''Useful tip''' : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report  2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix<br><br>
::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 ==
=Registration/Distribution Trend=
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).
::<u>NB:</u> 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.<br>
[[File:403.PNG]]
*;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).<br>
[[File:404.PNG]]
*;Single (square)
::this entry means that one NAV was expected that day (standard situation)<br>
[[File:405.PNG]]
*;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.<br>
[[File:406.PNG]]
*;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).<br>
[[File:407.PNG]]
*;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).<br>
[[File:408.PNG]]<br>
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”.<br>
[[File:409.PNG]]


== Exclude entries ==
==General information==
It is also possible to exclude entries : specific dates, specific currencies, specific funds / sub-funds / share classes.
Example : you know that for your funds, the NAV is sent the day after its value date. Therefore, all value dates of your NAV will be missing today. Therefore you want to exclude today’s NAV’s in the view.


= NAV’s loaded – Hourly view (3 months) =
The view “Registration/Distribution Trend” indicates a global trend on how many shares have reached the different possible status (to register, registered, distributed, …) .<br>
<br>
[[File:80_.png]]<br><br>
'''Example''' : In the view “Registration/Distribution Map”, we saw that Luxembourg and Switzerland were the two countries where the greatest number of share classes is distributed for the Management Company.
In this view the timeperiod is now set to display last year only; we can see that, in the past year, Liechtenstein was the country were the greatest number of share classes have been distributed.<br><br>
'''Useful tip''' : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report  2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix<br><br>


== General Information ==
=Share registration incoherence=
The “NAV’s transmitted to Fundsquare – Hourly view (3 months)” view represents the number of NAV’s received by Fundsquare for each fund at each hour of the day.<br>
[[File:410.PNG]]<br>
In the example above, we can see that, for the “Fund 100709”, 165 NAV’s have been loaded between 1pm and 2 pm during the last 3 months , we can also see that a small percentage has been received after 5 pm, which seems to be an exception.<br>
In the background, behind the number of NAV’s received per hour, a cumulated view of the NAV’s received until the specific hour (from 0 am to the hour selected) is available in a lighter color.<br>
Below that graph, a global view of all the NAV’s received for your funds is available (“Your funds”). This view gives a quick overlook of all the NAV’s loaded for your funds in the past 3 months.<br>


== Apply Filters ==
==General information==
The following filters can be applied :
*;Management Company
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*;Fund Name
::Useful when dealing with a large number of funds to quickly select a subset of them.
*;Frequency
::Useful to distinguish the expected delivery frequency. By default, “daily” funds are selected.


= NAV’s transmited – Hourly view – Details (Max 3 months) =
The view “Share registration incoherence” illustrates the registration issues of your funds in Fundsquare’s database.<br>
<br>
[[File:90_.png]]<br><br>
An incoherence is detected if share is distributed in a country but not registered : it means that this share is marked as “distributed” (D) in the matrix but has not as “registered” (R or RX). This either means that the share should not be distributed anymore in the country, or that the share should be logged as “registered” as well.<br><br>
To check the list of ISINs impacted, you can apply a country filter first if necessary and then use the “Download” button to the check the extract in excel format.<br><br>
'''Useful tip''' : you can also check this issue (classes distributed per country but not registered) going on the Dashboard and select the report 2_1-Incoherence between REG and DIST matrix (D and not R).
In order to solve them, we propose you either to change these Distributed statuses by putting a DX or insert a Registration status (R)<br><br>


== General Information ==
=NAV’s loaded – Hourly view (3 months)=
The “NAV’s transmitted – Hourly view – Details (3 months)” view represents the number of NAV’s transmitted to Fundsquareat each hour of the day. This is a detailed view of “NAV’s transmitted to Fundsquare – Hourly view (3 months)”.<br>
[[File:411.PNG]]<br>
The interest of this view is to select a fund / a sub-fund to analyze a problem detected in the previous view.<br>
[[File:412.PNG]]<br>
It is also possible to select a specific frequency (“Daily” by default), and a Reception Period (only 3 months of data is available but it is possible to select a subset of it to analyse the last month for instance).<br>


= NAV reception delay – Standard deviation =
==General information==


== General Information ==
The “NAV’s loaded Hourly view (3 months)” view represents the number of NAV’s received by Fundsquare for each fund at each hour of the day.<br>
The “NAV reception delay Standard deviation” is a statistical view.  It depicts any variation in terms of delay of a specific share class between the value date of the NAV and its transmission date.<br>
<br>
[[File:413.PNG]]<br>
[[File:100_.png]]<br><br>
The top view shows the regularity of each of your funds.<br>
In the example above, we can see that, for the “Fund 4209”, 62375 NAV’s have been loaded at 7 PM during the last 3 months.<br><br>
The bottow view compares your results (highlighted in blue) to the results of other providers.<br>
Under the number of NAV’s received by hour, a cumulated view of the NAV’s received till the specific hour (from 0 am to the hour selected) is available in a lighter color.<br><br>
<u>NB:</U>In order to compare similar funds, only daily funds have been kept and Specialized Investment Funds (SIF) have been excluded.<br>
Below that graph, a global view of all the NAV’s received for your funds is available (“Your funds”). This view gives a quick overlook of all the NAV’s loaded for your funds in the past 3 months.<br><br>


== Detailed process ==
=NAV’s transmitted to Fundsquare – Details=
For each share classe, a standard deviation of the difference between the NAV value date and the NAV reception date is calculated. This result is aggregated by fund in the first view and by provider in the second view. In the second view, your result is highlighted in blue and set on first position of the graph. The average result of each of the other providers of the marketplace are anonymized.


== Apply Filters ==
==General information==
The first filter (Fund Name) only permits to change what is displayed on the top screen (select one or several specific funds).<br>
The second filter (Fund Structure) modifies the content of  both the top and the bottom views.


= e-file filing (12 months) =
The “NAV’s transmitted to Fundsquare - Details” view represents the number of NAV’s received by Fundsquare for each share class every day.<br>
== General Information ==
<br>
The “e-file filing (12 months)”  view lists all documents sent to the different National Competent Authorities. This is a detailed view of the “e-file filing” available in the Dashboard.<br>
[[File:110_.png]]<br><br>
[[File:414.PNG]]
==Apply filters==
== Apply Filters ==
The following filters can be applied :<br>
The following filters can be applied:  
*'''Fund Name''' : Useful when dealing with a large number of funds to quickly select a subset of them.
*;Authority
*'''CSSF Fund Code''' : This code is given to a fund by the CSSF upon registration of the fund at the CSSF.
::This field is useful to restrict the data for one or several National Competent Authorities (for example, keep only the CSSF).
*'''Sub-fund Name''' : Usually used after the Fund Name is selected, to make a quick subfilter.
*;e-file
*'''ISIN''' : Useful to quickly search a specific share class.
::In e-file, different business groups are defined. Each business group is allowed to send a set of document types. This information is also the one displayed in the dashboard. This is therefore a good way to make a filter and analyze something detected in the Dashboard.
*'''Frequency''' : Useful to distinguish the expected delivery frequency. By default, “daily” funds are selected.  
*;Document Type
*'''Last Month/Last 3 Months''' : 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.
::The document type gives the detail of the type of document that was sent to the authority (for example it is possible to filter on the O1.1 reports).
==Status==
Six different types of entry exist :<br>
*'''Leftward pointing green 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).
<br>
[[File:111_.png]]<br><br>
*'''Green filled square''' : this entry means that one NAV was expected that day (standard situation)
<br>
[[File:112_.png]]<br><br>
*'''Green 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 ould also mean that the NAV of different days were received on the same day.
<br>
[[File:406.PNG]]<br><br>
*'''Rightward pointing green 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).
<br>
[[File:114_.png]]<br><br>
*'''Rightward pointing empty triangle''' : this entry means that the NAV was received after the share lass was closed ''(this could most likely be a data quality issue or a case of liquidation)''.
<br>
[[File:115_.png]]<br><br>
*'''Leftward pointing empty triangle''' : NAV received before launch date : 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.
<br>
[[File:116_.png]]<br><br>
[[File:117_.png]]<br><br>
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”.
<br>
[[File:118_.png]]<br><br>


= Regulatory reports =
==Exclude entries==
It is also possible to exclude entries : specific dates, specific currencies, specific funds / sub-funds / share classes. <br>Example : you know that for your funds, the NAV is sent the day after its value date. Therefore, all value dates of your NAV will be missing today. Therefore you want to exclude today’s NAV’s in the view.<br><br>


== General Information ==
=Regulatory reports=
The “Regulatory reports”  view represents the percentage of different regulatory reports sent on time, late or not sent yet.<br>
[[File:415.PNG]]<br>
Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far. The table gives a periodic KPI (monthly for O1.1/U1.1, yearly for O4.1) for each fund and a global periodic KPI for all the funds the Fund Administrator is working for.<br>
A global periodic Market KPI is also available to benchmark your performance against the market.


== Apply Filters ==
==General information==
The following filters can be applied :
*;Management Company
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*;Sending Date
::This filter determines which reception date is used to determine if a report was sent on time or late: with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
*;Report Type
::This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).


== Line Types ==
The “Regulatory reports”  view represents the percentage of different regulatory reports that were either sent on time, late or were not sent yet.<br>
Three different information types exist :
<br>
*;On Time
[[File:120_.png]]<br><br>
::This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far in this detailed view. The table gives a periodic KPI (monthly for O1.1/U1.1, yearly for O4.1) for each fund and a global periodic KPI for all the funds your Fund Administrator(s) is/are working for. The table shows you all the active sub-funds. A global periodic Market KPI is also available to benchmark your performance against the market.<br>
*;Late
::This entry indicates that the report was received, but after the deadline indicated above.
*;Missing
::This entry indicates that the report was not yet received.
*;Other Provider
::This entry indicates that the report has been sent by another provider.


== Data History ==
==Apply filters==
The following filters can be applied : <br>
*'''Sender''' : This filter is especially useful for Management Companies working with a lot of different Central Administrations.
*'''Sending Date''' :  This filter determines which reception date is used to determine if a report was sent on time or late : with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
*'''Report Type''' : This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).


For the '''O1.1/U1.1''', reports received in the last '''12 months-to-date''' are taken into account.<br>
==Line types==
For the '''O4.1''', reports received in the last '''4 years-to-date''' are taken into account.
Four different information types exist :
*'''On Time''' : This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
*'''Late''' : This entry indicates that the report was received, but after the deadline indicated above.
*'''Missing''' : This entry indicates that the report was not yet received.


= Regulatory reports - Details =
==Data history ==
For the '''O1.1/U1.1''', reports received in the last '''12 months'''-to-date are taken into account.
For the '''O4.1''', reports received in the last '''4 years'''-to-date are taken into account.<br><br>


== General Information ==
=Regulatory reports - Details=


The “Regulatory reports - Details”  view represents, at sub-fund level, the percentage of different regulatory reports sent on time, late or not sent yet. This is a detailed view of “Regulatory reports”.<br>
==General information==
[[File:416.PNG]]<br>
Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far.


== Apply filters ==
The “Regulatory reports - Details”  view represents, at sub-fund level, the percentage of different regulatory reports which were either sent on time, late or were not sent yet. These are the detail of the view of “Regulatory reports” explained in the chapter before.<br>
<br>
[[File:130_.png]]<br><br>
Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far in this detailed view.<br>


==Apply filters==
The following filters can be applied :  
The following filters can be applied :  
*;Fund Name
*'''Fund Name''' : Useful when dealing with a large number of funds to quickly select a subset of them.
::Useful when dealing with a large number of funds to quickly select a subset of them.
*'''Codif CSSF/Internal Code''' : This filter pilotes the Fund and Sub-Fund codes displayed in the table. It also pilotes the codification used for the filter “Fund Codification”.
*;Codif CSSF/AAC
*'''Fund Codification''' : Depending on the filter “Codif CSSF/AAC”, this filter either contains the CSSF codification or the AAC internal codification.
::This filter pilotes the Fund and Sub-Fund codes displayed in the table. It also pilotes the codification used for the filter “Fund Codification”.
*'''Sender''' : This filter is especially useful for Management Companies working with a lot of different Central Administrations.
*;Fund Codification
*'''Sending Date''' : This filter determines which reception date is used to determine if a report was sent on time or late : with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
::Depending on the filter “Codif CSSF/AAC”, this filter either contains the CSSF codification or the AAC internal codification.
*'''Report Type''' : This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).  
*;Sending Date
::This filter determines which reception date is used to determine if a report was sent on time or late: with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
*;Report Type
::This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).


== Line types ==
==Line types==
Three different information types exist :  
Three different information types exist :  
*;On Time
*'''On Time''' : This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
::This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
*'''Late''' : This entry indicates that the report was received, but after the deadline indicated above.
*;Late
*'''Missing''' : This entry indicates that the report was not yet received.
::This entry indicates that the report was received, but after the deadline indicated above.
*;Missing
::This entry indicates that the report was not yet received.
*;Other Provider
::This entry indicates that the report has been sent by another provider.


== Status ==
==Status==
Six different types of entry exist :
*'''Leftward pointing green filled triangle''' : this entry means that it is the first report expected/received for the sub-fund.
<br>
[[File:131_.png]]<br><br>
*'''Green filled square''' : this entry means that one report was expected/received for that period..
<br>
[[File:132_.png]]<br><br>
*'''Star''' : this entry means that several reports were received for that period. This is usually because corrections were necessary (e.g. because all the information were not available before the deadline).
<br>
[[File:133_.png]]<br><br>
*'''Rightward pointing filled triangle''' : this entry means that it is the last report expected/received for the sub-fund due to the closing of the sub-fund.
<br>
[[File:134_.png]]<br><br>
*'''Rightward pointing empty triangle''' : this entry means that the report was received after the sub-fund was closed.
<br>
[[File:135_.png]]<br><br>
*'''Leftward pointing empty triangle''' : this entry means that the report was received before the sub-fund was launched.
<br>
[[File:136_.png]]<br>
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”.<br>
[[File:423.PNG]]<br>
==Data history==
For the '''O1.1/U1.1''', reports received in the last '''12 months'''-to-date are taken into account.
For the '''O4.1''', reports received in the last '''4 years'''-to-date are taken into account.
 
=Document transmission to authorities (1 year)=
 
==General information==
 
The “Document transmission to authorities” view represents the number of documents (KIID, notifications, …) sent to the authorities and further displays the entity that has sent these documents during one year rolling.<br>
<br>
[[File:140_.png]]<br><br>


Six different types of entry exist:
=Your Fundsquare library=
*;Before launch (left empty triangle)
::this entry means that the report was received before the sub-fund was launched.<br>
[[File:417.PNG]]
*;First (left filled triangle)
::this entry means that it is the first report expected/received for the sub-fund.<br>
[[File:418.PNG]]
*;Report (square)
::this entry means that one report was expected/received for that period.<br>
[[File:419.PNG]]
*;Multi (star)
::this entry means that several reports were received for that period. This is usually because corrections were necessary (because all the information were not available for the deadline for instance).<br>
[[File:420.PNG]]
*;Last (right filled triangle)
::this entry means that it is the last report expected/received for the sub-fund due to the closing of the sub-fund.<br>
[[File:421.PNG]]
*;After closed (right empty triangle)
::this entry means that the report was received after the sub-fund was closed.<br>
[[File:422.PNG]]<br>
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”.<br>
[[File:423.PNG]]


== Data history ==
==General information==
For the '''O1.1/U1.1''', reports received in the last '''12 months-to-date''' are taken into account.<br>
For the '''O4.1''', reports received in the last '''4 years-to-date''' are taken into account.


The “Your Fundsquare library” view represents the number of documents loaded in your Fundsquare library and indicates which entity sent them.<br><br>


= CSSF synchronization on sub-fund level =
The number of documents is counted either during one year (last complete year from January 1st to December 31st) or counted during the current year (always started at January 1st)<br><br>


== General Information ==
The documents are separated per country (if they are linked to funds) or per companies (FATCA reports made for companies) The columns indicating a country (Luxembourg or United Kingdom in the example) count documents that are issued by fund and display the number of documents under that fund domicile. The column “RFI” (Reporting Filing Institutions) counts all documents that are not related to funds but to entities, such as FATCA reports.<br>
The “CSSF synchronization on sub-fund level”  view shows for each fund you are servicing using Fundsquare, the synchronization between the CSSF and Fundsquare with regards to the status of the sub-funds.<br>
<br>
[[File:424.PNG]]
[[File:150_.png]]<br>
[[File:160_.png]]<br>


== Apply filters ==
==Apply filters==
The following filters can be applied :  
The following filters can be applied :  
*;Management Company
*'''Document Type''' : this filter allows you to select one or more Document Type that has been transmitted (e.g : Annual Report, U11 report, Prospectus,…)
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*'''Sender''' : This filter is especially useful for Management Companies working with a lot of different Central Administrations/Depositor
*;Fund Name
*'''Period''' : 2 periods are available :<br>
::Useful when dealing with a large number of funds to quickly select a subset of them.
:*Full preceding year : allows you to view all the documents available in your library during the last complete year (January 1st until December 31st)
:*Year-to-date : allows you to view the documents during the current year (allwaysstarting from January 1st)


== Entry types ==
=Document Dissemination=
Several entry types exist:
*;Active on both sides
::“Normal” situation, listing all the sub-funds active both at Funsquare and at the CSSF of the funds known by Fundsquare.
*;CSSF only
::“Normal” situation, which indicates that even though the fund is known by Fundsquare, some of the sub-funds are not known.
*;Fundsquare active and CSSF inactive
::Point of attention, which can either indicate that the sub-fund has already been activated in Fundsquare sytem but not yet in the CSSF database, or that the sub-fund has already been closed at the CSSF and not yet in Fundsquare system.
*;CSSF active and Fundsquare inactive
::“Unnormal” situation, which indicates that the activation date of the sub-fund was not indicated to Fundsquare.
*;CSSF active and Fundsquare closed
::“Unnormal” situation, which indicates either that the closure of the sub-fund was not yet reported to the CSSF, or that a closing date was reported to Fundsquare by error.
*;Fundsquare only
::This situation indicates the sub-fund do not exist yet/anymore in the CSSF database, but the sub-fund is already/still active in Fundsquare database.<br>


<u>NB:</u> Only the entry types relevant to the view are displayed. It is possible to filter on a specific entry type by clicking on the status in the legend (on top) and clicking on “keep only”.<br>
==General information==
[[File:425.PNG]]
The “Document Dissemination” view gives a list of all the recipients which have been configured per fund for all type of documents. The recipients have been divided in 2 parts : 1) the Platforms and 2) the Specifics Recipients.<br>
<br>
[[File:170_.png]]<br><br>
The disseminations’ lists can be managed via the module “Dissemination set-up”.<br>


= CSSF synchronization on sub-fund level - Details =
=NAV Dissemination=
== General Information ==
 
The “CSSF synchronization on sub-fund level - Details”  view shows for each sub-fund of the funds you are servicing using Fundsquare, the synchronization between CSSF and Fundsquare with regards to the status of the sub-funds. Details about the start/close dates of the CSSF and Fundsquare are available by flying over the squares with the mouse.<br>
==General information==
[[File:426.PNG]]


== Apply filters ==
The “NAV Dissemination” view gives a list of all the recipients which have been configured per fund for all your NAVs. The recipients have been divided in  parts : 1) the Platforms and 2) the Specifics Recipients.<br>
The following filters can be applied:
<br>
*;Management Company
[[File:180_.png]]<br><br>
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*;CSSF Fund Code
::This code is given to a fund by the CSSF upon registration of the fund at the CSSF.
*;Fund Name
::Useful when dealing with a large number of funds to quickly select a subset of them.


= CSSF synchronization on share class level =
=Static Data Dissemination=


== General Information==
==General information==
The “CSSF synchronization on share class level”  view shows for fund you are servicing using Fundsquare the synchronization between CSSF and Fundsquare with regards to the status of the share classes. <br>
The “Static Data Dissemination” view gives a list of all the recipients which have been configured per fund for all your Static Datas. The recipients have been divided in parts : 1) the Platforms and 2) the Specifics Recipients.<br>
[[File:427.PNG]]
<br>
[[File:190_.png]]<br><br>


== Apply filters ==
=OMS Universe=
The following filters can be applied:
*;Management Company
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*;Fund Name
::Useful when dealing with a large number of funds to quickly select a subset of them.


= CSSF synchronization on share class level - Details =
==General information==


== General information ==
The “Fundsquare OMS Universe” view provides a summary of all three levels of instruments (e.g. Share Class / Sub-Fund / Fund) linked to the entity in scope. The donut displays the total of your ISIN’s created, split into a “routable” part – that can be used by distributors to send orders via our order routing platform – and a “non-routable” part – that can not be used within our order routing platform (yet).<br><br>
The “CSSF synchronization on sub-fund level - Details”  view shows for each share class of the funds you are servicing using Fundsquare  the synchronization between CSSF and Fundsquare with regards to the status of the share classes.<br>
The graph shows all instruments (Luxembourgish and Non-Luxembourgish) split in 2 parts :
[[File:428.PNG]]
*OMS : instruments are part of the Order Management Service and are routable;
*FSQ : all instruments created in our database which cannot be used for Order Routing (yet).<br>
<br>
[[File:200_.png]]<br>
'''Remark:'''<br>
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.<br><br>


== Apply filters ==
==Apply filters==
The following filters can be applied:
The following filters can be applied :  
*;Management Company
*'''Fund''' : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.
::This filter is especially useful for Fund Administrators working with a lot of different management companies.
*'''Actual Share Status''' : per default it will be (All) meaning you will have active and inactive share classes. You can filter by having only active classes or only inactive classes (inactive classes are defined as not yet launched or closed classes)
*;CSSF Fund Code
*'''Country, Type''' : Country is defined by the jurisdiction country of your fund. In this printscreen, this Management Company has Luxemburgish Funds (LU) and Foreign Funds (NON-LU). The Type defines if these classes are under Fundsquare database only (FSQ) or if they are also part of the OMS (OMS)
::This code is given to a fund by the CSSF upon registration of the fund at the CSSF.
*'''Manco Routable ISINs''' : This donut will show you the number of your ISINs which are routable and the number of  ISINs which are not.  
*;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.


= Registration/Distribution Map =
=Distributor Activity=
==General information==
The “Distributor Activity” view provides detailed information about the volume of transactions. Several indicators can be selected such as message type, period, transmission type (in number or value), …<br><br>
In addition, the below part of the page focuses on transactions sent through Fundsquare per Order Giver.<br>
<br>
[[File:210_.png]]<br>
'''Remark:'''<br>
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.<br><br>


== General Information ==
==Apply filters==
The “Registration/Distribution Map”  view shows for the selected funds, sub-funds or share classes in which countries they are registered and/or distributed. It also enables to see how many shares are registered and/or distributed in a specific country. <br>
The following filters can be applied :
[[File:429.PNG]]
*'''Fund Name''' : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.
*'''Message Type''' : This filter allows you to select the type of message (per default (All) messages are shown). You also have : Redemption Order, Subscription Order and Switch Order.
*'''In/Out Indicator''' : This filter allows you to select the indicator (Inflow or Outflow). Per default (All) is selected (grouping the 2 indicators).
*'''Period''' : Gives you the possibility, by moving the arrows, to see during a selected period the activity done.
*'''Select Transmission''' : You can select the Transmission mode. Per default you have the Number of Transactions. The other selection is the Value in € by transactions (if your transaction has not been made in €, the conversion in € will be calculated the day of the confirmation based on the FOREX)<br><br>


== Apply filters ==
=In/Out Benchmark=
The following filters are available:
*;Fund Name
::Useful when dealing with a large number of funds to quickly select a subset of them.
*;Sub-fund Name
::Usually used after the Fund Name is selected, to make a quick subfilter.
*;ISIN
::Useful to quickly search a specific share class.
*;Distributed/Registered
::Enable to find quickly funds registered, distributed or both, in different countries.


= Training Sessions =
==General information==
The “In/Out Benchmark” view provides transaction volumes or values per Order Giver. It also gives a benchmark information on the transaction volume on your funds compared to the entire volume of orders sent by this distributor through Fundsquare.<br>
<br>
[[File:220_.png]]<br>
'''Remark:'''<br>
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.<br><br>


You can subscribe to training sessions available in either french, english or german, organized at the premises of Fundsquare S.A. at the end of August and mid of September.
=Order Reception=


Please us the following link
==General information==
* <u>'''[https://fundsquare.acuityscheduling.com FundLifyCycle Training Session</u>''']
The “Order Reception” view gives an overview of order receiption over the day. The donut displays a split of all orders per channel : there are different channels available via which Fundsquare can receive orders, the most important one is “SWIFT”; we then also offer “OGUi” which is our User Interface for order placement. Then also a FTP connection would be possible.<br><br>
Further a KPI (Latency) is displayed.<br>
<br>
[[File:230_.png]]<br>
'''Remark:'''<br>
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.<br><br>


==Apply filters==
The following filters can be applied :
*'''Message Type''' : This filter allows you to select the type of message (per default (All) messages are shown). You also have : Cancelation of  Switch Order, Cancelation of  Redemption Order, Redemption Order, Subscription Order and Switch Order.
*'''Order Giver''' : This filter allows you to select the Order Giver. Per default (All) is selected.
*'''Period''' : Gives you the possibility, by moving the arrows, to see during a selected period the activity done (Maximum period is 3 Months).
*'''Channel''' : Allows you to select the channel (OGUI or Swift)<br><br>


= General Questions =
= General Questions =


If you have questions to the shown content on the FLC Monitoring, please address your question to [mailto:FLC@fundsquare.net].
If you have questions to the shown content on the FLC LOversight, please address your question to [mailto:FLC@fundsquare.net].


In case of questions to your access, please contact your local e-file administrator.
In case of questions to your access, please contact your local e-file administrator.


Should you encounter other technical problems, please contact our Helpdesk Team at<br>
Should you encounter other technical problems, please contact our [[How to contact us|'''Client Support & Operations Desk''']].
* phone: +352 28 370-330
* email: helpdesk@fundsquare.net


[[Category: FAQ e-file]]
[[Category: FAQ e-file]]

Latest revision as of 21:07, 30 April 2018

What is the FundLifeCycle Monitoring all about?

The purpose of Fund Life Cycle Oversight is to give all Management Companies a view of all the activities done on their funds by themselves and/or by their providers.
Management Companies will have views on :

  • Registration/Distribution matrix,
  • NAV’s loaded,
  • Regulatory Reports
  • Their Library,
  • The different Disseminations,
  • And finally on the Order Management Services



This document provides “a Useful Tip”, on some views, which will lead you to different reports available on the Dashboard Module on your e-file light application.
10 .png
If you do not have this module, please contact either your provider or your Fundsquare Client Service Manager.

User Guide

Access to the application

20 .png

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

21 .png
If you do not see this module, please contact your Relationship Manager or your Client Service Manager. If the module is in grey, please contact your administrator who will give you the right to access it.
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.
    22 .png
  2. In the General tab, click on the Tabs button.
    23 .png
  3. Under When a pop-up is encountered, choose Always open pop-ups in a new tab.
    24 .png

General Options

In each screen, the following options are available:
30 .png

  • 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.

A Dashboard report exists for most of the views in your Dashboard module. Those reports are easy to interpret.


Dashboard

General Information

The “Dashboard” is the entrance screen showing the following five main parts of your activities :

  • Funds universe
This view represents the number of active funds/sub-funds/share classes you are working on.
  • E-file filing
This view represents the number of all documents sent to each of the authorities in the last 12 months.
  • Your top distribution countries
This view lists the countries with the highest distribution of your funds. The list contains the top 10 (if there are 10 or more countries where your funds are distributed).
  • Documents loaded in library
This view represents the number of documents loaded in Fundsquare library for the corresponding funds.
  • Providers
This view lists all your providers who are using Fundsquare services and the number of corresponding funds they act on. The different roles the provider has are indicated :
  • Reporter : Entity which can publish NAV’s and sends Reportings (O, U, S and TPT)
  • Transfer Agent – Fundsquare routing hub: Entity which uses Fundsquare order routing system.
  • All other workflows (FATCA sending, KIID update, …) : Entity that can create and transmit the corresponding documents for the funds of the management company (possible also for ALL the funds where the management company is also library owner)

40 .png

You @ Fundsquare

General Information

The view “You @ Fundsquare” shows your contractual situation, in other words : the subscribed services.
50 .png
The details of the services can be found in our “Product catalog” pdf document available on : www.fundsquare.net under menu “Services”, section “Presentation”.

Registration/Distribution Heatmap

General information

The “Registration/Distribution” heatmap gives a quick global oversight of your shares in different possible status (to register, registered, distributed, …) and their quantity.
60 .png
In the example above, we can see that the funds of the ManCo are mostly distributed in Western Europe but also a few other countries (Peru, Chile, South Korea, …).

Interact with the map

By moving the mouse over the top left corner, you have different options available to interact with the map:

61 .png

Magnifying glass : To search a country or any part of the world (Asia, Europe, Luxembourg, …)
+ and - : To zoom in/out.
Home (house): To return to the initial view

62 .png

Zoom / Selection options:

  • Zoom on a rectangle area
  • Select countries in a rectangle
  • Select countries in a circle
  • Select countries with a free pattern

It is possible to navigate on the map by holding a click and navigate with the mouse.

Apply filters

The following filters can be applied :

  • Fund Name : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.

Example : you want to select only SIF funds and all your specialized funds contain the word “SIF”.

  • Status : 5 status about the registration and 3 status about the distribution exist. Each fund has a registration status and a distribution status. By default, the distribution view is visible.


63 .png

In the example above, we can see that the ManCo stopped a lot of distribution of shares in Greece.

NB : If several statuses are selected, the view will sum up the number of entries. For example, if the “registered” and “distributed” statuses are selected, all the share classes that have both status will be counted twice.

Useful tip : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report 2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix

Fund distribution by country

General information

The view “Fund distribution by country” illustrates how many share classes are distributed by fund by country.

70 .png

This view can help the ManCo to realize where some funds / share classes are distributed (or not distributed). For example, the fund 8831 seems to be distributed in most countries in Europe, and we saw in the “Registration/Distribution Trend” view that Liechtenstein was one of the ManCo’s hot country. The ManCo can therefore wonder if they shouldn’t also distribute the shares of the fund 8831 in Liechtenstein.

Useful tip : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report 2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix

Registration/Distribution Trend

General information

The view “Registration/Distribution Trend” indicates a global trend on how many shares have reached the different possible status (to register, registered, distributed, …) .

80 .png

Example : In the view “Registration/Distribution Map”, we saw that Luxembourg and Switzerland were the two countries where the greatest number of share classes is distributed for the Management Company. In this view the timeperiod is now set to display last year only; we can see that, in the past year, Liechtenstein was the country were the greatest number of share classes have been distributed.

Useful tip : To have the details of all the classes registered and distributed per country, you can go to the Dashboard and select either the report 2_3-Export csv of the Registration Matrix either report 2_4-Export excel of the Registration Matrix

Share registration incoherence

General information

The view “Share registration incoherence” illustrates the registration issues of your funds in Fundsquare’s database.

90 .png

An incoherence is detected if share is distributed in a country but not registered : it means that this share is marked as “distributed” (D) in the matrix but has not as “registered” (R or RX). This either means that the share should not be distributed anymore in the country, or that the share should be logged as “registered” as well.

To check the list of ISINs impacted, you can apply a country filter first if necessary and then use the “Download” button to the check the extract in excel format.

Useful tip : you can also check this issue (classes distributed per country but not registered) going on the Dashboard and select the report 2_1-Incoherence between REG and DIST matrix (D and not R). In order to solve them, we propose you either to change these Distributed statuses by putting a DX or insert a Registration status (R)

NAV’s loaded – Hourly view (3 months)

General information

The “NAV’s loaded – Hourly view (3 months)” view represents the number of NAV’s received by Fundsquare for each fund at each hour of the day.

100 .png

In the example above, we can see that, for the “Fund 4209”, 62375 NAV’s have been loaded at 7 PM during the last 3 months.

Under the number of NAV’s received by hour, a cumulated view of the NAV’s received till the specific hour (from 0 am to the hour selected) is available in a lighter color.

Below that graph, a global view of all the NAV’s received for your funds is available (“Your funds”). This view gives a quick overlook of all the NAV’s loaded for your funds in the past 3 months.

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.

110 .png

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.
  • ISIN : Useful to quickly search a specific share class.
  • Frequency : Useful to distinguish the expected delivery frequency. By default, “daily” funds are selected.
  • Last Month/Last 3 Months : 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.

Status

Six different types of entry exist :

  • Leftward pointing green 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).


111 .png

  • Green filled square : this entry means that one NAV was expected that day (standard situation)


112 .png

  • Green 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 ould also mean that the NAV of different days were received on the same day.


406.PNG

  • Rightward pointing green 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).


114 .png

  • Rightward pointing empty triangle : this entry means that the NAV was received after the share lass was closed (this could most likely be a data quality issue or a case of liquidation).


115 .png

  • Leftward pointing empty triangle : NAV received before launch date : 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.
116 .png

117 .png

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”.
118 .png

Exclude entries

It is also possible to exclude entries : specific dates, specific currencies, specific funds / sub-funds / share classes.
Example : you know that for your funds, the NAV is sent the day after its value date. Therefore, all value dates of your NAV will be missing today. Therefore you want to exclude today’s NAV’s in the view.

Regulatory reports

General information

The “Regulatory reports” view represents the percentage of different regulatory reports that were either sent on time, late or were not sent yet.

120 .png

Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far in this detailed view. The table gives a periodic KPI (monthly for O1.1/U1.1, yearly for O4.1) for each fund and a global periodic KPI for all the funds your Fund Administrator(s) is/are working for. The table shows you all the active sub-funds. A global periodic Market KPI is also available to benchmark your performance against the market.

Apply filters

The following filters can be applied :

  • Sender : This filter is especially useful for Management Companies working with a lot of different Central Administrations.
  • Sending Date : This filter determines which reception date is used to determine if a report was sent on time or late : with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
  • Report Type : This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).

Line types

Four different information types exist :

  • On Time : This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
  • Late : This entry indicates that the report was received, but after the deadline indicated above.
  • Missing : This entry indicates that the report was not yet received.

Data history

For the O1.1/U1.1, reports received in the last 12 months-to-date are taken into account. For the O4.1, reports received in the last 4 years-to-date are taken into account.

Regulatory reports - Details

General information

The “Regulatory reports - Details” view represents, at sub-fund level, the percentage of different regulatory reports which were either sent on time, late or were not sent yet. These are the detail of the view of “Regulatory reports” explained in the chapter before.

130 .png

Only the monthly O1.1/U1.1 and the yearly O4.1 are available so far in this detailed view.

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.
  • Codif CSSF/Internal Code : This filter pilotes the Fund and Sub-Fund codes displayed in the table. It also pilotes the codification used for the filter “Fund Codification”.
  • Fund Codification : Depending on the filter “Codif CSSF/AAC”, this filter either contains the CSSF codification or the AAC internal codification.
  • Sender : This filter is especially useful for Management Companies working with a lot of different Central Administrations.
  • Sending Date : This filter determines which reception date is used to determine if a report was sent on time or late : with the “First sending date”, the date of the first report sent is considered (even if a correction on this report is sent later); with the “Last sending date”, only the date of the last version of the report is considered.
  • Report Type : This filter is used to choose to visualize either the O1.1/U1.1 (“Monthly 1.1”) or the O4.1 (“Yearly 4.1”).

Line types

Three different information types exist :

  • On Time : This entry indicates that the report was sent on time (Before the 10th of the month for O1.1/U1.1 reports and before 10 days and 4 months after the reference date (end of accounting year) for O4.1 reports).
  • Late : This entry indicates that the report was received, but after the deadline indicated above.
  • Missing : This entry indicates that the report was not yet received.

Status

Six different types of entry exist :

  • Leftward pointing green filled triangle : this entry means that it is the first report expected/received for the sub-fund.


131 .png

  • Green filled square : this entry means that one report was expected/received for that period..


132 .png

  • Star : this entry means that several reports were received for that period. This is usually because corrections were necessary (e.g. because all the information were not available before the deadline).


133 .png

  • Rightward pointing filled triangle : this entry means that it is the last report expected/received for the sub-fund due to the closing of the sub-fund.


134 .png

  • Rightward pointing empty triangle : this entry means that the report was received after the sub-fund was closed.


135 .png

  • Leftward pointing empty triangle : this entry means that the report was received before the sub-fund was launched.


136 .png
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”.
423.PNG

Data history

For the O1.1/U1.1, reports received in the last 12 months-to-date are taken into account. For the O4.1, reports received in the last 4 years-to-date are taken into account.

Document transmission to authorities (1 year)

General information

The “Document transmission to authorities” view represents the number of documents (KIID, notifications, …) sent to the authorities and further displays the entity that has sent these documents during one year rolling.

140 .png

Your Fundsquare library

General information

The “Your Fundsquare library” view represents the number of documents loaded in your Fundsquare library and indicates which entity sent them.

The number of documents is counted either during one year (last complete year from January 1st to December 31st) or counted during the current year (always started at January 1st)

The documents are separated per country (if they are linked to funds) or per companies (FATCA reports made for companies) The columns indicating a country (Luxembourg or United Kingdom in the example) count documents that are issued by fund and display the number of documents under that fund domicile. The column “RFI” (Reporting Filing Institutions) counts all documents that are not related to funds but to entities, such as FATCA reports.

150 .png
160 .png

Apply filters

The following filters can be applied :

  • Document Type : this filter allows you to select one or more Document Type that has been transmitted (e.g : Annual Report, U11 report, Prospectus,…)
  • Sender : This filter is especially useful for Management Companies working with a lot of different Central Administrations/Depositor
  • Period : 2 periods are available :
  • Full preceding year : allows you to view all the documents available in your library during the last complete year (January 1st until December 31st)
  • Year-to-date : allows you to view the documents during the current year (allwaysstarting from January 1st)

Document Dissemination

General information

The “Document Dissemination” view gives a list of all the recipients which have been configured per fund for all type of documents. The recipients have been divided in 2 parts : 1) the Platforms and 2) the Specifics Recipients.

170 .png

The disseminations’ lists can be managed via the module “Dissemination set-up”.

NAV Dissemination

General information

The “NAV Dissemination” view gives a list of all the recipients which have been configured per fund for all your NAVs. The recipients have been divided in parts : 1) the Platforms and 2) the Specifics Recipients.

180 .png

Static Data Dissemination

General information

The “Static Data Dissemination” view gives a list of all the recipients which have been configured per fund for all your Static Datas. The recipients have been divided in parts : 1) the Platforms and 2) the Specifics Recipients.

190 .png

OMS Universe

General information

The “Fundsquare OMS Universe” view provides a summary of all three levels of instruments (e.g. Share Class / Sub-Fund / Fund) linked to the entity in scope. The donut displays the total of your ISIN’s created, split into a “routable” part – that can be used by distributors to send orders via our order routing platform – and a “non-routable” part – that can not be used within our order routing platform (yet).

The graph shows all instruments (Luxembourgish and Non-Luxembourgish) split in 2 parts :

  • OMS : instruments are part of the Order Management Service and are routable;
  • FSQ : all instruments created in our database which cannot be used for Order Routing (yet).


200 .png
Remark:
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.

Apply filters

The following filters can be applied :

  • Fund : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.
  • Actual Share Status : per default it will be (All) meaning you will have active and inactive share classes. You can filter by having only active classes or only inactive classes (inactive classes are defined as not yet launched or closed classes)
  • Country, Type : Country is defined by the jurisdiction country of your fund. In this printscreen, this Management Company has Luxemburgish Funds (LU) and Foreign Funds (NON-LU). The Type defines if these classes are under Fundsquare database only (FSQ) or if they are also part of the OMS (OMS)
  • Manco Routable ISINs : This donut will show you the number of your ISINs which are routable and the number of ISINs which are not.

Distributor Activity

General information

The “Distributor Activity” view provides detailed information about the volume of transactions. Several indicators can be selected such as message type, period, transmission type (in number or value), …

In addition, the below part of the page focuses on transactions sent through Fundsquare per Order Giver.

210 .png
Remark:
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.

Apply filters

The following filters can be applied :

  • Fund Name : This filter is useful when dealing with a large number of funds to quickly select a subset of them, or to visualize the status for a specific fund.
  • Message Type : This filter allows you to select the type of message (per default (All) messages are shown). You also have : Redemption Order, Subscription Order and Switch Order.
  • In/Out Indicator : This filter allows you to select the indicator (Inflow or Outflow). Per default (All) is selected (grouping the 2 indicators).
  • Period : Gives you the possibility, by moving the arrows, to see during a selected period the activity done.
  • Select Transmission : You can select the Transmission mode. Per default you have the Number of Transactions. The other selection is the Value in € by transactions (if your transaction has not been made in €, the conversion in € will be calculated the day of the confirmation based on the FOREX)

In/Out Benchmark

General information

The “In/Out Benchmark” view provides transaction volumes or values per Order Giver. It also gives a benchmark information on the transaction volume on your funds compared to the entire volume of orders sent by this distributor through Fundsquare.

220 .png
Remark:
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.

Order Reception

General information

The “Order Reception” view gives an overview of order receiption over the day. The donut displays a split of all orders per channel : there are different channels available via which Fundsquare can receive orders, the most important one is “SWIFT”; we then also offer “OGUi” which is our User Interface for order placement. Then also a FTP connection would be possible.

Further a KPI (Latency) is displayed.

230 .png
Remark:
In case you, as the ManCo, have not subscribed to Order Routing Service (OMS) with us, all OMS related screens in this application will not display any information although it might happen that you probably already benefit from our services (since your TA can be linked to us). In such case and if you would like to learn more about how to subscribe, please contact your relationship manager at Fundsquare.

Apply filters

The following filters can be applied :

  • Message Type : This filter allows you to select the type of message (per default (All) messages are shown). You also have : Cancelation of Switch Order, Cancelation of Redemption Order, Redemption Order, Subscription Order and Switch Order.
  • Order Giver : This filter allows you to select the Order Giver. Per default (All) is selected.
  • Period : Gives you the possibility, by moving the arrows, to see during a selected period the activity done (Maximum period is 3 Months).
  • Channel : Allows you to select the channel (OGUI or Swift)

General Questions

If you have questions to the shown content on the FLC LOversight, please address your question to [1].

In case of questions to your access, please contact your local e-file administrator.

Should you encounter other technical problems, please contact our Client Support & Operations Desk.