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.
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.
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.
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.
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.
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.
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 |
|
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 |
nLink Field |
XPLAN |
Notes |
Planner |
Entity_note_owner |
|
Entry date |
Entity_note_date |
|
File note |
Entity_note_date |
|
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 |
|
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 |
|
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 |
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 |
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' |
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.
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.
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:
The following are recommended settings for the Internet Explorer browser to access XPLAN.
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 - nLink