On this page:
What you will need
Before you begin, you will need:
Information about all eligible workers who have worked for you during the quarter, including:
- the hours they have worked
- the ordinary pay they received during the quarter
- any long service leave they have taken under another arrangement
- details of any Worker terminated during the quarter
- a copy of the bulk upload spreadsheet for the current quarter downloaded directly from your employer portal.
Instructions
-
Login to the employer portal using your Employer ID, registered email address and password.
-
Once in the portal, select the Returns tab from the menu on the left-hand side.
Click on the blue Return ID number.
In the new page, click on the Export/Import button.
This will take you the Export/Import page. You can take the opportunity to read the steps prior to exporting the spreadsheet.
When you’re ready, click the blue Export to Excel button to begin the download.
-
Open the spreadsheet from your downloads (or equivalent) folder.
Column Mandatory Description Member ID No For your first return, leave this column blank as Member IDs will only be assigned to your workers once your first return is submitted. When a return spreadsheet is uploaded to the portal without Member IDs, the portal will automatically assign a number to each worker.
For future returns, this column will be pre-populated with your workers’ Member IDs.
Duplication of Workers will occur if existing members are added to the spreadsheet without their membership numbers.
Payroll ID No This is where you can record your organisation’s payroll reference for a worker. Salutation No If completing this section, you must enter the appropriate code (see below). First Name Yes Enter your worker's first name. Middle Names No Surname Yes Enter your worker's surname.
Gender Yes Enter the appropriate code (see below).
Date of birth Yes Must be entered in dd/mm/yyyy format. Employment type Yes Enter the appropriate code (see below).
Work type Yes Enter the appropriate code (see below).
Worker type Yes Enter the appropriate code (see below).
Start date Yes The date the worker became eligible for the scheme within your business.
The start date must be greater than or equal to 1 July 2019 and must be entered in dd/mm/yyyy format.
Hours Yes The hours worked for each worker for the period. Up to 4 decimal places.
Period pay Yes The ordinary pay received by the worker for the period. Up to 2 decimal places.
Termination date No The date the worker ceased eligibility for the scheme within your business. The termination date must have occurred during the return period and be entered in dd/mm/yyyy format.
Termination reason No Enter the appropriate code (see below)
Comment No Any additional comments regarding the worker, up to 1,024 characters.
Mobile Preferred Insert ' (apostrophe) before a mobile or phone number to retain leading zeros.
Phone No Insert ' (apostrophe) before a mobile or phone number to retain leading zeros.
Email Preferred Address Line 1 For new workers only. In future returns, worker details cannot be updated using the export/import process. You will need to contact the Authority directly to make request a change.
Address Line 2
No Address Line 3
No Suburb Yes For new workers only.
State Yes For new workers only.
Postcode Yes For new workers only.
-
Log back into the employer portal and navigate to the Export/Import page.
Click on the blue Browse button to locate and upload your completed and saved spreadsheet.
You may receive notification of validation issues.
When a spreadsheet is uploaded to the portal, the system automatically validates the data it contains. Any issues will be displayed the row number, Member ID and the validation issue to be resolved.
If you receive a validation issue notice, you will need to make the required changes in the spreadsheet and re-upload it.
Below is an example of a common validation issue; a space after the word ‘Miss’. In this case, you can delete the space and save the file.
Follow the instructions above to re-upload the amended spreadsheet.
Once all validation issues have been resolved click on the green Commit Changes button to upload data into Portal. Ensure there are no duplicated workers prior to committing changes.
Click OK on the pop-up window to proceed.
If you discover errors within the data you can click cancel, amend the data in the spreadsheet and then re-upload the amended spreadsheet.
Click on the green Commit Return button.
Once you have committed changes you cannot re-upload another spreadsheet as you will get duplicated workers.
If you need to make additional changes to hours and pay, you must re-export the spreadsheet so that it has valid Member IDs for your worker.
If any of your workers has taken long service leave (LSL) during the period, you will need to record it by ticking the LSL Taken box next to their name.
Click the green Save & Close button to complete.
Click Commit Return or Edit Return as required.
Click OK to confirm and submit your return or Cancel to continue to edit your return.
The submitted return may require review by the Authority. If this occurs, then a Pending Review sign will appear and the submitted status will be red. The status will remain red until the review is completed.
On completion of the review the status will change to orange and read 'Committed' meaning that it is ready for payment.
When payment has been receipted, the status will turn green.
-
Once a return has been committed, you will see your invoice in the 'Financial Details' section of the page.
From here you can print your invoice and make payment.
Spreadsheet codes
-
Enter one of the below options, exactly as written:
- Mr
- Mrs
- Miss
- Dr
- Ms
- Prof
-
Employment type Spreadsheet code Self-employed Self Full-time Full Part-time Part Casual Cas -
Community services
Work type Spreadsheet code Administration and managerial CASM Crisis counselling CSCC Community development and support
CSCD Community and home care CSCH Drug and alcohol services CSDA Disability services (non-NDIS) CSDS Early childhood services CSEC Employment services CSES Financial and material assistance CSFM Family support services CSFS Family violence prevention and response CSFV Housing and homelessness CSHH Community legal services CSLS Migrant and refugee support services CSMR NDIS welfare services CSNDIS Neighbourhood houses CSNH Other community services CSO Personal and support services CSPS Contract cleaning
Work type Spreadsheet code Carpet cleaning CC Cleaner, commercial areas CCA Cleaner, mixed areas CMA Cleaner, other CO Cleaner, public areas CPA Cleaner, shopping centres CCS Cleaning and sanitisation of food processing area CFP Graffiti removalist CGR High-pressure cleaning CHP Housekeeper CH Swimming pool cleaning CSP Window and gutter cleaning CWG Security
Work type Spreadsheet code Security adviser SA Bodyguard SB Crowd controller SCC Security equipment installer or repairer SEIR Guarding property SGC Investigator SI Monitoring centre operator SMC Security, operator SO Security, other SO Private security trainer ST -
Worker type Spreadsheet code Worker WORK Apprentice APPR Contractor (self-employed) CONT Working director WDIR -
Termination reason Spreadsheet code Termination TERM Resignation RES Retrenchment RTRNCH Project completed PC Ill-health/incapacity ILL Retirement RET Death DTH
Reviewed 26 October 2021