Skip to main content

Super CSV file is blank

When I preview the report for superannuation, I can see the figures, but my CSV file is blank or values are missing from the file

There are several reasons why the Super CSV file might be blank. They include:

  • Overwriting the file rather than appending.

  • Employer or Employee Contribution are missing from the File Layout.

Overwriting the file

If you produce one file that contains all Super Funds that you submit to a Clearing House, you need to tick Append Files in Superannuation Processing when you produce the file. Ticking this will add each fund to the file.

If you don't tick this field, each fund will overwrite the previous fund. Resulting in either a file that contains employees for the last fund or a blank file if there are no employees attached to the last fund.

Contribution missing from the File

Your File Layout will be set up to include either:

  • Employer Primary, Employer Additional, Employee PreTax and Employee PostTax.

  • Or, Employer MTD and Employee MTD.

When you add the fields to your File Layout, list the relevant Employer or Employee Contribution codes in the Format column. E.g. for field Employee MTD, list DB01,DB02 in Format, then the field will include Employee Contributions for Deductions DB01 and DB02 only.

If you use the first list (Employer Primary, etc.), you can enter ALL in the Format column rather than listing the codes. As these fields already allocate contributions based on:

  • Primary Contribution being ticked for Employer Contributions. For example, Employer Primary will include all Employer Contributions that have Primary ticked on the employee record.

  • Before or After tax being selected for Employee Contributions.

If you have created new Contribution codes and attached them to your employees, ensure your new code is included in your super file. To do this:

  1. Go to Payroll, Maintenance, Superannuation, File Layout.

  2. Edit the File Layout.

  3. Select the Detail Tab.

  4. In the Destination List, locate the relevant field from the list above, e.g. Employer Primary or Employer MTD.

  5. If codes are listed in the Format column, add a comma to the end, followed by the new code. Repeat for all new codes.

    • If the field is Employer Primary, Employer Additional, Employee PreTax or Employee PostTax you can use ALL instead. This means that you won't have to update the file layout when new codes are added in the furture.

  6. Click OK to save the change.

Did this answer your question?