jagomart
digital resources
picture1_Excel Sheet Download 6571 | Superstream Alternative File Format   V1 0 - Standar Format


 270x       Filetype XLSX       File size 0.03 MB       Source: softwaredevelopers.ato.gov.au


File: Excel Sheet Download 6571 | Superstream Alternative File Format V1 0 - Standar Format
sheet 1 release note release note superstream alternative file format version 10 release date 4 august 2014 this release note must be read in conjunction with the guidance note entitled ...

icon picture XLSX Filetype Excel XLSX | Posted on 24 Jun 2022 | 3 years ago
Partial file snippet.
Sheet 1: Release note
Release note
SuperStream alternative file format - version 1.0
Release date - 4 August 2014
This release note must be read in conjunction with the guidance note entitled 'SuperStream alternative file format', published by the ATO.

General information
INTENT OF THE SUPERSTREAM ALTERNATIVE FILE FORMAT
* The SuperStream alternative file format is intended to complement the Superannuation Data and Payment Standard 2012 (the 'standard'); it does not replace the standard. Nothing in the SuperStream alternative file format, or the published guidance note, is intended to override the legislative or regulatory obligations of employers and funds under the standard.
* Instead, the alternative file format is intended to be a complement to the standard where certain options are exercised under the standard. This includes, for example, where data is exchanged in intermediate or transitional steps in a format other than that prescribed in the standard.
* When used to that effect it is intended that the alternative file format will help lower costs for those who have exercised these options.
SCOPE
* The SuperStream alternative file format is intended to support exchange of member registration and contribution data between employers and funds under either:
- an alternative approach, as documented in the legislative instrument (sometimes known as bridging solutions, or ‘Channel B’), or
- to support the exchange of files between an employer and their service provider that will ultimately lead to a conformant exchange of data, once transformed into XBRL and ebMS3/AS4 (‘Channel A’).
BACKGROUND
* The standard includes a specification for how registration and contribution messages are to be sent. This specification outlines both the format for the data (XBRL), as well as the message exchange protocol to be used (ebMS3/AS4).
* The standard also recognises that as part of the transition employers and funds may choose to adopt an alternative arrangement, subject to conditions detailed in the legislative instrument. Under this arrangement an alternative file format may be used to pass data from the employer to the fund. Interactions between employers and their service providers (such as clearing houses) also involve alternative file formats, often generated by payroll software products, prior to the point at which XBRL files are created.
* The outcome is that a wide variety of alternative file formats are used across the industry, and will continue to be used for some time, requiring funds and employers (and the various service providers of both) to incur the cost of maintaining the many file formats.
* In light of this the question was raised as to whether it was possible to agree a common alternative file format, complementing the standard, so as to reduce costs to all affected parties.
APPROACH
* As a result of a co-design process across key industry stakeholders in early 2014, it was agreed that a SuperStream alternative file format would be described using a comma separated value (CSV) format. This file would be presented for use on an optional basis.
* It was expected that the file would have utility to support both the alternative approaches as documented in the legislative instrument, as well as supporting the exchange of files between an employer and their service provider leading to a conformant exchange of data once transformed.
USING THE SUPERSTREAM ALTERNATIVE FILE FORMAT
* The use of the SuperStream alternative file format is optional, and is by mutual agreement between an employer and a fund.
* Where employers and funds agree to use the format the two parties will work to resolve all remaining implementation choices/details required (in practice this choice, and therefore resolution of details, will often effectively be made by service providers).
* The data items contained in the SuperStream alternative file format are intended to align with the data items contained in the standard. Fields included in the standard that are constant, derivable, or not required for this alternative file format have not been included in the specification.
* The SuperStream alternative file format does not specify the mandatory or optional nature of fields, business rules, data types and field lengths of data items where those items are described in the standard. Developers are expected to reference the standard (including the supporting taxonomy files) in order to understand these details. This is to ensure that there is a single source of truth underpinning the definition of data exchanged between employers and funds.
PAYMENT REFERENCE NUMBER
* Where the employer is paying contributions directly to the fund, the rules in respect to the payment reference number (PRN) apply. This is to ensure the integrity of the reconciliation process for the sender and receiver.
* Where the employer is using a service provider (for example, a clearing house) to split, and then distribute, the contribution file and payments it is up to the employer and their service provider to determine the manner in which payment reference is used.
NEGATIVE AMOUNTS
* In general this file should not be used for passing negative amounts. This principle is applied to ensure alignment between this alternative file format and the standard, where the passing of negative values is out of scope (except in very limited circumstances where generic tuples are used for negative amounts by mutual agreement between employer and fund).
* It is recognised that in some cases the exchange of negative values will be desired by both employer and fund. In those cases this file can support the requirement however the following principles must be followed:
- the default position is that negative values are not supported
- a choice can be made to support negative values in fields on an opt-in basis, to suit special, known requirements. This choice is exercised on the fund side
- where a fund opts to allow negatives, the fund is responsible for specifying the rules governing where and how negative amounts can be added, and the implications for associated payments, and
- where a fund opts to allow negatives, the fund is also responsible for working with their stakeholders - employers and other service providers (for example payroll software companies) - to implement that choice.
* An indicator has been provided in the file header (that is, 'negatives supported') so that an explicit declaration is made as to whether negative values are supported in the instance of the file being sent. In line with the principles above, the default value for this indicator is 'false'.

Release specific information
Version 1.0 reflects the first production release of the SuperStream alternative file format.

Sheet 2: Alternative File Format
Rules and guidance: Mandatory data field Alphanumeric data allowed Must conform with published file version number VERSION <version data> Rules and guidance: * Mandatory data field. If this field is not populated, the value 'false' should be assumed. * Boolean data field: value must be 'true' or 'false' only. * This field is an indicator. - true: this indicates that negative amounts are able to be provided in fields and can be processed - false: this indicates that negative amounts in fields must not be used and should not be processed. * Principles governing use - The default position is that negative values are NOT supported. - A choice can be made to support negative values in fields on an opt-in basis, to suit special, known requirements. This choice is exercised on the Fund side. - Where a Fund opts to allow negatives, the Fund is responsible for specifying the rules governing where and how negative amounts can be added, and the implications for associated payments. - Where a Fund opts to allow negatives, the Fund is also responsible for working with their stakeholders - employers and other service providers (for example payroll software companies) - to implement that choice. NEGATIVES SUPPORTED <negatives supported data> Rules and guidance: Optional data field Alphanumeric data allowed • Maximum length = 20 characters • Allowed characters = 0-9, a-z, A-Z, underscore, hyphen, period FILE ID <file ID data>






























































































































LINE ID HEADER


SENDER





PAYER



PAYEE/RECEIVER










EMPLOYER


SUPER FUND MEMBER COMMON






















SUPER FUND MEMBER CONTRIBUTIONS








SUPER FUND MEMBER REGISTRATION














DEFINED BENEFITS CONTRIBUTIONS














DEFINED BENEFITS REGISTRATION
































Rules and guidance: Optional data field If used, each Line ID must be unique within the file Intended to be used to support error resolution where desired Alphanumeric data allowed • Maximum length = 20 characters • Allowed characters = 0-9, a-z, A-Z, underscore, hyphen, period ID SourceEntityID SourceEntityIDType SourceElectronicServiceAddress ElectronicErrorMessaging ABN Organisational Name Text Family Name Given Name Other Given Name E-mail Address Text Telephone Minimal Number ABN Organisational Name Text BSB Number Account Number Account Name Text ABN USI Organisational Name Text TargetElectronicServiceAddress Payment Method Code Transaction Date Payment/Customer Reference Number Bpay Biller Code Payment Amount BSB Number Account Number Account Name Text ABN Rules and guidance: Optional data field This field is not described in the data standard. It has been included in this file to link an employee with different sections/departments/payrolls etc. within an employer (that is, the same ABN) if desired. There is no direct mapping to an element in the Member registration and contribution data standard. Alphanumeric data allowed • Maximum length = 20 characters • Allowed characters = 0-9, a-z, A-Z, underscore, hyphen, period Location ID Organisational Name Text Superannuation Fund Generated Employer Identifier TFN Person Name Title Text Person Name Suffix text Family Name Given Name Other Given Name Sex Code Birth Date Address Usage Code Address Details Line 1 Text Address Details Line 2 Text Address Details Line 3 Text Address Details Line 4 Text Locality Name Text Postcode Text State or Territory Code Country Code E-mail Address Text Telephone Minimal Number Landline Telephone Minimal Number Mobile Member Client Identifier Payroll Number Identifier Employment End Date Employment End Reason Text Pay Period Start Date Pay Period End Date Superannuation Guarantee Amount Award or Productivity Amount Personal Contributions Amount Salary Sacrificed Amount Voluntary Amount Spouse Contributions Amount Child Contributions Amount Other Third Party Contributions Amount Employment Start Date At Work Indicator Annual Salary for Benefits Amount Annual Salary for Contributions Amount Annual Salary for Contributions Effective Start Date Annual Salary for Contributions Effective End Date Annual Salary for Insurance Amount Weekly Hours Worked Number Occupation Description Insurance Opt Out Indicator Fund Registration Date Benefit Category Text Employment Status Code Super Contribution Commence Date Super Contribution Cease Date Member Registration Amendment Reason Text Defined Benefit Member Pre Tax Contribution Defined Benefit Member Post Tax Contribution Defined Benefit Employer Contribution Defined Benefit Notional Member Pre Tax Contribution Defined Benefit Notional Member Post Tax Contribution Defined Benefit Notional Employer Contribution Ordinary Time Earnings Actual Periodic Salary or Wages Earned Superannuable Allowances Paid Notional Superannuable Allowances Service Fraction Service Fraction Effective Date Full Time Hours Contracted Hours Actual Hours Paid Employee Location Identifier Service Fraction Service Fraction Start Date Service Fraction End Date Defined Benefit Employer Rate Defined Benefit Employer Rate Start Date Defined Benefit Employer Rate End Date Defined Benefit Member Rate Defined Benefit Member Rate Start Date Defined Benefit Member Rate End Date Defined Benefit Annual Salary 1 Defined Benefit Annual Salary 1 Start Date Defined Benefit Annual Salary 1 End Date Defined Benefit Annual Salary 2 Defined Benefit Annual Salary 2 Start Date Defined Benefit Annual Salary 2 End Date Defined Benefit Annual Salary 3 Defined Benefit Annual Salary 3 Start Date Defined Benefit Annual Salary 3 End Date Defined Benefit Annual Salary 4 Defined Benefit Annual Salary 4 Start Date Defined Benefit Annual Salary 4 End Date Defined Benefit Annual Salary 5 Defined Benefit Annual Salary 5 Start Date Defined Benefit Annual Salary 5 End Date Leave Without Pay Code Leave Without Pay Code Start Date Leave Without Pay Code End Date Annual Salary for Insurance Effective Date Annual Salary for Benefits Effective Date Employee Status Effective Date Employee Benefit Category Effective Date Employee Location Identifier Employee Location Identifier Start Date Employee Location Identifier End Date

Sheet 3: Examples
Rules and guidance: Mandatory data field Alphanumeric data allowed Must conform with published file version number VERSION 1.0 Rules and guidance: * Mandatory data field. If this field is not populated, the value 'false' should be assumed. * Boolean data field: value must be 'true' or 'false' only. * This field is an indicator. - true: this indicates that negative amounts are able to be provided in fields and can be processed - false: this indicates that negative amounts in fields must not be used and should not be processed. * Principles governing use - The default position is that negative values are NOT supported. - A choice can be made to support negative values in fields on an opt-in basis, to suit special, known requirements. This choice is exercised on the Fund side. - Where a Fund opts to allow negatives, the Fund is responsible for specifying the rules governing where and how negative amounts can be added, and the implications for associated payments. - Where a Fund opts to allow negatives, the Fund is also responsible for working with their stakeholders - employers and other service providers (for example payroll software companies) - to implement that choice. NEGATIVES SUPPORTED false Rules and guidance: Optional data field Alphanumeric data allowed FILE ID ABC123






























































































































LINE ID HEADER


SENDER





PAYER



PAYEE/RECEIVER










EMPLOYER


SUPER FUND MEMBER COMMON






















SUPER FUND MEMBER CONTRIBUTIONS








SUPER FUND MEMBER REGISTRATION














DEFINED BENEFITS CONTRIBUTIONS














DEFINED BENEFITS REGISTRATION
































Rules and guidance: Optional data field If used, each Line ID must be unique within the file Alphanumeric data allowed Intended to be used to support error resolution where desired ID SourceEntityID SourceEntityIDType SourceElectronicServiceAddress ElectronicErrorMessaging ABN Organisational Name Text Family Name Given Name Other Given Name E-mail Address Text Telephone Minimal Number ABN Organisational Name Text BSB Number Account Number Account Name Text ABN USI Organisational Name Text TargetElectronicServiceAddress Payment Method Code Transaction Date Payment/Customer Reference Number Bpay Biller Code Payment Amount BSB Number Account Number Account Name Text ABN Location ID Organisational Name Text Superannuation Fund Generated Employer Identifier TFN Person Name Title Text Person Name Suffix text Family Name Given Name Other Given Name Sex Code Birth Date Address Usage Code Address Details Line 1 Text Address Details Line 2 Text Address Details Line 3 Text Address Details Line 4 Text Locality Name Text Postcode Text State or Territory Code Country Code E-mail Address Text Telephone Minimal Number Landline Telephone Miminal Number Mobile Member Client Identifier Payroll Number Identifier Employment End Date Employment End Reason Text Pay Period Start Date Pay Period End Date Superannuation Guarantee Amount Award or Productivity Amount Personal Contributions Amount Salary Sacrificed Amount Voluntary Amount Spouse Contributions Amount Child Contributions Amount Other Third Party Contributions Amount Employment Start Date At Work Indicator Annual Salary for Benefits Amount Annual Salary for Contributions Amount Annual Salary for Contributions Effective Start Date Annual Salary for Contributions Effective End Date Annual Salary for Insurance Amount Weekly Hours Worked Number Occupation Description Insurance Opt Out Indicator Fund Registration Date Benefit Category Text Employment Status Code Super Contribution Commence Date Super Contribution Cease Date Member Registration Amendment Reason Text Defined Benefit Member Pre Tax Contribution Defined Benefit Member Post Tax Contribution Defined Benefit Employer Contribution Defined Benefit Notional Member Pre Tax Contribution Defined Benefit Notional Member Post Tax Contribution Defined Benefit Notional Employer Contribution Ordinary Time Earnings Actual Periodic Salary or Wages Earned Superannuable Allowances Paid Notional Superannuable Allowances Service Fraction Service Fraction Effective Date Full Time Hours Contracted Hours Actual Hours Paid Employee Location Identifier Service Fraction Service Fraction Start Date Service Fraction End Date Defined Benefit Employer Rate Defined Benefit Employer Rate Start Date Defined Benefit Employer Rate End Date Defined Benefit Member Rate Defined Benefit Member Rate Start Date Defined Benefit Member Rate End Date Defined Benefit Annual Salary 1 Defined Benefit Annual Salary 1 Start Date Defined Benefit Annual Salary 1 End Date Defined Benefit Annual Salary 2 Defined Benefit Annual Salary 2 Start Date Defined Benefit Annual Salary 2 End Date Defined Benefit Annual Salary 3 Defined Benefit Annual Salary 3 Start Date Defined Benefit Annual Salary 3 End Date Defined Benefit Annual Salary 4 Defined Benefit Annual Salary 4 Start Date Defined Benefit Annual Salary 4 End Date Defined Benefit Annual Salary 5 Defined Benefit Annual Salary 5 Start Date Defined Benefit Annual Salary 5 End Date Leave Without Pay Code Leave Without Pay Code Start Date Leave Without Pay Code End Date Annual Salary for Insurance Effective Date Annual Salary for Benefits Effective Date Employee Status Effective Date Employee Benefit Category Effective Date Employee Location Identifier Employee Location Identifier Start Date Employee Location Identifier End Date
Additional information: Example showing a generic contributions transaction. No defined benefit or registration component. 1 84111122223 urn:oasis:tc:ebcore:partyid-type:ABN:0151 mygateway true 84111122223 Banzai Pty Ltd Sims Simon
simon.sims@banzai.com.au 02 62478965 84111122223 Banzai Pty Ltd 66121 256987 Banzai Pty Ltd 98111133334 98111133334001 Reach Your Goal Fund acmegateway DirectDebit 2014-07-22 230722123
510 626845 9000000145 Trustee for Reach your Goal 84111122223
Banzai Pty Ltd
999999716 Mr Snr Jones Adam
1 1969-07-17 RES 15 Gale Way


Griffith 2603 ACT au ajonessnr@yahoo.com.au
0410101001 M469857


2014-07-07 2014-07-21 500
10




2014-07-15 1 250000 250000 2014-07-15
250000 40 Manager 0 2014-07-22
Full time 2014-07-15



















































Additional information: Example showing a generic registration transaction. No defined benefit or contribution component. 2 84111122223 urn:oasis:tc:ebcore:partyid-type:ABN:0151 mygateway true 84111122223 Banzai Pty Ltd Sims Simon
simon.sims@banzai.com.au 02 62478965




12345678901 12345678901100 Window Fund acmegateway







84111122223
Banzai Pty Ltd
100000001 Ms
Smith Jane Emily 2 1970-01-01 RES 2/225 Benaud Lane


Coogee 2034 NSW au
0298754444
















































































Additional information: Example showing a combioned registration and contributions transaction. No defined benefit component. 3 84111122223 urn:oasis:tc:ebcore:partyid-type:ABN:0151 mygateway true 84111122223 Banzai Pty Ltd Sims Simon
simon.sims@banzai.com.au 02 62478965 84111122223 Banzai Pty Ltd 66121 256987 Banzai Pty Ltd 24681012141 24681012141246 Cloud Super 123.456.789.101 BPAY 2014-07-22 8426751935426840 9563 360


84111122223
Banzai Pty Ltd
200000002 Mr
White Alan Matthew 1 1960-02-02 RES 96 Monkey Avenue


Richmond 3121 VIC au


96R45678956


2014-07-07 2014-07-21 250

110




1 77500 72200 2014-07-07
72200







Change to annual salary

















































Additional information: Example showing a contributions transaction with a defined benefit component. No registration. 4 84111122223 urn:oasis:tc:ebcore:partyid-type:ABN:0151 mygateway true 84111122223 Banzai Pty Ltd Sims Simon
simon.sims@banzai.com.au 02 62478965 84111122223 Banzai Pty Ltd 66121 256987 Banzai Pty Ltd 13579111315 98765432110999 Public Wealth Management https://www.superstreamgateway.com.au DirectCredit 2014-07-22 741852963369852000
301 626845 9000000145 Trustee for Public Wealth Management 84111122223
Banzai Pty Ltd
300000003 Ms
Brown Jeanette Ida 2 1950-06-15 RES 55 Railway Parade


Argyle 6239 WA au


100236597


2014-07-07 2014-07-21
























85 216






1 2014-07-07





































Additional information: Example showing a registration transaction with a defined benefit component. No contribution. 5 84111122223 urn:oasis:tc:ebcore:partyid-type:ABN:0151 mygateway true 84111122223 Banzai Pty Ltd Sims Simon
simon.sims@banzai.com.au 02 62478965




98765432110 98765432110999 Public Wealth Management https://www.superstreamgateway.com.au







84111122223
Banzai Pty Ltd
400000004 Mr
Sung Sam
1 1985-11-23 RES The Place Unit 2 Block 4 777 Wotherspoon Street Sydney 2000 NSW au
















2014-07-08 1 45000 45000 2014-07-08
45000 35 Salesperson 0 2014-07-22
Full time 2014-07-08

















1 2014-07-08
12.5% 2014-07-08
5% 2014-07-08


















2014-07-08 2014-07-08 2014-07-08 2014-07-08



The words contained in this file might help you see if this file matches what you are looking for:

...Sheet release note superstream alternative file format version date august this must be read in conjunction with the guidance entitled published by ato general information intent of is intended to complement superannuation data and payment standard it does not replace nothing or override legislative regulatory obligations employers funds under instead a where certain options are exercised includes for example exchanged intermediate transitional steps other than that prescribed when used effect will help lower costs those who have these scope support exchange member registration contribution between either an approach as documented instrument sometimes known bridging solutions lsquo channel b rsquo files employer their service provider ultimately lead conformant once transformed into xbrl ebmsas background specification how messages sent outlines both well message protocol also recognises part transition may choose adopt arrangement subject conditions detailed pass from fund interaction...

no reviews yet
Please Login to review.