Worker turnover rate in the administrative and support services industry in New Zealand

By sex, 1999 Q4–2023 Q4, % of jobs

The following information applies to all values in the table. Industry: N, Measure: Workers turnover rate
Quarter	Sex	% of total jobs
1999 Q4	Female	24.9%
1999 Q4	Male	27%
2000 Q1	Female	27.7%
2000 Q1	Male	30.1%
2000 Q2	Female	28.2%
2000 Q2	Male	29.5%
2000 Q3	Female	26.5%
2000 Q3	Male	28.7%
2000 Q4	Female	27.5%
2000 Q4	Male	30.1%
2001 Q1	Female	28.5%
2001 Q1	Male	31%
2001 Q2	Female	29%
2001 Q2	Male	30.4%
2001 Q3	Female	28.5%
2001 Q3	Male	30%
2001 Q4	Female	25%
2001 Q4	Male	27.9%
2002 Q1	Female	27.5%
2002 Q1	Male	29.9%
2002 Q2	Female	30.1%
2002 Q2	Male	33.1%
2002 Q3	Female	27.4%
2002 Q3	Male	30.4%
2002 Q4	Female	25.2%
2002 Q4	Male	29.1%
2003 Q1	Female	24.9%
2003 Q1	Male	27.8%
2003 Q2	Female	33.4%
2003 Q2	Male	34.2%
2003 Q3	Female	27.3%
2003 Q3	Male	30.9%
2003 Q4	Female	26.8%
2003 Q4	Male	31.3%
2004 Q1	Female	27.3%
2004 Q1	Male	30.2%
2004 Q2	Female	32.4%
2004 Q2	Male	34.5%
2004 Q3	Female	29.1%
2004 Q3	Male	31.8%
2004 Q4	Female	27.5%
2004 Q4	Male	30.9%
2005 Q1	Female	28.1%
2005 Q1	Male	31.2%
2005 Q2	Female	35.7%
2005 Q2	Male	37.9%
2005 Q3	Female	30.7%
2005 Q3	Male	33.5%
2005 Q4	Female	29%
2005 Q4	Male	32.9%
2006 Q1	Female	28.2%
2006 Q1	Male	31.6%
2006 Q2	Female	33.7%
2006 Q2	Male	37.2%
2006 Q3	Female	29.5%
2006 Q3	Male	33.6%
2006 Q4	Female	29.5%
2006 Q4	Male	33.8%
2007 Q1	Female	29.2%
2007 Q1	Male	32.4%
2007 Q2	Female	33.6%
2007 Q2	Male	37.4%
2007 Q3	Female	30.4%
2007 Q3	Male	35.5%
2007 Q4	Female	29%
2007 Q4	Male	34.4%
2008 Q1	Female	29.7%
2008 Q1	Male	33.7%
2008 Q2	Female	34.5%
2008 Q2	Male	38.6%
2008 Q3	Female	29.5%
2008 Q3	Male	34.1%
2008 Q4	Female	27.4%
2008 Q4	Male	32.1%
2009 Q1	Female	29.7%
2009 Q1	Male	32.2%
2009 Q2	Female	31.6%
2009 Q2	Male	34.7%
2009 Q3	Female	26%
2009 Q3	Male	30.5%
2009 Q4	Female	23.7%
2009 Q4	Male	28.5%
2010 Q1	Female	24.9%
2010 Q1	Male	29%
2010 Q2	Female	35%
2010 Q2	Male	39.4%
2010 Q3	Female	28.5%
2010 Q3	Male	31.5%
2010 Q4	Female	25.2%
2010 Q4	Male	30.7%
2011 Q1	Female	27.2%
2011 Q1	Male	31%
2011 Q2	Female	31.2%
2011 Q2	Male	36%
2011 Q3	Female	27.7%
2011 Q3	Male	31.7%
2011 Q4	Female	25%
2011 Q4	Male	31%
2012 Q1	Female	28.7%
2012 Q1	Male	33.1%
2012 Q2	Female	29.9%
2012 Q2	Male	35.5%
2012 Q3	Female	27.2%
2012 Q3	Male	31.6%
2012 Q4	Female	25.3%
2012 Q4	Male	31.8%
2013 Q1	Female	24.4%
2013 Q1	Male	30.2%
2013 Q2	Female	30.5%
2013 Q2	Male	35.6%
2013 Q3	Female	27.6%
2013 Q3	Male	32%
2013 Q4	Female	25.5%
2013 Q4	Male	31.8%
2014 Q1	Female	26.7%
2014 Q1	Male	31.4%
2014 Q2	Female	29.2%
2014 Q2	Male	34.4%
2014 Q3	Female	27.2%
2014 Q3	Male	32.1%
2014 Q4	Female	24.9%
2014 Q4	Male	31.4%
2015 Q1	Female	25.8%
2015 Q1	Male	31.1%
2015 Q2	Female	30.9%
2015 Q2	Male	36.9%
2015 Q3	Female	27.2%
2015 Q3	Male	32.1%
2015 Q4	Female	25.3%
2015 Q4	Male	32%
2016 Q1	Female	25.6%
2016 Q1	Male	31.4%
2016 Q2	Female	30.1%
2016 Q2	Male	35.8%
2016 Q3	Female	28.1%
2016 Q3	Male	33.1%
2016 Q4	Female	27.3%
2016 Q4	Male	34.4%
2017 Q1	Female	27.5%
2017 Q1	Male	32.3%
2017 Q2	Female	32.2%
2017 Q2	Male	37.1%
2017 Q3	Female	28.8%
2017 Q3	Male	33.7%
2017 Q4	Female	27.2%
2017 Q4	Male	33.1%
2018 Q1	Female	32.1%
2018 Q1	Male	37.3%
2018 Q2	Female	33.9%
2018 Q2	Male	38.1%
2018 Q3	Female	31.1%
2018 Q3	Male	34.2%
2018 Q4	Female	28.1%
2018 Q4	Male	33.5%
2019 Q1	Female	29.7%
2019 Q1	Male	33.6%
2019 Q2	Female	31.5%
2019 Q2	Male	35.9%
2019 Q3	Female	29.8%
2019 Q3	Male	34.1%
2019 Q4	Female	28.3%
2019 Q4	Male	33.3%
2020 Q1	Female	28.7%
2020 Q1	Male	31.6%
2020 Q2	Female	28.8%
2020 Q2	Male	30.1%
2020 Q3	Female	26.3%
2020 Q3	Male	28.6%
2020 Q4	Female	27.9%
2020 Q4	Male	31.2%
2021 Q1	Female	26%
2021 Q1	Male	29.9%
2021 Q2	Female	35.3%
2021 Q2	Male	37.4%
2021 Q3	Female	30.5%
2021 Q3	Male	32.2%
2021 Q4	Female	26.8%
2021 Q4	Male	29.2%
2022 Q1	Female	29.3%
2022 Q1	Male	30.4%
2022 Q2	Female	32.7%
2022 Q2	Male	32.4%
2022 Q3	Female	31.4%
2022 Q3	Male	31.6%
2022 Q4	Female	29.5%
2022 Q4	Male	30.6%
2023 Q1	Female	29.4%
2023 Q1	Male	31.1%
2023 Q2	Female	33.6%
2023 Q2	Male	37.1%
2023 Q3	Female	28.4%
2023 Q3	Male	29.8%
2023 Q4	Female	25.3%
2023 Q4	Male	27.8%

Definitions

Job: a unique employer-employee pair present on an EMS in the reference quarter.
Full-quarter jobs: jobs that exist continuously over the reference quarter.
Total filled jobs: The number of jobs (defined as an employer-employee match) on the 15th of the middle month of the reference quarter. Does not distinguish between part-time and full-time jobs.
Accessions: The number of employees who have joined employers since the previous reference date.
Separations: The number of employees who have left employers since the previous reference date.
Worker turnover rate: The ratio of the average of the total accessions and separations to the average of the total jobs in the reference quarter (t) and the previous quarter (t-1), as represented in the formula:
[ (accessions + separations)/2 ] / [ (jobs(t) + jobs(t-1))/2 ].
Job creation: The number of jobs created, since the previous reference date, when businesses expand or start up. For example, a business employing 100 workers with 10 accessions and five separations has job creation of five.
Job destruction: The number of jobs lost, since the previous reference date, when businesses contract or shut down. For example, a business employing 100 workers with five accessions and 15 separations has job destruction of 10.
Job turnover rate: The ratio of the average of the total creations and destructions to the average of the total jobs in the reference quarter (t) and the previous quarter (t-1), as represented in the formula:
[ (creation + destruction)/2 ] / [ (jobs(t) + jobs(t-1))/2 ].
Mean/median earnings: Mean (average) or median earnings of all full-quarter jobs.
Mean/median earnings for continuing jobs: Mean (average) or median earnings for jobs that were full-quarter in the reference quarter and previous quarters.
Mean/median earnings for new hires: Mean (average) or median earnings for jobs that were full-quarter in the reference quarter and began sometime in the previous quarter, but were not present in the four previous quarters.
Mean/median earnings ratio: The ratio of the mean or median earnings for new hires to the mean or median earnings for continuing jobs.
Total earnings: The sum of all earnings paid in the reference quarter, including employees with invalid IRD identifiers and individuals under 15 years of age.

For more information

http://www.stats.govt.nz/browse_for_stats/income-and-work/employment_and_unemployment/LEED-quarterly-tech-notes.aspx
http://nzdotstat.stats.govt.nz/OECDStat_Metadata/ShowMetadata.ashx?Dataset=TABLECODE7013&Lang=en

Inclusions

LEED covers all individuals (‘employees’) who receive income from which tax is deducted at source. These payments are made by organisations that are registered with Inland Revenue. Note that the data from LEED includes social assistance payments, such as paid parental leave, student allowances, benefits, pensions, and Accident Compensation Corporation payments, although these are excluded from the quarterly measures.
The fundamental basis of the LEED quarterly measures is ‘jobs’.
For inclusion in the LEED quarterly statistics, the job must:
- relate to a person 15 years of age and over
- have PAYE tax deducted at source
- be in relation to ‘paid employment’ rather than a social assistance payment
- have a valid IRD identifier.
An exception is the total earnings measure, which includes all jobs with PAYE tax deducted at source (irrespective of age and IRD identifier) apart from those relating to social assistance payments.

All the earnings measures represent quarterly earnings inclusive of tax. They include payments reported as lump sums to Inland Revenue.

Data provided by

Stats NZ

Dataset name

Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) and sex December 2023 quarter

Webpage:

https://explore.data.stats.govt.nz/vis?tm=by%20industry%20%28based%20on%20ANZSIC06%29%20and%20sex&pg=0&snb=4&df[ds]=ds-nsiws-disseminate&df[id]=LEED_Q2W_007&df[ag]=STATSNZ&df[vs]=1.0

How to find the data

Data is displayed at URL provided. To create this dataset, click on download and “Filtered data in tabular text (CSV)”.
Industries were selected only at the lowest node to prevent the Aotearoa Data Explorer from generating duplicate records.

Import & extraction details

File as imported: Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) and sex December 2023 quarter

From the dataset Linked Employer-Employee Dataset: LEED measures by industry (based on ANZSIC06) and sex December 2023 quarter, this data was extracted:

Rows: 2-66,292
Column: 13
Provided: 66,291 data points

This data forms the table Jobs - All LEED measures by industry and sex 1999 Q2–2023 Q4.

Dataset originally released on:

February 06, 2025

About this dataset

The LEED dataset is created by linking a longitudinal employer series from the Stats NZ Business Register to a longitudinal series of EMS payroll data from Inland Revenue.

Purpose of collection

Official quarterly statistics produced from LEED measure labour market dynamics at various levels – including industry, region, territorial authority, firm size, sector, sex, and age – providing an insight into the operation of New Zealand's labour market. Stats NZ releases other official labour market statistics that show changes in employment at an aggregate level. Statistics from LEED, such as job and worker flows, help to explain what causes these aggregate movements and are therefore useful for explaining changes in the labour market.

Worker turnover rate in the administrative and support services industry in New Zealand

By sex, 1999 Q4–2023 Q4, % of jobs

About this data

Related Content