Skip to main content
Skip table of contents

PR - Super Remittance File/Report

Super Remittance File/Report Overview

This program can be used to either:

  • Generate a superannuation remittance report.

  • Generate a TXT file to submit to a superannuation clearinghouse.

  • Generate a superannuation CSV alternative file format.

The layout of the report is set up in this program.

It is a once-only user-definable setup which can be altered later if the need arises.

Map Genders

Use the 'Map Genders' icon to view or edit the specific TASS genders and codes mapped for this report.

Important!

If your school has defined additional gender types that are not recognised by the report's governing body, you will see the following message:

'Unmapped Genders exist. To run this report you must use the 'Map Genders' icon, and enter a mapping for all genders.'

To run the report, any additional genders in your database must be mapped to those that are accepted for the report by the governing body.

For example, if the governing body were to accept 3 gender types:

  1. Female might map to gender code 'F'.

  2. Male might map to gender code 'M'.

  3. Any additional gender types that your school recognises could map to 'Unknown' (gender code 'U')—if the governing body recognises this gender type and you have defined it (or it is already defined) in TASS.

For more information on 'Gender Setup', refer to Community Plus program Setup Information.

Define Your File/Report Format

Before you can use this report you must set up your file/report format. 

Click on the 'Define Format' icon to display the 'Super File/Report Format List' screen.

Click on the 'New Field' button to start the 'mapping' of the fields in your report/file to data elements within the payroll. Fields are numbered from left to right.

Fields that require further explanation

Field Number

Fields will be numbered from left to right as they appear in your report or file. The system will sequentially number them starting at 1 as you enter them.

*Data Type

Employee/Fund Data

If this field on the report is an Employee/Fund Data type then you will need to map it to one of the following payroll fields:

  • Fund ID.

  • Employee Code.

  • Member Number.

  • Surname.

  • Given Names.

  • Title.

  • Initials.

  • Date of Birth.

  • Gender.

  • Tax File Number.

  • Start Date.

  • Termination Date.

  • Employment Status.

  • Position Text.

  • Address Line 1.

  • Address Line 2.

  • Town/Suburb.

  • State

  • Postcode.

  • Home Phone.

  • Work Phone.

  • Mobile Phone.

  • Email.

  • Fund SFN.

  • TFN Indicator.

  • Fund ABN.

  • Fund USI.

  • Country.

  • Fund Name.

  • SMSF – BSB.

  • SMSF – Account Number.

  • SMSF – Account Title.

  • SMSF – Email.

  • SMSF – Electronic Address.

Contribution Amount

If this field on the report is a Contribution Amount type then you will need to map it to one of your super component types, e.g. Salary Sacrifice [SS].

Salary Amount

If this field on the report is a Salary Amount type then you will need to map it to one of the following 3 salary amount options:

  1. Annual Base Salary.

  2. Annual Total Salary.

  3. Period Super Gross.

Blank Field

You would use this where the prescribed file format from your super clearing house has an optional field where there is no matching data type in the TASS.web payroll.

Employee/Fund Data Field

This field is only applicable if you have chosen 'Employee/Fund Data' as your Data Type. Choose from the drop-down list.

Component Type(s) for this field

This field is only applicable if you have chosen 'Contribution Amount' as your Data Type. Choose one or more types from the drop-down list.

Salary Amount Options

This field is only application if you have chosen 'Salary Amount' as your Data Type.   

Select one of the following 3 salary amount options:

  1. Annual Base Salary.

  2. Annual Total Salary.

  3. Period Super Gross.

After you have completed the setup for each field click the 'Save' button and then the 'New Field' button to repeat this process for the next field.

Continue until you have mapped all the required fields for your report/TXT file.

As an example, to achieve this report layout:

the following setup would be required:

Field Number

Data Type

Employee/Fund Data Filed

1

Employee/Fund Data

Employee Code

2

Employee/Fund Data

Surname

3

Employee/Fund Data

Given Names

4

Employee/Fund Data

Date of Birth

5

Employee/Fund Data

Member Number

6

Contribution Amount

SG Contributions (compulsory) normally code [SA]

7

Contribution Amount

Employer Additional normally code [EA]

8

Contribution Amount

Salary Sacrifice normally code [SS]

9

Contribution Amount

Member Voluntary normally code [MV]

Sunsuper File Format (Pre SuperStream)

Sunsuper File Format (Pre SuperStream)

The Sunsuper Fund has mapped a TASS file format for schools where Sunsuper is their default fund.

This file format is their Pre-SuperStream format and it is valid for Remittance Files submitted up to the date where the SuperStream Date Standard is mandatory for employers.

Column Order

Field Name

1st

Clearing House Fund ID (only for registered users of Sunsuper Stream) ***

2nd

Employee ID

3rd

Member ID

4th

Surname

5th

Given Names

6th

Birth Date

7th

Gender

8th

Employer Compulsory Contributions

9th

Salary Sacrifice Contributions

10th

Member Voluntary Contributions

11th

Address 1

12th

Address 2

13th

Suburb

14th

State

15th

Postcode

16th

Tax File Number

17th

Commenced Work

18th

<blank field>

19th

Employment Status

20th

Date Terminated

To achieve the file format above the following setup would be required:

Field Number

Data Type

Employee/Fund Data Filed

1

Employee/Fund Data

Fund ID

2

Employee/Fund Data

Employee Code

3

Employee/Fund Data

Member Number

4

Employee/Fund Data

Surname

5

Employee/Fund Data

Given Names

6

Employee/Fund Data

Date of Birth

7

Employee/Fund Data

Gender

8

Contribution Amount

SG Contributions (compulsory) normally code [SA] and Employer Additional normally code [EA]

9

Contribution Amount

Salary Sacrifice normally code [SS]

10

Contribution Amount

Member Voluntary normally code [MV]

11

Employee/Fund Data

Address Line 1

12

Employee/Fund Data

Address Line 2

13

Employee/Fund Data

Town/Suburb

14

Employee/Fund Data

State

15

Employee/Fund Data

Postcode

16

Employee/Fund Data

Tax File Number

17

Employee/Fund Data

Start Date

18

Blank Field

19

Employee/Fund Data

Employment Status

20

Employee/Fund Data

Termination Date

Sunsuper File Format (SuperStream)

The Sunsuper Fund has mapped a TASS file format for schools where Sunsuper is their default fund.

This file format is their SuperStream format and it is valid for Remittance Files submitted from 1 July 2014.

Column Order

Field Name

1st

Clearing House Fund ID (only for registered users of Sunsuper Stream) ***

2nd

Employee ID

3rd

Member ID

4th

Surname

5th

Given Names

6th

Title

7th

Birth Date

8th

Gender

9th

Tax File Number

10th

Commenced Work

11th

Date Terminated

12th

Employment Status

13th

Address 1

14th

Address 2

15th

Suburb

16th

State

17th

Postcode

18th

Country

19th

Home Phone

20th

Mobile Phone

21st

Email

22nd

Tax File Number Indicator

23rd

Fund ABN

24th

Fund USI

25th

Fund Name

26th

SMSF – BSB Number

27th

SMSF – Account Number

28th

SMSF – Electronic Address

29th

Employer Compulsory Contributions

30th

Employer Additional Contributions

31st

Employee Salary Sacrifice Contributions

32nd

Employee Member Voluntary Contributions

To achieve the file format above the following setup would be required:

Field Number

Data Type

Employee/Fund Data Filed

1

Employee/Fund Data

Fund ID

2

Employee/Fund Data

Employee Code

3

Employee/Fund Data

Member Number

4

Employee/Fund Data

Surname

5

Employee/Fund Data

Given Names

6

Employee/Fund Data

Title

7

Employee/Fund Data

Date of Birth

8

Employee/Fund Data

Gender

9

Employee/Fund Data

Tax File Number

10

Employee/Fund Data

Start Date

11

Employee/Fund Data

Termination Date

12

Employee/Fund Data

Employment Status

13

Employee/Fund Data

Address Line 1

14

Employee/Fund Data

Address Line 2

15

Employee/Fund Data

Town/Suburb

16

Employee/Fund Data

State

17

Employee/Fund Data

Postcode

18

Employee/Fund Data

Country

19

Employee/Fund Data

Home Phone

20

Employee/Fund Data

Mobile Phone

21

Employee/Fund Data

Email

22

Employee/Fund Data

TFN Indicator

23

Employee/Fund Data

Fund ABN

24

Employee/Fund Data

Fund USI

25

Employee/Fund Data

Fund Name

26

Employee/Fund Data

SMSF – BSB

27

Employee/Fund Data

SMSF – Account Number

28

Employee/Fund Data

SMSF – Electronic Address

29

Contribution Amount

SG Contributions (compulsory) normally code [SA]

30

Contribution Amount

Employer Additional normally code [EA]

31

Contribution Amount

Salary Sacrifice normally code [SS]

32

Contribution Amount

Member Voluntary normally code [MV]

SuperChoice File Format

SuperChoice File Format

The SuperChoice Clearing House has mapped a TASS file format for schools using this clearinghouse.

Inquiries regarding SuperChoice should be made to Debi Phillips (debi.phillips@superchoice.com.au)

The SuperChoice file format is as follows:

Column Order

Field Name

1st

Employee Code

2nd

Member Number

3rd

Surname

4th

Given Names

5th

Title

6th

Birth Date

7th

Gender

8th

Tax File Number

9th

Address 1

10th

Address 2

11th

Town/Suburb

12th

State

13th

Postcode

14th

Country

15th

Home Phone

16th

Mobile Phone

17th

Email

18th

Fund ABN

19th

Fund USI

20th

Fund Name

21st

SMSF – BSB

22nd

SMSF – Account Number

23rd

SMSF – Email

24th

SMSF – Electronic Address

25th

Employer Compulsory Contributions

26th

Employer Additional Contributions

27th

Salary Sacrifice Contributions

28th

Member Voluntary Contributions

To achieve the file format above the following setup would be required:

Field Number

Data Type

Employee/Fund Data Filed

1

Employee/Fund Data

Employee Code

2

Employee/Fund Data

Member Number

3

Employee/Fund Data

Surname

4

Employee/Fund Data

Given Names

5

Employee/Fund Data

Title

6

Employee/Fund Data

Date of Birth

7

Employee/Fund Data

Gender

8

Employee/Fund Data

Tax File Number

9

Employee/Fund Data

Address Line 1

10

Employee/Fund Data

Address Line 2

11

Employee/Fund Data

Town/Suburb

12

Employee/Fund Data

State

13

Employee/Fund Data

Postcode

14

Employee/Fund Data

Country

15

Employee/Fund Data

Home Phone

16

Employee/Fund Data

Mobile Phone

17

Employee/Fund Data

Email

18

Employee/Fund Data

Fund ABN

19

Employee/Fund Data

Fund USI

20

Employee/Fund Data

Fund Name

21

Employee/Fund Data

SMSF – BSB

22

Employee/Fund Data

SMSF – Account Number

23

Employee/Fund Data

SMSF – Email

24

Employee/Fund Data

SMSF – Electronic Address

25

Contribution Amount

SG Contributions (compulsory) normally code [SA]

26

Contribution Amount

Employer Additional normally code [EA]

27

Contribution Amount

Salary Sacrifice normally code [SS]

28

Contribution Amount

Member Voluntary normally code [MV]

SAFF Parameters

If you intend to use a Super Alternative File Format (SAFF) as the report Remittance Type, enter your CSV File search parameters via the SAFF Parameters icon.

Fields that require further explanation

*Payment Method

Select the Superannuation Payment Method that you would like to produce the CSV file for.  Options include:

  • BPAY

  • Direct Debit

  • Direct Credit

BPay Biller Code

This field is only active and mandatory if BPAY has been defined as the ‘Payment Method’. Enter the Superannuation BPay Biller Code to be included in your CSV file. 

BPay Reference Number

This field is only active and mandatory if BPAY has been defined as the ‘Payment Method’. Enter the Superannuation BPay Reference Number to be included in your CSV file. 

Payer B.S.B Code

This is an optional field. Enter a Superannuation Payer B.S.B. code to be included in your CSV file. 

Payer Account Number

This is an optional field. Enter a Superannuation Payer Account Number to be included in your CSV file. 

Payer Account Name

This is an optional field. Enter a Superannuation Payer Account Name to be included in your CSV file. 

Component Type(s) for Contributions

Select the Superannuation Component Type(s) for Contributions to be included in your CSV file. 

These are all multi-select fields. Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key enables selection of discrete (individual) criterion.

Click the ‘Update’ button when complete.

Producing Your Remittance File/Report

General Tab

Fields that require further explanation

Remittance Type

Indicate the Remittance Type that you intend to produce.  Options include:

  • Clearing House Remittance File

  • Super Funds Contribution Report

  • Super Alternative File Format (SAFF)

Check the appropriate radio button.

Remittance Searching

Enter your 'Remittance Searching' criteria.

The 'Payroll' and 'Super Funds' allow multiple selections. Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key enables selection of discrete (individual) criterion.

In the ‘Contributions FROM’ field, select the Period End Date of the first payroll for contributions to be reported/paid. This is a compulsory field.

In the ‘Contributions TO’ field, select the Period End Date of the last payroll for contributions to be reporting/paid. This is a compulsory field.

Payment Details

These fields are only active when ‘Super Alternative File Format (SAFF)' is selected as the Remittance Type, and either BPAY, Direct Debit or Direct Credit are selected via the 'SAFF Parameters’ icon.

When BPAY is the SAFF Payment Method, enter a Payment Date.

When Direct Debit is the SAFF Payment Method, enter a Payment Reference Number.

When Direct Credit is the SAFF Payment Method, enter a Payment Date and a Payment Reference Number.

Print Tab

The 'Print' tab is used to format the report.

Fields that require further explanation

Sort By

Use the ‘Sort By’ options on the left side of the screen to sort your report by Employee Code or Surname.

Formatting Options

If you selected 'Clearing House Remittance File' on the 'General' tab, then the only 'Formatting Option' available is 'Export to TXT File'.

If you selected 'Super Funds Contribution Report' on the 'General' tab, then the 'Formatting Options' are Export to PDF, Export to Excel® or Export to Word®. Select your preferred option.

When Exporting to PDF, you can also choose to ‘Show Table Borders', use 'Alternate Row Colours’ and display the page in Portrait or Landscape orientation.

The 'Alternate Row Colours' option significantly improves the readability of the report.

If you selected 'Alternative File Format (SAFF)' on the 'General' tab, then the only 'Formatting Option' available is 'Export to CSV File'.

Tick the 'Format ABN without spaces' to remove spaces from the ABN, or untick the checkbox to format ABNs as they appear in the TASS.web database.

Report Options

Use the 'Report Options' to produce a:

  • Separate Report per Fund, or a

  • Consolidated Report.

Tick ‘Include Employee Totals’ to include total amounts in your File/Report.

Click the 'GO' button to generate your report.

If you have created a TXT file or CSV file, you should now check that it can load successfully into the software that is provided by your superannuation clearing fund.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.