How to locate a Joint account from a datafeed

When reviewing and locating clients accounts that are flowing through on a datafeed, Joint accounts can be a little tricky.

The IPS Datafeeds are quite accurate with automapping to either a Client or Partner, but for Joint accounts the IPS system has a bit of trouble mapping. Most of the time they can be located under the System Datafeeds menu and the manually mapped:

 

Navigate to 'Admin -> Integration -> System datafeeds':

Mapping Joint pic 1.png

 

Then navigate to 'Mappings -> IPS external accounts':

Mapping Joint pic 2.png

 

On the Search Filter list, update the following:

  • Search Account Number -> Enter Client Account number
  • Listing Option -> List All

Then press 'Search'

Mapping Joint pic 3.png

 

If you see in the search results, more than 1 entry with the same 'Portfolio Account Name', 'Vendor' and 'IPS External Account ID' & 'Vendor Adviser ID', this will confirm the account is flowing through on an active datafeed but not yet linked to an Xplan Entity.

Mapping Joint pic 4.png

 

You will then need to copy the text listed under 'Portfolio Account Name' and 'IPS External Account ID' and paste it into notepad or word as we need this at a later step.

Press the drop down Action button to the left of one of the IPS account entries for your clients account, then select 'Delete' and press 'ok' to the delete warning

Mapping Joint pic 5.png

Mapping Joint pic 6.png

 

Now you need to navigate to your client through search clients, then to 'Portfolios -> Portfolio -> Position', press your clients name at the top of the screen, then select 'Joint' for the Joint Entity in IPS

Mapping Joint pic 7.png

 

Navigate to 'Portfolios -> Admin -> External Accounts' & press 'Add External Account'

Mapping Joint pic 8.png

 

Update the following:

  • Vendor -> Platform account is held
  • Vendor's Account ID -> text copied from 'IPS External Account ID' from step above

Press 'Ok', then press 'Ok' to the confirmation popup

Mapping Joint pic 9.png

Mapping Joint pic 10.png

 

The account will now be showing in the IPS External Accounts list. Press Action drop down button, then select 'Refresh'

Mapping Joint pic 11.png

 

On the pop up, leave all boxes as they are and press 'Ok'

Mapping Joint pic 12.png

 

Navigate to 'Portfolios -> Admin -> Cash & Accounts', press the pencil paper icon to the left of the account you have just created

Mapping Joint pic 13.png

 

Update the 'Account' field (top of pop up) with the 'Portfolio Account Name' text that was copied earlier, this will then rename the account back to what it was from the datafeed

Mapping Joint pic 14.png

 

All Complete :)