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

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

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

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

The AIIR spreadsheet template version 7.1 is available for 2020-21 and subsequent financial years. Previous versions should only be used for prior year financial years.

Key changes

General key changes

• General wording changes to allow for consistency, update and clarify information and processes. Where the intent of the information content has not changed, the changes have not been tracked.
• AUSkey changed to myGovID and RAM External Links.
• Update references for SIPO or SILU to DPO throughout the specification.
• DPO Phone number has changed.
• Online services for business (OSB) information has been added.
• Correction of examples.

The following sections have been updated

• 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 any applicable NCMI Capital Gains and Excluded from NCMI Capital Gains amounts.
  • 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