Annual investment income report (AIIR) PC spreadsheet specification Draft v7.0.0

Version: 

7.0.0

Original Published Date: 

15/06/2018 - 02:00pm

Status: 

  • Current

Tax Category: 

  • Investment bodies

Resource Type: 

  • Specifications

Description: 

A Draft electronic reporting specification Annual investment income report (AIIR) PC spreadsheet format version 7.0.0 has been released. Tracked and clean versions of the final specifications have been published for your information.

This specification contains the data requirements for the 2019-20and subsequent financial years. Only version 7.0.0 will be accepted for the 2020 and subsequent financial years.

A brief overview of the differences between version 6.0.0 and version 7.0.0 are listed below.  Refer to the specification on pages I – III for a more detailed list of changes.

The AIIR spreadsheet template will be published next year and version 6 may only be used for the prior year reporting.

Key changes

  • Section 1 Introduction and Section 2 Legal requirements
    • Changes to include Stapled structures
  • Section 2
    • Extension of time to lodge section - instructions have been updated
  • Section 3
    • Lodging your spreadsheet - instructions have been updated
  • Section 7
    • Updated the example of a standard AIIR spreadsheet  file

Changes to data records, values and definitions

  • Security Level Data Record
    • Added Reporting period start date and Reporting period end date cells and  definitions
  • Investment Account Data Record
    • Added Non-Assessable Non-Exempt (NANE) Non-trust income (6.76) cell and definition
    • Added NCMI – Non-primary production (6.132) cell and definition
    • Added NCMI – Primary production (6.133) data cell and definition
    • Added Excluded from  NCMI – Non-primary production (6.134) cell and definition
    • Added Excluded from NCMI – Primary production (6.135) cell and definition
    • Added NCMI Capital Gains – (6.136) cell and definition
    • Added Excluded from NCMI Capital Gains – (6.137) cell and definition
  • Updated definitions in the Investor Data Record
    • Updated codes in the Investor entity type (6.38) data cell to include E – sovereign entity and F – foreign super/pension fund
    • Updated codes in the Individual investor surname (6.42) alert box
    • Updated codes in the Non-individual investor name (6.47) alert box
    • Updated Type of payment (6.71) cell codes to include Non-Exempt (NANE) Non-trust income
    • Updated Non-resident withholding amount deducted (6.75) definition to include amounts withheld from Non-Concessional MIT income
    • Updated Non-Primary production income (6.84) definition to include NCMI – Non-primary production and Excluded from NCMI – Non-primary production values.
    • Updated Managed investment trust fund payments (6.104) definition with an alert box
    • Updated Amounts withheld from managed investment trust fund payments (6.105) definition with an alert box
    • Updated Primary production income (6.109) definition to include NCMI – Primary production Income or Excluded from NCMI – Primary production income amounts
    • Updated Net foreign rent (6.114) definition with an alert box
    • Updated Capital Gains discount method – Taxable Australian property (6.119) definition to include any applicable NCMI Capital Gains and Excluded from NCMI Capital Gains amounts
    • Updated Capital Gains discount method – Non-Taxable Australian property (6.120) definition to include any applicable NCMI Capital Gains and Excluded from NCMI Capital Gains amounts
    • Updated Capital gains other – Taxable Australian property (6.121) definition to include any applicable NCMI Capital Gains and Excluded from NCMI Capital Gains amounts
    • Updated Capital gains other – Non-Taxable Australian property (6.122) definition to include NANE income referrable to a sovereign entity that is attributable or distributed through trusts.
    • Updated Non-assessable non-exempt amount (6.123) definition to include NANE income referrable to a sovereign entity that is attributable or distributed through trusts.
    • Updated Other income (6.126) definition to not include Non-Concessional MIT income amounts.
  • Sales Of securities Data Record
    • Added Reporting period start date and Reporting period end date cells and  definitions
    • Balance before transaction field (6.141) has increased  to 15 characters from 13
    • Quantity field (6.145) has increased to 14 characters from 12
    • Balance after transaction field (6.152) has increased to 15 characters from 13
    • Definitional update to Investment reference number field (6.62)
    • Added codes for the field Transaction reason code field (6.139)
    • Added codes for the field Transaction sub-type code (6.140)
    • Definitional update to field Currency exchange rate used to calculate (6.149)
    • Transaction reference field format has been changed to Alphanumeric

Interested software developers are encouraged to provide feedback on this draft specification to the Digital Partnership Office at DPO@ato.gov.au by close of business Friday 10th January 2020.

Resource Attachments