Superannuation Information Imported from a Spreadsheet
After you make payments to the third-party administrators of the superannuation funds to which you are contributing, you must record information about those payments. You can enter payment information for individual payments, or you can import the payment information into the system from a spreadsheet.
Before you can import payment information from a spreadsheet, you must create a spreadsheet that contains all of the necessary information in a format that is compatible with the software. To ensure that the information in the spreadsheet is in an acceptable format, you must first enter a superannuation payment record individually. You then export this record to create the spreadsheet.
After you create the spreadsheet, you can enter information about superannuation payments directly into the spreadsheet. You can then import the data from the spreadsheet into the software.
After you have imported the data into the software, it is stored in the Superannuation Payment table. You can then process the employee through a payroll cycle. When you print the employee's payment advice slip, the system includes all of the records in the Superannuation Payment table that have not already been printed on the payment advice. Printing superannuation information on the employee's advice slip satisfies the ATO's reporting requirements.
Before you can create a spreadsheet, you must add a superannuation payment record. This record should be a valid payment record. If you enter an invalid record that you will use solely for the purposes of creating the spreadsheet, delete the record after you create the spreadsheet.