Xplan IPS Integration

Moneysoft Data Feed Integration Process – iress Xplan (IPS) Portfolio and Assets and Liabilities

When integrated, Moneysoft and Xplan deliver a powerful combination. The following guide runs through the set-up process in five short, easy to follow steps.

All versions of Xplan support data feeds. Ensure your Xplan version has the IPS module activated as this is where the data integrated into.

If you have any questions or need any help with your own set-up, please email us at support@moneysoft.com.au or call us on 1300 850 878.

For a printable version of this process please click here.

Steps

1.       Confirm you have an operational Moneysoft Professional or Partner account with active clients
  • If you do not have an active account, register here and invite your clients.
2.       Confirm your Moneysoft system data feed is switched on
  • Log in to your Xplan site.
  • From the main menu click Admin (the three cogs icon), select Integration then System datafeeds to access the list of Available System Datafeeds within your Xplan site.
  • Scroll down and confirm Moneysoft is set to On.

Note: If the status is still not set to On after 24 hours contact your Xplan site administrator to authorise the feed from the admin level.

 Integration Menu
 Moneysoft On
3.       Authenticate your Moneysoft account in Xplan
  • From the System datafeeds screen click Mappings then Advisers to add a New External Adviser Mapping.
 Mappings Menu
  • Click Add Mapping from the top right of your screen.
 Add Mapping
  • In the Add External Adviser ID window, select Moneysoft from the Provider drop down list.
 Add External Adviser ID
  • Enter your Moneysoft username and password into the relevant fields, then click save in the top right corner to complete the integration.
    • Ensure you are entering the same Moneysoft username and password you use when logging into Moneysoft as an adviser.
 Password and Username
  • If you have entered your correct username and password a success message will appear at the top of the screen.
  • It will now take up to 24 hours for the data to appear in your Xplan account.
 Success Credentials
  • If the incorrect credentials are entered a failure message will be displayed.
  • Confirm you are entering the same Moneysoft username and password you use when logging into Moneysoft as an adviser.
 Failure Credentials
4.       Set Adviser Overrides and Refresh the data to retrieve initial balances and transactions
  • Click on External Adviser Mappings, select Moneysoft from the Provider drop down list then click on the pencil icon in the Action column next to the adviser’s name.
 External Adviser Mappings
  •  In the Adviser Overrides tab set Mark account of balance to No and Create initial balances to Yes.
 Adviser Overrides
  • From the Refresh Adviser Mapping screen, set Delete existing data to Yes then click Ok to retrieve the initial balances and transactions.
 Refresh Adviser Mapping
5.       Map Clients’ Moneysoft data to Xplan
  • From the main menu click Admin (the three cogs icon), select Integration then System datafeeds.
  • From the System datafeeds screen click Mappings then IPS external accounts.
 IPS External Accounts Menu
  • In the Search Filter select the following:
    • Provider: MoneySoft.
    • Listing Option: List Unmapped to return list of all data feeds that are not yet mapped (linked) to any clients in Xplan.
 IPS External Account
  • Click Search to return all data feeds that meet the filter options.
    • If there are no data feeds returned, data has not yet begun to flow through.
    • If Moneysoft data has flowed through, you will be able to map (link) the data to your clients in Xplan.
6.       Check the Client’s IPS Portfolio Position
  • In the client’s Xplan Profile expand Portfolio (IPS) then click Portfolio and select Position.
 Portfolio Screen
  • In the Position screen set the Aggregation option to No aggregate to view all accounts.
 Aggregation
7.       Link the Client’s Moneysoft accounts in the Assets and Liabilities Module in Xplan
  • From the Financial Information drop down menu select Assets & Liabilities.
 Financial Information
  • If there is no Asset or Liability present, it will need to be created.
 Assets and Liabilities
  • Link the IPS account to the Asset or liability.
 Link IPS Account
Some things that you should be aware of about this data feed

Balances

  • The Out of Balance reconciliation notification is turned on by default for this data feed as Moneysoft is unable to provide pending transactions before they are processed, while the balance provided is the available cash balance, including the effect of these transactions.
  • An Out of Balance error will occur whenever there is a difference between the available and actual cash balances. Advisers who do not wish to see out of balance notifications in the Portfolio screens should edit the Moneysoft data feed settings to, Mark account out of balance and / or Mark position out of balance.

Transactions

  • Transaction types are customisable by users within the Moneysoft system and hence many will lack an accurate mapping to an IPS transaction type. Advisers who would like a different IPS categorisation for particular Moneysoft transaction types can use the Transaction Type Mappings & Income Type Mappings functionality within Xplan (against a users Adviser Mappings) to achieve this.

Data Access

  • If clients have turned adviser access OFF, Advisers must ask the client to enable sharing access to their accounts within the Moneysoft before details can be released or Accounts will not appear in Xplan or transaction descriptions will appear masked.

Fields and API Data Points

Below is a list of data items and fields which from part of the integration and sync to and from Xplan as part of the Iress OPEN API integration. As more fields and API data points are made available by Xplan, Moneysoft will continue to develop and enhance the mappings and integration.

Item

Create

Read

Update

Delete

client

 Yes

Yes

 Yes

 Yes

partner

 Yes

 Yes

 Yes

 Yes

contact

 Yes

Yes

 Yes

 Yes

address

 Yes

 Yes

 Yes

 Yes

dependent

 Yes

 Yes

 Yes

 Yes

expense

 Yes

 Yes

 Yes

 Yes

estateplanning

 No

 Yes

 Yes

 No

goal

 Yes

 Yes

 Yes

 Yes

income

 Yes

 Yes

 Yes

 Yes

insurance

 No

 Yes

 No

 No

liability

 Yes

 Yes

 Yes

 Yes

objective

 Yes

 Yes

 Yes

 Yes

portfolio

 No

Yes No

No

retirementincome

 Yes

 Yes

 Yes

 Yes

superannuation

 Yes

 Yes

 Yes

 Yes