|
Electronic File for Super Fund |
  
|
|
Electronic File for Super Fund |
|
Each time you pay a superannuation fund for a particular period a comma separated file (.csv) file is created in the parent data folder for that company. Check with your superannuation fund to see if this format is compatible with their system.
The name of the super file is based on the year, month, period ending and fund number.
eg: 06053101.csv would be the super file for the year 2006 month of May, period ending 31st of that month for fund number 1.
This is a sample of the created file.
q
Below is a table which details what information each column contains.
Column Order
1st |
A |
Fund ID |
2nd |
B |
Employee ID |
3rd |
C |
Member ID |
4th |
D |
Surname |
5th |
E |
Given Names |
6th |
F |
Birth Date |
7th |
G |
Gender |
8th |
H |
Total Award SG Contributions |
9th |
I |
Total Non Award Contributions (before tax) |
10th |
J |
Total Member Voluntary Contributions (after tax) |
11th |
K |
Address 1 |
12th |
L |
Address 2 |
13th |
M |
Suburb |
14th |
N |
State |
15th |
O |
Postcode |
16th |
P |
Tax File Number * |
17th |
Q |
Commenced Work |
18th |
R |
Salary |
19th |
S |
Employment Status |
20th |
T |
Date Terminated |
* NB If you require the Tax File Number to export to the Electronic File for Super Fund. You must activate the Electronic File for TFN in the Company file, and in the Employee Information, tick 'YES' to 'Do you authorise your payer to give your TFN to the trustee of your superannuation fund?'.