Once you have added investors to your register, you can import their transaction data using the Transactions spreadsheet. See below for explanations and examples of the information required in the import file.
|
Column name |
Required |
Description |
Example value(s) 1 |
Example value(s) 2 |
|
Security |
Yes |
The security which is being transacted. Select the security from a dropdown which is populated with a list of the existing securities of your issuer. |
Ordinary Shares |
Ordinary Units |
|
Buying/Receiving holder |
Yes (for issues and transfers) |
The holder which is buying or receiving shares/units. Select the holder from a dropdown which is populated with a list of all of the existing and pending investors on your register. |
Mrs Jill Peterson + Mr Thomas Peterson- I923853243 |
The Superannuation Company <The A Superannuation Fund> - I90012345 |
|
Selling/Redeeming holder (redemptions & transfers only) |
Yes (for redemptions and transfers) |
The holder which is selling (in a transfer) or redeeming (in a redemption) shares/units. Select the holder from a dropdown which is populated with a list of all of the existing and pending investors on your register. |
|
Mrs Jill Peterson + Mr Thomas Peterson- I923853243 |
|
Category* |
Yes |
The category which best describes the type of transaction. Choose a value from the dropdown list. |
ALLOTMENT |
OFF MARKET TRANSFER |
|
Date* |
Yes |
The value date for the transaction. Use the format DD/MM/YYYY |
12/11/2019 |
13/11/2019 |
|
Quantity* |
Yes |
The amount of shares or units being transacted. This should always be a positive number. |
150 |
90 |
|
Price |
No |
The price per security |
0.10 |
0.20 |
|
If Partly paid: Paid amount per security* |
Yes |
The paid amount that the shares/units are transacted at. Should be an amount in dollars and cents. Do not include the dollar sign. |
1.10 |
1.12 |
|
If Partly paid: Unpaid amount per security* |
Yes |
The unpaid amount that the shares/units are transacted at. Should be an amount in dollars and cents. Do not include the dollar sign. |
1.50 |
0.00 |
|
Send investor notification (holding statement) |
No |
A holding statement will be created and sent to the investor if "Yes" is selected here. |
Yes |
No |
|
If security class is certificated: Include share certificate in notification (If applicable) |
No |
A share/unit certificate will be created and sent to the investor if "Yes" is selected here; and only if 'Send investor notification' (see previous question) is also set to 'Yes' |
Yes |
No |