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

    This guide provides information to assist Australian Reporting Financial Institutions (RFIs) complete and lodge the Common Reporting Standard (CRS report) using our Small Reporter Tool v2.0 (XLSM, 5.71MB)This link will download a file.

    In this guide:

    About this guide

    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.

    Reports from Australian RFIs include data from January to December. They are 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 3.0 available on the OECD websiteExternal Link. 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 (XLSM, 4.7MB)This link will download a file 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:

    • select Lodge file from the left menu
    • select test or lodge – files can be tested before lodgment allowing for any errors to be corrected.

    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 submitting.

    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)

    C2

    Sending company Id number*

    999999992

    C5

    Message type indicator*

    CRS703 – No data to report

    C6

    Reporting period end date*

    2017-12-31

    C7

    Unique message identifier*

    User generated reference for your records e.g. xxxx01

    C8

    Message reference

    Automatically generated

    C24

    Document type*

    OECD1 – New Data

    C25

    Unique document identifier*

    User generated reference for your records e.g. nilfri2

    C26

    Document reference

    Automatically generated

    C27

    Corrected document reference identifier

    BLANK

    Individual and Organisation accounts tabs must be blank.

    Next steps:

      Last modified: 04 Jan 2021QC 55152