PR - Super Remittance File/Report

Overview

The ‘Super Remittance File/Report’ program can be used to:

Set up the Super File/Report Format layout.
Map Employee Genders for the Super File/Report.
Generate a superannuation remittance report.
Generate a TXT file to submit to a superannuation clearinghouse.
Generate a superannuation CSV alternative file format.

This program can be accessed by navigating to TASS.web Payroll HRM > Payroll > Listings & Reports.

Click here for an Administrator Note.

User Security Permissions

Access to this tab requires the ‘Super Remittance File/Report’ security point in the ‘Payroll’ section of TASS.web System Admin > Users > User Maintenance or TASS.web System Admin > Users > Security Role Permissions.

Define Your Super File/Report Format

Before you can use this report, you must set up your file/report format. It is a one-time user-definable setup that can be altered later if needed.

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 in the ‘Employee / Fund Data Field’ field below. 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] in the ‘Component Type(s) for this Contribution Amount’ field below.
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 in the ‘Salary Amount Options’ field below: Annual Base Salary. Annual Total Salary. 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 Contribution Amount

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 applicable if you have chosen 'Salary Amount' as your Data Type.

Select one of the following 3 salary amount options:

Annual Base Salary.
Annual Total Salary.
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.

Example

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)

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

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]

Map Genders

Use the 'Map Genders' icon or button 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:

Female might map to gender code 'F'.
Male might map to gender code 'M'.
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 TASS.web Community > Setup Information.

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) criteria.

Click the ‘Save’ or ‘Update’ button when complete.

Producing Your Superannuation Remittance File/Report

General Tab

Remittance Type
Clearing House Remittance File Super Funds Contribution Report Super Alternative File Format (SAFF)	Select the appropriate radio button to indicate the Remittance Type that you intend to produce. The ‘Clearing House Remittance File’ option uses the file format defined by the ‘Define Format’ icon. The ‘Super Fund s Contribution Report’ option uses the file format defined by the ‘Define Format’ icon, and The ‘Super Alternative File Format (SAFF)’ option uses the file format defined by the ‘SAFF Parameters’ icon.
Remittance Searching
Payroll	Use this field to select Payrolls as your 'Remittance Searching' criteria. This is a multi-select field. Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key enables selection of discrete (individual) criteria.
Super Funds	Use this field to select Superannuation Funds as your 'Remittance Searching' criteria. This is a multi-select field. Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key enables selection of discrete (individual) criteria.
* Contributions FROM	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.
* Contributions TO	In the ‘Contributions TO’ field, select the Period End Date of the last payroll for contributions to be reported/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 is 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.

After entering these details, click the ‘Print’ tab.

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 report's readability. 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. Select the ‘Include Employee Totals’ checkbox 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 then check that it can load successfully into the software that is provided by your superannuation clearing fund.