Once you have investors in your register, you can import their tax details. For a unit trust security with FATCA/CRS requirements, use the Tax details (FATCA/CRS securities) spreadsheet. See below for explanations and examples of the information required in the import file.
Column name |
Required |
Description |
Example value(s) |
Old system identifier |
No |
If data has been converted from another platform, this is pre-populated with the investor ID no. from that platform. |
I00000000123 |
SRN |
No |
This is pre-populated with the SRN for the holding in question. You do not need to change this value. |
I01264534903 |
Holding |
Yes |
This is pre-populated with the holding name and SRN/HIN for the holding in question. You do not need to change this value. |
Jane Hernandez - I01264534903 |
Holder name |
Yes |
This is pre-populated with the name, if any, that is currently set in the tax details for the holding in question. Joint holdings will have a separate row for each different name on the holding. You can update this value if you wish. |
Jane Hernandez |
Holder type |
Yes |
This is pre-populated with the tax type for the holding. On the Individuals tab, possible values are:
On the Entities tab, possible values are:
You do not need to change this value. |
Individuals |
Declaration date (DD/MM/YYYY) |
No |
This is the date which the FATCA/CRS tax declaration was submitted, if available. |
12/11/2019 |
Name of person submitting |
No |
The name of the person that submitted the FATCA/CRS tax declaration. |
Jane Hernandez |
TFN/ABN or exemption code |
No |
The TFN (Tax File Number) or ABN (Australian Business Number) or exemption code for the holder. |
555000555 |
Individuals [worksheet] |
|||
Other country for tax purposes [group of columns] |
|||
If you are resident of any other country for tax purposes, select the country below |
No |
Only fill this out if the holder is not an Australian resident for tax purposes. Choose a value from the dropdown list |
NEW ZEALAND |
TIN or equivalent tax identification number |
No |
If the holder is not an Australian resident for tax purposes then enter their TIN (Tax Identification Number) or equivalent, for their country of tax residency. |
777600999 |
Reason for not providing a TIN |
No |
If no TIN or equivalent was provided in the previous question, select a reason for not providing one. Choose a value from the dropdown list. Possible values are:
|
No TIN is required |
If second option was selected, provide explanation to not providing a TIN |
No |
If you chose the second option for previous question, type in an explanation of why no TIN was provided |
|
Entities [worksheet] |
|||
Other country for tax purposes [group of columns] |
|||
If you are resident of any other country for tax purposes, select the country below |
No |
Only fill this out if the holder is not an Australian resident for tax purposes. Choose a value from the dropdown list |
NEW ZEALAND |
TIN or equivalent tax identification number |
No |
If the holder is not an Australian resident for tax purposes then enter their TIN (Tax Identification Number) or equivalent, for their country of tax residency. |
777600999 |
Reason for not providing a TIN |
No |
If no TIN or equivalent was provided in the previous question, select a reason for not providing one. Choose a value from the dropdown list. Possible values are:
|
The entity is otherwise unable to obtain a TIN or equivalent number (please state why). |
If second option was selected, provide explanation to not providing a TIN |
No |
If you chose the second option for previous question, type in an explanation of why no TIN was provided |
The tax office has not been answering our emails. |
Are you an Australian Retirement Fund? (If yes, do not complete remaining questions) |
No |
If the holding is an Australian Retirement Fund or not. Choose a value from the dropdown list. Possible values are:
Note: you do not need to fill out any of the subsequent questions if the answer to this question is yes. |
Yes |
Note: the remainder of the questions in the entities sheet are specific to the FATCA/CRS tax declaration form and for the purposes of succinctness, have been omitted from this guide. If you require assistance in interpreting or completing those questions, please contact Registry Direct Support. |