Import your data - Investors (Advanced) – Registry Direct Support Team

The Investors (Advanced) spreadsheet includes the complete set of information for each investor, including details for each associate of an investor, and is recommended for advanced users. See below for explanations and examples of the information required in the import file.

The spreadsheet fields are arranged under column groups for different investor types. The following column groups apply to all investor types:

Contact details
Bank and DRP details
Investor type
Beneficially held
Create holdings

Depending on the investor type, fields under the relevant column groups should be completed:

Individual investors
Companies
Trusts with individual trustees
Trusts with corporate trustees

Individual-type associates of investors, ie. Primary investors, joint investors, directors, beneficial owners and trustees, all share the same fields. For succinctness, refer to Primary investor below for explanations and examples for completing the fields for all individuals.

Column name	Required	Description	Example value(s) 1	Example value(s) 2
External ID	No	If converting data from another platform, the investor ID no. from that platform or any other form of ID of the investor.	I00000000123	AAA-111
Tags	No	Add up to 5 user-defined tags to an investor, separated by a semicolon. Allowed characters are: 0-9 a-Az-Z -	VIP	LISTA; LISTC; LISTF
Contact details [group of columns]
Contact first name	No	First name of the contact person for the holding.	Jane	Martin
Contact last name	No	Last name of the contact person for the holding.	Hernandez	Jones
Email address	No	The email address for the contact person. Any email communications for the holding will be sent to this email address. If you choose to grant online access for the holding the invitation to sign up for that online access will be sent to this email address.	jane@example.org	martin@test.com
Email address (Read only access)	No	The email address for a user which you wish to grant read only access to, for this holding. Typically this is the email address of an advisor which you wish to grant read only access to.	m.advisor@example.org	terry@example.org
Mobile number	No	The mobile phone number for the contact person for this holding. For international numbers please enter "+" then "international country code" then "phone number"	0414 888 777	+447911123456
Other phone number	No	An alternative phone number for the contact person for this holding.	03 8877 6644
Communication preference (Annual reports) Communication preference (Issuer information) Communication preference (Statements) Communication preference (Notice of meetings and proxy)	No	Specifies how communications should be sent to the holding. Choose a value from the dropdown. Possible values are: Email Post Do not send If this column is left the preference will default to Email.	Email	Do not send
Bank and DRP details [group of columns]
Bank account name	No	The bank account name for the (Australian) bank account for this holding. Will be used for paying dividends and/or distributions.	Jane Hernandez	The A Superannuation Fund
BSB number	No	The BSB number for the (Australian) bank account for this holding. Will be used for paying dividends and/or distributions. Must be a 6 digit number with a dash separating the first three numbers from the last three.	132-456	123-987
Bank account number	No	The bank account number for the (Australian) bank account for this holding. Will be used for paying dividends and/or distributions. Must be a number between 4 and 10 digits long.	67826306	12345678
DRP Participation		The type, if any, of DRP (Dividend/Distribution Reinvestment Plan) participation desired for the holding. Choose a value from the dropdown. Possible values are: Full participation Partial participation No participation	Full participation	Partial participation
Number of units invested in DRP (if applicable)	No	If Partial participation was selected in the previous column then this should be the absolute number of shares/units to be reinvested. If Full participation or No participation was selected in the previous column then this can be left blank as it is not applicable.		15
[ End Bank and DRP details]
Investor type*	Yes	The type of holding, for tax purposes. Choose a value from the dropdown list. Possible values are: Individual Company Trust/Superfund with Individual Trustee Trust/Superfund with Company Trustee	Individual	Superannuation Fund
Beneficially held*	Yes	Whether the holding is beneficially held or not. Choose a value from the dropdown list. Possible values are: Yes No	Yes	No
Individual investors [group of columns] Complete these fields if you have selected Individual as the Investor type.
Primary investor Note: The fields for the Primary investor are the same as for other individual types; Joint investors, Directors and Beneficial owners. Refer to Primary investor when entering data for all other individual types.
Title	No	Title of the investor. Choose a value from the dropdown list.	MS	DR
Legal first name	Yes, for Primary investor	Legal first name of the investor.	Jill	Anthony
Middle names	No	Middle name/s of the investor.	Alice Rose	James
Legal last name	Yes, for Primary investor	Legal last name of the investor.	Peterson	Nguyen
Date of birth	No	Date of birth of the investor.	15/10/1966	25/2/1980
Country of citizenship	No	The country of citizenship of the investor. Choose a value from the dropdown list.	Australia	Canada
Email address	No	The email address for the investor.	jane@example.org	martin@test.com
Mobile number	No	The mobile phone number for the investor. For international numbers please enter "+" then "international country code" then "phone number"	0414 888 777	+447911123456
Address Line 1	Yes, for Primary investor	The number and street name for the address of the investor.	Suite 2 Anderson Centre	Level 6 2 Russell St
Address Line 2	No	The number and street name for the address of the investor, if more space is required.	26 Lonsdale St
Suburb/City	Yes, for Primary investor	The suburb or city for the address of the investor.	Melbourne	Downtown Montreal East Quebec Province HB3
Postcode	Yes, for Australian address No, for International address	The postcode for the address of the primary investor.	3000	A0A 0A0
State	Yes	The state for the address of the investor. If an Australian address, enter the 3 letter acronym of the state. Possible values are: ACT NSW NT SA TAS QLD VIC WA If an international address, any format is valid.	VIC	New Jersey
Country	Yes, for Primary investor	The country for the address of the investor. Choose a value from the dropdown list.	Australia	Canada
Joint investor 1, Joint investor 2 Refer to Primary investor above for an explanation of these fields. Entering data for Joint investor 1 and Joint investor 2 is not required.
Companies [group of columns] Complete these fields if you have selected Company as the Investor type.
Company
Company name	Yes	The registered company name	The Superannuation Company
Company Tax Country	Yes	The country where the business is registered	Australia	Canada
Tax number	No	The tax number issued in the company’s country of registration	53004085616
Address Line 1	Yes	The number and street name for the address of the company.	Suite 2 Anderson Centre	Level 6 2 Russell St
Address Line 2	No	The number and street name for the address of the company, if more space is required.	26 Lonsdale St
Suburb/City	Yes	The suburb or city for the address of the company.	Melbourne	Downtown Montreal East Quebec Province HB3
Postcode	Yes, for Australian address No, for International address	The postcode for the address of the Company.	3000	A0A 0A0
State	Yes	The state for the address of the investor. If an Australian address, enter the 3 letter acronym of the state. Possible values are: ACT NSW NT SA TAS QLD VIC WA If an international address, any format is valid.	VIC	New Jersey
Country	Yes	The country for the address of the company. Choose a value from the dropdown list.	Australia	Canada
Directors 1, Directors 2, Directors 3 Refer to Primary investor above for an explanation of these fields. Entering data for Directors 1, Directors 2 and Directors 3 is not required.
Beneficial owner 1, Beneficial owner 2, Beneficial owner 3 Refer to Primary investor above for an explanation of these fields. Entering data for Beneficial owner 1, Beneficial owner 2 and Beneficial owner 3 is not required.
Trusts with individual trustee [group of columns] Complete these fields if you have selected Trust/Superfund with Individual Trustee as the Investor type.
Trust
Trust/Designation	Yes	Full name of the trust	The A Superannuation Fund
Trust type	Yes	Choose a value from the dropdown list. Possible values are: Superannuation fund Family Trust Regulated Trust Charitable Trust Testamentary Trust Non-regulated Trust Bare Trust Discretionary Trust	Superannuation Fund	Family Trust
Tax number	No	The tax number issued in the Trust’s country of registration	50110219460
Tax Country	Yes	Country where the trust is established	Australia	Canada
Individual Trustee 1 Refer to Primary investor above for an explanation of these fields. The following fields for Individual Trustee 1 are required: Legal first name Legal last name Address Line 1 Suburb/City Country
Individual Trustee 2, Individual Trustee 3 Refer to Primary investor above for an explanation of these fields. Entering data for Individual Trustee 1 and Individual Trustee 2 is not required.
Beneficial owner 1, Beneficial owner 2, Beneficial owner 3 Refer to Primary investor above for an explanation of these fields. Entering data for Beneficial owner 1, Beneficial owner 2 and Beneficial owner 3 is not required.
Trusts with corporate trustee [group of columns] Complete these fields if you have selected Trust/Superfund with Corporate Trustee as the Investor type.
Trust
Trust/Designation	Yes	Full name of the trust	The A Superannuation Fund
Trust type	Yes	Choose a value from the dropdown list. Possible values are: Superannuation fund Family Trust Regulated Trust Charitable Trust Testamentary Trust Non-regulated Trust Bare Trust Discretionary Trust	Superannuation Fund	Family Trust
Tax number	No	The tax number issued in the Trust’s country of registration	50110219460
Tax Country	Yes	Country where the trust is established	Australia	Canada
Corporate trustee
Company name	Yes	The registered corporate trustee name	The Superannuation Company
Company Tax Country	Yes	The country where the business is registered	Australia	Canada
Tax number	No	The tax number issued in the corporate trustee’s country of registration	53004085616
Address Line 1	Yes	The number and street name for the address of the corporate trustee.	Suite 2 Anderson Centre	Level 6 2 Russell St
Address Line 2	No	The number and street name for the address of the corporate trustee, if more space is required.	26 Lonsdale St
Suburb/City	Yes	The suburb or city for the address of the corporate trustee.	Melbourne	Downtown Montreal East Quebec Province HB3
Postcode	Yes, for Australian address No, for International address	The postcode for the address of the Corporate Trustee.	3000	A0A 0A0
State	Yes	The state for the address of the investor. If an Australian address, enter the 3 letter acronym of the state. Possible values are: ACT NSW NT SA TAS QLD VIC WA If an international address, any format is valid.	VIC	New Jersey
Country	Yes	The country for the address of the corporate trustee. Choose a value from the dropdown list.	Australia	Canada
Directors 1, Directors 2, Directors 3 Refer to Primary investor above for an explanation of these fields. Entering data for Directors 1, Directors 2 and Directors 3 is not required.
Beneficial owner 1, Beneficial owner 2, Beneficial owner 3 Refer to Primary investor above for an explanation of these fields. Entering data for Beneficial owner 1, Beneficial owner 2 and Beneficial owner 3 is not required.
Create holdings [group of columns]
Create holding under: <Security name>	Yes	A column for each security under the issuer will be displayed here. Possible values are: Yes No If you select Yes, a nil holding for the security will be created for the investor. You must select Yes for at least one security.	Yes	No

Contact details [group of columns]

Bank and DRP details [group of columns]

Individual investors [group of columns]

Primary investor

Joint investor 1, Joint investor 2

Companies [group of columns]

Company

Directors 1, Directors 2, Directors 3

Beneficial owner 1, Beneficial owner 2, Beneficial owner 3

Trusts with individual trustee [group of columns]

Trust

Individual Trustee 1

Individual Trustee 2, Individual Trustee 3

Beneficial owner 1, Beneficial owner 2, Beneficial owner 3

Trusts with corporate trustee [group of columns]

Trust

Corporate trustee

Directors 1, Directors 2, Directors 3

Beneficial owner 1, Beneficial owner 2, Beneficial owner 3

Create holdings [group of columns]

Related articles