Conversion Process Guide - PlatformPlus: XPLAN Conversion Guide

Conversion Process Guide - PlatformPlus: XPLAN Conversion Guide

 

PlatformPlus to XPLAN Conversion Guide Overview

This document highlights data and functionality most often of concern to practices converting from PlatformPlus to XPLAN, however if there is specific data and/or functionality that is not contained within this document and is of importance to your Practice, please discuss with your IRESS representative prior to your conversion.

It is also important to be aware that IRESS will not undertake data cleansing. Any data errors (i.e. misspellings, client names, date of birth) will be transferred; therefore a practice may wish to ‘clean up’ their data before commencing with the conversion.

 

Requesting a Data Conversion

Please be aware that there will be a wait of a number of weeks from the time that IRESS receives your request for a data conversion. This time frame will vary throughout the year and your IRESS representative will inform you of an estimated time when your conversion will be scheduled.

 

Out of Scope

If you require any data converted that is outside the scope of this document, IRESS is happy to assess the data. Once IRESS has made the assessment, a decision will be made on whether or not the conversion is possible. Once this decision has been made, an approximate quote on timeframe and additional cost will be given. Please contact your IRESS representative to discuss this further.

 

The Conversion Process

  1. Conversion preparation

During this phase a Transition Consultant will work with you to prepare for the conversion of your data.

 

  1. Obtaining a copy of your data for conversion

        Data must be received by the end of the business day prior to your conversion date.

 

  1. Data Import

IRESS completes the first step to import your data into your new XPLAN site (the destination site). Data imports are done after business hours and the time required to import the data depends on the volume of the data. Your Transition Consultant will keep you informed of the progress.

 

  1. Post-conversion tasks

IRESS completes the import of custom fields, choice value mappings, updating of risk profiles etc. on the next day after the data import completes.

 

  1. Data checking and sign-off

It is your responsibility to review your data in XPLAN after the conversion. You know your data better than anyone else and is best placed to notice any differences between your original data and the data that will reside your new XPLAN site after the conversion.

 

Standard conversions

Outlined in the following pages are details of the data within Platformplus that will be converted to XPLAN. It is important that you review this information so you are fully aware of how your Platformplus data will be converted to XPLAN.

 

Users

All users are converted unless requested to be mapped, contact and address information included.





Figure 1
: User list

Screen Field Name

XPLAN Field Name

Notes

Surname

entity_last_name

 

Given Names

entity_first_name

 

 

Key Details

Entity: Individuals




Figure 2:
Key Details – Main (Individual)

Screen Field Name

XPLAN Field Name

Notes

Title

entity_title

 

Surname

entity_last_name

 

Given Name

entity_first_name

 

Preferred Name

entity_preferred_name

 

Gender

entity_sex

 

Date of Birth

entity_dob

 

Marital Status

entity_marital_status

 

Tax File Number

entity _tfn

 

ABN

Entity_ abn

 

Smoker

entity_smoker

 

entity_is_smoker

Private Health

medical_private_cover

 

Salutation

entity_salutation

 

Address Title

entity_address_title

 

Notes

Entity_comment

 

 

Entity: Companies




Figure 3:
Key Details – Main (Company)

Screen Field Name

XPLAN Field Name

Notes

Company Name

entity_company_name

 

ACN

entity_company_number

 

ABN

Entity_ abn

 

Tax File Number

entity _tfn

 

Company Type

entity_company_type

 

Notes

entity_comment

 

 

Entity: Superfund




Figure 4:
Key Details – Main (Super Fund) 

Screen Field Name

XPLAN Field Name

Notes

Name of Fund

entity_superfund_name

 

Tax File Number

entity _tfn

 

ABN

entity_abn

 

Deed Date

entity_superfund_dod

 

Location Of Deed

entity_superfund_loc_deed

 

Notes

entity_comment

 

 

Entity: Trusts




Figure 5: Key Details – Main (Trust)
 

Screen Field Name

XPLAN Field Name

Notes

Trust Name

entity_trust_name

 

ABN

entity_abn

 

Tax File Number

entity_tfn

 

Notes

entity_comment

 

 

Contact




Figure 6: Key Details – Contact

Group Field Name

Field Name

XPLAN Field Name

Notes

 

Telephone/Email

Type

contact_type

 

Value

contact_value

 

Preferred

contact_preferred

 

 

 

 

 

Address

 

Address

address_type

 

address_street

Suburb

address_suburb

State

address_state

Postcode

address_postcode

Country

address_country

Preferred

address_preferred

 

Employment




Figure 7: Key Details – Employment
 

Screen Field Name

XPLAN Field Name

Notes

Occupation

entity_employment_iqm2_occupation

The Occupations list within XPLAN is a predefined listing that aligns with the inbuilt insurance quotation module. When no exact corresponding value is found, the occupation will be set to “Other’ and the Occupation Description field will be populated by the source value.

Description

entity_employment_occupation_desc

 

Type Employment Status

entity_emp_status

 

Start Date

entity_start_date

 

Hours Per Week

entity_hours_worked_per_week

 

Employer

entity_employer

 

Job Description

Entity_jobtitle

 

 

Category





Figure 8:
Key Details – Category  

Screen Field Name

XPLAN Field Name

Notes

Adviser

client_adviser

 

Secondary Adviser

client_adviser_secondary

 

Paraplanner

client_adviser_paraplanner

 

Administrator

client_adviser_administrator

 

Insurance Adviser

client_adviser_insurance

 

Investment Adviser

client_adviser_investment

 

Mortgage Adviser

client_adviser_mortage

 

Client Services Manager

client_adviser_service

 

Rating

client_category

 

Status

entity_client_status

 

Third Party Disclosure

entity_disclose_thirdparty

 

 

Estate





Figure 9:
Key Details – Estate

Group Field Name

Field Name

XPLAN Field Name

Notes

 

 

Will

Current Will

entity_will_exists

 

Reflect Current Wishes

Entity_is_will_current

Last Review Date

entity_date_of_will

Will Location

entity_will_location

 

Executor of Will

Surname

executor_lname

 

First Name

executor_fname

Notes

executor_notes

 

Dependant




Figure 10: Key Details – Dependant
 

Group Field Name

Field Name

XPLAN Field Name

Notes

 Dependant

Given Names

entity_dependent_dep_name

 

 

Objectives

Financial




Figure 11:
Objectives – Financial

Group Field Name

Field Name

XPLAN Field Name

Notes

 

Long/Short term

Objective

Description

entity_obj_lt_choice

 

Cost

entity_obj_lt_amount

Description

entity_obj_st_choice

Cost

entity_obj_st_amount

 

Risk Profiling

Risk profile values are stored against the entity; as such each client’s asset class values are brought across however the descriptive title of the profile is only converted by being mapped to the existing profile descriptions on the destination site.





Figure 12:
Risk Profiling – Investment  

Screen Field Name

XPLAN Field Name

Notes

Risk Profile

 

Risk profile descriptions are mapped to those on the destination site based on descriptive title.

 

Agreed Asset Allocations

entity_profile_c<1-10>_min

 

entity_profile_c<1-10>_target

entity_profile_c<1-10>_max

Comment

entity_profile_comment

 

 

Insurance

Policy





Figure 13
: Insurance – Existing – By Policy

Group Field Name

Screen Field Name

XPLAN Field Name

Notes

 

Owners

insurance_group_policy_owner

 

 

Policy Number

Insurance_group_policy_number

 

 

Service Name

insurance_group_coy

Where matches the options available on the XPLAN site

 

Policy Name

insurance_group_plan_name

 

 

Policy Fee

insurance_group_policy_fee

 

 

Policy Status

insurance_group_policy_status

 

 

Premium Frequency

insurance_group_frequency

 

 

Premium

insurance_group_benefit_premium

 

 

Vendor Name

insurance_group_coy

 

 

Policy Comment

insurance_group_policy_comments

 

 

Covers

Group Field Name

Screen Field Name

XPLAN Field Name

Notes

 

Life Insured

insurance_life_insured Type

 

 

Commencement Date

insurance_type

 

 

Annual Notice Date

insurance_inception_date

 

 

Expiry Date

insurance_renewal_date

 

 

Benefit Amount

insurance_expiry_date

 

 

Benefit Frequency

insurance_benefit_amount

 

 

Waiting Period

insurance_benefit_frequency

 

 

Sum Insured

insurance_waiting_period

 

insurance_value

 

Benefit Status

insurance_benefit_status

 

 

Installment Premium

insurance_benefit_premium

 

 

Premium Type

insurance_premium_structure

 

 

General Insurance ID

insurance_group_policyid

 

Insurance: Vehicle

Description

insurance_group_Description

 

Amount Insured

vehicle_group_sum_insured

Vehicle Note

vehicle_group _vehicle_notes

General Insurance ID

insurance_group_policyid

Insurance: Property

type Description

property_group_type

 

Amount Insured

property_group_address

General Insurance ID

property_group_sum_insured

Section

insurance_group_policyid

 

Description

other_group_item_type

 

Amount Insured

other_group_item_make

other_group_sum_insured

 

Analysis

Balance Sheet





Figure 14:
Analysis – balance Sheet 

Group Field Name

Screen Field Name

XPLAN Field Name

Notes

Assets

Type

asset_type_group

 

Sub-Type

asset_type

 

Address

asset_desc

 

Owner

asset_owner

 

Assets: Property

Current Value

asset_amount

 

Purchase Date

asset_acq

 

Purchase Price

asset_cost

 

Notes

asset_comments

 

Assets: Non Financial Asset

Description

asset_desc

 

Asset Value

asset_amount

 

Purchase Price

asset_cost

 

Purchase Date

asset_cost

 

Valuation Date

asset_valuation_date

 

Notes

asset_comments

 

 

 

 

 

 

 

 

 

 

 

Liabilities

Service

liability_package_name

 

Account Number

liability_account_client-number

 

Type

liability_type_group

 

Sub-Type

liability_type

 

liability_inst

Liability_supplier

Owners

Liability owner

 

Current Balance

liability_amount

 

Initial Balance

liability_original_amount

 

Current Limit

liability_residual

 

Interest

liability_repayment_type

 

Interest rate p

liability_rate

 

Interest Rate Date

liability_ commence_date

 

Current payment

liability_repayment

 

Frequency

liability_frequency

 

Balance Updated

liability_values_last_updated

 

Repayment Type

liability_repayment_type

 

Commence Date

liability_settlement

 

Purchase Date

liability_loan_settlement_due_date

 

Termination Date

liability_expire_date

 

Tax Deductible Percentage

liability_deductible

 

Notes

Liability_comment

 

Cashflow





Figure 15:
Cashflow – Balance Sheet 

Group Field Name

Screen Field Name

XPLAN Field Name

Notes

 

 

Expense

Type

Cashflow_type

 

Sub Type

Cashflow_type_group

Owner

Cashflow_owner

Description

Cashflow_desc

Amount

Cashflow_Amount

Frequency

Cashflow_frequency

 

 

 

Income

Type

Cashflow_type

 

Sub Type

Cashflow_type_group

Owner

Cashflow_owner

Description

Cashflow_desc

Amount

Cashflow_Amount

Frequency

Cashflow_frequency

 

Super




Figure 16: Super– Existing Super
 

Screen Field Name

XPLAN Field Name

Notes

Type

Fund_fund_type

 

Account Name

Fund_fund_name

 

Account No

Fund_fund_refnum

 

Taxable

Fund_fund_taxable

 

Commenced Date

Fund_ date_commenced

 

Date Updated

Fund_ values_last_updated

 

Payment

Fund_ annual_contributions

 

 

Service

Profession Advisers & Referral




Figure 17:
Service – Referral 





Figure 18: Service – (Prof. Advisers)
 

Screen Field Name

XPLAN Field Name

Notes

Title

entity_title

 

Surname

entity_last_name

 

First Name

entity_first_name

 

Firm

entity_employer

 

Type

entity_profadviser_adviser_type

 

 

Reviews




Figure 19: Service – Reviews
 

Screen Field Name

XPLAN Field Name

Notes

Appointment Type

entity_review_type

 

Description

entity_review_desc

 

Appointment Date

entity_review_date

 

Appointment Time

entity_review_time

 

Appointment Date Completed

entity_review_date_completed

 

Appointment Frequency

entity_review_frequency

 

Notes

entity_review_comments

 

 

 

Admin

Tasks

All tasks that are set to a client are converted.

 



Figure 20: Admin – Tasks
 

Screen Field Name

XPLAN Field Name

Notes

Type

task_taskkind

 

Sub Type

task_subtype

 

Created By

task_assignedby

 

Assigned To

task_assignedto

 

Date Due

task_DateDue

 

Status

task_Status

 

Date Completed

tasks_completedate

 

Priority

task_priority

 

Last Updated By

task_modifiedby

 

Task Name

task_Subject

 

Hourly Rate

task_revenue

 

Duration

task_ctimetaken

 

Date Assigned

task_activatedstamp

 

 

Notes

All file notes and their attachments are converted.





Figure 21:
Admin – Note 

Screen Field Name

XPLAN Field Name

Notes

Note Type

entity_note_type

 

Document Name

entity_note_subject

 

Date Created

entity_note_date

 

 

Groups

Client Group

Figure 22: Groups – Client Group 



Portfolios

By default IRESS convert IPS manual data ONLY whilst attempting to create external account information against client. All datafeed data is then refreshed from inception after the conversion is completed.   However, in some cases a Practice may have specific datafeed requirements which differ from the default:

  • No IPS
  • All IPS
  • Macquarie Datafeed

If your Practice’s requirements differ from the default, please raise with your IRESS representative prior to your conversion.

This intern means that manually created transactions and notes that belongs to a service will be lost. All other Products, Transactions, and comments (i.e. those not belonging to a service) should be brought across. Orphaned transactions i.e. those where the external mapping has been removed will be treated as manual transactions. FUM, CGT, Exclude from reports and reinvest income information is converted under the edit holding screen in XPLAN All products are added to the default sub fund in XPLAN. Unit price history is not converted (all transaction amounts are stored in the transaction itself). XPLAN does not support client based assumptions so intern all projected income and growth amounts are not converted.

 

Known PlatformPlus conversion issues and data that will not be converted to XPLAN

Platformplus data is usually received as an Access database with an accompanying file with document attachments.

If your data is received in another format the conversion may be more com plex, requiring extra work by the conversion analyst and testing for the practice. There is also more chance in this scenario that relevant information may be missing. Please keep this in mind when considering the conversion timeframe.

The following table identifies common issues when converting Platformplus data. This list is not exhaustive.

Functional Area

Description

Portfolio Data

Platformplus only supplies manual portfolio data.

Past holdings and cash flows

Platformplus allows the record of past holdings and cash flows. XPLAN only holds current information for clients in these areas.

 

Therefore, as a result of the conversion, records held historically in Platformplus will appear as current in XPLAN and will be required to be cleaned up manually post-conversion.

Tasks

Tasks and workflows have a distinct format from XPLAN.

 

Given this, the conversion tool works to fit information into the XPLAN format in the best way possible.

Opt-in and fee disclosure

Opt-in and fee disclosure details are not converted

 

Custom requirements

If you require any data to be converted that is outside the scope of this document, IRESS will be happy to assess the data and your specific requirement. If the conversion can be done IRESS will provide an estimate of the time it will take to complete the conversion and the associated cost. Please discuss any custom requirements with your Transition Consultant.

 

Appendices

Post-conversion checking instructions

Once the conversion has taken place you will need to go through the data to ensure that everything has converted correctly. We recommend that you run a client list as well as check a 10-20 clients in full, comparing software to software where possible.

If any issues are discovered, the conversion analyst will need the following information to investigate and resolve the issues:

  • Client examples – experiencing the probl
  • New site screen shots – of the issue, a number if applicab
  • Original site screen shots – if you will no longer have access to your site, make sure to take screen shots of some sample client record

This information will be submitted in the Feedback Form provided in Appendices  The screen shots below illustrate how you should run your post conversion data check.

Run a ‘Client List’ management report:

 

 

This will allow you to produce a client list report to check all clients have converted.

Go through a client file from start to finish:

 

 

 

If IPS data has been converted:

Note: The default is to ONLY bring across manual data and for all datafeed data to be refreshed from inception post conversion.

 

 

The following are recommended settings for the Internet Explorer browser to access XPLAN.

  • Start Internet Explorer and select Internet Options from the Tools menu. Make sure XPLAN is in the Trusted sites zone by:
  • Select the Security tab, and click Trusted Sites.

 

  • Click Sites. The Trusted Sites dialog box displays.
  • Enter your XPLAN domain as it appears in your XPLAN site URL. For example, if your XPLAN site URL is https://mysite.xplan.iress.com.au, you should enter https://mysite.xplan.iress.com.au.
  • Click Add. Your XPLAN domain will be added to the trusted Websites list.
  • Click Close. The Trusted Sites dialog box closes and the new settings are saved.

 

Set the security level for Trusted Sites by:

  • Ensure that Trusted sites is still selected and click Custom level.

 

  • In the Reset to list, select Medium-Low, and then click Reset.
  • In the Warning! dialog click Yes to confirm the change.
  • Set Miscellaneous > Display Mixed Content to Enabled.
  • Click OK. The Security Settings - Trusted Sites Zone dialog box closes.

This also has the effect of enabling downloads, disabling the Pop-up blocker and disabling the phishing filter, but only for XPLAN (and any other trusted sites) not general internet use.

  • Activate the Advanced tab.
  • In the Settings box, ensure that the following HTTP 1.1 settings are both ticked:
    • Use HTTP 1.1
    • Use HTTP 1.1 through proxy connections.

  • Press Ok. The settings are saved.

You will need to exit and restart Internet Explorer.

 

Conversion feedback form 

Complete this form if you have identified an issue with your converted data and wish IRESS to investigate if there was a problem with the conversion.

Complete your XPLAN Transitions Conversion Feedback Form here

 

Conversion Sign Off Form

This form must be completed and returned to your transition consultant once you have checked your converted data in XPLAN and verified that all has been converted. In the absence of feedback, your conversion will be considered finalised after a period of ten working days.

Complete your XPLAN Transitions Data Conversion Sign Off Form here

IRESS Wealth Management | XPLAN Transitions | Platform to XPLAN Conversion Guide


    • Related Articles

    • Conversion Process Guide - PlatformPlus: Known Conversion Issues

        PlatformPlus Known Conversion Issues The PlatformPlus conversion tools have been standardised to support conversions without additional development required and are classified as a Standard conversion tool. Platformplus conversions have been ...
    • Conversion Process Guide - PlatformPlus: PreConversion Checklist

        PlatformPlus PreConversion Checklist Overview  The below checklist highlights key areas that must be understood and discussed with your Transition Consultant prior to your conversion date. It is intended that you and your Transition Consultant use ...
    • Conversion Process Guide - XPLAN: XPLAN Conversion Guide

        XPLAN to XPLAN Conversion Guide Overview This document provides a summary of the data that will be included when data is converted from one XPLAN site to another and should be read in conjunction with the XPLAN to XPLAN Field Guide. Please ensure ...
    • Conversion Process Guide - XPLAN: XPLAN Conversion Fact Sheet

        The IRESS transition team has a range of tools and procedures in place to perform data conversions from various sources into XPLAN for new XPLAN clients, or existing clients that move from one XPLAN site to another. We currently support the ...
    • Conversion Process Guide - RiskWiz: XPLAN Conversion Guide

        RiskWiz to XPLAN Conversion Guide Overview This document highlights data and functionality most often of concern to practices converting from RiskWiz to XPLAN, however if there is specific data and/or functionality that is not contained within 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 ...