Steps to submit your employer return via spreadsheet
You can submit your worker service return to QLeave in two ways. They are:
- entering data directly into the online portal
- bulk importing a spreadsheet into the portal
This guide shows you how to submit your return by importing a spreadsheet into the portal. Click here for instructions to do it by entering data directly into the portal.
Do not make any changes to the spreadsheet format
- Do not add, remove or rearrange any columns in the spreadsheet.
- Do not add new sheets or tabs to the spreadsheet.
- Do not add additional rows to the spreadsheet (for example, AutoSum of wages).
- If you make changes to the spreadsheet format, you will receive an error message and your spreadsheet will not be accepted when you import it into the portal.
- The contributions tab is only for existing workers.
- Columns A-G in the contributions tab are pre-filled with your worker's details, including their name, QLeave registration number, gender, and date of birth. Do not make any changes to the contents of these columns. If you do, your spreadsheet will not be accepted when you import it into the portal.
New workers tab
- The new workers tab is only for new workers. Use this tab to add any new workers who joined your organisation during the quarter.
- Do not add new workers to the bottom of the contributions tab.
1. Go to the Employer Portal
2. When logging into the new portal for the first time you must reset your password.
Please note: if you're the primary contact for the organisation, you will receive an email from us when returns become available. If you'd like another contact within your organisation to have access to the portal so they can complete returns, you will need to enable their portal access. Click here for instructions.
3. Once you’ve logged in to the portal with your new password, you will see your Dashboard on the screen. Your Dashboard tab at the top gives you a snapshot of your account information and tasks including pending returns, outstanding invoices, reports and contact details.
Download the spreadsheet
1. Click the Returns tab on the left hand menu.
2. Select the blue Return number (e.g. R110080). New returns will have a return status of Open.
3. Click the Export / Import button on the top left of your Return (directly above the periodic return information). This will bring up a screen showing the steps to complete your spreadsheet return.
Please note, there is a second Export link further down the page on the right-hand side. Please do not click this link. The spreadsheet provided by this link can be used as a receipt of return but it is not the correct file for completing the return. If you use the spreadsheet provided by this link, you will receive an error when trying to import it into the portal.
4. Click the Export to Excel button on the right to download your Return as a spreadsheet.
This will download a spreadsheet with a list of all your workers.
Save this spreadsheet to your local computer.
5. Once you've saved the spreadsheet, open the file to start adding details.
Note: please don't make any changes to the format of the spreadsheet (e.g. deleting or changing the order of columns). If you change the format of the spreadsheet, the file may not be accepted when you import it into the portal.
Complete your spreadsheet
Use the first sheet (Contributions tab) to complete your Return.
Columns A - G (DO NOT update these columns)
Columns A - G are pre-filled with each of your worker's details, including their Worker ID, Title, Name, Gender and Date of Birth. Do not make any changes to the details in these columns - leave them as is.
Columns H - J (these are the only columns you need to update)
6. Enter the Gross Ordinary Wages (Column H) and Annual Rate of Pay (Column I) for each of your workers for the return period. Click here for information on ordinary wages.
To calculate the annual rate of pay, enter the worker's hourly rate of pay (including all applicable amounts outlined under ordinary wages) x 38 hours x 52 weeks. Do not enter any symbols (e.g. ‘$’) or use decimal places.
The same calculation (hourly rate x 38 hours x 52 weeks) applies to full-time, part-time and casual workers.
Please note: do not enter the total wages or annual pay amounts for all your workers at the bottom of these columns. If you add the totals, it will cause an error with your spreadsheet.
If you need to terminate a worker who has stopped working for you during the quarter, enter the date worker was terminated in Termination Date (Column J). The date entered must be within the return period.
Adding new workers to your return
If you have new workers who have started working for you this quarter, you will need to add new worker's details to the second sheet (New Workers tab).
Enter details for your new workers in all columns, including their personal and contact details, start date, work type codes (refer to the codes listed in the References tab of your spreadsheet) and their gross ordinary wages and annual rate of pay for the return period.
1. Once you've completed your spreadsheet, save it again to your computer. Go back to the portal and click the Browse button to upload your completed spreadsheet.
2. Click the Commit Import File button to complete the import and submit your spreadsheet file.
The completed data from your spreadsheet will now appear in your Return page on the portal.
3. Click Edit Return or Commit Return at the top right of your screen.
- If you need to make any changes to your return, click the Edit Return button.
- If you're ready to submit your return, click the Commit Return button to send your completed return to QLeave for processing.
4. When you click Commit Return, a Return Submission Alert will pop up on your screen.
Click OK to confirm and send your return to QLeave. If you need to go back to edit your return, click cancel.
5. Return Status: once your return has been committed the return status will change colour.
- Orange means that your return is committed and ready for payment.
- Red means that your return is submitted and needs to be reviewed by QLeave staff. You may be contacted to help resolve any issues. Once these issues are resolved, the colour of the return status will change to orange to indicate it's now ready for payment.
1. Once your Return is in orange committed status, QLeave will email the invoice for the levy payment to your organisation's primary contact.
You can also download your invoice from the dashboard, or by selecting either Returns or Transactions from the left hand menu. Once you've found your invoice, click [Print PDF] to download it.
QLeave issues levy invoices with the due date of 14 July 2021. This aligns with the legislation that requires the return to be submitted and the levy paid within 14 days after the end of the return period (1 April 2021 – 30 June 2021).
While the scheme is still new and we are developing our systems, we are offering more flexible payment terms to support employers transition to portable long service leave.
If you need an extension for submitting your return or paying the levy please contact email@example.com
2. You can pay the levy by EFT or credit card using the payment details on the invoice or via the Payment Information section in the Returns tab.
Note: it may take up to 14 days after we've received your payment for the payment status to be updated in the employer portal.