Super funds file format

When uploading super fund codes in bulk to EmpowerHR, you use the options called Super Funds Data Load and Data Load of Pay Code Attached to Super Fund from the Data Take-On Initiation screen.  Here are the file formats to use. 

What files do I need to prepare?

You need to create a tab-delimited (.txt) file for each type of required data.

Information

Remember to exclude column headings from the files.

Super fund data 

Here's the format to use.  An asterisk (*) shows which data is mandatory.  

Column >
A*
BCDE
F
G

Super Fund Code
Abbreviation
Description
Fill Empl Super Fund Screen
To Period Multiplier
User Field 1
User Fund 2

Characters >

8

10

30

1

9 including decimal point

15

10







Use for SMSF phone number for interface files.

SMSF = self-managed super fund

Use for SPIN or USI for interface files.

SPIN = Super Product Identifier Number 

USI = Unique Superannuation Identifier 


Column >
H
IJKL

User Field 3
User Field 4
ESA (SMF)
User Field 5
User Field 6

Characters >

10

30

15

15

15


Organisation-specific.

Use as y/n indicator for clearing house for interface files.

n will be excluded from output files.

Organisation-specific.

Use for ABN (SMSF) for interface files.

Set to y if the Super Fund is A Defined Benefit Fund.

Used for SAFFE interface.



Attach payment code to super fund

Here's the format to use.  An asterisk (*) shows which data is mandatory.   

Column >
A*
B*CDEFG

Super Fund
Payment Code
Calc Type
Super Group
Minimum Salary
Maximum SalaryPrescribed Percentage

Characters >

8

4

3

4

12

12

12


Column >
H
IJKLM
NO

Prescribed Amount
Rounding
Decimals
User No. 1
User No. 2
User Field 1
User Field 2
Linked to Super Option

Characters >

12


4

12

12

30

30




RN = Round to nearest

RU = Round up

RD = Round down

If blank, default is RN






NL = Not linked

y = Linked to super option

n = Not linked to super option

If blank, the default is NL




Next topic

Organisational level file format



© 2023 Fusion5. All rights reserved.