Conversion Process Guide - AdvisorLogic: XPLAN Conversion Guide

Conversion Process Guide - AdvisorLogic: XPLAN Conversion Guide

 

AdviserLogic to XPLAN Conversion Guide Overview

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

 

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

The section below highlights sections of the AdviserLogic client record and provides the field mapping that occurs during the data conversion. The tables provide the screen name within AdviserLogic 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.

 

User | Advisers

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

 Figure 1 - List of Users - (Tools - Administrative Tools – Practice – Advisers)

 

 Figure 2 - User Profile (when clicking on user id in list)

 

 Figure 3 - Logon ID profile (Tools, Adviser Profile, Edit Profile)

 

AdviserLogic

Screen Field Name

Screen Field Name

 Group

 Field Name

 Notes

First Name

Key Details| FirstName

Entity

first_name

 

Surname

Key Details|Surname

entity

last_name

 

Post Code

Address|Postcode

entity_address

postcode

 

State

Address|State

entity_address

state

 

Address 1

Address|Street

entity_address

stree

 

Address 2

Suburb

Address|Suburb

entity_address

suburb

 

Phone

Contact|Type

entity_contact      

type

 

Mobile

Fax

Email

Address

Phone

Contact|Detail

entity_contact

value

 

Mobile

Fax

Email

Address

Title

Key Details|Title

entity

title

 

 

Fact Finder (This includes partner information)

Basic Information

Figure 4 - Fact Finder - Basic Information

 

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

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Title

Key Details Title

entity

Title

Entity

Partner

First Name

Key Details First Name

entity

First_name

Entity

Partner

Surname

Key Details Surname

entity

Last_name

Entity

Partner

Middle Name

Key Details Middle Name

entity

Middle_name

Entity

Partner

1.Driver’s Licence

Key Details Comment

entity

comment

1.Prefix with “Driver’s Licence.’

2.Notes

2.No prefix on normal notes

TFN

Key Details Tax File Number

entity

tfn

Entity

Partner

Advisor

Key Details Client Adviser

Entity

Client adviser

 

Notes

KeyDetails Comment

Entity

comment

 

Gender

Key Details Gender

Entity

Sex

Entity

Partner

Marital Status

Key Details Marital Status

Entity

Marital_status

Entity Partner

Date of Birth

Key Details Date of Birth

entity

dob

Entity Partner

Preferred Name

Key Details Preferred Name

Entity

Preferred_name

Entity Partner

Category

Key Details Category

Entity

Client_category

 

Status

Key Details Entity Status

Entity

Entity_client_status

 

Referred By

Referral Referred By

Entity

Referral_referred by

 

Wedding Date

Key Details Marriage Date

Entity

Marriage_date

 

FSG Version

FSG FSG Version

Entity_fsg

Fsg_version

 

Occupation

Emplyment Occupation (Standard)

Entity_employment

Iqm2_occupation

Entity Partner

Job Title

Employment Job Title

Entity_employment

Jobtitle

Entity Partner

Centrelink No.

Centrelink Centrelink Relationship Number

Entity

Centrelink_relationship_number

Entity Partner

Last Review Date

Review Completed Date

Entity_review

Date_completed

 

Next Review Date

Review Date

Entity_review

Date

 

Review Frequency

Review Frequency

Entity_review

frequency

 

 

Superannuation

 Figure 5 - Superannuation summary

 

Figure 6 - Platform Super Fund

 

Figure 7 - Self Managed Super Fund

 


Figure 8 - Industry Super Fund

 


Figure 9 - Platform Pension 

 


Figure 10 - Industry Pension

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Super Contribution (%)

 

Superannuation|E mployer Contribution Rate

entity

employer_ctr_rate

 

Description

 

Superannuation- Funds|Fund Name

 

entity_fund

fund_name

 

Account Code

 

Superannuation- Funds|Reference Number

 

entity_fund

fund_refnum

 

Account Status

Superannuation- Funds|Status

entity_fund

fund_status

 

1. Issue Date

Superannuation- Funds|Date

Commenced

entity_fund

date_commenced

1. Platform Superfund

 

2. Commencement Date

2. Self Managed SuperFund

3. Issue Date

3. Industry Super Fund

4. Issue Date

4. Platform Pension

5. Issue Date

5. Industry Pension

Current Balance

 

Superannuation Funds Balance-

entity_fund

fund_balance

 

 

Entities

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Company Name

Key Details

Company|Company

Name

entity

company_name

 

ABN

Key Details|ABN

entity

abn

 

ACN

Key Details|Company

Numebr

Entity

Company_number

 

TFN

Key Details|Tax File Number

entity

tfn

 

Figure 11 - Fact Finder – Entities  

 

Contact

 Figure 12 - Fact Finder - Contact Details

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Country

Address|Country

entity_address

country

 

Post Code

Address|Postcode

entity_address

postcode

 

Preferred Email Address

Address|Preferred

entity_address

preferred

 

Preferred Contact Address

Preferred Phone Number

State

Address|State

entity_address

state

 

Line 1

Address|Street

entity_address

street

 

Line 2

Suburb

Address|Suburb

entity_address

suburb

 

Home Address

Address|Type

entity_address

type

Entity Partner

Mailing Address

Work Address

Other Address

Phone (H) (W)(Fax)

Contact|Detail

entity_contact

value

Entity Partner

Email (H)(W)

Notes

Contact|Notes

entity_contact

notes

Entity Partner

Phone (H) (W)(Fax)

Contact|Type

entity_contact

type

Entity Partner

Email (H)(W)

Australian Resident

Key Details|Resident Status

entity

resident_status

Entity Partner

Do not Contact

KeyDetails|Privacy

entity

privacy

Entity Partner

 

Income & Expenses

 Figure 13 - Fact Finder – Income

 

Figure 14 - Fact Finder - Income - Income Type

 

 

 Figure 15 - Fact Finder - Income - Status

 

Figure 16 - Fact Finder - Expenses

 

 

Figure 17 - Fact Finder - Expenses - Expense Type

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Amount

Cashflow|Amount

Entity_cashflow

amount

Income

Expense (annualised figures from AdviserLogic)

Notes

Cashflow|Cashflow Notes  

entity

cashflow_notes

Income

Income Type

Cashflow|Cashflow Type

entity_cashflow

type

If no Subtype field, DefaultValue chosen

Expense Type

Cashflow|Cashflow Type General

entity_cashflow

type_group

Income & Expense

Description

Cashflow|Description

entity_cashflow

desc

Income & Expense

Owner

Cashflow|Owner

entity_cashflow

owner

Income & Expense

Start Date

Cashflow|Start Date

entity_cashflow

startdate

In Expenses

Employer

Employment|Employer

entity_employment

employer

EntityPartner

Status

Employment|Status

entity_employment

emp_status

 

Super Contribution (%)

Superannuation|Employer Contribution Rate

entity

employer_ctr_rate

 

Superfund

Superannuation Funds|Fund Name

entity_fund

fund_name

 

  

Annuities

 Figure 18 - Fact Finder - Annuities

 

 Figure 19 - Annuities - Fact Finder - Annuities - Pension Amount Type

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Owner

Annuity|Owner

entity_annuity

owner

 

Description

Annuity|Description

entity_annuity

description

 

Pension Indexation Rate

Annuity|Escalation

Percentage

entity_annuity

escalation

 

Notes

Annuity|Notes

entity_annuity

notes

 

Balance Date

Annuity|Values

Last Updated

entity_annuity

values_last_updated

 

DeductibleAmount ($)

Annuity|Tax Deductible Amount

entity_annuity

tax_deductible_amount

 

Rate ofReturn (%)

Annuity|RCV

entity_annuity

rcv_percentage

 

PensionAmount

Annuity|RCVAmount

entity_annuity

rcv_amount

 

PensionAmount Type

Annuity|Escalation Percentage Type

entity_annuity

escalation_type

 

 

Dependents

 Figure 20 - Fact Finder - Dependents

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Given Name

Dependant|First Name

entity_dependent

dep_name

 

Relationship

Dependant|Relation

entity_dependent

dep_rel

 

Birth Date

Dependant|Date of Birth

entity_dependent

dep_dob

 

To Age

Dependant|Dependant Until Age

entity_dependent

dep_until_age

 

Surname

Dependant|Surname

entity_dependent

dep_last_name

 

Notes

Dependant|Comments

entity_dependent

dep_comment

 

 

Health

 Figure 21 - Fact Finder – Health 

 

 

 Figure 22 - Fact Finder - Health - Health Status

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Health Status

Key Details|Health

entity

health

 

Smoker

Key Details|Smoker

entity

is_smoker

 

Height (meters)

Key Details|Height

entity

height

 

Weight(kilograms)

Key Details|Weight

entity

weight

 

Health Insurance

Medical

entity_med ical_insurance

cover_notes

 

Insurance|Cover

 

 

 

Notes

 

 

 

Referred By

Referral|ReferredBy

entity

referral_referred_by

1. Are you on any medications, or been on any recently?

Risk

Medical|Medical

History Details

entity

Medical_history_details

1. Prefix answer with "Recent Medications.”

2. Have you had any Physical ailments (back,neck, etc)

2. Prefix answer with "Physical ailments”

3. Have you made a claim on an

Insurance Policy

or workers'

3. Prefix answer with"Insurance/Workers” Comp Claim “

4.Have your parents or any siblings sufferend from a major

trauma (heart problems, cancer, stroke, etc)?

4. Prefix answers with “Parent/Siblings Major Trauma.”

 

Goals & Objectives

 Figure 23 - Fact Finder - Goals & Objectives – Priority

 

If time frame is less than 5 years

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Priority(choice)

Goals|Comments

entity_stobjective

obj_st_priority

 

Objectives

Goals|Objective

entity_stobjective

obj_st_choice

Defaults to “Other”

Objectives(Text)

Goals|Objective

entity_stobjective

obj_st_other

 

Approximate Amount

Goals|Target Amount

entity_stobjective

obj_st_amount

 

Time Frame(Years)

Goals|Timeframe

entity_stobjective

obj_st_timeframe

Converted to months

 

If time frame is over 5 years

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Priority(choice)

Goals|Comments

entity_ltobjective

obj_lt_priority

 

Objectives

Goals|Objective

entity_ltobjective

obj_lt_choice

Defaults to “Other”

Objectives(Text)

Goals|Objective

entity_stobjective

obj_st_other

 

Approximate Amount

Goals|Target Amount

entity_ltobjective

obj_lt_amount

 

Time Frame(Years)

Goals|Timeframe

entity_ltobjective

obj_lt_timeframe

Converted to months

 

Estate Planning

 Figure 24 – Fact Finder – Estate Planning

 

 Figure 25 – Fact Finder – Estate Planning – Estate Planning Contacts

 

 Figure 26 – Fact Finder – Estate Planning – Estate Planning Contacts – Contact Type

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Date of Will

Estate|Date of Will

entity

date_of_will

 

Location of Will

Estate|Location

entity

will_location

 

1.Testamentary trust (Yes/No Dropdown box)

Estate|Notes

entity

will_notes

1. If 1.Testamentary trust flag = Yes, prefix with "Testamentary Trust: Yes"

2.Guardianship

(Yes/No) drop

Down Box

2. If Guardianship flag= Yes, prefix with Guardianship: Yes”

3.Date of

Guardianship

3. If Date of Guardianship is populated, prefix with “Guardianship Date : dd/mm/yyyy”

4.Guardianship

Note

4. Copy notes if Guardianship note is populated.

Will Prepared

Estate|Will Exists

entity

will_exists

 

First Name

Executor of Will|First Name

entity_executor

fname

 

Notes

Executor of Will|Notes

entity_executor

notes

 

Surname

Executor of Will|Surname

entity_executor

lname

 

Firstname

Power of Attorney|Firstname

entity_attorney

fname

 

Notes

Power of Attorney|Notes

entity_attorney

notes

 

Surname

Power of Attorney|Surname

entity_attorney

lname

 

Type

Power of Attorney|Type

entity_attorney

type

AL: Enduring to XP: Enduring
AL:General to XP:Normal
AL: Medical to XP: Medical

Power of Attorney Date

Power of Attorney|Date

entity_attorney

date

 

 

Consultants

 Figure 27 – Fact Finder – Consultants – Consultant Type

 

 

 Figure 28 – Fact Finder – Consultants – Consultant Type

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Name

Key Details|Entity Name

entity

entity_name

 

Street Address

Address|Street

entity_address

street

 

Suburb

Address|Suburb

entity_address

suburb

 

State

Address|State

entity_address

state

 

Country

Address|Country

entity_address

country

 

Mobile
Phone1
Phone2
Email
Fax

Contact|Detail

entity_contact

value

 

Consultant Type

Professional Adviser|Type

entity_profadviser

adviser_type

 

Phone (H) (W)(Fax)
Email (H)(W)

Contact|Type

entity_contact

type

 

 

Risk Profiler

From XPLAN version 2.10 a reason must to be specified when changing Risk Profiles. The conversion tools will apply the reason "Created by conversion" when Risk Profiles are set because Risk Profile mappings were requested.

AdviserLogic

XPLAN

Conservative

Conservative

Moderate

Moderate Defensive

Balanced

Balanced

Growth

Growth

High Growth

Aggressive

  

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Australian Shares

Profile|Class 1 Target

entity

profile_c1_target

 

International Shares

Profile|Class 2 Target

entity

profile_c2_target

 

Direct Property

Listed Property

Profile|Class 3 Target

entity

profile_c3_target

 

International Property

Profile|Class 4 Target

entity

profile_c4_target

 

Australian Fixed Interest

Profile|Class 5 Target

entity

profile_c5_target

 

International Fixed Interest

Profile|Class 6 Target

entity

profile_c6_target

 

Cash

Profile|Class 7 Target

entity

profile_c7_target

 

Other

Profile|Class 11 Target

entity

profile_c11_target

 

 

Assets/Liabilities

Assets

 Figure 29 – Assets/Liabilities – Existing Assets 

 

 Figure 30 – Assets/Liabilities – Assets – Australian Shares

 

 Figure 31 – Assets/Liabilities – Assets – Managed Funds

 

 Figure 32 – Assets/Liabilities – Assets – BankDeposit

 

 Figure 33 – Assets/Liabilities – Assets – Investment Property

 

 Figure 34 – Assets/Liabilities – Assets – Family Home

 

 Figure 35 – Assets/Liabilities – Assets – Custom Product

 

 Figure 36 – Assets/Liabilities – Assets – Other Investment

 

 Figure 37 – Assets/Liabilities – Assets – IndustrySuper

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Account Code

Asset-Investment|Policy Number

entity_asset_investment

policy_number

 

Maturity Date

Asset-Investment|Maturity Date

entity_asset_investment

maturity_date

 

Purchase Price

Asset-Investment|Initial Investment

entity_asset_investment

initial_investment

 

ASX Code
APIR Code

Asset-Investment|Product Code

entity_asset_investment

product_code

 

Description

Balance Sheet-Asset|Description

entity_asset

desc

 

Purchase Date

Balance Sheet-Asset|Purchase Date

entity_asset

acq

 

Type

Balance Sheet-Asset|Type

entity_asset

type_group

 

Owner

Balance Sheet-Asset|Owner Type

entity_asset

owner

 

Notes

Balance Sheet-Asset|Comments

entity_asset

comments

 

Balance Date

Balance Sheet-Asset|Valuation Date

entity_asset

valuation_date

 

Subject to CGT (Tick box)

Balance Sheet-Asset|Subject to CGT

entity_asset

subject_to_cgt

 

BSB

Balance Sheet-Asset|Bank Branch Code

entity_asset

bank_branch_number

 

Account Number

Balance Sheet-Asset|Bank Account Number

entity_asset

bank_account_number

 

HIN/SRN

Balance Sheet-Asset|Account/Client Number

entity_asset

account_client_number

 

Platform

Balance Sheet-Asset|Supplier

entity_asset

supplier

 

Unit Balance

Balance Sheet-Asset|Units

entity_asset

units

 

Street

Balance Sheet-Asset|Property Street

entity_asset

property_street

 

Suburb

Balance Sheet-Asset|Property Suburb

entity_asset

property_suburb

 

Sate

Balance Sheet-Asset|Property State

entity_asset

property_state

 

Post Code

Balance Sheet-Asset|Property Postcode

entity_asset

property_postcode

 

Country

Balance Sheet-Asset|Account Holder Name

entity_asset

property_country

 

 

Liabilities

 Figure 38 – Assets/Liabilities - Liabilities

 

 Figure 39 – Assets/Liabilities – Liability - Mortgage

 

 Figure 40 – Assets/Liabilities – Liabilities – Other Types of Liabilities

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Type of Liability

Balance Sheet-Liability|Loan Type

entity_liability

type

 

Lender

Balance Sheet-Liability|Institution

entity_liability

inst

 

Outstanding Amount

Balance Sheet-Liability|Outstanding Balance

entity_liability

amount

 

Interest Rate

Balance Sheet-Liability|Interest Rate (pa)

entity_liability

rate

 

Repayment Amount

Balance Sheet-Liability|Repayment Amount

entity_liability

repayment

 

 

Balance Sheet-Liability|Type

entity_liability

type_group

Based upon Type of Liability

Owner

Balance Sheet-Liability|Owner Type

entity_liability

owner

 

Credit Limit

Balance Sheet-Liability|Credit Limit

entity_liability

credit_limit

 

1. Interest Only Expiry Date
2. Notes
3. Fixed Rate Expiry Date

Balance Sheet-Liability|Comment

entity_liability

comment

1. Prefix with "Interest Only Expiry Date: "
2. No prefix for normal notes
3. Prefix with "Fixed Rate Expiry Date: "

Tax Deductibility

Balance Sheet-Liability|Deductible

entity_liability

deductible

 

Loan Structure

Balance Sheet-Liability|Repayment Type

entity_liability

repayment_type

 

Settlement Date

Balance Sheet-Liability|Start Date

entity_liability

settlement

 

Loan number

Balance Sheet-Liability|Account Number

entity_liability

account

 

Initial Loan Amount

Balance Sheet-Liability|Original Balance

entity_liability

original_amount

 

Rate Type

Balance Sheet-Liability|Interest Rate Type

entity_liability

rate_type

 

Desciption

Balance Sheet-Liability|Description

entity_liability

package_name

 

Remaining Term (Years)

Balance Sheet-Liability|Loan Term (integer)

entity_liability

loan_term

 

Remaining Term (Years)

Balance Sheet-Liability|Loan Term (Type)

entity_liability

loan_term_type

Value in Years

As at

Balance Sheet-Liability|Values Last Updated

entity_liability

values_last_updated

 

Ongoing Commission (%)

Balance Sheet-Liability|Ongoing Commission

entity_liability

trail_commission

 

 

Insurance

Figure 41 – Insurance - Combined

 

Figure 42 – Insurance – Types of Policy

 

 

Figure 43 – Insurance – Policy Purpose

 

Figure 44 – Insurance – Payment Options

 

  • Insurance policies with the policy type of Home, Contents, General and Landlord will convert to the General Insurance section in XPLAN.
  • Insurance policies with the policy type of Health Insurance will convert to the Medical Insurancesection in XPLAN.
  • Insurance policies owned by Superfunds will be converted under the Superfund entity.

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Account Number

Insurance Group|Bank Account Number

entity_insurance_group

account_number

 

Account Name

Insurance Group|Bank Account Name

entity_insurance_group

account_name

 

Beneficiaries

Insurance Group|Beneficiary

entity_insurance_group

beneficiary

 

Business Expense Sum Insured

Risk|Benefit Amount

entity_insurance

benefit_amount

 

Policy Purpose

Insurance Group|Business Protection Purpose

entity_insurance_group

policy_purpose

 

1. Commission Type
2. Upfront %
3. Ongoing %

Insurance Group|Commission Comments

entity_insurance_group

commission_comments

1. Prefix with "Commission Type: "
2. Prefix with "Upfront % "
3. Prefix with "Ongoing % "

Income Protection Sum Insured

Risk|Benefit Amount

entity_insurance

benefit_amount

 

Life Sum Insured

Risk|Base Sum Insured

entity_insurance

base_sum_insured

 

Next Review Date

Insurance Group|Next Review Date

entity_insurance_group

next_review_date

 

Method

Insurance Group|Payment Method

entity_insurance_group

payment_method

 

Policy Name

Insurance Group|Plan Name

entity_insurance_group

plan_name

 

Notes

Insurance Group|Policy Comment

entity_insurance_group

policy_comments

 

Annual Policy Fee

Insurance Group|Policy Fee

entity_insurance_group

policy_fee

 

Policy Number

Insurance Group|Policy Number

entity_insurance_group

policy_number

 

Policy Owner

Insurance Group|Policy Owner

entity_insurance_group

policy_owner

 

Status

Insurance Group|Policy Status

entity_insurance_group

policy_status

 

Premium Frequency

Insurance Group|Premium Frequency

entity_insurance_group

frequency

 

Premium

Insurance Group|Benefit Premium

entity_insurance_group

benefit_premium

 

TPD Sum Insured

Risk|Sum Insured

entity_insurance

value

 

Trauma Sum Insured

Risk|Sum Insured

entity_insurance

value

 

Insurer

Insurance Group|Underwriter

entity_insurance_group

coy

 

Smoker

Key Details|Smoker

entity

is_smoker

 

Type of Policy

Risk|Policy Type

entity_insurance

type

If not matched to Type Group

Type of Policy

Risk|Policy Category

entity_insurance

type_group

 

Issue Date

Risk|Issue Date

entity_insurance

issued_date

 

Premium Basis

Risk|Premium Structure

entity_insurance

premium_structure

 

Life Insured

Risk|Life Insured

entity_insurance

life_insured

 

Exclusions

Risk|Exclusion Notes

entity_insurance

loading_exclusion_notes

 

1. Loading %
2. Reasons for Loading

Risk|Loading Notes

entity_insurance

loading_notes

1. Prefix "Loading % :"
2. Reasons comment

 

Tasks

 Figure 45 – Tasks - Add

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Assigned To

Task| Assignee

task

assignee

 

Time Spent on Task (Minutes)

Task| Total Time Taken

task

total_timetaken

 

Extended Description

Task|Description

task

description

 

Due By

Task|Due Date

task

duedate

 

Start On

Task|Start Date

task

startdate

 

Status

Task|Status

task

status

 

Brief Description

Task|Subject

task

subject

 

Task Type

Task|Type

task

taskkind

 

  

File Notes

 Figure 46 – File Notes - Summary

 

 Figure 47 – File Notes – Add File Note

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Filename

Note|Attachment Name

entity_note

filename

 

Date Entered

Note|Date

entity_note

date

 

Lock

Note|Edit/Delete Privilege

entity_note

edit_priv

 

Title

Note|Subject

entity_note

subject

 

Comments

Note|Text

entity_note

data

 

Category

Note|Type

entity_note

type

 

 

Document Vault

Figure 48 - Document Vault – Summary Screen

 

Figure 49 - Document Vault - Add

 

AdviserLogic

Screen Field Name

Screen Field Name

 

Group

 

Field Name

 

Notes

Year

Document Note|Date

docnotes

date

 

Notes

Document Note|Text

docnotes

text

 

Category

Document Note|Type

docnotes

type

 

Filename

Note|Attachment Name

entity_note

filename

 

Visibility

Note|Permission

entity_note

permission

 

 

Entities

Please note the following rules that apply to the creation of entities within XPLAN during conversion.

  1. Joint - Joint entity types are NOT created
  2. Child/Dependant - Created as a dependant in XPLAN listed against the Client
  3. Company - Created as Company entity type
  4. Trust - Created as Trust entity type
  5. Superfund - Created as Superfund entity type 
  6. Other - Created as Company entity type

      

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

1. Known Issues

Functional Area

Description

 

XPLAN Entities

Partner, Company, Superfund and Trusts entity records can exist in AdviserLogic

without an adviser. The adviser from the primary entity will be used to determine the adviser in XPLAN for Partner, Company, Superfund and Trusts entities.

 

Joint Entities

AdviserLogic allows for joint entities to have assets, liabilities, and cashflow items.

XPLAN does not   support joint entities.   Assets, liabilities and   cash flow items belonging to joint entities are converted and linked to both client and partner with a

50% split in ownership.

Cashflow Comments/ Notes

Notes for cashflow items are not converted as AdviserLogic allows for separate notes in each cashflow item. XPLAN only has functionality for one general cashflow note for each client.

Recommended

Insurance

Policies in the recommended insurance section are not converted.

Portfolio Data

Portfolio data has never been converted for Adviserlogic conversions.

Superannuation funds

Superannuation fund data is converted to the existing Superannuation group fields in XPLAN. The conversion tool also creates the Superannuation funds as new entities

Current, closed and recommended Superannuation funds

All current, closed and recommended Superannuation funds will be converted.

 

2. AdviserLogic data NOT converted

This section contains ‘key’ AdviserLogic 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.

  •  Portfolio - The Portfolio section is not converted to XPLAN.
  •  Workflow - Workflow/Threads are not converted to XPLAN.
  •  Reports - Reports are not converted to XPLAN.
  •  Custom Fields - Custom filed are not converted to XPLAN.

 

Custom requirements

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.

 

Appendices

1. 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 problem
  • New site screen shots – of the issue, a number if applicable
  • 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:   

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.

 

     

 

2. 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 then click Trusted Sites.

 

  • Click Sites. The Trusted Sites dialog box display
  • 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 lis
  • Click Clo 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 chan
  • Set Miscellaneous > Display Mixed Content to Enabled.
  • Click OK. The Security Settings - Trusted Sites Zone dialog box clo

 

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

 

  • Press Ok. The settings are saved.

You will need to exit and restart Internet Explorer.

 

XPLAN Transitions 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

 

XPLAN Transitions Data 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 - AdvisorLogic to XPLAN  


    • Related Articles

    • Conversion Process Guide - AdvisorLogic: PreConversion Checklist

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