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.
During this phase a Transition Consultant will work with you to prepare for the conversion of your data.
Data must be received by the end of the business day prior to your conversion date.
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.
IRESS completes the import of custom fields, choice value mappings, updating of risk profiles etc. on the next day after the data import completes.
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.
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 |
||||
|
||||
Address |
||||
Phone |
Contact|Detail |
entity_contact |
value |
|
Mobile |
||||
Fax |
||||
|
||||
Address |
||||
Title |
Key Details|Title |
entity |
title |
|
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 |
|
Figure 5 - Superannuation summary
Figure 6 - Platform Super Fund
Figure 7 - Self Managed Super Fund
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 |
|
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
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 |
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 |
|
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 |
|
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 |
|
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.” |
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 |
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 |
Power of Attorney Date |
Power of Attorney|Date |
entity_attorney |
date |
|
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 |
Contact|Detail |
entity_contact |
value |
|
Consultant Type |
Professional Adviser|Type |
entity_profadviser |
adviser_type |
|
Phone (H) (W)(Fax) |
Contact|Type |
entity_contact |
type |
|
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 |
|
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 |
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 |
|
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 |
Balance Sheet-Liability|Comment |
entity_liability |
comment |
1. Prefix with "Interest Only 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 |
|
Figure 41 – Insurance - Combined
Figure 42 – Insurance – Types of Policy
Figure 43 – Insurance – Policy Purpose
Figure 44 – Insurance – Payment Options
|
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 |
Insurance Group|Commission Comments |
entity_insurance_group |
commission_comments |
1. Prefix with "Commission Type: " |
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 % |
Risk|Loading Notes |
entity_insurance |
loading_notes |
1. Prefix "Loading % :" |
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 |
|
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 |
|
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 |
|
Please note the following rules that apply to the creation of entities within XPLAN during conversion.
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. |
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.
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.
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:
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.
The following are recommended settings for the Internet Explorer browser to access XPLAN.
URL is https://mysite.xplan.iress.com.au, you should enter https://mysite.xplan.iress.com.au.
Set the security level for Trusted Sites by:
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.
You will need to exit and restart Internet Explorer.
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
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