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.
|
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* | 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 > | 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 | I | J | K | L |
|---|---|---|---|---|---|
| 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* | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| Super Fund | Payment Code | Calc Type | Super Group | Minimum Salary | Maximum Salary | Prescribed Percentage | |
Characters > | 8 | 4 | 3 | 4 | 12 | 12 | 12 |
| Column > | 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 > | 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 |
© 2023 Fusion5. All rights reserved.