What information do you require for me to use and upload my payroll file to SCH Online?

 Back to Help Centre

Data Requirements

If you are already uploading a payroll file for your default fund employees and now wish to make a contribution for employees that have chosen a APRA Regulated Super Fund, you'll first need to configure your payroll system to add additional columns for member ID, Fund Product Name, Fund ABN and Fund USI. When uploading your file, the system will create new records for each of your employees and linked the record to the fund based on the data you've provided. You won't need to add APRA Regulated Super Funds in the system as we regularly maintain and update this list.

For payments to SMSF you will need to add details to the columns for member ID, Fund Product Name and Fund ABN only.

Check out the sample upload file factsheetOpens in new window which highlights the mandatory fields and formatting required.

Finding Fund ABN or SPIN ID:

You can find this information three ways:

1. Within your online Employer account, from the homepage, select Employee Management and in the drop down menu select Add Employee. Click “Another Fund” and a search funds box will appear.

Screen shot of instructionsOpens in new window

Opens in new window

2. Search using the below links:

3. Search on the following websites:

Fund USI: https://superfundlookup.gov.au/Tools/DownloadUsiList​Opens in new window
Fund ABN: https://superfundlookup.gov.au/Opens in new window

Formatting Requirements

The file needs to be in one of the following formats: TXT, CSV, XLS and XLSX (CSV preferred) and meet certain formatting requirements including:

  • each field must have its own column
  • a character can separate date details, as long as it’s the same for the entire column (eg slash / comma, or fullstop)
  • must be one line per member (ie all information for a member must be contained on the one line / row)
  • all blank rows (with no information) and ‘subtotal’ or ‘total’ rows must be removed from the file
  • if editing a file output from your payroll system, make sure these corrections are also made in your payroll system so next months contribution reflects accurately
  • make sure the file format is consistent each month otherwise you will need to remap it

Check out the sample upload file factsheetOpens in new window which highlights the mandatory fields and formatting required.

Get Started!