Show download pdf controls
  • Completing the spreadsheet

    Do NOT copy and paste into the spreadsheet as this will corrupt the template.

    On this page:

    Report information

    Report information

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    C2

    Sending company Id number

    SendingCompanyIN

    -

    11

    Use either ABN, GIIN or TFN

    C3

    Warning

    Warning

    -

    11

    -

    C4

    Contact

    Contact

    -

    12

    Include name, email and phone number

    C5

    Message type indicator

    MessageTypeIndic

    -

    12

    Select the message type from the drop down list

    C6

    Reporting period end date

    ReportingPeriod

    -

    13

    YYYY-MM-DD e.g. 2017-12-31

    C7

    Unique message identifier

    MessageRefID

    -

    12

    See Unique Identifier section below

    C8

    Message reference

    MessageRefID

    -

    12

    See Unique Identifier section below

    C10

    Name

    Name

    -

    13

    -

    C11

    Country of residence

    ResCountryCode

    -

    19

    Must be AU

    C12

    Tax identification number

    IN

    -

    19

    Automatically generated

    C13

    Country of issue

    IN

    issued by

    19

    Automatically generated

    C14

    Type

    AddressType

    -

    17

    Select the address type from the drop down list

    C15

    Country

    CountryCode

    -

    16

    Select the country from the drop down list

    C16

    Country subentity

    CountrySubentity

    -

    17

    State or territory e.g. NSW, QLD, ACT

    C17

    Street

    Street

    -

    17

    -

    C18

    Building identifier

    BuildingIdentifier

    -

    17

    -

    C19

    Suite identifier

    SuiteIdentifier

    -

    17

    -

    C20

    Floor identifier

    FloorIdentifier

    -

    17

    -

    C21

    Post office box

    POB

    -

    17

    -

    C22

    Post code

    PostCode

    -

    17

    -

    C23

    City

    City

    -

    17

    -

    C24

    Document type

    DocTypeIndic

    -

    28

    Select the document type from the drop down list

    C25

    Unique document identifier

    DocRefID

    -

    28

    See Unique identifier section below

    C26

    Document reference

    DocRefID

    -

    28

    Automatically generated

    C27

    Corrected document reference identifier

    CorrDocRefID

    -

    29

    Only used when correcting or deleting a previously submitted report

    Individual accounts

    A3:C3 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    A3

    Account number

    AccountNumber

    -

    21

    -

    B3

    Account number type

    AccountNumber

    AcctNumberType

    22

    -

    C3

    Closed

    AccountNumber

    ClosedAccount

    22

    -

    D3:K3 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    D3

    Name type

    NamePerson_Type

    xnlNameType

    14

    -

    E3

    Title

    Title

     -

    15

    -

    F3

    First name

    FirstName

    xnlNameType

    15

    -

    G3

    Middle name

    MiddleName

    xnlNameType

    15

    -

    H3

    Last name

    LastName

    xnlNameType

    16

    -

    I3

    Generation identifier

    GenerationIdentifier

    -

    16

    Name suffix e.g. JNR

    J3

    Suffix

    Suffix

    -

    16

    Name suffix e.g. DR

    K3

    General suffix

    GeneralSuffix

    -

    16

    Name suffix e.g. PHD

    L3:N3 Account holder details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    L3

    Country of residence

    ResCountryCode

    -

    14

    -

    M3

    Tax identification number

    TIN

    -

    14

    Overseas tax identification number

    N3

    Country of issue

    TIN

    issuedBy

    14

    Country that issued the tax identification number

    O3:Y3 Address

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    O3

    Type

    AddressType

    17

    -

    P3

    Country

    CountryCode

    16

    -

    Q3

    Country subentity

    CountrySubentity

    17

    State or territory e.g. NSW, QLD, ACT

    R3

    Street

    Street

    17

    -

    S3

    Building identifier

    BuildingIdentifier

    17

    -

    T3

    Suite identifier

    SuiteIdentifier

    17

    -

    U3

    Floor identifier

    FloorIdentifier

    17

    -

    V3

    District name

    DistrictName

    17

    Not used for Australian addresses

    W3

    Post office box

    POB

    17

    -

    X3

    Post code

    PostCode

    17

    -

    Y3

    City

    City

    17

    -

    Z3 Birth details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    Z3

    Date

    BirthDate

    18

    -

    AA3:AJ3 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    AA3

    Account balance

    AccountBalance

    -

    25

    AB3

    Currency

    AccountBalance

    currCode

    25

    AC2:AJ2

    Payment details

    -

    -

    -

    AC3

    Dividend

    PaymentAmnt

    -

    26

    AD3

    Currency

    PaymentAmnt

    currCode

    26

    AE3

    Interest

    PaymentAmnt

    -

    26

    AF3

    Currency

    PaymentAmnt

    currCode

    26

    AG3

    Gross proceeds

    PaymentAmnt

    -

    26

    AH3

    Currency

    PaymentAmnt

    currCode

    26

    AI3

    Other payment

    PaymentAmnt

    -

    26

    AJ3

    Currency

    PaymentAmnt

    currCode

    26

    AK3:AN3 Report details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AK3

    Document type

    DocTypeIndic

    28

    Select the document type from the drop down list

    AL3

    Unique identifier

    DocRefID

    28

    See Unique Identifier section below

    AM3

    Document reference

    DocRefID

    28

    Automatically generated

    AN3

    Corrected document reference

    CorrDocRefID

    29

    Only used when correcting or deleting a previously submitted report

    Organisation accounts

    A4:D4 Account

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    A4

    Account number

    AccountNumber

    -

    21

    -

    B4

    Account number type

    AccountNumber

    AcctNumberType

    22

    -

    C4

    Closed

    AccountNumber

    ClosedAccount

    22

    -

    D4

    Account holder type

    AcctHolderType

    -

    23

    -

    E4:T4 Organisation details E4:F4 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    E4

    Name type

    Name

    nameType

    20

    F4

    Name

    Name

    -

    20

    E4:T4 Organisation details G4:I4 Account holder details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    G4

    Country of residence

    ResCountryCode

    -

    19

    -

    H4

    Identification number

    IN

    -

    19

    Overseas Tax identification number

    I4

    Country of issue

    IN

    issuedBy

    19

    Country that issued the Tax identification number

    E4:T4 Organisation details J4:T4 Address type

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    J4

    Type

    AdressType

    17

    -

    K4

    Country

    CountryCode

    18

    -

    L4

    Country subentity

    CountrySubentity

    17

    State or territory e.g. NSW, QLD, ACT

    M4

    Street

    Street

    17

    -

    N4

    Building identifier

    BuildingIdentifier

    17

    -

    O4

    Suite identifier

    SuiteIdentifier

    17

    -

    P4

    Floor identifier

    FloorIdentifier

    17

    -

    Q4

    District name

    DistrictName

    17

    Not used for Australian addresses

    R4

    Post office box

    POB

    17

    -

    S4

    Post code

    PostCode

    17

    -

    T4

    City

    City

    17

    -

    Controlling person U4:AB4 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    U4

    Name type

    NamePerson_Type

    NameType

    14

    -

    V4

    Title

    Title

     

    15

    -

    W4

    First name

    FirstName

    xnlNameType

    15

    -

    X4

    Middle name

    MiddleName

    xnlNameType

    15

    -

    Y4

    Last name

    LastName

    xnlNameType

    16

    -

    Z4

    Generation identifier

    GenerationIdentifier

    -

    16

    Name suffix e.g. JNR

    AA4

    Suffix

    Suffix

    -

    16

    Name suffix e.g. DR

    AB4

    General suffix

    GeneralSuffix

    -

    16

    Name suffix e.g. PHD

    Controlling person AC4:AF4 Controlling person details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    AC4

    Type

    CtrlgPersonType

    -

    24

    -

    AD4

    Country of residence

    ResCountryCode

    -

    14

    -

    AE4

    Tax identification number

    TIN

    -

    14

    Overseas tax identification number

    AF4

    Country of issue

    TIN

    issuedBy

    14

    Country that issued the tax identification number

    Controlling person AG4:AQ4 Address

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AG4

    Type

    AddressType

    17

    -

    AH4

    Country

    CountryCode

    16

    -

    AI4

    Country subentity

    CountrySubentity

    17

    State or territory e.g. NSW, QLD, ACT

    AJ4

    Street

    Street

    17

    -

    AK4

    Building identifier

    BuildingIdentifier

    17

    -

    AL4

    Suite identifier

    SuiteIdentifier

    17

    -

    AM4

    Floor identifier

    FloorIdentifier

    17

    -

    AN4

    District name

    DistrictName

    17

    Not used for Australian addresses

    AO4

    Post office box

    POB

    17

    -

    AP4

    Post code

    PostCode

    17

    -

    AQ4

    City

    City

    17

    -

    Controlling person AR4 Birth details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AR4

    Date

    BirthDate

    18

    -

    Controlling person AS4:AT4 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    AS4

    Account balance

    AccountBalance

    -

    25

    AT4

    Currency

    AccountBalance

    currCode

    25

    Controlling person AU4:BB4 Payment details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    AU4

    Dividend

    PaymentAmnt

    -

    26

    AV4

    Currency

    PaymentAmnt

    currCode

    26

    AW4

    Interest

    PaymentAmnt

    -

    26

    AX4

    Currency

    PaymentAmnt

    currCode

    26

    AY4

    Gross proceeds

    PaymentAmnt

    -

    26

    AZ4

    Currency

    PaymentAmnt

    currCode

    26

    BA4

    Other payment

    PaymentAmnt

    -

    26

    BB4

    Currency

    PaymentAmnt

    currCode

    26

    Controlling person BC4:BF4 Report details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    BC4

    Document type

    DocTypeIndic

    28

    -

    BD4

    Unique document identifier

    DocRefID

    28

    See Unique Identifier section below

    BE4

    Document reference

    DocRefID

    28

    Automatically generated

    BF4

    Corrected document reference

    CorrDocRefID

    29

    Only used when correcting or deleting a previously submitted report

    Next steps:

      Last modified: 22 Apr 2021QC 55152