Datafeed - System Datafeeds: Manual Transactions

Datafeed - System Datafeeds: Manual Transactions

How to identify manual transactions in a Datafeed

Manual transactions include the purchase or sale of units of a particular holding, which have been created by an individual user, rather than originating through the datafeed. These extra transactions can cause the account balance to not reconcile with the provider, and cause account balances to display incorrectly in the portfolios IPS area of XPLAN.

 

How to identify manual transactions

Step 1: Under the ‘Transactions’ menu of ‘Portfolios’ area of XPLAN (1), use the filter options to show the security you wish to analyse (2). Select the date range to since inception from the ‘Date Range’ options to show every transaction since the policy began (3).

mceclip0.png


Step 2:
This will show a list of every transaction against the holding. To identify the manual holdings, click the cog wheel in the ‘Portfolio Transactions’ section, and then select ‘Temp. Table Config’.

mceclip1.png


Step 3:
Within the table configuration, select the ‘Vendor name’ and ‘External ID’ options, then click Ok.

mceclip2.png


Step 4:
This will add 2 extra columns to the transaction view. With this view, we can see that some transactions do not have any details under the ‘Vendor Name’ and ‘External ID’.

mceclip3.png


Step 5:
In order to correct the information, these transactions need to removed in order to correct the feed. This can be achieved by selecting the incorrect transaction and selecting ‘Remove Transaction’.

mceclip4.png

 

 

 

 

 

    • Related Articles

    • Datafeed - System Datafeeds

      System Datafeeds Overview System Datafeeds are automated Datafeeds processed by IRESSnet (a combination of software applications/services hosted on IRESS infrastructure) and are the most common type of Datafeed.  Data files are supplied by the data ...
    • Datafeed - Troubleshooting Guide: System Datafeed

        System Datafeed Troubleshooting Guide Overview Identifying if the Datafeed has Run Check the ‘Last Updated’ column in the Platform Summary / Adviser Summary screens – this field reflects the date and time data finished importing into the site. ...
    • XPLAN Datafeeds: SunSuper Datafeed

          XPLAN Datafeeds: Sunsuper Datafeed As of 30 July 2021, Sunsuper have commenced datafeeds to XPLAN. The following provides more details including how to register and what information is supplied.  What Information Will Be Supplied The datafeed ...
    • 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/6823
    • 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 ...