Conversion Process Guide - Midwinter: XPLAN Conversion Guide

Conversion Process Guide - Midwinter: XPLAN Conversion Guide

 

Midwinter to XPLAN Conversion Guide Overview

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

  2. Obtaining a copy of your data for conversion
    Data must be received by the end of the business day prior to your conversion date.

  3. 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.

  4. 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.

  5. 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 Midwinter that will be converted to XPLAN.  It is important that you review this information so you are fully aware of how your Midwinter 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: 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

 Type

address_type

 

Address

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 Occupation 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

 

Surname

entity_dependent_dep_last_name

 

Relation

dependent_dep_rel

 

Date of Birth

dependent_dep_dob

 

Sex

dependent_dep_sex

 


Objectives

Financial


Figure 11: 
Objectives – Financial

Group Field Name

 Field Name

XPLAN Field Name

Notes

 

Long/Short term Objectives

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

 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_status

 

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

 


Cover

Group Field Name

Screen Field Name

XPLAN Field Name

Notes

 

Life Insured

Insurance_life_insured

Type

Insurance_type

Commencement Date

 

Insurance_inception_date

Annual Notice Date

 

Insurance_renewal_date

Expiry Date

 

Insurance_expiry_date

Benefit Amount

 

Insurance_benefit_amount

Benefit Frequency

 

Insurance_benefit_frequency

Waiting Period

 

Insurance_waiting_period

Sum Insured

 

Insurance_value

 

 

Benefit Status

Insurance_benefit_status

 

Installment Premium

Insurance__benefit_premium

 

Premium Type

Insurance_premium_structure

 

Insurance: Vehicle

General Insurance ID

Insurance_group_policyid

 

Description

Insurance_group_Description

 

Amount Insured

Vehicle_group_sum_insured

 

Vehicle Note

Vehicle_group_vehicle_notes

 

Insurance: Property

General Insurance Id

Insurance_group_policyid

 

Type Description

Property_group_type

Amount Insured

Property_group_address

Insurance:Other

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

 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 Assets

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

Vendor name

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 - Notes

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: 
Group - 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 you’re 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 Midwinter conversion issues and data that will not be converted to XPLAN

Midwinter 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 complex, 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.

 

Known Issues

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

Functional Area

Description

Portfolio Data

Midwinter only supplies manual portfolio data. Datafeed data will not be converted

Past holdings and cash flows

Midwinter allows the user to 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 Midwinter 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 Instruction

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 F

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.

 

 

Workstations recommended settings

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

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



  3. Click Sites. The Trusted Sites dialog box displays.
  4. 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/.
  5. Click Add. Your XPLAN domain will be added to the trusted Websites list.
  6. Click Close. The Trusted Sites dialog box closes and the new settings are saved.

 

Set the security level for Trusted Sites by:

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



  2. In the Reset to list, select Medium-Low, and then click Reset.
  3. In the Warning! dialog click Yes to confirm the change.
  4. Set Miscellaneous > Display Mixed Content to Enabled.
  5. 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.

  6. Activate the Advanced tab.
  7. 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.



  8. 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

 

    • 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 ...