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

Was this article helpful?

0 out of 2 found this helpful

Have more questions? Submit a request