specification / external / UNCLASSIFIED
format / Audience / Date / Classification
/ File Ref: / prefill tax 2.0
Pre-filling report 2017
Specification to import pre-filling data into tax agent software.
Date created: 26/04/2017
Date updated: 02/05/2017
Version: 0.2
UNCLASSIFIED / For further information or questions, contact the Software Industry Partnership Office
Visit www.softwaredevelopers.ato.gov.au/
Phone 1300 139 052
UNCLASSIFIED / PAGE 2 OF 74
UNCLASSIFIED / 2017 pre-filling report importing data into tax agent software V0.1
Endorsement / Version Control
CURRENT VERSION NUMBER / 0.1 / DATE / 22/02/2017CURRENT AUTHOR
Alex Hanna / Graduate Business Analyst / 07 321 35489
APPROVAL
Cassie Dransfield / Assistant Director, Pre-filling project manager / 07 321 33021
Trevor Fernando / Team Leader, Channels & Online BAU Support / 07 390 72727
Mark Hendy / Director, Channels & Online, BAU Support / 07 311 99520
VERSION CONTROL
Version / Revision date / Revision description / Author/ModifierV0.1.
V0.2.
V1.0. / 22/02/2017
27/03/2017
02/05/2017 / Initial draft for Pre-filling project 2016
Updated to include payment type H
Update based on feedback from product owner / Alex Hanna
Alex Hanna
Alex Hanna
CHANGES FOR 2017
This document has been updated for the 2016-17 financial year. Changes specific to 2017 are highlighted in green. Cyclical changes, such as updating the financial year, are not highlighted.
Table of Contents
Endorsement / Version Control 2
1. Introduction 4
1.1. Purpose 4
1.2. Scope 4
1.3. References 4
1.4. Audience 4
2. Downloading the report 5
3. Requirements for Importing data into tax agent software 6
4. Examples of download formats 7
4.1. XML tag format with ELS tag attributes 7
5. Data dictionary 8
5.1. Report header 8
5.2. Taxpayer Details 9
5.3. 2016-17 PAYG Payment summaries 10
5.3.1. INB – Individual non-business payment summaries 11
5.3.2. INB – Individual and non-business payment summaries (Annuity) 13
5.3.3. PSI <PaymentType=003> Voluntary agreement 15
5.3.4. PSI <PaymentType=001> Labour hire 16
5.3.5. PSI <PaymentType=002> Other specified payments 17
5.3.6. EMP – Employment termination payment summaries 18
5.3.7. SPN – Superannuation income stream payment summaries 19
5.3.8. SPN – Superannuation lump sum payment summaries 20
5.3.9. PSI <PaymentType=004> Personal services attributed income 21
5.3.10. Foreign employment income payment summary (Foreign employment income) 22
5.3.11. Foreign employment income payment summary (Joint petroleum development area) 24
5.4. 2016-17 Government Payments 25
5.5. 2016-17 ATO Interest 27
5.6. 2016-17 Interest Income 29
5.7. 2016-17Dividend and interest schedule income 31
5.8. 2016-17 Dividend income 34
5.9. 2016-17 Employee share schemes 36
5.10. 2016-17 Managed fund distributions 38
5.11. 2016 – 17 PARTNERSHIP DISTRIBUTIONS 46
5.12. 2016-17 Foreign Source Investment Income 48
5.13. 2016-17 Share Disposal 51
5.14. 2016-17 Taxable Payments 52
5.15. 2016-17 Net Farm Management Deposits or repayments 53
5.16. Tax offsets 55
5.17. MEDICARE LEVY SURCHARGE 56
5.18. Private Health Insurance Policy Details 57
5.19. income test related items 58
5.20 ATO Data 60
5.21. 2015-16 Prior year tax return details 62
6. Mapped error codes 66
1. Introduction
1.1. Purpose
The Pre-filling report 2017 will focus on simplifying and consolidation of the existing 2016 product. This will include removing extraneous sections and re-ordering data
This report is a tool tax agents use to assist them in completing a taxpayer’s income tax return. The report does not list all sources of income and therefore, it should not be relied upon exclusively.
The benefits of displaying or importing pre-filling information are:
- making it easier to prepare returns by providing income, deduction and tax withheld details
- more certainty about the income and deduction details thereby reducing the chance of mistakes, and
- saving time since tax agents can verify details with the client.
1.2. Scope
Tax agents can request the Pre-filling report in the Tax Agent Portal. The report is to be displayed on the portal for multiple years (for 2017 there will be (9) financial years displayed).
Medicare data is only available for one (1) financial year at a time as it is a single year service.
The Pre-filling report can be viewed online or downloaded to their personal computer in the following formats:
- ASCII (comma delimited)
- ASCII zipped
- HTML
- HTML zipped
- XML
This document provides information on how the Pre-filling report is generated and formatted.
1.3. References
This document should be read in conjunction with the EI specification.
An XML Schema Definition (XSD) is used to guarantee to the end user that the XML provided by the application is in a valid and consistent format. It defines what format the XML will be in so that the end application knows what to expect. An XSD has been provided for assistance in building an application based on the XSD’s definition.
1.4. Audience
This document has been developed for any persons wanting to implement a software solution to import the Pre-filling report data into an individual’s income tax return.
2. Downloading the report
Tax agents download the Pre-filling report to their personal computer by
logging into the Tax Agent Portal. (The ‘Homepage’ is displayed).
selecting Reports link in the left navigation. (The ‘Reports’ page is displayed).
selecting the Pre-filling report link. (The ‘Enter report criteria’ page is displayed).
The tax agent can request up to 5 clients’ Pre-filling reports. The tax agent enters the TFN, Medicare card number (optional) including the relevant Individual Reference Number and any additional dependant Individual Reference Numbers.
Select a report format and select the Generate report button. (The ‘Report download page’ is displayed).
Downloading the Pre-filling report for HTML formatted pages, ASCII text and XML
The download page will display up to 5 separate links
Downloading the Pre-filling report for zipped HTML formatted pages or ASCII
The download page will display a single zipped download link that will contain up to 5 separate files within it.
Alternatively, tax agents can request the report from Client reports under the Your client function. They can download the report by
- Selecting the Pre-filling report link. (The ‘Enter report criteria’ page is displayed).
- Entering a Medicare card number (optional) including the relevant Individual Reference Number and any additional dependant Individual reference numbers.
Select a report format and select the Generate report button. (The ‘Report download page’ is displayed).
When the Download file link is selected, a ‘Save As’ window is displayed. The Portal will default to the ‘My documents’ folder and provide a report name.
The tax agent can choose
- to change the directory where the file is saved, and
- over-write the default file name with a new name.
After selecting the Save button, the file is now saved on the tax agent’s personal computer.
3. Requirements for Importing data into tax agent software
Tax agents were consulted regarding how they would like their client’s tax return pre-filled with the report’s data.
The tax agent must be able to choose whether to pre-fill their client’s tax return on an individual basis.
The data may be imported into the worksheets or schedules used to complete the tax return.
The pre-filled data must be distinguishable from other data.
All pre-filled data must be editable except for the number of investors and the gross amounts for joint investments (interest, dividends and managed funds).
Pre-filled data may be deleted.
Pre-filled data may be reviewed by the tax agent prior to lodging the tax return.
The tax agent software may alert the tax agent which data has not yet been reviewed.
4. Examples of download formats
4.1. XML tag format with ELS tag attributes
UNCLASSIFIED / PAGE 2 OF 75UNCLASSIFIED / 2017 pre-filling report importing data into tax agent software 0.1
5. Data dictionary
5.1. Report header
PRE-FILLING REPORT 2017 /Text / Valid Values / Format / Description / XML Tag /
‘Pre-filling report <year>.‘ / String: 10 / Pre-filling report <year> = requested year
<Version > = version number. This is only displayed in downloadable formats such as,
- XML tag – displayed in the report
- ASCII/CSV – displayed in the report
- HTML – not displayed in the report (meta file tag) / <?xml version=”1.0” encoding=”UTF-8”?>
- Prefilling2017
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
<Version> / - XML: <Version>1.0</Version>
- ASCII/CVS: Pre-filling report 2017 – version 1.0
- HTML: <metaname=”Version”content=”1.0”>
‘Report created:’ <date> / Date: 10 DD/MM/YYYY / Date report was generated / <ReportCreationDate/ReportCreationDate>
Static text. / ‘You should not rely exclusively on this report but use it to assist you in preparing your client’s income tax return. For more information refer to portal help or www.ato.gov.au/taprefilling.’ / Static: Text
Hyperlink / Hyperlink – portal help
Hyperlink – www.ato.gov.au/taprefilling / portal help =
http://portalhelp.ato.gov.au/TAP/ADMIN/Your_clients/Client_reports/Reports/#Pre_filling
pre-filling service – tax agent portal =
https://www.ato.gov.au/Tax-professionals/Tax-Agent-Portal/Using-the-Tax-Agent-Portal/Portal-reports/Pre-filling-service/
5.2. Taxpayer Details
PRE-FILLING REPORT 2017Row Name / Valid Values / Format / Description / XML Tag / ELS Attribute
‘Taxpayer details’ / Section title – always displayed / - <TaxPayerDetails>
‘Tax file number’ / 1,2,…9, 0 / String: 11 / - Taxpayer’s tax file number – always displayed / <TFN</TFN> / ^AAD
‘Title’ / String: 15 / - Taxpayer’s title – blank if unknown
- Trailing blanks likely to exist. / <Title> </Title> / ^ABE
‘Given names’ / <GivenName> / String: 15 / - First name - always displayed
- Trailing blanks may exist
- First name and middle name appear on one row / <GivenName</GivenName / ^ABG
<MiddleName> / String: 30 / - Middle name - blank if unknown
- Trailing blanks may exist / <MiddleName</MiddleName / ^BBB
‘Family name and suffix’ / <FamilyName> / String: 30 / - Surname - always displayed
- Trailing blanks may exist
- Family name and suffix appear on one row / <FamilyName</FamilyName / ^ABF
<Suffix> / String: 10 / - Suffix (eg “Jnr” )- blank if unknown
- Trailing blanks may exist / <Suffix</Suffix / ^BAW
‘Australian resident as at <ResidencyStatusDate>’ / ‘<Yes>’ OR ’<No>’ / String: 3 / - Yes/No. Is the taxpayer an Australian resident? / <ResidencyStatus</ResidencyStatus> / ^AJY
<ReportCreationDate> / Date: 10
DD/MM/YYYY / <ResidencyStatusDate> = the same date as when the report was created. / ResidencyStatusDate>
</ResidencyStatusDate>
‘Postal address’ / <Line1> / String: 38 (numeric/alpha) / - Postal Address - blank if ‘0’ value or unknown.
- Suburb, State and Postcode - displayed on one row / - <PostalAddress>
<Line1</Line1> / ^ABH
<Line2> / String: 38 (numeric/alpha) / <Line2</Line2> / ^ABH
<Suburb> <State> <Postcode> / String: 27,
Integer: 3,
String: 4 (alpha/numeric) / <Suburb</Suburb>
<State</State>
<PostCode</PostCode> / ^AME
^AMF
^APE
<Country> / String: 20 / - Country = ‘Australia’ - row not visible
- Country ≠ ‘Australia’ - country displayed / <Country</Country>
</PostalAddress> / ^AMG
‘Residential address‘ / <Line1> / String: 38 (numeric/alpha) / - Residential Address - blank if ‘0’ value or unknown.
- Suburb, State and Postcode - displayed on one row / - <ResidentialAddress>
<Line1</Line1> / ^ABK
<Line2> / String: 38 (numeric/alpha) / <Line2</Line2> / ^ABK
<Suburb> <State> <Postcode> / String: 27, 3, 4 (alpha/numeric) / <Suburb</Suburb>
<State</State>
<PostCode</PostCode> / ^AXQ
^AXR
^APH
<Country> / String: 20 / - Country = ‘Australia’ - row not visible
- Country ≠ ‘Australia’ - country displayed / <Country</Country>
</ResidentialAddress> / ^BAU
‘Date of birth’ / <DateOfBirth> / Date: 10
DD/MM/YYYY / - Date of birth – always displayed / <DateOfBirth</DateOfBirth> / ^ABQ
‘Contact Number’ / <AreaCode> (1,2,…9, 0) / Integer: 4 / - Area code – displayed in brackets
- Phone number – blank if unknown
- Displayed on one row / - <ContactPhone>
<AreaCode</AreaCode> / ^BOC
<PhoneNo>
(1, 2, …9, 0) / Integer: 15 / <PhoneNo</PhoneNo>
</ContactPhone>
</TaxpayerDetails> / ^BOD
5.3. 2016-17 PAYG Payment summaries
Assumption: All VOL, LAB and PSA will be converted to one of the following
- PSI <PaymentType001> = Business and personal services income payment summary, payment type - Labour hire
- PSI <PaymentType002> = Business and personal services income payment summary, payment type - Other specified payments
- PSI <PaymentType003> = Business and personal services income payment summary, payment type – Voluntary agreement
- PSI <PaymentType004> = Business and personal services income payment summary, payment type – Personal services income.
PRE-FILLING REPORT 2017Row Name / Valid Values / Format / Description / Label / XML tag
‘2016-17 PAYG payment summaries as at <LastUpdatedDate>’ / Section title –Section only displayed if data exists.
- 3 columns - bold print.
Tax withheld (right align)
Income (right align)
Label (right align) / - <PAYGPaymentSummaries>
<MostRecentPAYGUpdateDate>
</MostRecentPAYGUpdateDate>
5.3.1. INB – Individual non-business payment summaries
Row Name / Valid Values / Format / Description / Label / XML tag‘Type of payment summary:’ / INB payment summary / String: 250 / Type of payment summary being displayed / - <IndividualNonBusinessPaymentSummary>
-IndividualNonBusinessPaymentSummaryType>
<IncomeType> </IncomeType>
‘Available for pre-filling:’ / DD/MM/YYYY / Date10 / Date information received. / LastUpdatedTimestamp>
</LastUpdatedTimestamp>
‘ABN:’ / ABN and CAC
1, 2, …9, 0 / Integer: 20 / The payer ABN / CAC number on the payment summary / <PayerABN> </PayerABN>
<PayerCAC> </PayerCAC>
‘Employer’s name:’ / Employer’s name and (Income type) / String: 76 / The employer’s name and (Income type) on the INB payment summary. / <Payer Employer’s name > </Payer Employer’s name
<Payer (Income type)> </(Income type)>
Income type is type X where X is S for salary, P for pension and H for working Holiday Makers