134 – Innovative Approaches to Administrative Records
Standardizing Time in Payroll Data Using Splines
Jack Lothian
Statistics New Zealand
Statistics New Zealand is in the midst of implementing its 2010-2020 Strategic Plan that will transform how the agency functions. The "administrative data first" philosophy is a critical component in the transformation process and the Business Payroll Tax (PAYE) data is an important input dataset for business and national accounts surveys. Standardized PAYE data can be used in sub-annual surveys to enhance survey data, improve editing and implement calibration. These processes could potentially reduce response burden and collection costs plus improve quality. However, the use of administrative data poses major challenges. The data covers a melange of varying and overlapping time intervals. We propose a calendarization method based on interpolating the cumulated flows with splines that provides data with standardization time intervals and short-term forecasts. The methodology improves the timeliness and quality of the PAYE data and increases the willingness of the survey programs to embrace tax data.