Conversion Process Guide - nLink: XPLAN Conversion Guide

Conversion Process Guide - nLink: XPLAN Conversion Guide

 

nLink to XPLAN Conversion Overview

This document highlights data and functionality most often of concern to practices converting from NLink 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

The section below highlights sections of the nLink client record and provides the field mapping that occurs during the data conversion. The tables provide the screen name within nLink and the XPLAN field name, along with any relevant notes.

Your IRESS representative will take you through this document, so any questions can be raised and discussed before conversion.

 

Advisers

All Users are created by the conversion unless requested to be mapped to existing Users within XPLAN

Description

XPLAN Field

Notes

 

Planners surname

 

Entity_last_name

 

 

Planners given name

 

Entity_last_name

 

 

Clients

Please note that XPLAN validates all TFN and ABN’s if these are invalid then they are ignored.

nLink Field

XPLAN Field

Notes

Financial Planner Code

Entity_first_name

 

Entity_last_name

Client Title

Entity_title

‘Mr’;

‘Mrs’;

‘Miss’;

‘Ms’;

‘Dr’;

‘Prof’

Client surname

Entity_last_name

 

Client given name

Entity_first_name

 

Preferred client name

Entity_preferred_name

 

Salutation

Entity_salutation

Eg. Mr. Conversion

Entity type

Entity_entity_type

Client and Partner only

‘S’ = Single;

‘M’ = Married;

‘V’ = Divorced;

‘W’ = Widowed;

‘U’ = Unknown;

‘F’ = Defacto;

‘P’ = Separated;

Client Sex

Entity_sex

‘M’ = Male;

‘F’ = Female Or blank

Client date of birth

Entity_dob

 

Client Occupation

Entity_iqm2_occupation

 

Client Employer

Entity_employer

 

Status of Employment

Entity_emp_status

 

Tax file number

Entity_tfn

Must be a valid TFN

Client category

Entity_client_category

 

Client home phone

Entity_contact_type

 

Entity_contact_value

Client fax number

Entity_contact_type

 

Entity_contact_value

Mobile phone number

Entity_contact_type

 

Entity_contact_value

Work phone number

Entity_contact_type

 

Entity_contact_value

Email Address

Entity_contact_type

 

Entity_contact_value

Client or Partner Webpage address

Entity_contact_type

 

Entity_contact_value

Client home address 1

Entity_address_street

1st line of home address

Home address line 2

Entity_address_street

2nd line of home address

Home address line 3

Entity_address_street

3rd line of home address

Home town

Entity_address_suburb

 

Home state

Entity_address_state

 

Client home postal code

Entity_address_postcode

 

Home country

Entity_address_country

 

Client postal 1

Entity_address_street

1st line of postal address

Postal address line 2

Entity_address_street

2nd line of postal address

Postal address line 3

Entity_address_street

3rd   line of postal address

Client postal town

Entity_address_suburb

 

Client postal state

Entity_address_state

 

Client postal code

Entity_address_postcode

 

Country

Entity_address_country

 

Australian Business Number

Entity_abn

Format is:

53-078-119-212

Is the client or partner a smoker?

Entity_is_smoker

Yes/No

 

File notes

nLink Field

XPLAN

Notes

Planner

Entity_note_owner

 

Entry date

Entity_note_date

 

File note

Entity_note_date

 

 

 

Insurance

nLink Field

XPLAN

Notes

 

Insurance Type

 

Type of cover

 

 

Insurance Status

 

entity_insurance_group_policy_status

 

 

Commencement Date

 

Entity_insurance_group_inception_date

 

 

Renewal Date

 

Entity_insurance_group_next_review_dat

 

 

Benefit Amount

 

Entity_insurance_benefit_amount

 

 

Current Premium

 

Entity_insurance_group_benefit_premium

 

 

Premium Frequency

 

Entity_insurance_group_frequency

 

 

Policy Number

 

Entity_insurance_group_policy_number

 

 

Policy Description

 

Entity_insurance_group_plan_name

 

 

Premium

 

Entity_insurance_group_benefit_premium

 

 

Insured

 

Entity_insurance_base_sum_insured

 

 

Policy Commencement Date

 

Entity_insurance_issued_date

 

Business Expense Benefit

 

Period

 

Entity_insurance_accident_period

 

Business Expense Waiting Period

Entity_insurance_waiting_period

 

Company

Entity_insurance_group_coy

 

 

Payment Method

 

Entity_insurance_group_payment_method

 

 

Notes

 

Entity_insurance_group_policy_comments

 

 

Assets

nLink Field

XPLAN

Notes

Name

Entity_asset_type_group

Mapping required

Entity_asset_type

Current Value

Entity_asset_amount

 

Purchase Date

Entity_asset_acq

 

Entity_asset_establishment

Cost Price

Entity_asset_cost

 

Description

Entity_asse_desc

 

Owner

Entity_asset_owner_string

 

 

Expenses

nLink Field

XPLAN

Notes

Expenses Label

Entity_cashflow_type

 

Mapping required

Entity_cashflow_type_group

Description

Entity_cashflow_desc

 

Owner

Entity_cashflow_owner

 

Annual Expense

Entity_cashflow_amount

 

Defaults to Annually

Entity_cashflow_freq

 

Income

nLink Field

XPLAN

Notes

 

Income Label

Entity_cashflow_type

 

Entity_cashflow_type_group

Description

Entity_cashflow_desc

 

Owner

Entity_cashflow_owner

 

 

Monthly Income

Entity_cashflow_amount

 

Defaults to Monthly

Entity_cashflow_freq

 

 

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

Known n-Link conversion issues

The following table identifies common issues when converting N-Link data. This list is not exhaustive.

Functional Area

Description

Document Attachments

Document attachments are not sent and are therefore not converted.

Portfolio Data

Portfolio data is not converted. Datafeeds will be used to refresh data where necessary.

Risk Profile

Risk Profile data is converted with these rules:

·       'Balanced' to 'Balanced'

·       'Conservative' to 'Conservative'

·       'Moderate Aggressive' to 'Growth'

·       'Aggressive' to 'High Growth'

·       'Moderately Conservative' to 'Defensive'

 

nLink data NOT converted

This section contains ‘key’ nLink data and functionality which will not be converted and is intended to flag areas that are most often of concern to Practices converting to XPLAN. However, if there is data and/or functionality that is important to your Practice and is not specifically mentioned in this booklet, please raise with your IRESS representative who will be able to advise further.

  • Advisor fees
  • Marketing details
  • Account summary
  • Financial Profile
  • Risk Profile
  • Investor profile details
  • Relationships - Dependents/Professional advisors
  • Portfolio data
  • Companies, Trusts, Superfunds, Joint and other entities
  • Liabilities

  

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 proble
  • 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 Appendix B.

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:

 

  

 

 

 

Workstations recommended settings

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 | Conversion Guide - nLink

 

    • Related Articles

    • Conversion Process Guide - nLink: PreConversion Checklist

        nLink 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 the ...
    • Conversion Process Guide - nLink: Known Conversions Issues

        nLink Known Conversion Issues Overview The n-link conversion tool have been developed to a basic level and is classified as a Non-standard conversion tool. The tool is not used with sufficient frequency for a standardised process to be built and ...
    • 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 - 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 ...
    • Conversion Process Guide - COIN: XPLAN Conversion Guide

        COIN to XPLAN Conversion Guide Overview This document highlights data and functionality most often of concern to practices converting from Coin 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 ...