Previous page

Next page

PGPRSUPA313 - Superstream Formatting Requirements

To run and submit the PGSUPA313 report successfully, some database preparation may be required. This may include the following details:

Address formatting for Australian addresses

Any address is assumed to be in Australia unless the Country field is explicitly set to another country. If the country is AU, AUS, Australia or blank (i.e. Australia), the following fields may be populated. An example is also provided for your reference.

Field

Required

Example

Address Line 1

Mandatory

Unit 3

Address Line 2

Optional

10 Kent St

Address Line 3

Optional

SYDNEY

Address Line 4

Ignored

 

State

Mandatory

NSW

Post Code

Mandatory

2000

Country

Optional

AU

Address Line 3, if populated, should hold the suburb. For Australian addresses, the Address Line 3, Post Code and State must be a valid combination in the list published by Australia Post (see http://auspost.com.au to search for valid post codes).

Address formatting for International addresses

If some other country is specified, the following fields may be populated. An example is also provided for your reference.

Field

Required

Example

Address Line 1

Mandatory

Unit 1B Level 7, West Building

Address Line 2

Optional

123 Johnstone Street West

Address Line 3

Optional

Point Chevalier

Address Line 4

Optional

Auckland 1022

State

Ignored

 

Post Code

Ignored

 

Country

Mandatory

NZ

The Post Code and State columns are specific to Australian addresses and must be left blank for international addresses.

Date fields

It is worth noting that the date format used in the QuickSuper report for Exolvo will always use the dd/mm/yyyy format. This date format is required to be registered with QuickSuper prior to submitting a file.

Date of birth

Date of birth must be completed and must be a valid value. This means that it is not outside an accepted range such as being greater than the current date or the date of birth is greater than 100 years ago.

Super Settings Group

The default Super Settings Group (specified in Company Settings - Payroll - Misc - Misc) must have a current SGC Minimum Percentage specified. If no active value is specified the report will not know how to split the Employer Super Guarantee Amount and the Employer Additional Amount values.

Employee SuperFund Member Id

All employee's must be setup with a valid Member Id (located on the Membership tab) on each of their current employee super fund records. The value may only contain alphanumeric, hyphen and forward slash characters otherwise the export file will be rejected by QuickSuper.

Intermediary Fund Id or SPIN

On the superannuation fund record itself, either the Intermediary Fund Id or the SPIN number must be populated. Exolvo will use, on the PGPRSUPA313 export file, the Intermediary Fund Id if it is populated otherwise default to the SPIN number. When submitting to QuickSuper, if the resulting number is not found in the QuickSuper database or it is not in active use, the export file will be rejected.

Important: This may mean you need to split existing superannuation fund records if you have been using a single superfund record that may be across multiple Intermediary Fund Id's or SPIN numbers.

Intermediary Employer Id

Exolvo databases must have a valid Super Intermediary Employer Id on either (or both) the Internal Company or the Modify Company Settings if submitting to QuickSuper.

If there is a valid value in any Internal Company located on the employees default pay period, the report will use this value otherwise default to the Modify Company Settings equivalent value.

Other member details

If an employee has any other member contributions then the following fields must be completed on the employees equivalent super fund record:

Topic: 42732