Simple Fund 360 allows the uploading of share buy and sells from brokers not supported by the Contract Notes Service through a CSV file upload.
|From the Main Toolbar, go to Home.|
|Select Feed Management from the list.||
1. Select Advanced Options & Reports
2. Under Files, select File Import
3. Select Broker CSV Import on the left hand side of the File Import window.
Select File to Import
Select Browse and locate the CSV file on your computer.
Once the Broker File has been selected, the Mapping Summary screen will appear. Select the file's column headers under the Required fields, and then complete the Optional fields.
A column preview will also display below the Mapping Summary to ensure you have selected the right columns for the Required and Optional fields (see below).
To be able to successfully import the CSV file , you need to specify the matching column in the CSV file for all of the following fields.
Select the column from the drop-down list where the information is located.
For the Buy/Sell field, Simple Fund 360 will present you with a sub-screen to further describe which item depicts a buy, and which item will depict a sell. For example:
Note: It is advised to put in positive figures in the Net Amount field, as Buy/Sell column has already indicated the direction of transactions.
The following fields are not mandatory and can be selected if you wish to import those details in Simple Fund 360.
A Preview screen will show the data that will be imported into Simple Fund 360 to allow you to confirm that the correct fields have been selected.
Format and Import
Once the Mapping Summary has been completed, select the Do not load Before and After dates (if required) to determine the date range to be imported within the file.
Select Import to upload the file to Simple Fund 360.
Simple Fund 360 will upload the transactions to the relevant investment accounts (based on the security selected under the Required Fields section).
The Import Log screen will display to confirm the number of rows in the file and whether all rows have been successfully imported.
Coding to a suspense account
In the instance that users manually import transactions and are yet to allocate them, it is recommended to use the 94910 Investment Movement Data Clearing Account.
CSV Import and Corporate Actions
It is recommended that Corporate Actions are processed first before importing the CSV file, otherwise, users will need to re-save the affected transactions after the Corporate Action to show the correct CGT.