Weekly Payroll Jobs and Wages in Australia methodology

These weekly estimates are part of a suite of new products the ABS are releasing to provide up-to-date information on the impact of the COVID-19 coronavirus on people and businesses in Australia. This release provides indicative information on the economic impact of the COVID-19 coronovirus on employees, including changes in paid employee jobs, changes in total wages paid, and changes in average weekly wages per job.

These weekly estimates are derived from Single Touch Payroll (STP) data, which is provided to the Australian Taxation Office (ATO) by businesses with STP-enabled payroll or accounting software each time the business runs its payroll. STP data includes both business and job level tax information and superannuation information. The data are combined with other administrative data from the Australian taxation system to determine additional classification attributes, such as the age and sex of employees.

The ABS would like to acknowledge the critical support from the Australian Taxation Office (ATO) in enabling the ABS to produce these statistics.

All paid employee jobs reported to the ATO through STP are in scope of these estimates.

An employee job is a relationship between an employed person and their employing enterprise, where the employee has received a payment in the reference week through STP-enabled software and reported to the ATO.

Owner managers of unincorporated enterprises are not included in these estimates as they are not in scope of STP-enabled software reporting to the ATO.

As at 6 April 2020, nationally approximately 99% of employers the ATO classifies as ‘substantial employers’ (those with 20 or more employees) were reporting through STP. Small employers (those with 19 or less employees) began transitioning to STP on 1 July 2019 and by 6 April 2020 approximately 71% were reporting through STP. As a result, not all jobs in the Australian labour market are captured within these estimates.

The estimates are considered experimental and use an index to provide an indication of movements in total jobs and total wages (rather than level estimates), for the purpose of assessing the economic impact of the COVID-19 coronavirus on employees.

For context, high level analysis suggests that there was approximately 650,000-700,000 fewer paid employee jobs in STP-enabled businesses between 14 March and 18 April 2020.

These estimates will be published fortnightly on Tuesdays during the COVID-19 coronavirus period. The timing has been optimised around when the largest proportion of both weekly and fortnightly payments are made (thereby minimising the contribution from imputation at the end point of the series).

These estimates have a 17 day time lag after the reference week. While estimates are published fortnightly, weekly data are available within the release.

These estimates are available the state and territory and national level. All geographic variables are based on the individual's residential address as stated on their income tax return. Where an address is not available from the income tax return the residential address as reported on the STP file is used.

Estimates are also provided for the 19 Australia and New Zealand Standard Industry Classification (ANZSIC) divisions. All industry variables are based on the ABS Statistical Business Register.

STP data is reported on a year-to-date cash accounting basis at the time the payment was provided to an employee rather than at the time the payment was earned. To produce indicative real time estimates of wages and jobs, the calendarisation method is used to convert STP data from a cash basis to an accrual basis.

The calendarisation method uses the start and end date of the payment period reported through STP to calculate the payment frequency, known as ‘periodicity’. A daily pay rate is then calculated by dividing the total payment by the total number of days in the payment periodicity. For example, a payment made weekly will be divided by seven to calculate a daily pay rate. Where the commencement or termination date for a job occurs within a payment period, the periodicity for that job is adjusted to exclude the days before commencement or after termination.

Payment data extracted from the STP system each week is always partially incomplete, given businesses have different payment frequencies. For example, a business with a fortnightly payroll will only provide STP data every second week. To produce reliable weekly statistics, an imputation method is used to account for differing reporting patterns.

If an employee has not yet had payment data reported and they have not been flagged for termination, it is assumed that their payment status is consistent with their previous reporting record. The previous calculated daily rate will be imputed for the current period.

As at 13 April 2020, the data indicates that 38% of employees are paid weekly; 47% are paid fortnightly; 11% paid monthly; 4% are paid quarterly or paid infrequently.

No imputation is required for employees paid weekly. Business reported data is included for all employees paid weekly due to the 17 day lag between the reference week and the release of estimates. Actual payments for most employees paid fortnightly and some employees paid monthly are also available.

Imputation is not applied for the small proportion of employees who are paid quarterly or infrequently as there is not an established pattern of payment to extrapolate forward.

No imputation is applied for new employees without historical payment information, until a pattern can be determined.

Once STP data is converted to an accrual basis using the calendarisation method and imputation is applied, the data is aggregated to produce the following weekly estimates:

• Total Paid Employee Jobs: The average of the 7 days of employee counts.
• Total Wages Paid: The sum of all daily rates for all jobs for the week. This is the total value of wages for the week.
• Average weekly wage by job: This is calculated by dividing the total wages value by the total employee jobs number.
   

The data underlying these estimates are revised for each release, and reflected in percentage change movements and indexes.

Revising underlying data across the time series allows the estimates to incorporate newly available business reported data and replace previously imputed data with actual data.

Care should be exercised in focusing on weekly movements in wages, which are subject to a higher degree of reporting variability and revisions.

The ABS and Northern Territory Treasury worked collaboratively to resolve an issue with reported wages in the Northern Territory for the week ending 14 March 2020, which has been revised as part of the release of data for the week ending 18 April 2020.

The ABS and the Tasmanian Treasury worked collaboratively to resolve an issue with reported employee jobs in Tasmania in the week ending 4 April 2020, which have been revised as part of the release of data for the week ending 18 April 2020.

The ABS will continue to work through wages reported in the Northern Territory and ACT over the coming weeks.

Improvements in the alignment of ANZSIC codes for businesses to those on the ABS Business Register has improved the quality of industry estimates, resulting in some revisions as part of the release of data for the week ending 18 April 2020.

The estimates are presented as an original series only. Seasonally adjusted and trend estimates are not yet available. A number of years of data will be required before seasonal patterns can be observed and adjusted for.

The calendarisation and imputation methodologies applied to the estimates account for calendar related variations, such as the number of days in a month, and different payment frequencies.

Note: All estimates presented in this publication are presented for weeks ending on a Saturday.

Estimates are produced for weekly change in the number of paid employee jobs, change in wages paid and change in average weekly wage by job. These estimates are available at the national, state and territory and ANZSIC division level by selected personal attributes, including sex and 10 year age groups. Estimates are presented as percentage change movements and indexes.

The estimates include indexes to present changes in the labour market during the COVID-19 coronavirus period.

In order to compare changes over time, the week Australia recorded its 100th confirmed coronavirus case (i.e. week ending 14th March 2020) is used as the reference period for constructing the indexes and given an index value of 100.0.

Index values relative to the reference period are updated in each release to reflect revisions to underlying data. Index values commencing week ending 4 January 2020 are available via Table 4 in the Data downloads section to support users to undertake additional longer time series analysis.

The indexes allow comparison between two points in time. The points in time can be adjacent (this week and the previous week) or many weeks apart. Movements in the index from one period to another can be expressed as either points or percentage change and these are rounded to one decimal place.

The following example illustrates the method of calculating changes in index points and percentage changes between any two periods:

These indexes differ from the ABS' suite of price indexes, including the Wage Price Index, which measure changes in price over time unaffected by quality or quantity and should not be directly compared.

An employee job is a relationship between an employed person and their employing enterprise, where the employee has received a payment in the reference week through STP-enabled software and reported to the ATO.

STP data does not include information on hours worked or hours paid for. Analysis of monthly hours worked can be found in Labour Force, Australia (cat. no. 6202.0) and the detailed releases (cat. no. 6291.0.55.001 and 6291.0.55.003). STP data are also unable to account for job attachment where a payment has not been made, where a jobholder was temporarily stood down without pay.

The estimates do not include information on the employment status of employees, i.e. full time or part time. This will be explored as part of ongoing work between the ABS and the ATO. In the interim, this information is also available within the suite of Labour Force releases.

Note: The gender information in the underlying data includes jobholders who were identified as a gender other than ‘male’ and ‘female’, or where no gender was specified. These data are not included in the calculation of male and female estimates but are included in all other calculations.

STP data is supplied by the ATO to the ABS under the Taxation Administration Act 1953, which requires that such data is only used for the purposes of administering the Census and Statistics Act 1905. Any discussion of data limitations or weaknesses is made within the context of using the data for statistical purposes, and is not related to the ability of the data to support the ATO's core operational requirements.

Legislative requirements to ensure privacy and secrecy of this data have been adhered to. In accordance with the Census and Statistics Act 1905, results have been confidentialised to ensure that they are not likely to enable identification of a particular person or organisation.

The ABS would like to acknowledge the critical support from the Australian Taxation Office (ATO) in enabling the ABS to produce these statistics.

Weekly Payroll Wages and Jobs in Australia provide weekly changes in the total number of employee jobs and total wages at the national, state and territory and ANZSIC industry level by selected personal attributes of jobholders, including sex and age group.

The estimates are compiled using Single Touch Payroll (STP) data provided to the Australian Taxation Office (ATO) by businesses with STP-enabled payroll or accounting software each time the business runs its payroll. As at 6 April 2020, approximately 99% of substantial employers (20 or more employees) and around 70% of small employers (those with 19 or less employees) are reporting through STP.

The STP data are reported on a cash basis (the time when the payment was made) rather than an accrual basis (the time when the payment was earned). Therefore to produce real time estimates of weekly jobs and earnings, the STP data need to be converted from a cash basis to as close to an accrual basis as possible, using a calendarisation method.

In addition to the cash reporting, the STP payment data that are extracted for a specific week cycle will be incomplete due to different payment and reporting frequencies. For example, a business that normally pays its employees on a fortnightly basis will not have any payment data available in every weekly STP dataset. To produce reliable statistics on a timely basis, an extrapolation imputation method is applied to account for these different payment and reporting habits.

The method includes the following steps:

• The periodicity, or payment frequency, is calculated using the start and end date of the payment period;
• A daily pay rate is then calculated by dividing the total payments by the payment frequency. For example, weekly pay is divided by seven;
• Where the start or termination date for a job occurs within the payment period, an adjustment is made to the periodicity for that job to exclude the days before commencement (or after termination).
   

This method allows the data to be aggregated and analysed for different reporting periodicities as all the records are broken down to a common frequency (daily).

The STP payment data that are extracted for a specific week cycle are always partially incomplete due to varying payment and reporting frequencies. For example, a business with a monthly payroll will only provide STP data every fourth week.

As at 13 April 2020, the data indicates that 38% of employees are paid weekly; 47% are paid fortnightly; 11% are paid monthly; 4% are paid quarterly or infrequently.

To produce reliable statistics on a weekly basis, an imputation method is used to account for differing reporting patterns, with revisions made when additional data become available.

If an employee has not yet had payment data reported and they have not been flagged for termination, it is assumed that their payment status is consistent with their previous reporting record. The previous calculated daily rate will be imputed for the current period.

No imputation is required for employees paid weekly. Business reported data is included for all employees paid weekly due to the 17-day lag between the reference week and the release of estimates. Actual payments for most employees paid fortnightly and some employees paid monthly are also available.

Imputation is not applied for the small proportion of employees who are paid quarterly or infrequently as there is not an established pattern of payment to extrapolate forward.

No imputation is applied for new employees without historical payment information, until a pattern can be determined. This means that there is an inherent and unavoidable lag before new employee jobs will appear in the data, after the initial pay period, particularly for new jobs with employers who have less frequent payment and reporting periods.

Once STP data is converted to an accrual basis using the calendarisation method and imputation is applied, the data is aggregated to produce the following weekly estimates:

• Total Employee Jobs: The average of the 7 days of employee job counts. An employee job is a relationship between an employed person and their employing enterprise, where the employee has received a payment in the reference week through STP-enabled software and reported to the ATO.
• Total Wages: The sum of all daily rates for all jobs for the week. This is the total value of wages for the week. For employees who work for the whole week in a specific job, the weekly wages are the sum of 7 days of the daily rate. For the employees who work partially for the whole week in a specific job (i.e. who just started the work or terminated the work during this period), the weekly wages are the sum of the actual periodicity for that job excluding the days before commencement (or after termination).
• Average weekly wage by job: This is calculated by dividing the total wages value by the total employee jobs number.
• These estimates are aggregated to the national, state and territory and ANZSIC division level by selected personal attributes, including sex and 10-year age groups.
   

The data underlying these estimates are revised for each release, and reflected in percentage change movements and indexes.

Revising underlying data across the time series allows the estimates to incorporate newly available business reported data and replace previously imputed data with actual data.

For more information on this methodology please email labour.statistics@abs.gov.au

The ABS has recently released experimental estimates of changes in paid employee jobs and changes in wages in Weekly Payroll Jobs and Wages in Australia. The estimates are compiled in near real time and published fortnightly, using Single Touch Payroll (STP) data provided to the Australian Taxation Office (ATO) by businesses with STP-enabled payroll or accounting software each time the business runs its payroll.

This information provides complementary insights to the Labour Force statistics on employment. However, while changes in paid employee jobs can provide an indication of changes in how employed the population is, it is important to remember that the measures are different.

The table below highlights key differences that should be considered when comparing changes in paid employee jobs with changes in employment.

For further information, please email labour.statistics@abs.gov.au