Datafeed - Reporting
Reporting Overview
It is recommended that Reconciliation reports be checked daily, however at a minimum these reports should be checked weekly.
- From the Title Bar select XPLAN > Datafeed Functions > System Datafeeds > Reporting
- To view the IRESS Insights Video, please view the following link here [Part1] and here [Part 2]. (Created by Anthony Derriscott on Sep 28, 2017)
Platform Summary
The Platform Summary page will show details of each Datafeed for which the site has registered advisers. It will show the following information:
- Platform: This is the name of the Datafeed provider.
- Positions: This represents the number of holdings / positions that the Data Provider has supplied in the Datafeed.
-
Vendor: This column represents how many of the positions (as supplied by the Data Provider) reconcile.
Note: This value is calculated as part of the pre import validation process, and does not reflect the quality of the data in XPLAN.
- Vendor Balanced: This is a percentage representation of the data quality based on the two aforementioned fields, Positions & Vendor
-
Site: This column represents how many of the positions in XPLAN reconcile.
Note: This value would be compared to the Vendor column to see if Site data quality is as good as (if not better) than Vendor quality – with the exception of Broker feeds. If there are differences then refer to the Troubleshooting guide. -
Site Balanced: This is a percentage representation of the data quality based on the Site field against ‘Positions’.
Here you can check Vendor quality against Site quality by comparing the Vendor Balances and Site Balanced fields.
% Vendor Balanced for Broker datafeeds may not be 100% as when client’s broker accounts change from on broker to another the new broker account will only have transactions from the day the account was opened, and not the full transaction history of the holdings.
Historical transactions will need to be manually entered or uploaded via .CSV file. Alternatively an initial amount can be entered and reports can be generated from that date forward.
Adviser Summary
The Adviser Summary page shows the same detail as the Platform Summary screen but breaks it down by each Adviser registered to receive data per vendor.
This page also has filtering options which allow the user to drill down to specific Data Providers, User Groups, and Advisers.
Audit Log
The Audit Log will allow a user to pick a date and view the Audit Log for a given Provider. This can be filtered by Provider, User Groups or a single Adviser.
Notification messages displayed via the Notification Envelope will be consolidated and displayed in this log, dependent on the date, Vendor and Adviser selected.
Reconciliation Summary
The Reconciliation Report will display a list of Clients, Accounts, and Assets that are ‘Out of Balance’. This allows the user to filter the display at a Vendor, Adviser level.
Related Articles
Ultimate Guide to Datafeed
Datafeed Course Overview What is this about? This course is aimed at providing users with the skills to initiate new datafeeds as well as understanding datafeed reports. This guide covers a basic overview of what datafeeds are and an overview of the ...Datafeed - Overview and Navigation
Datafeed Overview and Navigation Datafeeds represent an efficient way to import portfolio transactions from a third-party. Incoming data is processed and matched against clients, automatically updating their current portfolio holdings. Types of ...Datafeed Troubleshooting
You will need to login to IRESS Community to access this link. https://community.iress.com/t5/Help-Guide-XPLAN/System-Datafeed-Troubleshooting-Guide/ta-p/6823Datafeed - Refresh Panorama Datafeed
If datafeed refresh from XPlan does not work, we could now do an adviser refresh directly from Panorama platform. IRESS has confirmed that this would fix the problem. If after doing the below steps, the problem does not get resolved, please send an ...Datafeed Set Up
Please log in to Wealth Axis Box and go to: https://wealthaxis.box.com/s/tmk9wvtk9jn4inxb41nvedeazx4a91v3 Supporting Document is attached. IRESS Community link for datafeed set ...
Popular Articles
Wealth Axis Files - Naming Convention
File Format: Date, Client Name, File Name Date - yymmdd E.g: 12 Sept 2013 - 130912 E.g: Undated - 010101 Client Names One Client / Only primary client (John Smith) E.g: Smith, J Two Clients (Primary and Secondary Client/Client and Partner) - Married ...Wealth Axis Wizards - Overview
Overview This article is designed to help you effectively use the Wealth Axis Wizards in XPLAN. The key features of the Wealth Axis Wizards are: Integration with key modules such as Client Focus, Portfolios (IPS), Risk Researcher, WealthSolver and ...New User Manual - Admin
XPLAN and the Advice Process Overview Many advisers use the Advice to Client process to manage the advice process in their business. To enable participants to be able to relate to the different modules in XPLAN, this course is structured along the ...Administration - Email: Setting up the Outlook Plugin
Outlook Plugin - Overview Outlook Plugin is a function available with XPLAN that allows you to quickly and easily save and record email correspondence in the XPLAN document library as a Note that is linked to a client or user entity. This allows for ...XPLAN Workshop - XPLAN Client Setup
Introduction Overview Each practice deals with leads, referrals and potential clients differently. However, most practices have a system regarding the way client information is recorded and relationships with clients are managed. In this section, ...
Recent Articles
XPLAN Legislative Rates June 2022
XPLAN Legislative Rates - June 2022 Legislative rates have been updated to reflect: 1. Social Security rates effective July 2022 2. AFSA Retirement Standard Benchmarks for the March Quarter 2022. Social Security Rate Changes - July 2022 The rate ...XPLAN: Task Notifications - Redirecting
XPLAN: Redirecting Task Notifications XPLAN task notifications can be sent to your Email Inbox (e.g. Outllok, Gmail) to notify you if a task has been created, unactioned, is overdue or complete. If the task notifications cannot be turned off, then ...XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195)
XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195) Client Focus Digital Signature Notification will Honour the "Override from Address" when sent by Super User The notify signatories template configured in system settings > client focus ...XPLAN Version Enhancements - November 2021 (Version 21.11.194)
XPLAN Version Enhancements - November 2021 (Version 21.11.194) Client Focus New Current Residential Address Field A new field, current residential address, has been added to record a client’s current address. When entering the first address for a ...XPLAN Datafeeds: HUB24 Enhancements (v4.3) 29 October 2021
HUB24 Enhancements: 29 October 2021 HUB24 have released enhancements to their XPLAN EPI 4.3 datafeeds, to be effective 15 November 2021. Below is the information directly from HUB24 on the enhancements. The Individual Holding extract is where the ...