Explaining file upload and data quality checks
The Workplace Profile and Workforce Management Statistics Excel templates are uploaded within their respective sections of the Portal. When an Excel file is uploaded it passes through two separate checks:
- File verification and formatting: this check ensures you are using the correct file and have not altered the formatting of rows and columns.
- The file verification check takes place instantly. If the file is rejected, this status will appear in the upload table, and you will also receive an email advising you of the file rejection.
- Data quality: this check assesses that the data provided on the Excel sheets is within expected ranges, and that all mandatory data has been provided.
- The data quality check can take up to 1 hour in peak periods. If any issues are found, this status will appear in the upload table. You will also receive an email advising you that issues have been found, and the email will contain a link to take you to your issue page to review.
Types of data quality issues
There are three types of issues that flag data anomalies: errors, warnings and notifications.
- Errors refer to identified data errors within your uploaded file. You must correct any errors before addressing any warnings or notifications.
- Please review the instructions provided in the Employer Portal, amend the data in your template accordingly, and re-upload the file.
- Warnings indicate that the data provided is unusual or unexpected. This means that you must check your data.
- If your data is correct, you must provide a reason for it being unusual. If you select a custom reason, please ensure it is clear and detailed. If a response is insufficient or unclear, we may request further clarification. We will outline any additional requirements via email. Providing thorough explanations helps avoid delays and supports timely progression of your submission.
- If your data is incorrect, please amend the data in your template, and re-upload the file.
- Notifications indicate that the data provided is unusual or unexpected. This means that you must confirm your data has been intentionally entered as it appears.
- If the data is correct, you may proceed.
- If it is incorrect, please amend the data in your template, and re-upload the file.
Note: If you confirm a notification or provide a reason for a warning, please refresh the page to update the issue list status.
Review instructions to resolve each error from your submission
Review instructions to resolve each warning from your submission
Review instructions to resolve each notification from your submission
Tips to resolve issues
Address errors first, then warnings and notifications
The Portal requires you to address all anomalies labelled ‘errors’ before you can address ‘warnings’ and 'notifications'. Use the instructions provided on the Errors page to resolve your data errors and re-upload your file.
- When all errors are resolved, the 'Select' pencil button will become active (yellow). You can then provide reasons for your warnings or confirm your notifications.
Find the data rows
All anomalies will refer to a specific row(s) and column within the Workplace Profile or Workforce Management Statistics where the issue occurs.
- To identify the specific location of the issue, please use the row references in the issue list in the Employer Portal.
Use the filter
We strongly recommend using the column filtering function in Excel to locate your data anomalies.
- For example, if you receive a warning that the number of graduates recorded in your Workplace Profile is unusually high, you can filter the graduate/apprentice column to only display employees recorded as graduates (and not those recorded as apprentices or blank). This will help you review your data more efficiently, especially if you are reporting a large number of employees.
Re-upload and lodge
Remember, once you have amended your files you will need to re-upload them to the WGEA Portal. If no further issues are identified, you will see the status of your submission change from ‘Issues found’ to ‘No issues’. You will then need to generate your reports and complete the consents and declarations to lodge your report to finalise your submission.
- If you confirm a notification or provide a reason for a warning, please refresh the page to update the issue list status(es).
Order by lowest base salary
Before submitting, check the lowest base salary in your file and ensure it is above $49,296 or, if it is below this figure, that you have a valid justification. This figure represents 12 months of full-time employment (38 hours per week) at the national minimum wage.
- Go to the base salary column (Column K for Unit Level and Column U For STP). Order the column by highlighting all the values from Row 2 and using the 'Sort and filter' tool in the 'Editing' section of Excel. Sort 'Smallest to largest'.
- If any base salaries are below $49,296, they will trigger a warning and your file will not be immediately accepted. Any base salaries for juniors below $18,140 will not be accepted. Please check that you have annualised relevant salaries correctly.