CSV list

In the past, conversion analysts have found missing CSV files. A full set of 30 CSV files must be provided. Otherwise the conversion may not complete or data will be missing from the conversion. It has been necessary, on occasion, to go back to COIN for more data.

CSV file list:

EW.csv, EX.csv, HO.csv, IA.csv, IO.csv, IS.csv, LO.csv, LS.csv, PA.csv, PD.csv, PM.csv, PR.csv, RP.csv, SE.csv, SM.csv, TA.csv, TR.csv, TT.csv, UP.csv, AD.csv, AT.csv, BU.csv, CC.csv, CD.csv, CL.csv, CN.csv, CS.csv, CT.csv, DL.csv, DO.csv

CSV only

Missing data

In the past, conversion analysts have found data missing from the CSV files received. It has been necessary, on occasion, to go back to COIN for more data.

CSV only

Asset Allocation

The percentages in the asset allocation of an investment portfolio are not converted.

CSV Only

Attachments

The Task Attachment file (TA.csv) is required to be updated manually by the conversion analyst. Commas have been replaced by special characters which cause the conversion to fail if not amended.

CSV only

Insurance

Insurance data received has not allowed for standard formatting in XPLAN. Relevant data is often missing. The workaround is to ask the practice to provide a report from COIN and this is used to fill in the missing data.

CSV only

Datafeed data

Datafeed data is not provided so it cannot be converted.

CSV only

Unknown entities

Data provided for “Other” entities and dependents is incomplete. This causes unknown entities to be created in XPLAN and must be cleaned up manually after the conversion.

CSV only

Assets and Super

Assets (not including lifestyle assets) and Super are not converted if “No IPS” is selected during the conversion.

CSV only

Estate Planning

Estate Planning details are not converted. Data provided is incomplete.

CSV only

Tax File Numbers

Tax File Numbers are encrypted in the COIN database and cannot be converted into XPLAN.

CSV and SQL

Occupations

The Occupations list within XPLAN is a predefined listing that aligns with the inbuilt insurance quotation module and therefore cannot be modified. The conversion tool will look for an exact match; if this is not found the occupation field will be blank.

CSV and SQL

Investor Profiles

The Investor Profiles list in XPLAN is a predefined listing. The conversion tool will look for an exact match; if this is not found the Investor profile field will be blank.

CSV and SQL

Reviews

Reviews are created from the Next Review Date field in Coin. Frequency is not converted

CSV and SQL

Assets

Assets in COIN can be created and assigned to an entity with no name. This causes unknown entities to be created and must be cleaned up manually after the conversion.

CSV and SQL

Tasks

Tasks in COIN can be assigned to multiple users. Tasks in XPLAN can only be assigned to one user at a time. Converted tasks will only be assigned to one user and all other users associated with the task will be lost

CSV and SQL

Loan Type

The loan type list within XPLAN is a predefined listing. The conversion tool will look for an exact match; if this is not found the loan type field will be blank.

CSV and SQL

Identity check

Identity check information is not converted.

CSV and SQL

Pyramid and Strategy

Pyramid and Strategy data is not converted.

CSV and SQL

FoFA

FoFA opt-in details are not converted.

CSV and SQL

Entity Types

Entity type information is not provided in the COIN database. The entity type is determined by the entity name:

·       If the Entity has “pty” in its name then it will be converted as a company;

·       If the Entity has “ltd” in its name then it will be converted as a company;

·       If the Entity has “trust” in its name then it will be converted as a trust;

·       If the Entity has “super” in its name then it will be converted as a Superfund;

·       If the Entity has “fund” in its name then it will be converted as a Superfund;

·       Otherwise it is created as an individual entity type.

CSV and SQL

Liabilities linked to Investments

Liabilities are not linked to investments.

CSV and SQL

Insurance Policy status “existing”

The COIN Policy status “existing” will be mapped to the XPLAN policy status “inforce” as well as changing the Under Advice field to “No”.

CSV and SQL

“Joint” insured

XPLAN doesn’t support “Joint” insured.   When an insurance policy in COIN has a “Joint” insured the “Main” entity becomes the insured in XPLAN.

CSV and SQL

Insurance policy owner

The insurance policy owner is a mandatory field in XPLAN. If the policy owner hasn’t been selected in COIN or the owner isn’t a valid entity the conversion tool will use the entity reference on the insurance policy as the policy owner. This is usually the main entity.

CSV and SQL

Deleted Client groups

The Standard COIN conversion does not convert entities in deleted client groups. These deleted entities can be converted if requested by your IRES representative. The deleted client will become active clients in Xplan

CSV and SQL

Objectives

Any information contained in the Objectives tab will not be converted.

CSV and SQL

Other Questions

Any information contained in the Other Questions tab will not be converted.

CSV and SQL

Additional Rider Benefits

Only standard Life, TPD, Trauma, Income and Business expense covers are converted. Additional Rider Benefits are not converted.

CSV and SQL

Corporate Actions

The conversion process removes the linkage between the transaction and the corporate action.   It’s important to choose a specific date and ensure all your corporate actions are processed up to this date. Transactions created by corporate actions in Coin are converted as manual transactions and post conversion are not identifiable as corporate actions and cannot be reversed in XPLAN.

CSV and SQL

Custom fields

Custom fields will not be converted.

CSV and SQL