Import your data - Tax details (FATCA/CRS securities)

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:

  • Individual
  • Deceased

On the Entities tab, possible values are:

  • Superannuation Fund 
  • Partnership
  • Company
  • Trust
  • Other
  • Government

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:

  • The country/jurisdiction where the entity is resident does not issue TINs to its residents.
  • The entity is otherwise unable to obtain a TIN or equivalent number (please state why).
  • No TIN is required.

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 country/jurisdiction where the entity is resident does not issue TINs to its residents.
  • The entity is otherwise unable to obtain a TIN or equivalent number (please state why).
  • No TIN is required.

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:

  • Yes
  • No

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.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request