XPlan

Print Friendly and PDF

Overview


A file import function is available for Xplan users to import investment data into Simple Fund 360.

Navigation


 

From the Main Toolbar, go to Connect.
Select Feed Management from the list.

68.png

Select the Wraps and Platforms Global tab.

9.png

 

Fund Filter


The Wraps and Platforms screen can now be filtered to either a Global or Fund view. The Global view will show all Wrap accounts for your Simple Fund 360 firm, while the Fund view will display Wrap accounts specifically for the selected fund.

XPlan File Export


Prerequisites for exporting the XML file for Simple Fund 360:

  • Set the BGL Identifier;
  • Datafeed Import is allowed under your User Capability.

 

Set the BGL Identifier - each client


Note: If you are a previous Simple Fund Desktop user who has setup identifiers for clients, skip this step.

In XPlan, while accessing a client:

  1. On the navigation menu, select Portfolios, then select Admin > External Accounts.
  2. Select Add External Client.
  3. Select BGL Entity from the Vendor list.
  4. Enter a BGL unique identifier for this portfolio in the Vendor's Client ID box.
  5. Select Add. The maps the entire portfolio and its sub-funds in XPLAN to a BGL super fund.

Export XML


  1. Access the datafeeds manager by selecting Home >> Portfolio Functions >> User Datafeeds.
  2. In the navigation menu, select Export to BGL > Export Data. The BGL Exporter displays.
  3. Under Export Options set the Date Range to export, and the Type of Date to use (Trade Date, Settlement Date or Tax Date).

    Handle SMSF/Trust Listing

    The checkbox Handle SMSF/Trust member linking is left unticked. Member transactions are not supported in the XPlan feed.

  4. Select Include XPLAN gain/loss in order to pass the XPLAN calculated capital gain or loss on sales/disposals.
  5. In the Export Entities table, select the client portfolios to export.
  6. Select Export. XPLAN processes the export as a background process. When completed, the exported information is given to the user in an XPLAN message. The exported information is in an XML file, which is sent to the user in a Zip archive file. The XML file must be extracted from the Zip file to import it into BGL.

Add Feed - Each Fund


    1. From the Wrap and Platform Global tab, select (+) Setup.

      10.png
    2. The Setup Wrap and Platform Feed screen will appear. Begin typing the fund name into the field and select it from the drop-down list below.

    3. Select XPlan as the Feed Provider.

    4. Input the BGL Identifier. The identifier is created in XPlan (see prior tab).



      Note: If data has been entered manually for this feed prior to its activation, input a Do not import data before date in the relevant field to the last date of manual data entry. 
    5. Select the Bank Account for the feed.

Note: Selecting Advanced Options will display a drop down of any bank or other non-unitised investments appearing in the Security Code chart. This chart will contain the relevant mapping codes used by the feed to load data to the correct account. These fields will be empty until the feed is operating.

Potential Duplicate Accounts

If you do not set this up, the feed will automatically create new accounts and you might end up with duplicate accounts.

  1. Select Save. Complete this for each fund.

XPlan File Import


  1. A manual file received from XPlan within the sent zip folder can be uploaded into Simple Fund 360.
  2. From the Wraps and Platforms Global tab, select the Import Manual File icon.

    43.png
  3. From the left hand side of the screen, ensure Xplan XML import is selected. 

    93.png
  4. Browse for the file in the box next to File Location. Ensure the XML file is stored on your computer or network.

    94.png

  5. Select Import.

    Bulk Fund Import is currently not supported. A file will need to be uploaded for each fund.

Data Import


What data is imported?

All investment cash, income (dividends, interest, distributions), and investment transactions will be allocated to the correct account in Simple Fund 360. For purchases of new investments not previously held by the fund, new accounts will be created and transactions will be automatically allocated. Member transactions such as contributions are not imported.

 

 

Which transactions will be matched?

Investment and income transactions will be automatically matched to their corresponding cash transactions by Simple Fund 360.

Any cash transaction that is not investment related (e.g. an expense) will be automatically matched once Transaction Matching Rules have been set up.

Note: Selecting Advanced Options will display a drop down of any bank or other non-unitised investments appearing in the Security Code chart. This chart will contain the relevant mapping codes used by the feed to load data to the correct account. These fields will be empty until the feed is operating.

Potential Duplicate Accounts

If you do not set this up, the feed will automatically create new accounts and you might end up with duplicate accounts.

 

 

 

 

 

 

 

 

 

 

 

 

 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.

  • synced-from-confluence