Stats NZ - Quarterly Employment Survey (QES)

The Quarterly Employment Survey, also known as the QES Report or the NZ Stats Report, is a set of data that NZ employers are required to send to Stats NZ every quarter as per the NZ Statistics Act 1975 (http://www.legislation.govt.nz/act/public/1975/0001/latest/DLM430705.html?src=qs).

Employers are randomly selected to participate but, once they have been selected, they are expected to continue reporting quarterly thereafter. Penalties apply for supplying false data and/or no data.

Information Stats NZ require for the QES report is located here: https://www.stats.govt.nz/help-with-surveys/list-of-stats-nz-surveys/about-the-quarterly-employment-survey/.

Unfortunately, Stats NZ only provide a direct data entry web form for employers to complete. There’s no data transfer service similar to IRD/ATO’s gateway service.

The current version of the QES reporting requirements have been in effect since 2021.

PayGlobal can now produce a data extract that provides data for the Stats NZ Quarterly Employment Survey (QES).

Initial Setup

To run a data extract, PayGlobal first requires a root folder path to be specified. This is catered for by a new field called Data extract root folder within Company Settings (go to: Administration > Modify Company Settings > General > Settings > Data Extracts tab):

Please note, the path entered by our Online customers needs to start with \\tsclient\, followed by the Drive letter, then the folders required – ie. \\tsclient\DriveLetter\FolderName\...\FolderName\

For example, if you are wanting to save the data extract to the “temp” folder on your C: Drive, you would enter: \\tsclient\c\temp\ as the Data Extract Root Folder.

Access to the Data Extracts is controlled via the user’s Security profile. To ensure you control which users should have access, access to the run commands within the Data Extracts folder will be switched off by default.

Users requiring access will need to be given Edit access to the Data Extracts folder, along with the functions inside it:

Before you run the QES data extract, you will need to configure your allowance settings. To do this go to: Reports > Data Extracts > Configure Data Extracts or select from the Global List shortcut (Alt + G). When the form opens you will see the QES Allowance Settings tab:

For each allowance, you will need to specify whether it is included in the Hours and/or included in the Amount, and which Payroll Grouping it should be included in.

The report will only include employees whose Employee Status (Employee Details > Human Resources > Employee Status) has a Stat Report Type of 1. Full-time or 2. Part-time.

1. Full-time is classed as those employees working 30 hours or more per week.

2. Part-time is classed as those employees working less than 30 hours per week.

In the below example, employees with an Employee Status of CA would not be included in the report:

For each Employee Status, you will need to ensure the correct Stat Report Type is selected.

For more information on configuring the Data Extract Settings, see Help Topic 10913

Running the Report

To run the QES Report, you will need to:

Navigate to Reports > Data Extracts > Stats NZ - Quarterly Employment Survey
Select the Reporting Date
Enter the date from which to base the data extract on.
You can select any date, but the valid dates for the Quarterly Employment Survey are: 20th Feb, 20th May, 20th Aug and 20th Nov each year.
Select the appropriate Geographical Location
You need to tell PayGlobal which of the following entities represents the Geographical location each employee is based at for the purposes of the Quarterly Employment Survey.
You can select from
- Location
- Department
- Dims 1 - 4 (Dims will show the Description your database has applied to the Dim # table as set in Company Settings - DIMs)
- Internal Company
If you only want to run the report for a specific Internal Company, click on the Internal Companies tab and select the appropriate Internal Company (or Companies).
If you only want to run the report for a specific Period Code, click on the Pay Periods tab and select the appropriate Period Code (or Codes).
Click Generate Data Extract

After following the above process, a CSV file will be generated in the folder specified in the Initial Setup.

Example of the CSV file:

For more information regarding the QES Report, see Help Topic 10899