Summary

Report Type: Hard-coded

Run Frequency: Every pay sequence, super period (Super PTD) or super quarter (Super QTD).

The PGPRSUPA314 - SuperStream Alternative Format Report report enables you to create a CSV export file that that you can send to your superannuation service provider to assist with SuperStream compliance.

Important: You can only use this report if have agreement from your service provider to accept this file format.

Output

PGPRSUPA314 produces two outputs:

• PayGlobal readable report

  This output summarises values for superannuation contributions made in the reporting period.

• CSV-format export file

  This output meets the ATO’s Transitional File Format specifications - SuperStream alternative file format, version 0.4.

  Also refer to at the ATO as the 'transitional file format' or 'bridging solution'.

Settings

Period Type: Select from Q. Pay Sequences, S. Super PTD or Z. Super QTD.

Period Range: When using period type S. Super PTD or Z. Super QTD you must select the accumulator record you want to report on.

Pay Sequence: When using period type Q. Pay Sequences you must select the which pay sequences you want to report on.

File Content: This field tells the report what information should be exported. You can select from the following options:

1. Contributions and registrations
2. Contributions only
3. Registrations only

Fund Employer ID Source: This field tells the report where to get the “Superannuation Fund Generated Employer Identifier” from so that it can populate column “AG” of the export file. You can select from Superfund or Payer:

• Superfund - retrieves the employer ID from the record relating to the payment made an employee
• Payer - retrieves the employer ID from either Company Settings or the Internal Company the employee was paid by as defined by your selection in the report setting field “Sender/Payer Population”.

  Important: The Superannuation Fund Generated Employer Identifier is a unique ID number that represents the relationship between an employer and a single superannuation provider/fund. Using the “Payer” option is only suitable for those companies that either interact with only ONE superannuation provider/fund OR, the employer has arranged to use the same ID with all superannuation providers/funds they interact with.

Contribution Content: This field tells the report what contribution data you want to export. You can select from the following options:

1. All contributions (default)
2. SG only
3. Non-SG only

Sender/Payer Population: This field tells the report how to populate the Sender and Payer fields based on the settings you have applied for Internal Company Filtering. You can select from the following options:

1. Sender and payer is main company (default value)
2. Sender is main company, payer is internal company
3. Sender and payer is internal company

Payment Transaction Date: Enter the date that you will pay the Superannuation Funds the amount reported.

Payment Method: Select the method that describes how you pay the reported superfunds. You can select either Direct Credit or Direct Debit.

Note: Cheque payments are not supported for SuperStream and PayGlobal does not support BPAY.

File ID: Populating this field will be dependent on your superannuation service provider. Enter a value or leave blank.

Export Filename: You must enter a name for the file export file that will be sent to your superannuation service provider. If you intend to use the Edit Destination/Format option Save to file and you want the export file saved to different location than the PG readable report, you must include the file path and name. For all other Edit Destination/Format options the export file will be sent to the same location as the PG readable report.

Contracted Hours Calc Method: This field is required for Defined Benefit Contributions and for registration of an accumulation fund or a defined benefit fund. Select the option that represents where you record how many hours an employee is contracted to work per week.

• Profiled Hours
• Annualised Salary Default Hours
• UDF

Contracted Hours UDF: If you use a UDF to record the hours your employees are contracted to work, then select the UDF record applicable.

Full Time Hours: Default value is 38.00. If your Full-time employees don't work 38hrs per week, change the value.

Contents

CSV file

The CSV file will contain a minimum of 4 rows and 133 columns of data.

Each row will represent either:

• Employee superfund member registration
• Employee superfund contributions
• Employee combined registration and contributions
• Other member contributions

For employee rows

The reported data represents a unique combination of: employee code, employer (attached to pay period of the superannuation transactions in the report period), superfund member ID, superfund ABN, superfund USI, superfund Employer ID, superfund Organisational Name, superfund Electronic Service Address, superfund Bank Account, superfund Bank Account Name

For other member rows

The reported data represents a unique combination of: As above plus all fields on the Other member tab of the employee's superannuation fund.

PayGlobal readable report

The employee code, employee name or other member name, member ID and contribution amounts.

Before you
run this report

To avoid files being rejected by the superannuation fund or service provider please ensure the following entities have the correct data:

Employee records: TFN, DOB, Address details, at least one contact phone number (landline or mobile)

Superannuation Funds: USI, ABN, Employer ID - unless you record this on the 'Employer/Payer' record, Electronic Service Address, Bank Account, Bank Account Name and Bank Account Reference

Employee Superfund 'Other member tab': TFN (if possible), Last name, First names, DOB, Address line 1, Address line 3 (Suburb), State (not set to 'Other' for Australian address), Post code, Home or mobile phone.

The 'Employee', 'Superannuation Fund' and 'Other member' fields listed above are mandatory for this report but optional in the database.

Employer/Payer data is retrieved from either CompanySettings or the Internal Companies based on the setting you apply to the report setting field “Sender/Payer Population”. If you do not/cannot use the Superannuation Fund to record your Superannuation Fund Generated Employer Identifier (aka Employer ID field), please ensure you populate the "Super intermediary employer ID" on Company Settings and/or each Internal Company record. Not doing this may result in column "AG" being blank and cause a rejection of your SAFF file upon submission. .