Show download pdf controls
  • Common Reporting Standard – user guide for the Small Reporter Tool

    This guide is to assist reporters to prepare a Common Reporting Standard (CRS) report using our Small Reporter Tool v1.0.

    On this page:

    Introduction

    This guide provides information to assist Australian Reporting Financial Institutions (RFI’s) complete and lodge the CRS report.

    CRS reports must be lodged in XML format. This solution allows reporters, who meet the criteria below, to input information into an Excel spreadsheet which will then convert the data into an XML file.

    The CRS came into effect on 1 July 2017 with the first report due by 31 July 2018. The first report should contain data from 1 July 2017 to 31 December 2017. After this period reports will include data from 1 January to 31 December and will be due annually, by 31 July in the following year.

    On this page:

    Who should use this guide

    Australian CRS reporters with 50 or less individual and 50 or less organisation accounts or those who wish to provide a nil report.

    At this stage the spreadsheet option is not available for MAC users. A communication will issue if this changes.

    Files containing more than 50 reportable individual and 50 reportable organisation accounts cannot be accepted.

    How to use this guide

    Read this guide in conjunction with the CRS user guide version 2.0 available on the OECD website. The tables below map the spreadsheet cell reference and name to the CRS Schema XML element and attribute names. To assist you in locating more detailed information on each element, and its requirements, the relevant page number in the CRS user guide has also been provided.

    Regular updates

    Always refer to the online published version of the CRS and Small Reporter Tool user guide to ensure you have the most recent information.

    Feedback

    We welcome your feedback on the Small Reporter Tool and user guide. Provide your feedback and suggestions to CRS@ato.gov.au

    Setting up the spreadsheet

    Download the spreadsheet from our website.

    Save the spreadsheet onto your computer. The spreadsheet is not compatible with MAC computers at this stage.

    Fill in the spreadsheet ensuring all required information is included in the following tabs:

    • Report information
    • Individual accounts
    • Organisation accounts

    Generate the report through the ‘Generate report’ tab. This creates an XML file.

    Save the XML file to your computer.

    Lodge the file online, see 'How to lodge' below. Note, this tool will generate the required wrapper header for lodgment online.

    How to lodge

    The CRS report can be lodged through:

    File transfer

    Your XML CRS file is lodged through the file transfer facility.

    In the Business Portal or Tax Agent Portal:

    • select Lodge file from the left menu
    • select test or lodge – files can be tested before lodgment allowing for any errors to be corrected.Tax Agent Portal files are limited to 3.7MB.

    In Online services for agents:

    • from the Agent Homepage select Reports and forms
    • select File Transfer
    • select Lodge file
    • select test or lodge – files can be tested before lodgment so any errors can be corrected before submiting.

    See also:

    A validation report will then be produced informing whether the lodgment was successful or not.

    If successful, an ATO reference number is provided. This confirms the report has been lodged with us, however this does not confirm the overseas receiving jurisdiction has successfully processed the report. If another jurisdiction advises us of errors in the file we may contact you.

    Backup of data

    It is the responsibility of the investment body to keep effective records as part of their tax reporting obligations. You should keep backups of data supplied to us so that data can be re-supplied if necessary.

    Nil reports

    There is no requirement for RFIs to lodge a nil CRS report. However, lodging a nil report will help us monitor CRS compliance and may reduce the need for queries.

    To complete a nil report all of the mandatory elements in the Report information tab must be provided.

    Nil reports

    Cell ref

    Cell name

    Content (example only)

    A3

    Sending company Id number*

    999999992

    A6

    Message type indicator*

    CRS703 – nil report

    A7

    Corrected message identifier

    BLANK

    A8

    Reporting period end date*

    2017-12-31

    A9

    Unique message identifier*

    User generated reference for your records eg xxxx01

    A10

    Message reference

    Automatically generated

    A28

    Document type*

    OECD1 – New Data

    A29

    Unique document identifier*

    User generated reference for your records eg nilfri2

    A30

    Document reference

    Automatically generated

    A31

    Corrected document reference identifier

    BLANK

    Individual and Organisation accounts tabs should be left blank.

    Completing the spreadsheet

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

    Report information

    Report information

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    C3

    Sending company Id number

    SendingCompanyIN

    -

    232

    Use either ABN, GIIN or TFN

    C4

    Warning

    Warning

    -

    233

    -

    C5

    Contact

    Contact

    -

    234

    Include name, email and phone number

    C6

    Message type indicator

    MessageTypeIndic

    -

    234

    Select the message type from the drop down list

    C7

    Corrected message identifier

    CorrMessageRefID

    -

    -

    This is not used for CRS reporting

    C8

    Reporting period end date

    ReportingPeriod

    -

    235

    YYYYMMDD eg 20171231

    C9

    Unique message identifier

    MessageRefId

    -

    234

    See Unique Identifier section below

    C10

    Message reference

    MessageRefID

    -

    234

    See Unique Identifier section below

    C12

    Name

    Name

    -

    235

    -

    C13

    Name type

    NamePerson_Type

    -

    237

    -

    C14

    Country of residence

    ResCountryCode

    -

    235

    Must be AU

    C15

    Tax identification number

    IN

    -

    243

    Automatically generated

    C16

    Country of issue

    CountryCode

    issued by

    239

    -

    C17

    Type

    AddressType

    -

    240

    -

    C18

    Country

    CountryCode

    -

    239

    Country of residence

    C19

    Country subentity

    CountrySubentity

    -

    241

    State or territory eg NSW, QLD, ACT

    C20

    Street

    Street

    -

    240

    -

    C21

    Building identifier

    BuildingIdentifier

    -

    240

    -

    C22

    Suite identifier

    SuiteIdentifier

    -

    240

    -

    C23

    Floor identifier

    FloorIdentifier

    -

    240

    -

    C24

    District name

    DistrictName

    -

    240

    Not used for Australian addresses

    C25

    Post office box

    POB

    -

    241

    -

    C26

    Post code

    PostCode

    -

    241

    -

    C27

    City

    City

    -

    241

    -

    C28

    Document type

    DocTypeIndic

    -

    253

    -

    C29

    Unique document identifier

    DocRefID

    -

    254

    Only used when correcting or deleting a previously submitted report

    C30

    Document reference

    DocRefID

    -

    254

    -

    C31

    Corrected document reference identifier

    CorrDocRefID

    -

    254

    See Unique Identifier section below

    Individual accounts

    A2:E2 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    A3

    Account number

    AccountNumber

    -

    245

    -

    B3

    Account number type

    AccountNumber

    AcctNumberType

    246

    -

    C3

    Undocumented

    AccountNumber

    UndocumentedAccount

    246

    An account is only classified as undocumented if:

    1) it is an account opened before 1 July 2017

    2) the only address on file is a ‘hold mail’ or ‘in-care-of’ address outside Australia; and

    3) you have been unable to determine the tax residency of the person

    D3

    Closed

    AccountNumber

    ClosedAccount

    246

    -

    E3

    Dormant

    AccountNumber

    DormantAccount

    246

    Not used for Australian reporting

    F2:M2 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    F3

    Name type

    NamePerson_Type

    nameType

    237

    -

    G3

    Title

    Title

     -

    238

    -

    H3

    First name

    FirstName

    xnlNameType

    238

    -

    I3

    Middle name

    MiddleName

    xnlNameType

    238

    -

    J3

    Last name

    LastName

    xnlNameType

    239

    -

    K3

    Generation identifier

    GenerationIdentifier

    -

    239

    Name suffix eg JNR

    L3

    Suffix

    Suffix

    -

    239

    Name suffix eg DR

    M3

    General suffix

    GeneralSuffix

    -

    239

    Name suffix eg PHD

    N2:P2 Account holder details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    N3

    Country of residence

    ResCountryCode

    -

    236

    Should be AU for undocumented accounts

    O3

    Tax identification number

    TIN

    -

    237

    Overseas tax identification number

    P3

    Country of issue

    CountryCode

    issuedBy

    239

    Country that issued the tax identification number

    Q2:AA2 Address

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    Q3

    Type

    AddressType

    240

    -

    R3

    Country

    CountryCode

    239

    -

    S3

    Country subentity

    CountrySubentity

    241

    State or territory eg NSW, QLD, ACT

    T3

    Street

    Street

    240

    -

    U3

    Building identifier

    BuildingIdentifier

    240

    -

    V3

    Suite identifier

    SuiteIdentifier

    240

    -

    W3

    Floor identifier

    FloorIdentifier

    240

    -

    X3

    District name

    DistrictName

    240

    Not used for Australian addresses

    Y3

    Post office box

    POB

    241

    State or territory eg NSW, QLD, ACT

    Z3

    Post code

    PostCode

    241

    -

    AA3

    City

    City

    241

    -

    AB2:AF2 Birth details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AB3

    Date

    BirthDate

    241

    -

    AC3

    City

    City

    242

    Not used for Australian reporting

    AD3

    City subentity

    CitySubentity

    242

    Not used for Australian reporting

    AE3

    Country

    CountryCode

    242

    Not used for Australian reporting

    AF3

    Former country name

    FormerCountryName

    242

    Not used for Australian reporting

    AG2:AH2 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    AG3

    Account balance

    AccountBalance

    -

    250

    AH3

    Currency

    AccountBalance

    currCode

    250

    AI2:AP2

    Payment details

    -

    -

    -

    AI3

    Dividend

    PaymentAmnt

    -

    252

    AJ3

    Currency

    PaymentAmnt

    currCode

    252

    AK3

    Interest

    PaymentAmnt

    -

    252

    AL3

    Currency

    PaymentAmnt

    currCode

    252

    AM3

    Gross proceeds

    PaymentAmnt

    -

    252

    AN3

    Currency

    PaymentAmnt

    currCode

    252

    AO3

    Other payment

    PaymentAmnt

    -

    252

    AP3

    Currency

    PaymentAmnt

    currCode

    252

    AQ2:T2 Report details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AQ3

    Document type

    DocTypeIndic

    253

    -

    AR3

    Unique document identifier

    DocRefID

    253

    See Unique Identifier section below

    AS3

    Document reference

    DocRefID

    254

    Automatically generated

    AT3

    Correlated document reference identifier

    CorrDocRefID

    254

    Only used when correcting or deleting a previously submitted report

    Organisation accounts

    A3:F3 Account

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    A4

    Account number

    AccountNumber

    -

    245

    -

    B4

    Account number type

    AccountNumber

    AcctNumberType

    246

    -

    C4

    Undocumented

    AccountNumber

    UndocumentedAccount

    246

    Not used for Australian reporting

    D4

    Closed

    AccountNumber

    ClosedAccount

    246

    -

    E4

    Dormant

    AccountNumber

    DormantAccount

    246

    Not used for Australian reporting

    F4

    Account holder type

    AcctHolderType

    -

    247

    -

    G2:V2 Organisation details G3:H3 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    G4

    Name type

    NamePerson_Type

    -

    244

    H4

    Name

    Name

    nameType

    244

    G2:V2 Organisation details I3:K3 Account holder details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    I4

    Country of residence

    ResCountryCode

    -

    243

    Should be AU for undocumented accounts

    J4

    Identification number

    IN

    -

    243

    Overseas Tax identification number

    K4

    Country of issue

    IN

    issuedBy, INType

    242

    Country that issued the Tax identification number

    G2:V2 Organisation details L3:V3 Address type

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    M4

    L4

    CountryCode

    243

    -

    N4

    Country subentity

    CountrySubentity

    241

    State or territory eg NSW, QLD, ACT

    O4

    Street

    Street

    240

    -

    P4

    Building identifier

    BuildingIdentifier

    240

    -

    Q4

    Suite identifier

    SuiteIdentifier

    240

    -

    R4

    Floor identifier

    FloorIdentifier

    240

    -

    S4

    District name

    DistrictName

    240

    Not used for Australian addresses

    T4

    Post office box

    POB

    241

    -

    U4

    Post code

    PostCode

    241

    -

    V4

    City

    City

    241

    -

    W2:AX3 Controlling person W3:AD3 Name

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    W4

    Name type

    NamePerson_Type

    nameType

    237

    -

    X4

    Title

    Title

     

    238

    -

    Y4

    First name

    FirstName

    xnlNameType

    238

    -

    Z4

    Middle name

    MiddleName

    xnlNameType

    238

    -

    AA4

    Last name

    LastName

    xnlNameType

    239

    -

    AB4

    Generation identifier

    GenerationIdentifier

    -

    239

    Name suffix eg JNR

    AC4

    Suffix

    Suffix

    -

    239

    Name suffix eg DR

    AD4

    General suffix

    GeneralSuffix

    -

    239

    Name suffix eg PHD

    W2:AX3 Controlling person AE3:AH3 Controlling person details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    Notes

    AE4

    Type

    CtrlgPersonType

    -

    248

    -

    AF4

    Country of residence

    ResCountryCode

    -

    236

    Should be AU for undocumented

    AG4

    Tax identification number

    TIN

    -

    237

    Overseas tax identification number

    AH4

    Country of issue

    CountryCode

    issuedBy

    239

    Country that issued the tax identification number

    W2:AX3 Controlling person AI3:AS3 Address

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AI4

    Type

    AddressType

    240

    -

    AJ4

    Country

    CountryCode

    239

    -

    AK4

    Country subentity

    CountrySubentity

    241

    State or territory eg NSW, QLD, ACT

    AL4

    Street

    Street

    240

    -

    AM4

    Building identifier

    BuildingIdentifier

    240

    -

    AN4

    Suite identifier

    SuiteIdentifier

    240

    -

    AO4

    Floor identifier

    FloorIdentifier

    240

    -

    AP4

    District name

    DistrictName

    240

    Not used for Australian addresses

    AQ4

    POB

    POB

    241

    Post office box

    AR4

    Post code

    PostCode

    241

    -

    AS4

    City

    City

    241

    -

    W2:AX3 Controlling person AT3:AX3 Birth details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    AT4

    Date

    BirthDate

    241

    -

    AU4

    City

    City

    242

    -

    AV

    City subentity

    CitySubentity

    242

    Not used for Australian reporting

    AW4

    Country

    CountryCode

    242

    Not used for Australian reporting

    AX4

    Former country name

    FormerCountryName

    242

    Not used for Australian reporting

    W2:AX3 Controlling person AY3:AZ3 Account details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page #

    AY4

    Account balance

    AccountBalance

    -

    250

    AZ4

    Currency

    AccountBalance

    currCode

    250

    W2:AX3 Controlling person BA3:BH3 Payment details

    Cell ref

    Cell name

    Schema XML element name

    Schema XML attribute

    CRS user guide page number

    BA4

    Dividend

    PaymentAmnt

    -

    252

    BB4

    Currency

    PaymentAmnt

    currCode

    252

    BC4

    Interest

    PaymentAmnt

    -

    252

    BD4

    Currency

    PaymentAmnt

    currCode

    252

    BE4

    Gross proceeds

    PaymentAmnt

    -

    252

    BF4

    Currency

    PaymentAmnt

    currCode

    252

    BG4

    Other payment

    PaymentAmnt

    -

    252

    BH4

    Currency

    PaymentAmnt

    currCode

    252

    W2:AX3 Controlling person BI3:BL3 Report details

    Cell ref

    Cell name

    Schema XML element name

    CRS user guide page number

    Notes

    BI4

    Document type

    DocTypeIndic

    253

    -

    BJ4

    Unique document identifier

    DocRefID

    253

    See Unique Identifier section below

    BK4

    Document reference

    DocRefID

    254

    Automatically generated

    BL4

    Correlated message identifier

    CorrDocRefID

    254

    Only used when correcting or deleting a previously submitted report

    Correcting reports

    If errors in the data are identified after the initial report has been lodged, a correction report must be submitted.

    The file must contain only new data (OECD1) or corrected or deleted data (OECD2/OECD3). You cannot mix new and corrected or deleted data within the same file. The Reporting Financial Institution and Account Report are the only correctable elements in the schema. You must provide a new unique message identifier and unique document identifier in the Report information tab.

    In order to pass validation, do not populate the corrected message identifier (C7). This element is not used for CRS (and will be removed from the tool in the next update).

    Some of the mandatory elements in the Report information tab must be changed so they are different to the original report.

    How to correct Reporting Financial Institution details

    To correct the Reporting Financial Institution details in the Report information tab, update the following cells.

    Updating Reporting Financial Institution details

    Cell ref

    Cell name

    Content (example only)

    C6

    Message type indicator*

    CRS702

    C7

    Corrected message identifier

    Leave blank, this is not used for CRS

    C9

    Unique message identifier*

    Must be different to original identifier provided

    C28

    Document type*

    OECD2

    C29

    Unique document identifier*

    Must be different to original identifier provided

    C31

    Corrected document reference identifier

    Must match the unique document identifier (C29) provided in the original report

    How to correct Account Reports

    To correct or delete Account Reports in the Individual accounts or Organisation accounts tab, update the following cells.

    Updating Account Reports

    Report tab

    Cell ref

    Cell name

    Content (example only)

    Report information

    C6

    Message type indicator*

    CRS702

    Report information

    C7

    Corrected message identifier

    Leave blank, this is not used for CRS

    Report information

    C9

    Unique message identifier*

    Must be different to original identifier provided

    Report information

    C28

    Document type*

    OECD0

    Report information

    C29

    Unique document identifier*

    Must be different to original identifier provided

    Individual accounts

    AQ

    Document type*

    OECD2 or OECD3

    Individual accounts

    AR

    Unique identifier*

    Must be different to original identifier provided

    Individual accounts

    AT

    Correlated document reference identifier

    Must match the unique document identifier (AR) provided in the original report

    Organisation accounts

    BI

    Document type*

    OECD2 or OECD3

    Organisation accounts

    BJ

    Unique identifier*

    Must be different to original identifier provided

    Organisation accounts

    BL

    Correlated document reference identifier

    Must match the unique document identifier (BJ) provided in the original report

    How to correct Reporting Financial Institution and Account Report details

    To correct the Reporting Financial Institution details in Report information tab and correct or delete Account Reports in the Individual accounts or Organisation accounts tab, update the following cells.

    Updating Reporting Financial Institution and Account Report details

    Report tab

    Cell ref

    Cell name

    Content (example only)

    Report information

    C6

    Message type indicator*

    CRS702

    Report information

    C7

    Corrected message identifier

    Leave blank, this is not used for CRS

    Report information

    C9

    Unique message identifier*

    Must be different to original identifier provided

    Report information

    C28

    Document type*

    OECD2

    Report information

    C29

    Unique document identifier*

    Must be different to original identifier provided

    Report information

    C31

    Corrected document reference identifier

    This must match the unique document identifier (C29) provided in the original report

    Individual accounts

    AQ

    Document type*

    OECD2 or OECD3

    Individual accounts

    AR

    Unique identifier*

    Must be different to original identifier provided

    Individual accounts

    AT

    Correlated document reference identifier

    This must match the unique identifier (AR) provided in the original

    Organisation accounts

    BI

    Document type*

    OECD2 or OECD3

    Organisation accounts

    BJ

    Unique identifier*

    Must be different to original identifier provided

    Organisation accounts

    BL

    Correlated document reference identifier

    This must match the unique identifier (BJ) provided in the original

    Unique identifiers

    There are two types of unique identifiers used to ensure that any corrections or amendments can be aligned to the correct report and account information.

    • Message reference (MessageRefId) – identifies the specific report and appears once (C10) in the Report information.
    • Document reference (DocRefId) – identifies the specific data element within the report and appears in the    
      • Report information (C30)
      • Individual accounts – column AS for each account reported
      • Organisation accounts – column BK for each account reported.

    These elements must be unique across all time and space, meaning it can only ever be used once.

    In all CRS files the Message reference and Document reference elements must be in the following format:

    • AUReportingYearAUSendingCompanyINUniqueReference for example    
      • AU2017AU12345679121RBF123

    This format has been built into the spreadsheet.

    The Message reference is automatically populated based on the following:

    • AU – the reporter’s Country of residence
    • C8 – the reporting year reported in the Reporting period end date
    • AU – the reporter’s country of lodgment
    • C3 – Sending company Id number
    • C9 – Unique message identifier

    The Document reference is automatically populated based on the following:

    • AU – the reporter’s Country of residence
    • C8 – the year reported in the Reporting period end date
    • AU – the reporter’s country of lodgment
    • C3 – Sending company Id number
    • Unique document identifiers    
      • Report information C29
      • Individual accounts AR3 – AR52
      • Organisation accounts BJ4 – BJ53

    The Message reference and Document reference will not automatically populate if the Sending company Id number is invalid. If this occurs you need to correct the ABN, TFN or GIIN in the Sending company Id (C3).

    More information

    For more information on the CRS visit:

    Version Control

    Version number

    Date

    1.0

    10/04/2018

    1.1

    09/10/2018

    Acronyms

    Term/Acronym

    Definition

    CRS

    Common Reporting Standard

    XML

    eXtensible Markup Language

    RFI

    Reporting Financial Institutions

      Last modified: 18 Jun 2019QC 55152