Xact Web Portal: Ad hoc reporting functionality for Statements of Holdings
Note: This Announcement, originally published on 13 September 2023, has been updated with additional details. The changes have been highlighted.
Further to Announcement L23022 LuxCSD1 informs clients about the ad hoc reporting functionality in Xact Web Portal, effective
18 September 2023
Background
Xact Web Portal has been enhanced to provide clients with ad hoc reporting under its Reporting and Monitoring service, with a new “AdHoc Reporting” domain and “Manage Adhoc Reporting” sub-domain.
The first report available under the new service will be “Statement of Holdings (securities/cash)” intended for external audit purposes.
Click on image to enlarge
Reporting
Statement of Holdings (securities/cash) is available under AdHoc Reporting/Manage Adhoc Reporting.
The report is split into an MT535 Statement of Holdings for the securities part and an MT950 Money Statement for the cash part (depending on the client account set-up, that is, Securities + Cash, Securities only or Cash only).
Once scheduled, the report can be downloaded as a PDF file and stored on a local drive.
To query Manage Adhoc Reporting/Statement of Holdings (securities/cash)
- Click on Reporting & Monitoring, Manage Adhoc Reporting in the main menu of Xact Web Portal;
- Select Statement of Holdings (securities/cash) from the drop-down menu;
- Populate the fields with the required search criteria;
- Click on "Count" if you want to check how many results your query will yield as it is currently specified, use the "Count" button to display the number in the Count field. If the count is high, you can refine your query to yield fewer results;
- Click on "Query" to see the List View.
- To display the details of the report, select the row(s) from the list and click on "Open details", alternatively, click on the folder icon. If more than one row is selected the reports details open in separate tabs.
To create an Adhoc Reporting/Statement of Holdings (securities/cash) subscription
- Click on Reporting & Monitoring, Manage Adhoc Reporting in the main menu of Xact Web Portal. The screen will open with the Query view;
- Click on the “+” button to create a new report subscription; The report wizard will open;
- Complete the fields as required;
- Click on "Submit”;
- The Details window will open: Click on Refresh (several refresh clicks may be necessary depending on file size and server response) to see the new report subscription under the List of Requests, and click on Acknowledge to validate the request;
- Your report(s) will appear in the List of Responses;
- Select the row(s) you wish to download; Click on Download;
Unzip/Extract/Save the file to the location of your choice and open the PDF.
Further information
Further information can be found in the Xact Web Portal User Manual.
Please see the LuxCSD website for more information about Xact Web Portal.
For further information please contact the Clearstream Connectivity Helpdesk or your Relationship Manager.
------------------------------------------
1. LuxCSD refers to LuxCSD S.A., registered office at 42, Avenue J.F. Kennedy, L-1855 Luxembourg, registered with the Luxembourg Trade and Companies Register under number B-154.449.