Skip to main content

Combine Superannuation information into one file

Can I use one file layout for multiple Super funds and append the file in Super Processing

Superannuation Funds require information detailing payments for their members. The Append File checkbox is used to include details for two or more superannuation funds to the same Clearing House or Superannuation Fund Administrator.

SuperStream, a package of measures designed by the Australian Government to improve the efficiency of the superannuation system, imposes a new standard in superannuation reporting. As the data standards require you to forward superannuation remittances electronically, you need to set up a File Layout and attach it to your Funds.

If you already have File Layouts set up, contact your Superannuation Funds or Clearing House for advice on their file specifications (i.e., what fields are required).

To combine information for Superannuation into one file, ensure that the funds you wish to append use the same File Layout and that the path and file name is correc:.

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

  2. Edit the layout and click the File Detail tab.

  3. Check the Name of Output File, Extention of Output file and Path of Output File.

  4. Ensure the file layout is attached to all relevant Superannuation Funds.

  5. Go to Payroll, Maintenance, Superannuation, Fund.

  6. Click on the File Layout tab and ensure the correct File Layout has been selected.

Files are generated through Superannuation Processing. This collates superannuation values that haven't been processed, for Period End Dates up to the Process To date, where End of Pay has been completed. Before starting this process, ensure that you back up your data and that you have deleted or renamed any previous superannuation files.

To generate a superannuation file:

  1. Go to Payroll, Transactions, End of Period, Superannuation Processing.

  2. From Notification Method, select File.

  3. Use Fund to select the Funds to include.

  4. Select Payroll Company, Location and Pay Frequency or leave as <All>.

  5. Enter the Process to date.

  6. Tick Pay to Fund if you are ready to pay the outstanding super. This function will mark the Super as processed and they won't appear as Contributions Due if you run or preview Super Processing again.

  7. Tick Append Files to produce one file per file path and name.

  8. Select the Contribution Start and Contribution End dates and choose the Number of Periods that are included in this process.

  9. Enter a Unique Reference. This links the data sent in the Superannuation File to the contribution payment. For more information about the format and requirements for the Payment Reference number, refer to the ATO website, www.ato.gov.au.

  10. Select Display Options and Order.

  11. Click File.

After the first Fund has been processed, you will receive a message asking if you wish to append to the existing file. Select Yes or Yes to All. When Yes is selected, all Funds that have the same file name will be appended to the specified file.

If the previous file that was sent to the Super Fund for processing (i.e. last month’s file or last quarter’s file) still exists in the specified directory, selecting Yes at this prompt will append your current superannuation Fund details to a previously processed file.

If No is selected, processing for Funds with the same file name will stop.

The existing file should be manually removed or renamed from the specified location so that a new file can be created before processing can continue. If the Append files option is not ticked and the file exists, you will be prompted to overwrite the file.

Did this answer your question?