---
title: "Super funds file format"
id: "super-funds-file-format"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/super-funds-file-format"
updated: 2026-10-19T00:52:50Z
---

# 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](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | 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 &gt;** | **A\*** | **B** | **C** | **D** | **E** | **F** | **G** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Super Fund Code | Abbreviation | Description | Fill Empl Super Fund Screen | To Period Multiplier | User Field 1 | User Fund 2 |
| **Characters &gt;** | 8 | 10 | 30 | 1 | 9 including decimal point | 15 | 10 |
|  |  |  |  |  |  | Use for SMSF phone number for interface files.<br>SMSF = self-managed super fund | Use for SPIN or USI for interface files.SPIN = Super Product Identifier NumberUSI = Unique Superannuation Identifier |

| **Column &gt;** | **H** | **I** | **J** | **K** | **L** |
| --- | --- | --- | --- | --- | --- |
|  | User Field 3 | User Field 4 | ESA (SMF) | User Field 5 | User Field 6 |
| **Characters &gt;** | 10 | 30 | 15 | 15 | 15 |
|  | Organisation-specific.<br><br>Use as **y**/**n** indicator for clearing house for interface files.<br><br>**n** will be excluded from output files. | Organisation-specific.<br>Use for ABN (SMSF) for interface files. |  | Set to **y** if the Super Fund is A Defined Benefit Fund.<br><br>Used for SAFFE interface. |  |

### Attach payment code to super fund

Here's the format to use. An asterisk (**\***) shows which data is mandatory.

| **Column &gt;** | **A\*** | **B\*** | **C** | **D** | **E** | **F** | **G** |
| --- | --- | --- | --- | --- | --- | --- | --- |
|  | Super Fund | Payment Code | Calc Type | Super Group | Minimum Salary | Maximum Salary | Prescribed Percentage |
| **Characters &gt;** | 8 | 4 | 3 | 4 | 12 | 12 | 12 |

| **Column &gt;** | **H** | **I** | **J** | **K** | **L** | **M** | **N** | **O** |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  | Prescribed Amount | Rounding | Decimals | User No. 1 | User No. 2 | User Field 1 | User Field 2 | Linked to Super Option |
| **Characters &gt;** | 12 |  | 4 | 12 | 12 | 30 | 30 |  |
|  |  | RN = Round to nearest<br><br>RU = Round up<br><br>RD = Round down<br><br>If blank, default is RN |  |  |  |  |  | NL = Not linked<br><br>y = Linked to super option<br><br>n = Not linked to super option<br><br>If blank, the default is NL |

| Next topic<br><br>[Organisational level file format](/articles/ehr-user-guide/organisational-level-file-format) |
| --- |

© 2023 Fusion5. All rights reserved.