Cash Movements (Bank Transactions
|Investment Movements (Buys & Sells)
|Income Movements (Dividends & Distributions)
BGL has integrated with MLC to provide users with an XML file import function.
The XML file exported from MLC will provide the following data:
Cash movements (bank transactions).
Investment movements (Buys & Sells).
Income movements (Dividends, Distributions, and Interest).
Within the Feed Management screen, click the blue ( + ) Setup button to create a new feed.
Entity Name - Ensure that the correct entity has been selected.
Feed Provider - Select ‘MLC’.
Account ID - Input the Account ID for the wrap account.
Bank Account - Select a Bank/Cash Account to link to this feed.
Do Not Import Data Before - Users can restrict the data that is imported by the feed by inputting a date. Clicking on the three dots will allow you to also enter a Do Not Import Data After date. If data has already been manually entered, this step will be necessary to prevent any duplication with manual work.
Account Mapping - Users are required to link asset accounts to the feed to ensure that data is allocated to the desired asset accounts. If this step is not completed, the system will create new accounts to allocate the data to. If this results in duplicate asset accounts, please refer to our help article Wrap Feed has created duplicate accounts?
Holding Accounts Report - Once data has been imported for the account through an XML File, users can generate an excel report which displays all asset accounts and corresponding Security Codes and Portfolio Codes. This can assist with the Account Mapping process.
Save - Click this button to ensure that any changes made are saved.
1. A manual file received from MLC within the sent zip folder can be uploaded into Simple Fund 360.
2. From the Wrap and Platform Global tab, under the Actions column, select the Import Manual File icon.
3. Ensure MLC XML Import has been selected on the left hand side.
4. Select the box located next to File Location to upload the XML File. Ensure the XML file is stored on your computer or network.
5. Select Import.
If the XML is a bulk file containing data for more than one fund, you can upload the file following the steps above. Ensure Bulk Fund Import is selected and that MLC has been setup for each fund prior to uploading a bulk file.
Yes, historical transactions and balances can be provided when exporting the XML file from MLC.
How will the transactions and balances be allocated?
Transactions and balances will be posted to the asset accounts that are linked to the data feed as per the Account Mapping.
For purchases of new investments not previously held by the fund, new accounts will be created and transactions will be automatically allocated. This is provided that the user hasn’t already created a sub-account for the investment and mapped it to the feed.
Dividends and distributions will be coded to the accounts 23900 and 23800 respectively using the ASX codes. Interest income will be coded to the linked 25000 interest account.
If the Account Mapping process had not been completed when setting up the data feed within Simple Fund 360, then the system will create new accounts to allocate the data to.
If this results in duplicate asset accounts being created, please refer to our help article Wrap Feed has created duplicate accounts?
The system can automatically match the following types of transactions provided that the debits and credits reconcile between the transactions and that the transactions are recorded within a similar date range.
Investment movements (Buys and Sells) and the corresponding Bank movement(s).
Income movements (Dividends and Distributions) and the corresponding Bank movement(s).
Any transactions which have not been automatically matched or coded by the system will need to be actioned manually.