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.
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.
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.
All users are converted unless requested to be mapped, contact and address information included.
Screen Field Name | XPLAN Field Name | Notes |
Surname | entity_last_name | |
Given Names | entity_first_name |
Entity: Individuals
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 |
|
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 |
|
Screen Field Name |
XPLAN Field Name |
Notes |
Trust Name |
entity_trust_name |
|
ABN |
entity_abn |
|
Tax File Number |
entity_tfn |
|
Notes |
entity_comment |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 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 |
|
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 |
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 |
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 |
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
Figure 22: Group - Client Group
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:
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.
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.
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 |
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 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. |
The following are recommended settings for the Internet Explorer browser to access XPLAN.
Set the security level for Trusted Sites by:
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 | Platform to XPLAN Conversion Guide