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 - 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 ...
    • New User Manual - Adviser

      Table of Contents Welcome and Introduction.............................................................................................................................. 4 Using this Guide ...
    • XPLAN Workshop - Datafeed Administration

      Datafeeds Overview Introduction Datafeeds are an efficient way to import client, portfolio and risk data into your XPLAN site that are administered by a third-party such as a Stock Broker, Fund Manager, Wrap, Life Office etc. (known as a Data ...
    • New User Manual - Adviser Focus

      Welcome and Introduction  Welcome Introduction Welcome to the 1-Day New User - Adviser Focus course. This course is aimed at providing new users with an overview of XPLAN and its various financial advice and administrative capabilities. In this ...
    • 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 ...