Portfolio (IPS) - IPS Portfolio: Portfolio Position - Add a Transaction

Portfolio (IPS) - IPS Portfolio: Portfolio Position - Add a Transaction

Add a Transaction Overview

Once a portfolio account is setup, transactions such as a Purchase or a Sale can be added and reviewed in the portfolio. Adding a Purchase or Sale to an existing holding in a client's portfolio can be done via either the Position or the Transaction page.

Understand how to enter a client's existing equity investment in IPS module.

  • To view the IRESS Insights Video, please view the following link here. (Created by Anthony Derriscott on July 28, 2016)

 

Adding a Transaction

Adding a Transaction via Quick Entry

Quick entry allows for multiple holdings purchases using the bare minimum details. While viewing a Client's Portfolio: 

  1. In the client navigation menu, locate and click on Portfolios. The menu will expand. 


    Screen_Shot_2018-07-31_at_8.46.43_AM_copy.png

  2. Click on Portfolio. The menu options will expand. 


  3. Click on The menu options will expand.

  4. Select the Add button, the select Quick Entry. The Portfolio Quick Entry box opens

    Screen_Shot_2018-07-31_at_9.45.34_AM.png

  5. If you want to track the cash the client has to invest, type the amount in the Initial Cash to Invest box.

  6. This will allow you to use the Percentage allocation mode, and keep a running total of Remaining Cash to Invest.

  7. If a value has been entered in the Initial Cash to Invest box, select to use the Market Value or Percentage allocation mode.

  8. In the Security field, use the dynamic search field to select the holding to be purchased. You can also click  to search for and select one or more holdings.

  9. Do one of the following:

    • Market Value allocation mode

      enter the number of Units to be purchased, then click inside the Market Value text box. XPLAN will attempt to find the current unit price and calculate the Market Value.

      enter the Market Value of the purchase, then click inside the Units text box. XPLAN will attempt to find the current unit price and calculate the number of Units that can be purchased.

    • Percentage allocation mode

      enter the number of Units to be purchased, then click inside the Percentage text box. XPLAN will attempt to find the current unit price and calculate the Percentage of the initial cash to invest.

      enter the Percentage of the initial cash to invest that you want to use for the purchase, then click inside the Units text box. XPLAN will attempt to find the current unit price and calculate the number of Units that can be purchased.

  10. Repeat steps 4 and 5 for each holding to be purchased. Click  to add additional entry lines as required.

  11. Click Save.

 

Adding a Transaction via Purchase and Sale

To add a transaction via the Add Button:

  1. In the client navigation menu, locate and click on Portfolios. The menu will expand. 


    Screen_Shot_2018-07-31_at_8.46.43_AM.png

  2. Click on Portfolio. The menu options will expand. 


  3. Click on The menu options will expand.

  4. Select the Add button, then select Add Purchase (or Add Sale)

  5. Continue to the Enter details of the Transaction below

 

Adding a Transaction via Account

Screen_Shot_2018-12-03_at_9.34.05_AM.png

Accounts are created in the client portfolios to manage all underlying investments within a platform/ administration service. Accounts needs to be created before entering the underlying investments and can be named to reflect the platform name Portfolios have a Default account where all investments are listed unless you create a new account.

 

How to Add an Account:

  1. After you have selected the entities you wish to add an investment for, click on the Add drop box, and you will be then be you will be able to chose from Quick Entry, Purchase, Sale and Account.

  2. Click on the Account option, and you will be lead to another screen where you can add the Account details.

 

Screen_Shot_2018-12-03_at_9.34.31_AM.png

  1. Add the Account name into the Account text box field. The first step is to enter a name for the account. This will be the name you see when you’re selecting the account in any IPS screen. It is important that you name the account, making it is easily identifiable. For example the platform name and account number.

  2. Chose the relevant Provider if available. The “provider” field is linked to the provider of the datafeed that are linked to this account. The options available in the “Platform” field are the platforms created when creating fee disclosure sets.

  3. If there have been platforms set then the select the relevant Platform from the drop down menu.

  4. Select the relevant Investment Risk Profile that is to be applied to this account.

  5. Select the Status of the account; Active, Inactive, Closed, New, Terminating, Transferred Out or Recommended

  6. Enter the date the account was opened in the Account Open Date field.

  7. If a client has signed a Mandate against the portfolio account, select the Category and Type of Mandate. Account Mandates can be used as a filter in the portfolio positions, security positions, modelling, group modelling, transaction, corporate action and reconcile functions. Mandates need to be set up by your XPLAN administrator before they can be set against an account.

  8. Click on the Include in Corporate Actions field and select if you would like the account to be include corporate actions:

    • Select Allow Application to include full corporate action access for the account you are creating.

    • Select Deny Application to exclude corporate actions from accessing the account you are creating.

    • Select Allow Applications, but deny income cash to allow the account to execute dividends and income transactions but not to link the cash transaction to the default cash asset.

    • Select Allow Application, but deny capital cash to allow the account to execute capital corporate action events (e.g. rights issues) creating the stock movement but not to link the cash effect for payment or proceeds to the default cash asset.

    • Select Allow application, but deny income and capital cash to allow the account to execute both income and capital corporate action events without linking any cash effect to the default cash asset.

  9. Click on the FUM Scale field and select FUM scale to use for the account you are creating:

    • Select Use Client's FUM Scale to use the default FUM Scale for the client.

    • Select No FUM Fee Set and the account can be excluded from FUM calculations.

  10. Select the Disclosure Fee Set that is to be applied to the account. When portfolio accounts are linked to a disclosure fee set, the fees can be generated into your Statement of Advice documents.

  11. If applicable, you can set the “Contract for Difference (CFD)” provider for the account. Any new CFD holdings added to the account will be assigned to the CFD Provider selected here. CFD providers will need to be set up by your XPLAN Administrator.

  12. Specify the Account Name.

  13. Click on the Account Type field and select the type of account from the options available to tag to the account you are creating.

  14. Select whether this account Is Super or not.

  15. The Account Lock Date allows you to lock transactions at a particular date. This feature is mainly used for data feed Portfolio Accounts. No changes can be made to the holdings in the account for dates earlier than the lock date.

  16. Enter the Adviser Code that is linked to the account. This is the adviser’s code associated with the platform or product.

  17. Enter the Product Name.

  18. Select the Account Investor Status.

  19. Click on the Supplementary tab to enter additional details relating to the account. 


Screen_Shot_2018-12-03_at_9.34.46_AM.png

  1. If applicable, you can select a Custodial Entity for the portfolio account and any holdings added to the account will be assigned to the custodial entity.

  2. For clients with Online Access, set the permission if the client has the ability to edit their own account. This includes either editing transactions or applying corporate actions via their online access.

  3. If applicable, set the Default Cash Account to be linked to this account by entering the Code and the Exchange here.

  4. Tick the checkbox in the Default CGT Positions field for securities in this account to be CGT enabled by default.

  5. A Benchmark can be set which is used when analysing the account holdings to a specific benchmark.

  6. If you set a benchmark you can enter the percentage Benchmark Adjustment for the analysis.

  7. If applicable, link the account to a Margin Loan.

  8. If applicable, link the account to Borrowed Funds.

  9. Click OK to save the Account Details.

Screen_Shot_2018-12-03_at_9.35.21_AM.png

The Filter Options for Holding Overview panel will now display a field called Portfolio Account. (This field will only appear if an account has been created for the client's portfolio.) Ensure you select the correct account the investment is to be held under prior to adding the investment by clicking on the drop down box. A list of accounts for the client will be listed to select from.

 

Adding a Transaction via Holdings Overview

To access the Holding Details for a Position:

  1. In the client navigation menu, locate and click on Portfolios. The menu will expand. 


  2. Click on Portfolio. The menu options will expand. 


  3. Click on The menu options will expand.



  4. Select the Entity for the holding that you are adding a purchase (or sale) for.
  5. Select the Account the holding you need is held under. In the example we have selected 
"View All". 


  6. Click on the down arrow for the holding you are adding a purchase (or sale) and a submenu 
will appear. 


  7. Click on Add Purchase (or Add Sale) for the holding. 

     
  8. Continue to the Enter details of the Transaction below

 

Enter the details of the Transaction

  1. Add the purchase details as required. (In this example the client has purchased 1000 units on the 19th October 2017 and the transaction status is Actual). 

  2. Click Save once you have added all the details required. 




  3. In the below fields ensure the following is filled out:
    • Investment Code – once you have typed this in click on the  logo next to it and this will search the code in Xplan.

    • Exchange - type ‘ASX’ as the relevant exchange (not that this field does not pre-fill)

    • Transaction – in this case, use the drop down box to select ‘purchase’

    • Transaction Status – use the drop down box to select ‘ Actual’

    • Transaction Date – use the date of purchase/sale in this field

    • Settlement Date- this field will automatically pre-fill

    • Gross amount – if a gross amount is given, add this figure in (with corresponding decimal places). If no gross amount is given, click on the  logo to the right of the ‘unit price’ field, this will change the logo to  and add in the unit price.

    • Number of units – enter number of units purchased.

      Note

      If you are missing either the gross amount, number of unit or unit price, clicking on the icon on either the right hand side of gross amount of number of unit and this will calculate the figures based on the data in the other two fields.

      In the notes section outline the transaction as: (Transaction type) (ASX Code) (no of units) @ (Price) (date). In this case it is Purchase CBA 15 units @ $75.00 30/11/2016. This is in case a field is ever edited and/or accidentally recalculated the original data entered is still available.



  4. In the ‘Fees and Taxes’ tab add in any brokerage and GST that was on the transaction statement.



  5. You will notice an additional 200 units has been added to the holding:

 

Add a Recurring Income 

Recurring income transaction are useful for income such as recurring rent on direct property that is managed in the Portfolio area, or regular cash withdrawals on a manually managed cash account.

Screen_Shot_2018-12-03_at_9.41.30_AM.png

To add a recurring income transaction to an existing holding:

  1. Locate the holding the recurring income transaction is to be applied to and click on the down arrow button.

  2. Click Add Income.

Screen_Shot_2018-12-03_at_9.42.06_AM.png

  1. Complete the fields in the Account Information and Transaction Information for the first income distribution that is to be applied.

  2. To set the recurring transactions, click on the Set Recurrence button.

Screen_Shot_2018-12-03_at_9.42.18_AM.png

  1. Select the Recurrence Pattern - Weekly, Monthly or Yearly and complete the required fields.

  2. Enter the Range period the recurring income will be received.

  3. Click OK to save the changes.

  4. To remove stop the recurring income transaction in the future before the end date, you can return to this screen and click Remove Recurrence.

 

Check the Transaction History

  • To check the transaction history of each share holding, click on the  button on the line of the relevant holding.

  • Click on ‘View Transactions for (relevant shareholdings)’



  • You will now be taken to the transactions screen for that security code. The date range can be amended for a specific time period or from inception through the calendar function as shown below



  • Each transaction line item for that time period is shown as and can edited and viewed in more detail by clicking on the button to the left of the relevant line item.



  • Clicking on ‘View Transaction’ will take you into a pop-up screen with the below information:



  • Click ‘Close’ and go back to the transaction screen once information has been obtained.
    • Related Articles

    • Portfolio (IPS) - IPS Portfolio: Portfolio Position

      Portfolio Position Overview This section outlines the main components of the client's portfolio position screen and its functions on add, removing and managing holdings and transaction in a client's portfolio     How to Access Portfolios Position To ...
    • Portfolio (IPS) - Corporate Actions: Creating a Corporate Action

      Creating a Corporate Action Overview The purpose of this guide is to provide information on how to create and edit corporate actions and corporate action templates   To Create a Corporate Action Portfolio Functions > Corporate Actions. The Available ...
    • Portfolio (IPS) - IPS Portfolio: Portfolio Position - Access Holdings and Transaction

      Access Holdings and Transactions Overview The purpose of this guide is to demonstrate how to view Transactions for clients within their portfolio from the position screen; and search for Portfolio Transactions across all clients. 
 Note: Login to ...
    • Portfolio (IPS) - IPS Portfolio: Portfolio Position - Edit Holding and Transaction

      Edit Holdings and Transactions Overview The purpose of this lesson is to provide an overview of how to edit a holding, edit a transaction, add a purchase and add a sale to an existing holding in Portfolios. To view the IRESS Insights Video, please ...
    • Portfolio (IPS) - IPS Portfolio

      IPS Portfolio Overview This overview and navigation outlines the main components available in the client's IPS Portfolio screen   Portfolio Position This section outlines the main components of the client's portfolio position screen and its functions ...
    • 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 ...